home / aphis_reports

Semantic search

citations

1 row where hash_id = "296488acda0b63c4"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
28296 296488acda0b63c4 2.126(b)   0 ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. Section 2.126(b) - Access and inspection of records and property: A responsible adult shall be made available to accompany APHIS officials during the inspection process. A responsible adult was not available to accompany APHIS Officials during the inspection process at 12:30 on 10/06/2015. Upon arrival I spoke with the licensee who stated that she could not stay for the inspection process but had to go to a meeting. We discussed future hours of operation and optimal hours for inspection. This is the first attempted inspection.

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