Semantic search

citation_inspection

Table actions

1 row where hash_id = "80fd82a774acd3ed"

✎ 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

Pigs on an IACUC approved protocol are restricted in farrowing crates for a period of approximately three weeks. The restricted animals are exercised at least once daily during this time. For the period they are in the crates, the pigs' normal postural adjustment are restricted, as they are unable to turn around. This exception to space requirements is noted in the protocol, but has not been included in the Facility's annual report. A summary of all exceptions to the standards and regulations under the Act must be attached to the facility's annual report. An addendum to the annual report including all exceptions shall be submitted. Correct by: July 19, 2014 Exit interview conducted with the IACUC Administrator and other representative personnel. Inspection conducted June 16 - 19, 2014, including site 002.

rowid 882
desc ANNUAL REPORT.
web_siteName CONRAD FARM
kind  
Incident hash_id 80fd82a774acd3ed
web_inspectionDate 2014-06-17
code 2.36(b)(3)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 35.0
web_certType Class R - Research Facility
pdf_customer_id 798.0
pdf_customer_name Indiana University School Of Medicine
pdf_customer_addr 980 Indiana Ave., L V 3315 Indianapolis, IN 46202
customer_state IN
pdf_site_id 005
doccloud_url https://www.documentcloud.org/documents/23474766-aphis-inspection-156141715144886
lat 39.7797659
lng -86.1752156

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