Semantic search

citation_inspection

Table actions

1 row where hash_id = "95b50f60687b127b"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

On 13 May 2018, according to the paperwork for American Airlines Waybills 06761646 and 06761300 the intermediate handler accepted shipments of kittens where the age on the Health Certificates (dated 11 May 18) is only 7 weeks old. No cat shall be accepted by any intermediate handler or carrier for transportation in commerce unless such cat is 8 weeks of age and has been weaned. Per this regulation, all dogs and cats transported in commerce must be at least 8 weeks of age and fully weaned. This facility must take steps to assure that future acceptance of all dogs are at the minimum age for the health and safety of the animals. Correct from this day forward. This inspection and exit interview were conducted with facility representatives.

rowid 36
desc MINIMUM AGE REQUIREMENTS.
web_siteName GENERAL AVIATION TERMINAL, INC.
kind  
Incident hash_id 95b50f60687b127b
web_inspectionDate 2018-08-15
code 2.130
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 0.0
web_certType Class H - Intermediate Handler
pdf_customer_id 31.0
pdf_customer_name General Aviation Terminal Inc
pdf_customer_addr 8400 Airport Blvd West Ramp Rd Mobile, AL 36608
customer_state AL
pdf_site_id SAN
doccloud_url https://www.documentcloud.org/documents/23470299-aphis-inspection-2016082569245802
lat 30.6800208
lng -88.24911399999999

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "citation_inspection" (
   [rowid] INTEGER PRIMARY KEY,
   [narrative] TEXT,
   [desc] TEXT,
   [web_siteName] TEXT,
   [kind] TEXT,
   [hash_id] TEXT REFERENCES [inspections]([hash_id]),
   [web_inspectionDate] TEXT,
   [code] TEXT,
   [repeat] INTEGER,
   [pdf_insp_type] TEXT,
   [pdf_animals_total] FLOAT,
   [web_certType] TEXT,
   [pdf_customer_id] FLOAT,
   [pdf_customer_name] TEXT,
   [pdf_customer_addr] TEXT,
   [customer_state] TEXT,
   [pdf_site_id] TEXT,
   [doccloud_url] TEXT
, lat double precision, lng double precision);