Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_age_standardized_death_rates_poisoning_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_death_rates_poisoning_per_100_000" FLOAT
);
CREATE TABLE owid_age_standardized_death_rates_poisoning_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_death_rates_poisoning_per_100_000" FLOAT,
"age_standardized_death_rates_poisoning_per_100_000_low" VARCHAR,
"age_standardized_death_rates_poisoning_per_100_000_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_death_rates_prematurity_and_low__4561be76 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_death_rates_prematurity_and_low_birth_566f73a0" FLOAT
);
CREATE TABLE owid_age_standardized_death_rates_prematurity_and_low__adb584fa (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_death_rates_prematurity_and_low_birth_566f73a0" FLOAT,
"age_standardized_death_rates_prematurity_and_low_birth_bdbdacf8" VARCHAR,
"age_standardized_death_rates_prematurity_and_low_birth_894c22a3" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_death_rates_road_traffic_acciden_474e7579 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_death_rates_road_traffic_accidents_per_100_000" FLOAT,
"age_standardized_death_rates_road_traffic_accidents_pe_fc09f7d6" VARCHAR,
"age_standardized_death_rates_road_traffic_accidents_pe_3052611e" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_death_rates_road_traffic_acciden_b0c70272 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_death_rates_road_traffic_accidents_per_100_000" FLOAT
);
CREATE TABLE owid_age_standardized_death_rates_self_inflicted_injur_0c5419e9 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_death_rates_self_inflicted_injury_per_100_000" FLOAT
);
CREATE TABLE owid_age_standardized_death_rates_self_inflicted_injur_f26acdcb (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_death_rates_self_inflicted_injury_per_100_000" FLOAT,
"age_standardized_death_rates_self_inflicted_injury_per_8d308240" VARCHAR,
"age_standardized_death_rates_self_inflicted_injury_per_22738f2a" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_death_rates_violence_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_death_rates_violence_per_100_000" FLOAT
);
CREATE TABLE owid_age_standardized_death_rates_violence_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_death_rates_violence_per_100_000" FLOAT,
"age_standardized_death_rates_violence_per_100_000_low" VARCHAR,
"age_standardized_death_rates_violence_per_100_000_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_deaths_attributable_to_the_envir_002eaf59 (
"year" INTEGER,
"country" VARCHAR,
"cause" VARCHAR,
"age_standardized_deaths_attributable_to_the_environmen_65ce68b5" FLOAT,
"age_standardized_deaths_attributable_to_the_environmen_30ccc82e" VARCHAR,
"age_standardized_deaths_attributable_to_the_environmen_bc635ddd" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_deaths_attributable_to_the_envir_8e8f23ef (
"year" INTEGER,
"country" VARCHAR,
"cause" VARCHAR,
"age_standardized_deaths_attributable_to_the_environmen_65ce68b5" FLOAT
);
CREATE TABLE owid_age_standardized_ncd_mortality_rate_per_100_000_p_52d75fbe (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_ncd_mortality_rate_per_100_000_population" FLOAT,
"age_standardized_ncd_mortality_rate_per_100_000_population_low" FLOAT,
"age_standardized_ncd_mortality_rate_per_100_000_population_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_ncd_mortality_rate_per_100_000_p_d1c58c7d (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_ncd_mortality_rate_per_100_000_population" FLOAT
);
CREATE TABLE owid_age_standardized_suicide_rates_per_100_000_population_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_suicide_rates_per_100_000_population" FLOAT
);
CREATE TABLE owid_age_standardized_suicide_rates_per_100_000_population_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_suicide_rates_per_100_000_population" FLOAT,
"age_standardized_suicide_rates_per_100_000_population_low" FLOAT,
"age_standardized_suicide_rates_per_100_000_population_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_agreement_in_place_between_the_ministry_of_health_35e7d5f8 (
"year" INTEGER,
"country" VARCHAR,
"cch_survey_sub_question" VARCHAR,
"agreement_in_place_between_the_ministry_of_health_and__70cc45a6" VARCHAR
);
CREATE TABLE owid_agreement_in_place_between_the_ministry_of_health_e0ccbd4d (
"year" INTEGER,
"country" VARCHAR,
"cch_survey_sub_question" VARCHAR,
"agreement_in_place_between_the_ministry_of_health_and__70cc45a6" VARCHAR,
"agreement_in_place_between_the_ministry_of_health_and__34184c91" VARCHAR,
"agreement_in_place_between_the_ministry_of_health_and__daf2adfd" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_abstainers_lifetime_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_abstainers_lifetime_pct" FLOAT
);
CREATE TABLE owid_alcohol_abstainers_lifetime_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_abstainers_lifetime_pct" FLOAT,
"alcohol_abstainers_lifetime_pct_low" FLOAT,
"alcohol_abstainers_lifetime_pct_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_abstainers_past_12_months_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_abstainers_past_12_months_pct" FLOAT
);
CREATE TABLE owid_alcohol_abstainers_past_12_months_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_abstainers_past_12_months_pct" FLOAT,
"alcohol_abstainers_past_12_months_pct_low" FLOAT,
"alcohol_abstainers_past_12_months_pct_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_attributable_all_cause_deaths_per_100_000_1084fd87 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"alcohol_attributable_all_cause_deaths_per_100_000_age__8988777b" FLOAT,
"alcohol_attributable_all_cause_deaths_per_100_000_age__c766d4e2" FLOAT,
"alcohol_attributable_all_cause_deaths_per_100_000_age__56fef197" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_attributable_dalys_per_100_000_people_age_0d09fd46 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"alcohol_attributable_dalys_per_100_000_people_age_standardized" FLOAT,
"alcohol_attributable_dalys_per_100_000_people_age_stan_dcf15cd1" FLOAT,
"alcohol_attributable_dalys_per_100_000_people_age_stan_780e377a" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_alcohol_attributable_fractions_15plus_cancer_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"alcohol_attributable_fractions_15plus_cancer_deaths" FLOAT
);
Anyone who has the link will be able to view this.