Semantic search

citation_inspection

Table actions

1 row where hash_id = "dd83c72e0a3d02ce"

✎ 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

Recordkeeping for Reports to Institutional Official. 1. There was no copy of the semi-annual IACUC report to the Institutional Official (IO) available for review at time of the inspection for the report submitted to the IO for the semi-annual review of the Program for Animal Care and Use and the semi-annual inspection of the animal facilities that were conducted by the IACUC in the Fall of 2015. Per this Section of the Regulations, copies of the semi-annual reports prepared by the IACUC and submitted to the IO should be maintained and available at the time of an inspection so the required records can be reviewed to determine the compliance of the research facility with the provisions of the AWA. Correct from this date forward for all past and future IACUC semi-annual reports to the Institutional Official. NOTE - Exit interview held on-site 3/31/16 with facility representative. Report delivered by e-mail 4/4/16. *END OF REPORT*

rowid 54
desc RECORDKEEPING REQUIREMENTS.
web_siteName QUINNIPIAC UNIVERSITY
kind  
Incident hash_id dd83c72e0a3d02ce
web_inspectionDate 2016-03-31
code 2.35(a)(3)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 126.0
web_certType Class R - Research Facility
pdf_customer_id 46.0
pdf_customer_name Quinnipiac University
pdf_customer_addr 275 Mount Carmel Avenue Hamden, CT 06518
customer_state CT
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470357-aphis-inspection-91161959010611
lat 41.4197818
lng -72.8915502

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