Semantic search
citation_inspection
2 rows where hash_id = "b9df746ac1f615ee"
This data as json, CSV (advanced)
*** The main primate building has green algae growing on the ceiling above the enclosures. This is due to cleaning and moisture condensation staying on the ceiling. This algae growth would indicate that there is not enough auxiliary ventilation to reduce the humidity in the building which could become a health concern for the animals. This needs to be addressed for the health of the animals. Correct by: Oct 30, 2014
| rowid | 3300 |
| desc | INDOOR HOUSING FACILITIES. |
| web_siteName | Utica Zoological Society |
| kind | |
| Incident hash_id | b9df746ac1f615ee |
| web_inspectionDate | 2014-09-09 |
| code | 3.76(b) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 97.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/23481563-aphis-inspection-254140826490499 |
| lat | 43.0794831 |
| lng | -75.2427859 |
*** A sea lion pup died after he got his head stuck in a plastic toy on exhibit. Although the toy was approved for adult sea lions, these same toys need to be reassessed with younger animals to prevent injury. This needs to be addressed with all adult approved enrichment items for the safety of the new pup currently at the facility. Correct by: Sept 16, 2014 An exit briefing was conducted with a facility representative at the time of the inspection.
| rowid | 3301 |
| desc | FACILITIES, GENERAL. |
| web_siteName | Utica Zoological Society |
| kind | |
| Incident hash_id | b9df746ac1f615ee |
| web_inspectionDate | 2014-09-09 |
| code | 3.101(g) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 97.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/23481563-aphis-inspection-254140826490499 |
| 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);