Semantic search
citation_inspection
1 row where hash_id = "ec026eecdfd00798"
This data as json, CSV (advanced)
A new caretaker panicked when he observed a marmoset attempting to leave the cage and he closed the door while the animal was in the doorway inadvertently causing an injury. The incident was immediately reported to the supervisor and veterinarian. The veterinarian promptly examined the animal but was unable to resuscitate the marmoset. Personnel working with marmosets must be trained on marmoset behavior and how to appropriately handle the animals in an escape situation. Correction: The Standard Operating Procedure for "Marmoset Husbandry and Maintenance" was revised and all personnel involved in marmoset care were trained on the new procedures. Training emphasized keeping calm and contacting the supervisor for assistance in the safe return of an escaped marmoset. This inspection and exit interview were conducted with the facility representatives.
| rowid | 102 |
| desc | PERSONNEL QUALIFICATIONS. |
| web_siteName | JOHNS HOPKINS UNIVERSITY, THE |
| kind | |
| Incident hash_id | ec026eecdfd00798 |
| web_inspectionDate | 2019-06-10 |
| code | 2.32(c)(1)(ii) |
| repeat | 0 |
| pdf_insp_type | FOCUSED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class R - Research Facility |
| 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 | 003 |
| doccloud_url | https://www.documentcloud.org/documents/23470592-aphis-inspection-2016082569509534 |
| lat | 39.3273434 |
| lng | -76.62155039999999 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);