Semantic search
citation_inspection
1 row where hash_id = "498e0efc3a0b5d09"
This data as json, CSV (advanced)
The three camel stalls in the barn are in disrepair. The wood around two of the stalls is damaged or missing in several areas. Additionally, no fewer than four sections of metal tube fencing that comprise these stalls are in disrepair. The fencing has been bent and damaged by the camels. The damaged wood and bent fencing are potential hazards to the camels. Assure that the camels are housed in enclosures that are maintained in good repair to prevent potential injury. To be corrected: 9-15-14 A verbal inspection exit briefing was conducted with the facility owner. The inspection report was sent by email.
| rowid | 21917 |
| desc | FACILITIES, GENERAL. |
| web_siteName | ANDREAS GEORGIADES |
| kind | |
| Incident hash_id | 498e0efc3a0b5d09 |
| web_inspectionDate | 2014-08-14 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 42.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 40620.0 |
| pdf_customer_name | Andreas Georgiades |
| pdf_customer_addr | P O Box 123 Huntley, IL 60142 |
| customer_state | IL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23516957-aphis-inspection-227141336542276 |
| 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);