home / aphis_reports

Semantic search

citations

1 row where hash_id = "0003750fe37eecba"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
31381 0003750fe37eecba 2.126(b)   0 Access and inspection of records and property; submission of itineraries. A responsible adult was not available to accompany APHIS Officials during the inspection process at 10:00 AM on 5/23/23. The inspector arrived at 10:00 AM on 5/23/23 to conduct an inspection. The inspector tried to contact the Licensee by phone (no answer) and then rang the doorbell at the front door. The person who was on the premises told the inspector that the Licensee was at a distant off-site location and would not be available for several hours. An AWA compliance inspection could not be conducted because there was no other authorized facility representative available to accompany the inspector. Unannounced inspections are used to evaluate compliance with the AWA Regulations and Standards. This is the FIRST attempted inspection of the Licensee. End Section

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