{"main_topic":"census","sub_topic":"cre","topic":"community_resilience","key":"census/cre/community_resilience","version":"1.0.0","year_min":2016,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","tracts"],"default_detail":"counties","path_template":"census/community_resilience/year={year}/{detail}.parquet","grain":["year","county_fips","district_code","tract_geoid"],"title":"Community Resilience Estimates (Census CRE)","summary":"Estimated share of residents with 0, 1-2 or 3+ social-vulnerability components, by county (2016-2024) and tract (2020-2024).","description":"The U.S. Census Bureau's Community Resilience Estimates (CRE) for Georgia: the estimated number and share of residents with zero, one or two, or three or more of ten components of social vulnerability - household and individual risk factors such as low income, disability, no health insurance, age 65 and over and no broadband - that make it harder to absorb and recover from a disaster or other shock. By county for every edition 2016-2024 and by census tract for 2020-2024. Model-based estimates (American Community Survey 1-year responses combined with population estimates in a small-area model) with 90 percent margins of error; the headline is the share with three or more components.","explorer":true,"search_aliases":{"en":["disaster vulnerability","social vulnerability","disaster resilience","disaster risk","vulnerable residents","at-risk residents","risk factors","recover from disasters","CRE"],"es":["vulnerabilidad social","vulnerabilidad ante desastres","resiliencia comunitaria","resiliencia ante desastres","riesgo de desastres","residentes vulnerables","factores de riesgo","recuperación ante desastres","CRE"]},"source":"U.S. Census Bureau, Community Resilience Estimates, editions 2016-2024 (county and tract files)","source_url":"https://www.census.gov/programs-surveys/community-resilience-estimates/data/datasets.html","endpoint":"/api/v1/census/community_resilience","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Edition year: the year the estimates describe, modeled from that year's American Community Survey 1-year responses and population estimates (the 2024 edition, released January 2026, uses 2024 ACS data). One edition per year, 2016-2024; each is a separately modeled release, not a revision of the others. Tract rows exist for 2020-2024 only.","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 (state 13 + county), from the source GEO_ID. Populated on county rows (every year); NULL on tract rows.","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":"district_code","type":"string","role":"fk_district","nullable":true,"label":"District Code","short_description":"","description":"Always NULL: the Community Resilience Estimates publish no school-district geography. Kept for the census 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":"tract_geoid","type":"string","role":"fk_tract","nullable":true,"label":"Tract GEOID","short_description":"","description":"11-digit 2020 census tract GEOID (FK to the tracts dimension), from the source GEO_ID. Populated on tract rows, which exist for 2020-2024 only (the 2016-2019 editions use 2010 tract boundaries and are served at county level only); NULL on county rows.","valid_values":null,"example":"13121001100","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_three_plus_components","type":"number","role":"metric","nullable":true,"label":"Share With 3+ Vulnerability Components","short_description":"Estimated share of residents with three or more social-vulnerability components.","description":"Estimated share of the universe population (num_population) with three or more of the ten CRE components of social vulnerability (0-1). A model-based estimate, served as published (PRED3_PE / 100; the source rounds to two decimals of a percent) and equal to num_three_plus_components / num_population within that rounding. NULL only where num_population is 0 (the published 0, or the 2021 edition's modeled rate, over no residents is set to NULL as known-bad). The headline measure: the Census Bureau's 'most socially vulnerable' group, least able to absorb and recover from a disaster or other shock.","valid_values":null,"example":0.189,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"num_population is 0 (the all-water and special land-use tracts with no in-universe residents): a share of nobody is undefined. The Census publishes 0 there (in the 2021 edition a modeled rate), which is not a 0 percent share, so it is not served.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_three_plus_components_moe","type":"number","role":"metric","nullable":true,"label":"Percent Three Plus Components Moe","short_description":"","description":"90 percent margin of error for pct_three_plus_components (0-1 scale), as published (PRED3_PM / 100). Equals num_three_plus_components_moe / num_population within rounding (2019 county rows: within 0.03 points). County margins for 2019, 2021 and 2022 come from an older Census variance method and run larger than in other editions; do not compare margins across those editions.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL exactly where pct_three_plus_components is NULL (num_population is 0).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_three_plus_components","type":"integer","role":"metric","nullable":true,"label":"People With 3+ Vulnerability Components","short_description":"","description":"Estimated number of people in the universe with three or more of the ten CRE components of social vulnerability (PRED3_E; a model-based estimate). Adds across tracts (a county's tracts sum exactly to its county row) and across counties; with the other two bands it sums exactly to num_population. 0 on tracts with no in-universe residents. The numerator of pct_three_plus_components.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"num_three_plus_components_moe","type":"number","role":"metric","nullable":true,"label":"Number Three Plus Components Moe","short_description":"","description":"90 percent margin of error for num_three_plus_components, as published (PRED3_M; to one decimal in the 2021 and 2022 editions, whole numbers otherwise). 0 on tracts with no in-universe residents. Margins never add across places.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_one_two_components","type":"number","role":"metric","nullable":true,"label":"Share With 1-2 Vulnerability Components","short_description":"","description":"Estimated share of the universe population (num_population) with one or two of the ten CRE components of social vulnerability (0-1). A model-based estimate, served as published (PRED12_PE / 100; the source rounds to two decimals of a percent) and equal to num_one_two_components / num_population within that rounding. NULL only where num_population is 0 (the published 0, or the 2021 edition's modeled rate, over no residents is set to NULL as known-bad).","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"num_population is 0 (the all-water and special land-use tracts with no in-universe residents): a share of nobody is undefined. The Census publishes 0 there (in the 2021 edition a modeled rate), which is not a 0 percent share, so it is not served.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_one_two_components_moe","type":"number","role":"metric","nullable":true,"label":"Percent One Two Components Moe","short_description":"","description":"90 percent margin of error for pct_one_two_components (0-1 scale), as published (PRED12_PM / 100). Equals num_one_two_components_moe / num_population within rounding (2019 county rows: within 0.03 points). County margins for 2019, 2021 and 2022 come from an older Census variance method and run larger than in other editions; do not compare margins across those editions.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL exactly where pct_one_two_components is NULL (num_population is 0).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_one_two_components","type":"integer","role":"metric","nullable":true,"label":"People With 1-2 Vulnerability Components","short_description":"","description":"Estimated number of people in the universe with one or two of the ten CRE components of social vulnerability (PRED12_E; a model-based estimate). Adds across tracts (a county's tracts sum exactly to its county row) and across counties; with the other two bands it sums exactly to num_population. 0 on tracts with no in-universe residents.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_one_two_components_moe","type":"number","role":"metric","nullable":true,"label":"Number One Two Components Moe","short_description":"","description":"90 percent margin of error for num_one_two_components, as published (PRED12_M; to one decimal in the 2021 and 2022 editions, whole numbers otherwise). 0 on tracts with no in-universe residents. Margins never add across places.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_zero_components","type":"number","role":"metric","nullable":true,"label":"Share With No Vulnerability Components","short_description":"","description":"Estimated share of the universe population (num_population) with none of the ten CRE components of social vulnerability (0-1). A model-based estimate, served as published (PRED0_PE / 100; the source rounds to two decimals of a percent) and equal to num_zero_components / num_population within that rounding. NULL only where num_population is 0 (the published 0, or the 2021 edition's modeled rate, over no residents is set to NULL as known-bad).","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"num_population is 0 (the all-water and special land-use tracts with no in-universe residents): a share of nobody is undefined. The Census publishes 0 there (in the 2021 edition a modeled rate), which is not a 0 percent share, so it is not served.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_zero_components_moe","type":"number","role":"metric","nullable":true,"label":"Percent Zero Components Moe","short_description":"","description":"90 percent margin of error for pct_zero_components (0-1 scale), as published (PRED0_PM / 100). Equals num_zero_components_moe / num_population within rounding (2019 county rows: within 0.03 points). County margins for 2019, 2021 and 2022 come from an older Census variance method and run larger than in other editions; do not compare margins across those editions.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL exactly where pct_zero_components is NULL (num_population is 0).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_zero_components","type":"integer","role":"metric","nullable":true,"label":"People With No Vulnerability Components","short_description":"","description":"Estimated number of people in the universe with none of the ten CRE components of social vulnerability (PRED0_E; a model-based estimate). Adds across tracts (a county's tracts sum exactly to its county row) and across counties; with the other two bands it sums exactly to num_population. 0 on tracts with no in-universe residents.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_zero_components_moe","type":"number","role":"metric","nullable":true,"label":"Number Zero Components Moe","short_description":"","description":"90 percent margin of error for num_zero_components, as published (PRED0_M; to one decimal in the 2021 and 2022 editions, whole numbers otherwise). 0 on tracts with no in-universe residents. Margins never add across places.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_population","type":"integer","role":"metric","nullable":true,"label":"Universe Population","short_description":"","description":"The CRE universe population (POPUNI): residents excluding people in adult correctional and juvenile facilities and college dormitories. The Census's own population estimate (decennial census base updated with the Population Estimates Program and treated as exact by the model), so no margin is published. The three band counts sum exactly to it; the denominator of every share. 0 on tracts with no in-universe residents (all-water and special land-use tracts).","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"denominator"}],"key_metric":"pct_three_plus_components","numeric_filter_columns":["pct_three_plus_components","pct_three_plus_components_moe","num_three_plus_components","num_three_plus_components_moe","pct_one_two_components","pct_one_two_components_moe","num_one_two_components","num_one_two_components_moe","pct_zero_components","pct_zero_components_moe","num_zero_components","num_zero_components_moe","num_population"],"usage":"Star-schema fact table at county (2016-2024) and census-tract (2020-2024) grain; there are no state or school-district rows. Join the counties dimension on county_fips and the tracts dimension on tract_geoid (2020 tract boundaries); district_code is always NULL. pct_three_plus_components is the headline: the estimated share of residents with three or more components of social vulnerability. Every figure is a model-based estimate - quote it with its margin of error (the matching _moe column, 90 percent confidence). The band counts add up to num_population and add across tracts and counties (a county's tracts sum exactly to its county row), but shares and margins never add: the estimated share for several places together is SUM(num_three_plus_components) / SUM(num_population), never an average of their shares, and no margin can be derived for a combination. Read directly with DuckDB over Parquet.","limitations":"These are MODEL-BASED ESTIMATES, not counts: the Census Bureau's Community Resilience Estimates (CRE) model one year's American Community Survey responses, so every figure has a 90 percent margin of error (the _moe columns). Each year is a separately modeled edition: compare years with care, and 2020 (pandemic-era survey data) with extra care. Tract rows exist only for 2020-2024 (2020 tract boundaries); the 2016-2019 editions are on 2010 tracts and are served for counties only. A change between years mixes real change, sampling error in each year's ACS sample and method change, so never treat a small change as a trend. The population base is the 2010 Census for 2016-2019 and the 2020 Census from 2020 on. The 2016-2018 and 2020 editions are a historical series first published in May 2026 with the 2024 edition's method; 2019 (released in 2021, the first edition after the experimental CRE of 2018 data was redesigned) and 2021-2023 are earlier releases. The Census urges particular caution with the 2020 edition: the pandemic disrupted 2020 ACS collection, its 1-year weights were experimental and its variance method was adapted, so compare 2020 with other years with extra care. County margins of error in 2019, 2021 and 2022 come from an older Census variance method and run much larger than in the other editions (median county margin for the 3+ count about 26-37 percent of the estimate, versus 18-22 percent), so margins are not comparable across those editions. Tract estimates are much less precise than county ones: the median tract margin for the 3+ count is 55-69 percent of the estimate, so many tract differences are within the margins. A component of social vulnerability is one of ten household or individual risk factors measured in the ACS (including a low income-to-poverty ratio, disability, no health insurance, age 65 and over, crowding, a communication barrier, employment and broadband access); the Census publishes only the 0 / 1-2 / 3+ groups, never the individual components or which ones apply. Universe (num_population): residents excluding people in adult correctional and juvenile facilities and college dormitories; nursing-home and military-barracks residents are included with components assumed by the Census (the 2019 file layout calls it total population). The universe is the Census's own population estimate, treated as exact, so it has no margin. Shares are served as published (two decimals of a percent, divided by 100) and equal count / num_population. Twelve tracts in each 2020-2024 edition (five all-water and seven special land-use tracts) have no in-universe residents: their counts and count margins are 0 and their shares and share margins NULL. There is no state or school-district row: a statewide count is the sum of the 159 county counts (exact, but with no margin of error).","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"657c579e7ddcc95ca3b45a557f4d29fd0a99cfb0eceed3a589fb22c44b55d00a","tags":["census","u.s. census bureau, community resilience estimates, editions 2016-2024","community_resilience"],"granularity_description":"One row per year, county_fips, district_code, tract_geoid (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), counties detail","query":"SELECT * FROM community_resilience WHERE year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"scope":"global"},{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"tract_geoid","target_object":"tracts","target_columns":["tract_geoid"],"attribute_columns_added":["tract_name"],"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","tracts"],"default":"counties"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"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":"district_type","kind":"dimension_attribute","dimension":"districts","column":"district_type","type":"string","multi_value":true,"enum_enforced":true,"values":["commission_charter","resa","standard","state_agency","state_charter","state_school","state_special"]}],"filter_hints":[],"non_additive":[],"partitions":[],"value_implications":[],"year_meaning":null,"pooled_rates":[],"series_breaks":[],"year_window":null,"pooled_min_count":null,"values_endpoint":"/api/v1/census/community_resilience/values"}