Semantic search

citations

1 row where hash_id = "ba185b1c6aac0059"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
34928 ba185b1c6aac0059 3.125(a)   0 Facilities, general. In the enclosure housing three foxes, there is a triangular piece of plywood used as a platform with a significant number of chewed, jagged edges. Additionally, where the plywood is attached to the corner of the enclosure, there are three screws that extrude approximately 1.5in-2in into the enclosure. These sharp points pose a risk of injury to the animals contained therein. The housing facilities must be constructed so that they protect the animals from injury. Correct by 6/2/2023. This inspection and exit interview were conducted with the facility representative. 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
);