Semantic search
citation_inspection
1 row where hash_id = "d933639e970120f8"
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 on20-JUN-17 at 12:00. On June 20, 2017 the USDA inspector attempted to reach the IACUC Administrator upon arrival to the facility and received information from the security desk at St. Elizabeth Hospital that the company has been closed since August 2015. The USDA inspector emailed Genesys representatives and the emails were sent back as invalid addresses. This inspection and exit interview could not be conducted since the facility is no longer there.
| rowid | 170 |
| desc | MISCELLANEOUS. |
| web_siteName | GENE SYS RESEARCH INSTITUTE |
| kind | |
| Incident hash_id | d933639e970120f8 |
| web_inspectionDate | 2017-06-20 |
| code | 2.38(b) |
| repeat | 1 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 99.0 |
| pdf_customer_name | Gene Sys Research Institute |
| pdf_customer_addr | 736 Cambridge Street , C B R 406 Boston, MA 02135 |
| customer_state | MA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23470709-aphis-inspection-2016082568423073 |
| lat | 42.34907310000001 |
| lng | -71.14825139999999 |
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);