Semantic search

citations

1 row where hash_id = "96bfdcebafa8ecec"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
25241 96bfdcebafa8ecec 2.33(a)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE. A covered species was not included in the approved written Program of Veterinary Care (PVC). All covered species should be addressed in the PVC to ensure the facility has a program to follow concerning the care of all the animals. Failure to do so could adversely affect the health and well-being of the animals. A complete and accurate written Program of Veterinary Care with consultation from the attending veterinarian must be in place. Correct by 02/27/2015 Exit interview conducted with facility representatives. Additional Inspectors Lee Jeffrey, 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
);