IDEAS home Printed from https://ideas.repec.org/p/nbr/nberwo/26770.html

A Method to Construct Geographical Crosswalks with an Application to US Counties since 1790

Author

Listed:
  • Fabian Eckert
  • Andrés Gvirtz
  • Jack Liang
  • Michael Peters

Abstract

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 US county-level data since 1790 to present-day counties or commuting zones. We also provide the code to generate other crosswalks given maps of reporting and reference units.

Suggested Citation

  • Fabian Eckert & Andrés Gvirtz & Jack Liang & Michael Peters, 2020. "A Method to Construct Geographical Crosswalks with an Application to US Counties since 1790," NBER Working Papers 26770, National Bureau of Economic Research, Inc.
    • Handle: RePEc:nbr:nberwo:26770
    Note: DAE DEV EFG ITI
    as

    Download full text from publisher

    File URL: http://www.nber.org/papers/w26770.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. David H. Autor & David Dorn & Gordon H. Hanson, 2013. "The China Syndrome: Local Labor Market Effects of Import Competition in the United States," American Economic Review, American Economic Association, vol. 103(6), pages 2121-2168, October.
    2. Daron Acemoglu & Pascual Restrepo, 2017. "Robots and Jobs: Evidence from US Labor Markets," Boston University - Department of Economics - Working Papers Series dp-297, Boston University - Department of Economics.
    3. Tolbert, Charles M. & Sizer, Molly, 1996. "U.S. Commuting Zones and Labor Market Areas: A 1990 Update," Staff Reports 278812, United States Department of Agriculture, Economic Research Service.
    4. Fabian Eckert & Michael Peters, 2018. "Spatial Structural Change," 2018 Meeting Papers 98, Society for Economic Dynamics.
    5. Daron Acemoglu & Pascual Restrepo, 2020. "Robots and Jobs: Evidence from US Labor Markets," Journal of Political Economy, University of Chicago Press, vol. 128(6), pages 2188-2244.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. David A. Jaeger & Joakim Ruist & Jan Stuhler, 2018. "Shift-Share Instruments and the Impact of Immigration," Working Papers 2018-007, Human Capital and Economic Opportunity Working Group.
    2. Daisuke Adachi & Daiji Kawaguchi & Yukiko U. Saito, 2024. "Robots and Employment: Evidence from Japan, 1978–2017," Journal of Labor Economics, University of Chicago Press, vol. 42(2), pages 591-634.
    3. Rodrigo Adão & Costas Arkolakis & Federico Esposito, 2019. "General Equilibrium Effects in Space: Theory and Measurement," NBER Working Papers 25544, National Bureau of Economic Research, Inc.
    4. Daisuke ADACHI & Taiyo FUKAI & Daiji KAWAGUCHI & Yukiko SAITO, 2020. "Commuting Zones in Japan," Discussion papers 20021, Research Institute of Economy, Trade and Industry (RIETI).
    5. Rodrigo Ad'o & Costas Arkolakis & Federico Esp'sito, 2019. "Spatial Linkages, Global Shocks, and Local Labor Markets: Theory and Evidence," Cowles Foundation Discussion Papers 2163, Cowles Foundation for Research in Economics, Yale University.
    6. Andrea Salvatori & Seetha Menon & Wouter Zwysen, 2018. "The effect of computer use on job quality: Evidence from Europe," OECD Social, Employment and Migration Working Papers 200, OECD Publishing.
    7. Dekle, Robert, 2020. "Robots and industrial labor: Evidence from Japan," Journal of the Japanese and International Economies, Elsevier, vol. 58(C).
    8. Aina Gallego & Thomas Kurer & Nikolas Schöll, 2018. "Not so disruptive after all: How workplace digitalization affects political preferences," Economics Working Papers 1623, Department of Economics and Business, Universitat Pompeu Fabra.
    9. Gaetano Basso & Giovanni Peri & Ahmed S. Rahman, 2020. "Computerization and immigration: Theory and evidence from the United States," Canadian Journal of Economics/Revue canadienne d'économique, John Wiley & Sons, vol. 53(4), pages 1457-1494, November.
    10. Escaith, Hubert, 2026. "Global outsourcing and (de)industrialisation, 1995−2019 volume II: production, demand, and the dynamics of industrial change," MPRA Paper 128374, University Library of Munich, Germany.
    11. Fran Stewart & Minkyu Yeom & Alice Stewart, 2020. "STEM and Soft Occupational Competencies: Analyzing the Value of Strategic Regional Human Capital," Economic Development Quarterly, , vol. 34(4), pages 356-371, November.
    12. Kerwin Kofi Charles & Erik Hurst & Mariel Schwartz, 2019. "The Transformation of Manufacturing and the Decline in US Employment," NBER Macroeconomics Annual, University of Chicago Press, vol. 33(1), pages 307-372.
    13. Domini, Giacomo & Grazzi, Marco & Moschella, Daniele & Treibich, Tania, 2021. "Threats and opportunities in the digital era: Automation spikes and employment dynamics," Research Policy, Elsevier, vol. 50(7).
    14. Artuc,Erhan & Christiaensen,Luc & Winkler,Hernan Jorge, 2019. "Does Automation in Rich Countries Hurt Developing Ones? : Evidence from the U.S. and Mexico," Policy Research Working Paper Series 8741, The World Bank.
    15. Ljubica Nedelkoska & Frank Neffke, 2019. "Skill Mismatch and Skill Transferability: Review of Concepts and Measurements," Papers in Evolutionary Economic Geography (PEEG) 1921, Utrecht University, Department of Human Geography and Spatial Planning, Group Economic Geography, revised Jun 2019.
    16. David Autor & David Dorn & Gordon Hanson & Maggie R. Jones & Bradley Setzler, 2024. "Places versus People: The Ins and Outs of Labor Market Adjustment to Globalization," Working Papers 24-78, Center for Economic Studies, U.S. Census Bureau.
    17. Daniele Siena & Riccardo Zago, 2021. "Job Polarization and the Flattening of the Price Phillips Curve," Working papers 819, Banque de France.
    18. Chunyang Su & Lin Zhang, 2025. "Industrial robots, social networks, and the gig economy," The Annals of Regional Science, Springer;Western Regional Science Association, vol. 74(3), pages 1-26, September.
    19. Gold, Robert & Dippel, Christian & Heblich, Stephan & Pinto, Rodrigo, 2017. "Instrumental Variables and Causal Mechanisms: Unpacking the Effect of Trade on Workers and Voters," VfS Annual Conference 2017 (Vienna): Alternative Structures for Money and Banking 168152, Verein für Socialpolitik / German Economic Association.
    20. Anna M. Stansbury & Lawrence H. Summers, 2017. "Productivity and Pay: Is the link broken?," NBER Working Papers 24165, National Bureau of Economic Research, Inc.

    More about this item

    JEL classification:

    • A1 - General Economics and Teaching - - General Economics
    • N11 - Economic History - - Macroeconomics and Monetary Economics; Industrial Structure; Growth; Fluctuations - - - U.S.; Canada: Pre-1913

    NEP fields

    This paper has been announced in the following NEP Reports:

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:nbr:nberwo:26770. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: the person in charge (email available below). General contact details of provider: https://edirc.repec.org/data/nberrus.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.