home / aphis_reports

Semantic search

citation_inspection

Table actions
  • Semantic search against this table
  • Semantic search against this table

3 rows where hash_id = "ed2ddcb8cccd19da"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

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);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 3827.269ms