Semantic search

citations

2 rows where hash_id = "2a1309400b22c49c"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
13514 2a1309400b22c49c 3.125(a)   0 FACILITIES, GENERAL. At this time the roof shingles behind the water wheel and the roof of the calf shelter are in need of attention. There are shingles missing and / or damaged. To ensure that the animal areas are maintained properly these roofs will need to be addressed. ***To Be Corrected By: August 2, 2014
13515 2a1309400b22c49c 3.131(c)   0 SANITATION. At the time of this inspection it was noted that the stream bed that runs through the calf, goat and sheep enclosures was in need of attention. This water feature is ~ 6-8(cid:29) deep. However, the water in this stream bed was brown and emitted an odor. At this time you could not see the bottom of this stream bed. To ensure that the areas are kept clean this water feature will need to be cleaned on a more frequent basis. ***To Be Corrected By: July 23, 2014

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