Semantic search

citations

1 row where hash_id = "2152451d3d85affc"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
29729 2152451d3d85affc 2.40(b)(2)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). ***There was an approximately 8 month old female Bichon Frise (#941000018198430) with hair loss and circular-like lesions on the front of the lower legs/back feet. The hair loss was present on the front of both back legs extending approximately from the knees to the top of each rear foot. There were at least 2 to 3 reddened circular type lesions present over each lower leg/ rear foot in the areas of hair loss. The lesions varied in size from pinpoint to approximately 1/4 inch in diameter. The larger lesions on each foot appeared to be crusty and scab-like. The licensee was not aware of the dog's condition prior to the inspector pointing it out, but thought it could be due to the dog recently being housed with a male dog. This dog's condition could be due to an infection or a variety of other veterinary medical conditions. The licensee must consult with a licensed veterinarian regarding this dog's condition in order to ensure that an accurate diagnosis is made and an appropriate treatment plan is developed and followed. The licensee must document this information and make it available to the inspector upon request. The licensee must ensure that all animals receive adequate veterinary care at all times. To be corrected by: January 9, 2016. The inspection and exit interview were conducted with the licensee.

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