home / aphis_reports

Semantic search

citation_inspection

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

1 row where hash_id = "842352fe70a26487"

✎ 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

In April 2021, the Attending Veterinarian was reviewing surgical records of voles with telemetry devices implanted for behavior studies. Upon reviewing the records, the Attending Veterinarian identified 11 voles that had gone through the telemetry implant surgery from March 30th to April 2nd. According to the IACUC approved protocol, only 8 voles were supposed to be used. The Principal Investigator had not submitted an amendment to the IACUC for this change in animals. Proposed activities and proposed significant changes in ongoing activities that have been approved by the IACUC may be subject to further review and approval. Any changes in activity that involves the care and use of animals must be approved by the IACUC. This was corrected at the time of inspection by the Attending Veterinarian retraining the Principal Investigator and the IACUC approving an amendment to increase animal numbers. This inspection and exit interview were conducted with Attending Veterinarian. End Section

rowid 50
desc Institutional Animal Care and Use Committee (IACUC).
web_siteName UNIVERSITY OF DELAWARE
kind  
Incident hash_id 842352fe70a26487
web_inspectionDate 2022-02-01
code 2.31(d)(8)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 350.0
web_certType Class R - Research Facility
pdf_customer_id 45.0
pdf_customer_name UNIVERSITY OF DELAWARE
pdf_customer_addr 79 E DELAWARE AVENUE NEWARK, DE 19711
customer_state DE
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23470353-aphis-inspection-2016090000767938
lat 39.6819421
lng -75.7501065

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