Semantic search

citations

2 rows where hash_id = "eec448c522da4c07"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
17546 eec448c522da4c07 2.40(b)(2)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). A male Shih-Tzu (tag number 148) has a skin lesion in the area of his right shoulder that is weepy and red in appearance. The facility representative stated that the licensee has been treating the lesion with a topical medication, but has not consulted the attending veterinarian regarding the dog's skin condition. The lesion is an abnormal condition that may be painful and can become infected if not treated properly. Correct by having the attending veterinarian examine and evaluate the dog's skin condition and then by treating the dog as directed by the attending veterinarian. Correct by January 8, 2016.
17547 eec448c522da4c07 3.4(b)   0 OUTDOOR HOUSING FACILITIES. Two female Golden Doodles (tag numbers 119 and 120) are currently housed in the outdoor portion of the barn. The licensee has provided a nesting box with bedding, but has not provided a shelter structure within the enclosure. Lack of a shelter structure does not provide the dogs with an adequate means of conserving heat during the winter. Correct by providing a shelter structure within the enclosure. Correct by January 7, 2016. Inspection and exit briefing conducted with the facility representative. End of report.

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