Global Health Observatory - World Health Organization

CREATE TABLE owid_accessibility_of_social_and_financial_protection__45354c96 (
  "year" INTEGER,
  "country" VARCHAR,
  "accessibility_of_social_and_financial_protection_for_d_e8a586d1" VARCHAR  -- Accessibility Of Social And Financial Protection For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
  "accessibility_of_social_and_financial_protection_for_d_f3073a65" VARCHAR  -- Accessibility Of Social And Financial Protection For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
  "accessibility_of_social_and_financial_protection_for_d_ad3b2afd" VARCHAR  -- Accessibility Of Social And Financial Protection For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
  "comments" VARCHAR
);

CREATE TABLE owid_accessibility_of_social_and_financial_protection__54b62441 (
  "year" INTEGER,
  "country" VARCHAR,
  "accessibility_of_social_and_financial_protection_for_d_e8a586d1" VARCHAR  -- Accessibility Of Social And Financial Protection For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);

CREATE TABLE owid_access_restrictions_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sunbed_access_restrictions" VARCHAR,
  "comments" VARCHAR,
  "access_restrictions" VARCHAR
);

CREATE TABLE owid_access_restrictions_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sunbed_access_restrictions" VARCHAR,
  "access_restrictions" VARCHAR,
  "access_restrictions_low" VARCHAR,
  "access_restrictions_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_access_restrictions_to_maintenance_treatment_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "maintenance_access_restrictions" VARCHAR,
  "access_restrictions_to_maintenance_treatment" VARCHAR
);

CREATE TABLE owid_access_restrictions_to_maintenance_treatment_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "maintenance_access_restrictions" VARCHAR,
  "access_restrictions_to_maintenance_treatment" VARCHAR,
  "access_restrictions_to_maintenance_treatment_low" VARCHAR,
  "access_restrictions_to_maintenance_treatment_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_access_to_a_toll_free_quit_line_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "access_to_a_toll_free_quit_line" VARCHAR
);

CREATE TABLE owid_access_to_a_toll_free_quit_line_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "access_to_a_toll_free_quit_line" VARCHAR,
  "access_to_a_toll_free_quit_line_low" VARCHAR,
  "access_to_a_toll_free_quit_line_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_action_plan_for_implementation_of_alcohol_policy_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "action_plan_for_implementation_of_alcohol_policy" VARCHAR
);

CREATE TABLE owid_action_plan_for_implementation_of_alcohol_policy_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "action_plan_for_implementation_of_alcohol_policy" VARCHAR,
  "action_plan_for_implementation_of_alcohol_policy_low" VARCHAR,
  "action_plan_for_implementation_of_alcohol_policy_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_adolescent_birth_rate_per_1000_women_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "adolescent_birth_rate_per_1000_women" FLOAT  -- Adolescent Birth Rate, Per 1000 Women,
  "comments" VARCHAR
);

CREATE TABLE owid_adolescent_birth_rate_per_1000_women_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "adolescent_birth_rate_per_1000_women" FLOAT  -- Adolescent Birth Rate, Per 1000 Women,
  "adolescent_birth_rate_per_1000_women_low" VARCHAR  -- Adolescent Birth Rate, Per 1000 Women Low,
  "adolescent_birth_rate_per_1000_women_high" VARCHAR  -- Adolescent Birth Rate, Per 1000 Women High,
  "comments" VARCHAR
);

CREATE TABLE owid_adolescent_fertility_rate_births_per_1000_women_a_317f41a5 (
  "year" INTEGER,
  "country" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "adolescent_fertility_rate_births_per_1000_women_aged_1_4dda0ad3" FLOAT  -- Adolescent Fertility Rate, Births Per 1000 Women Aged 15–19 Years,
  "adolescent_fertility_rate_births_per_1000_women_aged_1_e3abd018" FLOAT  -- Adolescent Fertility Rate, Births Per 1000 Women Aged 15–19 Years Low,
  "adolescent_fertility_rate_births_per_1000_women_aged_1_d6fdcc72" FLOAT  -- Adolescent Fertility Rate, Births Per 1000 Women Aged 15–19 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_adolescent_fertility_rate_births_per_1000_women_a_6b283635 (
  "year" INTEGER,
  "country" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "wealth_decile" VARCHAR,
  "adolescent_fertility_rate_births_per_1000_women_aged_1_4dda0ad3" FLOAT  -- Adolescent Fertility Rate, Births Per 1000 Women Aged 15–19 Years,
  "comments" VARCHAR
);

CREATE TABLE owid_adolescent_mortality_rate_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "adolescent_mortality_rate_per_100_000_population" FLOAT  -- Adolescent Mortality Rate, Per 100–000 Population
);

