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, 2024. "Human Capital, Female Employment, and Electricity: Evidence from the Early 20th-Century United States," The Review of Economic Studies, Review of Economic Studies Ltd, vol. 91(1), pages 560-594.
    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. 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.
    3. 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.
    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. 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. 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.
    11. 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.
    12. 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.
    13. 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.
    14. 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.
    15. Davide Dottori, 2021. "Robots and employment: evidence from Italy," Economia Politica: Journal of Analytical and Institutional Economics, Springer;Fondazione Edison, vol. 38(2), pages 739-795, July.
    16. 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.
    17. 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).
    18. Teresa C. Fort & Justin R. Pierce & Peter K. Schott, 2018. "New Perspectives on the Decline of US Manufacturing Employment," Journal of Economic Perspectives, American Economic Association, vol. 32(2), pages 47-72, Spring.
    19. Wolcott, Erin L., 2021. "Employment inequality: Why do the low-skilled work less now?," Journal of Monetary Economics, Elsevier, vol. 118(C), pages 161-177.
    20. 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.

    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.