Semantic search

citations

1 row where hash_id = "d694b56d7f596db1"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
21191 d694b56d7f596db1 3.127(a)   0 FACILITIES, OUTDOOR. Shelter from sunlight. The amount of shade provided by the existing shelter was not large enough to accommodate all 15 reindeer at one time. As a result all reindeer do not have shelter from sunlight simultaneously. Failure to provide adequate protection from direct sunlight, may not allow the animals to maintain body temperature, which could lead to overheating or more serious health concerns. Provide enough shaded areas to accommodate all animals housed in the enclosure. Licensee provided a plan for permanent additional shade, however, temporary shade solution must be provided until permanent plan is implemented. Correct by 06/11/14. Inspection and exit interview were done with the Zoo Director. Additional Inspectors Maxwell Kelly, Animal Care Inspector

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