Burden Of Disease

CREATE TABLE burden_of_disease_by_cause (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_cardiovascular_di_28062178" DOUBLE,
  "dalys_disability_adjusted_life_years_other_infectious__bbc8d666" DOUBLE,
  "dalys_disability_adjusted_life_years_neurological_diso_e2b8ee3b" DOUBLE,
  "dalys_disability_adjusted_life_years_diabetes_and_kidn_13f197a9" DOUBLE,
  "dalys_disability_adjusted_life_years_digestive_disease_033db28e" DOUBLE,
  "dalys_disability_adjusted_life_years_mental_disorders__42d45e8c" DOUBLE,
  "dalys_disability_adjusted_life_years_transport_injurie_17927293" DOUBLE,
  "dalys_disability_adjusted_life_years_musculoskeletal_d_8ae8c7c1" DOUBLE,
  "dalys_disability_adjusted_life_years_maternal_disorder_02ed93ec" DOUBLE,
  "dalys_disability_adjusted_life_years_self_harm_sex_bot_b73a746c" DOUBLE,
  "dalys_disability_adjusted_life_years_interpersonal_vio_8a853d28" DOUBLE,
  "dalys_disability_adjusted_life_years_unintentional_inj_b9d4cc12" DOUBLE,
  "dalys_disability_adjusted_life_years_neglected_tropica_1dc982d3" DOUBLE,
  "dalys_disability_adjusted_life_years_enteric_infection_6d71c98a" DOUBLE,
  "dalys_disability_adjusted_life_years_substance_use_dis_7ea3e336" DOUBLE,
  "dalys_disability_adjusted_life_years_nutritional_defic_4c8b938e" DOUBLE,
  "dalys_disability_adjusted_life_years_conflict_and_terr_89bd4f29" DOUBLE,
  "dalys_disability_adjusted_life_years_neoplasms_sex_bot_3df32a7b" DOUBLE,
  "dalys_disability_adjusted_life_years_other_non_communi_d48a8588" DOUBLE,
  "dalys_disability_adjusted_life_years_hiv_aids_and_sexu_743e4cdc" DOUBLE,
  "dalys_disability_adjusted_life_years_neonatal_disorder_789352e0" DOUBLE,
  "dalys_disability_adjusted_life_years_respiratory_infec_9ee8082b" DOUBLE,
  "dalys_disability_adjusted_life_years_exposure_to_force_6b839b15" DOUBLE,
  "dalys_disability_adjusted_life_years_chronic_respirato_a906cd05" DOUBLE,
  "dalys_disability_adjusted_life_years_skin_and_subcutan_a7d79601" DOUBLE
);

CREATE TABLE burden_of_disease_from_injuries_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_injuries_sex_both_bd97fd5f" DOUBLE,
  "dalys_disability_adjusted_life_years_injuries_sex_both_ec31818a" DOUBLE,
  "dalys_disability_adjusted_life_years_injuries_sex_both_6dc3ed2e" DOUBLE,
  "dalys_disability_adjusted_life_years_injuries_sex_both_ddae245a" DOUBLE,
  "dalys_disability_adjusted_life_years_injuries_sex_both_0850d775" DOUBLE
);

CREATE TABLE burden_of_disease_rates_from_communicable_neonatal_mat_901026b7 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_communicable_mate_2516183e" DOUBLE
);

CREATE TABLE burden_of_disease_rates_from_injuries (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_injuries_sex_both_b7e5d1c4" DOUBLE
);

CREATE TABLE burden_of_disease_rates_from_ncds (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_non_communicable__e954e6e3" DOUBLE
);

CREATE TABLE daly_rates_from_all_causes_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_6e031f84" DOUBLE,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_4e1207ca" DOUBLE,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_329617d1" DOUBLE,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_1eba3003" DOUBLE,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_fbfac216" DOUBLE,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_c5f730e2" DOUBLE,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_58b46c05" DOUBLE
);

CREATE TABLE dalys_rate_from_all_causes (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_58b46c05" DOUBLE
);

