Semantic search

citation_inspection

Table actions

1 row where hash_id = "4c0ebd56182fff84"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: web_inspectionDate (date)

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

During the review of the semi-annual reports to the Institutional Official, it was noted that the IACUC updated the Semi- annual Report on 2/8/22 and the next update to the report was on 10/4/22, an interval of 8 months between reports instead of at least once every 6 months. Per this Section, one of the functions of the IACUC is to prepare reports of the Committee’s semi-annual evaluations of the program for animal use and its inspection of the facilities; the semi-annual reports to the Institutional Official shall be updated at least once every six months upon completion of the required semiannual evaluations. This process ensures that the Institutional Official is kept informed of the status of both the animal use program and the research facilities. Correct from this date 10/14/22 for all future semi-annual reports to the Institutional Official. This inspection and exit briefing were conducted with facility representatives. *END OF REPORT* n

rowid 63
desc Institutional Animal Care and Use Committee (IACUC).
web_siteName ANIMAL RESEARCH FACILITY
kind  
Incident hash_id 4c0ebd56182fff84
web_inspectionDate 2022-10-13
code 2.31(c)(3)
repeat 0
pdf_insp_type FOCUSED INSPECTION
pdf_animals_total 3.0
web_certType Class R - Research Facility
pdf_customer_id 51.0
pdf_customer_name HARTFORD HOSPITAL
pdf_customer_addr DIR., PRECLINICAL RES. DEPT, CRANE 4, 80 SEYMOUR STREET, P O BOX 5037 HARTFORD, CT 06102
customer_state CT
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470388-aphis-inspection-ins-0000821229
lat 41.752536
lng -72.6802372

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);