Semantic search
citation_inspection
1 row where hash_id = "383be313834a7a95"
This data as json, CSV (advanced)
A white male hedgehog is missing a portion of its left ear. The remaining portion of the ear is thickened and scabbed. The injury occurred at least one week ago and had not been reported to the veterinarian prior to the time of inspection. The animal had only been removed from its group enclosure and isolated in its own enclosure. Failure to provide adequate veterinary care for animal injuries can result in further injury and veterinary complications. This injury must be reported to the veterinarian. All prescribed treatments or instructions must be followed. Note: The license holder contacted veterinarian during the time of inspection. The inspection exit briefing was conducted with the facility owner.
| rowid | 7507 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | THE ANIMAL STORE INC |
| kind | |
| Incident hash_id | 383be313834a7a95 |
| web_inspectionDate | 2016-01-05 |
| code | 2.40(b)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 8.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 3844.0 |
| pdf_customer_name | The Animal Store |
| pdf_customer_addr | 4364 W. Touhy Avenue Lincolnwood, IL 60712 |
| customer_state | IL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23488267-aphis-inspection-5161621170136 |
| lat | 42.0120516 |
| lng | -87.73769180000001 |
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);