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)

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 Cases (DISCONTINUED). Source: Center for Disease Control and Prevention. Track economic…

COVID data for cases aged 5 to 18 years by county. Source dataset can be found here: https://www.tn.gov/health/cedep/ncov/data/downloadable-datasets.html

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

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?

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.

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

Reporting of Aggregate Case and Death Count data was discontinued May 11, 2023, with the expiration of the COVID-19 public health emergency declaration. This dataset will receive a final update on June 1, 2023, to reconcile historical data through May 10, 2023, and will remain publicly available.

This archived public use dataset contains historical case and percent positivity data updated weekly for all available counties and jurisdictions. Each week, the dataset was refreshed to capture any historical updates. Please note, percent positivity data may be incomplete for the most recent time period.

Related data CDC provides the public with two active versions of COVID-19 county-level community transmission level data: this dataset with historical case and percent positivity data for each county from January 22, 2020 (Weekly Historical Changes dataset) and a dataset with the levels as originally posted (Weekly Originally Posted dataset) since October 20, 2022. Please navigate to the Weekly Originally Posted dataset for the Community Transmission Levels published weekly on Thursdays.

Methods for calculating county level of community transmission indicator The County Level of Community Transmission indicator uses two metrics: (1) total new COVID-19 cases per 100,000 persons in the last 7 days and (2) percentage of positive SARS-CoV-2 diagnostic nucleic acid amplification tests (NAAT) in the last 7 days. For each of these metrics, CDC classifies transmission values as low, moderate, substantial, or high (below and here). If the values for each of these two metrics differ (e.g., one indicates moderate and the other low), then the higher of the two should be used for decision-making.

CDC core metrics of and thresholds for community transmission levels of SARS-CoV-2 Total New Case Rate Metric: "New cases per 100,000 persons in the past 7 days" is calculated by adding the number of new cases in the county (or other administrative level) in the last 7 days divided by the population in the county (or other administrative level) and multiplying by 100,000. "New cases per 100,000 persons in the past 7 days" is considered to have transmission level of Low (0-9.99); Moderate (10.00-49.99); Substantial (50.00-99.99); and High (greater than or equal to 100.00).

Test Percent Positivity Metric: "Percentage of positive NAAT in the past 7 days" is calculated by dividing the number of positive tests in the county (or other administrative level) during the last 7 days by the total number of tests resulted over the last 7 days. "Percentage of positive NAAT in the past 7 days" is considered to have transmission level of Low (less than 5.00); Moderate (5.00-7.99); Substantial (8.00-9.99); and High (greater than or equal to 10.00).

The data in this dataset are considered provisional by CDC and are subject to change until the data are reconciled and verified with the state and territorial data providers.

This dataset is created using CDC’s Policy on Public Health Research and Nonresearch Data Management and Access.

Archived data CDC has archived two prior versions of these datasets. Both versions contain the same 7 data elements reflecting community transmission levels for all available counties and jurisdictions; however, the datasets updated daily. The archived datasets can be found here:

Archived Originally Posted dataset

Archived Historical Changes dataset

Archived Data Notes:

October 27, 2022: Due to a processing issue this dataset will not be posted this week. CDC is currently working to address the issue and will publish the data when able.

November 10, 2022: As of 11/10/2022, this dataset will continue to incorporate historical updates made to case and percent positivity data; however, community transmission level will only be published in the corresponding Weekly COVID-19 County Level of Community Transmission as Originally Posted dataset (Weekly Originally Posted dataset).

Note:

October 20, 2022: Due to a data reporting error, the case rate for Philadelphia County, Pennsylvania is lower than expected in the COVID-19 Community Transmission Level data released on October 20, 2022. This could lead to the COVID-19 Community Transmission Level for Philadelphia County being underestimated; therefore, it should be interpreted with caution.

November 3, 2022: Due to a reporting cadence issue, case rates for Missouri counties are calculated based on 11 days’ worth of case count data in the COVID-19 Community Transmission Level data released on November 3, 2022, instead of the customary 7 days’ worth of data. This could lead to the COVID-19 Community Transmission Levels metrics for Missouri counties being overestimated; therefore, they should be interpreted with caution.

November 10, 2022: Due to a reporting cadence change, case rates for Alabama counties are calculated based on 13 days’ worth of case count data in the COVID-19 Community Transmission Level data released on November 10, 2022, instead of the customary 7 days’ worth of data. This could lead to the COVID-19 Community Transmission Levels metrics for Alabama counties being overestimated; therefore, they should be interpreted with caution.

November 10, 2022: Per the request of the jurisdiction, cases among non-residents have been removed from all Hawaii county totals throughout the entire time series. Cumulative case counts reported by CDC will no longer match Hawaii’s COVID-19 Dashboard, which still includes non-resident cases. 

November 10, 2022: In the COVID-19 Community Transmission Level data released on November 10, 2022, multiple municipalities in Puerto Rico are reporting higher than expected increases in case counts. CDC is working with territory officials to verify the data submitted. 

