Semantic search

citations

2 rows where hash_id = "51bfe575a07deea8"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
28919 51bfe575a07deea8 2.40(a)(1)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). The Program of Veterinary Care: The written program needs more detail in the following areas: (cid:28)The Parasite Control Program: describe the frequency of sampling or treatment.(cid:29), (cid:28)Emergency Care(cid:29) (more detail needed on who provide emergency care if the attending veterinarian is unavailable), and (cid:28)Method of Euthanasia(cid:29) (more detail would include route, dose, product). This information is important so that the preventative medicine program established and implemented help insure that the animals are maintained in good health. It is important that the written Program of Veterinary Care is updated periodically, or whenever there is a new species obtained, or when other veterinary health changes occur. ************** To be corrected by: 9/20/2014
28920 51bfe575a07deea8 3.84(a)   0 CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. Both capuchin enclosures - resting platforms also used for feeding: This area has an accumulation of hair, and food waste trapped at the edge of platform and wire mesh of the cage. Food waste must be removed from inside each primary enclosure daily. Perches, bars, and shelves must be kept clean and replaced when worn to prevent the nonhuman primates from becoming soiled. A system is to be implemented to ensure adequate cleaning. To be corrected by: September 5, 2014 Exit interview conducted with facility personnel. Additional Inspectors Drlica Steve, 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
);