Semantic search
citation_inspection
2 rows where hash_id = "eec448c522da4c07"
This data as json, CSV (advanced)
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.
| rowid | 17546 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | AARON HOSTETLER |
| kind | |
| Incident hash_id | eec448c522da4c07 |
| web_inspectionDate | 2016-01-05 |
| code | 2.40(b)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 50.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 25976.0 |
| pdf_customer_name | Aaron Hostetler |
| pdf_customer_addr | W4775 Elm Ave Stetsonville, WI 54480 |
| customer_state | WI |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23507051-aphis-inspection-5161404190595 |
| lat | |
| lng |
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.
| rowid | 17547 |
| desc | OUTDOOR HOUSING FACILITIES. |
| web_siteName | AARON HOSTETLER |
| kind | |
| Incident hash_id | eec448c522da4c07 |
| web_inspectionDate | 2016-01-05 |
| code | 3.4(b) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 50.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 25976.0 |
| pdf_customer_name | Aaron Hostetler |
| pdf_customer_addr | W4775 Elm Ave Stetsonville, WI 54480 |
| customer_state | WI |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23507051-aphis-inspection-5161404190595 |
| lat | |
| lng |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "citation_inspection" ( [rowid] INTEGER PRIMARY KEY, [narrative] TEXT, [desc] TEXT, [web_siteName] TEXT, [kind] TEXT, [hash_id] TEXT REFERENCES [inspections]([hash_id]), [web_inspectionDate] TEXT, [code] TEXT, [repeat] INTEGER, [pdf_insp_type] TEXT, [pdf_animals_total] FLOAT, [web_certType] TEXT, [pdf_customer_id] FLOAT, [pdf_customer_name] TEXT, [pdf_customer_addr] TEXT, [customer_state] TEXT, [pdf_site_id] TEXT, [doccloud_url] TEXT , lat double precision, lng double precision);