{"main_topic":"health","sub_topic":"cancer","topic":"cancer_incidence","key":"health/cancer/cancer_incidence","version":"1.0.0","year_min":2023,"year_max":2023,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","states"],"default_detail":"counties","path_template":"health/cancer_incidence/year={year}/{detail}.parquet","grain":["year","county_fips","tract_geoid","demographic","sex","cancer_site","stage"],"title":"Cancer Incidence","summary":"New cancer cases per 100,000 residents (age-adjusted) in each Georgia county by site, race, sex and stage, 2019-2023 average.","description":"New cancer cases in Georgia and each of its 159 counties, 2019-2023 pooled: the age-adjusted incidence rate per 100,000 with its 95% confidence interval, the average annual number of cases, and either the recent 5-year trend of the rate or the share of cases diagnosed at late stage, by cancer site (22 sites and all sites), race/ethnicity, sex and stage (all stages or late stage), from NCI and CDC's State Cancer Profiles (Georgia Comprehensive Cancer Registry data).","explorer":true,"search_aliases":{"en":["new cancer cases","cancer diagnoses","cancer rates","late stage cancer","breast cancer","lung cancer","prostate cancer","colon cancer","cancer registry","childhood cancer"],"es":["casos nuevos de cáncer","diagnósticos de cáncer","cáncer de mama","cáncer de pulmón","cáncer de próstata","cáncer de colon","cáncer en etapa tardía","registro de cáncer","cáncer infantil","tasas de cáncer"]},"source":"National Cancer Institute and Centers for Disease Control and Prevention, State Cancer Profiles: Incidence Rate Report for Georgia by County, 2019-2023 (CSV exports, one per cancer site, race/ethnicity, sex and stage); Georgia rows from the Georgia Comprehensive Cancer Registry, SEER November 2025 submission. Retrieved 2026-10-24","source_url":"https://statecancerprofiles.cancer.gov/incidencerates/index.php","endpoint":"/api/v1/health/cancer_incidence","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"End year of the pooled five-year window: 2023 = cancers diagnosed in 2019-2023. Every figure covers those five years together, not 2023 alone (see year_meaning).","valid_values":null,"example":2023,"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 FIPS code of the county of residence at diagnosis, as State Cancer Profiles lists it. NULL on the Georgia (state) row.","valid_values":null,"example":"13121","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"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 reports by county. Kept for the health domain's standard key shape.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"demographic","type":"string","role":"fk_demographic","nullable":false,"label":"Demographic","short_description":"Race/ethnicity: 'all', non-Hispanic white, black, American Indian/Alaska Native, Asian/Pacific Islander, or Hispanic.","description":"Race and ethnicity (FK to the demographics dimension), State Cancer Profiles' groups: 'all' is every race, Hispanic included; 'white', 'black', 'native_american' (American Indian/Alaska Native) and 'asian_pacific_islander' (Asian and Pacific Islander as one group: the source never splits them) are non-Hispanic; 'hispanic' is Hispanic of any race. The five groups are mutually exclusive but do not add up to 'all': people of other or unknown race are only in 'all' (statewide, all sites, the groups' counts are 99.3% of all). Crossed with sex, which is its own column.","valid_values":["all","asian_pacific_islander","black","hispanic","native_american","white"],"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' (both sexes), 'male' or 'female'.","description":"Sex: 'all' (both sexes), 'male', 'female', crossed with every race group. Sex-specific sites have only their own sex and no 'all' row: breast_female, breast_female_in_situ, cervix, ovary, uterus are 'female' (rates per 100,000 women), prostate is 'male' (per 100,000 men). Male + female average annual counts equal 'all' within 1 (rounding); age-adjusted rates do not combine that way.","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; 'all' is all cancer sites.","description":"Primary cancer site, State Cancer Profiles' list: 'all' = all cancer sites (the total); bladder (invasive and in situ); brain_and_other_nervous_system; breast_female (invasive, women); breast_female_in_situ (in situ only, women; not in 'all'); cervix; childhood_under_15 and childhood_under_20 (all sites, children under 15 / under 20, rates age-adjusted over those ages); 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). Invasive cancers only except bladder and breast in situ. The sites overlap ('all' contains the named sites; the childhood rows hold cases also counted under named sites): never add across sites. childhood_under_20 has trend figures only (its rate and count are withheld; see the rate's description).","valid_values":["all","bladder","brain_and_other_nervous_system","breast_female","breast_female_in_situ","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":"stage","type":"string","role":"categorical","nullable":false,"label":"Stage","short_description":"Stage at diagnosis: 'all' stages or 'late' only.","description":"Stage at diagnosis: 'all' = every stage (including unknown); 'late' = late stage only (regional or distant spread), a subset of 'all', published for the 18 staged sites (not all, breast_female_in_situ, childhood_under_15, childhood_under_20, leukemia). Staging is SEER's Combined Summary Stage / NPCR's Merged Summary Stage (publisher footnote). Never add 'late' to 'all'.","valid_values":["all","late"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"age_adjusted_incidence_rate_per_100k","type":"number","role":"metric","nullable":true,"label":"Age-Adjusted Incidence Rate per 100,000","short_description":"New cancer cases per 100,000 people a year, age-adjusted, 2019-2023 average.","description":"New cancers diagnosed per 100,000 people per year, age-adjusted to the 2000 U.S. standard population, over 2019-2023, as State Cancer Profiles publishes it (Georgia Comprehensive Cancer Registry data, SEER November 2025 submission). The population is the group's: women for the female-only sites, men for prostate, children of the ages for the childhood sites. On stage = 'late' rows it is the rate of late-stage diagnoses. In small groups one or two cases move it a lot: read it with age_adjusted_incidence_rate_per_100k_ci_lower and age_adjusted_incidence_rate_per_100k_ci_upper. Never average it across places. §4b mask: on every childhood_under_20 row (code 515: 2,880 Georgia and county rows, 110 of them with published figures) this column is NULL. In all of them the published rate, CI and average annual count equal the childhood_under_15 (516) row's, while the US rows differ (under 15: 16.4 per 100,000 and 9,945 cases a year; under 20: 18.4 and 15,199). Under-20 counts cannot equal under-15 counts, and the Georgia figures (15.9 per 100,000, 329 cases a year) imply about 2.1 million children, Georgia's under-15 population, not its roughly 2.8 million under 20, so the 515 figures are a copy of 516's.","valid_values":null,"example":54.4,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"Suppressed by State Cancer Profiles: fewer than 16 cases in the area-race-sex cell over 2019-2023 (the count is shown as '3 or fewer'). The cell can hold zero cases: no zero is ever published. NULL on every childhood_under_20 row: the publisher's under-20 Georgia and county figures repeat the under-15 figures (masked, see the description).","key_metric_grain_contributor":false,"metric_component":null},{"name":"age_adjusted_incidence_rate_per_100k_ci_lower","type":"number","role":"metric","nullable":true,"label":"Rate Lower 95% CI","short_description":"","description":"Lower bound of the 95% confidence interval of age_adjusted_incidence_rate_per_100k, as published (intervals are asymmetric, so it is not the rate minus a margin). §4b mask: on every childhood_under_20 row (code 515: 2,880 Georgia and county rows, 110 of them with published figures) this column is NULL. In all of them the published rate, CI and average annual count equal the childhood_under_15 (516) row's, while the US rows differ (under 15: 16.4 per 100,000 and 9,945 cases a year; under 20: 18.4 and 15,199). Under-20 counts cannot equal under-15 counts, and the Georgia figures (15.9 per 100,000, 329 cases a year) imply about 2.1 million children, Georgia's under-15 population, not its roughly 2.8 million under 20, so the 515 figures are a copy of 516's.","valid_values":null,"example":null,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"Suppressed by State Cancer Profiles: fewer than 16 cases in the area-race-sex cell over 2019-2023 (the count is shown as '3 or fewer'). The cell can hold zero cases: no zero is ever published. NULL on every childhood_under_20 row: the publisher's under-20 Georgia and county figures repeat the under-15 figures (masked, see the description).","key_metric_grain_contributor":false,"metric_component":null},{"name":"age_adjusted_incidence_rate_per_100k_ci_upper","type":"number","role":"metric","nullable":true,"label":"Rate Upper 95% CI","short_description":"","description":"Upper bound of the 95% confidence interval of age_adjusted_incidence_rate_per_100k, as published. §4b mask: on every childhood_under_20 row (code 515: 2,880 Georgia and county rows, 110 of them with published figures) this column is NULL. In all of them the published rate, CI and average annual count equal the childhood_under_15 (516) row's, while the US rows differ (under 15: 16.4 per 100,000 and 9,945 cases a year; under 20: 18.4 and 15,199). Under-20 counts cannot equal under-15 counts, and the Georgia figures (15.9 per 100,000, 329 cases a year) imply about 2.1 million children, Georgia's under-15 population, not its roughly 2.8 million under 20, so the 515 figures are a copy of 516's.","valid_values":null,"example":null,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"Suppressed by State Cancer Profiles: fewer than 16 cases in the area-race-sex cell over 2019-2023 (the count is shown as '3 or fewer'). The cell can hold zero cases: no zero is ever published. NULL on every childhood_under_20 row: the publisher's under-20 Georgia and county figures repeat the under-15 figures (masked, see the description).","key_metric_grain_contributor":false,"metric_component":null},{"name":"avg_annual_cases","type":"integer","role":"metric","nullable":true,"label":"Average Annual Cases","short_description":"","description":"Average number of new cases per year over 2019-2023 (the five-year total / 5, rounded by the publisher), as published; at least 3 when shown (a shown 3 means 16 or more cases in five years). On stage = 'late' rows, late-stage cases. Not a component of age_adjusted_incidence_rate_per_100k (an age-adjusted rate; the population is not published). Adds across counties and sexes, never across sites or stages. §4b mask: on every childhood_under_20 row (code 515: 2,880 Georgia and county rows, 110 of them with published figures) this column is NULL. In all of them the published rate, CI and average annual count equal the childhood_under_15 (516) row's, while the US rows differ (under 15: 16.4 per 100,000 and 9,945 cases a year; under 20: 18.4 and 15,199). Under-20 counts cannot equal under-15 counts, and the Georgia figures (15.9 per 100,000, 329 cases a year) imply about 2.1 million children, Georgia's under-15 population, not its roughly 2.8 million under 20, so the 515 figures are a copy of 516's.","valid_values":null,"example":6916,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by State Cancer Profiles: fewer than 16 cases in the area-race-sex cell over 2019-2023 (the count is shown as '3 or fewer'). The cell can hold zero cases: no zero is ever published. NULL on every childhood_under_20 row: the publisher's under-20 Georgia and county figures repeat the under-15 figures (masked, see the description).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_of_all_stage_cases","type":"number","role":"metric","nullable":true,"label":"Share of Cases Diagnosed at Late Stage","short_description":"","description":"Share of all the site's cases (every stage) that were diagnosed at late stage (regional or distant spread), 0-1: the late-stage row's cases over the stage = 'all' row's for the same place, group and site, as State Cancer Profiles publishes it (Percent of Cases with Late Stage / 100). On stage = 'late' rows only. Equals the late-stage avg_annual_cases / the all-stage avg_annual_cases within the counts' rounding.","valid_values":null,"example":0.67,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Not applicable on stage = 'all' rows (always NULL there). On 'late' rows, suppressed with the late-stage rate (fewer than 16 late-stage cases in five years).","key_metric_grain_contributor":false,"metric_component":null},{"name":"recent_trend_aapc","type":"number","role":"metric","nullable":true,"label":"Recent 5-Year Trend (Annual Percent Change)","short_description":"","description":"Recent 5-year trend of the annual incidence rate: the average annual percent change (AAPC) from NCI's Joinpoint regression, as a signed fraction (the published percent / 100: -0.029 = falling 2.9% a year). State Cancer Profiles calls a trend rising when the 95% CI (recent_trend_aapc_ci_lower, recent_trend_aapc_ci_upper) is above 0, falling when below 0, and stable otherwise; that label is not stored because it follows exactly from the CI (checked on every row). Trends use a different malignancy standard than the rates and, for some counties, a different span of years (publisher footnotes). On stage = 'all' rows only. No unit: a signed annual percent change has none in the platform vocabulary. For childhood_under_20 the trend is kept as published (it differs from the under-15 trend), though the rate is withheld.","valid_values":null,"example":-0.029,"unit":null,"value_min":null,"value_max":null,"null_meaning":"Always NULL on stage = 'late' rows (the late-stage report has no trend). Otherwise withheld by the publisher: with the rate (suppressed cell), or where the rate is shown but the trend is not (too few cases for a stable trend).","key_metric_grain_contributor":false,"metric_component":null},{"name":"recent_trend_aapc_ci_lower","type":"number","role":"metric","nullable":true,"label":"Trend Lower 95% CI","short_description":"","description":"Lower bound of the 95% confidence interval of recent_trend_aapc, as a signed fraction (published percent / 100). Above 0 = rising.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":"NULL with recent_trend_aapc.","key_metric_grain_contributor":false,"metric_component":null},{"name":"recent_trend_aapc_ci_upper","type":"number","role":"metric","nullable":true,"label":"Trend Upper 95% CI","short_description":"","description":"Upper bound of the 95% confidence interval of recent_trend_aapc, as a signed fraction (published percent / 100). Below 0 = falling.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":"NULL with recent_trend_aapc.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"age_adjusted_incidence_rate_per_100k","numeric_filter_columns":["age_adjusted_incidence_rate_per_100k","age_adjusted_incidence_rate_per_100k_ci_lower","age_adjusted_incidence_rate_per_100k_ci_upper","avg_annual_cases","pct_of_all_stage_cases","recent_trend_aapc","recent_trend_aapc_ci_lower","recent_trend_aapc_ci_upper"],"usage":"Star-schema fact table at state and county grain. Join the counties dimension on county_fips (NULL on the Georgia row) and the demographics dimension on demographic; tract_geoid is always NULL. Pin every grain column: demographic = 'all', sex = 'all', cancer_site = 'all' and stage = 'all' are the totals. Sex-specific sites have no sex = 'all' row: use 'female' for breast_female, breast_female_in_situ, cervix, ovary, uterus and 'male' for prostate. stage = 'late' exists for 18 sites; never add it to 'all', and read pct_of_all_stage_cases on the late row for the late-stage share. Never sum or average rates across places, sites, races or sexes: for Georgia read the state row. avg_annual_cases is the publisher's rounded average per year over 2019-2023: 5 times it only approximates the window's total (a published 3 stands for 16 or more cases), and the exact five-year count is not in this table. Compare two places with the CI bounds (age_adjusted_incidence_rate_per_100k_ci_lower, age_adjusted_incidence_rate_per_100k_ci_upper): overlapping intervals are no clear difference. recent_trend_aapc is a fraction (-0.029 = falling 2.9% a year); its CI decides rising (above 0), falling (below 0) or stable. Read directly with DuckDB over Parquet.","limitations":"One pooled period, not an annual series: every row describes cancers diagnosed in 2019-2023 (year 2023 is the window's end year), the only county window State Cancer Profiles serves. The next release's window will overlap this one in four of five years, so two releases are never year-over-year change; the published 5-year trend (recent_trend_aapc) is the table's only trend information. Rates are age-adjusted to the 2000 U.S. standard population and use the population of the group (per 100,000 women for breast, cervix, ovary and uterus, per 100,000 men for prostate, children for the childhood sites). Rates cover invasive cancers only, except bladder (invasive and in situ) and breast_female_in_situ (in situ only). Counts under 16 cases in five years are suppressed (rate, CI, count and trend NULL; about 85% of county cells across all combinations, most race-specific cells for rare sites and every American Indian/Alaska Native county cell except a few for all sites), and a suppressed cell can be zero, so county rows do not add up to the state row. Small published counts carry wide confidence intervals: compare places with them. The population behind each rate is not published, so county rates cannot be pooled into a regional rate here; the state row is Georgia's published rate. Race groups are non-Hispanic white, black, American Indian/Alaska Native and Asian/Pacific Islander (combined, never split), plus Hispanic of any race; they do not add up to 'all' (other and unknown races are only in 'all'). Trends come from NCI's Joinpoint on a different malignancy standard than the rates, and for some counties a different span of years (publisher footnotes). The childhood under 20 rates and counts are withheld here (childhood_under_20 NULL): the publisher's figures for it repeat the under-15 ones. The U.S. comparator row, the CI*Rank county ranks and the rural-urban class are not in this table. tract_geoid is always NULL.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2023],"schema_hash":"a5d6e0dc244871457abfe02453b01f73718cc7b210004273dac77fbb75d22c8c","tags":["health","national cancer institute and centers for disease control and prevention, state cancer profiles: incidence rate report for georgia by county, 2019-2023","cancer_incidence"],"granularity_description":"One row per year, county_fips, tract_geoid, demographic, sex, cancer_site, stage (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2023), counties detail","query":"SELECT * FROM cancer_incidence WHERE year = 2023 LIMIT 100"},{"description":"Filter by sex = female","query":"SELECT * FROM cancer_incidence WHERE sex = 'female' AND year = 2023 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","asian_pacific_islander","black","hispanic","native_american","white"]},{"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","breast_female_in_situ","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":"stage","kind":"categorical","column":"stage","type":"string","multi_value":true,"enum_enforced":true,"values":["all","late"],"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":"cancer_site","dependent":"sex","note":"Sex-specific sites have no sex 'all' row: breast_female, breast_female_in_situ, cervix, ovary, uterus are published for 'female' only and prostate for 'male' only; every other site has 'all', 'male' and 'female'."},{"primary":"cancer_site","dependent":"stage","note":"stage 'late' exists only for the 18 staged sites; all, breast_female_in_situ, childhood_under_15, childhood_under_20, leukemia have stage 'all' only."}],"non_additive":[{"column":"cancer_site","reason":"The sites overlap: 'all' (all cancer sites) contains the named invasive sites, the childhood sites hold children's cases that are also counted under their named sites (leukemia, brain and other nervous system, ...), and childhood_under_20 contains childhood_under_15; breast_female_in_situ counts in situ cases outside the invasive sites. A sum across sites is not a total: 'all' is."},{"column":"stage","reason":"'late' (regional and distant) is a subset of 'all' (every stage), so adding the two counts late-stage cases twice; 'all' is the total."}],"partitions":[],"value_implications":[],"year_meaning":"year 2023 labels the pooled five-year diagnosis window 2019-2023: every figure describes cancers diagnosed over those five years (the rate per 100,000 person-years, age-adjusted; the count an average per year), not 2023 alone. The trend columns describe how the annual rate changed over the most recent five data years. State Cancer Profiles serves only the latest window for counties; its next release (2020-2024) will share four of these five years, so two releases are never annual change.","pooled_rates":[],"series_breaks":[],"year_window":{"years":5,"overlapping":false},"pooled_min_count":null,"values_endpoint":"/api/v1/health/cancer_incidence/values"}