tract_county_crosswalk
Census tract to county mapping. One row per census tract. county_id / state_id are the positional prefixes of the 11-char tract GEOID (STATE(2)+COUNTY(3)+TRACT(6)) from the Census 2023 Gazetteer national tracts file (same TIGER vintage as ACS 2019–2023 tract data). Use to aggregate tract-grain source data (e.g. ACS B03002 race counts) to county grain.
tier aTier A: positional prefix of the official tract GEOID.
overview
overview
85,396 rows — one per 2023 census tract.
current vintage — 2023
provenance
source & licensing
authority
U.S. Census Bureau
dataset
Census 2023 Gazetteer national tracts
license
Public domain (U.S. Federal Government work)
citation
U.S. Census Bureau, 2023 Gazetteer national census tracts file.
schema
fields
| name | type | definition |
|---|---|---|
| county_id | string | 5-character FIPS code identifying the county.Joins dim.counties on county_id. |
| name | string | Human-readable census tract label derived from the 6-digit tract code (e.g. 'Census Tract 201.01'). |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| tract_idkey | string | 11-character census tract FIPS code (GEOID), structured as STATE(2)+COUNTY(3)+TRACT(6). Primary key; one row per census tract from the Census 2023 Gazetteer national tracts file.Part of primary key. |
relationships
joins
primary key
tract_id
common joins
not provided
usage
how to use this table
method
county_id/state_id = STATE(2)+COUNTY(3) prefix of the 11-char tract GEOID.
do not use for
Tract vintages other than 2023 TIGER.
last updated · Jul 7, 2026