Semantic search

citations

1 row where hash_id = "195cf1a95b1fe8b9"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
11887 195cf1a95b1fe8b9 2.40(a)(1)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). There is a written program of veterinary care but the last visit by the veterinarian is greater than one year ago on August 8, 2012. Regular inspections by attending veterinarians are required in order to ensure adequate veterinary care at the facility. The licensee shall employ an attending veterinarian under formal arrangements and must schedule regular visits to the premises. To be corrected by August 1, 2014 A verbal exit conference was conducted with the licensee representative at the time of the 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
);