Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_affordability_of_cigarettes_category_of_change_in_9e412303 (
"year" INTEGER,
"country" VARCHAR,
"affordability_of_cigarettes_category_of_change_in_the__abc67443" VARCHAR,
"affordability_of_cigarettes_category_of_change_in_the__fd086060" VARCHAR,
"affordability_of_cigarettes_category_of_change_in_the__b7cbad85" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_affordability_of_cigarettes_category_of_change_ov_284cf18d (
"year" INTEGER,
"country" VARCHAR,
"affordability_of_cigarettes_category_of_change_over_pa_62e98359" VARCHAR
);
CREATE TABLE owid_affordability_of_cigarettes_percentage_of_gdp_per_97fa773e (
"year" INTEGER,
"country" VARCHAR,
"affordability_of_cigarettes_percentage_of_gdp_per_capi_0d4ac01e" FLOAT
);
CREATE TABLE owid_affordability_of_cigarettes_percentage_of_gdp_per_b3338712 (
"year" INTEGER,
"country" VARCHAR,
"affordability_of_cigarettes_percentage_of_gdp_per_capi_0d4ac01e" FLOAT,
"affordability_of_cigarettes_percentage_of_gdp_per_capi_dfcc9962" VARCHAR,
"affordability_of_cigarettes_percentage_of_gdp_per_capi_80f73548" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_affordability_of_fluoride_toothpaste_1 (
"year" INTEGER,
"country" VARCHAR,
"affordability_of_fluoride_toothpaste" VARCHAR
);
CREATE TABLE owid_affordability_of_fluoride_toothpaste_2 (
"year" INTEGER,
"country" VARCHAR,
"affordability_of_fluoride_toothpaste" VARCHAR,
"affordability_of_fluoride_toothpaste_low" VARCHAR,
"affordability_of_fluoride_toothpaste_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_limits_off_premise_sales_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"age_limits_off_premise_sales" VARCHAR
);
CREATE TABLE owid_age_limits_off_premise_sales_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"age_limits_off_premise_sales" VARCHAR,
"age_limits_off_premise_sales_low" VARCHAR,
"age_limits_off_premise_sales_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_limits_on_premise_service_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"age_limits_on_premise_service" VARCHAR
);
CREATE TABLE owid_age_limits_on_premise_service_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_types" VARCHAR,
"age_limits_on_premise_service" VARCHAR,
"age_limits_on_premise_service_low" VARCHAR,
"age_limits_on_premise_service_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_agencies_responsible_for_delivering_prison_healthcare_1 (
"year" INTEGER,
"country" VARCHAR,
"agencies_responsible_for_delivering_prison_healthcare" VARCHAR
);
CREATE TABLE owid_agencies_responsible_for_delivering_prison_healthcare_2 (
"year" INTEGER,
"country" VARCHAR,
"agencies_responsible_for_delivering_prison_healthcare" VARCHAR,
"agencies_responsible_for_delivering_prison_healthcare_low" VARCHAR,
"agencies_responsible_for_delivering_prison_healthcare_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_range_of_latest_adult_prevalence_survey_nonsmoked_1 (
"year" INTEGER,
"country" VARCHAR,
"age_range_of_latest_adult_prevalence_survey_nonsmoked" VARCHAR
);
CREATE TABLE owid_age_range_of_latest_adult_prevalence_survey_nonsmoked_2 (
"year" INTEGER,
"country" VARCHAR,
"age_range_of_latest_adult_prevalence_survey_nonsmoked" VARCHAR,
"age_range_of_latest_adult_prevalence_survey_nonsmoked_low" VARCHAR,
"age_range_of_latest_adult_prevalence_survey_nonsmoked_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_range_of_latest_youth_prevalence_survey_nonsmoked_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"age_range_of_latest_youth_prevalence_survey_nonsmoked" VARCHAR
);
CREATE TABLE owid_age_range_of_latest_youth_prevalence_survey_nonsmoked_2 (
"year" INTEGER,
"country" VARCHAR,
"age_range_of_latest_youth_prevalence_survey_nonsmoked" VARCHAR,
"age_range_of_latest_youth_prevalence_survey_nonsmoked_low" VARCHAR,
"age_range_of_latest_youth_prevalence_survey_nonsmoked_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_range_of_most_recent_adolescent_survey_1 (
"year" INTEGER,
"country" VARCHAR,
"age_range_of_most_recent_adolescent_survey" VARCHAR
);
CREATE TABLE owid_age_range_of_most_recent_adolescent_survey_2 (
"year" INTEGER,
"country" VARCHAR,
"age_range_of_most_recent_adolescent_survey" VARCHAR,
"age_range_of_most_recent_adolescent_survey_low" VARCHAR,
"age_range_of_most_recent_adolescent_survey_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_range_of_most_recent_survey_of_adults_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"age_range_of_most_recent_survey_of_adults" VARCHAR
);
CREATE TABLE owid_age_range_of_most_recent_survey_of_adults_2 (
"year" INTEGER,
"country" VARCHAR,
"age_range_of_most_recent_survey_of_adults" VARCHAR,
"age_range_of_most_recent_survey_of_adults_low" VARCHAR,
"age_range_of_most_recent_survey_of_adults_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_alcohol_and_drug_use_disor_03f7a020 (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_type_disorders" VARCHAR,
"age_standardized_dalys_alcohol_and_drug_use_disorders__e755f31b" INTEGER
);
CREATE TABLE owid_age_standardized_dalys_alcohol_and_drug_use_disor_03fecdcb (
"year" INTEGER,
"country" VARCHAR,
"rsud_substance_type_disorders" VARCHAR,
"age_standardized_dalys_alcohol_and_drug_use_disorders__e755f31b" INTEGER,
"age_standardized_dalys_alcohol_and_drug_use_disorders__e343638a" VARCHAR,
"age_standardized_dalys_alcohol_and_drug_use_disorders__950c17d9" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_alcohol_use_disorders_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_alcohol_use_disorders_per_100_000" INTEGER
);
CREATE TABLE owid_age_standardized_dalys_alcohol_use_disorders_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_alcohol_use_disorders_per_100_000" INTEGER,
"age_standardized_dalys_alcohol_use_disorders_per_100_000_low" VARCHAR,
"age_standardized_dalys_alcohol_use_disorders_per_100_000_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_attributable_to_the_enviro_0d6c3e86 (
"year" INTEGER,
"country" VARCHAR,
"cause" VARCHAR,
"age_standardized_dalys_attributable_to_the_environment_414b0ad5" FLOAT
);
Anyone who has the link will be able to view this.