Semantic search

citation_inspection

Table actions

1 row where hash_id = "7060bed47f98f526"

✎ 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

The facility personnel reported three seperate adverse events under protocol #79 since June of 2013. In each case the IACUC investigated and took corrective action which included approving amendments to the protocol. The amendments were not incorporated into the most recent version of the Protocol. The protocol that is printable for distribution must have the most recent updates and be followed as written to assure that the animals are being handled in the manner approved by the IACUC. This assures that the needs of the animals have, and will be, addressed by the facility. Correct from this point forward. An exit briefing was conducted with the IACUC Chair

rowid 122
desc INSTITUTIONAL ANIMAL CARE AND USE COMMITTEE (IACUC).
web_siteName SINAI HOSPITAL OF BALTIMORE
kind  
Incident hash_id 7060bed47f98f526
web_inspectionDate 2014-06-03
code 2.31(c)(4)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 2.0
web_certType Class R - Research Facility
pdf_customer_id 85.0
pdf_customer_name Sinai Hospital Of Baltimore Inc
pdf_customer_addr Department Of Research 2401 W Belveder Ave Schapiro Bldg, Suite 203 Baltimore, MD 21215
customer_state MD
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470617-aphis-inspection-154141512150087
lat 39.3416271
lng -76.68169619999999

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