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)

    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. Donald Davis & Eric Mengus & Tomasz Michalski, 2024. "Labor Market Polarization and the Great Urban Divergence," Working Papers hal-04759262, HAL.
    11. 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.
    12. 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.
    13. 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).
    14. Kozo Kiyota, 2023. "Spatially uneven pace of deindustrialisation within a country," The World Economy, Wiley Blackwell, vol. 46(7), pages 2187-2230, July.
    15. Claudia Macaluso, 2017. "Skill Remoteness and Post-layoff Labor Market Outcomes," 2017 Meeting Papers 569, Society for Economic Dynamics.
    16. 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.
    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.