Semantic search

citations

2 rows where hash_id = "dfcab2fa02827e58"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
21844 dfcab2fa02827e58 3.80(a)(1)   0 PRIMARY ENCLOSURES. The following items are in need of repair or replacement: 1. The wooden trim along the right side of the viewing window has been chewed by the non-human primates. The chewed wooden trim must be replaced to protect the animals from injury and to maintain the window in good repair. 2. One of the fluorescent light fixtures, in the non-human primate enclosure, has detached from the ceiling and is no longer adequately secured. This dangling fixture must be repaired and adequately secured to prevent the fixture from falling and causing injury to the non-human primates housed therein. The above items must be repaired and/or replaced to ensure that the non-human primates are not harmed or injured.
21845 dfcab2fa02827e58 3.84(c)   0 CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. An accumulation of soiled shavings is present on the inside of the clear, plastic cover that protects the dials of an old heating unit. This accumulation must be removed to prevent odors and/or disease hazards within the non-human primate enclosure. ALL OF THE ABOVE ITEMS MUST BE CORRECTED BY: SEPTEMBER 16, 2014 The exit briefing was conducted with the 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
);