home / aphis_reports

Semantic search

citation_inspection

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

3 rows where hash_id = "54001c1678e68942"

✎ 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 are several areas in both fox enclosures where these animals have dug exposing the wire mesh. This has now created holes underneath which now pose a risk of injury or entrapment. One of the foxes "Cheza" has had a previous injury to one of the legs resulting in temporarily injury/lameness which required veterinary attention. The cause of this lameness was not definitively determined, but these holes could have contributed the cause of this injury. The holes shall be filled in, and the wire mesh shall be covered, to prevent injury and maintain these enclosures in good condition. Correct by June 7, 2014

rowid 27680
desc FACILITIES, GENERAL.
web_siteName FLORIDAS C L A W S
kind  
Incident hash_id 54001c1678e68942
web_inspectionDate 2014-06-04
code 3.125(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 12.0
web_certType Class C - Exhibitor
pdf_customer_id 326578.0
pdf_customer_name Rachel Arnott
pdf_customer_addr 8520 Sioux Trail Kissimmee, FL 34747
customer_state FL
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23527878-aphis-inspection-155141250520380
lat  
lng  

The water receptacles & the water in the two fox enclosures, and the outdoor bobcat enclosure have large accumulations of algae. The water appeared stagnant and slimy on the surface. All water receptacles shall be kept clean and sanitary. Correct by June 5, 2014

rowid 27681
desc WATERING.
web_siteName FLORIDAS C L A W S
kind  
Incident hash_id 54001c1678e68942
web_inspectionDate 2014-06-04
code 3.130
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 12.0
web_certType Class C - Exhibitor
pdf_customer_id 326578.0
pdf_customer_name Rachel Arnott
pdf_customer_addr 8520 Sioux Trail Kissimmee, FL 34747
customer_state FL
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23527878-aphis-inspection-155141250520380
lat  
lng  

The indoor kinkajou, bobcat, & skunk rooms are dirty and have a high concentration of ammonia. The ammonia was in sufficient concentrations to cause an irritation of this inspector's nasal passages and difficulty in breathing. Additionally, the kinkajou was observed to have slight, clear, nasal discharges from both nostrils and was observed intermittently licking his nose to remove these discharges. The skunk room (bathroom) had large accumulations of old feces and food pellets on the floor &/or in the bathtub. This room also had a bottle of cleaner on the floor. The skunks are allowed free access in this bathroom. High concentrations of ammonia are irritating to nasal, ocular, & respiratory passages. This can cause distress, difficulty in breathing, and does not minimize respiratory illnesses. All animal enclosures shall be maintained in a clean fashion to minimize disease hazards and to reduce odors. Correct by June 5, 2014 The exit interview was conducted with the licensee.

rowid 27682
desc SANITATION.
web_siteName FLORIDAS C L A W S
kind  
Incident hash_id 54001c1678e68942
web_inspectionDate 2014-06-04
code 3.131(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 12.0
web_certType Class C - Exhibitor
pdf_customer_id 326578.0
pdf_customer_name Rachel Arnott
pdf_customer_addr 8520 Sioux Trail Kissimmee, FL 34747
customer_state FL
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23527878-aphis-inspection-155141250520380
lat  
lng  

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 1313.336ms