Semantic search
citation_inspection
1 row where hash_id = "4e497801e347d906"
This data as json, CSV (advanced)
***A responsible adult was not available to accompany APHIS Officials during the inspection process at 11:15am to 11:45am on 08/18/2015. Attempts to make contact with the licensee were done by knocking on the door, honking the vehicle horn, waiting in the driveway for 30 minutes, calling the licensee's phone number and leaving a voicemail. Additional Inspectors Niemann Jamilon, Supervisory Animal Care Specialist
| rowid | 15944 |
| desc | ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. |
| web_siteName | MELVIN & ESTHER ZIMMERMAN |
| kind | |
| Incident hash_id | 4e497801e347d906 |
| web_inspectionDate | 2015-08-18 |
| code | 2.126(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 18564.0 |
| pdf_customer_name | Esther Zimmerman |
| pdf_customer_addr | Melvin Zimmerman 11451 Hwy E Versailles, MO 65084 |
| customer_state | MO |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23503439-aphis-inspection-230151732120655 |
| 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);