IDEAS home Printed from https://ideas.repec.org/p/nbr/nberwo/26770.html
   My bibliography  Save this paper

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. Fabian Eckert & Michael Peters, 2018. "Spatial Structural Change," 2018 Meeting Papers 98, Society for Economic Dynamics.
    2. 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.
    3. 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.
    4. 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.
    5. 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.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Daniela Vidart, 2021. "Human Capital, Female Employment, and Electricity: Evidence from the Early 20th Century United States," Working papers 2021-08, University of Connecticut, Department of Economics, revised Sep 2022.
    2. Kulkarni, Nirupama & Malmendier, Ulrike, 2022. "Homeownership segregation," Journal of Monetary Economics, Elsevier, vol. 129(C), pages 123-149.
    3. Fabian Eckert & Michael Peters, 2018. "Spatial Structural Change," 2018 Meeting Papers 98, Society for Economic Dynamics.
    4. Marguerite Obolensky & Marco Tabellini & Charles Taylor, 2024. "Homeward Bound: How Migrants Seek Out Familiar Climates," RF Berlin - CReAM Discussion Paper Series 2401, Rockwool Foundation Berlin (RF Berlin) - Centre for Research and Analysis of Migration (CReAM).
    5. Hanlon, W.Walker & Heblich, Stephan, 2022. "History and urban economics," Regional Science and Urban Economics, Elsevier, vol. 94(C).
    6. Mathias Bühler & Andrew Dickens & Andrew C. Dickens, 2024. "From Couch to Poll: Media Content and the Value of Local Information," CESifo Working Paper Series 10959, CESifo.
    7. Bühler Mathias & Andrew Dickens, 2024. "From Couch to Poll: Media Content and The Value of Local Information," Rationality and Competition Discussion Paper Series 496, CRC TRR 190 Rationality and Competition.
    8. Sezer, Ayse Hazal, 2023. "Convicts and Comrades : Coerced Labor’s Impact on Early Labor Unions," Other publications TiSEM 98f91e6a-8e47-4c1f-bc84-a, Tilburg University, School of Economics and Management.
    9. Lan Dinh, 2022. "Has toughness of local competition declined?," Working Papers 22-13, Center for Economic Studies, U.S. Census Bureau.
    10. Obolensky, Marguerite & Tabellini, Marco & Taylor, Charles A., 2024. "Homeward Bound: How Migrants Seek Out Familiar Climates," IZA Discussion Papers 16710, Institute of Labor Economics (IZA).

    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. 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.
    2. ADACHI Daisuke & KAWAGUCHI Daiji & SAITO Yukiko, 2020. "Robots and Employment: Evidence from Japan, 1978-2017," Discussion papers 20051, Research Institute of Economy, Trade and Industry (RIETI).
    3. Stuhler, Jan & Jaeger, David & Ruist, Joakim, 2018. "Shift-Share Instruments and the Impact of Immigration," CEPR Discussion Papers 12701, C.E.P.R. Discussion Papers.
    4. ADACHI Daisuke & FUKAI Taiyo & KAWAGUCHI Daiji & SAITO Yukiko, 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. Greg Howard & Carl Liebersohn, 2019. "What Explains U.S. House Prices? Regional Income Divergence," 2019 Meeting Papers 1054, Society for Economic Dynamics.
    7. Christian Dippel & Robert Gold & Stephan Heblich & Rodrigo Pinto, 2017. "Instrumental Variables and Causal Mechanisms: Unpacking the Effect of Trade on Workers and Voters," CESifo Working Paper Series 6816, CESifo.
    8. Lo Bello,Salvatore & Sanchez Puerta,Maria Laura & Winkler,Hernan Jorge, 2019. "From Ghana to America : The Skill Content of Jobs and Economic Development," Policy Research Working Paper Series 8758, The World Bank.
    9. 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.
    10. Lael Brainard, 2017. "Why Persistent Employment Disparities Matter for the Economy's Health : a speech at \"Disparities in the Labor Market: What Are We Missing?\" a research conference sponsored by the Board of ," Speech 970, Board of Governors of the Federal Reserve System (U.S.).
    11. Dekle, Robert, 2020. "Robots and industrial labor: Evidence from Japan," Journal of the Japanese and International Economies, Elsevier, vol. 58(C).
    12. Katharine G. Abraham & Melissa S. Kearney, 2020. "Explaining the Decline in the US Employment-to-Population Ratio: A Review of the Evidence," Journal of Economic Literature, American Economic Association, vol. 58(3), pages 585-643, September.
    13. Gregory, Terry & Salomons, Anna & Zierahn, Ulrich, 2016. "Racing With or Against the Machine? Evidence from Europe," VfS Annual Conference 2016 (Augsburg): Demographic Change 145843, Verein für Socialpolitik / German Economic Association.
    14. 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.
    15. 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.
    16. Gallipoli, Giovanni & Makridis, Christos A., 2018. "Structural transformation and the rise of information technology," Journal of Monetary Economics, Elsevier, vol. 97(C), pages 91-110.
    17. Muendler, Marc-Andreas, 2017. "Trade, technology, and prosperity: An account of evidence from a labor-market perspective," WTO Staff Working Papers ERSD-2017-15, World Trade Organization (WTO), Economic Research and Statistics Division.
    18. Stefano Federico & Fadi Hassan & Veronica Rappoport, 2020. "Trade shocks and credit reallocation," Temi di discussione (Economic working papers) 1289, Bank of Italy, Economic Research and International Relations Area.
    19. Daron Acemoglu & Pascual Restrepo, 2018. "Artificial Intelligence, Automation, and Work," NBER Chapters, in: The Economics of Artificial Intelligence: An Agenda, pages 197-236, National Bureau of Economic Research, Inc.
    20. Katharina Candel-Haug & Alexander Cuntz & Oliver Falck, 2018. "Immigrants' Contribution to Innovativeness: Evidence from a Non-Selective Immigration Country," CESifo Working Paper Series 7409, CESifo.

    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.