Semantic search
citation_inspection
1 row where hash_id = "a535c7bd2a91bb3d"
This data as json, CSV (advanced)
The Semi-annual Report to the Institutional Official references only the Program Review function in its title, and contains no information relating to the facility inspection function of the committee. The report is intended to encompass all functions of the committee and must provide information on both the semi-annual program review and semi-annual facility inspections that have been completed during the reporting period. All future reports must meet the regulatory requirements. An exit interview was conducted with a facility representative.
| rowid | 19131 |
| desc | INSTITUTIONAL ANIMAL CARE AND USE COMMITTEE (IACUC). |
| web_siteName | ATSCC |
| kind | |
| Incident hash_id | a535c7bd2a91bb3d |
| web_inspectionDate | 2014-08-14 |
| code | 2.31(c)(3) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 31678.0 |
| pdf_customer_name | Atscc |
| pdf_customer_addr | 1030 S. Centerville Turnpike Chesapeake, VA 23322 |
| customer_state | VA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23511143-aphis-inspection-226141141220288 |
| lat | |
| lng |
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);