Semantic search

citations

1 row where hash_id = "00229f83658ee799"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
28435 00229f83658ee799 2.126(b)   0 ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. A responsible adult was not available to accompany APHIS Officials during the inspection process at 11:58AM on 27-Feb-20. Called licensee and confirmed licensee was out of business and no longer a resident at the listed property. She would like to cancel her license effective today 27FEB2020.

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