After over two years of public reporting, the State Profile Report will no longer be produced and distributed after February 2023. The final release was on February 23, 2023. We want to thank everyone who contributed to the design, production, and review of this report and we hope that it provided insight into the data trends throughout the COVID-19 pandemic. Data about COVID-19 will continue to be updated at CDC’s COVID Data Tracker.

The State Profile Report (SPR) is generated by the Data Strategy and Execution Workgroup in the Joint Coordination Cell, in collaboration with the White House. It is managed by an interagency team with representatives from multiple agencies and offices (including the United States Department of Health and Human Services (HHS), the Centers for Disease Control and Prevention, the HHS Assistant Secretary for Preparedness and Response, and the Indian Health Service). The SPR provides easily interpretable information on key indicators for each state, down to the county level.

It is a weekly snapshot in time that:

• Focuses on recent outcomes in the last seven days and changes relative to the month prior
• Provides additional contextual information at the county level for each state, and includes national level information
• Supports rapid visual interpretation of results with color thresholds

Daily situation for Tennessee counties as reported by the Tennessee Department of Health. The data are posted on the department's coronavirus disease web page: https://www.tn.gov/health/cedep/ncov.html. Date on testing results and deaths was posted beginning March 31, 2020.CountyNS (County GNIS code)NAMELSAD (Legal/statistical area) -County of residence of COVID-19 casesCounty identifier (GEOID) - County FIPS codeCombined statistical area code (CBSAFP) - Metropolitan/Micropolitan Area codeCore-based area name (CBSA_TITLE) - Metropolitan/Micropolitan Area nameCore-based statistical area type (MSA_TYPE) - Core-based statistical area typeCore-based area county type (MSA_COUNTY_TYPE) - Type of county in core-based statistical areasHealth Department Region (HEALTH_DEPT_REG)Health Department Type (HEALTH_DEPT_TYPE)TN ECD Urban Rural Classification (ECD_URBAN_RURAL_CLASS)Positive Tests (TEST_POS) - Total number of people ever to test positive for COVID-19Negative Tests (TEST_NEG) - Total number of people with a negative COVID-19 test resultTotal Tests (TEST_TOT) - Total number of COVID-19 tests with reported resultNew Tests (TEST_NEW) - Number of new tests results posted since the previous dayTotal Cases (CASES_TOT) - Total number of people ever to have a confirmed or probably case of COVID-19 by countyNew Cases (CASES_NEW) - The number of new cases reported to have a confirmed case of COVID-19 since the report on the previous dayTotal Hospitalizations (HOSPITALIZED_TOT) - Number of patients that were ever hospitalized during their illness, it does not indicate the number of patients currently hospitalizeNew Hospitalizations (HOSPITALIZED_NEW) - Number of patients that were ever hospitalized in the previous 24-hour period. Does not indicate the number of patients currently hospitalizedTotal Recovered (RECOV_TOT) - Total Number of inactive/recovered COVID cases. Includes people 14 days beyond illness onset date, specimen collection date, investigation report date, or investigation start date.New Recovered (RECOV_NEW) - Change in the number of new inactive/recovered cases since the previous day.Total Deaths (DEATHS_TOT) - Number of COVID-19 related deaths that were ever reported by countyNew Deaths (DEATHS_NEW) - Number of COVID-19 related deaths that were reported since the previous dayActive Cases (ACTIVE_TOT) - Calculated as the total number of confirmed COVID-19 cases, less the number of recovered and deaths reportedNew Active Cases (ACTIVE_NEW) - Change in the number of active COVID-19 cases since the previous dayPopulation Estimate 2019 (POPESTIMATE2019) - 2019 vintage estimated population for counties by the U.S. Census BureauNOWcast Current (NOWCast_CURRENT) - UTK COVID-19 NOWCast estimate of the number of new daily casesEffective Rate Transmission (EffectiveR) - Effective reproduction or R is an estimate of the average number of new infections caused by a single infected individualEffect Rate Transmission Label (EffectiveR_LABEL)

Daily COVID data for all of TN. Source dataset can be found here: https://www.tn.gov/health/cedep/ncov/data/downloadable-datasets.html Data dictionary provided by TN Department of Health download link: https://www.tn.gov/content/dam/tn/health/documents/cedep/novel-coronavirus/datasets/Public-Dataset-Data-Dictionary.xlsx

Updated daily count of confirmed COVID-19 cases by county in Tennessee. The dataset includes metrics on cases per 100,000, number of deaths per county, and number of negative tests per county. Data is updated daily at 2 pm from TN DOH.

View daily updates and historical trends for Tennessee Coronavirus Full Vaccination Rate. Source: Our World in Data. Track economic data with YCharts anal…

COVID data in TN aggregated by age, county, and date. Source dataset can be found here: https://www.tn.gov/health/cedep/ncov/data/downloadable-datasets.html

Title: Tracing the Curves: An Analysis of Tennessee COVID-19-Related Deaths By Occupation and Industry Authors: KaeChandra Weyenberg, Sarah Waldo, Benjamin Crumpler, and Nickie Brillon CEDEP Program: COVID Product type: abstract and poster Conference, meeting, or publication accepted to: CSTE

Dataset includes information on COVID-19 testing sites in the state of Tennessee across different counties and cities, the accessibility of these testing sites, hours of operation, and availability.

This dataset tracks the updates made on the dataset "COVID-19 State Profile Report - Tennessee" as a repository for previous versions of the data and metadata.

View daily updates and historical trends for Tennessee Coronavirus Deaths (DISCONTINUED). Source: Center for Disease Control and Prevention. Track economi…

Demographic vaccination data by county and date in TN

