Semantic search

citations

1 row where hash_id = "d933639e970120f8"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
170 d933639e970120f8 2.38(b)   1 MISCELLANEOUS. There was no one available during business hours to allow APHIS Officials to enter and inspect the facilities, property, records, and animals on20-JUN-17 at 12:00. On June 20, 2017 the USDA inspector attempted to reach the IACUC Administrator upon arrival to the facility and received information from the security desk at St. Elizabeth Hospital that the company has been closed since August 2015. The USDA inspector emailed Genesys representatives and the emails were sent back as invalid addresses. This inspection and exit interview could not be conducted since the facility is no longer there.

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
);