Global Health Observatory - World Health Organization

CREATE TABLE owid_number_of_deaths_due_to_tuberculosis_excluding_hiv_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_deaths_due_to_tuberculosis_excluding_hiv" UINTEGER  -- Number Of Deaths Due To Tuberculosis, Excluding Hiv
);

CREATE TABLE owid_number_of_deaths_due_to_tuberculosis_excluding_hiv_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_deaths_due_to_tuberculosis_excluding_hiv" UINTEGER  -- Number Of Deaths Due To Tuberculosis, Excluding Hiv,
  "number_of_deaths_due_to_tuberculosis_excluding_hiv_low" UINTEGER  -- Number Of Deaths Due To Tuberculosis, Excluding Hiv Low,
  "number_of_deaths_due_to_tuberculosis_excluding_hiv_high" UINTEGER  -- Number Of Deaths Due To Tuberculosis, Excluding Hiv High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_diarrhoea_dalys_from_inadequate_hygiene_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_dalys_from_inadequate_hygiene" UINTEGER
);

CREATE TABLE owid_number_of_diarrhoea_dalys_from_inadequate_hygiene_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_dalys_from_inadequate_hygiene" UINTEGER,
  "number_of_diarrhoea_dalys_from_inadequate_hygiene_low" UINTEGER,
  "number_of_diarrhoea_dalys_from_inadequate_hygiene_high" UINTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_diarrhoea_dalys_from_inadequate_sanitation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_dalys_from_inadequate_sanitation" FLOAT
);

CREATE TABLE owid_number_of_diarrhoea_dalys_from_inadequate_sanitation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_dalys_from_inadequate_sanitation" FLOAT,
  "number_of_diarrhoea_dalys_from_inadequate_sanitation_low" FLOAT,
  "number_of_diarrhoea_dalys_from_inadequate_sanitation_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_diarrhoea_dalys_from_inadequate_water_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_dalys_from_inadequate_water" FLOAT
);

CREATE TABLE owid_number_of_diarrhoea_dalys_from_inadequate_water_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_dalys_from_inadequate_water" FLOAT,
  "number_of_diarrhoea_dalys_from_inadequate_water_low" FLOAT,
  "number_of_diarrhoea_dalys_from_inadequate_water_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_diarrhoea_dalys_from_inadequate_water_s_4ea5b74b (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_dalys_from_inadequate_water_sanita_6dbeb45b" UINTEGER  -- Number Of Diarrhoea Dalys From Inadequate Water, Sanitation And Hygiene,
  "number_of_diarrhoea_dalys_from_inadequate_water_sanita_58de3354" UINTEGER  -- Number Of Diarrhoea Dalys From Inadequate Water, Sanitation And Hygiene Low,
  "number_of_diarrhoea_dalys_from_inadequate_water_sanita_19f282cc" UINTEGER  -- Number Of Diarrhoea Dalys From Inadequate Water, Sanitation And Hygiene High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_diarrhoea_dalys_from_inadequate_water_s_87db16b6 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_dalys_from_inadequate_water_sanita_6dbeb45b" UINTEGER  -- Number Of Diarrhoea Dalys From Inadequate Water, Sanitation And Hygiene
);

CREATE TABLE owid_number_of_diarrhoea_deaths_from_inadequate_hygiene_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_deaths_from_inadequate_hygiene" UINTEGER
);

CREATE TABLE owid_number_of_diarrhoea_deaths_from_inadequate_hygiene_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_deaths_from_inadequate_hygiene" UINTEGER,
  "number_of_diarrhoea_deaths_from_inadequate_hygiene_low" UINTEGER,
  "number_of_diarrhoea_deaths_from_inadequate_hygiene_high" UINTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_diarrhoea_deaths_from_inadequate_sanitation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_deaths_from_inadequate_sanitation" FLOAT
);

CREATE TABLE owid_number_of_diarrhoea_deaths_from_inadequate_sanitation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_deaths_from_inadequate_sanitation" FLOAT,
  "number_of_diarrhoea_deaths_from_inadequate_sanitation_low" FLOAT,
  "number_of_diarrhoea_deaths_from_inadequate_sanitation_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_diarrhoea_deaths_from_inadequate_water_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_deaths_from_inadequate_water" FLOAT
);

