home / aphis_reports

Semantic search

citations

2 rows where hash_id = "a6e20eb58461850f"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
25226 a6e20eb58461850f 2.40(b)   1 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). In the kennel facility there are three adult English Bulldogs which needs to be evaluated by the attending veterinarian. One animal is an adult male named Fraizer, chip #0A02014642, who has green matter surrounding his right eye. Dana is an adult female chip # 0A01565253, who gas green drainage from both eyes and her nose. Jea is an adult female chip# 941000013167750 who has an enlarged gland on her left eye with green matter. The dealer did not have any written documentation of the animals receiving any treatment or communications with the attending veterinarian. The animals must be evaluated by the attending veterinarian. The dealer must maintain written documentation of the evaluation and all treatment to protect their health and welfare. Affects three adults
25227 a6e20eb58461850f 3.11(c)   1 CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. The kennel consists of one sheltered building which is divided into two areas. In the adult housing area there is an accumulation of spider webs with dead insects on the windows and walls. There is spilt food in the enclosures and central walk way floor. There are accumulations of flies through out the building including the empty enclosures. The dealer does have a fly bait jar which is half full. Premises where housing facilities are located, including buildings and surrounding grounds, must be kept clean and in good repair to protect the animals from injury, to facilitate husbandry practices, and to reduce or eliminate breeding and living areas for rodents and other pests and to protect the health and well-being of the animals. Affects Thirty-three adults The inspection and exit briefing was conducted with the Dealer. Additional Inspectors Cooper Natalie, Veterinary Medical Officer

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