Semantic search

citations

1 row where hash_id = "0011c69cf5e961f4"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
11905 0011c69cf5e961f4 3.125(a) Critical 0 FACILITIES, GENERAL. 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

Advanced export

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

CSV options: 

CREATE TABLE "citations" (
   [rowid] INTEGER PRIMARY KEY,
   [hash_id] TEXT REFERENCES [inspections]([hash_id]),
   [code] TEXT,
   [kind] TEXT,
   [repeat] INTEGER,
   [desc] TEXT,
   [narrative] TEXT
);