Semantic search

citation_inspection

Table actions

1 row where hash_id = "a8b0260e67575635"

✎ 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

During the review of the most recent Semi-annual Report submitted to the Institutional Official (IO) dated 10/18/23, it was noted that the report was not signed by a majority of the IACUC members. 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 reports shall be reviewed and signed by a majority of the IACUC members prior to being submitted to the IO. This process ensures that all members of the IACUC Committee have an opportunity to review the report and to include any minority views to ensure that the IO is kept informed and provided with accurate information on the status of both the animal use program and the research facilities. This inspection and exit briefing were conducted with facility representatives. *END OF REPORT* n

rowid 75
desc Institutional Animal Care and Use Committee (IACUC).
web_siteName SLATE BLDG & BRITTON BLDG
kind  
Incident hash_id a8b0260e67575635
web_inspectionDate 2024-02-20
code 2.31(c)(3)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 0.0
web_certType Class R - Research Facility
pdf_customer_id 61.0
pdf_customer_name The CT Agriculture Experiment Station
pdf_customer_addr 123 HUNTINGTON STREET BOX 1106 NEW HAVEN, CT 06504
customer_state CT
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/24493611-aphis-inspection-ins-0000928332
lat 41.3306425
lng -72.9199874

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