Analysis of ‘COVID-19 State Data’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/nightranger77/covid19-state-data on 30 September 2021.

--- Dataset description provided by original source is as follows ---

This dataset is a per-state amalgamation of demographic, public health and other relevant predictors for COVID-19.

Deaths, Infections and Tests by State

The COVID Tracking Project: https://covidtracking.com/data/api

Used positive, death and totalTestResults from the API for, respectively, Infected, Deaths and Tested in this dataset. Please read the documentation of the API for more context on those columns

Predictor Data and Sources

Population (2020)

Density is people per meter squared https://worldpopulationreview.com/states/

ICU Beds and Age 60+

https://khn.org/news/as-coronavirus-spreads-widely-millions-of-older-americans-live-in-counties-with-no-icu-beds/

GDP

https://worldpopulationreview.com/states/gdp-by-state/

Income per capita (2018)

https://worldpopulationreview.com/states/per-capita-income-by-state/

Gini

https://en.wikipedia.org/wiki/List_of_U.S._states_by_Gini_coefficient

Unemployment (2020)

Rates from Feb 2020 and are percentage of labor force
https://www.bls.gov/web/laus/laumstrk.htm

Sex (2017)

Ratio is Male / Female
https://www.kff.org/other/state-indicator/distribution-by-gender/

Smoking Percentage (2020)

https://worldpopulationreview.com/states/smoking-rates-by-state/

Influenza and Pneumonia Death Rate (2018)

Death rate per 100,000 people
https://www.cdc.gov/nchs/pressroom/sosmap/flu_pneumonia_mortality/flu_pneumonia.htm

Chronic Lower Respiratory Disease Death Rate (2018)

Death rate per 100,000 people
https://www.cdc.gov/nchs/pressroom/sosmap/lung_disease_mortality/lung_disease.htm

Active Physicians (2019)

https://www.kff.org/other/state-indicator/total-active-physicians/

Hospitals (2018)

https://www.kff.org/other/state-indicator/total-hospitals

Health spending per capita

Includes spending for all health care services and products by state of residence. Hospital spending is included and reflects the total net revenue. Costs such as insurance, administration, research, and construction expenses are not included.
https://www.kff.org/other/state-indicator/avg-annual-growth-per-capita/

Pollution (2019)

Pollution: Average exposure of the general public to particulate matter of 2.5 microns or less (PM2.5) measured in micrograms per cubic meter (3-year estimate)
https://www.americashealthrankings.org/explore/annual/measure/air/state/ALL

Medium and Large Airports

For each state, number of medium and large airports https://en.wikipedia.org/wiki/List_of_the_busiest_airports_in_the_United_States

Temperature (2019)

Note that FL was incorrect in the table, but is corrected in the Hottest States paragraph
https://worldpopulationreview.com/states/average-temperatures-by-state/
District of Columbia temperature computed as the average of Maryland and Virginia

Urbanization (2010)

Urbanization as a percentage of the population https://www.icip.iastate.edu/tables/population/urban-pct-states

Age Groups (2018)

https://www.kff.org/other/state-indicator/distribution-by-age/

School Closure Dates

Schools that haven't closed are marked NaN https://www.edweek.org/ew/section/multimedia/map-coronavirus-and-school-closures.html

Note that some datasets above did not contain data for District of Columbia, this missing data was found via Google searches manually entered.

--- Original source retains full ownership of the source dataset ---

This statistic shows a ranking of the estimated per capita consumer spending on healthcare in 2020 in Latin America and the Caribbean, differentiated by country. Consumer spending here refers to the domestic demand of private households and non-profit institutions serving households (NPISHs) in the selected region. Spending by corporations or the state is not included. Consumer spending is the biggest component of the gross domestic product as computed on an expenditure basis in the context of national accounts. The other components in this approach are consumption expenditure of the state, gross domestic investment as well as the net exports of goods and services. Consumer spending is broken down according to the United Nations' Classification of Individual Consumption By Purpose (COICOP). The shown data adheres broadly to group 06. As not all countries and regions report data in a harmonized way, all data shown here has been processed by Statista to allow the greatest level of comparability possible. The underlying input data are usually household budget surveys conducted by government agencies that track spending of selected households over a given period.The data is shown in nominal terms which means that monetary data is valued at prices of the respective year and has not been adjusted for inflation. For future years the price level has been projected as well. The data has been converted from local currencies to US$ using the average exchange rate of the respective year. For forecast years, the exchange rate has been projected as well. The timelines therefore incorporate currency effects.The shown forecast is adjusted for the expected impact of the COVID-19 pandemic on the local economy. The impact has been estimated by considering both direct (e.g. because of restrictions on personal movement) and indirect (e.g. because of weakened purchasing power) effects. The impact assessment is subject to periodic review as more data becomes available.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in more than 150 countries and regions worldwide. All input data are sourced from international institutions, national statistical offices, and trade associations. All data has been are processed to generate comparable datasets (see supplementary notes under details for more information).

