Global Health Observatory - World Health Organization

CREATE TABLE owid_dentists_in_prisons_ftes_per_1000_prisoners_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "dentists_in_prisons_ftes_per_1000_prisoners" FLOAT  -- Dentists In Prisons, Ftes Per 1000 Prisoners
);

CREATE TABLE owid_dentists_in_prisons_ftes_per_1000_prisoners_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dentists_in_prisons_ftes_per_1000_prisoners" FLOAT  -- Dentists In Prisons, Ftes Per 1000 Prisoners,
  "dentists_in_prisons_ftes_per_1000_prisoners_low" VARCHAR  -- Dentists In Prisons, Ftes Per 1000 Prisoners Low,
  "dentists_in_prisons_ftes_per_1000_prisoners_high" VARCHAR  -- Dentists In Prisons, Ftes Per 1000 Prisoners High,
  "comments" VARCHAR
);

CREATE TABLE owid_dentists_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "dentists_number" UINTEGER  -- Dentists, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_dentists_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dentists_number" UINTEGER  -- Dentists, Number,
  "dentists_number_low" VARCHAR  -- Dentists, Number Low,
  "dentists_number_high" VARCHAR  -- Dentists, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_dentists_per_10_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "dentists_per_10_000_population" FLOAT  -- Dentists, Per 10–000 Population,
  "comments" VARCHAR
);

CREATE TABLE owid_dentists_per_10_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dentists_per_10_000_population" FLOAT  -- Dentists, Per 10–000 Population,
  "dentists_per_10_000_population_low" VARCHAR  -- Dentists, Per 10–000 Population Low,
  "dentists_per_10_000_population_high" VARCHAR  -- Dentists, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_designation_of_a_focal_point_responsible_for_heal_678c3750 (
  "year" INTEGER,
  "country" VARCHAR,
  "designation_of_a_focal_point_responsible_for_health_an_60510fe2" VARCHAR  -- Designation Of A Focal Point Responsible For Health And Climate Change Within The Ministry Of Health,
  "designation_of_a_focal_point_responsible_for_health_an_1cad2f6e" VARCHAR  -- Designation Of A Focal Point Responsible For Health And Climate Change Within The Ministry Of Health Low,
  "designation_of_a_focal_point_responsible_for_health_an_41aea4bf" VARCHAR  -- Designation Of A Focal Point Responsible For Health And Climate Change Within The Ministry Of Health High,
  "comments" VARCHAR
);

CREATE TABLE owid_designation_of_a_focal_point_responsible_for_heal_b0ea8e84 (
  "year" INTEGER,
  "country" VARCHAR,
  "designation_of_a_focal_point_responsible_for_health_an_60510fe2" VARCHAR  -- Designation Of A Focal Point Responsible For Health And Climate Change Within The Ministry Of Health
);

CREATE TABLE owid_designation_of_alcohol_tax_revenues_to_health_services_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "designation_of_alcohol_tax_revenues_to_health_services" VARCHAR
);

CREATE TABLE owid_designation_of_alcohol_tax_revenues_to_health_services_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "designation_of_alcohol_tax_revenues_to_health_services" VARCHAR,
  "designation_of_alcohol_tax_revenues_to_health_services_low" VARCHAR,
  "designation_of_alcohol_tax_revenues_to_health_services_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_detection_of_marketing_infringements_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "detection_of_marketing_infringements" VARCHAR
);

CREATE TABLE owid_detection_of_marketing_infringements_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "detection_of_marketing_infringements" VARCHAR,
  "detection_of_marketing_infringements_low" VARCHAR,
  "detection_of_marketing_infringements_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_diphtheria_number_of_reported_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "diphtheria_number_of_reported_cases" UINTEGER  -- Diphtheria, Number Of Reported Cases
);

CREATE TABLE owid_diphtheria_number_of_reported_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "diphtheria_number_of_reported_cases" UINTEGER  -- Diphtheria, Number Of Reported Cases,
  "diphtheria_number_of_reported_cases_low" VARCHAR  -- Diphtheria, Number Of Reported Cases Low,
  "diphtheria_number_of_reported_cases_high" VARCHAR  -- Diphtheria, Number Of Reported Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_diphtheria_tetanus_toxoid_and_pertussis_dtp3_immu_5c3f16d2 (
  "year" INTEGER,
  "country" VARCHAR,
  "diphtheria_tetanus_toxoid_and_pertussis_dtp3_immunizat_a206eb5a" INTEGER  -- Diphtheria Tetanus Toxoid And Pertussis, Dtp3, Immunization Coverage Among 1 Year Olds, Pct
);

