Semantic search

citations

3 rows where hash_id = "a81faf0cae26ffe1"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: desc

rowid ▼ hash_id code kind repeat desc narrative
7569 a81faf0cae26ffe1 3.83   0 WATERING. Inside the Mandrill enclosure, the watering receptacle in this enclosure has an excess of green material covering the inside and along the edges of the watering receptacle. Dirty water may harbor disease hazards which may pose a health risk for the animals. All water receptacles shall be kept clean and sanitary. Corrected at the time of inspection.
7570 a81faf0cae26ffe1 3.84(d)   0 CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. Inside of the indoor portion of the Orangutan sheltered enclosure, there is an excessive amount of rat feces inside the enclosure. Evidence of rat feces is an indicator of an ineffective pest control program. Rat droppings can harbor disease causing organisms and could cause potential contamination in animal areas. The licensee should ensure an effective pest control program is in place to control pests and reduce potential contamination. To be corrected by February 25, 2015.
7571 a81faf0cae26ffe1 3.130   0 WATERING. Inside the Serval enclosure , the watering receptacle in this enclosure has an excess of green material covering the inside of the watering receptacle. Dirty water may harbor disease hazards which may pose a health risk for the animals. All water receptacles shall be kept clean and sanitary. Corrected at the time of inspection. Inspection and exit interview conducted by APHIS personnel with 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
);