home / aphis_reports

Semantic search

citation_inspection

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

1 row where hash_id = "ee03723d618834b0"

✎ 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 7-15-16 a breeding cage of peromyscus was found in the afternoon with an empty water bottle and one dead adult and one dead pup. The other adult and two pups were treated, but died the next day. This strain of peromyscus is particularly sensitive to environmental changes. The assigned caretaker failed to make health checks to assure all animals had food and water. Water bottles in this facility were periodically leaking, so the staff was told to be particularly attentive to the water bottles. The animal caretaker failed to provide adequate observation and care of the animals assigned to her and this resulted in distress and death of five animals. The facility took multiple corrective actions by thoroughly investigating the incident, replacing the caretaker, retraining all staff in proper procedures for daily health checks, replacing the water bottles, and moving the animals to a possibly quieter room. This item is found to be corrected at this inspection since no further incidents have occurred in the past year. This inspection and exit interview were conducted with the Attending Veterinarian and IACUC staff.

rowid 148
desc MISCELLANEOUS.
web_siteName UNIVERSITY OF MARYLAND COLLEGE PARK
kind Critical
Incident hash_id ee03723d618834b0
web_inspectionDate 2017-07-13
code 2.38(f)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 291.0
web_certType Class R - Research Facility
pdf_customer_id 91.0
pdf_customer_name University Of Maryland College Park
pdf_customer_addr Director Laboratory Animal Care College Park Campus College Park, MD 20742
customer_state MD
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470659-aphis-inspection-2016082568553139
lat 38.9869183
lng -76.9425543

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 7413.244ms