Semantic search

citations

1 row where hash_id = "e37a90eea360bb3e"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
14799 e37a90eea360bb3e 2.126(b)   0 ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. * A facility representative was not available on 1/5/16 at 4:30 PM to do a facility inspection. * Inspector knocked on the front door of the licensees house. Inspector called telephone numbers given by the licensee. Per phone conservation, licensee stated that they had a prior commitment and would not be available to do a facility inspection. * Copy of inspection report was sent by regular mail. Additional Inspectors Shaver Margaret, 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
);