Semantic search

citations

2 rows where hash_id = "3e3b2e18d4268616"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
38662 3e3b2e18d4268616 2.27(a)   0 Notification of change of operation. The registrant is no longer located at the address on file and has not provided notification of change of address. During the attempted inspection, it was noted that the facility appeared vacant. The neighbor was contacted and confirmed that the registrant no longer lived at that address but did not have a forwarding address. Multiple previous attempts to contact the licensee by phone and text have gone unanswered. It is important that address and other contact information is kept up to date to facilitate timely contact and inspections by USDA. Correct by 9/15/23
38663 3e3b2e18d4268616 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 12:30 on 9/14/23. Additional Inspectors: Jennifer Walker, VETERINARY MEDICAL OFFICEREnd 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
);