Semantic search

citations

1 row where hash_id = "a7017e38449e2998"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
20670 a7017e38449e2998 2.40(a)(1)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). Although the licensee has written out the veterinary care she provides her opossum, she has not had it reviewed and approved by an Attending Veterinarian. The written Program of Veterinary Care needs to be completed and approved by the attending veterinarian. This is a pre-use new site inspection for this organization. The above item needs to be corrected and submitted for review by USDA before any licensed activity occurs. Exit briefing conducted with licensee 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
);