Semantic search

citation_inspection

Table actions

1 row where hash_id = "c14125ba5346e5c4"

✎ 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

At the south farm, a goat was observed to jump up onto the ledge of the concrete foundation and move from pen 4 over to pen 5 and then back to pen 4 again. There was a panel up on the ledge in place to prevent this, however the goat could pass between the vertical supports of the panel. Also, the panel had some free ends of wire that if bent out could become sharp points exposed to any goat that climbs up on the concrete ledge. Lack of proper containment and exposure to sharp points could lead to injury or other adverse events. The facility must ensure that enclosures are structurally sound and maintained in good repair to contain the animals and protect them from injury. Correct by October 5, 2016. This inspection and exit interview were conducted with facility representatives on 9/26 thru 9/27/2016.

rowid 1
desc FACILITIES, GENERAL.
web_siteName UTAH STATE UNIVERSITY
kind  
Incident hash_id c14125ba5346e5c4
web_inspectionDate 2016-09-26
code 3.125(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 653.0
web_certType Class R - Research Facility
pdf_customer_id 2.0
pdf_customer_name Utah State University
pdf_customer_addr V.P. For Research/1450 Old Main Hill Logan, UT 84322
customer_state UT
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470072-aphis-inspection-2016082567941113
lat 41.7421403
lng -111.809059

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