Global Health Observatory - World Health Organization

CREATE TABLE owid_licenses_issued_for_retail_sale_change_since_2010_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "licenses_issued_for_retail_sale_change_since_2010" VARCHAR  -- Licenses Issued For Retail Sale, Change Since 2010,
  "licenses_issued_for_retail_sale_change_since_2010_low" VARCHAR  -- Licenses Issued For Retail Sale, Change Since 2010 Low,
  "licenses_issued_for_retail_sale_change_since_2010_high" VARCHAR  -- Licenses Issued For Retail Sale, Change Since 2010 High,
  "comments" VARCHAR
);

CREATE TABLE owid_licenses_issued_for_wholesale_distribution_change_14143045 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "licenses_issued_for_wholesale_distribution_change_since_2010" VARCHAR  -- Licenses Issued For Wholesale Distribution, Change Since 2010
);

CREATE TABLE owid_licenses_issued_for_wholesale_distribution_change_26deffde (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "licenses_issued_for_wholesale_distribution_change_since_2010" VARCHAR  -- Licenses Issued For Wholesale Distribution, Change Since 2010,
  "licenses_issued_for_wholesale_distribution_change_sinc_6e99c6b1" VARCHAR  -- Licenses Issued For Wholesale Distribution, Change Since 2010 Low,
  "licenses_issued_for_wholesale_distribution_change_sinc_32c02d37" VARCHAR  -- Licenses Issued For Wholesale Distribution, Change Since 2010 High,
  "comments" VARCHAR
);

CREATE TABLE owid_licensing_required_for_exports_of_alcoholic_beverages_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "licensing_required_for_exports_of_alcoholic_beverages" VARCHAR
);

CREATE TABLE owid_licensing_required_for_exports_of_alcoholic_beverages_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "licensing_required_for_exports_of_alcoholic_beverages" VARCHAR,
  "licensing_required_for_exports_of_alcoholic_beverages_low" VARCHAR,
  "licensing_required_for_exports_of_alcoholic_beverages_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_licensing_required_for_imports_of_alcoholic_beverages_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "licensing_required_for_imports_of_alcoholic_beverages" VARCHAR
);

CREATE TABLE owid_licensing_required_for_imports_of_alcoholic_beverages_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "licensing_required_for_imports_of_alcoholic_beverages" VARCHAR,
  "licensing_required_for_imports_of_alcoholic_beverages_low" VARCHAR,
  "licensing_required_for_imports_of_alcoholic_beverages_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_licensing_required_for_wholesale_distribution_of__60ca084f (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "licensing_required_for_wholesale_distribution_of_alcoh_49000f45" VARCHAR  -- Licensing Required For Wholesale Distribution Of Alcoholic Beverages,
  "licensing_required_for_wholesale_distribution_of_alcoh_8b6a4cf5" VARCHAR  -- Licensing Required For Wholesale Distribution Of Alcoholic Beverages Low,
  "licensing_required_for_wholesale_distribution_of_alcoh_f066a242" VARCHAR  -- Licensing Required For Wholesale Distribution Of Alcoholic Beverages High,
  "comments" VARCHAR
);

CREATE TABLE owid_licensing_required_for_wholesale_distribution_of__fa9c9663 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "licensing_required_for_wholesale_distribution_of_alcoh_49000f45" VARCHAR  -- Licensing Required For Wholesale Distribution Of Alcoholic Beverages
);

CREATE TABLE owid_life_expectancy_at_age_60_years_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "life_expectancy_at_age_60_years" FLOAT  -- Life Expectancy At Age 60, Years
);

CREATE TABLE owid_life_expectancy_at_age_60_years_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "life_expectancy_at_age_60_years" FLOAT  -- Life Expectancy At Age 60, Years,
  "life_expectancy_at_age_60_years_low" FLOAT  -- Life Expectancy At Age 60, Years Low,
  "life_expectancy_at_age_60_years_high" FLOAT  -- Life Expectancy At Age 60, Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_life_expectancy_at_birth_years_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "life_expectancy_at_birth_years" FLOAT  -- Life Expectancy At Birth, Years
);

CREATE TABLE owid_life_expectancy_at_birth_years_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "life_expectancy_at_birth_years" FLOAT  -- Life Expectancy At Birth, Years,
  "life_expectancy_at_birth_years_low" FLOAT  -- Life Expectancy At Birth, Years Low,
  "life_expectancy_at_birth_years_high" FLOAT  -- Life Expectancy At Birth, Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_lifetime_prevalence_of_child_emotional_abuse_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "lifetime_prevalence_of_child_emotional_abuse_pct" FLOAT  -- Lifetime Prevalence Of Child Emotional Abuse, Pct
);

