Semantic search
citation_inspection
3 rows where hash_id = "c9a2e76c8ba74b6e"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
***The shift door on the cotton-top tamarin and the emperor tamarin enclosure is rusted in several areas on the surface of the door frame. Excessive rust can prevent effective sanitization of the surface, which may affect the health of the animals through buildup of pathogens. ***In the chimpanzee enclosure there was rust on the metal brackets holding the elevated platforms. There was also peeling paint in several areas on the back wall of the enclosure. Excessive rust and peeling paint can prevent effective sanitization of the surface, which may affect the health of the animals through buildup of pathogens. Surfaces which come into contact with nonhuman primates must be free of excessive rust and constructed in such a manner to promote effective cleaning and sanitization of the surface and preserve structural strength.
| rowid | 5079 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | JACKSON ZOOLOGICAL SOCIETY INC |
| kind | |
| Incident hash_id | c9a2e76c8ba74b6e |
| web_inspectionDate | 2015-10-06 |
| code | 3.75(c)(1) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 151.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3004.0 |
| pdf_customer_name | Jackson Zoological Society Inc |
| pdf_customer_addr | 2918 West Capitol St Jackson, MS 39209 |
| customer_state | MS |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23484442-aphis-inspection-279151938180179 |
| lat | 32.3226003 |
| lng | -90.2238799 |
*** In the petting zoo containing sheep, potbellied pigs and goats there was a shade structure that had a wooden 2 x 6 that had come loose and could fall causing injury. *** In the red panda enclosure there was an area of the ceiling that was rotten. This rotten area could have pieces of material that could fall into the enclosure and cause injury or be harmful if ingested. The facilities should be structurally sound and maintained to protect the animals from injury. Correct by November 6, 2015.
| rowid | 5080 |
| desc | FACILITIES, GENERAL. |
| web_siteName | JACKSON ZOOLOGICAL SOCIETY INC |
| kind | |
| Incident hash_id | c9a2e76c8ba74b6e |
| web_inspectionDate | 2015-10-06 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 151.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3004.0 |
| pdf_customer_name | Jackson Zoological Society Inc |
| pdf_customer_addr | 2918 West Capitol St Jackson, MS 39209 |
| customer_state | MS |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23484442-aphis-inspection-279151938180179 |
| lat | 32.3226003 |
| lng | -90.2238799 |
*** The smaller outdoor enclosure containing 2 tigers had an area of water and mud that encompassed about one-third of the enclosure. An area that doesn'(cid:25)t drain and allows water and mud to accumulate has the potential to cause sanitation related diseases. A suitable method shall be provided to rapidly eliminate excess water. Correct by December 8, 2015. The inspection and exit interview were conducted with the Deputy Director.
| rowid | 5081 |
| desc | FACILITIES, OUTDOOR. |
| web_siteName | JACKSON ZOOLOGICAL SOCIETY INC |
| kind | |
| Incident hash_id | c9a2e76c8ba74b6e |
| web_inspectionDate | 2015-10-06 |
| code | 3.127(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 151.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3004.0 |
| pdf_customer_name | Jackson Zoological Society Inc |
| pdf_customer_addr | 2918 West Capitol St Jackson, MS 39209 |
| customer_state | MS |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23484442-aphis-inspection-279151938180179 |
| lat | 32.3226003 |
| lng | -90.2238799 |
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);