Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_alcohol_regional_per_capita_15plus_consumption_in_a231388c (
"year" INTEGER,
"country" VARCHAR,
"consumption_type" VARCHAR,
"alcohol_regional_per_capita_15plus_consumption_in_litr_bcb0dbd0" FLOAT
);
CREATE TABLE owid_alcohol_regional_prevalence_of_alcohol_dependence_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_regional_prevalence_of_alcohol_dependence_pct" FLOAT
);
CREATE TABLE owid_alcohol_regional_prevalence_of_alcohol_dependence_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_regional_prevalence_of_alcohol_dependence_pct" FLOAT,
"alcohol_regional_prevalence_of_alcohol_dependence_pct_low" VARCHAR,
"alcohol_regional_prevalence_of_alcohol_dependence_pct_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_regional_prevalence_of_alcohol_use_disorders_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_regional_prevalence_of_alcohol_use_disorders_pct" FLOAT
);
CREATE TABLE owid_alcohol_regional_prevalence_of_alcohol_use_disorders_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_regional_prevalence_of_alcohol_use_disorders_pct" FLOAT,
"alcohol_regional_prevalence_of_alcohol_use_disorders_pct_low" VARCHAR,
"alcohol_regional_prevalence_of_alcohol_use_disorders_pct_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_related_crimes_pct_of_all_crimes_1 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_related_crimes_pct_of_all_crimes" FLOAT
);
CREATE TABLE owid_alcohol_related_crimes_pct_of_all_crimes_2 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_related_crimes_pct_of_all_crimes" FLOAT,
"alcohol_related_crimes_pct_of_all_crimes_low" VARCHAR,
"alcohol_related_crimes_pct_of_all_crimes_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_related_disease_mortality_per_100_000_15p_b1490501 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_related_disease_mortality_per_100_000_15plus_years" FLOAT,
"alcohol_related_disease_mortality_per_100_000_15plus_years_low" VARCHAR,
"alcohol_related_disease_mortality_per_100_000_15plus_years_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_related_disease_mortality_per_100_000_15p_c61b4e9f (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_related_disease_mortality_per_100_000_15plus_years" FLOAT
);
CREATE TABLE owid_alcohol_related_injury_mortality_per_1_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_related_injury_mortality_per_1_000" FLOAT
);
CREATE TABLE owid_alcohol_related_injury_mortality_per_1_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_related_injury_mortality_per_1_000" FLOAT,
"alcohol_related_injury_mortality_per_1_000_low" VARCHAR,
"alcohol_related_injury_mortality_per_1_000_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_related_road_traffic_crashes_pct_of_all_t_5ff56aeb (
"year" INTEGER,
"country" VARCHAR,
"alcohol_related_road_traffic_crashes_pct_of_all_traffic_crashes" FLOAT,
"alcohol_related_road_traffic_crashes_pct_of_all_traffi_c75cd627" VARCHAR,
"alcohol_related_road_traffic_crashes_pct_of_all_traffi_8bcf6369" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_related_road_traffic_crashes_pct_of_all_t_ac899930 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_related_road_traffic_crashes_pct_of_all_traffic_crashes" FLOAT
);
CREATE TABLE owid_alcohol_related_road_traffic_crashes_per_100_000__05377ac5 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_related_road_traffic_crashes_per_100_000_population" FLOAT
);
CREATE TABLE owid_alcohol_related_road_traffic_crashes_per_100_000__50c0528f (
"year" INTEGER,
"country" VARCHAR,
"alcohol_related_road_traffic_crashes_per_100_000_population" FLOAT,
"alcohol_related_road_traffic_crashes_per_100_000_population_low" VARCHAR,
"alcohol_related_road_traffic_crashes_per_100_000_popul_f8973c36" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_related_road_traffic_crashes_with_fatalit_7e8702a7 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_related_road_traffic_crashes_with_fatalities_p_ad70a15e" FLOAT,
"alcohol_related_road_traffic_crashes_with_fatalities_p_4e6adb2a" VARCHAR,
"alcohol_related_road_traffic_crashes_with_fatalities_p_005be6bb" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_related_road_traffic_crashes_with_fatalit_a67bff54 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_related_road_traffic_crashes_with_fatalities_p_49924a88" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_related_road_traffic_crashes_with_fatalit_c14f5fca (
"year" INTEGER,
"country" VARCHAR,
"alcohol_related_road_traffic_crashes_with_fatalities_p_49924a88" FLOAT,
"alcohol_related_road_traffic_crashes_with_fatalities_p_6c7631eb" VARCHAR,
"alcohol_related_road_traffic_crashes_with_fatalities_p_d8722369" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_related_road_traffic_crashes_with_fatalit_cd28e216 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_related_road_traffic_crashes_with_fatalities_p_ad70a15e" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_totala_recorded_plus_unrecorded_per_capit_6bf8a595 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_totala_recorded_plus_unrecorded_per_capita_15p_a19e32f5" FLOAT,
"alcohol_totala_recorded_plus_unrecorded_per_capita_15p_4ecc1100" FLOAT,
"alcohol_totala_recorded_plus_unrecorded_per_capita_15p_0e736176" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_totala_recorded_plus_unrecorded_per_capit_db8f0ae9 (
"year" INTEGER,
"country" VARCHAR,
"alcohol_totala_recorded_plus_unrecorded_per_capita_15p_a19e32f5" FLOAT
);
CREATE TABLE owid_alcohol_total_per_capita_15plus_consumption_in_li_5f3a7a97 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_total_per_capita_15plus_consumption_in_litres__5517af50" FLOAT,
"alcohol_total_per_capita_15plus_consumption_in_litres__ebb67219" FLOAT,
"alcohol_total_per_capita_15plus_consumption_in_litres__4f4ebf7b" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_total_per_capita_15plus_consumption_in_li_6b92d538 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_total_per_capita_15plus_consumption_in_litres__3d4acab0" FLOAT,
"alcohol_total_per_capita_15plus_consumption_in_litres__c2eede9a" FLOAT,
"alcohol_total_per_capita_15plus_consumption_in_litres__6120d2ef" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_total_per_capita_15plus_consumption_in_li_cf57394b (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_total_per_capita_15plus_consumption_in_litres__3d4acab0" FLOAT
);
CREATE TABLE owid_alcohol_total_per_capita_15plus_consumption_in_li_d62f483a (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_total_per_capita_15plus_consumption_in_litres__5517af50" FLOAT,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.