Global Health Observatory - World Health Organization

CREATE TABLE owid_ever_breastfed_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "household_wealth" VARCHAR,
  "ever_breastfed" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_ever_breastfed_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "ever_breastfed" FLOAT,
  "ever_breastfed_low" FLOAT,
  "ever_breastfed_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_excise_duty_average_per_hectolitre_in_euros_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "excise_duty_average_per_hectolitre_in_euros" FLOAT  -- Excise Duty, Average, Per Hectolitre In Euros
);

CREATE TABLE owid_excise_duty_average_per_hectolitre_in_euros_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "excise_duty_average_per_hectolitre_in_euros" FLOAT  -- Excise Duty, Average, Per Hectolitre In Euros,
  "excise_duty_average_per_hectolitre_in_euros_low" VARCHAR  -- Excise Duty, Average, Per Hectolitre In Euros Low,
  "excise_duty_average_per_hectolitre_in_euros_high" VARCHAR  -- Excise Duty, Average, Per Hectolitre In Euros High,
  "comments" VARCHAR
);

CREATE TABLE owid_excise_tax_as_a_per_cent_of_the_retail_price_of_a_1f73de7b (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "excise_tax_as_a_per_cent_of_the_retail_price_of_alcoho_d523b886" FLOAT  -- Excise Tax As A Per Cent Of The Retail Price Of Alcoholic Beverages,
  "excise_tax_as_a_per_cent_of_the_retail_price_of_alcoho_fd9cf7c9" VARCHAR  -- Excise Tax As A Per Cent Of The Retail Price Of Alcoholic Beverages Low,
  "excise_tax_as_a_per_cent_of_the_retail_price_of_alcoho_af7b951f" VARCHAR  -- Excise Tax As A Per Cent Of The Retail Price Of Alcoholic Beverages High,
  "comments" VARCHAR
);

CREATE TABLE owid_excise_tax_as_a_per_cent_of_the_retail_price_of_a_f62dc3f8 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "excise_tax_as_a_per_cent_of_the_retail_price_of_alcoho_d523b886" FLOAT  -- Excise Tax As A Per Cent Of The Retail Price Of Alcoholic Beverages,
  "comments" VARCHAR
);

CREATE TABLE owid_excise_tax_as_a_per_cent_of_the_total_retail_pric_08ca4998 (
  "year" INTEGER,
  "country" VARCHAR,
  "excise_tax_as_a_per_cent_of_the_total_retail_price_for_d9ed5306" FLOAT  -- Excise Tax As A Per Cent Of The Total Retail Price For 1 Litre Of Pure Alcohol,
  "excise_tax_as_a_per_cent_of_the_total_retail_price_for_3ab04056" VARCHAR  -- Excise Tax As A Per Cent Of The Total Retail Price For 1 Litre Of Pure Alcohol Low,
  "excise_tax_as_a_per_cent_of_the_total_retail_price_for_666c959b" VARCHAR  -- Excise Tax As A Per Cent Of The Total Retail Price For 1 Litre Of Pure Alcohol High,
  "comments" VARCHAR
);

CREATE TABLE owid_excise_tax_as_a_per_cent_of_the_total_retail_pric_b369dac3 (
  "year" INTEGER,
  "country" VARCHAR,
  "excise_tax_as_a_per_cent_of_the_total_retail_price_for_d9ed5306" FLOAT  -- Excise Tax As A Per Cent Of The Total Retail Price For 1 Litre Of Pure Alcohol
);

CREATE TABLE owid_excise_taxes_are_applied_on_beverages_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "comments" VARCHAR,
  "excise_taxes_are_applied_on_beverages" VARCHAR
);

