Global Health Observatory - World Health Organization

CREATE TABLE owid_display_of_expiry_dates_is_prevented_on_cigarette_96b4517b (
  "year" INTEGER,
  "country" VARCHAR,
  "display_of_expiry_dates_is_prevented_on_cigarette_packaging" VARCHAR,
  "display_of_expiry_dates_is_prevented_on_cigarette_packaging_low" VARCHAR,
  "display_of_expiry_dates_is_prevented_on_cigarette_pack_b64bcbf9" VARCHAR  -- Display Of Expiry Dates Is Prevented On Cigarette Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_display_of_expiry_dates_is_prevented_on_other_smo_7ff46203 (
  "year" INTEGER,
  "country" VARCHAR,
  "display_of_expiry_dates_is_prevented_on_other_smoked_t_f4a7f6a6" VARCHAR  -- Display Of Expiry Dates Is Prevented On Other Smoked Tobacco Packaging,
  "display_of_expiry_dates_is_prevented_on_other_smoked_t_a559d55c" VARCHAR  -- Display Of Expiry Dates Is Prevented On Other Smoked Tobacco Packaging Low,
  "display_of_expiry_dates_is_prevented_on_other_smoked_t_0b184373" VARCHAR  -- Display Of Expiry Dates Is Prevented On Other Smoked Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_display_of_expiry_dates_is_prevented_on_other_smo_c5cc7022 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "display_of_expiry_dates_is_prevented_on_other_smoked_t_f4a7f6a6" VARCHAR  -- Display Of Expiry Dates Is Prevented On Other Smoked Tobacco Packaging
);

CREATE TABLE owid_display_of_expiry_dates_is_prevented_on_smokeless_133a61e5 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "display_of_expiry_dates_is_prevented_on_smokeless_toba_973636ae" VARCHAR  -- Display Of Expiry Dates Is Prevented On Smokeless Tobacco Packaging
);

