Semantic search

citations

2 rows where hash_id = "d138f1de6a0aad5f"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
19406 d138f1de6a0aad5f 2.40(a)(1)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). **The last Program of Veterinary Care found appears to have been updated in 2007 and does not include the species of animals on the premises. The exhibitor shall employ an attending veterinarian under formal arrangements, which includes a written Program of Veterinary Care and scheduled visits to the premises. This program and relationship must be established to help ensure provision of an appropriate standard of care for the regulated animals. The program must be complete to include all regulated species, regularly, reviewed, and updated as necessary by the attending veterinarian. Correct by 11/3/2015
19407 d138f1de6a0aad5f 2.40(b)(2)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). **The coyote Cheyenne was observed lying down in her enclosure and appeared unwilling to move. When she arose and began to walk to her den, her gait was very slow, stiff, and unsteady. The Caretaker reported that she had been running around when last observed up, but has been lying down in her den more often as the weather turned colder. It is thought that Cheyenne is 18 years old. Changes in gait and reduced mobility often indicate pain or discomfort in animals. This animal should be evaluated soon by a veterinarian to determine an appropriate method to diagnose and treat her condition. Correct by 10/24/2015. The inspection and exit briefing were conducted with the Caretaker.

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
);