Global Health Observatory - World Health Organization

CREATE TABLE owid_data_sources_used_to_routinely_monitor_people_wit_4498058b (
  "year" INTEGER,
  "country" VARCHAR,
  "data_sources_used_to_routinely_monitor_people_with_dem_fccc68af" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Household Surveys
);

CREATE TABLE owid_data_sources_used_to_routinely_monitor_people_wit_5c8ca3f1 (
  "year" INTEGER,
  "country" VARCHAR,
  "data_sources_used_to_routinely_monitor_people_with_dem_cf45a0f4" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Clinical Records
);

CREATE TABLE owid_data_sources_used_to_routinely_monitor_people_wit_721e9c02 (
  "year" INTEGER,
  "country" VARCHAR,
  "data_sources_used_to_routinely_monitor_people_with_dem_cf45a0f4" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Clinical Records,
  "data_sources_used_to_routinely_monitor_people_with_dem_ca6858ab" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Clinical Records Low,
  "data_sources_used_to_routinely_monitor_people_with_dem_f88e28b6" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Clinical Records High,
  "comments" VARCHAR
);

CREATE TABLE owid_data_sources_used_to_routinely_monitor_people_wit_799fc780 (
  "year" INTEGER,
  "country" VARCHAR,
  "data_sources_used_to_routinely_monitor_people_with_dem_6081b13d" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Other
);

CREATE TABLE owid_data_sources_used_to_routinely_monitor_people_wit_9589df91 (
  "year" INTEGER,
  "country" VARCHAR,
  "data_sources_used_to_routinely_monitor_people_with_dem_9a21ec75" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Facility Survey Or Records,
  "data_sources_used_to_routinely_monitor_people_with_dem_af06ea82" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Facility Survey Or Records Low,
  "data_sources_used_to_routinely_monitor_people_with_dem_08d431f6" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Facility Survey Or Records High,
  "comments" VARCHAR
);

CREATE TABLE owid_data_sources_used_to_routinely_monitor_people_wit_9820c415 (
  "year" INTEGER,
  "country" VARCHAR,
  "data_sources_used_to_routinely_monitor_people_with_dem_fccc68af" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Household Surveys,
  "data_sources_used_to_routinely_monitor_people_with_dem_eaf582bb" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Household Surveys Low,
  "data_sources_used_to_routinely_monitor_people_with_dem_a58fac6f" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Household Surveys High,
  "comments" VARCHAR
);

CREATE TABLE owid_data_sources_used_to_routinely_monitor_people_wit_9c26cd61 (
  "year" INTEGER,
  "country" VARCHAR,
  "data_sources_used_to_routinely_monitor_people_with_dem_35fb5212" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Administrative Data,
  "data_sources_used_to_routinely_monitor_people_with_dem_1dde3777" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Administrative Data Low,
  "data_sources_used_to_routinely_monitor_people_with_dem_f609d60a" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Administrative Data High,
  "comments" VARCHAR
);

CREATE TABLE owid_data_sources_used_to_routinely_monitor_people_wit_c0c108a4 (
  "year" INTEGER,
  "country" VARCHAR,
  "data_sources_used_to_routinely_monitor_people_with_dem_6081b13d" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Other,
  "data_sources_used_to_routinely_monitor_people_with_dem_68f46964" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Other Low,
  "data_sources_used_to_routinely_monitor_people_with_dem_09eafca5" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Other High,
  "comments" VARCHAR
);

CREATE TABLE owid_data_sources_used_to_routinely_monitor_people_wit_fe296277 (
  "year" INTEGER,
  "country" VARCHAR,
  "data_sources_used_to_routinely_monitor_people_with_dem_9a21ec75" VARCHAR  -- Data Sources Used To Routinely Monitor People With Dementia, Facility Survey Or Records
);

CREATE TABLE owid_data_used_to_routinely_monitor_people_with_dement_adc98e21 (
  "year" INTEGER,
  "country" VARCHAR,
  "data_used_to_routinely_monitor_people_with_dementia_ca_f1c98e7a" VARCHAR  -- Data Used To Routinely Monitor People With Dementia Can Be Disaggregated
);

CREATE TABLE owid_data_used_to_routinely_monitor_people_with_dement_ecc1ce18 (
  "year" INTEGER,
  "country" VARCHAR,
  "data_used_to_routinely_monitor_people_with_dementia_ca_f1c98e7a" VARCHAR  -- Data Used To Routinely Monitor People With Dementia Can Be Disaggregated,
  "data_used_to_routinely_monitor_people_with_dementia_ca_c4887b6e" VARCHAR  -- Data Used To Routinely Monitor People With Dementia Can Be Disaggregated Low,
  "data_used_to_routinely_monitor_people_with_dementia_ca_520d4e93" VARCHAR  -- Data Used To Routinely Monitor People With Dementia Can Be Disaggregated High,
  "comments" VARCHAR
);

CREATE TABLE owid_deaths_attributable_to_the_environment_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "deaths_attributable_to_the_environment" FLOAT
);

CREATE TABLE owid_deaths_attributable_to_the_environment_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "deaths_attributable_to_the_environment" FLOAT,
  "deaths_attributable_to_the_environment_low" VARCHAR,
  "deaths_attributable_to_the_environment_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_deaths_attributable_to_the_environment_in_childre_25cd786d (
  "year" INTEGER,
  "country" VARCHAR,
  "deaths_attributable_to_the_environment_in_children_und_d81dd88e" FLOAT  -- Deaths Attributable To The Environment In Children Under 5 Years, Pct
);

