Semantic search

citations

1 row where hash_id = "3429a518bfbb9f38"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
6830 3429a518bfbb9f38 3.125(a)   0 FACILITIES, GENERAL. Metal structures in two enclosures were in disrepair. In one fox den a metal door, it's track, and a metal cage containing a heat lamp were rusted. The door also appeared to have paint chipping from the surface. The door into a raccoon den also appeared to be rusted with areas of chipped paint. Failure to maintain metal surfaces could lead to more extensive rust damage and the eventual compromise of the structural integrity of the item. Rusted and chipped surfaces are also difficult clean. The facility should ensure that defects in animal enclosures are identified and repaired in a timely manner. Correct by February 7, 2015. An exit briefing was conducted with a facility representative.

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