Semantic search
citation_inspection
1 row where hash_id = "5dca06d0e0470ccc"
This data as json, CSV (advanced)
The male zebra has been separated into a smaller yard with access to the barn adjacent to the females. He has been reluctant to shift for any length of time into the barn according to staff. Subsequently, his yard has not been cleaned and there is a significant accumulation of feces. This level of accumulation does not allow him the ability to avoid standing in his feces throughout the yard. This area needs to be cleaned and excreta removed from the primary enclosure as often as necessary for the health of the zebra. Correct by: May 5, 2023 This inspection and exit interview were conducted with a facility representative. n
| rowid | 3324 |
| desc | Sanitation. |
| web_siteName | Utica Zoological Society |
| kind | |
| Incident hash_id | 5dca06d0e0470ccc |
| web_inspectionDate | 2023-05-02 |
| code | 3.131(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 78.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 2125.0 |
| pdf_customer_name | Utica Zoological Society |
| pdf_customer_addr | One Utica Zoo Way Utica, NY 13501 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23831751-aphis-inspection-ins-0000868326 |
| lat | 43.0794831 |
| lng | -75.2427859 |
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);