Semantic search
citation_inspection
1 row where hash_id = "0011c69cf5e961f4"
This data as json, CSV (advanced)
An unforeseen accident caused the death of a bobcat on 8-2-17. The zoo director stated the young bobcat was able to climb out of its enclosure and a young Siberian lynx being fed in its vicinity attacked it before the person supervising the animals could separate them. The bobcat enclosure did not adequately contain it to protect it from the lynx. The facility described reasonable steps to be taken prior to housing young bobcats. All animals must be housed in enclosures that prevent their escape. To be corrected: From this day forward This inspection and exit interview were conducted with the facility president. Additional Inspectors Welch Scott, Veterinary Medical Officer
| rowid | 11905 |
| desc | FACILITIES, GENERAL. |
| web_siteName | DeLavan Lake Animal Park |
| kind | Critical |
| Incident hash_id | 0011c69cf5e961f4 |
| web_inspectionDate | 2017-08-31 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 81.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 7752.0 |
| pdf_customer_name | Exotic Enterprises Inc |
| pdf_customer_addr | 5065 Highway 50 Delavan, WI 53115 |
| customer_state | WI |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23495476-aphis-inspection-2016082568770689 |
| 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);