Name: Financing Healthcare
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Financing Healthcare

Health care or healthcare is the improvement of health via the prevention, diagnosis, treatment, amelioration, or cure of disease, illness, injury, and other physical and mental impairments in people. Health care is delivered by health professionals and allied health fields. Wikipedia

@article{owidfinancinghealthcare,
author = {Esteban Ortiz-Ospina and Max Roser},
title = {Financing Healthcare},
journal = {Our World in Data},
year = {2017},
note = {https://ourworldindata.org/financing-healthcare}
}

Tables

Annual Healthcare Expenditure Per Capita

@kaggle.programmerrdai_financing_healthcare.annual_healthcare_expenditure_per_capita

33.84 kB
3,974 rows
4 columns

CREATE TABLE annual_healthcare_expenditure_per_capita (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "indicator_current_health_expenditure_che_per_capita_in_ppp_int" DOUBLE  -- Indicator:Current Health Expenditure (CHE) Per Capita In PPP Int$
);

Child Mortality Vs Health Expenditure

@kaggle.programmerrdai_financing_healthcare.child_mortality_vs_health_expenditure

478.84 kB
56,108 rows
7 columns

CREATE TABLE child_mortality_vs_health_expenditure (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "mortality_rate_under_5_per_1_000_live_births" DOUBLE  -- Mortality Rate, Under-5 (per 1,000 Live Births),
  "current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE  -- Current Health Expenditure Per Capita, PPP (current International $),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Expenditure Of The National Health Service Nhs In The Uk

@kaggle.programmerrdai_financing_healthcare.expenditure_of_the_national_health_service_nhs_in_the_uk

4.12 kB
27 rows
4 columns

CREATE TABLE expenditure_of_the_national_health_service_nhs_in_the_uk (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "nhs_expenditure_gdp_1950_2012_office_of_health_economics_2012" DOUBLE  -- NHS Expenditure %GDP 1950-2012 (Office Of Health Economics (2012))
);

Healthcare Expenditure Vs Gdp

@kaggle.programmerrdai_financing_healthcare.healthcare_expenditure_vs_gdp

494.24 kB
56,120 rows
7 columns

CREATE TABLE healthcare_expenditure_vs_gdp (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE  -- Current Health Expenditure Per Capita, PPP (current International $),
  "gdp_per_capita_ppp_current_international" DOUBLE  -- GDP Per Capita, PPP (current International $),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Health Insurance Coverage In The Us

@kaggle.programmerrdai_financing_healthcare.health_insurance_coverage_in_the_us

6.64 kB
28 rows
6 columns

CREATE TABLE health_insurance_coverage_in_the_us (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "health_insurance_coverage_us_govt_plan_us_current_popu_eca1d060" DOUBLE  -- Health Insurance Coverage US, Govt Plan (US Current Population Survey (2014)),
  "health_insurance_coverage_us_private_plan_us_current_p_f0790085" DOUBLE  -- Health Insurance Coverage US, Private Plan (US Current Population Survey (2014)),
  "health_insurance_coverage_us_any_plan_us_current_popul_12976c0d" DOUBLE  -- Health Insurance Coverage US, Any Plan (US Current Population Survey (2014))
);

Health Protection Coverage

@kaggle.programmerrdai_financing_healthcare.health_protection_coverage

7.19 kB
162 rows
4 columns

CREATE TABLE health_protection_coverage (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "share_of_population_covered_by_health_insurance_ilo_2014" DOUBLE  -- Share Of Population Covered By Health Insurance (ILO (2014))
);

How Much We Think We Spend On Healthcare Vs How Much W 8e939e55

@kaggle.programmerrdai_financing_healthcare.how_much_we_think_we_spend_on_healthcare_vs_how_much_w_8e939e55

414.84 kB
55,705 rows
7 columns

CREATE TABLE how_much_we_think_we_spend_on_healthcare_vs_how_much_w_8e939e55 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "how_much_we_actually_spend_on_health_expenditure_ipsos_2016" DOUBLE  -- How Much We Actually Spend On Health Expenditure (IPSOS (2016)),
  "how_much_we_think_we_spend_on_health_expenditure_ipsos_2016" DOUBLE  -- How Much We Think We Spend On Health Expenditure (IPSOS (2016)),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Life Expectancy Vs Healthcare Expenditure

@kaggle.programmerrdai_financing_healthcare.life_expectancy_vs_healthcare_expenditure

537 kB
56,537 rows
7 columns

CREATE TABLE life_expectancy_vs_healthcare_expenditure (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "life_expectancy_at_birth_total_years" DOUBLE  -- Life Expectancy At Birth, Total (years),
  "current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE  -- Current Health Expenditure Per Capita, PPP (current International $),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Life Expectancy Vs Health Expenditure

@kaggle.programmerrdai_financing_healthcare.life_expectancy_vs_health_expenditure

519.07 kB
56,629 rows
7 columns

CREATE TABLE life_expectancy_vs_health_expenditure (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "life_expectancy_at_birth_total_years" DOUBLE  -- Life Expectancy At Birth, Total (years),
  "health_expenditure_and_financing_per_capita_oecdstat_2017" VARCHAR  -- Health Expenditure And Financing (per Capita) (OECDstat (2017)),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Percentage Of Persons Without Health Insurance Coverage Us

@kaggle.programmerrdai_financing_healthcare.percentage_of_persons_without_health_insurance_coverage_us

3.98 kB
39 rows
4 columns

CREATE TABLE percentage_of_persons_without_health_insurance_coverage_us (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_persons_without_health_insurance" DOUBLE  -- Percentage Of Persons Without Health Insurance (%)
);

Public Healthcare Spending Share Gdp

@kaggle.programmerrdai_financing_healthcare.public_healthcare_spending_share_gdp

38.55 kB
4,034 rows
4 columns

CREATE TABLE public_healthcare_spending_share_gdp (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "domestic_general_government_health_expenditure_of_gdp" DOUBLE  -- Domestic General Government Health Expenditure (% Of GDP)
);

Public Health Expenditure Share Gdp Owid

@kaggle.programmerrdai_financing_healthcare.public_health_expenditure_share_gdp_owid

18.88 kB
2,177 rows
4 columns

CREATE TABLE public_health_expenditure_share_gdp_owid (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "public_health_expenditure_pc_gdp" DOUBLE
);

Public Health Insurance Coverage

@kaggle.programmerrdai_financing_healthcare.public_health_insurance_coverage

3.99 kB
28 rows
4 columns

CREATE TABLE public_health_insurance_coverage (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "health_insurance_coverage_tanzi_schuknecht_2000" BIGINT  -- Health Insurance Coverage (Tanzi \u0026 Schuknecht (2000))
);

Share Of Out Of Pocket Expenditure On Healthcare

@kaggle.programmerrdai_financing_healthcare.share_of_out_of_pocket_expenditure_on_healthcare

38.4 kB
4,034 rows
4 columns

CREATE TABLE share_of_out_of_pocket_expenditure_on_healthcare (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "out_of_pocket_expenditure_of_current_health_expenditure" DOUBLE  -- Out-of-pocket Expenditure (% Of Current Health Expenditure)
);

Share Of Out Of Pocket Expenditure Vs Gdp Per Capita

@kaggle.programmerrdai_financing_healthcare.share_of_out_of_pocket_expenditure_vs_gdp_per_capita

493.35 kB
56,120 rows
7 columns

CREATE TABLE share_of_out_of_pocket_expenditure_vs_gdp_per_capita (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "out_of_pocket_expenditure_of_current_health_expenditure" DOUBLE  -- Out-of-pocket Expenditure (% Of Current Health Expenditure),
  "gdp_per_capita_ppp_constant_2017_international" DOUBLE  -- GDP Per Capita, PPP (constant 2017 International $),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Share Of Public Expenditure On Healthcare By Country

@kaggle.programmerrdai_financing_healthcare.share_of_public_expenditure_on_healthcare_by_country

38.16 kB
4,034 rows
4 columns

CREATE TABLE share_of_public_expenditure_on_healthcare_by_country (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "domestic_general_government_health_expenditure_of_curr_bf742a93" DOUBLE  -- Domestic General Government Health Expenditure (% Of Current Health Expenditure)
);

Tax Revenue Per Capita And Public Health Spending Per, Dea02ff0

@kaggle.programmerrdai_financing_healthcare.tax_revenue_per_capita_and_public_health_spending_per__dea02ff0

416.96 kB
55,705 rows
7 columns

CREATE TABLE tax_revenue_per_capita_and_public_health_spending_per__dea02ff0 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "tax_revenues_per_capita_in_developing_countries_ppp_wo_14fcbbca" DOUBLE  -- Tax Revenues Per Capita In Developing Countries (PPP) (World Bank (WDI) (2017)),
  "public_expenditure_on_health_per_capita_in_developing__959e6909" DOUBLE  -- Public Expenditure On Health Per Capita In Developing Countries (PPP) (World Bank (WDI) (2017)),
  "continent" VARCHAR,
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates)
);

Total Healthcare Expenditure Gdp

@kaggle.programmerrdai_financing_healthcare.total_healthcare_expenditure_gdp

17.56 kB
3,974 rows
4 columns

CREATE TABLE total_healthcare_expenditure_gdp (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "indicator_current_health_expenditure_che_as_percentage_27476641" DOUBLE  -- Indicator:Current Health Expenditure (CHE) As Percentage Of Gross Domestic Product (GDP) (%)
);