Semantic search

citations

1 row where hash_id = "553396bb9bd960ea"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
3 553396bb9bd960ea 2.33(b)(2)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE. One expired bottle of Isoflourane (expiration date 20 Aug 2014) was found on a shelf in the procedure room. The procedure utilizing this anesthetic agent had been removed from the protocol in May 2017. Expired medications may have compromised efficacy and potency and use of such does not constitute adequate veterinary care. The institution needs to ensure that medications are not being used past their expiration date. Expired bottle was disposed of at the end of the inspection. This inspection and exit interview were conducted with facility representative.

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