Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_prevalence_of_daily_cigarette_smoking_among_adults_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_cigarette_smoking_among_adults_pct" FLOAT -- Prevalence Of Daily Cigarette Smoking Among Adults, Pct
);
CREATE TABLE owid_prevalence_of_daily_cigarette_smoking_among_adults_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_cigarette_smoking_among_adults_pct" FLOAT -- Prevalence Of Daily Cigarette Smoking Among Adults, Pct,
"prevalence_of_daily_cigarette_smoking_among_adults_pct_low" VARCHAR -- Prevalence Of Daily Cigarette Smoking Among Adults, Pct Low,
"prevalence_of_daily_cigarette_smoking_among_adults_pct_high" VARCHAR -- Prevalence Of Daily Cigarette Smoking Among Adults, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_daily_e_cigarette_use_among_adolesc_54ee0473 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_e_cigarette_use_among_adolescents_pct" FLOAT -- Prevalence Of Daily E Cigarette Use Among Adolescents, Pct
);
CREATE TABLE owid_prevalence_of_daily_e_cigarette_use_among_adolesc_d51bfa51 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_e_cigarette_use_among_adolescents_pct" FLOAT -- Prevalence Of Daily E Cigarette Use Among Adolescents, Pct,
"prevalence_of_daily_e_cigarette_use_among_adolescents_pct_low" VARCHAR -- Prevalence Of Daily E Cigarette Use Among Adolescents, Pct Low,
"prevalence_of_daily_e_cigarette_use_among_adolescents_pct_high" VARCHAR -- Prevalence Of Daily E Cigarette Use Among Adolescents, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_daily_e_cigarette_use_among_adults_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_e_cigarette_use_among_adults_pct" FLOAT -- Prevalence Of Daily E Cigarette Use Among Adults, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_daily_e_cigarette_use_among_adults_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_e_cigarette_use_among_adults_pct" FLOAT -- Prevalence Of Daily E Cigarette Use Among Adults, Pct,
"prevalence_of_daily_e_cigarette_use_among_adults_pct_low" VARCHAR -- Prevalence Of Daily E Cigarette Use Among Adults, Pct Low,
"prevalence_of_daily_e_cigarette_use_among_adults_pct_high" VARCHAR -- Prevalence Of Daily E Cigarette Use Among Adults, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_daily_smokeless_tobacco_use_among_a_73550e1d (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_smokeless_tobacco_use_among_adolescents_pct" INTEGER -- Prevalence Of Daily Smokeless Tobacco Use Among Adolescents, Pct,
"prevalence_of_daily_smokeless_tobacco_use_among_adoles_60b2ed35" VARCHAR -- Prevalence Of Daily Smokeless Tobacco Use Among Adolescents, Pct Low,
"prevalence_of_daily_smokeless_tobacco_use_among_adoles_fb471978" VARCHAR -- Prevalence Of Daily Smokeless Tobacco Use Among Adolescents, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_daily_smokeless_tobacco_use_among_a_a1522b68 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_smokeless_tobacco_use_among_adults_pct" FLOAT -- Prevalence Of Daily Smokeless Tobacco Use Among Adults, Pct,
"prevalence_of_daily_smokeless_tobacco_use_among_adults_pct_low" VARCHAR -- Prevalence Of Daily Smokeless Tobacco Use Among Adults, Pct Low,
"prevalence_of_daily_smokeless_tobacco_use_among_adults_pct_high" VARCHAR -- Prevalence Of Daily Smokeless Tobacco Use Among Adults, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_daily_smokeless_tobacco_use_among_a_cfbece5f (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_smokeless_tobacco_use_among_adolescents_pct" INTEGER -- Prevalence Of Daily Smokeless Tobacco Use Among Adolescents, Pct
);
CREATE TABLE owid_prevalence_of_daily_smokeless_tobacco_use_among_a_d8ad5669 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_smokeless_tobacco_use_among_adults_pct" FLOAT -- Prevalence Of Daily Smokeless Tobacco Use Among Adults, Pct
);
CREATE TABLE owid_prevalence_of_daily_tobacco_smoking_among_adolesc_3d9f6c5a (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_tobacco_smoking_among_adolescents_pct" FLOAT -- Prevalence Of Daily Tobacco Smoking Among Adolescents, Pct,
"prevalence_of_daily_tobacco_smoking_among_adolescents_pct_low" VARCHAR -- Prevalence Of Daily Tobacco Smoking Among Adolescents, Pct Low,
"prevalence_of_daily_tobacco_smoking_among_adolescents_pct_high" VARCHAR -- Prevalence Of Daily Tobacco Smoking Among Adolescents, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_daily_tobacco_smoking_among_adolesc_3f9b52d7 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_tobacco_smoking_among_adolescents_pct" FLOAT -- Prevalence Of Daily Tobacco Smoking Among Adolescents, Pct
);
CREATE TABLE owid_prevalence_of_daily_tobacco_smoking_among_adults_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_tobacco_smoking_among_adults_pct" FLOAT -- Prevalence Of Daily Tobacco Smoking Among Adults, Pct
);
CREATE TABLE owid_prevalence_of_daily_tobacco_smoking_among_adults_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_tobacco_smoking_among_adults_pct" FLOAT -- Prevalence Of Daily Tobacco Smoking Among Adults, Pct,
"prevalence_of_daily_tobacco_smoking_among_adults_pct_low" VARCHAR -- Prevalence Of Daily Tobacco Smoking Among Adults, Pct Low,
"prevalence_of_daily_tobacco_smoking_among_adults_pct_high" VARCHAR -- Prevalence Of Daily Tobacco Smoking Among Adults, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_daily_tobacco_use_among_adolescents_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_tobacco_use_among_adolescents_pct" INTEGER -- Prevalence Of Daily Tobacco Use Among Adolescents, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_daily_tobacco_use_among_adolescents_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_tobacco_use_among_adolescents_pct" INTEGER -- Prevalence Of Daily Tobacco Use Among Adolescents, Pct,
"prevalence_of_daily_tobacco_use_among_adolescents_pct_low" VARCHAR -- Prevalence Of Daily Tobacco Use Among Adolescents, Pct Low,
"prevalence_of_daily_tobacco_use_among_adolescents_pct_high" VARCHAR -- Prevalence Of Daily Tobacco Use Among Adolescents, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_daily_tobacco_use_among_adults_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_tobacco_use_among_adults_pct" FLOAT -- Prevalence Of Daily Tobacco Use Among Adults, Pct
);
CREATE TABLE owid_prevalence_of_daily_tobacco_use_among_adults_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_daily_tobacco_use_among_adults_pct" FLOAT -- Prevalence Of Daily Tobacco Use Among Adults, Pct,
"prevalence_of_daily_tobacco_use_among_adults_pct_low" VARCHAR -- Prevalence Of Daily Tobacco Use Among Adults, Pct Low,
"prevalence_of_daily_tobacco_use_among_adults_pct_high" VARCHAR -- Prevalence Of Daily Tobacco Use Among Adults, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_edentulism_in_people_20plus_years_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"prevalence_of_edentulism_in_people_20plus_years_pct" FLOAT -- Prevalence Of Edentulism In People 20plus Years, Pct
);
CREATE TABLE owid_prevalence_of_edentulism_in_people_20plus_years_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"prevalence_of_edentulism_in_people_20plus_years_pct" FLOAT -- Prevalence Of Edentulism In People 20plus Years, Pct,
"prevalence_of_edentulism_in_people_20plus_years_pct_low" VARCHAR -- Prevalence Of Edentulism In People 20plus Years, Pct Low,
"prevalence_of_edentulism_in_people_20plus_years_pct_high" VARCHAR -- Prevalence Of Edentulism In People 20plus Years, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_gonorrhoea_in_individuals_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"prevalence_of_gonorrhoea_in_individuals_pct" FLOAT -- Prevalence Of Gonorrhoea In Individuals, Pct
);
CREATE TABLE owid_prevalence_of_gonorrhoea_in_individuals_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"prevalence_of_gonorrhoea_in_individuals_pct" FLOAT -- Prevalence Of Gonorrhoea In Individuals, Pct,
"prevalence_of_gonorrhoea_in_individuals_pct_low" FLOAT -- Prevalence Of Gonorrhoea In Individuals, Pct Low,
"prevalence_of_gonorrhoea_in_individuals_pct_high" FLOAT -- Prevalence Of Gonorrhoea In Individuals, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_hiv_among_adults_aged_15_to_49_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"prevalence_of_hiv_among_adults_aged_15_to_49_pct" FLOAT -- Prevalence Of Hiv Among Adults Aged 15 To 49, Pct
);
CREATE TABLE owid_prevalence_of_hiv_among_adults_aged_15_to_49_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"prevalence_of_hiv_among_adults_aged_15_to_49_pct" FLOAT -- Prevalence Of Hiv Among Adults Aged 15 To 49, Pct,
"prevalence_of_hiv_among_adults_aged_15_to_49_pct_low" FLOAT -- Prevalence Of Hiv Among Adults Aged 15 To 49, Pct Low,
"prevalence_of_hiv_among_adults_aged_15_to_49_pct_high" FLOAT -- Prevalence Of Hiv Among Adults Aged 15 To 49, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_prevalence_of_hypertension_among_adults_aged_30_7_364b4287 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"prevalence_of_hypertension_among_adults_aged_30_79_years_crude" FLOAT -- Prevalence Of Hypertension Among Adults Aged 30–79 Years, Crude
);
Anyone who has the link will be able to view this.