Semantic search

citation_inspection

Table actions

2 rows where hash_id = "c89c47c53f1b0911"

✎ 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

***Protocols A & B: Minimally invasive procedures are performed on guinea pigs or ferrets that require anesthesia to prevent distress and/or pain. However, a search to determine if there are alternatives for such procedures were not conducted. The principal investigator should consider alternatives to procedures that may cause more than momentary pain or distress and provide a written narrative description of the methods and sources used to determine that alternatives were not available. The protocols must be amended to include a search that indicates alternatives to the procedures are not available. Correct by July 30, 2015

rowid 146
desc INSTITUTIONAL ANIMAL CARE AND USE COMMITTEE (IACUC).
web_siteName UNIVERSITY OF MARYLAND COLLEGE PARK
kind  
Incident hash_id c89c47c53f1b0911
web_inspectionDate 2015-06-30
code 2.31(d)(1)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 160.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/23470657-aphis-inspection-181150827581835
lat 38.9869183
lng -76.9425543

*** The Peromyscus mice are housed in open top cages in a room with air conditioning. However, there is a strong urine smell in the room. To minimize strong odors, the room should be provided with fresh air or an effective method to move the air should be implemented. Measures must be taken to adequately ventilate the room for the health and comfort of the animals. Correct by July 9, 2015. NOTE: Cages are scheduled to be changed the next day. The exit briefing was conducted with the facility representative.

rowid 147
desc FACILITIES, INDOOR.
web_siteName UNIVERSITY OF MARYLAND COLLEGE PARK
kind  
Incident hash_id c89c47c53f1b0911
web_inspectionDate 2015-06-30
code 3.126(b)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 160.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/23470657-aphis-inspection-181150827581835
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);