Semantic search

citations

1 row where hash_id = "08ba0ed985a26dfc"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
79 08ba0ed985a26dfc 3.125(a)   0 Facilities, general. Multiple small areas areas associated with seams along the metal lining on the wall of the goat pen were rusted and peeling up away from the wall, creating roughened edges with the potential for goats to rub against and pull apart further. If the metal wall liners are not kept in good repair, there is a potential for animal injury. The facility must ensure that the facility is structurally sound and maintained in good repair to protect the animals from injury. To be corrected by: August 10, 2021 This inspection and exit interview were conducted with facility representative. End 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
);