Data about the age of people with confirmed cases of COVID-19 was provided as part of the daily updates released by the Tennessee Department of Heath beginning on March 17, 2020. They are posted to the department's coronavirus disease web page: https://www.tn.gov/health/cedep/ncov.html. The counts are broken into 10-year age bands and are provided at the statewide-level. Date (DATE) - Date of report Age (AGE) - 10-year age breakdown of confirmed COVID-19 cases in Tennessee Total Case Count (TOT_CASE_COUNT) - Total number of people ever to have a confirmed case of COVID-19 in a given age range Share of Total Cases (SHARE_CASE_TOT) - For the given date, the share of people in a given age range as a proportion of the total number of people ever to have a confirmed case of COVID-19 New Case Count (NEW_CASE_COUNT) - The number of new cases reported to have a confirmed case of COVID-19 in a given age range since the report on the previous day Share of new cases (SHARE_NEW_CASES) - The share of people in a given age range reported as having a new confirmed case of COVID-19 in proportion to the total number of new cases reported since the previous day Total Deaths (DEATHS_TOT) - Number of COVID-19 related deaths that were ever reported for the age groupNew Deaths (DEATHS_NEW) - Number of COVID-19 related deaths that were reported since the previous dayShare of total deaths (SHARE_DEATHS_TOTAL) - Share of COVID-19 related deaths for the age group as percentage of the total reports deathsFID - Auto-generated unique feature ID. The classification of the age ranges changed has varied slightly. On March 17th and 18th, data was provided for five age ranges. This was expanded to the current 10-year age classifications on March 19th.Local health departments may provide additional county-level data.

View daily updates and historical trends for Tennessee Coronavirus Cases (DISCONTINUED). Source: Center for Disease Control and Prevention. Track economic…

Title: COVID-19 Delta and Omicron Hospitalization and Case Fatality in Tennessee Background Authors: Grace Kambach, Sarah Waldo, Chaitra Subramanya, Jennifer Jain, Jane Yackley, Vanessa Davis, Jennifer Wang, and Zoe W. Durand CEDEP Program: COVID Product type: abstract and presentation Conference, meeting, or publication accepted to: TPHA

Context

TN gov has generated daily report for Covid-19 case details. Need to extract few information in structured from unstructured format.

Content

Here, we can full details about TN covid-19 cases. However, we are trying to change few unstructured information to structured format(table).

Acknowledgements

We wouldn't be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.

Inspiration

Your data will be in front of the world's largest data science community. What questions do you want to see answered?

Daily situation summary as reported by the Tennessee Department of Health. The data are posted on the department's coronavirus disease web page: https://www.tn.gov/health/cedep/ncov.html. As additional cases were reported in the state, additional data was released including test results, hospitalizations and recoveries.Date (DATE) - Date of reportTotal Confirmed Case (CASES_TOT) - Total number of people ever to have a confirmed case of COVID-19 in TennesseeNew Confirmed Cases (CASES_NEW) - The number of new cases reported to have a confirmed case of COVID-19 since the report on the previous dayRate of change 1-day (RATE_CHG_1DAY) - Percentage change in the total number of cases of COVID-19 since the previous dayRate of change 3-day (RATE_CHG_3DAY) - 3-day rate of change calculated as the compound growth ratePositive Tests (TEST_POS) - Total number of people ever to test positive for COVID-19Negative Tests (TEST_NEG) - Total number of people with a negative COVID-19 test resultTotal Tests (TEST_TOT) - Total number of COVID-19 tests with reported resultNew Tests (TEST_NEW) - Number of new tests results posted since the previous dayTotal Hospitalizations (HOSPITALIZED_TOT) - Number of people who were ever hospitalized due to COVID-19 diseaseNew Hospitalizations Last Day (HOSPITALIZED_NEW) - Number of people hospitalized due to COVID-19 disease since the previous dayTotal Recovered (RECOV_TOT) - Number of people recoveredNew Recovered (RECOV_NEW) - Number of new people recovered since previous dayTotal Deaths (DEATHS_TOT) - Number of COVID-19 related deaths that were ever reportedNew Deaths (DEATHS_NEW) - Number of COVID-19 related deaths that were reported since the previous dayActive Cases (ACTIVE_TOT) - Calculated as the total number of confirmed COVID-19 cases, less the number of recovered and deaths reportedNew Actives Cases (ACTIVE_NEW) - Change in the number of active COVID-19 cases since the previous day.FID - Auto-generated unique feature ID

United States Excess Deaths excl COVID: Predicted: Avg No. of Deaths: Tennessee data was reported at 1,530.000 Number in 16 Sep 2023. This records an increase from the previous number of 1,525.000 Number for 09 Sep 2023. United States Excess Deaths excl COVID: Predicted: Avg No. of Deaths: Tennessee data is updated weekly, averaging 1,484.000 Number from Jan 2017 (Median) to 16 Sep 2023, with 350 observations. The data reached an all-time high of 1,680.000 Number in 14 Jan 2023 and a record low of 1,329.000 Number in 29 Jul 2017. United States Excess Deaths excl COVID: Predicted: Avg No. of Deaths: Tennessee data remains active status in CEIC and is reported by Centers for Disease Control and Prevention. The data is categorized under Global Database’s United States – Table US.G012: Number of Excess Deaths: by States: All Causes excluding COVID-19: Predicted (Discontinued).

View daily updates and historical trends for Tennessee Coronavirus Tests Administered Per Day. Source: US Department of Health & Human Services. Track eco…

Data pulled from THD website https://www.tn.gov/health/cedep/ncov/data/downloadable-datasets.html

Title: Navigating cross-sector collaborations for advanced molecular detection during the COVID-19 pandemic: Applications, challenges, opportunities Authors: Magdalena Dorvil-Joanem, Jyoti Narayana, and Jane Yackley CEDEP Program: COVID Product type: abstract and poster Conference, meeting, or publication accepted to: CSTE