home / aphis_reports

Semantic search

citation_inspection

Table actions
  • Semantic search against this table
  • Semantic search against this table

1 row where hash_id = "b5bc530938262e41"

✎ 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

On July 30th, 2021 ten rhesus macaques escaped from their primary enclosure and into the hallway of the facility. According to facility representatives, the animal care staff employee who was cleaning during the incident did not make sure the latch of the lock was completely secure. The employee was able to return 9 of the rhesus macaques to their primary enclosure. While returning the macaques to their primary enclosure, one juvenile macaque escaped into an uncovered floor drain. The baskets that covered the drain was removed at the time for cleaning. The facility attempted to retrieve the juvenile macaque from the drain, which included digging up the sewer main. The macaque was dead when it was removed from the drain by facility representatives. Handling of all animals shall be done as expeditiously and carefully as possible in a manner that does not cause trauma, physical harm, or unnecessary discomfort. This was corrected by the facility through installation of permanent grates over all drains to prevent animals from entering. Other appropriate corrective actions were taken, which included retraining of all employees that work with the primates at the facility. This inspection and exit interview were conducted with facility representatives. Additional Inspectors: GLORIA MCFADDEN, VETERINARY MEDICAL OFFICER Lemnique Wafer, Assistant DirectorEnd Section

rowid 89
desc Handling of animals.
web_siteName The Johns Hopkins University
kind Critical
Incident hash_id b5bc530938262e41
web_inspectionDate 2021-11-15
code 2.131(b)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 594.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/23470581-aphis-inspection-2016090000748874
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);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 2811.388ms