home / aphis_reports

Semantic search

citations

1 row where hash_id = "a7e8c1344d25a352"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
38251 a7e8c1344d25a352 2.40(a)(1)   0 Attending veterinarian and adequate veterinary care (dealers and exhibitors). * Documentation of the last regularly scheduled visit for 26 adult cats by the attending veterinarian could not be found at the time of inspection. Regularly scheduled visits are important to determine if all aspects of animal care (nutrition, health, environment, water, and air quality, etc.) are being provided. The licensee must have regularly scheduled visits by the attending veterinarian. Correct by 10/14/23. This inspection and exit interview were conducted with the licensee. n

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