Semantic search

citations

1 row where hash_id = "412b490c6f1243d2"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
31003 412b490c6f1243d2 2.40(a)(1)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). The written program of veterinary care was not available for review by USDA at time of the inspection . A written program of veterinary care, signed by the attending veterinarian must be maintained at the facility and followed to ensure adequate veterinary care is provided to the animals . It must be made available for review at time of the inspection . CORRECT BY : 10-1-16 The inspection and exit briefing was conducted with a facility 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
);