Semantic search
citation_inspection
3 rows where hash_id = "a81faf0cae26ffe1"
This data as json, CSV (advanced)
Inside the Mandrill enclosure, the watering receptacle in this enclosure has an excess of green material covering the inside and along the edges of the watering receptacle. Dirty water may harbor disease hazards which may pose a health risk for the animals. All water receptacles shall be kept clean and sanitary. Corrected at the time of inspection.
| rowid | 7569 |
| desc | WATERING. |
| web_siteName | Gladys Porter Zoo |
| kind | |
| Incident hash_id | a81faf0cae26ffe1 |
| web_inspectionDate | 2015-02-10 |
| code | 3.83 |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 432.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3882.0 |
| pdf_customer_name | Gladys Porter Zoo |
| pdf_customer_addr | 500 Ringgold St Brownsville, TX 78520 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23488388-aphis-inspection-43150930310500 |
| lat | 25.9134059 |
| lng | -97.4954635 |
Inside of the indoor portion of the Orangutan sheltered enclosure, there is an excessive amount of rat feces inside the enclosure. Evidence of rat feces is an indicator of an ineffective pest control program. Rat droppings can harbor disease causing organisms and could cause potential contamination in animal areas. The licensee should ensure an effective pest control program is in place to control pests and reduce potential contamination. To be corrected by February 25, 2015.
| rowid | 7570 |
| desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
| web_siteName | Gladys Porter Zoo |
| kind | |
| Incident hash_id | a81faf0cae26ffe1 |
| web_inspectionDate | 2015-02-10 |
| code | 3.84(d) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 432.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3882.0 |
| pdf_customer_name | Gladys Porter Zoo |
| pdf_customer_addr | 500 Ringgold St Brownsville, TX 78520 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23488388-aphis-inspection-43150930310500 |
| lat | 25.9134059 |
| lng | -97.4954635 |
Inside the Serval enclosure , the watering receptacle in this enclosure has an excess of green material covering the inside of the watering receptacle. Dirty water may harbor disease hazards which may pose a health risk for the animals. All water receptacles shall be kept clean and sanitary. Corrected at the time of inspection. Inspection and exit interview conducted by APHIS personnel with facility representative.
| rowid | 7571 |
| desc | WATERING. |
| web_siteName | Gladys Porter Zoo |
| kind | |
| Incident hash_id | a81faf0cae26ffe1 |
| web_inspectionDate | 2015-02-10 |
| code | 3.130 |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 432.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3882.0 |
| pdf_customer_name | Gladys Porter Zoo |
| pdf_customer_addr | 500 Ringgold St Brownsville, TX 78520 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23488388-aphis-inspection-43150930310500 |
| lat | 25.9134059 |
| lng | -97.4954635 |
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);