Semantic search

citations

1 row where hash_id = "3648683610b754ea"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
14953 3648683610b754ea 3.4(b)(4)   0 OUTDOOR HOUSING FACILITIES. The dogs in the outdoor facility did not have adequate bedding. The ambient temperature at the time of the inspection was 40 degrees F with temperatures falling below 35 degrees F at night. The shelters had a small amount of hay, but not enough for the temperatures that the dogs were being exposed to. Adequate clean, dry bedding is necessary to protect the dogs so that they are not in discomfort or at risk for temperature-related health problems. The licensee must ensure that each dog has access to a shelter with bedding when the ambient temperature falls below 50 degrees and must provide additional bedding when the temperature is 35 degrees F or lower. TO BE CORRECTED JANUARY 05, 2016. The inspection and the exit briefing were conducted with the licensee.

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