Semantic search

citation_inspection

Table actions

1 row where hash_id = "9073d48399cb4d7e"

✎ 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 June 16th 2021, a rhesus macaque was found dead, entrapped in the cable used to open and close the shift door of its primary enclosure. According to a facility representative and the facility’s review of the incident, the clasp used to secure the cable and keep the shift door closed may not have been positioned correctly, creating laxity in the cable. The animal, while in its enclosure, was able to get caught in the cable resulting in injury. Primary enclosures must be constructed and maintained so that nonhuman primates are protected from injury. This item was corrected by the IACUC through a temporary and immediate redesign of the door mechanism and retraining animal care staff on new husbandry practices. The facility is also in the process of replacing all shift doors with a new type. This inspection and exit interview were conducted with facility representatives. This inspection was conducted from 06/17/2021 to 06/21/2021. Additional Inspectors: GLORIA MCFADDEN, VETERINARY MEDICAL OFFICEREnd Section

rowid 88
desc Primary enclosures.
web_siteName The Johns Hopkins University
kind Critical
Incident hash_id 9073d48399cb4d7e
web_inspectionDate 2021-06-17
code 3.80(a)(2)(ii)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 658.0
web_certType Class A - Breeder
pdf_customer_id 81.0
pdf_customer_name THE JOHNS HOPKINS UNIVERSITY
pdf_customer_addr 265 GARLAND HALL 3400 N CHARLES STREET BALTIMORE, MD 21218
customer_state MD
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470578-aphis-inspection-2016090000639436
lat 39.3273434
lng -76.62155039999999

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