Total Emp Gif

County Business Patterns Database

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


Imputing Missing Values in the US Census Bureau's County Business Patterns [01/20] [NBER WP #26632]


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: employment for the majority of county-industry cells is suppressed to protect confidentiality; and 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.


Updates:

We may periodically update the imputed data. If your enter an email address below we will notify you of such changes.



Raw CBP Files:

1970   1971   1972   1973   1974   1975   1976   1977   1978   1979  
1980   1981   1982   1983   1984   1985   1986   1987   1988   1989  
1990   1991   1992   1993   1994   1995   1996   1997   1998   1999  
2000   2001   2002   2003   2004   2005   2006   2007   2008   2009  
2010   2011   2012   2013   2014   2015   2016  
Readme  


Imputed CBP County Files:

1970   1971   1972   1973   1974   1975   1976   1977   1978   1979  
1980   1981   1982   1983   1984   1985   1986   1987   1988   1989  
1990   1991   1992   1993   1994   1995   1996   1997   1998   1999  
2000   2001   2002   2003   2004   2005   2006   2007   2008   2009  
2010   2011   2012   2013   2014   2015   2016  
Readme  


Industry Concordance Files:

SIC 1977   SIC 1987   NAICS 1997   NAICS 2002   NAICS 2007  
Readme  


Imputed Partial Employment Counts:

Imputed Partial Employment  
Readme  


Cleaning and Imputation Codes:

Find all codes needed to replicate the imputation on our public Github Repo.


If you use the data or code posted on this website please cite:

Fabian Eckert, Teresa C. Fort, Peter K. Schott, and Natalie J. Yang. "Imputing Missing Values in the US Census Bureau's County Business Patterns." NBER Working Paper #26632, 2020

@techreport{eckert2020imputing,
title={Imputing Missing Values in the US Census Bureau's County Business Patterns},
author={Eckert, Fabian and Fort, Teresa C. and Schott, Peter K. and Yang, Natalie J.},
year={2020},
institution={National Bureau of Economic Research}
}