Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
The GHO data repository is WHO's gateway to health-related statistics for its 194 Member States. It provides access to over 1000 indicators on priority health topics including mortality and burden of diseases, the Millennium Development Goals (child nutrition, child health, maternal and reproductive health, immunization, HIV/AIDS, tuberculosis, malaria, neglected diseases, water and sanitation), non communicable diseases and risk factors, epidemic-prone diseases, health systems, environmental health, violence and injuries, equity among others.
CREATE TABLE owid_13_15_years_old_any_alcoholic_beverage_consumed_i_800f47fc (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__13_15_years_old_any_alcoholic_beverage_consumed_in__a0313b1d" FLOAT -- 13–15 Years Old Any Alcoholic Beverage Consumed In Past 30 Days, Pct,
"n__13_15_years_old_any_alcoholic_beverage_consumed_in__c7ee28de" VARCHAR -- 13–15 Years Old Any Alcoholic Beverage Consumed In Past 30 Days, Pct Low,
"n__13_15_years_old_any_alcoholic_beverage_consumed_in__152fa32b" VARCHAR -- 13–15 Years Old Any Alcoholic Beverage Consumed In Past 30 Days, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_13_15_years_old_any_alcoholic_beverage_consumed_i_90b2a9fc (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__13_15_years_old_any_alcoholic_beverage_consumed_in__a0313b1d" FLOAT -- 13–15 Years Old Any Alcoholic Beverage Consumed In Past 30 Days, Pct
);CREATE TABLE owid_13_15_years_old_first_drink_before_age_14_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__13_15_years_old_first_drink_before_age_14_pct" FLOAT -- 13–15 Years Old First Drink Before Age 14, Pct
);CREATE TABLE owid_13_15_years_old_first_drink_before_age_14_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__13_15_years_old_first_drink_before_age_14_pct" FLOAT -- 13–15 Years Old First Drink Before Age 14, Pct,
"n__13_15_years_old_first_drink_before_age_14_pct_low" VARCHAR -- 13–15 Years Old First Drink Before Age 14, Pct Low,
"n__13_15_years_old_first_drink_before_age_14_pct_high" VARCHAR -- 13–15 Years Old First Drink Before Age 14, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_15_19_years_old_abstainers_lifetime_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_abstainers_lifetime_pct" FLOAT -- 15–19 Years Old Abstainers, Lifetime, Pct,
"comments" VARCHAR
);CREATE TABLE owid_15_19_years_old_abstainers_lifetime_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_abstainers_lifetime_pct" FLOAT -- 15–19 Years Old Abstainers, Lifetime, Pct,
"n__15_19_years_old_abstainers_lifetime_pct_low" VARCHAR -- 15–19 Years Old Abstainers, Lifetime, Pct Low,
"n__15_19_years_old_abstainers_lifetime_pct_high" VARCHAR -- 15–19 Years Old Abstainers, Lifetime, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_15_19_years_old_current_drinkers_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_current_drinkers_pct" FLOAT -- 15–19 Years Old, Current Drinkers, Pct
);CREATE TABLE owid_15_19_years_old_current_drinkers_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_current_drinkers_pct" FLOAT -- 15–19 Years Old, Current Drinkers, Pct,
"n__15_19_years_old_current_drinkers_pct_low" VARCHAR -- 15–19 Years Old, Current Drinkers, Pct Low,
"n__15_19_years_old_current_drinkers_pct_high" VARCHAR -- 15–19 Years Old, Current Drinkers, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_15_19_years_old_former_drinkers_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_former_drinkers_pct" FLOAT -- 15–19 Years Old Former Drinkers, Pct,
"comments" VARCHAR
);CREATE TABLE owid_15_19_years_old_former_drinkers_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_former_drinkers_pct" FLOAT -- 15–19 Years Old Former Drinkers, Pct,
"n__15_19_years_old_former_drinkers_pct_low" VARCHAR -- 15–19 Years Old Former Drinkers, Pct Low,
"n__15_19_years_old_former_drinkers_pct_high" VARCHAR -- 15–19 Years Old Former Drinkers, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_15_19_years_old_heavy_episodic_drinkers_drinkers__3a41b80f (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_heavy_episodic_drinkers_drinkers_only_pct" FLOAT -- 15–19 Years Old Heavy Episodic Drinkers, Drinkers Only, Pct,
"n__15_19_years_old_heavy_episodic_drinkers_drinkers_on_79be24e5" FLOAT -- 15–19 Years Old Heavy Episodic Drinkers, Drinkers Only, Pct Low,
"n__15_19_years_old_heavy_episodic_drinkers_drinkers_on_7857e102" FLOAT -- 15–19 Years Old Heavy Episodic Drinkers, Drinkers Only, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_15_19_years_old_heavy_episodic_drinkers_drinkers__a8807eca (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_heavy_episodic_drinkers_drinkers_only_pct" FLOAT -- 15–19 Years Old Heavy Episodic Drinkers, Drinkers Only, Pct
);CREATE TABLE owid_15_19_years_old_heavy_episodic_drinkers_populatio_3a23f728 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_heavy_episodic_drinkers_population__5af014bd" FLOAT -- 15–19 Years Old Heavy Episodic Drinkers, Population, Pct With 95pctci,
"n__15_19_years_old_heavy_episodic_drinkers_population__79cd9d08" FLOAT -- 15–19 Years Old Heavy Episodic Drinkers, Population, Pct With 95pctci Low,
"n__15_19_years_old_heavy_episodic_drinkers_population__8e3bec3b" FLOAT -- 15–19 Years Old Heavy Episodic Drinkers, Population, Pct With 95pctci High,
"comments" VARCHAR
);CREATE TABLE owid_15_19_years_old_heavy_episodic_drinkers_populatio_75385dd5 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_heavy_episodic_drinkers_population__5af014bd" FLOAT -- 15–19 Years Old Heavy Episodic Drinkers, Population, Pct With 95pctci
);CREATE TABLE owid_15_19_years_old_total_alcohol_consumption_in_litr_b055d8b7 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_total_alcohol_consumption_in_litres_82116d7e" FLOAT -- 15–19 Years Old Total Alcohol Consumption In Litres Of Pure Alcohol,
"comments" VARCHAR
);CREATE TABLE owid_15_19_years_old_total_alcohol_consumption_in_litr_c77ef903 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_19_years_old_total_alcohol_consumption_in_litres_82116d7e" FLOAT -- 15–19 Years Old Total Alcohol Consumption In Litres Of Pure Alcohol,
"n__15_19_years_old_total_alcohol_consumption_in_litres_13aae386" FLOAT -- 15–19 Years Old Total Alcohol Consumption In Litres Of Pure Alcohol Low,
"n__15_19_years_old_total_alcohol_consumption_in_litres_f6d1b327" FLOAT -- 15–19 Years Old Total Alcohol Consumption In Litres Of Pure Alcohol High,
"comments" VARCHAR
);CREATE TABLE owid_15_years_old_any_alcoholic_beverage_consumed_at_l_73d97f3b (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_years_old_any_alcoholic_beverage_consumed_at_lea_536163af" FLOAT -- 15 Years Old, Any Alcoholic Beverage Consumed At Least Once A Week, Pct
);CREATE TABLE owid_15_years_old_any_alcoholic_beverage_consumed_at_l_9b4e45a9 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_years_old_any_alcoholic_beverage_consumed_at_lea_536163af" FLOAT -- 15 Years Old, Any Alcoholic Beverage Consumed At Least Once A Week, Pct,
"n__15_years_old_any_alcoholic_beverage_consumed_at_lea_d9fb9893" VARCHAR -- 15 Years Old, Any Alcoholic Beverage Consumed At Least Once A Week, Pct Low,
"n__15_years_old_any_alcoholic_beverage_consumed_at_lea_bfa549a7" VARCHAR -- 15 Years Old, Any Alcoholic Beverage Consumed At Least Once A Week, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_15_years_old_any_alcoholic_beverage_consumed_in_p_61104b8d (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_years_old_any_alcoholic_beverage_consumed_in_pas_37888148" FLOAT -- 15 Years Old Any Alcoholic Beverage Consumed In Past 30 Days, Pct,
"n__15_years_old_any_alcoholic_beverage_consumed_in_pas_c421d9b6" VARCHAR -- 15 Years Old Any Alcoholic Beverage Consumed In Past 30 Days, Pct Low,
"n__15_years_old_any_alcoholic_beverage_consumed_in_pas_4cee83c5" VARCHAR -- 15 Years Old Any Alcoholic Beverage Consumed In Past 30 Days, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_15_years_old_any_alcoholic_beverage_consumed_in_p_6a84d104 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_years_old_any_alcoholic_beverage_consumed_in_pas_c6bf3b05" FLOAT -- 15 Years Old Any Alcoholic Beverage Consumed In Past 12 Months, Pct,
"n__15_years_old_any_alcoholic_beverage_consumed_in_pas_a49ff84f" VARCHAR -- 15 Years Old Any Alcoholic Beverage Consumed In Past 12 Months, Pct Low,
"n__15_years_old_any_alcoholic_beverage_consumed_in_pas_6f048be7" VARCHAR -- 15 Years Old Any Alcoholic Beverage Consumed In Past 12 Months, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_15_years_old_any_alcoholic_beverage_consumed_in_p_8eaf5d2f (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_years_old_any_alcoholic_beverage_consumed_in_pas_c6bf3b05" FLOAT -- 15 Years Old Any Alcoholic Beverage Consumed In Past 12 Months, Pct
);CREATE TABLE owid_15_years_old_any_alcoholic_beverage_consumed_in_p_bad70373 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_years_old_any_alcoholic_beverage_consumed_in_pas_37888148" FLOAT -- 15 Years Old Any Alcoholic Beverage Consumed In Past 30 Days, Pct
);CREATE TABLE owid_15_years_old_first_drink_at_13_years_or_younger_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_years_old_first_drink_at_13_years_or_younger_pct" FLOAT -- 15 Years Old First Drink At 13 Years Or Younger, Pct
);CREATE TABLE owid_15_years_old_first_drink_at_13_years_or_younger_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"n__15_years_old_first_drink_at_13_years_or_younger_pct" FLOAT -- 15 Years Old First Drink At 13 Years Or Younger, Pct,
"n__15_years_old_first_drink_at_13_years_or_younger_pct_low" VARCHAR -- 15 Years Old First Drink At 13 Years Or Younger, Pct Low,
"n__15_years_old_first_drink_at_13_years_or_younger_pct_high" VARCHAR -- 15 Years Old First Drink At 13 Years Or Younger, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_abortion_rate_model_estimated_1 (
"year" INTEGER,
"country" VARCHAR,
"uncertainty_interval" VARCHAR,
"abortion_rate_model_estimated" FLOAT -- Abortion Rate, Model Estimated
);Anyone who has the link will be able to view this.