Semantic search

citations

1 row where hash_id = "001f35c544deb035"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
18402 001f35c544deb035 3.131(a)   0 SANITATION. The enclosure housing two pigs has excessive wet, soiled straw. The area (approximately 2x3 ft in diameter) of wet, soiled straw is located on the left, front on the enclosure and adjacent to the pigs feeding container. Several flies were present on/in the soiled straw during the time of inspection. Soiled, wet bedding attracts flies and can cause animal illness. Remove and clean the affected area of the pig enclosure to minimize flies and promote animal health. To be corrected: 9-23-16 This inspection and exit interview were conducted with the employee.

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