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, employed, employ, employee, labor, statistician, employment growth, estimates employment, employment estimates, tenure, workplace, workforce, household, employment dynamics, labor statistics, longitudinal employer, employer household, census employment, workforce indicators, measures employment

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. :
Bureau of Labor Statistics, National Science Foundation, Standard Industrial Classification, Metropolitan Statistical Area, Service Annual Survey, Center for Economic Studies, Employer Identification Number, American Economic Review, MIT Press, Current Population Survey, Decennial Census, Chicago Census Research Data Center, Survey of Income and Program Participation, Cornell University, Social Security, Economic Census, Unemployment Insurance, Business Master File, Research Data Center, Department of Labor, North American Industry Classification System, American Community Survey, Social Security Number, Longitudinal Employer Household Dynamics, Alfred P Sloan Foundation, Cornell Institute for Social and Economic Research, LEHD Program, Business Register, Census Bureau Business Register, Employer-Household Dynamics, Protected Identification Key, Individual Characteristics File, Employer Characteristics File, Employment History File, American Housing Survey, Quarterly Workforce Indicators, CDF, Quarterly Census of Employment and Wages, Local Employment Dynamics, Business Employment Dynamics, Business Register Bridge, Master Address File, Composite Person Record, Office of Personnel Management, 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.