Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_total_population_with_household_expenditures_on_h_a8e6dfd9 (
"year" INTEGER,
"country" VARCHAR,
"total_population_with_household_expenditures_on_health_608f0771" FLOAT,
"total_population_with_household_expenditures_on_health_622746d9" VARCHAR,
"total_population_with_household_expenditures_on_health_832a5c48" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_total_population_with_household_expenditures_on_h_ba4b817b (
"year" INTEGER,
"country" VARCHAR,
"total_population_with_household_expenditures_on_health_cc336f9a" FLOAT
);
CREATE TABLE owid_total_population_with_household_expenditures_on_h_ebd56703 (
"year" INTEGER,
"country" VARCHAR,
"total_population_with_household_expenditures_on_health_55958b50" FLOAT,
"total_population_with_household_expenditures_on_health_96abce64" VARCHAR,
"total_population_with_household_expenditures_on_health_5c29f440" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_total_population_with_household_expenditures_on_h_f6014faa (
"year" INTEGER,
"country" VARCHAR,
"total_population_with_household_expenditures_on_health_55958b50" FLOAT
);
CREATE TABLE owid_total_productivity_losses_due_to_5_oral_diseases__d92e16f8 (
"year" INTEGER,
"country" VARCHAR,
"total_productivity_losses_due_to_5_oral_diseases_in_million_usd" FLOAT
);
CREATE TABLE owid_total_productivity_losses_due_to_5_oral_diseases__fdd072b7 (
"year" INTEGER,
"country" VARCHAR,
"total_productivity_losses_due_to_5_oral_diseases_in_million_usd" FLOAT,
"total_productivity_losses_due_to_5_oral_diseases_in_mi_774b7a99" VARCHAR,
"total_productivity_losses_due_to_5_oral_diseases_in_mi_9d70a0c1" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_total_rubella_number_of_reported_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"total_rubella_number_of_reported_cases" UINTEGER
);
CREATE TABLE owid_total_rubella_number_of_reported_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"total_rubella_number_of_reported_cases" UINTEGER,
"total_rubella_number_of_reported_cases_low" VARCHAR,
"total_rubella_number_of_reported_cases_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_total_taxes_on_beverages_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"total_taxes_on_beverages_pct" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_total_taxes_on_beverages_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"total_taxes_on_beverages_pct" FLOAT,
"total_taxes_on_beverages_pct_low" VARCHAR,
"total_taxes_on_beverages_pct_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_total_tetanus_number_of_reported_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"total_tetanus_number_of_reported_cases" UINTEGER
);
CREATE TABLE owid_total_tetanus_number_of_reported_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"total_tetanus_number_of_reported_cases" UINTEGER,
"total_tetanus_number_of_reported_cases_low" VARCHAR,
"total_tetanus_number_of_reported_cases_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_traditional_and_complementary_medicine_profession_0aa49054 (
"year" INTEGER,
"country" VARCHAR,
"traditional_and_complementary_medicine_professionals_number" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_traditional_and_complementary_medicine_profession_0ddca9ac (
"year" INTEGER,
"country" VARCHAR,
"traditional_and_complementary_medicine_professionals_number" UINTEGER,
"traditional_and_complementary_medicine_professionals_number_low" VARCHAR,
"traditional_and_complementary_medicine_professionals_n_59ca64d4" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_training_in_screening_and_brief_interventions_for_135c7748 (
"year" INTEGER,
"country" VARCHAR,
"training_in_screening_and_brief_interventions_for_alco_77330fc6" VARCHAR
);
CREATE TABLE owid_training_in_screening_and_brief_interventions_for_59382b3c (
"year" INTEGER,
"country" VARCHAR,
"training_in_screening_and_brief_interventions_for_alco_77330fc6" VARCHAR,
"training_in_screening_and_brief_interventions_for_alco_484d002f" VARCHAR,
"training_in_screening_and_brief_interventions_for_alco_dfc4e531" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_training_requirements_1 (
"year" INTEGER,
"country" VARCHAR,
"sunbed_facility_staff_training_requirements" VARCHAR,
"comments" VARCHAR,
"training_requirements" VARCHAR
);
CREATE TABLE owid_training_requirements_2 (
"year" INTEGER,
"country" VARCHAR,
"sunbed_facility_staff_training_requirements" VARCHAR,
"training_requirements" VARCHAR,
"training_requirements_low" VARCHAR,
"training_requirements_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_travel_distance_to_obtain_assistive_products_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"residence_area_type" VARCHAR,
"assistive_technology_product" VARCHAR,
"travel_distance_to_obtain_assistive_products" VARCHAR,
"travel_distance_to_obtain_assistive_products_pct" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_travel_distance_to_obtain_assistive_products_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"residence_area_type" VARCHAR,
"assistive_technology_product" VARCHAR,
"travel_distance_to_obtain_assistive_products" VARCHAR,
"travel_distance_to_obtain_assistive_products_pct" FLOAT,
"travel_distance_to_obtain_assistive_products_pct_low" VARCHAR,
"travel_distance_to_obtain_assistive_products_pct_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_treatment_admissions_inpatient_alcohol_dependence_1839795f (
"year" INTEGER,
"country" VARCHAR,
"treatment_admissions_inpatient_alcohol_dependence_per_100_000" FLOAT,
"treatment_admissions_inpatient_alcohol_dependence_per__cc498692" VARCHAR,
"treatment_admissions_inpatient_alcohol_dependence_per__86c51ec5" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_treatment_admissions_inpatient_alcohol_dependence_a0dde2fa (
"year" INTEGER,
"country" VARCHAR,
"treatment_admissions_inpatient_alcohol_dependence_per_100_000" FLOAT
);
CREATE TABLE owid_treatment_admissions_inpatient_alcoholic_psychosi_038a9506 (
"year" INTEGER,
"country" VARCHAR,
"treatment_admissions_inpatient_alcoholic_psychosis_per_100_000" INTEGER
);
CREATE TABLE owid_treatment_admissions_inpatient_alcoholic_psychosi_62cbc75e (
"year" INTEGER,
"country" VARCHAR,
"treatment_admissions_inpatient_alcoholic_psychosis_per_100_000" INTEGER,
"treatment_admissions_inpatient_alcoholic_psychosis_per_b9ccd0c3" VARCHAR,
"treatment_admissions_inpatient_alcoholic_psychosis_per_3ab296ab" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_treatment_history_unknown (
"year" INTEGER,
"country" VARCHAR,
"treatment_history_unknown" UINTEGER
);
Anyone who has the link will be able to view this.