Semantic search

citation_inspection

Table actions

1 row where hash_id = "7bef52ccdb4f397f"

✎ 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

***The registrant self reported an incidence in which bats did not receive a prescribed treatment in a timely manner. An increase mortality rate was noticed in the bat colony. Based upon the results of the necropsies, the attending veterinarian prescribed a treatment to prevent further illness. Directions for administering the treatment were given to the research staff on December 20, 2014. Treatment was not provided to the affected bats until January 7, 2014. Bats did not receive treatment for 3 weeks and additional bats died before the treatment was started. The delay in treatment was detemined to be the result of miscommunication. A system must be in place to ensure direct and frequent communication with the attending veterinarian to ensure timely and accurate treatment for all illnesses. The IACUC took timely and appropriate corrective action to prevent a reccurence of such incidents. The exit briefing was conducted with the facility presentative.

rowid 145
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE.
web_siteName UNIVERSITY OF MARYLAND COLLEGE PARK
kind  
Incident hash_id 7bef52ccdb4f397f
web_inspectionDate 2014-09-04
code 2.33(b)(3)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 135.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/23470656-aphis-inspection-246140516230582
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);