CREATE TABLE dalys_to_ncds_vs_gdp (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_non_communicable__e954e6e3" DOUBLE,
  "gdp_per_capita_ppp_constant_2017_international" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE disease_burden_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_e13883b4" DOUBLE,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_2d6f1b5d" DOUBLE,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_a8f97175" DOUBLE,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_6950422c" DOUBLE,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_8892318b" DOUBLE
);

CREATE TABLE disease_burden_from_communicable_diseases_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_communicable_mate_7f67cdf5" DOUBLE,
  "dalys_disability_adjusted_life_years_communicable_mate_d894a487" DOUBLE,
  "dalys_disability_adjusted_life_years_communicable_mate_18bca5a8" DOUBLE,
  "dalys_disability_adjusted_life_years_communicable_mate_d854c586" DOUBLE,
  "dalys_disability_adjusted_life_years_communicable_mate_7668a035" DOUBLE
);

CREATE TABLE disease_burden_from_communicable_diseases (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_maternal_disorder_02ed93ec" DOUBLE,
  "dalys_disability_adjusted_life_years_nutritional_defic_4c8b938e" DOUBLE,
  "dalys_disability_adjusted_life_years_neglected_tropica_1dc982d3" DOUBLE,
  "dalys_disability_adjusted_life_years_neonatal_disorder_789352e0" DOUBLE,
  "dalys_disability_adjusted_life_years_tuberculosis_sex__490e98b3" DOUBLE,
  "dalys_disability_adjusted_life_years_hiv_aids_and_sexu_743e4cdc" DOUBLE,
  "dalys_disability_adjusted_life_years_respiratory_infec_9ee8082b" DOUBLE,
  "dalys_disability_adjusted_life_years_enteric_infection_6d71c98a" DOUBLE,
  "dalys_disability_adjusted_life_years_other_infectious__bbc8d666" DOUBLE
);

CREATE TABLE disease_burden_from_injuries (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_self_harm_sex_bot_b73a746c" DOUBLE,
  "dalys_disability_adjusted_life_years_interpersonal_vio_8a853d28" DOUBLE,
  "dalys_disability_adjusted_life_years_exposure_to_force_6b839b15" DOUBLE,
  "dalys_disability_adjusted_life_years_conflict_and_terr_89bd4f29" DOUBLE,
  "dalys_disability_adjusted_life_years_road_injuries_sex_1034ef7b" DOUBLE,
  "dalys_disability_adjusted_life_years_other_transport_i_3adfcc4a" DOUBLE,
  "dalys_disability_adjusted_life_years_falls_sex_both_ag_7eaacd6e" DOUBLE,
  "dalys_disability_adjusted_life_years_drowning_sex_both_f8828100" DOUBLE,
  "dalys_disability_adjusted_life_years_fire_heat_and_hot_c0ac77a7" DOUBLE,
  "dalys_disability_adjusted_life_years_poisonings_sex_bo_5147f301" DOUBLE
);

CREATE TABLE disease_burden_from_ncds_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_non_communicable__e5f2ac4d" DOUBLE,
  "dalys_disability_adjusted_life_years_non_communicable__949c7801" DOUBLE,
  "dalys_disability_adjusted_life_years_non_communicable__c35fb06b" DOUBLE,
  "dalys_disability_adjusted_life_years_non_communicable__868eaef1" DOUBLE,
  "dalys_disability_adjusted_life_years_non_communicable__90116371" DOUBLE
);

CREATE TABLE disease_burden_from_ncds (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_diabetes_and_kidn_13f197a9" DOUBLE,
  "dalys_disability_adjusted_life_years_other_non_communi_d48a8588" DOUBLE,
  "dalys_disability_adjusted_life_years_skin_and_subcutan_a7d79601" DOUBLE,
  "dalys_disability_adjusted_life_years_musculoskeletal_d_8ae8c7c1" DOUBLE,
  "dalys_disability_adjusted_life_years_chronic_respirato_a906cd05" DOUBLE,
  "dalys_disability_adjusted_life_years_cardiovascular_di_28062178" DOUBLE,
  "dalys_disability_adjusted_life_years_digestive_disease_033db28e" DOUBLE,
  "dalys_disability_adjusted_life_years_substance_use_dis_7ea3e336" DOUBLE,
  "dalys_disability_adjusted_life_years_neoplasms_sex_bot_3df32a7b" DOUBLE,
  "dalys_disability_adjusted_life_years_neurological_diso_e2b8ee3b" DOUBLE,
  "dalys_disability_adjusted_life_years_cirrhosis_and_oth_1918116d" DOUBLE,
  "dalys_disability_adjusted_life_years_mental_disorders__42d45e8c" DOUBLE
);

