Semantic search

citations

1 row where hash_id = "064ea9c56aaffe62"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
19404 064ea9c56aaffe62 2.40(b)(2)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). A male liver and white schnauzer (“Baxter”, microchip 496 578 191E) has a heavy buildup of brown tartar on the cheek teeth on the right side of the mouth. The tartar on the upper right cheek teeth is entirely encasing the surface of the teeth and the individual shape of the teeth is no longer identifiable. Nearly half the surface of the upper right canine tooth is encased in tartar with the thickest buildup located along the gum line. The cheek teeth on the left side of the mouth also have a buildup of tartar. The gums have become moderately reddened. Poor dental health could cause pain and discomfort to the dog and could possibly lead to further health issues. This dog must be evaluated by a licensed veterinarian for a proper diagnosis and to develop an effective treatment plan. The diagnosis and treatment plan must be documented in writing and available to the inspector upon request. The licensee must ensure that all dogs receive adequate veterinary care at all times. To be corrected by: September 28, 2016 Inspection and exit interview conducted with Kelly Maxwell, ACI and the facility representative.

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