home / aphis_reports

Semantic search

citations

1 row where hash_id = "b7431501e3d1512e"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
27945 b7431501e3d1512e 2.126(b)   0 ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. The written Program of Veterinary Care (PVC) and the List of Animals on Hand forms were not available for review at time of inspection. The required records should be made available to APHIS officials at time of inspection. To be corrected for all future inspections. An exit briefing was conducted with the 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 2713.039ms