Global Health Observatory - World Health Organization

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  -- Alcohol, Regional Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol
);

CREATE TABLE owid_alcohol_regional_prevalence_of_alcohol_dependence_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "alcohol_regional_prevalence_of_alcohol_dependence_pct" FLOAT  -- Alcohol, Regional Prevalence Of Alcohol Dependence, Pct
);

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,
  "alcohol_regional_prevalence_of_alcohol_dependence_pct_low" VARCHAR  -- Alcohol, Regional Prevalence Of Alcohol Dependence, Pct Low,
  "alcohol_regional_prevalence_of_alcohol_dependence_pct_high" VARCHAR  -- Alcohol, Regional Prevalence Of Alcohol Dependence, Pct High,
  "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  -- Alcohol, Regional Prevalence Of Alcohol Use Disorders, Pct
);

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,
  "alcohol_regional_prevalence_of_alcohol_use_disorders_pct_low" VARCHAR  -- Alcohol, Regional Prevalence Of Alcohol Use Disorders, Pct Low,
  "alcohol_regional_prevalence_of_alcohol_use_disorders_pct_high" VARCHAR  -- Alcohol, Regional Prevalence Of Alcohol Use Disorders, Pct High,
  "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  -- Alcohol Related Crimes, Pct Of All Crimes
);

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,
  "alcohol_related_crimes_pct_of_all_crimes_low" VARCHAR  -- Alcohol Related Crimes, Pct Of All Crimes Low,
  "alcohol_related_crimes_pct_of_all_crimes_high" VARCHAR  -- Alcohol Related Crimes, Pct Of All Crimes High,
  "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,
  "alcohol_related_disease_mortality_per_100_000_15plus_years_low" VARCHAR  -- Alcohol Related Disease Mortality, Per 100–000, 15plus Years Low,
  "alcohol_related_disease_mortality_per_100_000_15plus_years_high" VARCHAR  -- Alcohol Related Disease Mortality, Per 100–000, 15plus Years High,
  "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  -- Alcohol Related Disease Mortality, Per 100–000, 15plus Years
);

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  -- Alcohol Related Injury Mortality, Per 1–000
);

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,
  "alcohol_related_injury_mortality_per_1_000_low" VARCHAR  -- Alcohol Related Injury Mortality, Per 1–000 Low,
  "alcohol_related_injury_mortality_per_1_000_high" VARCHAR  -- Alcohol Related Injury Mortality, Per 1–000 High,
  "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 Traffic Crashes,
  "alcohol_related_road_traffic_crashes_pct_of_all_traffi_c75cd627" VARCHAR  -- Alcohol Related Road Traffic Crashes, Pct Of All Traffic Crashes Low,
  "alcohol_related_road_traffic_crashes_pct_of_all_traffi_8bcf6369" VARCHAR  -- Alcohol Related Road Traffic Crashes, Pct Of All Traffic Crashes High,
  "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  -- Alcohol Related Road Traffic Crashes, Pct Of All Traffic Crashes
);

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  -- Alcohol Related Road Traffic Crashes, Per 100–000 Population
);

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,
  "alcohol_related_road_traffic_crashes_per_100_000_population_low" VARCHAR  -- Alcohol Related Road Traffic Crashes, Per 100–000 Population Low,
  "alcohol_related_road_traffic_crashes_per_100_000_popul_f8973c36" VARCHAR  -- Alcohol Related Road Traffic Crashes, Per 100–000 Population High,
  "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, Per 100–000 Population,
  "alcohol_related_road_traffic_crashes_with_fatalities_p_4e6adb2a" VARCHAR  -- Alcohol Related Road Traffic Crashes With Fatalities, Per 100–000 Population Low,
  "alcohol_related_road_traffic_crashes_with_fatalities_p_005be6bb" VARCHAR  -- Alcohol Related Road Traffic Crashes With Fatalities, Per 100–000 Population High,
  "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  -- Alcohol Related Road Traffic Crashes With Fatalities, Pct Of All Road Traffic Crashes With Fatalities,
  "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, Pct Of All Road Traffic Crashes With Fatalities,
  "alcohol_related_road_traffic_crashes_with_fatalities_p_6c7631eb" VARCHAR  -- Alcohol Related Road Traffic Crashes With Fatalities, Pct Of All Road Traffic Crashes With Fatalities Low,
  "alcohol_related_road_traffic_crashes_with_fatalities_p_d8722369" VARCHAR  -- Alcohol Related Road Traffic Crashes With Fatalities, Pct Of All Road Traffic Crashes With Fatalities High,
  "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  -- Alcohol Related Road Traffic Crashes With Fatalities, Per 100–000 Population,
  "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, 15plus, Consumption With 95pctci, Projections To 2020 And 2025,
  "alcohol_totala_recorded_plus_unrecorded_per_capita_15p_4ecc1100" FLOAT  -- Alcohol, Totala, Recorded Plus Unrecorded, Per Capita, 15plus, Consumption With 95pctci, Projections To 2020 And 2025 Low,
  "alcohol_totala_recorded_plus_unrecorded_per_capita_15p_0e736176" FLOAT  -- Alcohol, Totala, Recorded Plus Unrecorded, Per Capita, 15plus, Consumption With 95pctci, Projections To 2020 And 2025 High,
  "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  -- Alcohol, Totala, Recorded Plus Unrecorded, Per Capita, 15plus, Consumption With 95pctci, Projections To 2020 And 2025
);

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 Of Pure Alcohol, Sdg Indicator 3–5 2,
  "alcohol_total_per_capita_15plus_consumption_in_litres__ebb67219" FLOAT  -- Alcohol, Total Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol, Sdg Indicator 3–5 2 Low,
  "alcohol_total_per_capita_15plus_consumption_in_litres__4f4ebf7b" FLOAT  -- Alcohol, Total Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol, Sdg Indicator 3–5 2 High,
  "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 Of Pure Alcohol, With 95pctci,
  "alcohol_total_per_capita_15plus_consumption_in_litres__c2eede9a" FLOAT  -- Alcohol, Total Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol, With 95pctci Low,
  "alcohol_total_per_capita_15plus_consumption_in_litres__6120d2ef" FLOAT  -- Alcohol, Total Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol, With 95pctci High,
  "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  -- Alcohol, Total Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol, With 95pctci
);

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  -- Alcohol, Total Per Capita, 15plus, Consumption, In Litres Of Pure Alcohol, Sdg Indicator 3–5 2,
  "comments" VARCHAR
);