CREAT: Census Research Exploration and Analysis Tool

Optimal Probabilistic Record Linkage: Best Practice for Linking Employers in Survey and Administrative Data

March 2019

Abstract

This paper illustrates an application of record linkage between a household-level survey and an establishment-level frame in the absence of unique identifiers. Linkage between frames in this setting is challenging because the distribution of employment across firms is highly asymmetric. To address these difficulties, this paper uses a supervised machine learning model to probabilistically link survey respondents in the Health and Retirement Study (HRS) with employers and establishments in the Census Business Register (BR) to create a new data source which we call the CenHRS. Multiple imputation is used to propagate uncertainty from the linkage step into subsequent analyses of the linked data. The linked data reveal new evidence that survey respondents' misreporting and selective nonresponse about employer characteristics are systematically correlated with wages.

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.
:
census research, survey data, survey, respondent, linked census, imputation, census employment, linkage

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.
:
Social Security Administration, Longitudinal Research Database, National Science Foundation, National Bureau of Economic Research, Longitudinal Business Database, Employer Identification Numbers, Survey of Income and Program Participation, Cornell University, Unemployment Insurance, Health and Retirement Study, Alfred P Sloan Foundation, Longitudinal Employer Household Dynamics, Census Bureau Business Register, Business Register, Quarterly Workforce Indicators, Quarterly Census of Employment and Wages, University of Michigan, Disclosure Review Board

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 'Optimal Probabilistic Record Linkage: Best Practice for Linking Employers in Survey and Administrative Data' are listed below in order of similarity.