Semantic search

citations

1 row where hash_id = "b8673d77ab228287"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
21733 b8673d77ab228287 3.56(a)   0 SANITATION. *** The rabbit cages have an excess accumulation of excreta and there is a noticeable ammonia odor in the room. For the health and comfort of the animals this situation should be corrected. Correct immediately. An exit interview was conducted with the licensee on 8/20/2014

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