Semantic search
citation_inspection
1 row where hash_id = "4e9ff799b13bb3da"
This data as json, CSV (advanced)
The bales of hay being fed to 66 ewes and 65 lambs are being stored outside, with no protection from the elements. At the time of inspection, there was an opened bale of hay that was being fed to these sheep. There were several moldy portions of hay within this bale and an entire side of the bale was bleached in color and covered with mud and debris. Uncovered or improperly stored food can become contaminated by insects, vermin, bacteria, or mold. Ingestion of this contaminated food can lead to animal illness or disease. Supplies of food and bedding shall be stored in facilities which adequately protect such supplies against deterioration, molding, or contamination by vermin. To be corrected by: September 14, 2017 This inspection was conducted with the attending veterinarian and the exit interview was conducted with the attending veterinarian, associate vice president, and two facility staff.
| rowid | 14 |
| desc | FACILITIES, GENERAL. |
| web_siteName | UNIVERSITY OF WYOMING |
| kind | |
| Incident hash_id | 4e9ff799b13bb3da |
| web_inspectionDate | 2017-08-31 |
| code | 3.125(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 131.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/23470195-aphis-inspection-2016082568771610 |
| 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);