Semantic search
citation_inspection
5 rows where hash_id = "ceee5a857ce2ba8a"
This data as json, CSV (advanced)
Dogs at the facility were able to gain access into the wallaby enclosure resulting in the wallabys death. The dogs, owned by the facility owner, were able to enter the indoor wallaby building through the entrance door. The door was closed, but the dogs forced it open as per the facility representative. All animal housing facilities must be structurally sound and maintained in good repair to prevent unauthorized animals from entering. Note: An new entrance door was placed on the wallaby building.
| rowid | 12789 |
| desc | FACILITIES, GENERAL. |
| web_siteName | DONALD WILLIAMS |
| kind | |
| Incident hash_id | ceee5a857ce2ba8a |
| web_inspectionDate | 2015-06-30 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 15.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 8982.0 |
| pdf_customer_name | Donald Williams |
| pdf_customer_addr | 4661 Yale Bridge Road Rockton, IL 61072 |
| customer_state | IL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23497325-aphis-inspection-181151736200156 |
| lat | |
| lng |
The camel enclosure has a drainage issue. A section (approximately 10 ft by 3 ft) of standing water and mud is present along the entire entrance to the camel's inside barn access. An additional section ((approximately 20 ft by 10 ft) of thick, saturated mud is present adjacent to the standing water, extending out into the enclosure. The camel must walk through the mud and standing water to gain access to its shelter, food, and water receptacles. The standing water can serve as a breeding area for insects. The mud is a potential hazard to the camel. Assure the camel enclosure has adequate drainage to prevent standing water and thick saturated mud. To be corrected: 7-15-15
| rowid | 12790 |
| desc | FACILITIES, OUTDOOR. |
| web_siteName | DONALD WILLIAMS |
| kind | |
| Incident hash_id | ceee5a857ce2ba8a |
| web_inspectionDate | 2015-06-30 |
| code | 3.127(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 15.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 8982.0 |
| pdf_customer_name | Donald Williams |
| pdf_customer_addr | 4661 Yale Bridge Road Rockton, IL 61072 |
| customer_state | IL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23497325-aphis-inspection-181151736200156 |
| lat | |
| lng |
Excessive algae is present in the camel water tub. The sides of the water tub are green with algae. Water containing algae, if ingested, can potentially cause animals to become ill. Clean and sanitize the camel water tub and repeat often enough to prevent buildup. To be corrected: 7-3-15
| rowid | 12791 |
| desc | WATERING. |
| web_siteName | DONALD WILLIAMS |
| kind | |
| Incident hash_id | ceee5a857ce2ba8a |
| web_inspectionDate | 2015-06-30 |
| code | 3.130 |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 15.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 8982.0 |
| pdf_customer_name | Donald Williams |
| pdf_customer_addr | 4661 Yale Bridge Road Rockton, IL 61072 |
| customer_state | IL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23497325-aphis-inspection-181151736200156 |
| lat | |
| lng |
1. Excessive feces and urine are present on the floor inside of the wallaby building. The majority of the floor was covered with a thin layer of feces and urine, The wallaby's food and water dishes are also present inside of this building. Excessive feces and urine are potential health hazards to animals. Thoroughly clean and disinfect the floor and repeat as necessary to prevent build up. To be corrected: 7-2-15 2. A pile of hay mixed with feces is present in the outdoor area of the reindeer enclosure. This pile is the result of a couple of days worth of cleaning the indoor area for the reindeer. Additionally, excessive feces are present on the ground of the indoor area for the reindeer. The pile could potentially provide a breeding area for insects and other pests. Excessive feces are a potential health hazard to the animals. Remove the pile from the reindeer enclosure. Clean and disinfect the reindeer indoor area. To be corrected: 7-3-15
| rowid | 12792 |
| desc | SANITATION. |
| web_siteName | DONALD WILLIAMS |
| kind | |
| Incident hash_id | ceee5a857ce2ba8a |
| web_inspectionDate | 2015-06-30 |
| code | 3.131(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 15.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 8982.0 |
| pdf_customer_name | Donald Williams |
| pdf_customer_addr | 4661 Yale Bridge Road Rockton, IL 61072 |
| customer_state | IL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23497325-aphis-inspection-181151736200156 |
| lat | |
| lng |
Excessive flies are present in and around the enclosures containing 2 reindeer and 1 camel. The camel was observed moving his head back and forth as it was attempting to shoo the flies. The male reindeer had no fewer than 10 flies on his legs. The reindeer also attempted to shoo the flies. There are several fly strips around the enclosures, however; they are not sufficiently controlling the fly population in these areas. Flies can carry diseases that affect animals. Implement provisions to effectively control the fly population in the animal areas. To be corrected: 7-3-15 The inspection was conducted on 6-30-15. The inspection exit briefing was conducted with the undersigned facility representative on 7-1-15
| rowid | 12793 |
| desc | SANITATION. |
| web_siteName | DONALD WILLIAMS |
| kind | |
| Incident hash_id | ceee5a857ce2ba8a |
| web_inspectionDate | 2015-06-30 |
| code | 3.131(d) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 15.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 8982.0 |
| pdf_customer_name | Donald Williams |
| pdf_customer_addr | 4661 Yale Bridge Road Rockton, IL 61072 |
| customer_state | IL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23497325-aphis-inspection-181151736200156 |
| 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);