{"main_topic":"health","sub_topic":"cancer","topic":"cancer_mortality","key":"health/cancer/cancer_mortality","version":"1.0.0","year_min":2024,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","states"],"default_detail":"counties","path_template":"health/cancer_mortality/year={year}/{detail}.parquet","grain":["year","county_fips","tract_geoid","demographic","sex","cancer_site"],"title":"Cancer Death Rates","summary":"Age-adjusted cancer death rates per 100,000, 2020-2024, for Georgia and its counties by cancer site, race/ethnicity and sex.","description":"Cancer death rates for Georgia and each of its 159 counties, pooled over 2020-2024: the age-adjusted death rate per 100,000 residents (2000 U.S. standard population) with its 95% confidence interval, and the average number of deaths per year, by cancer site (all cancers, 19 named sites and two childhood groups), race/ethnicity (non-Hispanic white, black, American Indian/Alaska Native and Asian/Pacific Islander, and Hispanic) and sex, from the National Cancer Institute and CDC's State Cancer Profiles (deaths from the national death file). Small groups are suppressed by NCI (fewer than 16 deaths over the five years).","explorer":true,"search_aliases":{"en":["cancer deaths","cancer mortality","dying of cancer","cancer death toll","lung cancer deaths","breast cancer deaths","prostate cancer deaths","colon cancer deaths","cancer fatalities"],"es":["muertes por cáncer","mortalidad por cáncer","defunciones por cáncer","muerte por cáncer","morir de cáncer","mortalidad cáncer de pulmón","cáncer de mama mortalidad"]},"source":"National Cancer Institute and Centers for Disease Control and Prevention, State Cancer Profiles: Death Rate Report for Georgia by County (deaths from the CDC National Center for Health Statistics' National Vital Statistics System; rates calculated by NCI with SEER*Stat), 2020-2024 pooled, as retrieved 2026-10-24","source_url":"https://statecancerprofiles.cancer.gov/deathrates/index.php","endpoint":"/api/v1/health/cancer_mortality","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"End year of the pooled five-year window: 2024 = deaths in 2020-2024. Every figure covers those five years together, not 2024 alone (see year_meaning).","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"county_fips","type":"string","role":"fk_county","nullable":true,"label":"County FIPS","short_description":"","description":"5-digit county FIPS code as published (FK to the counties dimension): the decedent's county of residence. NULL on the statewide row.","valid_values":null,"example":"13121","unit":null,"value_min":null,"value_max":null,"null_meaning":"Statewide row (Georgia as a whole).","key_metric_grain_contributor":false,"metric_component":null},{"name":"tract_geoid","type":"string","role":"fk_tract","nullable":true,"label":"Tract GEOID","short_description":"","description":"Always NULL: State Cancer Profiles publishes state and county figures only. Kept for the health domain's standard key shape.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":"Always NULL (no tract figures in the source).","key_metric_grain_contributor":false,"metric_component":null},{"name":"demographic","type":"string","role":"fk_demographic","nullable":false,"label":"Race/Ethnicity","short_description":"Race/ethnicity: non-Hispanic groups and Hispanic of any race; 'all' is everyone.","description":"Race/ethnicity of the decedent (FK to the demographics dimension). Mutually exclusive groups: white, black, native_american (American Indian/Alaska Native) and asian_pacific_islander (Asian and Pacific Islander combined, as NCI publishes it; never split) are non-Hispanic; hispanic is Hispanic of any race. 'all' is every death, including those of unknown Hispanic origin. Sex is on the sex column.","valid_values":["all","white","black","hispanic","asian_pacific_islander","native_american"],"example":"black","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"sex","type":"string","role":"categorical","nullable":false,"label":"Sex","short_description":"Sex: all, male or female; sex-specific sites have only their own sex.","description":"Sex: 'male', 'female', or 'all' (both sexes). Male + female = all for the counts, within rounding. The sex-specific sites (breast_female, cervix, ovary, uterus: female; prostate: male) are published for that sex only and have no 'all' row.","valid_values":["all","male","female"],"example":"female","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"cancer_site","type":"string","role":"categorical","nullable":false,"label":"Cancer Site","short_description":"Cancer site of the underlying cause of death; 'all' is every cancer. Sites overlap - pick one.","description":"Primary cancer site of the underlying cause of death, as State Cancer Profiles groups it: 'all' (all cancer sites, the total), bladder, brain_and_other_nervous_system, breast_female, cervix, colon_and_rectum, esophagus, kidney_and_renal_pelvis, leukemia, liver_and_bile_duct, lung_and_bronchus, melanoma_of_the_skin, non_hodgkin_lymphoma, oral_cavity_and_pharynx, ovary, pancreas, prostate, stomach, thyroid, uterus (corpus and uterus, NOS), and two childhood groups, childhood_under_15 and childhood_under_20 (all cancer sites among children under 15 / under 20; their rates are per 100,000 children of those ages, and the under-20 group contains the under-15 one). The named sites do not cover every cancer and the childhood groups overlap them, so sites never add up: only 'all' is the total. breast_female, cervix, ovary, uterus exist for sex 'female' only and prostate for 'male' only.","valid_values":["all","bladder","brain_and_other_nervous_system","breast_female","cervix","childhood_under_15","childhood_under_20","colon_and_rectum","esophagus","kidney_and_renal_pelvis","leukemia","liver_and_bile_duct","lung_and_bronchus","melanoma_of_the_skin","non_hodgkin_lymphoma","oral_cavity_and_pharynx","ovary","pancreas","prostate","stomach","thyroid","uterus"],"example":"lung_and_bronchus","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"age_adjusted_death_rate_per_100k","type":"number","role":"metric","nullable":true,"label":"Age-Adjusted Cancer Death Rate (per 100,000)","short_description":"Cancer deaths per 100,000 residents a year, 2020-2024, age-adjusted to the 2000 U.S. standard population.","description":"Deaths per 100,000 residents per year with the cancer site as the underlying cause, over 2020-2024 together, age-adjusted to the 2000 U.S. standard population (20 age groups), as NCI publishes it (rounded to 0.1). Age adjustment makes places with older or younger populations comparable; it is not the share of residents who died. For the sex-specific sites it is per 100,000 women or men, for the childhood groups per 100,000 children under 15 or under 20. Rates never add or average across rows (no population is published to weight them). Small groups can show very high, very uncertain rates: the highest, 886.6 (95% CI 134.2-2,406.5), is Black men in Charlton County, all sites, about 4 deaths a year, preserved as NCI publishes it; read such rates with their intervals. Healthy People 2030 objectives, not served as a column: all sites 122.7, lung_and_bronchus 25.1, breast_female 15.3, prostate 16.9 and colon_and_rectum 8.9 deaths per 100,000; NCI counts an area as meeting one when its rate is below it (its objectives are age-adjusted by slightly different methods).","valid_values":null,"example":31.1,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"Suppressed by NCI (State Cancer Profiles shows '*'): fewer than 16 deaths were recorded over 2020-2024 in this area, sex and race group. Never a zero, and never estimated or filled in here.","key_metric_grain_contributor":false,"metric_component":null},{"name":"age_adjusted_death_rate_per_100k_ci_lower","type":"number","role":"metric","nullable":true,"label":"Death Rate 95% CI Lower Bound","short_description":"","description":"Lower bound of the 95% confidence interval of age_adjusted_death_rate_per_100k, as NCI publishes it (rounded to 0.1): the range in which the rate would fall from chance variation in so few deaths. Wide for small counties and groups; two places whose intervals do not overlap differ by more than chance.","valid_values":null,"example":30.7,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"Suppressed by NCI (State Cancer Profiles shows '*'): fewer than 16 deaths were recorded over 2020-2024 in this area, sex and race group. Never a zero, and never estimated or filled in here.","key_metric_grain_contributor":false,"metric_component":null},{"name":"age_adjusted_death_rate_per_100k_ci_upper","type":"number","role":"metric","nullable":true,"label":"Death Rate 95% CI Upper Bound","short_description":"","description":"Upper bound of the 95% confidence interval of age_adjusted_death_rate_per_100k, as NCI publishes it (rounded to 0.1).","valid_values":null,"example":31.6,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"Suppressed by NCI (State Cancer Profiles shows '*'): fewer than 16 deaths were recorded over 2020-2024 in this area, sex and race group. Never a zero, and never estimated or filled in here.","key_metric_grain_contributor":false,"metric_component":null},{"name":"avg_annual_deaths","type":"integer","role":"metric","nullable":true,"label":"Average Annual Deaths","short_description":"","description":"Average number of deaths per year from the cancer site over 2020-2024 (the five-year total divided by five, rounded to a whole number), as NCI publishes it: not a single year's deaths and not the five-year total. A shown 3 can mean 16 or more deaths over the five years. The deaths behind the rate, but not its numerator in the arithmetic sense: the rate is age-adjusted. Adds across counties or race groups only where none is suppressed; never across cancer sites.","valid_values":null,"example":3978,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by NCI (State Cancer Profiles shows '3 or fewer'): fewer than 16 deaths over 2020-2024 in this area, sex and race group. Never a zero; never backed out of a total.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"age_adjusted_death_rate_per_100k","numeric_filter_columns":["age_adjusted_death_rate_per_100k","age_adjusted_death_rate_per_100k_ci_lower","age_adjusted_death_rate_per_100k_ci_upper","avg_annual_deaths"],"usage":"Star-schema fact table at state and county grain, one pooled window (2020-2024, year 2024). Join the counties dimension on county_fips (NULL on the statewide row); tract_geoid is always NULL. Pin demographic, sex and cancer_site to 'all' for the overall cancer death rate. For breast_female, cervix, ovary, uterus pin sex='female', for prostate sex='male': they have no 'all' row. Pick one cancer_site: sites do not add up (only 'all' covers every cancer death). Age-adjusted rates never add or average across rows, and no population is published, so a combined rate for several counties or groups cannot be computed from this table: use the statewide row for Georgia, and compare places or groups by their own rates and 95% confidence intervals. avg_annual_deaths adds across counties or race groups only where none is NULL (suppressed). Read directly with DuckDB over Parquet.","limitations":"One pooled period, not an annual series: every figure covers Georgia residents' cancer deaths in 2020-2024 together (year 2024 labels the window; rates and counts are five-year averages). State Cancer Profiles serves only its latest window, and the next (2021-2025) shares four of its five years with this one, so never read two windows as year-to-year change. NCI withholds the rate, its 95% confidence interval and the count wherever fewer than 16 deaths were recorded over the five years in the area, sex and race group: NULL here, never estimated or backed out of a total (90% of county rows and every county row for non-Hispanic American Indian/Alaska Native (native_american) residents). Deaths come from the National Center for Health Statistics' national death file (National Vital Statistics System public-use file), by the decedent's county of residence and underlying cause of death; NCI computes the rates with SEER*Stat, age-adjusted to the 2000 U.S. standard population in 20 age groups (under 1, 1-4, 5-9, ..., 85-89, 90 and over), over NCI's modified Census population estimates. They cover the same deaths as Georgia DPH's OASIS death figures (the state's own vital records, published as annual counts and rates with OASIS's own population estimates and cause groupings), so the two do not match exactly; OASIS gives single years, this table cancer sites by race and sex in every county. The childhood groups are rates per 100,000 children under 15 (childhood_under_15) or under 20 (childhood_under_20), not per 100,000 residents of all ages, and their deaths are also counted under the named sites they belong to (a child's leukemia death is in leukemia too). breast_female, cervix, ovary, uterus are published for females only and prostate for males only, as rates per 100,000 women or men (no sex='all' row). Race groups: white, black, native_american and asian_pacific_islander (one combined group) are non-Hispanic; hispanic is any race; 'all' also counts deaths of unknown Hispanic origin, so the five groups' counts can add to slightly less than 'all'. avg_annual_deaths is the five-year total divided by five and rounded: a shown 3 can mean 16 or more deaths over the five years. Rates are rounded to 0.1 per 100,000. Not served: NCI's recent 5-year trend (average annual percent change) and its direction, the CI*Rank ranks, the Healthy People 2030 objective flag, the county rural-urban class and the national row. For trends use health/oasis/deaths_by_cause_detailed (Georgia DPH OASIS): annual county deaths and age-adjusted death rates for 2000-2025, for all cancers and 17 of the 21 sites here (not childhood_under_15, childhood_under_20, non_hodgkin_lymphoma or thyroid). tract_geoid is always NULL.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2024],"schema_hash":"cd18ac4b2138346643e370618874963fb03a798bea70b26ad3c538f93452b28c","tags":["health","national cancer institute and centers for disease control and prevention, state cancer profiles: death rate report for georgia by county","cancer_mortality"],"granularity_description":"One row per year, county_fips, tract_geoid, demographic, sex, cancer_site (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), counties detail","query":"SELECT * FROM cancer_mortality WHERE year = 2024 LIMIT 100"},{"description":"Filter by sex = female","query":"SELECT * FROM cancer_mortality WHERE sex = 'female' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"scope":"global"},{"column":"tract_geoid","target_object":"tracts","target_columns":["tract_geoid"],"attribute_columns_added":["tract_name"],"scope":"global"},{"column":"demographic","target_object":"demographics","target_columns":["demographic"],"attribute_columns_added":["demographic_label","demographic_category"],"scope":"global"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["counties","states"],"default":"counties"},{"param":"county_fips","kind":"foreign_key","column":"county_fips","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"tract_geoid","kind":"foreign_key","column":"tract_geoid","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"demographic","kind":"foreign_key","column":"demographic","type":"string","multi_value":true,"enum_enforced":true,"values":["all","white","black","hispanic","asian_pacific_islander","native_american"]},{"param":"sex","kind":"categorical","column":"sex","type":"string","multi_value":true,"enum_enforced":true,"values":["all","male","female"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"cancer_site","kind":"categorical","column":"cancer_site","type":"string","multi_value":true,"enum_enforced":true,"values":["all","bladder","brain_and_other_nervous_system","breast_female","cervix","childhood_under_15","childhood_under_20","colon_and_rectum","esophagus","kidney_and_renal_pelvis","leukemia","liver_and_bile_duct","lung_and_bronchus","melanoma_of_the_skin","non_hodgkin_lymphoma","oral_cavity_and_pharynx","ovary","pancreas","prostate","stomach","thyroid","uterus"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"demographic_category","kind":"dimension_attribute","dimension":"demographics","column":"demographic_category","type":"string","multi_value":true,"enum_enforced":true,"values":["aggregate","disability","economic_status","esol","foster_care","gender","grade","homeless_status","migrant_status","military","race","sped"]}],"filter_hints":[{"primary":"sex","dependent":"cancer_site","note":"cancer_site breast_female, cervix, ovary, uterus exist only for sex 'female' and prostate only for sex 'male' (no 'all' row): set sex to the site's own sex."}],"non_additive":[{"column":"cancer_site","reason":"'all' is every cancer death; the named sites are a selection that does not cover every cancer, the childhood groups (childhood_under_15, childhood_under_20) hold deaths also counted under the named sites (a child's leukemia death is in leukemia too), and childhood_under_20 contains childhood_under_15. A sum across sites is not a total: use 'all'.","metrics":["avg_annual_deaths"]}],"partitions":[],"value_implications":[],"year_meaning":"year is the last year of State Cancer Profiles' pooled window: 2024 = all cancer deaths of Georgia residents in 2020-2024 together. Each rate is the age-adjusted death rate over those five years and avg_annual_deaths the average deaths per year over them, so no figure is for 2024 alone. A later release (2021-2025) would share four of these five years.","pooled_rates":[],"series_breaks":[],"year_window":{"years":5,"overlapping":false},"pooled_min_count":null,"values_endpoint":"/api/v1/health/cancer_mortality/values"}