Semantic search
citation_inspection
1 row where hash_id = "5f648df2aded7e07"
This data as json, CSV (advanced)
The USDA Annual Report filed for Fiscal Year 2021 incorrectly accounts for the pigs. The number of pigs used in research/teaching was stated in column C (no pain, distress or use of pain-relieving drugs) instead of the correct column D (accompanying pain or distress to the animals for which appropriate anesthetic, analgesic or tranquilizing drugs were used). The pigs were used in surgical procedures. Properly identifying animals used in research on the annual report is necessary to inform the Institutional Official and USDA Animal Care of the scope and extent of the animal use at the facility. The 2021 annual report needs to be amended and resubmitted to USDA Animal Care with all animal use data accurately included. Correct by July 31, 2022. This inspection and exit interview were conducted with the IACUC representative. End Section
| rowid | 35 |
| desc | Annual report. |
| web_siteName | COLLEGE OF MEDICINE |
| kind | |
| Incident hash_id | 5f648df2aded7e07 |
| web_inspectionDate | 2022-06-15 |
| code | 2.36(b)(6) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 29.0 |
| pdf_customer_name | UNIVERSITY OF TENNESSEE - CHATTANOOGA |
| pdf_customer_addr | 975 EAST THIRD ST. BOX 339 CHATTANOOGA, TN 37403 |
| customer_state | TN |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23470293-aphis-inspection-2016090000797873 |
| lat | 35.0482996 |
| lng | -85.29096059999999 |
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);