CREATE TABLE disease_burden_to_communicable_diseases_vs_gdp (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_communicable_mate_2516183e" DOUBLE,
  "gdp_per_capita_ppp_constant_2017_international" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE disease_burden_vs_health_expenditure_per_capita (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_all_causes_sex_bo_58b46c05" DOUBLE,
  "current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE share_of_disease_burden_from_communicable_diseases_vs_gdp (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_communicable_mate_e5c5c78e" DOUBLE,
  "gdp_per_capita_ppp_constant_2017_international" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE share_of_disease_burden_from_ncds_vs_gdp (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_non_communicable__a94ef510" DOUBLE,
  "gdp_per_capita_ppp_constant_2017_international" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE share_of_total_disease_burden_by_cause (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_self_harm_sex_bot_392183de" DOUBLE,
  "dalys_disability_adjusted_life_years_exposure_to_force_e658ed28" DOUBLE,
  "dalys_disability_adjusted_life_years_conflict_and_terr_e444a5af" DOUBLE,
  "dalys_disability_adjusted_life_years_interpersonal_vio_5818e997" DOUBLE,
  "dalys_disability_adjusted_life_years_neglected_tropica_e9ea9405" DOUBLE,
  "dalys_disability_adjusted_life_years_substance_use_dis_ec873260" DOUBLE,
  "dalys_disability_adjusted_life_years_skin_and_subcutan_00ad47de" DOUBLE,
  "dalys_disability_adjusted_life_years_enteric_infection_f6b0e658" DOUBLE,
  "dalys_disability_adjusted_life_years_diabetes_and_kidn_c5c91f80" DOUBLE,
  "dalys_disability_adjusted_life_years_cardiovascular_di_44f4daa6" DOUBLE,
  "dalys_disability_adjusted_life_years_digestive_disease_ce5f7073" DOUBLE,
  "dalys_disability_adjusted_life_years_nutritional_defic_6d09ecdf" DOUBLE,
  "dalys_disability_adjusted_life_years_respiratory_infec_931cec12" DOUBLE,
  "dalys_disability_adjusted_life_years_neonatal_disorder_737dc5a8" DOUBLE,
  "dalys_disability_adjusted_life_years_chronic_respirato_807e5abb" DOUBLE,
  "dalys_disability_adjusted_life_years_other_non_communi_bab0bd5f" DOUBLE,
  "dalys_disability_adjusted_life_years_maternal_disorder_a1042c5f" DOUBLE,
  "dalys_disability_adjusted_life_years_unintentional_inj_077f367a" DOUBLE,
  "dalys_disability_adjusted_life_years_musculoskeletal_d_cff94977" DOUBLE,
  "dalys_disability_adjusted_life_years_neoplasms_sex_bot_e1e3c059" DOUBLE,
  "dalys_disability_adjusted_life_years_mental_disorders__6698463d" DOUBLE,
  "dalys_disability_adjusted_life_years_neurological_diso_c520846e" DOUBLE,
  "dalys_disability_adjusted_life_years_hiv_aids_and_sexu_0e8ec507" DOUBLE,
  "dalys_disability_adjusted_life_years_transport_injurie_da075295" DOUBLE,
  "dalys_disability_adjusted_life_years_sense_organ_disea_606e9969" DOUBLE
);

CREATE TABLE total_disease_burden_by_cause (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_non_communicable__00669a83" DOUBLE,
  "dalys_disability_adjusted_life_years_communicable_mate_eabe414d" DOUBLE,
  "dalys_disability_adjusted_life_years_injuries_sex_both_5d40d04a" DOUBLE
);