Financing Healthcare
All day long she eats yeast and car wax. she will rise and shine (JOKE BTW!!!)
@kaggle.programmerrdai_financing_healthcare
All day long she eats yeast and car wax. she will rise and shine (JOKE BTW!!!)
@kaggle.programmerrdai_financing_healthcare
CREATE TABLE annual_healthcare_expenditure_per_capita (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"indicator_current_health_expenditure_che_per_capita_in_ppp_int" DOUBLE
);
CREATE TABLE child_mortality_vs_health_expenditure (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"mortality_rate_under_5_per_1_000_live_births" DOUBLE,
"current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
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
);
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_private_plan_us_current_p_f0790085" DOUBLE,
"health_insurance_coverage_us_any_plan_us_current_popul_12976c0d" DOUBLE
);
CREATE TABLE health_protection_coverage (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_of_population_covered_by_health_insurance_ilo_2014" DOUBLE
);
CREATE TABLE healthcare_expenditure_vs_gdp (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE,
"gdp_per_capita_ppp_current_international" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
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_think_we_spend_on_health_expenditure_ipsos_2016" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE life_expectancy_vs_health_expenditure (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"life_expectancy_at_birth_total_years" DOUBLE,
"health_expenditure_and_financing_per_capita_oecdstat_2017" VARCHAR,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE life_expectancy_vs_healthcare_expenditure (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"life_expectancy_at_birth_total_years" DOUBLE,
"current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE percentage_of_persons_without_health_insurance_coverage_us (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"percentage_of_persons_without_health_insurance" DOUBLE
);
CREATE TABLE public_health_expenditure_share_gdp_owid (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"public_health_expenditure_pc_gdp" DOUBLE
);
CREATE TABLE public_health_insurance_coverage (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"health_insurance_coverage_tanzi_schuknecht_2000" BIGINT
);
CREATE TABLE public_healthcare_spending_share_gdp (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"domestic_general_government_health_expenditure_of_gdp" DOUBLE
);
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
);
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,
"gdp_per_capita_ppp_constant_2017_international" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
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
);
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,
"public_expenditure_on_health_per_capita_in_developing__959e6909" DOUBLE,
"continent" VARCHAR,
"population_historical_estimates" DOUBLE
);
CREATE TABLE total_healthcare_expenditure_gdp (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"indicator_current_health_expenditure_che_as_percentage_27476641" DOUBLE
);
Anyone who has the link will be able to view this.