Semantic search

citations

1 row where hash_id = "53cb36a8c453f24e"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
3996 53cb36a8c453f24e 3.131(d)   0 SANITATION. *** The wallaby enclosure in the main building had an abundance of fruit flies in the enclosure around the animal and fruit on the ground. Although the facility has a fly trap near the diet prep area, it does not seem to be effective for this particular area of the building. This needs to be addressed for the health of the animal. Correct by: July 4, 2014 An exit briefing was conducted with the licensee at the time of the inspection.

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