Global Health Observatory - World Health Organization

CREATE TABLE owid_alcohol_expenditure_as_a_per_cent_of_total_househ_0cad1dfa (
  "year" INTEGER,
  "country" VARCHAR,
  "alcohol_expenditure_as_a_per_cent_of_total_household_e_5cd4ed23" FLOAT  -- Alcohol Expenditure As A Per Cent Of Total Household Expenditure,
  "alcohol_expenditure_as_a_per_cent_of_total_household_e_c76efa7a" VARCHAR  -- Alcohol Expenditure As A Per Cent Of Total Household Expenditure Low,
  "alcohol_expenditure_as_a_per_cent_of_total_household_e_cbe5b5cf" VARCHAR  -- Alcohol Expenditure As A Per Cent Of Total Household Expenditure High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_expenditure_as_a_per_cent_of_total_househ_b5c3c5d8 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcohol_expenditure_as_a_per_cent_of_total_household_e_5cd4ed23" FLOAT  -- Alcohol Expenditure As A Per Cent Of Total Household Expenditure
);

CREATE TABLE owid_alcohol_former_drinkers_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_former_drinkers_pct" FLOAT  -- Alcohol, Former Drinkers, Pct
);

CREATE TABLE owid_alcohol_former_drinkers_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_former_drinkers_pct" FLOAT  -- Alcohol, Former Drinkers, Pct,
  "alcohol_former_drinkers_pct_low" FLOAT  -- Alcohol, Former Drinkers, Pct Low,
  "alcohol_former_drinkers_pct_high" FLOAT  -- Alcohol, Former Drinkers, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_harmful_use_15plus_12_month_prevalence_pc_49a2717e (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_harmful_use_15plus_12_month_prevalence_pct_with_95pctci" FLOAT  -- Alcohol, Harmful Use, 15plus, 12 Month Prevalence, Pct, With 95pctci
);

CREATE TABLE owid_alcohol_harmful_use_15plus_12_month_prevalence_pc_fe951ed2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_harmful_use_15plus_12_month_prevalence_pct_with_95pctci" FLOAT  -- Alcohol, Harmful Use, 15plus, 12 Month Prevalence, Pct, With 95pctci,
  "alcohol_harmful_use_15plus_12_month_prevalence_pct_wit_142512fc" VARCHAR  -- Alcohol, Harmful Use, 15plus, 12 Month Prevalence, Pct, With 95pctci Low,
  "alcohol_harmful_use_15plus_12_month_prevalence_pct_wit_97c04dd4" VARCHAR  -- Alcohol, Harmful Use, 15plus, 12 Month Prevalence, Pct, With 95pctci High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_heavy_episodic_drinking_15plus_drinkers_o_4eb12f56 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_heavy_episodic_drinking_15plus_drinkers_only_p_ff9b59cf" FLOAT  -- Alcohol, Heavy Episodic Drinking, 15plus, Drinkers Only, Past 30 Days, Pct,
  "alcohol_heavy_episodic_drinking_15plus_drinkers_only_p_e29f08f4" FLOAT  -- Alcohol, Heavy Episodic Drinking, 15plus, Drinkers Only, Past 30 Days, Pct Low,
  "alcohol_heavy_episodic_drinking_15plus_drinkers_only_p_2643bb5a" FLOAT  -- Alcohol, Heavy Episodic Drinking, 15plus, Drinkers Only, Past 30 Days, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_heavy_episodic_drinking_15plus_drinkers_o_a49933d4 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_heavy_episodic_drinking_15plus_drinkers_only_p_ff9b59cf" FLOAT  -- Alcohol, Heavy Episodic Drinking, 15plus, Drinkers Only, Past 30 Days, Pct
);

CREATE TABLE owid_alcohol_heavy_episodic_drinking_15plus_past_30_da_ba2f4cb9 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_heavy_episodic_drinking_15plus_past_30_days_pc_492525a5" FLOAT  -- Alcohol, Heavy Episodic Drinking, 15plus, Past 30 Days, Pct, Age Standardized With 95pctci,
  "alcohol_heavy_episodic_drinking_15plus_past_30_days_pc_92e9ba64" FLOAT  -- Alcohol, Heavy Episodic Drinking, 15plus, Past 30 Days, Pct, Age Standardized With 95pctci Low,
  "alcohol_heavy_episodic_drinking_15plus_past_30_days_pc_273e7004" FLOAT  -- Alcohol, Heavy Episodic Drinking, 15plus, Past 30 Days, Pct, Age Standardized With 95pctci High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_heavy_episodic_drinking_15plus_past_30_da_f8cfb456 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_heavy_episodic_drinking_15plus_past_30_days_pc_492525a5" FLOAT  -- Alcohol, Heavy Episodic Drinking, 15plus, Past 30 Days, Pct, Age Standardized With 95pctci
);

CREATE TABLE owid_alcoholic_beverage_legally_defined_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcoholic_beverage_legally_defined" VARCHAR
);

