Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
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_e_c76efa7a" VARCHAR,
"alcohol_expenditure_as_a_per_cent_of_total_household_e_cbe5b5cf" VARCHAR,
"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
);
CREATE TABLE owid_alcohol_former_drinkers_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_former_drinkers_pct" FLOAT
);
CREATE TABLE owid_alcohol_former_drinkers_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_former_drinkers_pct" FLOAT,
"alcohol_former_drinkers_pct_low" FLOAT,
"alcohol_former_drinkers_pct_high" FLOAT,
"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
);
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_wit_142512fc" VARCHAR,
"alcohol_harmful_use_15plus_12_month_prevalence_pct_wit_97c04dd4" VARCHAR,
"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_p_e29f08f4" FLOAT,
"alcohol_heavy_episodic_drinking_15plus_drinkers_only_p_2643bb5a" FLOAT,
"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
);
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_pc_92e9ba64" FLOAT,
"alcohol_heavy_episodic_drinking_15plus_past_30_days_pc_273e7004" FLOAT,
"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
);
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_governme_3c28af7a" VARCHAR,
"alcoholic_excise_tax_revenue_as_a_per_cent_of_governme_e2155062" VARCHAR,
"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
);
CREATE TABLE owid_alcoholic_psychosis_incidence_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"alcoholic_psychosis_incidence_per_100_000" FLOAT
);
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_low" VARCHAR,
"alcoholic_psychosis_incidence_per_100_000_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_patterns_of_drinking_score_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"alcohol_patterns_of_drinking_score" VARCHAR
);
CREATE TABLE owid_alcohol_patterns_of_drinking_score_2 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_patterns_of_drinking_score" VARCHAR,
"alcohol_patterns_of_drinking_score_low" VARCHAR,
"alcohol_patterns_of_drinking_score_high" VARCHAR,
"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
);
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_litr_28de9bf4" VARCHAR,
"alcohol_recorded_per_capita_15plus_consumption_in_litr_e93e600f" VARCHAR,
"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,
"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_litr_463aa129" FLOAT,
"alcohol_recorded_per_capita_15plus_consumption_in_litr_ff470b36" FLOAT,
"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_164ad1e9" VARCHAR,
"alcohol_regional_alcohol_per_capita_15plus_consumption_ae8b016b" VARCHAR,
"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
);
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_litr_93aa8f9b" VARCHAR,
"alcohol_regional_per_capita_15plus_consumption_in_litr_f3fe917e" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.