Semantic search

citation_inspection

Table actions

1 row where hash_id = "ea4cf26ac554f5be"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: web_inspectionDate (date)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

During inspection, the outdoor enclosures for one male Grevy'(cid:25)s zebra, two Dexter cows, and six Jacob(cid:25)s Four-Horned sheep had multiple areas of loose sharp metal wires. Most of the loose wires were from 2 in. by 2 in. metal fencing used to patch holes in the main fencing and gates. The wires ranged from being a quarter inch in length to several inches and most were sharp to the touch. The wires are not only sharp which can injury the animal(cid:25)'s mouth and skin but can also be possibly ingested. Additionally, the loose fence wires do not provide a structurally sound enclosure. The housing facilities must be in good repair to protect the animals from injury and to contain the animals. Corrected at time of inspection Inspection was conducted with the Curator of Mammals, and the exit interview was conducted with the Zoo Director, Attending Veterinarian, Director of Animal Collections, Curator of Mammals, and Curator of Primates. Additional Inspectors Arango Juan, Permit Specialist

rowid 3497
desc FACILITIES, GENERAL.
web_siteName ZOOLOGICAL SOCIETY OF CINCINNATI
kind  
Incident hash_id ea4cf26ac554f5be
web_inspectionDate 2014-06-17
code 3.125(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 18.0
web_certType Class C - Exhibitor
pdf_customer_id 2208.0
pdf_customer_name Zoological Society Of Cincinnati
pdf_customer_addr 3400 Vine Street Cincinnati, OH 45220
customer_state OH
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23481803-aphis-inspection-169142033510224
lat 39.1433087
lng -84.5090245

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);