CREATE TABLE owid_alcoholic_beverage_legally_defined_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcoholic_beverage_legally_defined" VARCHAR,
  "alcoholic_beverage_legally_defined_low" VARCHAR,
  "alcoholic_beverage_legally_defined_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_alcoholic_excise_tax_revenue_as_a_per_cent_of_gov_0ad54eaa (
  "year" INTEGER,
  "country" VARCHAR,
  "alcoholic_excise_tax_revenue_as_a_per_cent_of_governme_4ea4ff5e" FLOAT  -- Alcoholic Excise Tax Revenue As A Per Cent Of Government Revenue,
  "alcoholic_excise_tax_revenue_as_a_per_cent_of_governme_3c28af7a" VARCHAR  -- Alcoholic Excise Tax Revenue As A Per Cent Of Government Revenue Low,
  "alcoholic_excise_tax_revenue_as_a_per_cent_of_governme_e2155062" VARCHAR  -- Alcoholic Excise Tax Revenue As A Per Cent Of Government Revenue High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcoholic_excise_tax_revenue_as_a_per_cent_of_gov_22de3d9b (
  "year" INTEGER,
  "country" VARCHAR,
  "alcoholic_excise_tax_revenue_as_a_per_cent_of_governme_4ea4ff5e" FLOAT  -- Alcoholic Excise Tax Revenue As A Per Cent Of Government Revenue
);

CREATE TABLE owid_alcoholic_psychosis_incidence_per_100_000_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcoholic_psychosis_incidence_per_100_000" FLOAT  -- Alcoholic Psychosis, Incidence, Per 100–000
);

CREATE TABLE owid_alcoholic_psychosis_incidence_per_100_000_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcoholic_psychosis_incidence_per_100_000" FLOAT  -- Alcoholic Psychosis, Incidence, Per 100–000,
  "alcoholic_psychosis_incidence_per_100_000_low" VARCHAR  -- Alcoholic Psychosis, Incidence, Per 100–000 Low,
  "alcoholic_psychosis_incidence_per_100_000_high" VARCHAR  -- Alcoholic Psychosis, Incidence, Per 100–000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_patterns_of_drinking_score_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "alcohol_patterns_of_drinking_score" VARCHAR  -- Alcohol, Patterns Of Drinking Score
);

CREATE TABLE owid_alcohol_patterns_of_drinking_score_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcohol_patterns_of_drinking_score" VARCHAR  -- Alcohol, Patterns Of Drinking Score,
  "alcohol_patterns_of_drinking_score_low" VARCHAR  -- Alcohol, Patterns Of Drinking Score Low,
  "alcohol_patterns_of_drinking_score_high" VARCHAR  -- Alcohol, Patterns Of Drinking Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_recorded_per_capita_15plus_consumption_in_5f425a9c (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "alcohol_recorded_per_capita_15plus_consumption_in_litr_97ac7f29" FLOAT  -- Alcohol, Recorded Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol
);

CREATE TABLE owid_alcohol_recorded_per_capita_15plus_consumption_in_cbbbead1 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcohol_recorded_per_capita_15plus_consumption_in_litr_df1ce481" FLOAT  -- Alcohol, Recorded Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol, Three Year Average,
  "alcohol_recorded_per_capita_15plus_consumption_in_litr_28de9bf4" VARCHAR  -- Alcohol, Recorded Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol, Three Year Average Low,
  "alcohol_recorded_per_capita_15plus_consumption_in_litr_e93e600f" VARCHAR  -- Alcohol, Recorded Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol, Three Year Average High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_recorded_per_capita_15plus_consumption_in_d968ad1e (
  "year" INTEGER,
  "country" VARCHAR,
  "alcohol_recorded_per_capita_15plus_consumption_in_litr_df1ce481" FLOAT  -- Alcohol, Recorded Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol, Three Year Average,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_recorded_per_capita_15plus_consumption_in_f92f9c8f (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "alcohol_recorded_per_capita_15plus_consumption_in_litr_97ac7f29" FLOAT  -- Alcohol, Recorded Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol,
  "alcohol_recorded_per_capita_15plus_consumption_in_litr_463aa129" FLOAT  -- Alcohol, Recorded Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol Low,
  "alcohol_recorded_per_capita_15plus_consumption_in_litr_ff470b36" FLOAT  -- Alcohol, Recorded Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_regional_alcohol_per_capita_15plus_consum_6501ad86 (
  "year" INTEGER,
  "country" VARCHAR,
  "consumption_type" VARCHAR,
  "alcohol_regional_alcohol_per_capita_15plus_consumption_c0c3f367" FLOAT  -- Alcohol, Regional Alcohol Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol,
  "alcohol_regional_alcohol_per_capita_15plus_consumption_164ad1e9" VARCHAR  -- Alcohol, Regional Alcohol Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol Low,
  "alcohol_regional_alcohol_per_capita_15plus_consumption_ae8b016b" VARCHAR  -- Alcohol, Regional Alcohol Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_regional_alcohol_per_capita_15plus_consum_68d4306c (
  "year" INTEGER,
  "country" VARCHAR,
  "consumption_type" VARCHAR,
  "alcohol_regional_alcohol_per_capita_15plus_consumption_c0c3f367" FLOAT  -- Alcohol, Regional Alcohol Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol
);

CREATE TABLE owid_alcohol_regional_per_capita_15plus_consumption_in_7e58afaa (
  "year" INTEGER,
  "country" VARCHAR,
  "consumption_type" VARCHAR,
  "alcohol_regional_per_capita_15plus_consumption_in_litr_bcb0dbd0" FLOAT  -- Alcohol, Regional Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol,
  "alcohol_regional_per_capita_15plus_consumption_in_litr_93aa8f9b" VARCHAR  -- Alcohol, Regional Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol Low,
  "alcohol_regional_per_capita_15plus_consumption_in_litr_f3fe917e" VARCHAR  -- Alcohol, Regional Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol High,
  "comments" VARCHAR
);