Semantic search

citations

2 rows where hash_id = "f8d79bf0189f7e9b"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
23035 f8d79bf0189f7e9b 3.56(c)   0 SANITATION. The barn where the rabbit enclosures are located had excessive clutter and debris, including shelves with chemical products, cobwebs, and dust. The building and grounds should be maintained in a cleanly manner, in order to reduce the risk of disease and vermin, and promote good husbandry. Trash should be removed, and chemicals stored in a safe manner. To be corrected by 11/6/15.
23036 f8d79bf0189f7e9b 3.125(a)   0 FACILITIES, GENERAL. The enclosures for the calf and sheep / goats have many dangling and protruding pieces of wire that could potentially cause injury to the animals. Animal enclosures should be constructed and maintained in a manner that minimizes the risk of injury. To be corrected by 10/16/15. An exit briefing was conducted with the exhibitor.

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