Semantic search
citation_inspection
1 row where hash_id = "001f35c544deb035"
This data as json, CSV (advanced)
The enclosure housing two pigs has excessive wet, soiled straw. The area (approximately 2x3 ft in diameter) of wet, soiled straw is located on the left, front on the enclosure and adjacent to the pigs feeding container. Several flies were present on/in the soiled straw during the time of inspection. Soiled, wet bedding attracts flies and can cause animal illness. Remove and clean the affected area of the pig enclosure to minimize flies and promote animal health. To be corrected: 9-23-16 This inspection and exit interview were conducted with the employee.
| rowid | 18402 |
| desc | SANITATION. |
| web_siteName | EDWARDS APPLE ORCHARD INC |
| kind | |
| Incident hash_id | 001f35c544deb035 |
| web_inspectionDate | 2016-09-21 |
| code | 3.131(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 22.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 29207.0 |
| pdf_customer_name | Edwards Apple Orchard Inc |
| pdf_customer_addr | 7061 Centerville Road Poplar Grove, IL 61065 |
| customer_state | IL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23509458-aphis-inspection-2016082567933929 |
| 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);