Cancer
Cancer Dataset with Alot of data
@kaggle.programmerrdai_cancer
Cancer Dataset with Alot of data
@kaggle.programmerrdai_cancer
CREATE TABLE annual_number_of_deaths_by_cause (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"number_of_executions_amnesty_international" VARCHAR,
"deaths_meningitis_sex_both_age_all_ages_number" DOUBLE,
"deaths_alzheimer_s_disease_and_other_dementias_sex_bot_448cb23e" DOUBLE,
"deaths_parkinson_s_disease_sex_both_age_all_ages_number" DOUBLE,
"deaths_nutritional_deficiencies_sex_both_age_all_ages_number" DOUBLE,
"deaths_malaria_sex_both_age_all_ages_number" DOUBLE,
"deaths_drowning_sex_both_age_all_ages_number" DOUBLE,
"deaths_interpersonal_violence_sex_both_age_all_ages_number" DOUBLE,
"deaths_maternal_disorders_sex_both_age_all_ages_number" DOUBLE,
"deaths_hiv_aids_sex_both_age_all_ages_number" DOUBLE,
"deaths_drug_use_disorders_sex_both_age_all_ages_number" DOUBLE,
"deaths_tuberculosis_sex_both_age_all_ages_number" DOUBLE,
"deaths_cardiovascular_diseases_sex_both_age_all_ages_number" DOUBLE,
"deaths_lower_respiratory_infections_sex_both_age_all_a_04c08283" DOUBLE,
"deaths_neonatal_disorders_sex_both_age_all_ages_number" DOUBLE,
"deaths_alcohol_use_disorders_sex_both_age_all_ages_number" DOUBLE,
"deaths_self_harm_sex_both_age_all_ages_number" DOUBLE,
"deaths_exposure_to_forces_of_nature_sex_both_age_all_a_da879c0d" DOUBLE,
"deaths_diarrheal_diseases_sex_both_age_all_ages_number" DOUBLE,
"deaths_environmental_heat_and_cold_exposure_sex_both_a_d4f48874" DOUBLE,
"deaths_neoplasms_sex_both_age_all_ages_number" DOUBLE,
"deaths_conflict_and_terrorism_sex_both_age_all_ages_number" DOUBLE,
"deaths_diabetes_mellitus_sex_both_age_all_ages_number" DOUBLE,
"deaths_chronic_kidney_disease_sex_both_age_all_ages_number" DOUBLE,
"deaths_poisonings_sex_both_age_all_ages_number" DOUBLE,
"deaths_protein_energy_malnutrition_sex_both_age_all_ag_9b9b0ecc" DOUBLE,
"terrorism_deaths" DOUBLE,
"deaths_road_injuries_sex_both_age_all_ages_number" DOUBLE,
"deaths_chronic_respiratory_diseases_sex_both_age_all_a_5fe95eb3" DOUBLE,
"deaths_cirrhosis_and_other_chronic_liver_diseases_sex__97badbdc" DOUBLE,
"deaths_digestive_diseases_sex_both_age_all_ages_number" DOUBLE,
"deaths_fire_heat_and_hot_substances_sex_both_age_all_a_a15461ab" DOUBLE,
"deaths_acute_hepatitis_sex_both_age_all_ages_number" DOUBLE
);
CREATE TABLE breast_cancer_survival_rates_vs_gdp_per_capita (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"breast" DOUBLE,
"gdp_per_capita_ppp_constant_2017_international" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE cancer_death_rates_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_neoplasms_sex_both_age_under_5_rate" DOUBLE,
"deaths_neoplasms_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_neoplasms_sex_both_age_all_ages_rate" DOUBLE,
"deaths_neoplasms_sex_both_age_70_years_rate" DOUBLE,
"deaths_neoplasms_sex_both_age_5_14_years_rate" DOUBLE,
"deaths_neoplasms_sex_both_age_50_69_years_rate" DOUBLE,
"deaths_neoplasms_sex_both_age_15_49_years_rate" DOUBLE
);
CREATE TABLE cancer_death_rates_by_type (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_prostate_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_breast_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_uterine_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_bladder_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_cervical_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_kidney_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_stomach_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_nasopharynx_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_testicular_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_other_pharynx_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_esophageal_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_non_melanoma_skin_cancer_sex_both_age_age_stand_cd643d4b" DOUBLE,
"deaths_pancreatic_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_tracheal_bronchus_and_lung_cancer_sex_both_age__e50ae8c1" DOUBLE,
"deaths_lip_and_oral_cavity_cancer_sex_both_age_age_sta_8208ae30" DOUBLE,
"deaths_colon_and_rectum_cancer_sex_both_age_age_standa_afdd1407" DOUBLE,
"deaths_gallbladder_and_biliary_tract_cancer_sex_both_a_9224bd23" DOUBLE,
"deaths_liver_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_larynx_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_ovarian_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_thyroid_cancer_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_brain_and_central_nervous_system_cancer_sex_bot_2e22e6ca" DOUBLE
);
CREATE TABLE cancer_death_rates_in_the_us (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"breast_female" DOUBLE,
"colon_and_rectum_female" DOUBLE,
"colon_and_rectum_male" DOUBLE,
"leukemia_male" DOUBLE,
"liver_female" DOUBLE,
"liver_male" DOUBLE,
"lung_and_bronchus_female" DOUBLE,
"lung_and_bronchus_male" DOUBLE,
"pancreas_female" DOUBLE,
"pancreas_male" DOUBLE,
"prostate_male" DOUBLE,
"stomach_female" DOUBLE,
"stomach_male" DOUBLE,
"uterus_female" DOUBLE
);
CREATE TABLE cancer_death_rates (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_neoplasms_sex_both_age_age_standardized_rate" DOUBLE
);
CREATE TABLE cancer_deaths_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_neoplasms_sex_both_age_under_5_number" BIGINT,
"deaths_neoplasms_sex_both_age_5_14_years_number" BIGINT,
"deaths_neoplasms_sex_both_age_15_49_years_number" BIGINT,
"deaths_neoplasms_sex_both_age_70_years_number" BIGINT,
"deaths_neoplasms_sex_both_age_50_69_years_number" BIGINT
);
CREATE TABLE cancer_deaths_by_type_grouped (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"bladder_cancer_deaths" BIGINT,
"brain_and_nervous_system_cancer_deaths" BIGINT,
"breast_cancer_deaths" BIGINT,
"cervical_cancer_deaths" BIGINT,
"colon_and_rectum_cancer_deaths" BIGINT,
"esophageal_cancer_deaths" BIGINT,
"gallbladder_cancer_deaths" BIGINT,
"kidney_cancer_deaths" BIGINT,
"larynx_cancer_deaths" BIGINT,
"leukemia_deaths" BIGINT,
"lip_and_oral_cavity_cancer_deaths" BIGINT,
"liver_cancer_deaths" BIGINT,
"non_hodgkin_lymphoma_deaths" BIGINT,
"other_cancers_deaths" BIGINT,
"other_pharynx_cancer_deaths" BIGINT,
"ovarian_cancer_deaths" BIGINT,
"pancreatic_cancer_deaths" BIGINT,
"prostate_cancer_deaths" BIGINT,
"stomach_cancer_deaths" BIGINT,
"tracheal_bronchus_and_lung_cancer_deaths" BIGINT
);
CREATE TABLE cancer_deaths_rate_and_age_standardized_rate_index (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_neoplasms_sex_both_age_age_standardized_rate" DOUBLE,
"deaths_neoplasms_sex_both_age_all_ages_rate" DOUBLE,
"deaths_neoplasms_sex_both_age_all_ages_number" BIGINT
);
CREATE TABLE death_rate_from_cancers_vs_average_income (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_neoplasms_sex_both_age_age_standardized_rate" DOUBLE,
"gdp_per_capita_ppp_constant_2017_international" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE disease_burden_rates_by_cancer_types (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"dalys_disability_adjusted_life_years_other_pharynx_can_525d9b55" DOUBLE,
"dalys_disability_adjusted_life_years_liver_cancer_sex__a24c0b9e" DOUBLE,
"dalys_disability_adjusted_life_years_breast_cancer_sex_820bc316" DOUBLE,
"dalys_disability_adjusted_life_years_tracheal_bronchus_4f8c7a4b" DOUBLE,
"dalys_disability_adjusted_life_years_gallbladder_and_b_981f3672" DOUBLE,
"dalys_disability_adjusted_life_years_kidney_cancer_sex_2834ad1a" DOUBLE,
"dalys_disability_adjusted_life_years_larynx_cancer_sex_f2e5fd14" DOUBLE,
"dalys_disability_adjusted_life_years_stomach_cancer_se_ff024a78" DOUBLE,
"dalys_disability_adjusted_life_years_thyroid_cancer_se_2c18ea96" DOUBLE,
"dalys_disability_adjusted_life_years_uterine_cancer_se_0548c77a" DOUBLE,
"dalys_disability_adjusted_life_years_ovarian_cancer_se_7137b0a3" DOUBLE,
"dalys_disability_adjusted_life_years_bladder_cancer_se_ec764fdf" DOUBLE,
"dalys_disability_adjusted_life_years_cervical_cancer_s_f8b054e1" DOUBLE,
"dalys_disability_adjusted_life_years_prostate_cancer_s_c419388d" DOUBLE,
"dalys_disability_adjusted_life_years_brain_and_central_8ff55a9d" DOUBLE,
"dalys_disability_adjusted_life_years_pancreatic_cancer_51397a13" DOUBLE,
"dalys_disability_adjusted_life_years_testicular_cancer_b117c228" DOUBLE,
"dalys_disability_adjusted_life_years_esophageal_cancer_525b84f5" DOUBLE,
"dalys_disability_adjusted_life_years_nasopharynx_cance_15718a19" DOUBLE,
"dalys_disability_adjusted_life_years_colon_and_rectum__0f7853c6" DOUBLE,
"dalys_disability_adjusted_life_years_non_melanoma_skin_d37d1a11" DOUBLE,
"dalys_disability_adjusted_life_years_lip_and_oral_cavi_25f1dfc2" DOUBLE,
"dalys_disability_adjusted_life_years_malignant_skin_me_ba535d8e" DOUBLE,
"dalys_disability_adjusted_life_years_other_malignant_n_1dc732d3" DOUBLE,
"dalys_disability_adjusted_life_years_mesothelioma_sex__088b0e5b" DOUBLE,
"dalys_disability_adjusted_life_years_hodgkin_lymphoma__a4df8d89" DOUBLE,
"dalys_disability_adjusted_life_years_non_hodgkin_lymph_a4b8fbca" DOUBLE
);
CREATE TABLE disease_burden_rates_from_cancers (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"dalys_disability_adjusted_life_years_neoplasms_sex_bot_72ce3bab" DOUBLE
);
CREATE TABLE five_year_survival_rate_from_liver_cancer (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"liver" DOUBLE
);
CREATE TABLE five_year_survival_rates_by_cancer_type (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"breast" DOUBLE,
"cervix" DOUBLE,
"colon" DOUBLE,
"leukaemia" DOUBLE,
"liver" DOUBLE,
"lung" DOUBLE,
"ovary" DOUBLE,
"prostate" DOUBLE,
"rectum" DOUBLE,
"stomach" DOUBLE
);
CREATE TABLE five_year_survival_rates_from_breast_cancer (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"breast" DOUBLE
);
CREATE TABLE five_year_survival_rates_from_lung_cancer (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"lung" DOUBLE
);
CREATE TABLE lung_cancer_deaths_per_100000_by_sex_1950_2002 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"age_standardized_death_rate_per_100k_male" DOUBLE,
"age_standardized_death_rate_per_100k_female" DOUBLE
);
CREATE TABLE lung_cancer_survival_rate_vs_gdp (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"lung" DOUBLE,
"gdp_per_capita_ppp_constant_2017_international" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE number_of_people_with_cancer_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"prevalence_neoplasms_sex_both_age_under_5_number" DOUBLE,
"prevalence_neoplasms_sex_both_age_50_69_years_number" DOUBLE,
"prevalence_neoplasms_sex_both_age_15_49_years_number" DOUBLE,
"prevalence_neoplasms_sex_both_age_5_14_years_number" DOUBLE,
"prevalence_neoplasms_sex_both_age_70_years_number" DOUBLE
);
CREATE TABLE sales_of_cigarettes_per_adult_per_day (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"sales_of_cigarettes_per_adult_per_day_international_sm_08c08fe8" DOUBLE
);
CREATE TABLE share_of_cancer_deaths_attributed_to_risk_factors (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_of_cancer_deaths_attributable_to_risk_factors" DOUBLE
);
CREATE TABLE share_of_cancer_deaths_attributed_to_tobacco (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_cause_neoplasms_risk_smoking_owid_sex_both_age__7b697686" DOUBLE
);
CREATE TABLE share_of_population_with_cancer_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"prevalence_neoplasms_sex_both_age_under_5_percent" DOUBLE,
"prevalence_neoplasms_sex_both_age_70_years_percent" DOUBLE,
"prevalence_neoplasms_sex_both_age_15_49_years_percent" DOUBLE,
"prevalence_neoplasms_sex_both_age_50_69_years_percent" DOUBLE,
"prevalence_neoplasms_sex_both_age_5_14_years_percent" DOUBLE,
"prevalence_neoplasms_sex_both_age_all_ages_percent" DOUBLE
);
CREATE TABLE share_of_population_with_cancer_types (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"prevalence_liver_cancer_sex_both_age_age_standardized_percent" DOUBLE,
"prevalence_kidney_cancer_sex_both_age_age_standardized_percent" DOUBLE,
"prevalence_larynx_cancer_sex_both_age_age_standardized_percent" DOUBLE,
"prevalence_breast_cancer_sex_both_age_age_standardized_percent" DOUBLE,
"prevalence_thyroid_cancer_sex_both_age_age_standardize_50598030" DOUBLE,
"prevalence_bladder_cancer_sex_both_age_age_standardize_728205bb" DOUBLE,
"prevalence_uterine_cancer_sex_both_age_age_standardize_fee2d0da" DOUBLE,
"prevalence_ovarian_cancer_sex_both_age_age_standardize_1768070f" DOUBLE,
"prevalence_stomach_cancer_sex_both_age_age_standardize_c54d5396" DOUBLE,
"prevalence_prostate_cancer_sex_both_age_age_standardiz_e713bab4" DOUBLE,
"prevalence_cervical_cancer_sex_both_age_age_standardiz_91c9aa72" DOUBLE,
"prevalence_testicular_cancer_sex_both_age_age_standard_fd368400" DOUBLE,
"prevalence_pancreatic_cancer_sex_both_age_age_standard_5580aee4" DOUBLE,
"prevalence_esophageal_cancer_sex_both_age_age_standard_b95ead49" DOUBLE,
"prevalence_nasopharynx_cancer_sex_both_age_age_standar_30de33d4" DOUBLE,
"prevalence_colon_and_rectum_cancer_sex_both_age_age_st_4949f1db" DOUBLE,
"prevalence_non_melanoma_skin_cancer_sex_both_age_age_s_ec78fb6a" DOUBLE,
"prevalence_lip_and_oral_cavity_cancer_sex_both_age_age_d94af64d" DOUBLE,
"prevalence_brain_and_nervous_system_cancer_sex_both_ag_e280bb5b" DOUBLE,
"prevalence_tracheal_bronchus_and_lung_cancer_sex_both__8e4795ea" DOUBLE,
"prevalence_gallbladder_and_biliary_tract_cancer_sex_bo_f868de97" DOUBLE
);
CREATE TABLE share_of_population_with_cancer (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"prevalence_neoplasms_sex_both_age_age_standardized_percent" DOUBLE
);
CREATE TABLE total_cancer_deaths_by_type (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_liver_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_kidney_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_lip_and_oral_cavity_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_tracheal_bronchus_and_lung_cancer_sex_both_age__cf975ccb" BIGINT,
"deaths_larynx_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_gallbladder_and_biliary_tract_cancer_sex_both_a_585fcc70" BIGINT,
"deaths_malignant_skin_melanoma_sex_both_age_all_ages_number" BIGINT,
"deaths_leukemia_sex_both_age_all_ages_number" BIGINT,
"deaths_hodgkin_lymphoma_sex_both_age_all_ages_number" BIGINT,
"deaths_multiple_myeloma_sex_both_age_all_ages_number" BIGINT,
"deaths_other_neoplasms_sex_both_age_all_ages_number" BIGINT,
"deaths_breast_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_prostate_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_thyroid_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_stomach_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_bladder_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_uterine_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_ovarian_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_cervical_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_brain_and_central_nervous_system_cancer_sex_bot_e91e880e" BIGINT,
"deaths_non_hodgkin_lymphoma_sex_both_age_all_ages_number" BIGINT,
"deaths_pancreatic_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_esophageal_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_testicular_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_nasopharynx_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_other_pharynx_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_colon_and_rectum_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_non_melanoma_skin_cancer_sex_both_age_all_ages_number" BIGINT,
"deaths_mesothelioma_sex_both_age_all_ages_number" BIGINT
);
Anyone who has the link will be able to view this.