Semantic search
citation_inspection
3 rows where hash_id = "01eaad3907749c02"
This data as json, CSV (advanced)
Primary enclosures- 1 pigtail macaque primate does not have a shift cage and the owner is the only one that can go in with him. There are some metal bars are the floor of the enclosure that could cause injury to the primate. There was also some miscellaneous trash in the enclosure. The shift cage is needed to prevent the accidental opening of the enclosure and the primate getting out and proper removal of unwanted items. The metal bars are heavy and are not a safe enrichment item in case they were to pick them up and swing them around. The licensee must add on a shift cage and remove the metal monkey bars lying on the floor of the enclosure. correct by 10-13-2015
| rowid | 28667 |
| desc | PRIMARY ENCLOSURES. |
| web_siteName | INDIAN CREEK INVESTMENT I I I, L L C |
| kind | |
| Incident hash_id | 01eaad3907749c02 |
| web_inspectionDate | 2015-10-06 |
| code | 3.80(a)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 94.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 327841.0 |
| pdf_customer_name | Indian Creek Investment I I I, L L C |
| pdf_customer_addr | 2740 Consear Rd Lambertville, MI 48144 |
| customer_state | MI |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23529709-aphis-inspection-279151613590791 |
| lat | |
| lng |
The (2) sloths are in a room that contains items that are not used for husbandry. The room they are currently housed in is for storage of boxes and miscellaneous items not used for the animals. Animal enclosures must not have any miscellaneous items stored in with the animals to protect the health of the animals because they are free to roam around the room. The licensee must remove all shelves with miscellaneous items and all items not pertaining to the husbandry practices for these sloths. Correct by 10-9-2015
| rowid | 28668 |
| desc | SANITATION. |
| web_siteName | INDIAN CREEK INVESTMENT I I I, L L C |
| kind | |
| Incident hash_id | 01eaad3907749c02 |
| web_inspectionDate | 2015-10-06 |
| code | 3.131(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 94.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 327841.0 |
| pdf_customer_name | Indian Creek Investment I I I, L L C |
| pdf_customer_addr | 2740 Consear Rd Lambertville, MI 48144 |
| customer_state | MI |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23529709-aphis-inspection-279151613590791 |
| lat | |
| lng |
Separation- 2 emus are being housed in the same enclosure with 4 wallabies. The animals are not a compatible species and must be housed in separate enclosures. The emus and wallabies will not share the shelter building and this will interfere with their health as the weather turns colder. The licensee must move one of these species to a separate enclosure to protect their health and not cause them discomfort. 10-9-2015 (This inspection was conducted with the licensee, Joe Kovach, ACI and Dr. Rick Kirsten, VMO, SAC)
| rowid | 28669 |
| desc | SEPARATION. |
| web_siteName | INDIAN CREEK INVESTMENT I I I, L L C |
| kind | |
| Incident hash_id | 01eaad3907749c02 |
| web_inspectionDate | 2015-10-06 |
| code | 3.133 |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 94.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 327841.0 |
| pdf_customer_name | Indian Creek Investment I I I, L L C |
| pdf_customer_addr | 2740 Consear Rd Lambertville, MI 48144 |
| customer_state | MI |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23529709-aphis-inspection-279151613590791 |
| 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);