Semantic search

citations

1 row where hash_id = "6abf53960d5a97cf"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
3091 6abf53960d5a97cf 3.101(a)(1)   0 FACILITIES, GENERAL. Item Facilities General 3.101 a 1 At the time of inspection it was noticed that the door entering the sea lion exhibit holding area had begun to rot and corrode. Housing facilities need to be maintained structurally sound and in good repair. Facility needs to repair/replace door. Correct by 5/1/15 Exit interview took place at the end of inspection.

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