Semantic search

citations

1 row where hash_id = "f9b36cb6b7c38469"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
16323 f9b36cb6b7c38469 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 9:45am to 10:15am on 10/06/2015. Attempts to make contact with the licensee were done by ringing the doorbell, honking the vehicle horn, waiting in the driveway for 30 minutes, calling the licensee's phone numbers and leaving voicemails.

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