Cancer Regression
Cancer data of United States of America
@kaggle.varunraskar_cancer_regression
Cancer data of United States of America
@kaggle.varunraskar_cancer_regression
The dataset contains 2 .csv files
This file contains various demographic and health-related data for different regions. Here's a brief description of each column:
File 1st
avganncount: Average number of cancer cases diagnosed annually.
avgdeathsperyear: Average number of deaths due to cancer per year.
target_deathrate: Target death rate due to cancer.
incidencerate: Incidence rate of cancer.
medincome: Median income in the region.
popest2015: Estimated population in 2015.
povertypercent: Percentage of population below the poverty line.
studypercap: Per capita number of cancer-related clinical trials conducted.
binnedinc: Binned median income.
medianage: Median age in the region.
pctprivatecoveragealone: Percentage of population covered by private health insurance alone.
pctempprivcoverage: Percentage of population covered by employee-provided private health insurance.
pctpubliccoverage: Percentage of population covered by public health insurance.
pctpubliccoveragealone: Percentage of population covered by public health insurance only.
pctwhite: Percentage of White population.
pctblack: Percentage of Black population.
pctasian: Percentage of Asian population.
pctotherrace: Percentage of population belonging to other races.
pctmarriedhouseholds: Percentage of married households.
birthrate: Birth rate in the region.
File 2nd
This file contains demographic information about different regions, including details about household size and geographical location. Here's a description of each column:
statefips: The FIPS code representing the state.
countyfips: The FIPS code representing the county or census area within the state.
avghouseholdsize: The average household size in the region.
geography: The geographical location, typically represented as the county or census area name followed by the state name.
Each row in the file represents a specific region, providing details about household size and geographical location. This information can be used for various demographic analyses and studies.
CREATE TABLE avg_household_size (
"statefips" BIGINT,
"countyfips" BIGINT,
"avghouseholdsize" DOUBLE,
"geography" VARCHAR
);CREATE TABLE cancer_reg (
"avganncount" DOUBLE,
"avgdeathsperyear" BIGINT,
"target_deathrate" DOUBLE,
"incidencerate" DOUBLE,
"medincome" BIGINT,
"popest2015" BIGINT,
"povertypercent" DOUBLE,
"studypercap" DOUBLE,
"binnedinc" VARCHAR,
"medianage" DOUBLE,
"medianagemale" DOUBLE,
"medianagefemale" DOUBLE,
"geography" VARCHAR,
"percentmarried" DOUBLE,
"pctnohs18_24" DOUBLE,
"pcths18_24" DOUBLE,
"pctsomecol18_24" DOUBLE,
"pctbachdeg18_24" DOUBLE,
"pcths25_over" DOUBLE,
"pctbachdeg25_over" DOUBLE,
"pctemployed16_over" DOUBLE,
"pctunemployed16_over" DOUBLE,
"pctprivatecoverage" DOUBLE,
"pctprivatecoveragealone" DOUBLE,
"pctempprivcoverage" DOUBLE,
"pctpubliccoverage" DOUBLE,
"pctpubliccoveragealone" DOUBLE,
"pctwhite" DOUBLE,
"pctblack" DOUBLE,
"pctasian" DOUBLE,
"pctotherrace" DOUBLE,
"pctmarriedhouseholds" DOUBLE,
"birthrate" DOUBLE
);Anyone who has the link will be able to view this.