This dataset is a per-state amalgamation of demographic, public health and other relevant predictors for COVID-19.

Deaths, Infections and Tests by State

Coronavirus API http://coronavirusapi.com/states.csv

Predictor Data and Sources

Testing data per state

http://coronavirusapi.com/states.csv

Population (2020)

Density is people per meter squared https://worldpopulationreview.com/states/

ICU Beds and Age 60+

https://khn.org/news/as-coronavirus-spreads-widely-millions-of-older-americans-live-in-counties-with-no-icu-beds/

GDP

https://worldpopulationreview.com/states/gdp-by-state/

Income per capita (2018)

https://worldpopulationreview.com/states/per-capita-income-by-state/

Gini

https://en.wikipedia.org/wiki/List_of_U.S._states_by_Gini_coefficient

Unemployment (2020)

Rates from Feb 2020 and are percentage of labor force
https://www.bls.gov/web/laus/laumstrk.htm

Sex (2017)

Ratio is Male / Female
https://www.kff.org/other/state-indicator/distribution-by-gender/

Smoking Percentage (2020)

https://worldpopulationreview.com/states/smoking-rates-by-state/

Influenza and Pneumonia Death Rate (2018)

Death rate per 100,000 people
https://www.cdc.gov/nchs/pressroom/sosmap/flu_pneumonia_mortality/flu_pneumonia.htm

Chronic Lower Respiratory Disease Death Rate (2018)

Death rate per 100,000 people
https://www.cdc.gov/nchs/pressroom/sosmap/lung_disease_mortality/lung_disease.htm

Active Physicians (2019)

https://www.kff.org/other/state-indicator/total-active-physicians/

Hospitals (2018)

https://www.kff.org/other/state-indicator/total-hospitals

Health spending per capita

Includes spending for all health care services and products by state of residence. Hospital spending is included and reflects the total net revenue. Costs such as insurance, administration, research, and construction expenses are not included.
https://www.kff.org/other/state-indicator/avg-annual-growth-per-capita/

Pollution (2019)

Pollution: Average exposure of the general public to particulate matter of 2.5 microns or less (PM2.5) measured in micrograms per cubic meter (3-year estimate)
https://www.americashealthrankings.org/explore/annual/measure/air/state/ALL

Medium and Large Airports

For each state, number of medium and large airports https://en.wikipedia.org/wiki/List_of_the_busiest_airports_in_the_United_States

Temperature (2019)

Note that FL was incorrect in the table, but is corrected in the Hottest States paragraph
https://worldpopulationreview.com/states/average-temperatures-by-state/
District of Columbia temperature computed as the average of Maryland and Virginia

Urbanization (2010)

Urbanization as a percentage of the population https://www.icip.iastate.edu/tables/population/urban-pct-states

Age Groups (2018)

https://www.kff.org/other/state-indicator/distribution-by-age/

School Closure Dates

Schools that haven't closed are marked NaN https://www.edweek.org/ew/section/multimedia/map-coronavirus-and-school-closures.html

Note that some datasets above did not contain data for District of Columbia, this missing data was found via Google searches manually entered.

Antidepressant Use in Scandinavia

A Study of Population Characteristics and Drug Utilization Rates

By [source]

About this dataset

This fascinating dataset examines the use of antidepressant medications among children and adolescents in Denmark, Norway, and Sweden from 2007 until 2017. Through a comprehensive exploration of drug usage along with population characteristics, we can uncover deeper insights into the prevalence of antidepressant use in this demographic and its potential causes. By carefully inspecting this data set which contains details about drug use, census data and associated drug names by code, we can shed light on an important issue with far reaching implications for public health worldwide

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset offers an opportunity to analyze antidepressant use among children and adolescents in Denmark, Norway and Sweden from 2007 to 2017. To get started with your analysis, you'll need to familiarize yourself with the dataset. Below are some simple steps for getting acquainted with the available resources:

• Familiarize yourself with the column descriptions and data types. Each column contains meaningful information about drug use and population characteristics in the three countries during this window of time.
• Review the drug_names file contained in this dataset for a detailed list of drugs associated with each code represented in the main table. This is particularly important because ATC (Anatomical Therapeutic Chemical) codes provide an easy shorthand way of referring to individual medications without being too long-winded or cluttering up columns not relevant to your particular question or hypothesis
• Explore correlations between different parameters using crosstabs, scatterplots, or other common visualizations as necessary
• Use census data contained in census_data file as a reference when discussing population makeup within any given country during this period

With this approach, you will have all that's necessary to derive meaningful results out of this dataset! Good luck on your exploration!

Research Ideas

• Comparing the sex, age and population weights of those using different types of antidepressants in each country
• Tracking consumption trends across countries and between genders over time
• Correlating antidepressant use with national income indicators such as GDP per capita or overall Mental Health Index scores

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: census.csv | Column name | Description | |:--------------|:------------------------------------------| | year | Year of the data (Integer) | | sex | Gender of the population (String) | | age | Age group of the population (Integer) | | cnt | Number of people using the drug (Integer) | | country | Country of the population (String) |

