Semantic search

citations

1 row where hash_id = "c14125ba5346e5c4"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
1 c14125ba5346e5c4 3.125(a)   0 FACILITIES, GENERAL. At the south farm, a goat was observed to jump up onto the ledge of the concrete foundation and move from pen 4 over to pen 5 and then back to pen 4 again. There was a panel up on the ledge in place to prevent this, however the goat could pass between the vertical supports of the panel. Also, the panel had some free ends of wire that if bent out could become sharp points exposed to any goat that climbs up on the concrete ledge. Lack of proper containment and exposure to sharp points could lead to injury or other adverse events. The facility must ensure that enclosures are structurally sound and maintained in good repair to contain the animals and protect them from injury. Correct by October 5, 2016. This inspection and exit interview were conducted with facility representatives on 9/26 thru 9/27/2016.

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