Semantic search

citations

1 row where hash_id = "6babac222e1dcc89"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
10883 6babac222e1dcc89 2.40(x)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). (b) (2) ***** At time of inspection the following two dogs both female Yorkshire Terriers ( microchip #'s 020036541 and 019874011 ) were being treated for an eye problem disgnosed by the veterinarian as "Dry Eye" with several different types of ointments and washes. The eyes remain partially closed and eye matter is present in one female, while the other has eye matter and shows no change according to the licensee. These dogs need to be re-evaluated by a veterinarian to determine a cause of the continued problem with the eyes and to determine a new course of treatment. TO BE CORRECTED BY: 2-16-15 This inspection and exit interview conducted by APHIS, USDA, Animal Care personnel and the owners. END OF REPORT. Additional Inspectors Digesualdo Cynthia, Veterinary Medical Officer

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