Semantic search

citation_inspection

Table actions

1 row where hash_id = "40c497f8e3fbf7b3"

✎ 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

There was no one available during business hours to allow APHIS Officials to enter and inspect the facilities, property, records, and animals on29-JAN-20 at 1:15 PM. The inspector arrived on campus at 1:15 PM on 1/29/20 to conduct an inspection but the individual authorized to accompany the inspector was not in his/her office. The inspector tried to contact him/her by text messages and waited for almost 60 minutes before leaving. An AWA compliance inspection could not be conducted because there was no other authorized facility representative available to accompany the inspector. Unannounced inspections to determine compliance with the provisions of the AWA are required to assess the facility. Correct from this date forward by providing inspector with alternate points of contact and schedule of availability. NOTE - This is the FIRST attempted inspection. Report delivered by e-mail 1/30/20.

rowid 55
desc MISCELLANEOUS.
web_siteName QUINNIPIAC UNIVERSITY
kind  
Incident hash_id 40c497f8e3fbf7b3
web_inspectionDate 2020-01-29
code 2.38(b)
repeat 0
pdf_insp_type ATTEMPTED INSPECTION
pdf_animals_total 0.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/23470361-aphis-inspection-2016082569711787
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);