Semantic search
citation_inspection
2 rows where hash_id = "724fb26767db47d7"
This data as json, CSV (advanced)
The facility is comprised of enclosures and a roof that are in critical disrepair. Some gates have openings with protruding wires, feeders are falling apart, with exposed nails protruding, and the roof where the ewes are is actively shedding corroded pieces of corrugated metal, with broken pieces on the ground, and others threatening to fall from above. These elements have sharp edges and falling pieces which present a risk of injury to the animals. The gates and fencing in disrepair also present an escape risk. The facility must be constructed of such material and of such strength as appropriate for the animals involved. The indoor and outdoor housing facilities shall be structurally sound and shall be maintained in good repair to protect the animals from injury and to contain the animals. The facility should make necessary repairs or relocate the animals.
| rowid | 33 |
| desc | FACILITIES, GENERAL. |
| web_siteName | UNIVERSITY OF HAWAII AT MANOA |
| kind | |
| Incident hash_id | 724fb26767db47d7 |
| web_inspectionDate | 2018-07-19 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 30.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 19.0 |
| pdf_customer_name | University Of Hawaii At Manoa |
| pdf_customer_addr | 2425 Campus Road, Sinclair 10 Honolulu, HI 96822 |
| customer_state | HI |
| pdf_site_id | 009 |
| doccloud_url | https://www.documentcloud.org/documents/23470249-aphis-inspection-2016082569219244 |
| lat | 21.2984663 |
| lng | -157.8204149 |
In the animal enclosures and adjoining areas there was an accumulation of discarded materials. One room, within an enclosure, had discarded metal items and empty plastic sacs, and another had a bucket of cleaning products next to a pile of containers that appear to be discarded. Just outside another enclosure there was a large pile of discarded wool on the ground, that was wet and discolored. The premises shall be kept clean and in good repair in order to protect the animals from injury and to facilitate the prescribed husbandry practices. Accumulations of trash shall be placed in designated areas and cleared as necessary to protect the health of the animals. The facility should clean up the premises or relocate the animals. This was a new site inspection. No regulated activity shall be conducted at this site until it is brought into compliance and approved. This inspection was conducted with the site herdsman, and the exit interview was conducted with the University of Hawaii representatives.
| rowid | 34 |
| desc | SANITATION. |
| web_siteName | UNIVERSITY OF HAWAII AT MANOA |
| kind | |
| Incident hash_id | 724fb26767db47d7 |
| web_inspectionDate | 2018-07-19 |
| code | 3.131(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 30.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 19.0 |
| pdf_customer_name | University Of Hawaii At Manoa |
| pdf_customer_addr | 2425 Campus Road, Sinclair 10 Honolulu, HI 96822 |
| customer_state | HI |
| pdf_site_id | 009 |
| doccloud_url | https://www.documentcloud.org/documents/23470249-aphis-inspection-2016082569219244 |
| lat | 21.2984663 |
| lng | -157.8204149 |
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);