Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_age_standardized_dalys_attributable_to_the_enviro_708866df (
"year" INTEGER,
"country" VARCHAR,
"cause" VARCHAR,
"age_standardized_dalys_attributable_to_the_environment_414b0ad5" FLOAT -- Age Standardized Dalys Attributable To The Environment, Per 100–000 Population,
"age_standardized_dalys_attributable_to_the_environment_26ffa520" VARCHAR -- Age Standardized Dalys Attributable To The Environment, Per 100–000 Population Low,
"age_standardized_dalys_attributable_to_the_environment_e0e7d169" VARCHAR -- Age Standardized Dalys Attributable To The Environment, Per 100–000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_breast_cancer_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_breast_cancer_per_100_000" INTEGER -- Age Standardized Dalys, Breast Cancer, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_breast_cancer_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_breast_cancer_per_100_000" INTEGER -- Age Standardized Dalys, Breast Cancer, Per 100–000,
"age_standardized_dalys_breast_cancer_per_100_000_low" VARCHAR -- Age Standardized Dalys, Breast Cancer, Per 100–000 Low,
"age_standardized_dalys_breast_cancer_per_100_000_high" VARCHAR -- Age Standardized Dalys, Breast Cancer, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_cerebrovascular_disease_pe_8061d8c8 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_cerebrovascular_disease_per_100_000" INTEGER -- Age Standardized Dalys, Cerebrovascular Disease, Per 100–000,
"age_standardized_dalys_cerebrovascular_disease_per_100_000_low" VARCHAR -- Age Standardized Dalys, Cerebrovascular Disease, Per 100–000 Low,
"age_standardized_dalys_cerebrovascular_disease_per_100_000_high" VARCHAR -- Age Standardized Dalys, Cerebrovascular Disease, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_cerebrovascular_disease_pe_84838d58 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_cerebrovascular_disease_per_100_000" INTEGER -- Age Standardized Dalys, Cerebrovascular Disease, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_colon_and_rectum_cancers_p_0dabd335 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_colon_and_rectum_cancers_per_100_000" INTEGER -- Age Standardized Dalys, Colon And Rectum Cancers, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_colon_and_rectum_cancers_p_ace6cd74 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_colon_and_rectum_cancers_per_100_000" INTEGER -- Age Standardized Dalys, Colon And Rectum Cancers, Per 100–000,
"age_standardized_dalys_colon_and_rectum_cancers_per_100_000_low" VARCHAR -- Age Standardized Dalys, Colon And Rectum Cancers, Per 100–000 Low,
"age_standardized_dalys_colon_and_rectum_cancers_per_10_cf5d41db" VARCHAR -- Age Standardized Dalys, Colon And Rectum Cancers, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_diabetes_mellitus_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_diabetes_mellitus_per_100_000" INTEGER -- Age Standardized Dalys, Diabetes Mellitus, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_diabetes_mellitus_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_diabetes_mellitus_per_100_000" INTEGER -- Age Standardized Dalys, Diabetes Mellitus, Per 100–000,
"age_standardized_dalys_diabetes_mellitus_per_100_000_low" VARCHAR -- Age Standardized Dalys, Diabetes Mellitus, Per 100–000 Low,
"age_standardized_dalys_diabetes_mellitus_per_100_000_high" VARCHAR -- Age Standardized Dalys, Diabetes Mellitus, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_drownings_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_drownings_per_100_000" INTEGER -- Age Standardized Dalys, Drownings, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_drownings_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_drownings_per_100_000" INTEGER -- Age Standardized Dalys, Drownings, Per 100–000,
"age_standardized_dalys_drownings_per_100_000_low" VARCHAR -- Age Standardized Dalys, Drownings, Per 100–000 Low,
"age_standardized_dalys_drownings_per_100_000_high" VARCHAR -- Age Standardized Dalys, Drownings, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_falls_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_falls_per_100_000" INTEGER -- Age Standardized Dalys, Falls, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_falls_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_falls_per_100_000" INTEGER -- Age Standardized Dalys, Falls, Per 100–000,
"age_standardized_dalys_falls_per_100_000_low" VARCHAR -- Age Standardized Dalys, Falls, Per 100–000 Low,
"age_standardized_dalys_falls_per_100_000_high" VARCHAR -- Age Standardized Dalys, Falls, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_fires_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_fires_per_100_000" INTEGER -- Age Standardized Dalys, Fires, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_fires_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_fires_per_100_000" INTEGER -- Age Standardized Dalys, Fires, Per 100–000,
"age_standardized_dalys_fires_per_100_000_low" VARCHAR -- Age Standardized Dalys, Fires, Per 100–000 Low,
"age_standardized_dalys_fires_per_100_000_high" VARCHAR -- Age Standardized Dalys, Fires, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_ischaemic_heart_disease_pe_93005b6a (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_ischaemic_heart_disease_per_100_000" INTEGER -- Age Standardized Dalys, Ischaemic Heart Disease, Per 100–000,
"age_standardized_dalys_ischaemic_heart_disease_per_100_000_low" VARCHAR -- Age Standardized Dalys, Ischaemic Heart Disease, Per 100–000 Low,
"age_standardized_dalys_ischaemic_heart_disease_per_100_000_high" VARCHAR -- Age Standardized Dalys, Ischaemic Heart Disease, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_ischaemic_heart_disease_pe_cae8fa58 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_ischaemic_heart_disease_per_100_000" INTEGER -- Age Standardized Dalys, Ischaemic Heart Disease, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_liver_cancer_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_liver_cancer_per_100_000" FLOAT -- Age Standardized Dalys, Liver Cancer, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_liver_cancer_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_liver_cancer_per_100_000" FLOAT -- Age Standardized Dalys, Liver Cancer, Per 100–000,
"age_standardized_dalys_liver_cancer_per_100_000_low" VARCHAR -- Age Standardized Dalys, Liver Cancer, Per 100–000 Low,
"age_standardized_dalys_liver_cancer_per_100_000_high" VARCHAR -- Age Standardized Dalys, Liver Cancer, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_liver_cirrhosis_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_liver_cirrhosis_per_100_000" INTEGER -- Age Standardized Dalys, Liver Cirrhosis, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_liver_cirrhosis_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_liver_cirrhosis_per_100_000" INTEGER -- Age Standardized Dalys, Liver Cirrhosis, Per 100–000,
"age_standardized_dalys_liver_cirrhosis_per_100_000_low" VARCHAR -- Age Standardized Dalys, Liver Cirrhosis, Per 100–000 Low,
"age_standardized_dalys_liver_cirrhosis_per_100_000_high" VARCHAR -- Age Standardized Dalys, Liver Cirrhosis, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_mouth_and_oropharynx_cance_0a2b6737 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_mouth_and_oropharynx_cancer_per_100_000" INTEGER -- Age Standardized Dalys, Mouth And Oropharynx Cancer, Per 100–000,
"age_standardized_dalys_mouth_and_oropharynx_cancer_per_ee3caf19" VARCHAR -- Age Standardized Dalys, Mouth And Oropharynx Cancer, Per 100–000 Low,
"age_standardized_dalys_mouth_and_oropharynx_cancer_per_e642f670" VARCHAR -- Age Standardized Dalys, Mouth And Oropharynx Cancer, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_age_standardized_dalys_mouth_and_oropharynx_cance_8540443b (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_mouth_and_oropharynx_cancer_per_100_000" INTEGER -- Age Standardized Dalys, Mouth And Oropharynx Cancer, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_oesophagus_cancer_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_oesophagus_cancer_per_100_000" INTEGER -- Age Standardized Dalys, Oesophagus Cancer, Per 100–000
);
CREATE TABLE owid_age_standardized_dalys_oesophagus_cancer_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_standardized_dalys_oesophagus_cancer_per_100_000" INTEGER -- Age Standardized Dalys, Oesophagus Cancer, Per 100–000,
"age_standardized_dalys_oesophagus_cancer_per_100_000_low" VARCHAR -- Age Standardized Dalys, Oesophagus Cancer, Per 100–000 Low,
"age_standardized_dalys_oesophagus_cancer_per_100_000_high" VARCHAR -- Age Standardized Dalys, Oesophagus Cancer, Per 100–000 High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.