Semantic search

citations

1 row where hash_id = "4e497801e347d906"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
15944 4e497801e347d906 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:15am to 11:45am on 08/18/2015. Attempts to make contact with the licensee were done by knocking on the door, honking the vehicle horn, waiting in the driveway for 30 minutes, calling the licensee's phone number and leaving a voicemail. Additional Inspectors Niemann Jamilon, Supervisory Animal Care Specialist

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