-
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
-
Total Error and Variability Measures for the Quarterly Workforce Indicators and LEHD Origin Destination Employment Statistics in OnTheMap
September 2020
Working Paper Number:
CES-20-30
We report results from the first comprehensive total quality evaluation of five major indicators in the U.S. Census Bureau's Longitudinal Employer-Household Dynamics (LEHD) Program Quarterly Workforce Indicators (QWI): total flow-employment, beginning-of-quarter employment, full quarter employment, average monthly earnings of full-quarter employees, and total quarterly payroll. Beginning-of-quarter employment is also the main tabulation variable in the LEHD Origin-Destination Employment Statistics (LODES) workplace reports as displayed in On-TheMap (OTM), including OnTheMap for Emergency Management. We account for errors due to coverage; record-level non response; edit and imputation of item missing data; and statistical disclosure limitation. The analysis reveals that the five publication variables under study are estimated very accurately for tabulations involving at least 10 jobs. Tabulations involving three to nine jobs are a transition zone, where cells may be fit for use with caution. Tabulations involving one or two jobs, which are generally suppressed on fitness-for-use criteria in the QWI and synthesized in LODES, have substantial total variability but can still be used to estimate statistics for untabulated aggregates as long as the job count in the aggregate is more than 10.
View Full
Paper PDF
-
Family-Leave Mandates and Female Labor at U.S. Firms: Evidence from a Trade Shock
September 2020
Working Paper Number:
CES-20-25
We study the role of family-leave mandates in shaping the gender composition at U.S. firms that experience a negative demand shock. In a regression discontinuity framework, we compare firms mandated to provide job-protected leave under the Family and Medical Leave Act (FMLA) and firms that are exempt from the law (non-FMLA) following the post-2001 surge in Chinese imports. Using confidential microdata on matched employers and employees in the U.S. non-farm private sector, we find that between 2000 and 2003, an increase in import competition decreases the share of female workers at FMLA compared to non-FMLA firms. The negative differential effect is driven by female workers in prime childbearing years, with less than college education, and is strongest at firms with all male managers. We find similar patterns in changes in the female share of earnings and promotions. These results suggest that, when traditional gender norms prevail, adverse shocks may exacerbate gender inequalities in the presence of job-protected leave mandates.
View Full
Paper PDF
-
Total Error and Variability Measures with Integrated Disclosure Limitation for Quarterly Workforce Indicators and LEHD Origin Destination Employment Statistics in On The Map
January 2017
Working Paper Number:
CES-17-71
We report results from the rst comprehensive total quality evaluation of five major indicators in the U.S. Census Bureau's Longitudinal Employer-Household Dynamics (LEHD) Program Quarterly Workforce Indicators (QWI): total employment, beginning-of-quarter employment, full-quarter employment, total payroll, and average monthly earnings of full-quarter employees. Beginning-of-quarter employment is also the main tabulation variable in the LEHD Origin-Destination Employment Statistics (LODES) workplace reports as displayed in OnTheMap (OTM). The evaluation is conducted by generating multiple threads of the edit and imputation models used in the LEHD Infrastructure File System. These threads conform to the Rubin (1987) multiple imputation model, with each thread or implicate being the output of formal probability models that address coverage, edit, and imputation errors. Design-based sampling variability and nite population corrections are also included in the evaluation. We derive special formulas for the Rubin total variability and its components that are consistent with the disclosure avoidance system used for QWI and LODES/OTM workplace reports. These formulas allow us to publish the complete set of detailed total quality measures for QWI and LODES. The analysis reveals that the five publication variables under study are estimated very accurately for tabulations involving at least 10 jobs. Tabulations involving three to nine jobs have quality in the range generally deemed acceptable. Tabulations involving zero, one or two jobs, which are generally suppressed in the QWI and synthesized in LODES, have substantial total variability but their publication in LODES allows the formation of larger custom aggregations, which will in general have the accuracy estimated for tabulations in the QWI based on a similar number of workers.
View Full
Paper PDF
-
Revisiting the Effects of Unemployment Insurance Extensions on Unemployment: A Measurement Error-Corrected Regression Discontinuity Approach
March 2016
Working Paper Number:
carra-2016-01
The extension of Unemployment Insurance (UI) benefits was a key policy response to the Great Recession. However, these benefit extensions may have had detrimental labor market effects. While evidence on the individual labor supply response indicates small effects on unemployment, recent work by Hagedorn et al. (2015) uses a county border pair identification strategy to find that the total effects inclusive of effects on labor demand are substantially larger. By focusing on variation within border county pairs, this identification strategy requires counties in the pairs to be similar in terms of unobservable factors. We explore this assumption using an alternative regression discontinuity approach that controls for changes in unobservables by distance to the border. To do so, we must account for measurement error induced by using county-level aggregates. These new results provide no evidence of a large change in unemployment induced by differences in UI generosity across state boundaries. Further analysis suggests that individuals respond to UI benefit differences across boundaries by targeting job search in high-benefit states, thereby raising concerns of treatment spillovers in this setting. Taken together, these two results suggest that the effect of UI benefit extensions on unemployment remains an open question.
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
-
The Recent Decline in Employment Dynamics
March 2013
Working Paper Number:
CES-13-03
In recent years, the rate at which workers and businesses exchange jobs has declined in the United States. Between 1998 and 2010, rates of job creation, job destruction, hiring, and separation declined dramatically, and the rate of job-to-job flows fell by about half. Little is known about the nature and extent of these changes, and even less about their causes and implications. In this paper, we document and attempt to explain the recent decline in employment dynamics. Our empirical work relies on the four leading datasets of quarterly employment dynamics in the United States ' the Longitudinal Employer-Household Dynamics (LEHD), the Business Employment Dynamics (BED), the Job Openings and Labor Turnover Survey (JOLTS), and the Current Population Survey (CPS). We find that changes in the composition of the labor force and of employers explain relatively little of the decline. Exploiting some identities that relate the different measures to each other, we find that job creation and destruction could explain as much of a third of the decline in hires and separations, while job-to-job flows may explain more of the decline. We end our paper with a discussion of different possible explanations and their relative merits.
View Full
Paper PDF
-
Dynamically Consistent Noise Infusion and Partially Synthetic Data as Confidentiality Protection Measures for Related Time Series
July 2012
Working Paper Number:
CES-12-13
The Census Bureau's Quarterly Workforce Indicators (QWI) provide detailed quarterly statistics on employment measures such as worker and job flows, tabulated by worker characteristics in various combinations. The data are released for several levels of NAICS industries and geography, the lowest aggregation of the latter being counties. Disclosure avoidance methods are required to protect the information about individuals and businesses that contribute to the underlying data. The QWI disclosure avoidance mechanism we describe here relies heavily on the use of noise infusion through a permanent multiplicative noise distortion factor, used for magnitudes, counts, differences and ratios. There is minimal suppression and no complementary suppressions. To our knowledge, the release in 2003 of the QWI was the first large-scale use of noise infusion in any official statistical product. We show that the released statistics are analytically valid along several critical dimensions { measures are unbiased and time series properties are preserved. We provide an analysis of the degree to which confidentiality is protected. Furthermore, we show how the judicious use of synthetic data, injected into the tabulation process, can completely eliminate suppressions, maintain analytical validity, and increase the protection of the underlying confidential data.
View Full
Paper PDF
-
National Estimates of Gross Employment and Job Flows from the Quarterly Workforce Indicators with Demographic and Industry Detail
June 2010
Working Paper Number:
CES-10-11
The Quarterly Workforce Indicators (QWI) are local labor market data produced and released every quarter by the United States Census Bureau. Unlike any other local labor market series produced in the U.S. or the rest of the world, the QWI measure employment flows for workers (accession and separations), jobs (creations and destructions) and earnings for demographic subgroups (age and gender), economic industry (NAICS industry groups), detailed geography (block (experimental), county, Core- Based Statistical Area, and Workforce Investment Area), and ownership (private, all) with fully interacted publication tables. The current QWI data cover 47 states, about 98% of the private workforce in those states, and about 92% of all private employment in the entire economy. State participation is sufficiently extensive to permit us to present the first national estimates constructed from these data. We focus on worker, job, and excess (churning) reallocation rates, rather than on levels of the basic variables. This permits comparison to existing series from the Job Openings and Labor Turnover Survey and the Business Employment Dynamics Series from the Bureau of Labor Statistics. The national estimates from the QWI are an important enhancement to existing series because they include demographic and industry detail for both worker and job flow data compiled from underlying micro-data that have been integrated at the job and establishment levels by the Longitudinal Employer-Household Dynamics Program at the Census Bureau. The estimates presented herein were compiled exclusively from public-use data series and are available for download.
View Full
Paper PDF
-
A Formal Test of Assortative Matching in the Labor Market
November 2009
Working Paper Number:
CES-09-40
We estimate a structural model of job assignment in the presence of coordination frictions due to Shimer (2005). The coordination friction model places restrictions on the joint distribution of worker and firm effects from a linear decomposition of log labor earnings. These restrictions permit estimation of the unobservable ability and productivity differences between workers and their employers as well as the way workers sort into jobs on the basis of these unobservable factors. The estimation is performed on matched employer-employee data from the LEHD program of the U.S. Census Bureau. The estimated correlation between worker and firm effects from the earnings decomposition is close to zero, a finding that is often interpreted as evidence that there is no sorting by comparative advantage in the labor market. Our estimates suggest that his finding actually results from a lack of sufficient heterogeneity in the workforce and available jobs. Workers do sort into jobs on the basis of productive differences, but the effects of sorting are not visible because of the composition of workers and employers.
View Full
Paper PDF
