IDEAS home Printed from https://ideas.repec.org/p/cpr/ceprdp/14352.html
   My bibliography  Save this paper

Imputing Missing Values in the US Census Bureau's County Business Patterns

Author

Listed:
  • Schott, Peter
  • Yang, Natalie
  • Eckert, Fabian
  • Fort, Teresa

Abstract

The County Business Patterns data published by the US Census Bureau track employment by county and industry from 1946 to the present. Two features of the data limit their usefulness to researchers in practice: (1) employment for the majority of county-industry cells is suppressed to protect confidentiality, and (2) industry classifications change over time. We address both issues. First, we develop a linear programming method that exploits the large set of adding-up constraints implicit in the hierarchical arrangement of the data to impute missing employment. Second, we provide concordances to map all data to a consistent set of industry codes.

Suggested Citation

  • Schott, Peter & Yang, Natalie & Eckert, Fabian & Fort, Teresa, 2020. "Imputing Missing Values in the US Census Bureau's County Business Patterns," CEPR Discussion Papers 14352, C.E.P.R. Discussion Papers.
    • Handle: RePEc:cpr:ceprdp:14352
    as

    Download full text from publisher

    File URL: https://cepr.org/publications/DP14352
    Download Restriction: CEPR Discussion Papers are free to download for our researchers, subscribers and members. If you fall into one of these categories but have trouble downloading our papers, please contact us at subscribers@cepr.org
    ---><---

    As the access to this document is restricted, you may want to look for a different version below or search for a different version of it.

    Other versions of this item:

    References listed on IDEAS

    as
    1. Lorenzo Caliendo & Fernando Parro & Esteban Rossi-Hansberg & Pierre-Daniel Sarte, 2018. "The Impact of Regional and Sectoral Productivity Changes on the U.S. Economy," The Review of Economic Studies, Review of Economic Studies Ltd, vol. 85(4), pages 2042-2096.
    2. Andrew B. Bernard & Stephen J. Redding & Peter K. Schott, 2013. "Testing for Factor Price Equality with Unobserved Differences in Factor Quality or Productivity," American Economic Journal: Microeconomics, American Economic Association, vol. 5(2), pages 135-163, May.
    3. 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.
    4. Lorenzo CALIENDO & Maximiliano DVORKIN & Fernando PARRO, 2016. "Trade and Labor Market Dynamics," Discussion papers 16050, Research Institute of Economy, Trade and Industry (RIETI).
    5. 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.
    6. Rebecca Diamond, 2016. "The Determinants and Welfare Implications of US Workers' Diverging Location Choices by Skill: 1980-2000," American Economic Review, American Economic Association, vol. 106(3), pages 479-524, March.
    7. Brad Hershbein & Lisa B. Kahn, 2018. "Do Recessions Accelerate Routine-Biased Technological Change? Evidence from Vacancy Postings," American Economic Review, American Economic Association, vol. 108(7), pages 1737-1772, July.
    8. Fabian Eckert, 2019. "Growing Apart: Tradable Services and the Fragmentation of the U.S. Economy," 2019 Meeting Papers 307, Society for Economic Dynamics.
    9. Fabian Eckert & Michael Peters, 2018. "Spatial Structural Change," 2018 Meeting Papers 98, Society for Economic Dynamics.
    10. Thomas J. Holmes & John J. Stevens, 2004. "Geographic concentration and establishment size: analysis in an alternative economic geography model," Journal of Economic Geography, Oxford University Press, vol. 4(3), pages 227-250, June.
    11. Moretti, Enrico & Hornbeck, Richard, 2018. "Who Benefits From Productivity Growth? Direct and Indirect Effects of Local TFP Growth on Wages, Rents, and Inequality," CEPR Discussion Papers 12953, C.E.P.R. Discussion Papers.
    12. Fabian Eckert & Sharat Ganapati & Conor Walsh, 2019. "Skilled Tradable Services: The Transformation of U.S. High-Skill Labor Markets," Opportunity and Inclusive Growth Institute Working Papers 25, Federal Reserve Bank of Minneapolis.
    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. Parag Mahajan, 2021. "Immigration and Local Business Dynamics: Evidence from U.S. Firms," Working Papers 21-18, Center for Economic Studies, U.S. Census Bureau.
    2. Kwon, Spencer Y. & Ma, Yueran & Zimmermann, Kaspar, 2022. "100 years of rising corporate concentration," SAFE Working Paper Series 359, Leibniz Institute for Financial Research SAFE.
    3. Craig Wesley Carpenter & Anders Van Sandt & Scott Loveridge, 2022. "Measurement error in US regional economic data," Journal of Regional Science, Wiley Blackwell, vol. 62(1), pages 57-80, January.
    4. Spencer Y. Kwon & Yueran Ma & Kaspar Zimmermann, 2024. "100 Years of Rising Corporate Concentration," American Economic Review, American Economic Association, vol. 114(7), pages 2111-2140, July.
    5. Kim, Dongin & Steinbach, Sandro, 2021. "Spillover effects of foreign direct investment in the United States: County-level evidence from the food industry," 2021 Annual Meeting, August 1-3, Austin, Texas 313983, Agricultural and Applied Economics Association.
    6. Fabian Eckert & Sharat Ganapati & Conor Walsh, 2020. "Urban-Biased Growth: A Macroeconomic Analysis," CESifo Working Paper Series 8705, CESifo.
    7. Douglas S. Noonan & Joanna Woronkowicz & Jessica Sherrod Hale, 2021. "More than STEM: spillovers from higher education institution infrastructure investments in the arts," The Journal of Technology Transfer, Springer, vol. 46(6), pages 1784-1813, December.
    8. Jan Eeckhout & Christoph Hedtrich & Roberto Pinheiro, 2021. "IT and Urban Polarization," Working Papers 21-18, Federal Reserve Bank of Cleveland.
    9. Jevan Cherniwchan & Nouri Najjar, 2021. "Free Trade and the Formation of Environmental Policy: Evidence from US Legislative Votes," Carleton Economic Papers 21-11, Carleton University, Department of Economics, revised 24 Feb 2022.
    10. Justin R. Pierce & Peter K. Schott & Cristina Tello-Trillo, 2022. "Trade Liberalization and Labor-Market Outcomes: Evidence from US Matched Employer-Employee Data," Working Papers 22-42, Center for Economic Studies, U.S. Census Bureau.
    11. Sean Wang & Samuel Young, 2023. "Unionization, Employer Opposition, and Establishment Closure," Working Papers 23-35, Center for Economic Studies, U.S. Census Bureau.
    12. Singla, Shikhar, 2023. "Regulatory costs and market power," LawFin Working Paper Series 47, Goethe University, Center for Advanced Studies on the Foundations of Law and Finance (LawFin).
    13. repec:ags:aaea22:335481 is not listed on IDEAS
    14. , 2020. "The City Paradox: Skilled Services and Remote Work," Opportunity and Inclusive Growth Institute Working Papers 43, Federal Reserve Bank of Minneapolis.
    15. Tom Schmitz & Italo Colantone & Gianmarco Ottaviano, 2024. "Regional and Aggregate Economic Consequences of Environmental Policy," Working Papers 2024.10, Fondazione Eni Enrico Mattei.
    16. Chad Brown & Jeronimo Carballo & Alessandro Peri, 2022. "Bankruptcy Shocks and Legal Labor Markets: Evidence from the Court Competition Era," Papers 2202.00044, arXiv.org.
    17. Blanchard, Emily J. & Bown, Chad P. & Chor, Davin, 2024. "Did Trump’s trade war impact the 2018 election?," Journal of International Economics, Elsevier, vol. 148(C).
    18. Bustos, Sebastián & Yıldırım, Muhammed A., 2022. "Production Ability and economic growth," Research Policy, Elsevier, vol. 51(8).
    19. Bo Li, 2024. "Household Leverage Cycle Around the Great Recession," Papers 2407.01539, arXiv.org.
    20. Jay Hyun & Ziho Park & Vladimir Smirnyagin, 2021. "Import Competition and Firms� Internal Networks," Working Papers 21-28, Center for Economic Studies, U.S. Census Bureau.
    21. Raven S. Molloy & Charles G. Nathanson & Andrew D. Paciorek, 2020. "Housing Supply and Affordability: Evidence from Rents, Housing Consumption and Household Location," Finance and Economics Discussion Series 2020-044, Board of Governors of the Federal Reserve System (U.S.).
    22. Tom Schmitz & Italo Colantone & Gianmarco Ottaviano, 2024. "Regional and Aggregate Economic Consequences of Environmental Policy Abstract: This paper shows how to combine microeconometric evidence on the effects of environmental policy with a macroeconomic mod," BAFFI CAREFIN Working Papers 24225, BAFFI CAREFIN, Centre for Applied Research on International Markets Banking Finance and Regulation, Universita' Bocconi, Milano, Italy.
    23. Krumel, Thomas & Goodrich, Corey, 2021. "COVID-19 Working Paper: Meatpacking Working Conditions and the Spread of COVID-19," USDA Miscellaneous 315417, United States Department of Agriculture.
    24. Bo Li, 2024. "Testing Business Cycle Theories: Evidence from the Great Recession," Papers 2403.04104, arXiv.org.
    25. Monica Deza & Thanh Lu & Johanna Catherine Maclean, 2022. "Office‐based mental healthcare and juvenile arrests," Health Economics, John Wiley & Sons, Ltd., vol. 31(S2), pages 69-91, October.

    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. 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.
    3. Xiang Ding & Teresa C. Fort & Stephen J. Redding & Peter K. Schott, 2019. "Structural Change Within Versus Across Firms: Evidence from the United States," Working Papers 2019-9, Princeton University. Economics Department..
    4. Benny Kleinman & Ernest Liu & Stephen J. Redding, 2023. "Dynamic Spatial General Equilibrium," Econometrica, Econometric Society, vol. 91(2), pages 385-424, March.
    5. Ferdinando Monte & Stephen J. Redding & Esteban Rossi-Hansberg, 2018. "Commuting, Migration, and Local Employment Elasticities," American Economic Review, American Economic Association, vol. 108(12), pages 3855-3890, December.
    6. Joan Monras, 2020. "Immigration and Wage Dynamics: Evidence from the Mexican Peso Crisis," Journal of Political Economy, University of Chicago Press, vol. 128(8), pages 3017-3089.
    7. Gagliardi, Luisa & Moretti, Enrico & Serafinelli, Michel, 2023. "The World's Rust Belts: The Heterogeneous Effects of Deindustrialization on 1,993 Cities in Six Countries," IZA Discussion Papers 16648, Institute of Labor Economics (IZA).
    8. Fabian Eckert & Sharat Ganapati & Conor Walsh, 2020. "Urban-Biased Growth: A Macroeconomic Analysis," CESifo Working Paper Series 8705, CESifo.
    9. Mike Zabek, 2024. "Local Ties in Spatial Equilibrium," American Economic Journal: Macroeconomics, American Economic Association, vol. 16(2), pages 287-317, April.
    10. Bryan A. Stuart, 2022. "The Long-Run Effects of Recessions on Education and Income," American Economic Journal: Applied Economics, American Economic Association, vol. 14(1), pages 42-74, January.
    11. 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.
    12. Gagliardi, Luisa & Moretti, Enrico & Serafinelli, Michel, 2023. "The World’s Rust Belts: The Heterogeneous Effects of Deindustrialization on 1,993 Cities in Six Countries," CEPR Discussion Papers 18655, C.E.P.R. Discussion Papers.
    13. Kozo Kiyota, 2023. "Spatially uneven pace of deindustrialisation within a country," The World Economy, Wiley Blackwell, vol. 46(7), pages 2187-2230, July.
    14. Claudia Macaluso, 2017. "Skill Remoteness and Post-layoff Labor Market Outcomes," 2017 Meeting Papers 569, Society for Economic Dynamics.
    15. Donald R. Davis & Eric Mengus & Tomasz K. Michalski, 2020. "Labor Market Polarization and The Great Urban Divergence," NBER Working Papers 26955, National Bureau of Economic Research, Inc.
    16. Luisa Gagliardi,, "undated". "The World’s Rust Belts: The Heterogeneous Effects of Deindustrialization on 1,993 Cities in Six Countries," RF Berlin - CReAM Discussion Paper Series 2317, Rockwool Foundation Berlin (RF Berlin) - Centre for Research and Analysis of Migration (CReAM).
    17. Gregory Howard, 2017. "The Migration Accelerator: Labor Mobility, Housing, and Aggregate Demand," 2017 Meeting Papers 563, Society for Economic Dynamics.
    18. Jae Song & David J Price & Fatih Guvenen & Nicholas Bloom & Till von Wachter, 2019. "Firming Up Inequality," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 134(1), pages 1-50.
    19. Mengus, Eric & Davis, Donald R. & Michalski, Tomasz K., 2020. "Labor Market Polarization and The Great Divergence: Theory and Evidence," CEPR Discussion Papers 14623, C.E.P.R. Discussion Papers.
    20. Kirill Borusyak & Peter Hull & Xavier Jaravel, 2023. "Design-Based Identification with Formula Instruments: A Review," NBER Working Papers 31393, National Bureau of Economic Research, Inc.

    More about this item

    JEL classification:

    • E24 - Macroeconomics and Monetary Economics - - Consumption, Saving, Production, Employment, and Investment - - - Employment; Unemployment; Wages; Intergenerational Income Distribution; Aggregate Human Capital; Aggregate Labor Productivity
    • F16 - International Economics - - Trade - - - Trade and Labor Market Interactions
    • J21 - Labor and Demographic Economics - - Demand and Supply of Labor - - - Labor Force and Employment, Size, and Structure
    • L6 - Industrial Organization - - Industry Studies: Manufacturing

    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:cpr:ceprdp:14352. 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://www.cepr.org .

    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.