Effective September 27, 2023, this dataset will no longer be updated. Similar data are accessible from wonder.cdc.gov. Deaths involving COVID-19, pneumonia, and influenza reported to NCHS by sex, age group, and jurisdiction of occurrence.

Context

Dataset aims to facilitate a state by state comparison of potential risk factors that may heighten Covid 19 transmission rates or deaths. It includes state by state estimates of: covid 19 positives/deaths, flu/pneumonia deaths, major city population densities, available hospital resources, high risk health condition prevalance, population over 60, and means of work transportation rates.

Content

The Data Includes:

1) Covid 19 Outcome Stats:

Covid_Death : Covid Deaths by State

Covid_Positive : Covid Positive Tests by State

2) US Major City Population Density by State: CBSA_Major_City_max_weighted_density

3) KFF Estimates of Total Hospital Beds by State:

Kaiser_Total_Hospital_Beds

4) 2018 Season Flu and Pneumonia Death Stats:

FLUVIEW_TOTAL_PNEUMONIA_DEATHS_Season_2018

FLUVIEW_TOTAL_INFLUENZA_DEATHS_Season_2018

5)US Total Rates of Flu Hospitalization by Underlying Condition:

Fluview_US_FLU_Hospitalization_Rate_....

6) State by State BRFSS Prevalance Rates of Conditions Associated with Higher Flu Hospitalization Rates

BRFSS_Diabetes_Prevalance BRFSS_Asthma_Prevalance BRFSS_COPD_Prevalance
BRFSS_Obesity BMI Prevalance BRFSS_Other_Cancer_Prevalance BRFSS_Kidney_Disease_Prevalance BRFSS_Obesity BMI Prevalance BRFSS_2017_High_Cholestoral_Prevalance BRFSS_2017_High_Blood_Pressure_Prevalance Census_Population_Over_60

7)State by state breakdown of Means of Work Transpotation:

COMMUTE_Census_Worker_Public_Transportation_Rate

Acknowledgements

Links to data sources:

https://worldpopulationreview.com/states/

https://covidtracking.com/data/

https://gis.cdc.gov/GRASP/Fluview/FluHospRates.html https://www.kff.org/health-costs/issue-brief/state-data-and-policy-actions-to-address-coronavirus/#stateleveldata

https://data.census.gov/cedsci/table?q=United%20States&tid=ACSDP1Y2018.DP05&hidePreview=true&vintage=2018&layer=VT_2018_040_00_PY_D1&cid=S0103_C01_001E

Tables: ACSST1Y2018.S1811 ACSST1Y2018.S0102

https://www.census.gov/library/visualizations/2012/dec/c2010sr-01-density.html

https://gis.cdc.gov/grasp/fluview/mortality.html

Inspiration

I hope to show the existence of correlations that warrant a deeper county by county analysis to identify areas of increased risk requiring increased resource allocation or increased attention to preventative measures.

Note: On April 30, 2024, the Federal mandate for COVID-19 and influenza associated hospitalization data to be reported to CDC’s National Healthcare Safety Network (NHSN) expired. Hospitalization data beyond April 30, 2024, will not be updated on the Open Data Portal. Hospitalization and ICU admission data collected from summer 2020 to May 10, 2023, are sourced from the California Hospital Association (CHA) Survey. Data collected on or after May 11, 2023, are sourced from CDC's National Healthcare Safety Network (NHSN).

Data is from the California Department of Public Health (CDPH) Respiratory Virus State Dashboard at https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Respiratory-Viruses/RespiratoryDashboard.aspx.

Data are updated each Friday around 2 pm.

For COVID-19 death data: As of January 1, 2023, data was sourced from the California Department of Public Health, California Comprehensive Death File (Dynamic), 2023–Present. Prior to January 1, 2023, death data was sourced from the COVID-19 case registry. The change in data source occurred in July 2023 and was applied retroactively to all 2023 data to provide a consistent source of death data for the year of 2023. Influenza death data was sourced from the California Department of Public Health, California Comprehensive Death File (Dynamic), 2020–Present.

COVID-19 testing data represent data received by CDPH through electronic laboratory reporting of test results for COVID-19 among residents of California. Testing date is the date the test was administered, and tests have a 1-day lag (except for the Los Angeles County, which has an additional 7-day lag). Influenza testing data represent data received by CDPH from clinical sentinel laboratories in California. These laboratories report the aggregate number of laboratory-confirmed influenza virus detections and total tests performed on a weekly basis. These data do not represent all influenza testing occurring in California and are available only at the state level.

Provisional counts of the number of death occurrences in England and Wales due to coronavirus (COVID-19) and influenza and pneumonia, by age, sex and place of death.

Method

The dataset contains several confirmed COVID-19 cases, number of deaths, and death rate in six regions. The objective of the study is to compare the number of confirmed cases in Africa to other regions.

