In this paper, we describe the sensitivity of small-cell flow statistics
to coding errors in the identity of the underlying entities. Specifically,
we present results based on a comparison of the U.S. Census Bureau's
Quarterly Workforce Indicators (QWI) before and after correcting for
such errors in SSN-based identifiers in the underlying individual wage
records. The correction used involves a novel application of existing
statistical matching techniques. It is found that even a very conservative
correction procedure has a sizable impact on the statistics. The
average bias ranges from 0.25 percent up to 15 percent for flow statistics,
and up to 5 percent for payroll aggregates.
-
The LEHD Infrastructure Files and the Creation of the Quarterly Workforce Indicators
January 2006
Working Paper Number:
tp-2006-01
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. Beginning in 2003 and building on this infrastructure, the Census
Bureau has published the Quarterly Workforce Indicators (QWI), a new collection of data series
that offers unprecedented detail on the local dynamics of labor markets. Despite the fine detail,
confidentiality is maintained due to the application of state-of-the-art confidentiality protection
methods. This article describes how the input files are compiled and combined to create the infrastructure
files. We describe the multiple imputation methods used to impute in missing data and
the statistical matching techniques used to combine and edit data when a direct identifier match
requires improvement. Both of these innovations are crucial to the success of the final product. Finally,
we pay special attention to the details of the confidentiality protection system used to protect
the identity and micro data values of the underlying entities used to form the published estimates.
We provide a brief description of public-use and restricted-access data files with pointers to further
documentation for researchers interested in using these data.
View Full
Paper PDF
-
Confidentiality Protection in the Census Bureau Quarterly Workforce Indicators
February 2006
Working Paper Number:
tp-2006-02
The QuarterlyWorkforce Indicators are new estimates developed by the Census Bureau's Longitudinal
Employer-Household Dynamics Program as a part of its Local Employment Dynamics
partnership with 37 state Labor Market Information offices. These data provide detailed quarterly
statistics on employment, accessions, layoffs, hires, separations, full-quarter employment
(and related flows), job creations, job destructions, and earnings (for flow and stock categories of
workers). The data are released for NAICS industries (and 4-digit SICs) at the county, workforce
investment board, and metropolitan area levels of geography. The confidential microdata - unemployment
insurance wage records, ES-202 establishment employment, and Title 13 demographic
and economic information - are protected using a permanent multiplicative noise distortion factor.
This factor distorts all input sums, counts, differences and ratios. The released statistics are analytically
valid - measures are unbiased and time series properties are preserved. The confidentiality
protection is manifested in the release of some statistics that are flagged as "significantly distorted
to preserve confidentiality." These statistics differ from the undistorted statistics by a significant
proportion. Even for the significantly distorted statistics, the data remain analytically valid for
time series properties. The released data can be aggregated; however, published aggregates are
less distorted than custom postrelease aggregates. In addition to the multiplicative noise distortion,
confidentiality protection is provided by the estimation process for the QWIs, which multiply imputes
all missing data (including missing establishment, given UI account, in the UI wage record
data) and dynamically re-weights the establishment data to provide state-level comparability with
the BLS's Quarterly Census of Employment and Wages.
View Full
Paper PDF
-
The Creation of the Employment Dynamics Estimates
July 2002
Working Paper Number:
tp-2002-13
View Full
Paper PDF
-
LEHD Infrastructure S2014 files in the FSRDC
September 2018
Working Paper Number:
CES-18-27R
The Longitudinal Employer-Household Dynamics (LEHD) Program at the U.S. Census Bureau, with the support of several national research agencies, maintains 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 2014 Snapshot of the LEHD Infrastructure files as they are made available in the Census Bureau's secure and restricted-access Research Data Center network. The document attempts to provide a comprehensive description of all researcher-accessible files, of their creation, and of any modifications made to the files to facilitate researcher access.
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
-
Using linked employer-employee data to investigate the speed of adjustments in downsizing firms
May 2006
Working Paper Number:
tp-2006-03
When firms are faced with a demand shock, adjustment can take many forms. Firms can adjust
physical capital, human capital, or both. The speed of adjustment may differ as well: costs of
adjustment, the type of shock, the legal and economic enviroment all matter. In this paper, we
focus on firms that downsized between 1992 and 1997, but ultimately survive, and investigate how
the human capital distribution within a firm influences the speed of adjustment, ceteris paribus. In
other words, when do firms use mass layoffs instead of attrition to adjust the level of employment.
We combine worker-level wage records and measures of human capital with firm-level characteristics
of the production function, and use levels and changes in these variables to characterize
the choice of adjustment method and speed. Firms are described/compared up to 9 years prior to
death. We also consider how workers fare after leaving downsizing firms, and analyze if observed
differences in post-separation outcomes of workers provide clues to the choice of adjustment speed.
View Full
Paper PDF
-
Abandoning the Sinking Ship: The Composition of Worker Flows Prior to Displacement
August 2002
Working Paper Number:
tp-2002-11
declines experienced by workers several years before displacement occurs. Little attention, however,
has been paid to other changes in compensation and employment in firms prior to the actual
displacement event. This paper examines changes in the composition of job and worker flows
before displacement, and compares the "quality" distribution of workers leaving distressed firms to
that of all movers in general.
More specifically, we exploit a unique dataset that contains observations on all workers over
an extended period of time in a number of US states, combined with survey data, to decompose
different jobflow statistics according to skill group and number of periods before displacement.
Furthermore, we use quantile regression techniques to analyze changes in the skill profile of workers
leaving distressed firms. Throughout the paper, our measure for worker skill is derived from
person fixed effects estimated using the wage regression techniques pioneered by Abowd, Kramarz,
and Margolis (1999) in conjunction with the standard specification for displaced worker studies
(Jacobson, LaLonde, and Sullivan 1993).
We find that there are significant changes to all measures of job and worker flows prior to
displacement. In particular, churning rates increase for all skill groups, but retention rates drop
for high-skilled workers. The quantile regressions reveal a right-shift in the distribution of worker
quality at the time of displacement as compared to average firm exit flows. In the periods prior
to displacement, the patterns are consistent with both discouraged high-skilled workers leaving the
firm, and management actions to layoff low-skilled workers.
View Full
Paper PDF
-
Displaced workers, early leavers, and re-employment wages
November 2002
Working Paper Number:
tp-2002-18
In this paper, we lay out a search model that takes explicitly into account the
information flow prior to a mass layoff. Using universal wage data files that allow
us to identify individuals working with healthy and displacing firms both at
the time of displacement as well as any other time period, we test the predictions
of the model on re-employment wage differentials. Workers leaving a "distressed"
firm have higher re-employment wages than workers who stay with the
distressed firm until displacement. This result is robust to the inclusion of controls
for worker quality and unobservable firm characteristics.
View Full
Paper PDF
-
Earnings Growth, Job Flows and Churn
April 2020
Working Paper Number:
CES-20-15
How much do workers making job-to-job transitions benefit from moving away from a shrinking and towards a growing firm? We show that earnings growth in the transition increases with net employment growth at the destination firm and, to a lesser extent, decreases if the origin firm is shrinking. So, we sum the effect of leaving a shrinking and entering a growing firm and remove the excess turnover-related hires because gross hiring has a much smaller association with earnings growth than net employment growth. We find that job-to-job transitions with the cross-firm job flow have 23% more earnings growth than average.
View Full
Paper PDF
-
Two Perspectives on Commuting: A Comparison of Home to Work Flows Across Job-Linked Survey and Administrative Files
January 2017
Working Paper Number:
CES-17-34
Commuting flows and workplace employment data have a wide constituency of users including urban and regional planners, social science and transportation researchers, and businesses. The U.S. Census Bureau releases two, national data products that give the magnitude and characteristics of home to work flows. The American Community Survey (ACS) tabulates households' responses on employment, workplace, and commuting behavior. The Longitudinal Employer-Household Dynamics (LEHD) program tabulates administrative records on jobs in the LEHD Origin-Destination Employment Statistics (LODES). Design differences across the datasets lead to divergence in a comparable statistic: county-to-county aggregate commute flows. To understand differences in the public use data, this study compares ACS and LEHD source files, using identifying information and probabilistic matching to join person and job records. In our assessment, we compare commuting statistics for job frames linked on person, employment status, employer, and workplace and we identify person and job characteristics as well as design features of the data frames that explain aggregate differences. We find a lower rate of within-county commuting and farther commutes in LODES. We attribute these greater distances to differences in workplace reporting and to uncertainty of establishment assignments in LEHD for workers at multi-unit employers. Minor contributing factors include differences in residence location and ACS workplace edits. The results of this analysis and the data infrastructure developed will support further work to understand and enhance commuting statistics in both datasets.
View Full
Paper PDF