Semantic search

citations

1 row where hash_id = "097920c23601ccb4"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
2267 097920c23601ccb4 2.38(f)(1) Critical 0 Miscellaneous. One macaque sustained an injury to his hand requiring amputation of several digits when a guillotine door fell on his hand during shifting for routine enclosure sanitation. The caretaker lost grip on the door causing it to fall on the animal’s hand. Handling of animals shall be done as expeditiously and carefully as possible so as not to cause physical harm. Corrective measures have been instituted and include installing a portable pully system for the guillotine doors in this animal holding area ,training care staff on its use and revising the SOP for moving alert non human primates . CORRECTED AT TIME OF INSPECTION 5/1/2023 This inspection and exit briefing were conducted with facility employees . n

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