Semantic search
citation_inspection
1 row where hash_id = "d35d86afecd24c43"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
Housekeeping. There are accumulations of cobwebs, dust, and debris on the ceiling, walls, racks and wire surfaces. The floor contains spilled feed, shavings, and debris. Animal facilities must be kept clean to ensure the health and well-being of the animals. Ineffective cleaning exposes the animals to disease hazards and health problems. Correct by ensuring the premises are kept clean. Correct by June 20, 2014 An exit breifing was conducted with owner.
| rowid | 27946 |
| desc | SANITATION. |
| web_siteName | AMOS BEILER |
| kind | |
| Incident hash_id | d35d86afecd24c43 |
| web_inspectionDate | 2014-06-17 |
| code | 3.31(b) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 223.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 326894.0 |
| pdf_customer_name | Amos S Beiler |
| pdf_customer_addr | 140 S Maple Ave Leola, PA 17540 |
| customer_state | PA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23528342-aphis-inspection-156141006263024 |
| 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);