economy_poverty_county_year
Census SAIPE official county poverty, 2019-2023. child_poverty_rate (ages 0-17) is the CHR "Children in Poverty" Select Measure, surfaced as a plain variable; overall poverty rate and median household income come from the same model. Tier B (model-based estimate).
overview
~3,140 counties x 5 years (2019-2023).
current vintage — 2023
history — Yes — 1989–2023 (this table loads 2019–2023)
source & licensing
fields
| name | type | definition |
|---|---|---|
| _ingested_at | timestamp | Timestamp when this record was written to BigQuery.Pipeline metadata field. |
| _ingestor_version | string | Version of the ingestor script that produced this record.Pipeline metadata field. |
| _reliability_tier | string | Data quality tier (A/B/C) assigned at ingestion.Pipeline metadata field. |
| _source_dataset_id | string | Internal dataset identifier linking to meta.datasets.Pipeline metadata field. |
| child_poverty_count | int64 · count | SAIPE-modeled number of related children ages 0–17 living in poverty in the county-year (SAEPOV0_17_PT). Higher values indicate more children in poverty. |
| child_poverty_coverage | string | Coverage flag for child_poverty_rate: SUPPORTED when a source value is present, UNSUPPORTED when the source value is missing. Values are never imputed. |
| child_poverty_rate | float64 · percent (0–100) | SAIPE-modeled percent of related children ages 0–17 living in poverty (SAEPOVRT0_17_PT); this is the County Health Rankings "Children in Poverty" measure surfaced as a plain county-year variable. Higher values indicate greater child poverty. |
| country_id | string | ISO alpha-2 country code (always 'US' for domestic tables). |
| county_idkey | string | 5-character FIPS code identifying the county.Part of primary key. Joins dim.counties on county_id. |
| county_name | string | Human-readable county name corresponding to county_id. |
| geo_basis | string | Geography provenance flag: 'source' for rows at SAIPE's native canonical geography; 'crosswalk_estimate' for Connecticut (2019-2021) and Alaska Valdez-Cordova (2019) legacy-geography rows reallocated to modern successors via the population-weighted legacy-county crosswalk (us_dimension.crosswalk_legacy_county). |
| median_household_income | int64 · dollars (nominal) | SAIPE-modeled median household income for the county-year (SAEMHI_PT). Higher values indicate greater household income. |
| poverty_rate_all_ages | float64 · percent (0–100) | SAIPE-modeled percent of people of all ages living below the federal poverty line in the county-year (SAEPOVRTALL_PT). Higher values indicate greater poverty. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| yearkey | int64 | Reference year of the observation.Part of primary key. |
joins
how to use this table
SAIPE child poverty rate = modeled percent of related children ages 0-17 in poverty. Carried through as published (percent). Median household income is the modeled SAIPE estimate. No aggregation or weighting applied.
Sub-county geographies, single-year change detection in very small counties (model smoothing), or as a direct count (these are modeled estimates).
Connecticut and the Alaska Valdez-Cordova split span a county-equivalent geography change. SAIPE's 2019-2021 CT rows use the legacy 8 counties (09001-09015) and its 2019 AK row uses Valdez-Cordova (02261); none map 1:1 into the current planning-region / successor-borough geography. Rather than drop them, these rows are reallocated to the modern successors via us_dimension.crosswalk_legacy_county (exact 2020 town-population weights — rates population-weighted, counts split by population share) and flagged geo_basis='crosswalk_estimate'. All other rows are geo_basis='source'. 2022+ CT and 2020+ AK are reported natively by SAIPE and pass through unchanged.