File: drug_names.csv | Column name | Description | |:---------------|:------------------------------------------------------------------| | atc | Anatomical Therapeutic Chemical (ATC) code for the drug. (String) | | formalname | Formal name of the drug. (String) |

Acknowledgements

If you use this dataset in your research, please credit the original authors. If you use this dataset in your research, please credit .

The current healthcare spending per capita in Colombia was forecast to continuously increase between 2024 and 2028 by in total 174.8 U.S. dollars (+27.31 percent). After the eigth consecutive increasing year, the spending is estimated to reach 814.86 U.S. dollars and therefore a new peak in 2028. Depicted here is the average per capita spending, in a given country or region, with regards to healthcare. The spending refers to the average current spending of both governments and consumers per inhabitant.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).

This statistic shows a ranking of the estimated current healthcare spending per capita in 2020 in Africa, differentiated by country. The spending refers to the average current spending of both governments and consumers per inhabitant.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in more than 150 countries and regions worldwide. All input data are sourced from international institutions, national statistical offices, and trade associations. All data has been are processed to generate comparable datasets (see supplementary notes under details for more information).

The current healthcare spending per capita in Ghana was forecast to continuously increase between 2024 and 2029 by in total 20.5 U.S. dollars (+22.15 percent). After the fourth consecutive increasing year, the spending is estimated to reach 113.05 U.S. dollars and therefore a new peak in 2029. Depicted here is the average per capita spending, in a given country or region, with regards to healthcare. The spending refers to the average current spending of both governments and consumers per inhabitant.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).Find more key insights for the current healthcare spending per capita in countries like Ivory Coast and Nigeria.

The alcohol consumption per capita in Colombia was forecast to continuously decrease between 2024 and 2029 by in total 0.01 liters (-0.2 percent). The per capita consumption is estimated to amount to 4.89 liters in 2029. Depicted is the estimated alcohol consumption in the country or region at hand.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).

The average number of hospital beds available per 1,000 people in Colombia was forecast to remain on a similar level in 2029 as compared to 2024 with 1.69 beds. According to this forecast, the number of available beds per 1,000 people will stay nearly the same over the forecast period. Depicted is the number of hospital beds per capita in the country or region at hand. As defined by World Bank this includes inpatient beds in general, specialized, public and private hospitals as well as rehabilitation centers.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).

The average number of hospital beds available per 1,000 people in Ghana was forecast to continuously decrease between 2024 and 2029 by in total 0.01 beds (-1.54 percent). The number of available beds per 1,000 people is estimated to amount to 0.64 beds in 2029. Depicted is the number of hospital beds per capita in the country or region at hand. As defined by World Bank this includes inpatient beds in general, specialized, public and private hospitals as well as rehabilitation centers.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).Find more key insights for the average number of hospital beds available per 1,000 people in countries like Ivory Coast and Senegal.

The current healthcare spending in Ghana was forecast to continuously increase between 2024 and 2029 by in total 1.1 billion U.S. dollars (+33.4 percent). After the fifth consecutive increasing year, the spending is estimated to reach 4.2 billion U.S. dollars and therefore a new peak in 2029. According to Worldbank health spending includes expenditures with regards to healthcare services and goods. The spending refers to current spending of both governments and consumers.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).Find more key insights for the current healthcare spending in countries like Senegal and Ivory Coast.

The current health expenditure as a share of the GDP in Ghana was forecast to continuously increase between 2024 and 2029 by in total 0.1 percentage points. The share is estimated to amount to 4.29 percent in 2029. According to Worldbank health spending includes expenditures with regards to healthcare services and goods. It is depicted here in relation to the total gross domestic product (GDP) of the country or region at hand.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).Find more key insights for the current health expenditure as a share of the GDP in countries like Senegal and Nigeria.

The number of hospital beds in Ghana was forecast to continuously increase between 2024 and 2029 by in total three thousand beds (+9.58 percent). After the fifteenth consecutive increasing year, the number of hospital beds is estimated to reach 34.29 thousand beds and therefore a new peak in 2029. Notably, the number of hospital beds of was continuously increasing over the past years.Depicted is the estimated total number of hospital beds in the country or region at hand.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).Find more key insights for the number of hospital beds in countries like Nigeria and Ivory Coast.

The number of physicians in Ghana was forecast to continuously increase between 2024 and 2029 by in total 2.1 thousand physicians (+26.92 percent). After the tenth consecutive increasing year, the number of physicians is estimated to reach 9.94 thousand physicians and therefore a new peak in 2029. Depicted here is the estimated number of physicians in the geographical unit at hand. Thereby physicians include medical specialists as well as general practitioners.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).Find more key insights for the number of physicians in countries like Ivory Coast and Nigeria.