Semantic search

citations

1 row where hash_id = "0029942204809e6f"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
30549 0029942204809e6f 2.40(b)(2)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). There were two unopened vials of Etorphine HCL. This medication was compounded into a sterile water vial. The label on the sterile water indicated that it was not yet expired, but the pharmacy compounding label indicated that the active ingredient expired in 2/2014. There were also three unopened bottles of Naltrexone that were compounded into similar vials of sterile water. While the on the sterile water also indicated that it was not expired, the pharmacy compounding label indicated that the active ingredient expired on 5/21/2014. Expired medications are considered adulterated, and is not considered an appropriate method to treat diseases or reduce/alleviate pain. Correct immediately. An exit interview was conducted with the facility representative. Additional Inspectors Brandes Robert, 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
);