Semantic search

citations

2 rows where hash_id = "6c4a2e93d40d4b13"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
30739 6c4a2e93d40d4b13 3.125(a)   0 FACILITIES, GENERAL. There are several areas at the bottom of the cougar enclosure where the weathered wood is damaged. This damaged wood needs to be replaced with wood or other suitable material. Outdoor housing facilities shall be structurally sound and shall be maintained in good repair to protect the animals from injury and to contain the animals. TO BE CORRECTED BY: AUGUST 28, 2015.
30740 6c4a2e93d40d4b13 3.125(c)   0 FACILITIES, GENERAL. (1) There were several bags of raw chicken being thawed outdsite out on the ground. I observed numerous ants around the bags of this raw chicken. (2) The temperature gauge on the freezer was a 32F, and when inspecting the freezer the temperature raises to 40F. Although the meat in the freezer is frozen, appliances need to be at the proper temperatures to prevent spoilage. Meats should be refrigerated and thawed at temperatures at or below 40° F (4° C), and the freezer temperature should be 0° F (-18° C). Supplies of food and bedding shall be stored in facilities which adequately protect such supplies against deterioration, molding, or contamination by vermin. Refrigeration shall be provided for supplies of perishable food. TO BE CORRECTED BY: IMMEDIATELY The exit interview was conducted with the care taker of animals.

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