CREATE TABLE owid_display_of_expiry_dates_is_prevented_on_smokeless_967bf804 (
  "year" INTEGER,
  "country" VARCHAR,
  "display_of_expiry_dates_is_prevented_on_smokeless_toba_973636ae" VARCHAR  -- Display Of Expiry Dates Is Prevented On Smokeless Tobacco Packaging,
  "display_of_expiry_dates_is_prevented_on_smokeless_toba_82fd6772" VARCHAR  -- Display Of Expiry Dates Is Prevented On Smokeless Tobacco Packaging Low,
  "display_of_expiry_dates_is_prevented_on_smokeless_toba_1ecfc359" VARCHAR  -- Display Of Expiry Dates Is Prevented On Smokeless Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_distribution_of_causes_of_death_among_children_ag_bac2a68d (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause_of_death" VARCHAR,
  "child_cause" VARCHAR,
  "distribution_of_causes_of_death_among_children_aged_lt_cc72bacb" FLOAT  -- Distribution Of Causes Of Death Among Children Aged, Lt, 5 Years, Pct,
  "distribution_of_causes_of_death_among_children_aged_lt_9a0af9ad" VARCHAR  -- Distribution Of Causes Of Death Among Children Aged, Lt, 5 Years, Pct Low,
  "distribution_of_causes_of_death_among_children_aged_lt_0c3ff09f" VARCHAR  -- Distribution Of Causes Of Death Among Children Aged, Lt, 5 Years, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_distribution_of_road_traffic_deaths_by_type_of_ro_4aad98e5 (
  "year" INTEGER,
  "country" VARCHAR,
  "road_user_type" VARCHAR,
  "distribution_of_road_traffic_deaths_by_type_of_road_user_pct" FLOAT  -- Distribution Of Road Traffic Deaths By Type Of Road User, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_distribution_of_road_traffic_deaths_by_type_of_ro_d4e9cccb (
  "year" INTEGER,
  "country" VARCHAR,
  "road_user_type" VARCHAR,
  "distribution_of_road_traffic_deaths_by_type_of_road_user_pct" FLOAT  -- Distribution Of Road Traffic Deaths By Type Of Road User, Pct,
  "distribution_of_road_traffic_deaths_by_type_of_road_us_c63db05c" VARCHAR  -- Distribution Of Road Traffic Deaths By Type Of Road User, Pct Low,
  "distribution_of_road_traffic_deaths_by_type_of_road_us_9acf07a5" VARCHAR  -- Distribution Of Road Traffic Deaths By Type Of Road User, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_distribution_of_years_of_life_lost_by_major_cause_group_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "causes" VARCHAR,
  "distribution_of_years_of_life_lost_by_major_cause_group" INTEGER
);

CREATE TABLE owid_distribution_of_years_of_life_lost_by_major_cause_group_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "causes" VARCHAR,
  "distribution_of_years_of_life_lost_by_major_cause_group" INTEGER,
  "distribution_of_years_of_life_lost_by_major_cause_group_low" VARCHAR,
  "distribution_of_years_of_life_lost_by_major_cause_group_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_general_government_health_expenditure_gg_29ebb571 (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_general_government_health_expenditure_gghe_d__f164231c" FLOAT  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of Gross Domestic Product, Gdp, Pct,
  "domestic_general_government_health_expenditure_gghe_d__ee441951" VARCHAR  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of Gross Domestic Product, Gdp, Pct Low,
  "domestic_general_government_health_expenditure_gghe_d__1a8042d2" VARCHAR  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of Gross Domestic Product, Gdp, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_general_government_health_expenditure_gg_4534c5a0 (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_general_government_health_expenditure_gghe_d__25bf34f9" FLOAT  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of Current Health Expenditure, Che, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_general_government_health_expenditure_gg_63a7162e (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_general_government_health_expenditure_gghe_d__758af232" FLOAT  -- Domestic General Government Health Expenditure, Gghe D, Per Capita In Usd,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_general_government_health_expenditure_gg_6d339c34 (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_general_government_health_expenditure_gghe_d__b4f4c8df" FLOAT  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of General Government Expenditure, Gge, Pct,
  "domestic_general_government_health_expenditure_gghe_d__4db20723" VARCHAR  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of General Government Expenditure, Gge, Pct Low,
  "domestic_general_government_health_expenditure_gghe_d__6f1be21f" VARCHAR  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of General Government Expenditure, Gge, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_general_government_health_expenditure_gg_78a576a6 (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_general_government_health_expenditure_gghe_d__f164231c" FLOAT  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of Gross Domestic Product, Gdp, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_general_government_health_expenditure_gg_d661f988 (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_general_government_health_expenditure_gghe_d__758af232" FLOAT  -- Domestic General Government Health Expenditure, Gghe D, Per Capita In Usd,
  "domestic_general_government_health_expenditure_gghe_d__fcacb5d6" VARCHAR  -- Domestic General Government Health Expenditure, Gghe D, Per Capita In Usd Low,
  "domestic_general_government_health_expenditure_gghe_d__5cf3e88f" VARCHAR  -- Domestic General Government Health Expenditure, Gghe D, Per Capita In Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_general_government_health_expenditure_gg_e7431373 (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_general_government_health_expenditure_gghe_d__25bf34f9" FLOAT  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of Current Health Expenditure, Che, Pct,
  "domestic_general_government_health_expenditure_gghe_d__20bf4b27" VARCHAR  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of Current Health Expenditure, Che, Pct Low,
  "domestic_general_government_health_expenditure_gghe_d__615cfb0d" VARCHAR  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of Current Health Expenditure, Che, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_general_government_health_expenditure_gg_efc7276f (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_general_government_health_expenditure_gghe_d__b4f4c8df" FLOAT  -- Domestic General Government Health Expenditure, Gghe D, As Percentage Of General Government Expenditure, Gge, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_private_health_expenditure_pvt_d_as_perc_5566e9ea (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_private_health_expenditure_pvt_d_as_percentag_e02a635e" FLOAT  -- Domestic Private Health Expenditure, Pvt D, As Percentage Of Current Health Expenditure, Che, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_private_health_expenditure_pvt_d_as_perc_c3d627ce (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_private_health_expenditure_pvt_d_as_percentag_e02a635e" FLOAT  -- Domestic Private Health Expenditure, Pvt D, As Percentage Of Current Health Expenditure, Che, Pct,
  "domestic_private_health_expenditure_pvt_d_as_percentag_4b312794" VARCHAR  -- Domestic Private Health Expenditure, Pvt D, As Percentage Of Current Health Expenditure, Che, Pct Low,
  "domestic_private_health_expenditure_pvt_d_as_percentag_734187fb" VARCHAR  -- Domestic Private Health Expenditure, Pvt D, As Percentage Of Current Health Expenditure, Che, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_private_health_expenditure_pvt_d_per_cap_c4a1f50e (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_private_health_expenditure_pvt_d_per_capita_in_usd" FLOAT  -- Domestic Private Health Expenditure, Pvt D, Per Capita In Usd,
  "comments" VARCHAR
);

CREATE TABLE owid_domestic_private_health_expenditure_pvt_d_per_cap_cd2dedb6 (
  "year" INTEGER,
  "country" VARCHAR,
  "domestic_private_health_expenditure_pvt_d_per_capita_in_usd" FLOAT  -- Domestic Private Health Expenditure, Pvt D, Per Capita In Usd,
  "domestic_private_health_expenditure_pvt_d_per_capita_in_usd_low" VARCHAR  -- Domestic Private Health Expenditure, Pvt D, Per Capita In Usd Low,
  "domestic_private_health_expenditure_pvt_d_per_capita_i_1e032aca" VARCHAR  -- Domestic Private Health Expenditure, Pvt D, Per Capita In Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_donor_commitments_million_constant_2009_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "donor_commitments_million_constant_2009_usd" FLOAT  -- Donor Commitments, Million, Constant 2009 Usd
);

CREATE TABLE owid_donor_commitments_million_constant_2009_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "donor_commitments_million_constant_2009_usd" FLOAT  -- Donor Commitments, Million, Constant 2009 Usd,
  "donor_commitments_million_constant_2009_usd_low" VARCHAR  -- Donor Commitments, Million, Constant 2009 Usd Low,
  "donor_commitments_million_constant_2009_usd_high" VARCHAR  -- Donor Commitments, Million, Constant 2009 Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_donor_disbursements_million_constant_2009_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "donor_disbursements_million_constant_2009_usd" FLOAT  -- Donor Disbursements, Million, Constant 2009 Usd
);