home / aphis_reports

Semantic search

citation_inspection

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

2 rows where hash_id = "cdce4529d2d130e8"

✎ 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

*** Protocol 256: A procedure was performed on a species not specified in the approved animal use protocol. Any changes to a protocol must be reviewed and approved by the IACUC prior to conducting any activity associated with the change. An IACUC review of protocol changes is to ensure that animals do not experience unnecessary pain and distress and to verify that personnel are adequately trained to handle and conduct procedures on a particular specied. The IACUC must amend the protocol to include goats as a species and/or implement appropriate procedures to ensure protocol changes are reviewed and approved by the IACUC for all protocol deviations involving the use of animals. Correct by May 30, 2014. NOTE: The goat did not experience any pain or distress as it was a terminal procedure performed under anesthesia.

rowid 165
desc INSTITUTIONAL ANIMAL CARE AND USE COMMITTEE (IACUC).
web_siteName SPRING VALLEY LABORATRORIES, INC.
kind  
Incident hash_id cdce4529d2d130e8
web_inspectionDate 2014-04-08
code 2.31(c)(7)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 142.0
web_certType Class R - Research Facility
pdf_customer_id 96.0
pdf_customer_name Spring Valley Laboratories Inc
pdf_customer_addr P.O. Box 242 Woodbine, MD 21797
customer_state MD
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470703-aphis-inspection-98140959382038
lat 39.3738173
lng -77.0569038

***Protocol 229: Rabbits on the study failed to receive a prescribed medical treatment for a day and a half. Treatment for a medical condition must be adminsiterd as indicated by the atending veterinarian. Personnel must be trained on the procedures for identifying animals on treatment according to facility standard operating procedures to ensure the veterinarian's prescribed treatment is administered in a timely manner. Correct by April 18, 2014 An exit briefing was conducted with the facility representatives.

rowid 166
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName SPRING VALLEY LABORATRORIES, INC.
kind  
Incident hash_id cdce4529d2d130e8
web_inspectionDate 2014-04-08
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 142.0
web_certType Class R - Research Facility
pdf_customer_id 96.0
pdf_customer_name Spring Valley Laboratories Inc
pdf_customer_addr P.O. Box 242 Woodbine, MD 21797
customer_state MD
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470703-aphis-inspection-98140959382038
lat 39.3738173
lng -77.0569038

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