Global Health Observatory - World Health Organization

CREATE TABLE owid_other_smoked_tobacco_packaging_and_labelling_must_8f919986 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "other_smoked_tobacco_packaging_and_labelling_must_not__a4b60e93" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Use Figurative Or Other Signs Including Colors Or Numbers As Substitutes For Prohibited Misleading Terms And Descriptors
);

CREATE TABLE owid_other_smoked_tobacco_packaging_and_labelling_must_9fa70b0a (
  "year" INTEGER,
  "country" VARCHAR,
  "other_smoked_tobacco_packaging_and_labelling_must_not__e5b516ee" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark,
  "other_smoked_tobacco_packaging_and_labelling_must_not__426179fa" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark Low,
  "other_smoked_tobacco_packaging_and_labelling_must_not__463dd784" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark High,
  "comments" VARCHAR
);

CREATE TABLE owid_other_smoked_tobacco_packaging_and_labelling_must_cd42cf6a (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "other_smoked_tobacco_packaging_and_labelling_must_disp_b4760c0f" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Display Qualitative Information On Emission Yields
);

CREATE TABLE owid_other_smoked_tobacco_packaging_and_labelling_must_eddd58b2 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "other_smoked_tobacco_packaging_and_labelling_must_not__d5f02a1a" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Use Descriptors Depicting Flavours
);

CREATE TABLE owid_other_taxes_on_beverages_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "other_taxes_on_beverages_pct" FLOAT  -- Other Taxes On Beverages, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_other_taxes_on_beverages_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "other_taxes_on_beverages_pct" FLOAT  -- Other Taxes On Beverages, Pct,
  "other_taxes_on_beverages_pct_low" VARCHAR  -- Other Taxes On Beverages, Pct Low,
  "other_taxes_on_beverages_pct_high" VARCHAR  -- Other Taxes On Beverages, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_outcome_evaluation_was_employed_to_assess_effecti_143dc91f (
  "year" INTEGER,
  "country" VARCHAR,
  "outcome_evaluation_was_employed_to_assess_effectivenes_3ceb4185" VARCHAR  -- Outcome Evaluation Was Employed To Assess Effectiveness Of The Campaign
);

CREATE TABLE owid_outcome_evaluation_was_employed_to_assess_effecti_9145f122 (
  "year" INTEGER,
  "country" VARCHAR,
  "outcome_evaluation_was_employed_to_assess_effectivenes_3ceb4185" VARCHAR  -- Outcome Evaluation Was Employed To Assess Effectiveness Of The Campaign,
  "outcome_evaluation_was_employed_to_assess_effectivenes_49c3b4cb" VARCHAR  -- Outcome Evaluation Was Employed To Assess Effectiveness Of The Campaign Low,
  "outcome_evaluation_was_employed_to_assess_effectivenes_b5bcac3e" VARCHAR  -- Outcome Evaluation Was Employed To Assess Effectiveness Of The Campaign High,
  "comments" VARCHAR
);

CREATE TABLE owid_out_of_pocket_expenditure_as_percentage_of_curren_173feb2c (
  "year" INTEGER,
  "country" VARCHAR,
  "out_of_pocket_expenditure_as_percentage_of_current_hea_a1700858" FLOAT  -- Out Of Pocket Expenditure As Percentage Of Current Health Expenditure, Che, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_out_of_pocket_expenditure_as_percentage_of_curren_e280acae (
  "year" INTEGER,
  "country" VARCHAR,
  "out_of_pocket_expenditure_as_percentage_of_current_hea_a1700858" FLOAT  -- Out Of Pocket Expenditure As Percentage Of Current Health Expenditure, Che, Pct,
  "out_of_pocket_expenditure_as_percentage_of_current_hea_d1cd5a6d" VARCHAR  -- Out Of Pocket Expenditure As Percentage Of Current Health Expenditure, Che, Pct Low,
  "out_of_pocket_expenditure_as_percentage_of_current_hea_cfb7f913" VARCHAR  -- Out Of Pocket Expenditure As Percentage Of Current Health Expenditure, Che, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_out_of_pocket_expenditure_oop_per_capita_in_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "out_of_pocket_expenditure_oop_per_capita_in_usd" FLOAT  -- Out Of Pocket Expenditure, Oop, Per Capita In Usd,
  "comments" VARCHAR
);

CREATE TABLE owid_out_of_pocket_expenditure_oop_per_capita_in_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "out_of_pocket_expenditure_oop_per_capita_in_usd" FLOAT  -- Out Of Pocket Expenditure, Oop, Per Capita In Usd,
  "out_of_pocket_expenditure_oop_per_capita_in_usd_low" VARCHAR  -- Out Of Pocket Expenditure, Oop, Per Capita In Usd Low,
  "out_of_pocket_expenditure_oop_per_capita_in_usd_high" VARCHAR  -- Out Of Pocket Expenditure, Oop, Per Capita In Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_outpatient_health_centres_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "outpatient_health_centres" VARCHAR
);

