Semantic search

citations

1 row where hash_id = "23e667f78812509e"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
1907 23e667f78812509e 3.125(a)   1 Facilities, general. The facility has a room that contains forty-five free roaming ferrets. There are two metal barriers in the doorway to prevent ferrets from leaving the room when the door is open. When the inspectors arrived at this room, there was one ferret stuck between the door and the barriers. Due to the placement of the metal barriers, it was able to climb over into the space between the door and the barrier but not get back out. The facility fixed the barriers and placed the ferret back in the room during the inspection. Enclosures that do not properly contain the animals can lead to injury or escape. Housing facilities shall be structurally sound and shall be maintained in good repair to protect the animals from injury and to contain the animals. This inspection and exit interview were conducted with facility representatives. Additional Inspectors: MICHAEL TYGART, VETERINARY MEDICAL OFFICER 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
);