Semantic search

citations

1 row where hash_id = "1ea558fb6f511ae0"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
78 1ea558fb6f511ae0 3.131(c)   0 SANITATION. *Two fly strips above the treatment stall for the goats were full of flies. There were some cobwebs attached to the back and sides of the stall. Debris from older fly strips and cobwebs could allow for contamination of equipment during procedures or while routinely handling the animals. In addition, as weather warms, fly strips that are full may not adequately control flies. Premises shall be kept clean in order to protect the animals from injury. Corrected at time of inspection. The inspection and exit briefing were conducted with the President.

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