Semantic search
citation_inspection
1 row where hash_id = "dd02e2b33effa7d6"
This data as json, CSV (advanced)
The facility is conducting regulated activity without a valid USDA license. The facility consigned exotic animals (5 Flying Squirrels) to an auction. Upon arrival at the sale, the facility was informed that they needed a USDA license and would receive a citation if the animals were consigned. The facility chose to proceed and consigned the animals to the auction. A valid license is necessary to protect the health and well-being of the animals and to comply with the Animal Welfare Act and Regulations. Correct by obtaining a USDA license or discontinuing regulated activities. No regulated activities may be conducted until a USDA license is obtained. This inspection and exit interview were conducted with the facility Representative. This inspection was conducted in Mount Hope, Ohio. Additional Inspectors: Jonathan Tomkovitch, VETERINARY MEDICAL OFFICER Lauren Murphy, VETERINARY MEDICAL OFFICER Charles Palmer, VETERINARY MEDICAL OFFICER DIANA CARE, VETERINARY MEDICAL OFFICER n
| rowid | 40340 |
| desc | Requirements and application. |
| web_siteName | Joseph H Cali |
| kind | |
| Incident hash_id | dd02e2b33effa7d6 |
| web_inspectionDate | 2023-09-14 |
| code | 2.1(a)(1) |
| repeat | 0 |
| pdf_insp_type | FOCUSED INSPECTION |
| pdf_animals_total | 5.0 |
| web_certType | |
| pdf_customer_id | 6018960.0 |
| pdf_customer_name | Joseph H. Cali |
| pdf_customer_addr | 7845 Lafayette Road Lodi, OH 44524 |
| customer_state | OH |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/24128922-aphis-inspection-ins-0000892241 |
| 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);