Global Health Observatory - World Health Organization

CREATE TABLE owid_alcohol_attributable_fractions_15plus_cancer_deaths_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "alcohol_attributable_fractions_15plus_cancer_deaths" FLOAT  -- Alcohol Attributable Fractions, 15plus, Cancer Deaths,
  "alcohol_attributable_fractions_15plus_cancer_deaths_low" FLOAT  -- Alcohol Attributable Fractions, 15plus, Cancer Deaths Low,
  "alcohol_attributable_fractions_15plus_cancer_deaths_high" FLOAT  -- Alcohol Attributable Fractions, 15plus, Cancer Deaths High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_attributable_fractions_15plus_liver_cirrh_18adac18 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "alcohol_attributable_fractions_15plus_liver_cirrhosis__c59cc7ae" FLOAT  -- Alcohol Attributable Fractions, 15plus, Liver Cirrhosis Deaths, Pct,
  "alcohol_attributable_fractions_15plus_liver_cirrhosis__cdcdff2a" FLOAT  -- Alcohol Attributable Fractions, 15plus, Liver Cirrhosis Deaths, Pct Low,
  "alcohol_attributable_fractions_15plus_liver_cirrhosis__abc65c7d" FLOAT  -- Alcohol Attributable Fractions, 15plus, Liver Cirrhosis Deaths, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_attributable_fractions_15plus_liver_cirrh_c63b624d (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_attributable_fractions_15plus_liver_cirrhosis__c59cc7ae" FLOAT  -- Alcohol Attributable Fractions, 15plus, Liver Cirrhosis Deaths, Pct
);

CREATE TABLE owid_alcohol_attributable_fractions_15plus_road_traffi_7c8173b3 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "alcohol_attributable_fractions_15plus_road_traffic_cra_cb55c7c5" FLOAT  -- Alcohol Attributable Fractions, 15plus, Road Traffic Crash Deaths, Pct,
  "alcohol_attributable_fractions_15plus_road_traffic_cra_572e5e05" FLOAT  -- Alcohol Attributable Fractions, 15plus, Road Traffic Crash Deaths, Pct Low,
  "alcohol_attributable_fractions_15plus_road_traffic_cra_b6200423" FLOAT  -- Alcohol Attributable Fractions, 15plus, Road Traffic Crash Deaths, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_attributable_fractions_15plus_road_traffi_a220671c (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_attributable_fractions_15plus_road_traffic_cra_cb55c7c5" VARCHAR  -- Alcohol Attributable Fractions, 15plus, Road Traffic Crash Deaths, Pct
);

CREATE TABLE owid_alcohol_attributable_fractions_all_cause_deaths_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_attributable_fractions_all_cause_deaths_pct" FLOAT  -- Alcohol Attributable Fractions, All Cause Deaths, Pct
);

CREATE TABLE owid_alcohol_attributable_fractions_all_cause_deaths_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "alcohol_attributable_fractions_all_cause_deaths_pct" FLOAT  -- Alcohol Attributable Fractions, All Cause Deaths, Pct,
  "alcohol_attributable_fractions_all_cause_deaths_pct_low" FLOAT  -- Alcohol Attributable Fractions, All Cause Deaths, Pct Low,
  "alcohol_attributable_fractions_all_cause_deaths_pct_high" FLOAT  -- Alcohol Attributable Fractions, All Cause Deaths, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_attributable_years_of_life_lost_yll_score_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcohol_attributable_years_of_life_lost_yll_score" INTEGER  -- Alcohol Attributable Years Of Life Lost, Yll, Score
);

CREATE TABLE owid_alcohol_attributable_years_of_life_lost_yll_score_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcohol_attributable_years_of_life_lost_yll_score" INTEGER  -- Alcohol Attributable Years Of Life Lost, Yll, Score,
  "alcohol_attributable_years_of_life_lost_yll_score_low" VARCHAR  -- Alcohol Attributable Years Of Life Lost, Yll, Score Low,
  "alcohol_attributable_years_of_life_lost_yll_score_high" VARCHAR  -- Alcohol Attributable Years Of Life Lost, Yll, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_average_daily_intake_in_grams_among_drink_80e3c677 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_average_daily_intake_in_grams_among_drinkers_w_0fd3d190" FLOAT  -- Alcohol, Average Daily Intake In Grams Among Drinkers With 95pctci,
  "alcohol_average_daily_intake_in_grams_among_drinkers_w_a2e6773b" FLOAT  -- Alcohol, Average Daily Intake In Grams Among Drinkers With 95pctci Low,
  "alcohol_average_daily_intake_in_grams_among_drinkers_w_d02bf3e2" FLOAT  -- Alcohol, Average Daily Intake In Grams Among Drinkers With 95pctci High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_average_daily_intake_in_grams_among_drink_81dd5070 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_average_daily_intake_in_grams_among_drinkers_w_0fd3d190" FLOAT  -- Alcohol, Average Daily Intake In Grams Among Drinkers With 95pctci
);

CREATE TABLE owid_alcohol_consumers_past_12_months_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_consumers_past_12_months_pct" FLOAT  -- Alcohol, Consumers Past 12 Months, Pct
);

