Semantic search

citation_inspection

Table actions

1 row where hash_id = "4e9ff799b13bb3da"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: web_inspectionDate (date)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

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

CSV options: 

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);