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

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.

Authors

Institutions

Publication Details

Journal
Journal of Economic and Social Measurement
Published
2026-06-16
DOI
https://doi.org/10.1177/07479662261458730
Primary Topic
Data Quality and Management
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

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

Sean Streiff, Cristina Tello-Trillo, Lawrence Schmidt
Journal of Economic and Social Measurement
Data Quality and Management
article

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

Sean Streiff, Cristina Tello-Trillo, Lawrence Schmidt
article en

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.

Journal of Economic and Social Measurement
United States Census Bureau (US), The Econometric Society (US), Massachusetts Institute of Technology (US)
Openalex Percentile: Top 4%
Data Quality and Management
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.