home / aphis_reports

Semantic search

citations

3 rows where hash_id = "85d41b8e6ca65514"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
26936 85d41b8e6ca65514 3.3(e)(1)(2)   0 SHELTERED HOUSING FACILITIES. The large pens used during the day to display the puppies for sale are on concrete under a shelter roof. These pens are not exposed to direct sunlight and the concrete flooring is not impervious to moisture. Surfaces that are not sealed cannot be adequately sanitized which may permit the growth of bacteria and may allow the spread of disease. All hard surfaces that the puppies may come in contact with that are not exposed to direct sunlight shall be made impervious to moisture. Correct by July 21, 2015.
26937 85d41b8e6ca65514 3.80(a)(2)(1)   0 PRIMARY ENCLOSURES. On the outdoor enclosure constructed for the lemur, there are sharp points remaining where the wire fence material was cut and joined to cover the top of the enclosure. These points are accessible to the lemur and may cause puncture wounds or other injury upon contact. All sharp points (wire, nails, etc) shall be removed or covered to protect the lemur from injury. Correct by July 7, 2015.
26938 85d41b8e6ca65514 3.127(a)   0 FACILITIES, OUTDOOR. There is very little shade provided for the Patagonian Cavy ("Roo"). The structure constructed to provide shade for "Roo) is very narrow and provides limited shade. There are no naturally shaded areas in this enclosure. Shade is required to protect the animals from overheating and discomfort. Additional shade shall be provided. Correct by July 7, 2015. Inspection and exit briefing conducted with the owner.

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 1736.626ms