Semantic search
citation_inspection
3 rows where hash_id = "ed2ddcb8cccd19da"
This data as json, CSV (advanced)
In the enclosure housing 8 sheep at the Multipurpose Building, there was a wooden shelter with a broken side. The broken edges were jagged and there were protruding wires with sharp points. These jagged edges and wires could cause injury to the sheep living in this enclosure. All housing facilities shall be structurally sound and maintained in good repair to protect the animals from injury. TO BE CORRECTED BY 28 AUGUST 2020.
rowid | 17 |
desc | FACILITIES, GENERAL. |
web_siteName | UNIVERSITY OF WYOMING |
kind | |
Incident hash_id | ed2ddcb8cccd19da |
web_inspectionDate | 2020-08-18 |
code | 3.125(a) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 28.0 |
web_certType | Class R - Research Facility |
pdf_customer_id | 16.0 |
pdf_customer_name | University Of Wyoming |
pdf_customer_addr | 1000 East University Avenue, Dept. 3355 Laramie, WY 82071 |
customer_state | WY |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23470200-aphis-inspection-2016082569869152 |
lat | 41.3139679 |
lng | -105.5845168 |
In the enclosure housing 8 sheep at the Multipurpose Building, there were dirty water receptacles. The inside walls of the water receptacles were coated in a green brown material and there was a layer of sediment along the bottom. This sediment appeared to consist of dirt, feed, grass, and other debris. These two receptacles were the only access to water in the enclosure. Dirty water receptacles can lead to disease or contamination. All water receptacles must kept clean and sanitary. TO BE CORRECTED BY 28 AUGUST 2020.
rowid | 18 |
desc | WATERING. |
web_siteName | UNIVERSITY OF WYOMING |
kind | |
Incident hash_id | ed2ddcb8cccd19da |
web_inspectionDate | 2020-08-18 |
code | 3.130 |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 28.0 |
web_certType | Class R - Research Facility |
pdf_customer_id | 16.0 |
pdf_customer_name | University Of Wyoming |
pdf_customer_addr | 1000 East University Avenue, Dept. 3355 Laramie, WY 82071 |
customer_state | WY |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23470200-aphis-inspection-2016082569869152 |
lat | 41.3139679 |
lng | -105.5845168 |
At the Red Buttes animal facility, an enclosure housing chipmunks had a large amount of overgrown vegetation surrounding the enclosure. On two sides of the enclosure, the vegetation completely obscured the enclosure walls from the outside. In order to see into the enclosure, the inspector had to stand on a gate due to the height and density of the weeds. This amount of overgrowth does not allow for proper visualization of the enclosure walls to ensure that it is in good repair nor does it allow easy visualization of the animals within the enclosure. Overgrown vegetation can also be an area for pests or predators to live in, which could lead to disease or injury of the chipmunks within. The premises must be kept clear of weeds and in good repair in order to protect the animals from injury and to facilitate proper husbandry practices. TO BE CORRECTED BY 28 AUGUST 2020. This inspection was conducted on 8/18/2020 and the exit interview was conducted on 8/19/2020 with facility representatives.
rowid | 19 |
desc | SANITATION. |
web_siteName | UNIVERSITY OF WYOMING |
kind | |
Incident hash_id | ed2ddcb8cccd19da |
web_inspectionDate | 2020-08-18 |
code | 3.131(c) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 28.0 |
web_certType | Class R - Research Facility |
pdf_customer_id | 16.0 |
pdf_customer_name | University Of Wyoming |
pdf_customer_addr | 1000 East University Avenue, Dept. 3355 Laramie, WY 82071 |
customer_state | WY |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23470200-aphis-inspection-2016082569869152 |
lat | 41.3139679 |
lng | -105.5845168 |
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);