Global Health Observatory - World Health Organization

CREATE TABLE owid_definition_of_drink_driving_by_bac_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "definition_of_drink_driving_by_bac" VARCHAR
);

CREATE TABLE owid_definition_of_drink_driving_by_bac_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "definition_of_drink_driving_by_bac" VARCHAR,
  "definition_of_drink_driving_by_bac_low" VARCHAR,
  "definition_of_drink_driving_by_bac_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_demand_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "demand" VARCHAR
);

CREATE TABLE owid_demand_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "demand" VARCHAR,
  "demand_low" VARCHAR,
  "demand_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_demand_for_family_planning_satisfied_use_of_moder_383e2c94 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" 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,
  "demand_for_family_planning_satisfied_use_of_modern_and_49783c24" FLOAT  -- Demand For Family Planning Satisfied, Use Of Modern And Traditional Methods, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_demand_for_family_planning_satisfied_use_of_moder_73027ffd (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" 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,
  "demand_for_family_planning_satisfied_use_of_modern_methods_pct" FLOAT  -- Demand For Family Planning Satisfied, Use Of Modern Methods, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_demand_for_family_planning_satisfied_use_of_moder_caeac272 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" 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,
  "demand_for_family_planning_satisfied_use_of_modern_methods_pct" FLOAT  -- Demand For Family Planning Satisfied, Use Of Modern Methods, Pct,
  "demand_for_family_planning_satisfied_use_of_modern_met_272f7cae" FLOAT  -- Demand For Family Planning Satisfied, Use Of Modern Methods, Pct Low,
  "demand_for_family_planning_satisfied_use_of_modern_met_9a6e764b" FLOAT  -- Demand For Family Planning Satisfied, Use Of Modern Methods, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_demand_for_family_planning_satisfied_use_of_moder_e5a08348 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" 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,
  "demand_for_family_planning_satisfied_use_of_modern_and_49783c24" FLOAT  -- Demand For Family Planning Satisfied, Use Of Modern And Traditional Methods, Pct,
  "demand_for_family_planning_satisfied_use_of_modern_and_fdd12e19" FLOAT  -- Demand For Family Planning Satisfied, Use Of Modern And Traditional Methods, Pct Low,
  "demand_for_family_planning_satisfied_use_of_modern_and_c8c5d13a" FLOAT  -- Demand For Family Planning Satisfied, Use Of Modern And Traditional Methods, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_care_facilities_hospitals_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_care_facilities_hospitals" VARCHAR  -- Dementia Care Facilities, Hospitals
);

CREATE TABLE owid_dementia_care_facilities_hospitals_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_care_facilities_hospitals" VARCHAR  -- Dementia Care Facilities, Hospitals,
  "dementia_care_facilities_hospitals_low" VARCHAR  -- Dementia Care Facilities, Hospitals Low,
  "dementia_care_facilities_hospitals_high" VARCHAR  -- Dementia Care Facilities, Hospitals High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_integrated_into_other_national_plan_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_integrated_into_other_national_plan" VARCHAR
);

CREATE TABLE owid_dementia_integrated_into_other_national_plan_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_integrated_into_other_national_plan" VARCHAR,
  "dementia_integrated_into_other_national_plan_low" VARCHAR,
  "dementia_integrated_into_other_national_plan_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_integrated_into_other_national_research__1e7a86ba (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_integrated_into_other_national_research_plan_programme" VARCHAR,
  "dementia_integrated_into_other_national_research_plan__f262deb0" VARCHAR  -- Dementia Integrated Into Other National Research Plan Programme Low,
  "dementia_integrated_into_other_national_research_plan__a3cf2ce5" VARCHAR  -- Dementia Integrated Into Other National Research Plan Programme High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_integrated_into_other_national_research__d7845bd0 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_integrated_into_other_national_research_plan_programme" VARCHAR
);

CREATE TABLE owid_dementia_nongovernmental_organization_equipped_wi_21692916 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organization_equipped_with_office" VARCHAR
);

CREATE TABLE owid_dementia_nongovernmental_organization_equipped_wi_76f7ee78 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organization_equipped_with_office" VARCHAR,
  "dementia_nongovernmental_organization_equipped_with_office_low" VARCHAR,
  "dementia_nongovernmental_organization_equipped_with_office_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_nongovernmental_organization_office_bran_32a04c95 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organization_office_branches__66416875" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, National Only
);

CREATE TABLE owid_dementia_nongovernmental_organization_office_bran_38fc8aeb (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organization_office_branches__4f534fec" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, Sub National,
  "dementia_nongovernmental_organization_office_branches__37cbc58b" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, Sub National Low,
  "dementia_nongovernmental_organization_office_branches__f8985a93" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, Sub National High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_nongovernmental_organization_office_bran_49e31de8 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organization_office_branches__4f534fec" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, Sub National
);

CREATE TABLE owid_dementia_nongovernmental_organization_office_bran_553dff3d (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organization_office_branches_local" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, Local
);

CREATE TABLE owid_dementia_nongovernmental_organization_office_bran_dcf8f2eb (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organization_office_branches__66416875" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, National Only,
  "dementia_nongovernmental_organization_office_branches__a6f6a901" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, National Only Low,
  "dementia_nongovernmental_organization_office_branches__3e97c6dc" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, National Only High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_nongovernmental_organization_office_bran_f4df3190 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organization_office_branches_local" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, Local,
  "dementia_nongovernmental_organization_office_branches_local_low" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, Local Low,
  "dementia_nongovernmental_organization_office_branches__a33840c4" VARCHAR  -- Dementia Nongovernmental Organization Office Branches, Local High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_nongovernmental_organizations_involvemen_af15ccf2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organizations_involvement_in__86fcdf42" VARCHAR  -- Dementia Nongovernmental Organizations Involvement In Policy Development,
  "dementia_nongovernmental_organizations_involvement_in__f5e63b95" VARCHAR  -- Dementia Nongovernmental Organizations Involvement In Policy Development Low,
  "dementia_nongovernmental_organizations_involvement_in__79e63820" VARCHAR  -- Dementia Nongovernmental Organizations Involvement In Policy Development High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_nongovernmental_organizations_involvemen_eae477a4 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organizations_involvement_in__86fcdf42" VARCHAR  -- Dementia Nongovernmental Organizations Involvement In Policy Development
);

CREATE TABLE owid_dementia_nongovernmental_organization_staff_prima_0c32c316 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organization_staff_primarily__c0c14f1c" VARCHAR  -- Dementia Nongovernmental Organization Staff Primarily Salaried Volunteer
);