Semantic search
citation_inspection
1 row where hash_id = "e90a81cba5e26d0f"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
There is one enclosure in the breeding stock area that has an area where the coated wire is broken. The section of damaged wire is along the bottom right of the enclosure next to the food receptacle. The pointed edge of the wire is facing inside the enclosure affecting one dog. This can create a hazardous situation for the dog. This must be repaired or replaced in a manner that eliminates the bent and broken wires and protects the dog from injury. To be corrected by July 24, 2014. Exit interview conducted with facility representative.
| rowid | 20093 |
| desc | PRIMARY ENCLOSURES. |
| web_siteName | LAVERN NOLT |
| kind | |
| Incident hash_id | e90a81cba5e26d0f |
| web_inspectionDate | 2014-07-22 |
| code | 3.6(a)(2)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 142.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 34444.0 |
| pdf_customer_name | Lavern Nolt |
| pdf_customer_addr | 1276 140 St Charles City, IA 50616 |
| customer_state | IA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23512962-aphis-inspection-203141615500035 |
| 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);