Semantic search
citation_inspection
1 row where hash_id = "513b4d781a5f41f0"
This data as json, CSV (advanced)
A responsible adult was not available to accompany APHIS Officials during the inspection process at 11:00 on 21-SEP-16. The licensee's father indicated that the licensee and his wife were both out for the day and there was no knowledgeable representative to accompany inspection. Lack of availability renders the inspection process impossible. The licensee must ensure that a knowledgeable adult is available to accompany inspection during regular business hours.
| rowid | 26101 |
| desc | ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. |
| web_siteName | DENNIS D YODER |
| kind | |
| Incident hash_id | 513b4d781a5f41f0 |
| web_inspectionDate | 2016-09-21 |
| code | 2.126(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | |
| web_certType | Class A - Breeder |
| pdf_customer_id | 324402.0 |
| pdf_customer_name | Dennis D Yoder |
| pdf_customer_addr | 2490 Township Road 151 Millersburg, OH 44654 |
| customer_state | OH |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23524879-aphis-inspection-2016082567932935 |
| 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);