CREATE TABLE owid_number_of_diarrhoea_deaths_from_inadequate_water_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_deaths_from_inadequate_water" FLOAT,
  "number_of_diarrhoea_deaths_from_inadequate_water_low" FLOAT,
  "number_of_diarrhoea_deaths_from_inadequate_water_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_diarrhoea_deaths_from_inadequate_water__2177569b (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_deaths_from_inadequate_water_sanit_bcd24f74" UINTEGER  -- Number Of Diarrhoea Deaths From Inadequate Water, Sanitation And Hygiene
);

CREATE TABLE owid_number_of_diarrhoea_deaths_from_inadequate_water__ead2e9c8 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "number_of_diarrhoea_deaths_from_inadequate_water_sanit_bcd24f74" UINTEGER  -- Number Of Diarrhoea Deaths From Inadequate Water, Sanitation And Hygiene,
  "number_of_diarrhoea_deaths_from_inadequate_water_sanit_ffd1a5a9" UINTEGER  -- Number Of Diarrhoea Deaths From Inadequate Water, Sanitation And Hygiene Low,
  "number_of_diarrhoea_deaths_from_inadequate_water_sanit_41207d2a" UINTEGER  -- Number Of Diarrhoea Deaths From Inadequate Water, Sanitation And Hygiene High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_full_time_equivalent_staff_in_national_agency_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_full_time_equivalent_staff_in_national_agency" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_full_time_equivalent_staff_in_national_agency_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_full_time_equivalent_staff_in_national_agency" FLOAT,
  "number_of_full_time_equivalent_staff_in_national_agency_low" VARCHAR,
  "number_of_full_time_equivalent_staff_in_national_agency_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_geriatricians_or_psychogeriatricians_pe_4311bbb6 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_geriatricians_or_psychogeriatricians_per_100_000" FLOAT  -- Number Of Geriatricians Or Psychogeriatricians, Per 100–000
);

CREATE TABLE owid_number_of_geriatricians_or_psychogeriatricians_pe_ff1ca990 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_geriatricians_or_psychogeriatricians_per_100_000" FLOAT  -- Number Of Geriatricians Or Psychogeriatricians, Per 100–000,
  "number_of_geriatricians_or_psychogeriatricians_per_100_000_low" VARCHAR  -- Number Of Geriatricians Or Psychogeriatricians, Per 100–000 Low,
  "number_of_geriatricians_or_psychogeriatricians_per_100_000_high" VARCHAR  -- Number Of Geriatricians Or Psychogeriatricians, Per 100–000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_health_warnings_approved_by_the_law_for_14a8257c (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_health_warnings_approved_by_the_law_for_smok_89bd7281" INTEGER  -- Number Of Health Warnings Approved By The Law For Smokeless Tobacco Packaging,
  "number_of_health_warnings_approved_by_the_law_for_smok_d23d2934" VARCHAR  -- Number Of Health Warnings Approved By The Law For Smokeless Tobacco Packaging Low,
  "number_of_health_warnings_approved_by_the_law_for_smok_ff0180cf" VARCHAR  -- Number Of Health Warnings Approved By The Law For Smokeless Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_health_warnings_approved_by_the_law_for_233183a4 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_health_warnings_approved_by_the_law_for_ciga_ce4ce1b2" INTEGER  -- Number Of Health Warnings Approved By The Law For Cigarette Packaging,
  "number_of_health_warnings_approved_by_the_law_for_ciga_27265a2e" VARCHAR  -- Number Of Health Warnings Approved By The Law For Cigarette Packaging Low,
  "number_of_health_warnings_approved_by_the_law_for_ciga_3ecddd70" VARCHAR  -- Number Of Health Warnings Approved By The Law For Cigarette Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_health_warnings_approved_by_the_law_for_5678c900 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_health_warnings_approved_by_the_law_for_ciga_ce4ce1b2" INTEGER  -- Number Of Health Warnings Approved By The Law For Cigarette Packaging,
  "comments" VARCHAR
);