Semantic search

citations

3 rows where hash_id = "70f2b6df16a76c73"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
28293 70f2b6df16a76c73 3.2(a)   0 INDOOR HOUSING FACILITIES. *** The puppy room was 87.4 degree F according to the handheld kestrel reader. The windows were open but there was no fan running and no method available to sufficiently cool the room down. This needs to be addressed for the health of the animals. Correct by: June 21, 2014
28294 70f2b6df16a76c73 3.2(d)   0 INDOOR HOUSING FACILITIES. The walls in the puppy room have paint that is chipping and flaking off. The wall needs to have a fresh coat of paint to keep the room impervious to moisture and so the room can be effectively cleaned and sanitized. Correct by: July 18, 2014
28295 70f2b6df16a76c73 3.11(b)(2)   0 CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. *** A few of the whelping boxes had an accumulation of dirt and debris along the walls. These boxes need to be cleaned more often between the routine sanitization cleanings to prevent this accumulation. This needs to be addressed for the health of the dogs. Correct by: June 23, 2014 An exit briefing was done 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
);