CREATE TABLE owid_excise_taxes_are_applied_on_beverages_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "excise_taxes_are_applied_on_beverages" VARCHAR,
  "excise_taxes_are_applied_on_beverages_low" VARCHAR,
  "excise_taxes_are_applied_on_beverages_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_excise_taxes_on_beverages_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "excise_tax_type" VARCHAR,
  "beverage" VARCHAR,
  "excise_taxes_on_beverages_pct" FLOAT  -- Excise Taxes On Beverages, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_excise_taxes_on_beverages_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "excise_tax_type" VARCHAR,
  "excise_taxes_on_beverages_pct" FLOAT  -- Excise Taxes On Beverages, Pct,
  "excise_taxes_on_beverages_pct_low" VARCHAR  -- Excise Taxes On Beverages, Pct Low,
  "excise_taxes_on_beverages_pct_high" VARCHAR  -- Excise Taxes On Beverages, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_excise_tax_on_alcoholic_beverages_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "excise_tax_on_alcoholic_beverages" VARCHAR
);

CREATE TABLE owid_excise_tax_on_alcoholic_beverages_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "excise_tax_on_alcoholic_beverages" VARCHAR,
  "excise_tax_on_alcoholic_beverages_low" VARCHAR,
  "excise_tax_on_alcoholic_beverages_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_exclusive_breastfeeding_under_6_months_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "exclusive_breastfeeding_under_6_months_pct" FLOAT  -- Exclusive Breastfeeding Under 6 Months, Pct
);

CREATE TABLE owid_exclusive_breastfeeding_under_6_months_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "exclusive_breastfeeding_under_6_months_pct" FLOAT  -- Exclusive Breastfeeding Under 6 Months, Pct,
  "exclusive_breastfeeding_under_6_months_pct_low" VARCHAR  -- Exclusive Breastfeeding Under 6 Months, Pct Low,
  "exclusive_breastfeeding_under_6_months_pct_high" VARCHAR  -- Exclusive Breastfeeding Under 6 Months, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_exclusive_breastfeeding_under_six_months_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "household_wealth" VARCHAR,
  "exclusive_breastfeeding_under_six_months" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_exclusive_breastfeeding_under_six_months_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "exclusive_breastfeeding_under_six_months" FLOAT,
  "exclusive_breastfeeding_under_six_months_low" FLOAT,
  "exclusive_breastfeeding_under_six_months_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_exclusive_breastfeeding_under_six_months_in_thousands_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "exclusive_breastfeeding_under_six_months_in_thousands" FLOAT  -- Exclusive Breastfeeding Under Six Months, In Thousands,
  "comments" VARCHAR
);

CREATE TABLE owid_exclusive_breastfeeding_under_six_months_in_thousands_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "exclusive_breastfeeding_under_six_months_in_thousands" FLOAT  -- Exclusive Breastfeeding Under Six Months, In Thousands,
  "exclusive_breastfeeding_under_six_months_in_thousands_low" FLOAT  -- Exclusive Breastfeeding Under Six Months, In Thousands Low,
  "exclusive_breastfeeding_under_six_months_in_thousands_high" FLOAT  -- Exclusive Breastfeeding Under Six Months, In Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_exclusively_breastfed_for_the_first_two_days_after_birth_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "household_wealth" VARCHAR,
  "exclusively_breastfed_for_the_first_two_days_after_birth" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_exclusively_breastfed_for_the_first_two_days_after_birth_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "exclusively_breastfed_for_the_first_two_days_after_birth" FLOAT,
  "exclusively_breastfed_for_the_first_two_days_after_birth_low" FLOAT,
  "exclusively_breastfed_for_the_first_two_days_after_birth_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_ex_expectation_of_life_at_age_x (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "ex_expectation_of_life_at_age_x" FLOAT  -- Ex, Expectation Of Life At Age X,
  "ex_expectation_of_life_at_age_x_low" VARCHAR  -- Ex, Expectation Of Life At Age X Low,
  "ex_expectation_of_life_at_age_x_high" VARCHAR  -- Ex, Expectation Of Life At Age X High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_a_current_dementia_research_plan_programme_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_current_dementia_research_plan_programme" VARCHAR
);

CREATE TABLE owid_existence_of_a_current_dementia_research_plan_programme_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_current_dementia_research_plan_programme" VARCHAR,
  "existence_of_a_current_dementia_research_plan_programme_low" VARCHAR,
  "existence_of_a_current_dementia_research_plan_programme_high" VARCHAR,
  "comments" VARCHAR
);