CREATE TABLE owid_lifetime_prevalence_of_child_emotional_abuse_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "lifetime_prevalence_of_child_emotional_abuse_pct" FLOAT  -- Lifetime Prevalence Of Child Emotional Abuse, Pct,
  "lifetime_prevalence_of_child_emotional_abuse_pct_low" VARCHAR  -- Lifetime Prevalence Of Child Emotional Abuse, Pct Low,
  "lifetime_prevalence_of_child_emotional_abuse_pct_high" VARCHAR  -- Lifetime Prevalence Of Child Emotional Abuse, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_lifetime_prevalence_of_child_physical_abuse_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "lifetime_prevalence_of_child_physical_abuse_pct" FLOAT  -- Lifetime Prevalence Of Child Physical Abuse, Pct
);

CREATE TABLE owid_lifetime_prevalence_of_child_physical_abuse_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "lifetime_prevalence_of_child_physical_abuse_pct" FLOAT  -- Lifetime Prevalence Of Child Physical Abuse, Pct,
  "lifetime_prevalence_of_child_physical_abuse_pct_low" VARCHAR  -- Lifetime Prevalence Of Child Physical Abuse, Pct Low,
  "lifetime_prevalence_of_child_physical_abuse_pct_high" VARCHAR  -- Lifetime Prevalence Of Child Physical Abuse, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_lifetime_prevalence_of_child_physical_neglect_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "lifetime_prevalence_of_child_physical_neglect_pct" FLOAT  -- Lifetime Prevalence Of Child Physical Neglect, Pct
);

CREATE TABLE owid_lifetime_prevalence_of_child_physical_neglect_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "lifetime_prevalence_of_child_physical_neglect_pct" FLOAT  -- Lifetime Prevalence Of Child Physical Neglect, Pct,
  "lifetime_prevalence_of_child_physical_neglect_pct_low" VARCHAR  -- Lifetime Prevalence Of Child Physical Neglect, Pct Low,
  "lifetime_prevalence_of_child_physical_neglect_pct_high" VARCHAR  -- Lifetime Prevalence Of Child Physical Neglect, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_lifetime_prevalence_of_child_sexual_abuse_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "lifetime_prevalence_of_child_sexual_abuse_pct" FLOAT  -- Lifetime Prevalence Of Child Sexual Abuse, Pct
);

CREATE TABLE owid_lifetime_prevalence_of_child_sexual_abuse_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "lifetime_prevalence_of_child_sexual_abuse_pct" FLOAT  -- Lifetime Prevalence Of Child Sexual Abuse, Pct,
  "lifetime_prevalence_of_child_sexual_abuse_pct_low" VARCHAR  -- Lifetime Prevalence Of Child Sexual Abuse, Pct Low,
  "lifetime_prevalence_of_child_sexual_abuse_pct_high" VARCHAR  -- Lifetime Prevalence Of Child Sexual Abuse, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_liver_cirrhosis_age_standardized_death_rates_15pl_2014c33c (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "liver_cirrhosis_age_standardized_death_rates_15plus_pe_f036e804" FLOAT  -- Liver Cirrhosis, Age Standardized Death Rates, 15plus, Per 100–000 Population,
  "liver_cirrhosis_age_standardized_death_rates_15plus_pe_fff288f6" VARCHAR  -- Liver Cirrhosis, Age Standardized Death Rates, 15plus, Per 100–000 Population Low,
  "liver_cirrhosis_age_standardized_death_rates_15plus_pe_8f305db0" VARCHAR  -- Liver Cirrhosis, Age Standardized Death Rates, 15plus, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_liver_cirrhosis_age_standardized_death_rates_15pl_e638d04e (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "liver_cirrhosis_age_standardized_death_rates_15plus_pe_f036e804" FLOAT  -- Liver Cirrhosis, Age Standardized Death Rates, 15plus, Per 100–000 Population
);

CREATE TABLE owid_low_birth_weight_number_in_thousands_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "low_birth_weight_number_in_thousands" FLOAT  -- Low Birth Weight Number, In Thousands,
  "comments" VARCHAR
);

CREATE TABLE owid_low_birth_weight_number_in_thousands_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "low_birth_weight_number_in_thousands" FLOAT  -- Low Birth Weight Number, In Thousands,
  "low_birth_weight_number_in_thousands_low" FLOAT  -- Low Birth Weight Number, In Thousands Low,
  "low_birth_weight_number_in_thousands_high" FLOAT  -- Low Birth Weight Number, In Thousands High,
  "comments" VARCHAR
);