Semantic search

citation_inspection

Table actions

2 rows where hash_id = "7db1f28beba52638"

✎ 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

On the facility semiannual inspection report, there is a list of "areas of concern" from the IACUC. However, there is no indication of the severity of these "concerns", nor is there a correction date or plan for any of these. These semiannual reports must distinguish any deviations from the animal welfare act, must distinguish minor from significant deficiencies, and must assign a reasonable correction date for any deficiencies. Correct from this date forward.

rowid 1994
desc INSTITUTIONAL ANIMAL CARE AND USE COMMITTEE (IACUC).
web_siteName MURRAY STATE COLLEGE
kind  
Incident hash_id 7db1f28beba52638
web_inspectionDate 2014-07-22
code 2.31(c)(3)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 0.0
web_certType Class R - Research Facility
pdf_customer_id 1389.0
pdf_customer_name Murray State College
pdf_customer_addr One Murray Campus Ste V T 100 Tishomingo, OK 73460
customer_state OK
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23477931-aphis-inspection-206141206180046
lat 34.2232909
lng -96.6785359

The facility's annual report only lists 2 cats as being used for the previous year (2013.) Records of acquisition and disposition show that at least 36 dogs and 1 additional cat were used in fall of 2013, alone. The annual report must list the common names and the numbers of animals used for experiments, teaching, research, surgery, or tests. Correct from this date forward. Inspection and exit interview conducted with facility representative.

rowid 1995
desc ANNUAL REPORT.
web_siteName MURRAY STATE COLLEGE
kind  
Incident hash_id 7db1f28beba52638
web_inspectionDate 2014-07-22
code 2.36(b)(6)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 0.0
web_certType Class R - Research Facility
pdf_customer_id 1389.0
pdf_customer_name Murray State College
pdf_customer_addr One Murray Campus Ste V T 100 Tishomingo, OK 73460
customer_state OK
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23477931-aphis-inspection-206141206180046
lat 34.2232909
lng -96.6785359

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