GEOGRAPHICAL CROSSWALKS

Crosswalk files for US counties across changing boundary definitions, 1790–present.

Eckert · Gvirtz · Liang · Peters

A Method to Construct Geographical Crosswalks with an Application to US Counties since 1790 · NBER #26770

Empirical researchers often have to map data provided for a “reporting” spatial unit, say, counties in 1900, to a “reference” one, say, counties in 2010. We discuss a general method to create such crosswalks: computing the share of the area of each reporting unit nested in a given reference unit. Using these shares, data can be re-aggregated from the reporting to the reference units. We apply the method to construct a crosswalk for mapping US county-level data from 1790 to 2010 to present-day county or commuting zone delineations. We then extend the method by computing the same shares using additional geographic information on livable terrain and historical data on the size and location of towns, which inform the distribution of population within counties in each decade. We also provide the code to generate other crosswalks given maps of reporting and reference units.

Each file gives three weights: by area, by livable area, and by population. The files come straight from the GitHub repository, so they are always the latest version.

Fabian Eckert, Andrés Gvirtz, Jack Liang, and Michael Peters. “A Method to Construct Geographical Crosswalks with an Application to US Counties since 1790.” Working paper, November 2026. An earlier version appeared as NBER Working Paper #26770, 2020.