Semantic search

citations

1 row where hash_id = "8d85d9f809c640c4"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
11995 8d85d9f809c640c4 2.10(c)   1 LICENSEES WHOSE LICENSES HAVE BEEN SUSPENDED OR REVOKED. ***Three tigers were being exhibited to the public by a person (CID# 7860) whose USDA license has been revoked. The individual stated to the APHIS VMO's that he gives talks and presentations about the tigers, to the public while standing in front of and around the enclosure housing the tigers. Any person whose license has been revoked is not allowed to exhibit, transport, deliver for transportation, buy, or sell any animal. Additional Inspectors Heezen Dee, 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
);