CREATE TABLE owid_diphtheria_tetanus_toxoid_and_pertussis_dtp3_immu_e923b4a3 (
  "year" INTEGER,
  "country" VARCHAR,
  "diphtheria_tetanus_toxoid_and_pertussis_dtp3_immunizat_a206eb5a" INTEGER  -- Diphtheria Tetanus Toxoid And Pertussis, Dtp3, Immunization Coverage Among 1 Year Olds, Pct,
  "diphtheria_tetanus_toxoid_and_pertussis_dtp3_immunizat_84812df4" VARCHAR  -- Diphtheria Tetanus Toxoid And Pertussis, Dtp3, Immunization Coverage Among 1 Year Olds, Pct Low,
  "diphtheria_tetanus_toxoid_and_pertussis_dtp3_immunizat_0ec8e308" VARCHAR  -- Diphtheria Tetanus Toxoid And Pertussis, Dtp3, Immunization Coverage Among 1 Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_disability_adjusted_life_years_dalys (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "causes" VARCHAR,
  "disability_adjusted_life_years_dalys" UINTEGER  -- Disability Adjusted Life Years, Dalys,
  "disability_adjusted_life_years_dalys_low" VARCHAR  -- Disability Adjusted Life Years, Dalys Low,
  "disability_adjusted_life_years_dalys_high" VARCHAR  -- Disability Adjusted Life Years, Dalys High,
  "comments" VARCHAR
);

CREATE TABLE owid_disability_adjusted_life_years_dalys_attributable_2130fdbc (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "disability_adjusted_life_years_dalys_attributable_to_t_15bb5e13" FLOAT  -- Disability Adjusted Life Years, Dalys, Attributable To The Environment, Pct
);

CREATE TABLE owid_disability_adjusted_life_years_dalys_attributable_30351357 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "disability_adjusted_life_years_dalys_attributable_to_t_15bb5e13" FLOAT  -- Disability Adjusted Life Years, Dalys, Attributable To The Environment, Pct,
  "disability_adjusted_life_years_dalys_attributable_to_t_f5c60220" VARCHAR  -- Disability Adjusted Life Years, Dalys, Attributable To The Environment, Pct Low,
  "disability_adjusted_life_years_dalys_attributable_to_t_9322816d" VARCHAR  -- Disability Adjusted Life Years, Dalys, Attributable To The Environment, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_disability_adjusted_life_years_dalys_attributable_37e5b79a (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "disability_adjusted_life_years_dalys_attributable_to_t_b6e05dfa" FLOAT  -- Disability Adjusted Life Years, Dalys, Attributable To The Environment,
  "disability_adjusted_life_years_dalys_attributable_to_t_7d4ab5dc" VARCHAR  -- Disability Adjusted Life Years, Dalys, Attributable To The Environment Low,
  "disability_adjusted_life_years_dalys_attributable_to_t_ed16b7dc" VARCHAR  -- Disability Adjusted Life Years, Dalys, Attributable To The Environment High,
  "comments" VARCHAR
);

CREATE TABLE owid_disability_adjusted_life_years_dalys_attributable_fbfa0c7a (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "disability_adjusted_life_years_dalys_attributable_to_t_b6e05dfa" FLOAT  -- Disability Adjusted Life Years, Dalys, Attributable To The Environment
);

CREATE TABLE owid_disability_adjusted_life_years_dalys_per_100_000__b29d07c7 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "causes" VARCHAR,
  "disability_adjusted_life_years_dalys_per_100_000_population" FLOAT  -- Disability Adjusted Life Years, Dalys, Per 100–000 Population,
  "disability_adjusted_life_years_dalys_per_100_000_population_low" VARCHAR  -- Disability Adjusted Life Years, Dalys, Per 100–000 Population Low,
  "disability_adjusted_life_years_dalys_per_100_000_popul_8744d887" VARCHAR  -- Disability Adjusted Life Years, Dalys, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_disbursements_to_recipient_countries_million_cons_1d51d9a3 (
  "year" INTEGER,
  "country" VARCHAR,
  "disbursements_to_recipient_countries_million_constant_2009_usd" FLOAT  -- Disbursements To Recipient Countries, Million, Constant 2009 Usd,
  "disbursements_to_recipient_countries_million_constant__c3e55d63" VARCHAR  -- Disbursements To Recipient Countries, Million, Constant 2009 Usd Low,
  "disbursements_to_recipient_countries_million_constant__69fd2e6e" VARCHAR  -- Disbursements To Recipient Countries, Million, Constant 2009 Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_disbursements_to_recipient_countries_million_cons_2db10233 (
  "year" INTEGER,
  "country" VARCHAR,
  "disbursements_to_recipient_countries_million_constant_2009_usd" FLOAT  -- Disbursements To Recipient Countries, Million, Constant 2009 Usd
);

CREATE TABLE owid_display_of_expiry_dates_is_prevented_on_cigarette_3425426a (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "display_of_expiry_dates_is_prevented_on_cigarette_packaging" VARCHAR
);