CREAT: Census Research Exploration and Analysis Tool

The LEHD Infrastructure Files and the Creation of the Quarterly Workforce Indicators

View Full Paper PDF

January 2006

Written by: Lars Vilhuber, John M. Abowd, Kevin L. McKinney, Bryce Stephens, Fredrik Andersson, Marc Roemer, Simon Woodcock

Working Paper Number:

tp-2006-01

Abstract

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.

Document Tags and Keywords

Keywords Keywords are automatically generated using KeyBERT, a powerful and innovative keyword extraction tool that utilizes BERT embeddings to ensure high-quality and contextually relevant keywords.

By analyzing the content of working papers, KeyBERT identifies terms and phrases that capture the essence of the text, highlighting the most significant topics and trends. This approach not only enhances searchability but provides connections that go beyond potentially domain-specific author-defined keywords. :
economist, estimating, payroll, quarterly, survey, earnings, employee, employ, employed, labor, statistician, estimates employment, employment growth, employment estimates, tenure, workplace, workforce, employment dynamics, labor statistics, measures employment, employer household, longitudinal employer, census employment, workforce indicators

Tags Tags are automatically generated using a pretrained language model from spaCy, which excels at several tasks, including entity tagging.

The model is able to label words and phrases by part-of-speech, including "organizations." By filtering for frequent words and phrases labeled as "organizations", papers are identified to contain references to specific institutions, datasets, and other organizations. :
Metropolitan Statistical Area, Standard Industrial Classification, Bureau of Labor Statistics, Service Annual Survey, National Science Foundation, Center for Economic Studies, American Economic Review, MIT Press, Current Population Survey, Decennial Census, Chicago Census Research Data Center, Employer Identification Numbers, Survey of Income and Program Participation, Cornell University, Business Master File, Social Security, Unemployment Insurance, Economic Census, Research Data Center, Department of Labor, North American Industry Classification System, American Community Survey, Social Security Number, Alfred P Sloan Foundation, Longitudinal Employer Household Dynamics, Cornell Institute for Social and Economic Research, LEHD Program, Census Bureau Business Register, Business Register, Protected Identification Key, Employer-Household Dynamics, Employment History File, Employer Characteristics File, Individual Characteristics File, American Housing Survey, Quarterly Workforce Indicators, CDF, Quarterly Census of Employment and Wages, Composite Person Record, Business Employment Dynamics, Local Employment Dynamics, Office of Personnel Management, Master Address File, Business Register Bridge, Census Bureau Master Address File

Similar Working Papers Similarity between working papers are determined by an unsupervised neural network model know as Doc2Vec.

Doc2Vec is a model that represents entire documents as fixed-length vectors, allowing for the capture of semantic meaning in a way that relates to the context of words within the document. The model learns to associate a unique vector with each document while simultaneously learning word vectors, enabling tasks such as document classification, clustering, and similarity detection by preserving the order and structure of words. The document vectors are compared using cosine similarity/distance to determine the most similar working papers. Papers identified with 🔥 are in the top 20% of similarity.

The 10 most similar working papers to the working paper 'The LEHD Infrastructure Files and the Creation of the Quarterly Workforce Indicators' are listed below in order of similarity.