Semantic search
citation_inspection
1 row where hash_id = "53cb36a8c453f24e"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
*** The wallaby enclosure in the main building had an abundance of fruit flies in the enclosure around the animal and fruit on the ground. Although the facility has a fly trap near the diet prep area, it does not seem to be effective for this particular area of the building. This needs to be addressed for the health of the animal. Correct by: July 4, 2014 An exit briefing was conducted with the licensee at the time of the inspection.
| rowid | 3996 |
| desc | SANITATION. |
| web_siteName | JAROD MILLER |
| kind | |
| Incident hash_id | 53cb36a8c453f24e |
| web_inspectionDate | 2014-07-01 |
| code | 3.131(d) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 8.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 2390.0 |
| pdf_customer_name | Jarod Miller |
| pdf_customer_addr | Jarod Miller Productions Inc Wild Encounters Dba P O Box 244 North Boston, NY 14110 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23482635-aphis-inspection-182141435070181 |
| lat | 42.68672000000001 |
| lng | -78.778311 |
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);