Death rate = Total number of deaths from COVID-19 divided by the Total Number of infected patients.

The study provides evidence for the country-level in six regions by the World Health Organisation's classification.

Findings

Based on the descriptive data provided above, we conclude that the lack of tourism is one of the key reasons why COVID-19 reported cases are low in Africa compared to other regions. We also justified this claim by providing evidence from the economic freedom index, which indicates that the vast majority of African countries recorded a low index for a business environment. On the other hand, we conclude that the death rate is higher in the African region compared to other regions. This points to issues concerning health-care expenditure, low capacity for testing for COVID-19, and poor infrastructure in the region.

Apart from COVID-19, there are significant pre-existing diseases, namely; Malaria, Flu, HIV/AIDS, and Ebola in the continent. This study, therefore, invites the leaders to invest massively in the health-care system, infrastructure, and human capital in order to provide a sustainable environment for today and future generations. Lastly, policy uncertainty has been a major issue in determining a sustainable development goal on the continent. This uncertainty has differentiated Africa to other regions in terms of stepping up in the time of global crisis.

Rank, number of deaths, percentage of deaths, and age-specific mortality rates for the leading causes of death, by age group and sex, 2000 to most recent year.

Data is from the California Department of Public Health (CDPH) Respiratory Virus Weekly Report.

The report is updated each Friday.

Laboratory surveillance data: California laboratories report SARS-CoV-2 test results to CDPH through electronic laboratory reporting. Los Angeles County SARS-CoV-2 lab data has a 7-day reporting lag. Test positivity is calculated using SARS-CoV-2 lab tests that has a specimen collection date reported during a given week.

Laboratory surveillance for influenza, respiratory syncytial virus (RSV), and other respiratory viruses (parainfluenza types 1-4, human metapneumovirus, non-SARS-CoV-2 coronaviruses, adenovirus, enterovirus/rhinovirus) involves the use of data from clinical sentinel laboratories (hospital, academic or private) located throughout California. Specimens for testing are collected from patients in healthcare settings and do not reflect all testing for influenza, respiratory syncytial virus, and other respiratory viruses in California. These laboratories report the number of laboratory-confirmed influenza, respiratory syncytial virus, and other respiratory virus detections and isolations, and the total number of specimens tested by virus type on a weekly basis.

Test positivity for a given week is calculated by dividing the number of positive COVID-19, influenza, RSV, or other respiratory virus results by the total number of specimens tested for that virus. Weekly laboratory surveillance data are defined as Sunday through Saturday.

Hospitalization data: Data on COVID-19 and influenza hospital admissions are from Centers for Disease Control and Prevention’s (CDC) National Healthcare Safety Network (NHSN) Hospitalization dataset. The requirement to report COVID-19 and influenza-associated hospitalizations was effective November 1, 2024. CDPH pulls NHSN data from the CDC on the Wednesday prior to the publication of the report. Results may differ depending on which day data are pulled. Admission rates are calculated using population estimates from the P-3: Complete State and County Projections Dataset provided by the State of California Department of Finance (https://dof.ca.gov/forecasting/demographics/projections/). Reported weekly admission rates for the entire season use the population estimates for the year the season started. For more information on NHSN data including the protocol and data collection information, see the CDC NHSN webpage (https://www.cdc.gov/nhsn/index.html).

CDPH collaborates with Northern California Kaiser Permanente (NCKP) to monitor trends in RSV admissions. The percentage of RSV admissions is calculated by dividing the number of RSV-related admissions by the total number of admissions during the same period. Admissions for pregnancy, labor and delivery, birth, and outpatient procedures are not included in total number of admissions. These admissions serve as a proxy for RSV activity and do not necessarily represent laboratory confirmed hospitalizations for RSV infections; NCKP members are not representative of all Californians.

Weekly hospitalization data are defined as Sunday through Saturday.

Death certificate data: CDPH receives weekly year-to-date dynamic data on deaths occurring in California from the CDPH Center for Health Statistics and Informatics. These data are limited to deaths occurring among California residents and are analyzed to identify influenza, respiratory syncytial virus, and COVID-19-coded deaths. These deaths are not necessarily laboratory-confirmed and are an underestimate of all influenza, respiratory syncytial virus, and COVID-19-associated deaths in California. Weekly death data are defined as Sunday through Saturday.

Wastewater data: This dataset represents statewide weekly SARS-CoV-2 wastewater summary values. SARS-CoV-2 wastewater concentrations from all sites in California are combined into a single, statewide, unit-less summary value for each week, using a method for data transformation and aggregation developed by the CDC National Wastewater Surveillance System (NWSS). Please see the CDC NWSS data methods page for a description of how these summary values are calculated. Weekly wastewater data are defined as Sunday through Saturday.