Semantic search
citation_inspection
1 row where hash_id = "79b96568ddb5329d"
This data as json, CSV (advanced)
Cleaning and sanitation of primary enclosures.There is a buildup of brown roughened scale and debris on the plastic sides and floor of the guinea pig enclosures. The buildup of scale and debris exposes the guinea pigs to potential infections with bacteria, fungi, and parasites. Correct by ensuring that all primary enclosures are clean and sanitized often enough to prevent an accumulation of scale and debris. Additionally, ensure that the primary enclosures are sanitized at least once every two weeks. Correct by October 22, 2016. This inspection and exit interview were conducted with the owner.
| rowid | 27151 |
| desc | SANITATION. |
| web_siteName | LESTER HOOVER |
| kind | |
| Incident hash_id | 79b96568ddb5329d |
| web_inspectionDate | 2016-10-12 |
| code | 3.31(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 108.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 325840.0 |
| pdf_customer_name | Lester Hoover |
| pdf_customer_addr | 379 North Hershey Ave Leola, PA 17540 |
| customer_state | PA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23526721-aphis-inspection-2016082567958275 |
| 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);