home / aphis_reports

Semantic search

citation_inspection

Table actions
  • Semantic search against this table
  • Semantic search against this table

1 row where hash_id = "d6d6af7595ba2cd5"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: web_inspectionDate (date)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

* There was a 6 foot, chain-link, perimeter fence surrounding the entire circus including the tigers' primary enclosures and their exercise enclosure. A drive-through gate in that fence was left open and unattended several times during the inspection. The open gate was approximately 100 feet away from and in plain view of the tiger transport trailer and enclosures. There was a fence immediately around the tiger transport enclosures, but it was only 4 feet tall and was within arms reach of the enclosures. At one point, the gate was left wide open after the tiger caretaker and much of the rest of the circus staff left the premises for a break. An unauthorized person could have easily approached and made contact with the tigers at that time. * Perimeter fence gates left open and unattended do not adequately prevent unauthorized personnel from coming in contact with the animals and do not adequately function as secondary containment systems. This could result in something harmful happening to the tigers or the public. *** The licensee must ensure the tigers' primary enclosures are contained within a secure perimeter fence which is at least 8 feet tall and 3 feet away from the enclosures OR provide appropriate alternative security measures. TO BE CORRECTED BY: this non-compliant item was corrected prior to the end of the inspection. The inspection was conducted on 22-23 July 2014 with a facility representative. A verbal exit interview was conducted in person with a facility representative and via telephone with the licensee on 23 July 2014. Additional Inspectors Niemann Jamilon, Supervisory Animal Care Specialist

rowid 5063
desc FACILITIES, OUTDOOR.
web_siteName MITCHEL KALMANSON
kind  
Incident hash_id d6d6af7595ba2cd5
web_inspectionDate 2014-07-22
code 3.127(d)(4)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 3.0
web_certType Class C - Exhibitor
pdf_customer_id 2996.0
pdf_customer_name Mitchel Kalmanson
pdf_customer_addr P O Box 940008 Maitland, FL 32794
customer_state FL
pdf_site_id TRA
doccloud_url https://www.documentcloud.org/documents/23484407-aphis-inspection-204141624450897
lat 28.6282202
lng -81.36568969999999

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 2379.691ms