CREATE TABLE owid_alcohol_consumers_past_12_months_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_consumers_past_12_months_pct" FLOAT  -- Alcohol, Consumers Past 12 Months, Pct,
  "alcohol_consumers_past_12_months_pct_low" FLOAT  -- Alcohol, Consumers Past 12 Months, Pct Low,
  "alcohol_consumers_past_12_months_pct_high" FLOAT  -- Alcohol, Consumers Past 12 Months, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_consumption_of_pure_alcohol_by_type_of_be_fa92009f (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "alcohol_consumption_of_pure_alcohol_by_type_of_beverage_pct" VARCHAR  -- Alcohol, Consumption Of Pure Alcohol By Type Of Beverage, Pct,
  "alcohol_consumption_of_pure_alcohol_by_type_of_beverage_pct_low" VARCHAR  -- Alcohol, Consumption Of Pure Alcohol By Type Of Beverage, Pct Low,
  "alcohol_consumption_of_pure_alcohol_by_type_of_beverag_944fce50" VARCHAR  -- Alcohol, Consumption Of Pure Alcohol By Type Of Beverage, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_consumption_of_pure_alcohol_by_type_of_be_ff395eec (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "alcohol_consumption_of_pure_alcohol_by_type_of_beverage_pct" VARCHAR  -- Alcohol, Consumption Of Pure Alcohol By Type Of Beverage, Pct
);

CREATE TABLE owid_alcohol_content_displayed_on_containers_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "alcohol_content_displayed_on_containers" VARCHAR
);

CREATE TABLE owid_alcohol_content_displayed_on_containers_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "alcohol_content_displayed_on_containers" VARCHAR,
  "alcohol_content_displayed_on_containers_low" VARCHAR,
  "alcohol_content_displayed_on_containers_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_content_in_beverage_in_percent_of_volume__9a093cb1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "alcohol_content_in_beverage_in_percent_of_volume_alcoh_93c1a70d" FLOAT  -- Alcohol Content In Beverage In Percent Of Volume, Alcohol By Volume, Abv Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_content_in_beverage_in_percent_of_volume__f7f225f4 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "alcohol_content_in_beverage_in_percent_of_volume_alcoh_93c1a70d" FLOAT  -- Alcohol Content In Beverage In Percent Of Volume, Alcohol By Volume, Abv Pct,
  "alcohol_content_in_beverage_in_percent_of_volume_alcoh_6884cdf2" VARCHAR  -- Alcohol Content In Beverage In Percent Of Volume, Alcohol By Volume, Abv Pct Low,
  "alcohol_content_in_beverage_in_percent_of_volume_alcoh_da515647" VARCHAR  -- Alcohol Content In Beverage In Percent Of Volume, Alcohol By Volume, Abv Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_dependence_15plus_12_month_prevalence_pct_8fe64c98 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_dependence_15plus_12_month_prevalence_pct_with_95pctci" FLOAT  -- Alcohol Dependence, 15plus, 12 Month Prevalence, Pct, With 95pctci,
  "alcohol_dependence_15plus_12_month_prevalence_pct_with_e41033ff" VARCHAR  -- Alcohol Dependence, 15plus, 12 Month Prevalence, Pct, With 95pctci Low,
  "alcohol_dependence_15plus_12_month_prevalence_pct_with_4303d2af" VARCHAR  -- Alcohol Dependence, 15plus, 12 Month Prevalence, Pct, With 95pctci High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_dependence_15plus_12_month_prevalence_pct_e99f9603 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_dependence_15plus_12_month_prevalence_pct_with_95pctci" FLOAT  -- Alcohol Dependence, 15plus, 12 Month Prevalence, Pct, With 95pctci
);

CREATE TABLE owid_alcohol_drinkers_only_per_capita_15plus_consumpti_44c1d16b (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_drinkers_only_per_capita_15plus_consumption_in_f4dbea84" FLOAT  -- Alcohol, Drinkers Only Per Capita, 15plus, Consumption In Litres Of Pure Alcohol,
  "alcohol_drinkers_only_per_capita_15plus_consumption_in_bac55602" FLOAT  -- Alcohol, Drinkers Only Per Capita, 15plus, Consumption In Litres Of Pure Alcohol Low,
  "alcohol_drinkers_only_per_capita_15plus_consumption_in_a9a005c3" FLOAT  -- Alcohol, Drinkers Only Per Capita, 15plus, Consumption In Litres Of Pure Alcohol High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_drinkers_only_per_capita_15plus_consumpti_e36783ee (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "alcohol_drinkers_only_per_capita_15plus_consumption_in_f4dbea84" FLOAT  -- Alcohol, Drinkers Only Per Capita, 15plus, Consumption In Litres Of Pure Alcohol
);

CREATE TABLE owid_alcohol_estimate_of_five_year_change_in_recorded__12cdee60 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcohol_estimate_of_five_year_change_in_recorded_per_c_24570d78" VARCHAR  -- Alcohol, Estimate Of Five Year Change In Recorded Per Capita, 15plus, Consumption 2006–2010,
  "alcohol_estimate_of_five_year_change_in_recorded_per_c_f296445a" VARCHAR  -- Alcohol, Estimate Of Five Year Change In Recorded Per Capita, 15plus, Consumption 2006–2010 Low,
  "alcohol_estimate_of_five_year_change_in_recorded_per_c_4e3dd214" VARCHAR  -- Alcohol, Estimate Of Five Year Change In Recorded Per Capita, 15plus, Consumption 2006–2010 High,
  "comments" VARCHAR
);

CREATE TABLE owid_alcohol_estimate_of_five_year_change_in_recorded__e033914e (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "alcohol_estimate_of_five_year_change_in_recorded_per_c_24570d78" VARCHAR  -- Alcohol, Estimate Of Five Year Change In Recorded Per Capita, 15plus, Consumption 2006–2010
);