CREATE TABLE owid_adolescent_mortality_rate_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "adolescent_mortality_rate_per_100_000_population" FLOAT  -- Adolescent Mortality Rate, Per 100–000 Population,
  "adolescent_mortality_rate_per_100_000_population_low" FLOAT  -- Adolescent Mortality Rate, Per 100–000 Population Low,
  "adolescent_mortality_rate_per_100_000_population_high" FLOAT  -- Adolescent Mortality Rate, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_adolescent_mortality_rate_per_1_000_age_specific_cohort (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "adolescent_mortality_rate_per_1_000_age_specific_cohort" FLOAT  -- Adolescent Mortality Rate, Per 1–000 Age Specific Cohort,
  "adolescent_mortality_rate_per_1_000_age_specific_cohort_low" FLOAT  -- Adolescent Mortality Rate, Per 1–000 Age Specific Cohort Low,
  "adolescent_mortality_rate_per_1_000_age_specific_cohort_high" FLOAT  -- Adolescent Mortality Rate, Per 1–000 Age Specific Cohort High,
  "comments" VARCHAR
);

CREATE TABLE owid_adopted_written_national_policy_on_alcohol_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "adopted_written_national_policy_on_alcohol" VARCHAR
);

CREATE TABLE owid_adopted_written_national_policy_on_alcohol_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "adopted_written_national_policy_on_alcohol" VARCHAR,
  "adopted_written_national_policy_on_alcohol_low" VARCHAR,
  "adopted_written_national_policy_on_alcohol_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_adopted_written_national_policy_on_alcohol_year_adopted_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "adopted_written_national_policy_on_alcohol_year_adopted" INTEGER  -- Adopted Written National Policy On Alcohol, Year Adopted
);

CREATE TABLE owid_adopted_written_national_policy_on_alcohol_year_adopted_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "adopted_written_national_policy_on_alcohol_year_adopted" INTEGER  -- Adopted Written National Policy On Alcohol, Year Adopted,
  "adopted_written_national_policy_on_alcohol_year_adopted_low" VARCHAR  -- Adopted Written National Policy On Alcohol, Year Adopted Low,
  "adopted_written_national_policy_on_alcohol_year_adopted_high" VARCHAR  -- Adopted Written National Policy On Alcohol, Year Adopted High,
  "comments" VARCHAR
);

CREATE TABLE owid_adopted_written_national_policy_on_alcohol_year_revised_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "adopted_written_national_policy_on_alcohol_year_revised" INTEGER  -- Adopted Written National Policy On Alcohol, Year Revised
);

CREATE TABLE owid_adopted_written_national_policy_on_alcohol_year_revised_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "adopted_written_national_policy_on_alcohol_year_revised" INTEGER  -- Adopted Written National Policy On Alcohol, Year Revised,
  "adopted_written_national_policy_on_alcohol_year_revised_low" VARCHAR  -- Adopted Written National Policy On Alcohol, Year Revised Low,
  "adopted_written_national_policy_on_alcohol_year_revised_high" VARCHAR  -- Adopted Written National Policy On Alcohol, Year Revised High,
  "comments" VARCHAR
);

CREATE TABLE owid_adult_day_centre_places_per_10_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "adult_day_centre_places_per_10_000_population" INTEGER  -- Adult Day Centre Places, Per 10–000 Population
);

CREATE TABLE owid_adult_day_centre_places_per_10_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "adult_day_centre_places_per_10_000_population" INTEGER  -- Adult Day Centre Places, Per 10–000 Population,
  "adult_day_centre_places_per_10_000_population_low" VARCHAR  -- Adult Day Centre Places, Per 10–000 Population Low,
  "adult_day_centre_places_per_10_000_population_high" VARCHAR  -- Adult Day Centre Places, Per 10–000 Population High,
  "comments" VARCHAR
);