CREATE TABLE owid_deaths_attributable_to_the_environment_in_childre_2e92abb8 (
  "year" INTEGER,
  "country" VARCHAR,
  "deaths_attributable_to_the_environment_in_children_und_d81dd88e" FLOAT  -- Deaths Attributable To The Environment In Children Under 5 Years, Pct,
  "deaths_attributable_to_the_environment_in_children_und_372fb418" VARCHAR  -- Deaths Attributable To The Environment In Children Under 5 Years, Pct Low,
  "deaths_attributable_to_the_environment_in_children_und_56d82588" VARCHAR  -- Deaths Attributable To The Environment In Children Under 5 Years, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_deaths_attributable_to_the_environment_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "deaths_attributable_to_the_environment_pct" FLOAT  -- Deaths Attributable To The Environment, Pct
);

CREATE TABLE owid_deaths_attributable_to_the_environment_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "deaths_attributable_to_the_environment_pct" FLOAT  -- Deaths Attributable To The Environment, Pct,
  "deaths_attributable_to_the_environment_pct_low" VARCHAR  -- Deaths Attributable To The Environment, Pct Low,
  "deaths_attributable_to_the_environment_pct_high" VARCHAR  -- Deaths Attributable To The Environment, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_deaths_due_to_hiv_aids_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "deaths_due_to_hiv_aids_per_100_000_population" FLOAT  -- Deaths Due To Hiv Aids, Per 100–000 Population,
  "comments" VARCHAR
);

CREATE TABLE owid_deaths_due_to_hiv_aids_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "deaths_due_to_hiv_aids_per_100_000_population" FLOAT  -- Deaths Due To Hiv Aids, Per 100–000 Population,
  "deaths_due_to_hiv_aids_per_100_000_population_low" VARCHAR  -- Deaths Due To Hiv Aids, Per 100–000 Population Low,
  "deaths_due_to_hiv_aids_per_100_000_population_high" VARCHAR  -- Deaths Due To Hiv Aids, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_deaths_due_to_tuberculosis_among_hiv_negative_peo_313fcecf (
  "year" INTEGER,
  "country" VARCHAR,
  "deaths_due_to_tuberculosis_among_hiv_negative_people_p_1e55275f" FLOAT  -- Deaths Due To Tuberculosis Among Hiv Negative People, Per 100–000 Population
);

CREATE TABLE owid_deaths_due_to_tuberculosis_among_hiv_negative_peo_bf991d5f (
  "year" INTEGER,
  "country" VARCHAR,
  "deaths_due_to_tuberculosis_among_hiv_negative_people_p_1e55275f" FLOAT  -- Deaths Due To Tuberculosis Among Hiv Negative People, Per 100–000 Population,
  "deaths_due_to_tuberculosis_among_hiv_negative_people_p_90b386a6" FLOAT  -- Deaths Due To Tuberculosis Among Hiv Negative People, Per 100–000 Population Low,
  "deaths_due_to_tuberculosis_among_hiv_negative_people_p_b0e21506" FLOAT  -- Deaths Due To Tuberculosis Among Hiv Negative People, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_deaths_in_children_aged_lt_5_years_by_cause (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause_of_death" VARCHAR,
  "deaths_in_children_aged_lt_5_years_by_cause" FLOAT  -- Deaths In Children Aged, Lt 5 Years, By Cause,
  "deaths_in_children_aged_lt_5_years_by_cause_low" VARCHAR  -- Deaths In Children Aged, Lt 5 Years, By Cause Low,
  "deaths_in_children_aged_lt_5_years_by_cause_high" VARCHAR  -- Deaths In Children Aged, Lt 5 Years, By Cause High,
  "comments" VARCHAR
);

CREATE TABLE owid_deaths_in_children_aged_lt_5_years_by_cause_per_1_4f3cbad7 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause_of_death" VARCHAR,
  "child_cause" VARCHAR,
  "deaths_in_children_aged_lt_5_years_by_cause_per_1_000__03154355" FLOAT  -- Deaths In Children Aged, Lt 5 Years, By Cause, Per 1–000 Live Births,
  "deaths_in_children_aged_lt_5_years_by_cause_per_1_000__2d4104db" VARCHAR  -- Deaths In Children Aged, Lt 5 Years, By Cause, Per 1–000 Live Births Low,
  "deaths_in_children_aged_lt_5_years_by_cause_per_1_000__8afad314" VARCHAR  -- Deaths In Children Aged, Lt 5 Years, By Cause, Per 1–000 Live Births High,
  "comments" VARCHAR
);

CREATE TABLE owid_dedicated_funds_for_enforcement_of_smoke_free_laws_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "dedicated_funds_for_enforcement_of_smoke_free_laws" VARCHAR
);

CREATE TABLE owid_dedicated_funds_for_enforcement_of_smoke_free_laws_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dedicated_funds_for_enforcement_of_smoke_free_laws" VARCHAR,
  "dedicated_funds_for_enforcement_of_smoke_free_laws_low" VARCHAR,
  "dedicated_funds_for_enforcement_of_smoke_free_laws_high" VARCHAR,
  "comments" VARCHAR
);