Semantic search

citations

1 row where hash_id = "7e241113ceab751d"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
156 7e241113ceab751d 3.125(a) Critical 0 FACILITIES, GENERAL. During a study involving ferrets, one ferret was entrapped by a perch and subsequently died. The facility determined that the cause of death was related to effects of the entrapment. The housing facility should be constructed such that it would protect the animals from injury. As a corrective action, the facility removed all of the perches from the ferret primary enclosures. Corrected prior to this inspection. This inspection and exit interview were conducted with facility representatives. Additional Inspectors Nooyen Amy, 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
);