Semantic search
citation_inspection
1 row where hash_id = "cc62b529f5954e12"
This data as json, CSV (advanced)
There was no one available during business hours to allow APHIS Officials to enter and inspect the facilities, property, records, and animals on29-JAN-18 at 1:30 PM. The inspector arrived on campus at 1:30 PM on 1/29/18 to conduct an inspection but the individual authorized to accompany the inspector was not in his/her office. The inspector waited for almost 60 minutes and tried to contact him/her by both phone and e-mail before leaving. An email received after the inspector left the premises confirmed that the contact had left the campus and was unavailable. 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. NOTE - This is the FIRST attempted inspection. Report delivered by e-mail 1/30/18.
| rowid | 42 |
| desc | MISCELLANEOUS. |
| web_siteName | ANIMAL BEHAVIOR LABORATORY |
| kind | |
| Incident hash_id | cc62b529f5954e12 |
| web_inspectionDate | 2018-01-29 |
| code | 2.38(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 39.0 |
| pdf_customer_name | Connecticut College |
| pdf_customer_addr | 270 Mohegan Avenue New London, CT 06320 |
| customer_state | CT |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23470323-aphis-inspection-2016082569030949 |
| lat | 41.3797744 |
| lng | -72.1081272 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);