home / aphis_reports

Semantic search

citations

4 rows where hash_id = "d7c8816cd12001f1"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
28691 d7c8816cd12001f1 3.1(e)   0 HOUSING FACILITIES, GENERAL. *** There were two open bags of food being stored on the ground in the sheltered building. Per this regulation, all open supplies of food must be kept in leak proof container with tightly fitting lids to prevent contamination and spoilage. This needs to be addressed for the health of the dogs. Correct by: Jan 24, 2015
28692 d7c8816cd12001f1 3.11(a)   0 CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. *** There was an accumulation of feces on the wire mesh that is not falling through in the outside runs of the sheltered building. The licensee's have not been cleaning the area due to cold weather. This area needs to be cleaned on a daily basis to prevent the dogs from becoming soiled. In addition the area underneath the mesh had an accumulation of feces and a very strong odor was all around the area. Correct by: Jan 23, 2015
28693 d7c8816cd12001f1 3.11(b)(2)   1 CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. *** Many of the feeders had a layer of grime and debris underneath the lip of the feeder and a layer of dust on top of the feeders. The feeders were last cleaned 3 weeks ago according to records. Per these regulations, the feeders need to be cleaned at least once every two 2 weeks to prevent this buildup of grime for the health of the dogs.
28694 d7c8816cd12001f1 3.11(c)   1 CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. *** There was a lot of clutter in the sheltered building with nails and dust on the window ledges, there were excess bags and items in and around the sink area and excess items in empty enclosures. These items need to be discarded and the building kept clean to promote good housekeeping practices. An exit briefing was conducted 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
);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 1929.681ms