Semantic search
citation_inspection
2 rows where hash_id = "2027961507d28a7e"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
***The Animal Care Regional Director did not receive an itinerary from the licensee prior to this overnight travel. One of the attendants stated to APHIS VMO's that they arrived to the fair approximately 1 week ago. The licensee must submit an itinerary to the Regional Director no fewer than 2 days in advance of travel whenever the animals will be exhibited at a location other than the licensee's approved site(s) and whenever that travel extends overnight. The itinerary shall contain complete and accurate information concerning the whereabouts of any animal intended for exhibition at any location other than the person's approved site.
| rowid | 24152 |
| desc | ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. |
| web_siteName | MICHAEL TODD |
| kind | |
| Incident hash_id | 2027961507d28a7e |
| web_inspectionDate | 2014-08-20 |
| code | 2.126(c) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 3.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 321415.0 |
| pdf_customer_name | Michael Todd |
| pdf_customer_addr | All Things Wild 22 West Washington St Suite 1500 Chicago, IL 60602 |
| customer_state | IL |
| pdf_site_id | TRA |
| doccloud_url | https://www.documentcloud.org/documents/23521458-aphis-inspection-232141954410499 |
| lat | |
| lng |
***There was insufficient distance and/or barriers between the tigers and the public during the time that the public was allowed to feed the tigers. The public is allowed to use kitchen tongs to feed raw meat to the tigers while having their photo taken by an attendant. The barrier that the public stands behind was about 3 feet high and was 32 inches away from the tiger enclosure. This height and distance was not enough to prevent people from leaning over the barrier far enough to potentially be able to stick their fingers or hands into the 2 inch by 4 inch openings of the enclosure. Insufficient distance or barriers between the animals and the public can compromise the safety of both. The licensee must ensure that there is sufficient distance and/or barriers between the general viewing public and the animals so as to assure the safety of the animals and the public. Inspection took place at the Central States Fair in Rapid City, SD. Inspection and exit briefing were conducted on-site with facility representatives and 2 APHIS VMO's. Additional Inspectors Heezen Dee, Veterinary Medical Officer
| rowid | 24153 |
| desc | HANDLING OF ANIMALS. |
| web_siteName | MICHAEL TODD |
| kind | |
| Incident hash_id | 2027961507d28a7e |
| web_inspectionDate | 2014-08-20 |
| code | 2.131(c)(1) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 3.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 321415.0 |
| pdf_customer_name | Michael Todd |
| pdf_customer_addr | All Things Wild 22 West Washington St Suite 1500 Chicago, IL 60602 |
| customer_state | IL |
| pdf_site_id | TRA |
| doccloud_url | https://www.documentcloud.org/documents/23521458-aphis-inspection-232141954410499 |
| 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);