Semantic search
citation_inspection
1 row where hash_id = "0646e1ee6dd7a829"
This data as json, CSV (advanced)
3.125 (a) Structural strength, In the back holding area of the Collard Peccary enclosure, along the right rear wall is an area of broken stucco with exposed chicken wire with sharp edges. This area is not in good repair and the exposed chicken wire could potentially cause injuries to the animals. In the same back holding area, along the left rear side the floor is missing a board. This area has a large enough gap for an animal's foot to get caught which could potentially cause an injury. Construct and maintain all facilities so that they are structurally sound and in good repair to protect the animals from injuries. Inspection accompanied by APHIS Officials Jeanne Kjos, VMO; Cindy Rhodes, ACI, and facility representative. An exit briefing was conducted with a facility representative. Additional Inspectors Kjos Jeanne, Veterinary Medical Officer
| rowid | 7268 |
| desc | FACILITIES, GENERAL. |
| web_siteName | NEW MEXICO WILDLIFE ASSOC. |
| kind | |
| Incident hash_id | 0646e1ee6dd7a829 |
| web_inspectionDate | 2015-08-18 |
| code | 3.125(a) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 21.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3754.0 |
| pdf_customer_name | New Mexico Wildlife Association |
| pdf_customer_addr | P. O. Box 1359 Edgewood, NM 87015 |
| customer_state | NM |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23487955-aphis-inspection-230151430280477 |
| lat | 35.0614358 |
| lng | -106.1914141 |
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);