CREATE TABLE owid_outpatient_health_centres_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "outpatient_health_centres" VARCHAR,
  "outpatient_health_centres_low" VARCHAR,
  "outpatient_health_centres_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_outpatient_social_centres_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "outpatient_social_centres" VARCHAR
);

CREATE TABLE owid_outpatient_social_centres_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "outpatient_social_centres" VARCHAR,
  "outpatient_social_centres_low" VARCHAR,
  "outpatient_social_centres_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_outpatient_visits_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "outpatient_visits_per_100_000_population" FLOAT  -- Outpatient Visits, Per 100–000 Population
);

CREATE TABLE owid_outpatient_visits_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "outpatient_visits_per_100_000_population" FLOAT  -- Outpatient Visits, Per 100–000 Population,
  "outpatient_visits_per_100_000_population_low" VARCHAR  -- Outpatient Visits, Per 100–000 Population Low,
  "outpatient_visits_per_100_000_population_high" VARCHAR  -- Outpatient Visits, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_overall_compliance_with_bans_on_direct_advertising_score_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "overall_compliance_with_bans_on_direct_advertising_score" INTEGER  -- Overall Compliance With Bans On Direct Advertising, Score
);

CREATE TABLE owid_overall_compliance_with_bans_on_direct_advertising_score_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "overall_compliance_with_bans_on_direct_advertising_score" INTEGER  -- Overall Compliance With Bans On Direct Advertising, Score,
  "overall_compliance_with_bans_on_direct_advertising_score_low" VARCHAR  -- Overall Compliance With Bans On Direct Advertising, Score Low,
  "overall_compliance_with_bans_on_direct_advertising_score_high" VARCHAR  -- Overall Compliance With Bans On Direct Advertising, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_overall_compliance_with_bans_on_promotion_and_spo_64def9e7 (
  "year" INTEGER,
  "country" VARCHAR,
  "overall_compliance_with_bans_on_promotion_and_sponsorship_score" INTEGER  -- Overall Compliance With Bans On Promotion And Sponsorship, Score
);

CREATE TABLE owid_overall_compliance_with_bans_on_promotion_and_spo_7d24b2ab (
  "year" INTEGER,
  "country" VARCHAR,
  "overall_compliance_with_bans_on_promotion_and_sponsorship_score" INTEGER  -- Overall Compliance With Bans On Promotion And Sponsorship, Score,
  "overall_compliance_with_bans_on_promotion_and_sponsors_9108f223" VARCHAR  -- Overall Compliance With Bans On Promotion And Sponsorship, Score Low,
  "overall_compliance_with_bans_on_promotion_and_sponsors_e8554cd1" VARCHAR  -- Overall Compliance With Bans On Promotion And Sponsorship, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_overall_compliance_with_regulations_on_smoke_free_14922c2d (
  "year" INTEGER,
  "country" VARCHAR,
  "overall_compliance_with_regulations_on_smoke_free_envi_4f1c8ad4" INTEGER  -- Overall Compliance With Regulations On Smoke Free Environments, Score,
  "overall_compliance_with_regulations_on_smoke_free_envi_a39ce982" VARCHAR  -- Overall Compliance With Regulations On Smoke Free Environments, Score Low,
  "overall_compliance_with_regulations_on_smoke_free_envi_3c477786" VARCHAR  -- Overall Compliance With Regulations On Smoke Free Environments, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_overall_compliance_with_regulations_on_smoke_free_89b3eb13 (
  "year" INTEGER,
  "country" VARCHAR,
  "overall_compliance_with_regulations_on_smoke_free_envi_4f1c8ad4" INTEGER  -- Overall Compliance With Regulations On Smoke Free Environments, Score
);

CREATE TABLE owid_overweight_numbers_among_children_under_5_years_o_99687d71 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "overweight_numbers_among_children_under_5_years_of_age_ff67fb34" FLOAT  -- Overweight Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates,
  "overweight_numbers_among_children_under_5_years_of_age_59aa79aa" FLOAT  -- Overweight Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates Low,
  "overweight_numbers_among_children_under_5_years_of_age_923b0373" FLOAT  -- Overweight Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates High,
  "comments" VARCHAR
);