home / aphis_reports

Semantic search

citations

4 rows where hash_id = "3dfa36d6fa351b68"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
4754 3dfa36d6fa351b68 2.40(b)(2)   1 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). A female Pomeranian microchip #005-008-600 continues to have problems with her teeth and right ear. The upper teeth remain covered in a dark hard material and the dog's right ear has redeveloped a thick brown discharge that is matted in the hair. Tooth problems can be painful and cause further health issues in dogs if not treated. The discharge from the ear may be a sign of a problem in the ear and needs to be evaluated if it needs proper treatment. To ensure that this dog is not in pain and receives appropriate treatment have the attending veterinarian evaluate it to diagnose the ear and teeth problems and treat them per the veterinarian's instructions. Documentation of the dog's diagnosis must be kept for future inspections.
4755 3dfa36d6fa351b68 2.50(a)(2)   1 TIME AND METHOD OF IDENTIFICATION. One puppy was not identified by an official USDA identification method (cage card, tag, or plastic collar). Lack of official identification does not allow for the proper identification or tracking of the animals. Correct by identifying all puppies with an official USDA method of identification.
4756 3dfa36d6fa351b68 2.75(a)(1)   1 RECORDS: DEALERS AND EXHIBITORS. The acquisition of four adult dogs has not been recorded on the APHIS 7005 inventory forms. One puppy birth has not been recorded on an APHIS Form 7005 or on a cage card. Lack of accurate and up-to-date inventory records does not ensure for the proper tracking of the animals by APHIS Officials as necessary. Update the facility inventory records with all required information so they accurately reflect the current inventory of animals.
4757 3dfa36d6fa351b68 3.1(c)(1)   1 HOUSING FACILITIES, GENERAL. Excessive rust development remains on three inside metal door flaps in the enclosures of the inside/outside building. The presence of rust can prevent the surfaces from being properly cleaned and sanitized. Eliminate the rust from the metal door flaps. This inspection and exit interview were conducted with the licensee. Additional Inspectors Wilken Kevin, Animal Care Inspector

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