Semantic search

citations

1 row where hash_id = "60ddf0cfb6b0c8e7"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
11888 60ddf0cfb6b0c8e7 2.40(a)(1)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). There was not a recorded site visit or written program of veterinary care by the attending veterinarian at time of inspection. Good communication and consultation between the licensee and the attending veterinarian in the form of a written program of veterinary care and regularly scheduled visits to the premise are necessary for the health of the animals. The licensee must schedule a site visit with the attending veterinarian and keep the recorded documentation available for inspection. To be corrected by August 12, 2014. Exit interview conducted with facility representative at time 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
);