December 1, 2022: Due to cadence changes over the Thanksgiving holiday, case rates for all Ohio counties are reported as 0 in the COVID-19 Community Transmission Level data released on December 1, 2022. Therefore, the COVID-19 Community Transmission Levels may be underestimated and should be interpreted with caution. 

December 22, 2022: Due to an internal revision process, case rates for some Tennessee counties may appear higher than expected in the December 22, 2022, weekly release. Therefore, the COVID-19 Community Transmission Levels metrics for some Tennessee counties may be overestimated and should be interpreted with caution.

December 22, 2022: Due to reporting of a backlog of historic COVID-19 cases, case rates for some Louisiana counties will appear higher than expected in the December 22, 2022, weekly release. Therefore, the COVID-19 Community Transmission Levels metrics for some Louisiana counties may be overestimated and should be interpreted with caution.

December 29, 2022: Due to technical difficulties, county data from Alabama could not be incorporated via standard practices. As a result, case and death metrics will be reported as 0 in the December 29, 2022, weekly release. Therefore, the COVID-19 Community Transmission Levels metrics for Alabama counties will be underestimated and should be interpreted with caution.

January 5, 2023: Due to a reporting cadence issue, case rates for all Alabama counties will be calculated based on 14 days’ worth of case count data in the COVID-19 Community Transmission Level information released on January 5, 2023, instead of the customary 7 days’ worth of case count data. Therefore, the weekly case rates will be overestimated, which could affect counties’ COVID-19 Community Transmission Level classification and should be interpreted with caution.

January 5, 2023: Due to North Carolina’s holiday reporting cadence, aggregate case data will contain 14 days’ worth of data instead of the customary 7 days. As a result, case metrics will appear higher than expected in the January 5, 2023, weekly release. COVID-19 Community Transmission metrics may be overestimated and should be interpreted with caution.

January 12, 2023: Due to data processing delays, Mississippi’s aggregate case data will be reported as 0. As a result, case metrics will appear lower than expected in the January 12, 2023, weekly release. COVID-19 Community Transmission metrics may be underestimated and should be interpreted with caution. 

January 13, 2023: Aggregate case data released for Los Angeles County, California for the week of December 22nd, 2022, and December 29th, 2022, have been corrected for a data processing error.

January 19, 2023: Due to a reporting cadence issue, Mississippi’s aggregate case data will be calculated based on 14 days’ worth of data instead of the customary 7 days in the January 19, 2023, weekly release. Therefore, COVID-19 Community Transmission metrics may be overestimated and should be interpreted with caution.

January 26, 2023: Due to a reporting backlog of historic COVID-19 cases, case rates for two Michigan counties

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

The counties of Trousdale and Lake – both in Tennessee – had the highest COVID-19 infection rates in the United States as of June 9, 2020. Dakota, Nobles, and Lincoln also ranked among the U.S. counties with the highest number of coronavirus cases per 100,000 people.

Coronavirus hits the East Coast In the United States, the novel coronavirus had infected around 5.4 million people and had caused nearly 170,000 deaths by mid-August 2020. The densely populated states of New York and New Jersey were at the epicenter of the outbreak in the country. New York City, which is composed of five counties, was one of the most severely impacted regions. However, the true level of transmission is likely to be much higher because many people will be asymptomatic or suffer only mild symptoms that are not diagnosed.

All states are in crisis The first coronavirus case in the U.S. was confirmed in the state of Washington in mid-January 2020. At the time, it was unclear how the virus was spreading; we now know that close contact with an infected person and breathing in their respiratory droplets is the primary mode of transmission. It is no surprise that the four states with the most coronavirus cases are those with the highest populations: New York, Texas, Florida, and California. However, Louisiana was the state with the highest COVID-19 infection rate per 100,000 people as of August 24, 2020.

Title: Texting to Stop the Spread: Establishing a Quick Response to Surging COVID-19 Case Counts Authors: Delaney B. Lackey, Ashley P. Keese, Katie Garman, Michelle E. Cascio, Caleb Wiedman, Mary Ellen Travers, and Jane Yackley CEDEP Program: COVID Product type: poster Conference, meeting, or publication accepted to: CSTE

Title: Improving efficiency of COVID-19 aggregate case and death surveillance data transmission for jurisdictions: current and future role of application programming interfaces (APIs) Authors: Diba Khan, Meeyoung Park, Samuel Lerma, Stephen Soroka, Denise Gaughan, Lyndsay Bottichio, Monika Bray, Mary Fukushima, Brooke Bregman, Caleb Wiedeman, William Duck, Deborah Dee, Adi Gundlapalli, and Amitabh B. Suthar CEDEP Program: EP Product type: publication Conference, meeting, or publication accepted to: Journal of the American Medical Informatics Association

Dataset

This dataset was created by Logeshkumar Sivakumar

Contents