The goal of this research was to investigate the value added from using worker flows to identify the spurious births and deaths of businesses. We identify four types of "at risk" businesses from ES202 using the successor/predecessor flag and mimic the same categories using UI wage record data. We use two critical decision rules in the analysis: a successor firm has to have at least 80% of employment coming from the donor firm and (in two of the four categories) at least 5 employees have to come from the donor firm. We examine the sensitivity of the categories based on the percentage definition, and find that the results stay very similar, with the exception of the identification of the pure successor. We examine the sensitivity based on the count threshold, and find that there are enormous differences, particularly with identifying spinoff businesses.
-
Using Worker Flows in the Analysis of the Firm
August 2003
Working Paper Number:
tp-2003-09
This paper uses a novel approach to measure firm entry and exit, mergers and
acquisition. It uses information about the flows of clusters of workers across business
units to identify longitudinal linkage relationships in longitudinal business data. These
longitudinal relationships may be the result of either administrative or economic changes
and we explore both types of newly identified longitudinal relationships. In particular,
we develop a set of criteria based on worker flows to identify changes in firm
relationships ? such as mergers and acquisitions, administrative identifier changes and
outsourcing. We demonstrate how this new data infrastructure and this cluster flow
methodology can be used to better differentiate true firm entry/exit and simple changes in
administrative identifiers. We explore the role of outsourcing in a variety of ways but in
particular the outsourcing of workers to the temporary help industry. While the primary
focus is on developing the data infrastructure and the methodology to identify and
interpret these clustered flows of workers, we conclude the paper with an analysis of the
impact of these changes on the earnings of workers.
View Full
Paper PDF
-
LEHD Snapshot Documentation, Release S2021_R2022Q4
November 2022
Working Paper Number:
CES-22-51
The Longitudinal Employer-Household Dynamics (LEHD) data at the U.S. Census Bureau is a quarterly database of linked employer-employee data covering over 95% of employment in the United States. These data are used to produce a number of public-use tabulations and tools, including the Quarterly Workforce Indicators (QWI), LEHD Origin-Destination Employment Statistics (LODES), Job-to-Job Flows (J2J), and Post-Secondary Employment Outcomes (PSEO) data products. Researchers on approved projects may also access the underlying LEHD microdata directly, in the form of the LEHD Snapshot restricted-use data product. This document provides a detailed overview of the LEHD Snapshot as of release S2021_R2022Q4, including user guidance, variable codebooks, and an overview of the approvals needed to obtain access. Updates to the documentation for this and future snapshot releases will be made available in HTML format on the LEHD website.
View Full
Paper PDF
-
An Analysis of Key Differences in Micro Data: Results from the Business List Comparison Project
September 2008
Working Paper Number:
CES-08-28
The Bureau of Labor Statistics and the Bureau of the Census each maintain a business register, a universe of all U.S. business establishments and their characteristics, created from independent sources. Both registers serve critical functions such as supplying aggregate data inputs for certain national statistics generated by the Bureau of Economic Analysis. This paper examines key micro-level differences across these two business registers.
View Full
Paper PDF
-
Employer-to-Employer Flows in the United States: Estimates Using Linked Employer-Employee Data
September 2010
Working Paper Number:
CES-10-26
We use administrative data linking workers and firms to study employer-to-employer flows. After discussing how to identify such flows in quarterly data, we investigate their basic empirical patterns. We find that the pace of employer-to-employer flows is high, representing about 4 percent of employment and 30 percent of separations each quarter. The pace of employer-to-employer flows is highly procyclical, and varies systematically across worker, job and employer characteristics. Our findings regarding job tenure and earnings dynamics suggest that for those workers moving directly to new jobs, the new jobs are generally better jobs; however, this pattern is highly procyclical. There are rich patterns in terms of origin and destination of industries. We find somewhat surprisingly that more than half of the workers making employer-to-employer transitions switch even broadly-defined industries (NAICS supersectors).
View Full
Paper PDF
-
Business Dynamics of Innovating Firms: Linking U.S. Patents with Administrative Data on Workers and Firms
July 2015
Working Paper Number:
CES-15-19
This paper discusses the construction of a new longitudinal database tracking inventors and patent-owning firms over time. We match granted patents between 2000 and 2011 to administrative databases of firms and workers housed at the U.S. Census Bureau. We use inventor information in addition to the patent assignee firm name to and improve on previous efforts linking patents to firms. The triangulated database allows us to maximize match rates and provide validation for a large fraction of matches. In this paper, we describe the construction of the database and explore basic features of the data. We find patenting firms, particularly young patenting firms, disproportionally contribute jobs to the U.S. economy. We find patenting is a relatively rare event among small firms but that most patenting firms are nevertheless small, and that patenting is not as rare an event for the youngest firms compared to the oldest firms. While manufacturing firms are more likely to patent than firms in other sectors, we find most patenting firms are in the services and wholesale sectors. These new data are a product of collaboration within the U.S. Department of Commerce, between the U.S. Census Bureau and the U.S. Patent and Trademark Office.
View Full
Paper PDF
-
A COMPARISON OF PERSON-REPORTED INDUSTRY TO EMPLOYER-REPORTED INDUSTRY
IN SURVEY AND ADMINISTRATIVE DATA
September 2013
Working Paper Number:
CES-13-47
The Census Bureau collects industry information through surveys and administrative data and creates associated public-use statistics. In this paper, we compare person-reported industry in the American Community Survey (ACS) to employer-reported industry from the Quarterly Census of Employment and Wages (QCEW) that is part of the Census Bureau's Longitudinal Employer-Household Dynamics (LEHD) program. This research provides necessary information on the use of administrative data as a supplement to survey data industry information, and the findings will be useful for anyone using industry information from either source. Our project is part of a larger effort to compare information on jobs from household survey data to employer-reported information. This research is the first to compare ACS job data to firm-based administrative data. We find an overall industry sector match rate of 75 percent, and a 61 percent match rate at the 4-digit Census Industry Code (CIC) level. Industry match rates vary by sector and by whether industry sector is classified using ACS or LEHD industry information. The educational services and health care and social assistance sectors have among the highest match rates. The management of companies and enterprises sector has the lowest match rate, using either ACS-reported or LEHD-reported sector. For individuals with imputed industry data, the industry sector match rate is only 14 percent. Our findings suggest that the industry distribution and the sample in a particular industry sector will differ depending on whether ACS or LEHD data are used.
View Full
Paper PDF
-
FIRM AGE AND SIZE IN THE LONGITUDINAL EMPLOYER-HOUSEHOLD DYNAMICS DATA
March 2014
Working Paper Number:
CES-14-16
The Census Bureau's Quarterly Workforce Dynamics (QWI) and OnTheMap now provide detailed workforce statistics by employer age and size. These data allow a first look at the demographics of workers at small and young businesses as well as detailed analysis of how hiring, turnover, job creation/destruction vary throughout a firm's lifespan. Both the QWI and OnTheMap are tabulated from the Longitudinal Employer-Household Dynamics (LEHD) linked employer-employee data. Firm age and size information was added to the LEHD data through integration of Business Dynamics Statistics (BDS) microdata into the LEHD jobs frame. This paper describes how these two new firm characteristics were added to the microdata and how they are tabulated in QWI and OnTheMap
View Full
Paper PDF
-
Matching State Business Registration Records
to Census Business Data
January 2020
Working Paper Number:
CES-20-03
We describe our methodology and results from matching state Business Registration Records (BRR) to Census business data. We use data from Massachusetts and California to develop methods and preliminary results that could be used to guide matching data for additional states. We obtain matches to Census business records for 45% of the Massachusetts BRR records and 40% of the California BRR records. We find higher match rates for incorporated businesses and businesses with higher startup-quality scores as assigned in Guzman and Stern (2018). Clerical reviews show that using relatively strict matching on address is important for match accuracy, while results are less sensitive to name matching strictness. Among matched BRR records, the modal timing of the first match to the BR is in the year in which the BRR record was filed. We use two sets of software to identify matches: SAS DQ Match and a machine-learning algorithm described in Cuffe and Goldschlag (2018). We find preliminary evidence that while the ML-based method yields more match results, SAS DQ tends to result in higher accuracy rates. To conclude, we provide suggestions on how to proceed with matching other states' data in light of our findings using these two states.
View Full
Paper PDF
-
USING LINKED CENSUS R&D-LRD DATA TO ANALYZE THE EFFECT OF R&D INVESTMENT ON TOTAL FACTOR PRODUCTIVITY GROWTH
January 1989
Working Paper Number:
CES-89-02
Previous studies have demonstrated that productivity growth is positively correlated with the intensity of R&D investment. However, existing studies of this relationship at the micro (firm or line of business) level have been subject to some important limitations. The most serious of these has been an inability to adequately control for the diversified activities of corporations. This study makes use of linked Census R&D - LRD data, which provides comprehensive information on each firms' operations at the 4-digit SIC level. A marked improvement in explaining the association between R&D and TFP occurs when we make appropriate use of the data by firm by industry. Significant relationships between the intensities of investment in total, basic, and company-funded R&D, and TFP growth are confirmed.
View Full
Paper PDF
-
LEHD Infrastructure Files in the Census RDC: Overview of S2004 Snapshot
April 2011
Working Paper Number:
CES-11-13
The Longitudinal Employer-Household Dynamics (LEHD) Program at the U.S. Census Bureau, with the support of several national research agencies, has built a set of infrastructure files using administrative data provided by state agencies, enhanced with information from other administrative data sources, demographic and economic (business) surveys and censuses. The LEHD Infrastructure Files provide a detailed and comprehensive picture of workers, employers, and their interaction in the U.S. economy. This document describes the structure and content of the 2004 Snapshot of the LEHD Infrastructure files as they are made available in the Census Bureau's Research Data Center network.
View Full
Paper PDF