home / aphis_reports

Semantic search

citations

2 rows where hash_id = "abd83017682d7a9f"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
15623 abd83017682d7a9f 2.40(b)(2) Direct 0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). * Three dogs (Female chihauhau # 0A01485761, male Yorkshire Terrier # 0A01451779, male Maltese # 101-892-341) all had excessively long toenails that curved around or splayed out to the side and did not allow the dog to stand in a normal manner. Licensee must trim these toenails and ensure that a maintenance program is established and adhered to with regard to toenail trimming. ** To be corrected by: 6/20/14
15624 abd83017682d7a9f 3.11(b)(2)   0 CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. (2) Used primary enclosures and food and water receptacles for dogs and cats must be sanitized at least once every 2 weeks using one of the methods prescribed in paragraph (b)(3) of this section, and more often if necessary to prevent an accumulation of dirt, debris, food waste, excreta, and other disease hazards. * All the enclosures in the two buildings, had a build up of dirt/grime, dust, and cobwebs on the walls, doors and surrounding interior edges of the enclosures.This type of build up can harbor disease hazards, cause soiling of the dogs and does not allow for proper sanitization to occur. Licensee must clean these areas as often as necessary to prevent any type of build up and to allow for sanitization to occur at least once every two weeks to minimize disease hazards. ** To be corrected by: 7/1/14 Inspection and exit interview conducted 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
);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 1285.275ms