Semantic search

citation_inspection

Table actions

1 row where hash_id = "ef7e9038e7df48d1"

✎ 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

A protocol involving sheep that was approved by the IACUC did not completely list all procedures that were performed and potential side effects of the pulmonary function tests. These tests were performed 20 times on 13 lambs from January to April 2017. Failure to include all procedures and potential side effects does not allow the IACUC to undertake a complete and thorough review of animal use to ensure humane care and use of animals. The protocol was amended and has since been been renewed and approved by the IACUC to include all testing procedures, potential side effects and steps to take to reduce risk and manage/treat side effects. Corrected prior to the inspection. This inspection and exit interview were conducted with facility representatives on 5/24/18. Additional Inspectors Schnell Michael, Veterinary Medical Officer

rowid 8
desc INSTITUTIONAL ANIMAL CARE AND USE COMMITTEE (IACUC).
web_siteName UNIVERSITY OF UTAH
kind  
Incident hash_id ef7e9038e7df48d1
web_inspectionDate 2018-05-23
code 2.31(e)(3)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 369.0
web_certType Class R - Research Facility
pdf_customer_id 12.0
pdf_customer_name University Of Utah
pdf_customer_addr Office Of Comparative Medicine 75 South 2000 East, Suite 311 Salt Lake City, UT 84112
customer_state UT
pdf_site_id 003
doccloud_url https://www.documentcloud.org/documents/23470154-aphis-inspection-2016082569157934
lat 40.76788699999999
lng -111.8326796

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