CREAT: Census Research Exploration and Analysis Tool

Papers written by Author(s): 'Kevin L. McKinney'

The following papers contain search terms that you selected. From the papers listed below, you can navigate to the PDF, the profile page for that working paper, or see all the working papers written by an author. You can also explore tags, keywords, and authors that occur frequently within these papers.
Click here to search again

Frequently Occurring Concepts within this Search

Longitudinal Employer Household Dynamics - 23

National Science Foundation - 17

Alfred P Sloan Foundation - 17

Quarterly Workforce Indicators - 14

Cornell University - 13

Unemployment Insurance - 13

Bureau of Labor Statistics - 12

Current Population Survey - 12

Social Security Administration - 10

American Community Survey - 10

Social Security Number - 10

Employer Identification Numbers - 10

Quarterly Census of Employment and Wages - 10

Disclosure Review Board - 8

Internal Revenue Service - 8

Standard Industrial Classification - 8

North American Industry Classification System - 8

LEHD Program - 8

Center for Economic Studies - 7

Research Data Center - 7

National Institute on Aging - 7

Employer Characteristics File - 7

Local Employment Dynamics - 7

International Trade Research Report - 7

Business Register - 7

Protected Identification Key - 6

Office of Personnel Management - 6

Census Bureau Disclosure Review Board - 6

AKM - 6

Metropolitan Statistical Area - 6

Service Annual Survey - 6

Employment History File - 6

Individual Characteristics File - 6

Economic Census - 6

Census Numident - 5

Master Address File - 5

Successor Predecessor File - 5

Survey of Income and Program Participation - 5

Census Bureau Business Register - 5

Business Register Bridge - 5

Cornell Institute for Social and Economic Research - 5

Decennial Census - 4

University of Chicago - 4

Longitudinal Business Database - 4

Core Based Statistical Area - 4

Composite Person Record - 4

Federal Tax Information - 4

National Bureau of Economic Research - 4

Standard Statistical Establishment List - 4

Business Master File - 4

American Housing Survey - 4

CDF - 4

Business Employment Dynamics - 4

Cumulative Density Function - 4

Journal of Labor Economics - 3

Social Security - 3

IZA - 3

Establishment Micro Properties - 3

Department of Labor - 3

Viewing papers 11 through 20 of 25


  • Working Paper

    Modeling Endogenous Mobility in Wage Determiniation

    June 2015

    Working Paper Number:

    CES-15-18

    We evaluate the bias from endogenous job mobility in fixed-effects estimates of worker- and firm-specific earnings heterogeneity using longitudinally linked employer-employee data from the LEHD infrastructure file system of the U.S. Census Bureau. First, we propose two new residual diagnostic tests of the assumption that mobility is exogenous to unmodeled determinants of earnings. Both tests reject exogenous mobility. We relax the exogenous mobility assumptions by modeling the evolution of the matched data as an evolving bipartite graph using a Bayesian latent class framework. Our results suggest that endogenous mobility biases estimated firm effects toward zero. To assess validity, we match our estimates of the wage components to out-of-sample estimates of revenue per worker. The corrected estimates attribute much more of the variation in revenue per worker to variation in match quality and worker quality than the uncorrected estimates.
    View Full Paper PDF
  • Working Paper

    JOB-TO-JOB (J2J) Flows: New Labor Market Statistics From Linked Employer-Employee Data

    September 2014

    Working Paper Number:

    CES-14-34

    Flows of workers across jobs are a principal mechanism by which labor markets allocate workers to optimize productivity. While these job flows are both large and economically important, they represent a significant gap in available economic statistics. A soon to be released data product from the U.S. Census Bureau will fill this gap. The Job-to-Job (J2J) flow statistics provide estimates of worker flows across jobs, across different geographic labor markets, by worker and firm characteristics, including direct job-to-job flows as well as job changes with intervening nonemployment. In this paper, we describe the creation of the public-use data product on job-to-job flows. The data underlying the statistics are the matched employer-employee data from the U.S. Census Bureau's Longitudinal Employer-Household Dynamics program. We describe definitional issues and the identification strategy for tracing worker movements between employers in administrative data. We then compare our data with related series and discuss similarities and differences. Lastly, we describe disclosure avoidance techniques for the public use file, and our methodology for estimating national statistics when there is partially missing geography.
    View Full Paper PDF
  • Working Paper

    NOISE INFUSION AS A CONFIDENTIALITY PROTECTION MEASURE FOR GRAPH-BASED STATISTICS

    September 2014

    Working Paper Number:

    CES-14-30

    We use the bipartite graph representation of longitudinally linked em-ployer-employee data, and the associated projections onto the employer and em-ployee nodes, respectively, to characterize the set of potential statistical summar-ies that the trusted custodian might produce. We consider noise infusion as the primary confidentiality protection method. We show that a relatively straightfor-ward extension of the dynamic noise-infusion method used in the U.S. Census Bureau's Quarterly Workforce Indicators can be adapted to provide the same confidentiality guarantees for the graph-based statistics: all inputs have been modified by a minimum percentage deviation (i.e., no actual respondent data are used) and, as the number of entities contributing to a particular statistic increases, the accuracy of that statistic approaches the unprotected value. Our method also ensures that the protected statistics will be identical in all releases based on the same inputs.
    View Full Paper PDF
  • Working Paper

    LEHD Infrastructure files in the Census RDC - Overview

    June 2014

    Working Paper Number:

    CES-14-26

    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 2011 Snapshot of the LEHD Infrastructure files as they are made available in the Census Bureaus 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 modifcations made to the files to facilitate researcher access.
    View Full Paper PDF
  • Working Paper

    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
  • Working Paper

    LEHD Data Documentation LEHD-OVERVIEW-S2008-rev1

    December 2011

    Working Paper Number:

    CES-11-43

    View Full Paper PDF
  • Working Paper

    LEHD Infrastructure Files in the Census RDC: Overview of S2004 Snapshot

    April 2011

    Working Paper Number:

    CES-11-13

    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. This document describes the structure and content of the 2004 Snapshot of the LEHD Infrastructure files as they are made available in the Census Bureau's Research Data Center network.
    View Full Paper PDF
  • Working Paper

    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
  • Working Paper

    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
  • Working Paper

    Using Worker Flows in the Analysis of the Firm

    August 2003

    Working Paper Number:

    tp-2003-09

    This paper uses a novel approach to measure firm entry and exit, mergers and acquisition. It uses information about the flows of clusters of workers across business units to identify longitudinal linkage relationships in longitudinal business data. These longitudinal relationships may be the result of either administrative or economic changes and we explore both types of newly identified longitudinal relationships. In particular, we develop a set of criteria based on worker flows to identify changes in firm relationships ? such as mergers and acquisitions, administrative identifier changes and outsourcing. We demonstrate how this new data infrastructure and this cluster flow methodology can be used to better differentiate true firm entry/exit and simple changes in administrative identifiers. We explore the role of outsourcing in a variety of ways but in particular the outsourcing of workers to the temporary help industry. While the primary focus is on developing the data infrastructure and the methodology to identify and interpret these clustered flows of workers, we conclude the paper with an analysis of the impact of these changes on the earnings of workers.
    View Full Paper PDF