Semantic search

citations

1 row where hash_id = "e8b2752177792440"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
19834 e8b2752177792440 2.75(a)(1)(6)   0 RECORDS: DEALERS AND EXHIBITORS. *** On the required records of animals on hand (form 7005) there were 21 dogs listed with their information but no formal identifying tag or microchip number. The licensee states the dogs are micro-chipped but has not entered the information into the records. These numbers need to be entered into the records in a timely and accurate manner for recordkeeping purposes. Correct by: Feb 21, 2015 An exit briefing was conducted with the licensee at the time of the inspection.

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