Semantic search
citation_inspection
1 row where hash_id = "002eedd164700d29"
This data as json, CSV (advanced)
A responsible adult was not available to accompany APHIS Officials during the inspection process at 2:50 pm on 16-Oct-17. At approximately 2:50 pm I left a voice message for the licensee. He called back right away. He was away from the facility having a truck repaired and there was no other authorized person available. The licensee was surprised that I was arriving so late in the day because historically inspectors have always arrived in the mornings or by early afternoon so he tends to do errands later in the day. Optimal hours were discussed.
| rowid | 23866 |
| desc | ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. |
| web_siteName | MICANOPY ZOOLOGICAL PRESERVE |
| kind | |
| Incident hash_id | 002eedd164700d29 |
| web_inspectionDate | 2017-10-16 |
| code | 2.126(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 45249.0 |
| pdf_customer_name | Micanopy Zoological Preserve |
| pdf_customer_addr | 19350 N W 123 Court Micanopy, FL 32667 |
| customer_state | FL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23520766-aphis-inspection-2016082568890028 |
| 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);