Matching Compustat data to the Longitudinal Business Database,1976

Abstract

This paper documents the construction of an updated and comprehensive bridge between Compustat and the Longitudinal Business Database (LBD) spanning 1976–2020. The Compustat–LBD linkage is one of the most requested resources in the U.S. Federal Statistical Research Data Centers, yet no publicly documented, comprehensive bridge has existed to date. We fill this gap with a multi-stage matching framework that combines EIN matching, refined fuzzy name and address algorithms, NAICS alignment, telephone records, and a novel ExecuComp–LEHD linkage. The resulting bridge matches roughly 85% of unique GVKEYs and 95% of economic activity, providing a valuable resource for longitudinal research on U.S. businesses, corporate governance, and executive compensation. By detailing all matching procedures we deliver a production-quality tool for integrating public-company financials to firm-level microdata.

Keywords

Compustat Longitudinal Business Database record linkage administrative data firm-level microdata data integration economic measurement

Get full access to this article

View all access options for this article.

References

Giroud

Mueller

. Firm leverage, consumer demand, and employment losses during the great recession. Q J Econ 2015; 130(1): 271–316. https://doi.org/10.1093/qje/qjw035

Wallskog

Bloom

Ohlmacher

, et al.Within-firm pay inequality and productivity. Econ J 2026; ueag020. https://doi.org/10.1093/ej/ueag020

Davis

Haltiwanger

Jarmin

, et al. Volatility and dispersion in business growth rates: publicly traded versus privately held firms. In: Acemoglu

Rogoff

Woodford

(eds). NBER Macroeconomics Annual 2006. MIT Press, 2007, vol 21, pp. 107–180. CES Working Paper No. 06-17.

Alharbi

Saeed

Iqbal

, et al. Board co-option and audit quality: evidence from US. Int Rev Financ Anal 2025; 102: 104123. https://doi.org/10.1016/j.irfa.2025.104123

Ron

. Jarmin and javier Miranda. The longitudinal business database. Center for economic studies working paper series. U.S. Census Bureau., 2002. CES-WP-02-17.

Chow

Fort

Goetz

, et al. Redesigning the longitudinal business database. Center for economic studies working paper series. U.S. Census Bureau., 2021. CES-WP-21-08.

Weber Handwerker

Mason

. Linking firms with establishments in bls microdata. Mon Labor Rev 2013; 136(6): 14–22.

Abowd

Abramowitz

Levenstein

, et al. Optimal probabilistic record linkage: best practice for linking employers in survey and administrative data. In: Center for economic studies working paper series. U.S. Census Bureau, 2019. CES-WP-19-08.

Winkler

WE.

Overview of record linkage and current research directions (Research Report Series No. RRS2006-02). U.S. Census Bureau, Statistical Research Division. 2006. https://www.census.gov/library/working-papers/2006/adrm/rrs2006-02.html

10.

Ivan

Sunter

. A theory for record linkage. J Am Stat Assoc 1969; 64(328): 1183–1210.

11.

Winkler

. String comparator metrics and enhanced decision rules in the fellegi–sunter model of record linkage. Proceedings of the Section on Survey Research Methods. American Statistical Association, 1990, pp. 354–359.

Matching Compustat data to the Longitudinal Business Database,1976–2020

Abstract

Keywords

Get full access to this article

References