Semantic search
citation_inspection
1 row where hash_id = "36e24ad7304db5f4"
This data as json, CSV (advanced)
On June 2, 2014, an Air Canada employee accepted a female goldendoodle puppy in Toronto, Canada and shipped the puppy to Philadelphia International Airport (air waybill # 014-01295125). The puppy was born on April 8, 2014, and was only 55 days of age at time of shipment. Puppies must be at least 8 weeks of age for shipping to make sure they are properly weaned, vaccinated, and fit for transportation. No carrier or intermediate handler shall transport a puppy or kitten unless it is at least 8 weeks of age or 56 days old in commerce. An exit briefing was conducted with the manager on duty.
| rowid | 17675 |
| desc | MINIMUM AGE REQUIREMENTS. |
| web_siteName | AIR CANADA PHILADELPHIA |
| kind | |
| Incident hash_id | 36e24ad7304db5f4 |
| web_inspectionDate | 2014-06-04 |
| code | 2.130 |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class T - Carrier |
| pdf_customer_id | 26177.0 |
| pdf_customer_name | Air Canada |
| pdf_customer_addr | P O Box 66085 A M F 515 Express Center Dr, Unit B Chicago, IL 60666 |
| customer_state | IL |
| pdf_site_id | PHL |
| doccloud_url | https://www.documentcloud.org/documents/23507296-aphis-inspection-153141339356750 |
| lat | |
| lng |
Advanced export
JSON shape: default, array, newline-delimited, object
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);