Semantic search

citations

1 row where hash_id = "73253967d1103b3e"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
29296 73253967d1103b3e 3.125(a)   0 FACILITIES, GENERAL. In the outdoor pig enclosure, there are two pieces of vertical metal siding which have become detached from the exterior of the barn. The loose metal siding has sharp edges which could potentially injure the two pigs housed in this enclosure. Indoor and outdoor housing facilities shall be structurally sound and shall be maintained in good repair to protect the animals from injury and to contain the animals. To be corrected by: January 29, 2016. Facility inspection was conducted by Jeanne Kjos, VMO and Cindy Digesualdo, VMO with facility representative on January 5, 2016. Exit briefing was conducted by Jeanne Kjos, VMO with facility representative on January 7, 2016. Additional Inspectors Digesualdo Cynthia, Veterinary Medical Officer

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