Semantic search

citations

1 row where hash_id = "dde3e736f7664753"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
23978 dde3e736f7664753 3.127(c)   0 FACILITIES, OUTDOOR. There is excessive, thick, and saturated mud in both pot-bellied pig enclosures. The mud is covering the entire ground except the animals' shelters in both enclosures. The pigs must walk through the mud to access their shelters, food, and water bowls. Excessive mud can be a potential hazard to the animals. Assure that measures are implemented to provide adequate drainage in both of these enclosures. To be corrected: 7-21-15 Note: Both pens were shoveled out, removing a substantial amount of mud between the time of inspection and the exit briefing. Note: The inspection exit briefing was conducted with the facility owner.

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