Semantic search

citations

1 row where hash_id = "d35d86afecd24c43"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
27946 d35d86afecd24c43 3.31(b)   0 SANITATION. Housekeeping. There are accumulations of cobwebs, dust, and debris on the ceiling, walls, racks and wire surfaces. The floor contains spilled feed, shavings, and debris. Animal facilities must be kept clean to ensure the health and well-being of the animals. Ineffective cleaning exposes the animals to disease hazards and health problems. Correct by ensuring the premises are kept clean. Correct by June 20, 2014 An exit breifing was conducted with 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
);