Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
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_low" FLOAT,
"alcohol_attributable_fractions_15plus_cancer_deaths_high" FLOAT,
"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__cdcdff2a" FLOAT,
"alcohol_attributable_fractions_15plus_liver_cirrhosis__abc65c7d" FLOAT,
"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
);
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_cra_572e5e05" FLOAT,
"alcohol_attributable_fractions_15plus_road_traffic_cra_b6200423" FLOAT,
"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
);
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
);
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_low" FLOAT,
"alcohol_attributable_fractions_all_cause_deaths_pct_high" FLOAT,
"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
);
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_low" VARCHAR,
"alcohol_attributable_years_of_life_lost_yll_score_high" VARCHAR,
"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_w_a2e6773b" FLOAT,
"alcohol_average_daily_intake_in_grams_among_drinkers_w_d02bf3e2" FLOAT,
"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
);
CREATE TABLE owid_alcohol_consumers_past_12_months_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_consumers_past_12_months_pct" FLOAT
);
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_low" FLOAT,
"alcohol_consumers_past_12_months_pct_high" FLOAT,
"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_low" VARCHAR,
"alcohol_consumption_of_pure_alcohol_by_type_of_beverag_944fce50" VARCHAR,
"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
);
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,
"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_alcoh_6884cdf2" VARCHAR,
"alcohol_content_in_beverage_in_percent_of_volume_alcoh_da515647" VARCHAR,
"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_e41033ff" VARCHAR,
"alcohol_dependence_15plus_12_month_prevalence_pct_with_4303d2af" VARCHAR,
"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
);
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_bac55602" FLOAT,
"alcohol_drinkers_only_per_capita_15plus_consumption_in_a9a005c3" FLOAT,
"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
);
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_c_f296445a" VARCHAR,
"alcohol_estimate_of_five_year_change_in_recorded_per_c_4e3dd214" VARCHAR,
"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
);
Anyone who has the link will be able to view this.