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

Fabian Eckert, Teresa Fort, Peter Schott and Natalie J. Yang

No 26632, NBER Working Papers from National Bureau of Economic Research, Inc

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: (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. Finally, we construct a user-friendly, 1975 to 2016 county-level panel that classifies industries according to a consistent set of 2012 NAICS codes in all years.

JEL-codes: E24 F16 J21 L6 (search for similar items in EconPapers)
Date: 2020-01
New Economics Papers: this item is included in nep-lma, nep-mac and nep-ore
Note: DAE ITI LS PR
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (31)

Downloads: (external link)
http://www.nber.org/papers/w26632.pdf (application/pdf)

Related works:
Working Paper: Imputing Missing Values in the US Census Bureau's County Business Patterns (2020)
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:nbr:nberwo:26632

Ordering information: This working paper can be ordered from
http://www.nber.org/papers/w26632

Access Statistics for this paper

More papers in NBER Working Papers from National Bureau of Economic Research, Inc National Bureau of Economic Research, 1050 Massachusetts Avenue Cambridge, MA 02138, U.S.A.. Contact information at EDIRC.
Bibliographic data for series maintained by ().