Semantic search

citations

1 row where hash_id = "c99a5e65e00dc08b"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
32997 c99a5e65e00dc08b 3.31(a)(1)   0 SANITATION. There is a buildup of brown roughened scale and debris on the sides and floor of the guinea pig enclosures. The accumulation of brown roughened scale and debris exposes the guinea pigs to potential infections with bacteria, fungi, and parasites. Correct by ensuring that all primary enclosures are clean and sanitized often enough to prevent an accumulation of scale and debris. Additionally, ensure that the primary enclosures are sanitized at least once every two weeks. Correct by September 28, 2016. This inspection and exit interview were conducted with the 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
);