Semantic search
citation_inspection
1 row where hash_id = "d16a9bd812feaca9"
This data as json, CSV (advanced)
A responsible adult was not available to accompany APHIS Officials during the inspection process at approximately 12:30 pm on 10/20/2015. The inspector sat at the facility gate for half an hour upon arriving at the facility. Two contact numbers were called and the vehicle horn was honked in an attempt to contact the license holder. All attempts were unsuccessful. A responsible person shall be available to accompany inspection during business hours. Note: This inspection report was sent by certified mail.
| rowid | 31905 |
| desc | ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. |
| web_siteName | HENRY FAMILY FARMS LLC |
| kind | |
| Incident hash_id | d16a9bd812feaca9 |
| web_inspectionDate | 2015-10-20 |
| code | 2.126(b) |
| repeat | 1 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 331560.0 |
| pdf_customer_name | Henry Family Farms Llc |
| pdf_customer_addr | P O Box 533 Somonauk, IL 60552 |
| customer_state | IL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23536959-aphis-inspection-294151040360952 |
| 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);