An Analysis of Key Differences in Micro Data: Results from the Business List Comparison Project
September 2008
Working Paper Number:
CES-08-28
Abstract
The Bureau of Labor Statistics and the Bureau of the Census each maintain a business register, a universe of all U.S. business establishments and their characteristics, created from independent sources. Both registers serve critical functions such as supplying aggregate data inputs for certain national statistics generated by the Bureau of Economic Analysis. This paper examines key micro-level differences across these two business registers.
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.
:
payroll,
statistical,
report,
microdata,
survey,
agency,
employee,
organizational,
labor,
surveys censuses,
establishment,
department,
economic census,
workforce,
worker,
salary,
federal,
labor statistics,
census bureau,
census 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.
:
Internal Revenue Service,
Bureau of Labor Statistics,
Social Security Administration,
Bureau of Economic Analysis,
County Business Patterns,
Employer Identification Numbers,
Business Master File,
Economic Census,
Wholesale Trade,
Department of Labor,
North American Industry Classification System,
Business Register,
Quarterly Census of Employment and Wages
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 'An Analysis of Key Differences in Micro Data: Results from the Business List Comparison Project' are listed below in order of similarity.
-
Working PaperLongitudinal Establishment And Enterprise Microdata (LEEM) Documentation
May 1998
Working Paper Number:
CES-98-09
This paper introduces and documents the new Longitudinal Enterprise and Establishment Microdata (LEEM) database, which has been constructed by Census' Economic Planning and Coordination Division under contract to the Office of Advocacy of the U.S. Small Business Administration. The LEEM links three years (1990, 1994, and 1995) of basic data for each private sector establishment with payroll in any of those years, along with data on the firm to which the establishment belongs each year. The LEEM data will facilitate both broader and more detailed analysis of patterns of job creation and destruction in the U.S., as well as research on the structure and dynamics of U.S. businesses. This paper provides documentation of the construction of LEEM data, summary data on most variables in the database, comparisons of the annual data with that of the nearly identical County Business Patterns, and distributions of establishments and their employment by the size of their firms. This is followed by a simple analysis of changes over time in the attributes of surviving establishments, and a brief discussion of turnover (business births and deaths) in the population and gross changes in employment associated with both establishment turnover and with surviving establishments. It concludes with a summary of the strengths and weaknesses of the LEEM.View Full Paper PDF
-
Working PaperNEW DATA FOR DYNAMIC ANALYSIS: THE LONGITUDINAL ESTABLISHMENT AND ENTERPRISE MICRODATA (LEEM) FILE
December 1999
Working Paper Number:
CES-99-18
Until now, research on U.S. business activities over time has been hindered by the lack of accurate and comprehensive longitudinal data. The new Longitudinal Establishment and Enterprise Microdata (LEEM) are tremendously rich data that open up numerous possibilities for dynamic analyses of businesses in the U.S. economy. It is the first nationwide high-quality longitudinal database that covers the majority of employer businesses from all sectors of the economy. Due to the confidential nature of these data, the file is located at the Center for Economic Studies in the U.S. Bureau of the Census. To access the data, researchers must submit an acceptable proposal to CES and become sworn Census researchers. This paper describes the LEEM file, the variables contained on the file, and current uses of the data.View Full Paper PDF
-
Working PaperEstablishment and Employment Dynamics in Appalachia: Evidence from the Longitudinal Business Database
December 2003
Working Paper Number:
CES-03-19
One indicator of the general economic health of a region is the rate at which new jobs are created. The newly developed Longitudinal Business Database has been used in this paper to develop a detailed portrait of establishment formation and attrition and job creation and destruction in the Appalachian Region. The foremost finding is that the pace of reallocation in Appalachia is lower than it is for the U.S.. This is evident in Appalachia's relatively lower establishment birth and death rates and job creation and destruction rates. For example, on average over the study time period, the U.S. job creation rate exceeds 45 percent, while the Appalachian job creation rate is 43 percent. Similarly, the U.S. job destruction rate is about 35 percent, while the Appalachian job destruction rate is about 33 percent. Even when controlling for other differences, job creation rates are 1.2 percentage points lower and job destruction rates are 3.4 percentage points lower in Appalachia relative to the rest of the U.S. Another indicator of the general economic health of a region is the quality of its jobs. The quality of jobs is measured in this paper by the average wage paid at the establishment. Here too there is cause for concern about the economic health of Appalachia. The analysis shows that wages are about 10 percent lower in Appalachia than in the U.S. even when controlling for differences in other characteristics across the two areas. This wage discrepancy has not narrowed over the time of the study. Moreover, new establishments have a similar wage gap. Employees at new establishments earn wages 10 percent less than at new establishments in the rest of the U.S.View Full Paper PDF
-
Working PaperLEHD Data Documentation LEHD-OVERVIEW-S2008-rev1
December 2011
Working Paper Number:
CES-11-43
View Full Paper PDF
-
Working PaperDocumenting the Business Register and Related Economic Business Data
March 2016
Working Paper Number:
CES-16-17
The Business Register (BR) is a comprehensive database of business establishments in the United States and provides resources for the U.S. Census Bureau's economic programs for sample selection, research, and survey operations. It is maintained using information from several federal agencies including the Census Bureau, Internal Revenue Service, Bureau of Labor Statistics, and the Social Security Administration. This paper provides a detailed description of the sources and functions of the BR. An overview of the BR as a linking tool and bridge to other Census Bureau data for additional business characteristics is also given.View Full Paper PDF
-
Working PaperGross Job Flows for the U.S. Manufacturing Sector: Measurement from the Longitudinal Research Database
December 2006
Working Paper Number:
CES-06-30
Measures of job creation and destruction are now produced regularly by the U.S. statistical agencies. The Bureau of Labor Statistics releases via the Business Employment Dynamics (BED) on a quarterly basis measures of job creation and destruction for the U.S. nonfarm business sector and related disaggregation by industrial sector and size class. The U.S. Census Bureau has developed the Longitudinal Business Database (LBD) covering the nonfarm business sector that has been used to produce research analysis and special tabulations including tabulations of job creation and destruction. Both of these data programs build upon the measurement methods and data analysis of job creation and destruction measures from the Longitudinal Research Database (LRD) developed and published by Davis, Haltiwanger and Schuh (1996). In this paper, the LRD based estimates of job creation and destruction are updated and made available for consistent annual and quarterly series from 1972-1998. While the BED and LBD programs are more comprehensive in scope than the LRD, the extensive development of the LRD permits the construction of measures of job creation and destruction for a rich array of employer characteristics including industry, size, business age, ownership structure, location and wage structure. The updated series that are released with this working paper provide measures along each of these dimensions. The paper describes in detail the changes in the processing of the Annual Survey of Manufactures over the 1972-1998 period that are important to incorporate by users of the LRD at Census Research Data Centers as well as users of products from the LRD such as job creation and destruction.View Full Paper PDF
-
Working PaperPublished Versus Sample Statistics From The ASM: Implications For The LRD
January 1991
Working Paper Number:
CES-91-01
In principle, the Longitudinal Research Database ( LRD ) which links the establishments in the Annual Survey of Manufactures (ASM) is ideal for examining the dynamics of firm and aggregate behavior. However, the published ASM aggregates are not simply the appropriately weighted sums of establishment data in the LRD . Instead, the published data equal the sum of LRD-based sample estimates and nonsample estimates. The latter reflect adjustments related to sampling error and the imputation of small-establishment data. Differences between the LRD and the ASM raise questions for users of both data sets. For ASM users, time-series variation in the difference indicates potential problems in consistently and reliably estimating the nonsample portion of the ASM. For LRD users, potential sample selection problems arise due to the systematic exclusion of data from small establishments. Microeconomic studies based on the LRD can yield misleading inferences to the extent that small establishments behave differently. Similarly, new economic aggregates constructed from the LRD can yield incorrect estimates of levels and growth rates. This paper documents cross-sectional and time-series differences between ASM and LRD estimates of levels and growth rates of total employment, and compares them with employment estimates provided by Bureau of Labor Statistics and County Business Patterns data. In addition, this paper explores potential adjustments to economic aggregates constructed from the LRD. In particular, the paper reports the results of adjusting LRD-based estimates of gross job creation and destruction to be consistent with net job changes implied by the published ASM figures.View Full Paper PDF
-
Working PaperIdentifying U.S. Merchandise Traders: Integrating Customs Transactions with Business Administrative Data
September 2020
Working Paper Number:
CES-20-28
This paper describes the construction of the Longitudinal Firm Trade Transactions Database (LFTTD) enabling the identification of merchandise traders - exporters and importers - in the U.S. Census Bureau's Business Register (BR). The LFTTD links merchandise export and import transactions from customs declaration forms to the BR beginning in 1992 through the present. We employ a combination of deterministic and probabilistic matching algorithms to assign a unique firm identifier in the BR to a merchandise export or import transaction record. On average, we match 89 percent of export and import values to a firm identifier. In 1992, we match 79 (88) percent of export (import) value; in 2017, we match 92 (96) percent of export (import) value. Trade transactions in year t are matched to years between 1976 and t+1 of the BR. On average, 94 percent of the trade value matches to a firm in year t of the BR. The LFTTD provides the most comprehensive identification of and the foundation for the analysis of goods trading firms in the U.S. economy.View Full Paper PDF
-
Working PaperComparing Measures of Earnings Instability Based on Survey and Adminstrative Reports
August 2010
Working Paper Number:
CES-10-15
In Celik, Juhn, McCue, and Thompson (2009), we found that estimated levels of earnings instability based on data from the Current Population Survey (CPS) and the Survey of Income and Program Participation (SIPP) were reasonably close to each other and to others' estimates from the Panel Study of Income Dynamics (PSID), but estimates from unemployment insurance (UI) earnings were much larger. Given that the UI data are from administrative records which are often posited to be more accurate than survey reports, this raises concerns that measures based on survey data understate true earnings instability. To address this, we use links between survey samples from the SIPP and UI earnings records in the LEHD database to identify sources of differences in work history and earnings information. Substantial work has been done comparing earnings levels from administrative records to those collected in the SIPP and CPS, but our understanding of earnings instability would benefit from further examination of differences across sources in the properties of changes in earnings. We first compare characteristics of the overall and matched samples to address issues of selection in the matching process. We then compare earnings levels and jobs in the SIPP and LEHD data to identify differences between them. Finally we begin to examine how such differences affect estimates of earnings instability. Our preliminary findings suggest that differences in earnings changes for those in the lower tail of the earnings distribution account for much of the difference in instability estimates.View Full Paper PDF
-
Working PaperSuccessor/Predecessor Firms
March 2002
Working Paper Number:
tp-2002-04
The goal of this research was to investigate the value added from using worker flows to identify the spurious births and deaths of businesses. We identify four types of "at risk" businesses from ES202 using the successor/predecessor flag and mimic the same categories using UI wage record data. We use two critical decision rules in the analysis: a successor firm has to have at least 80% of employment coming from the donor firm and (in two of the four categories) at least 5 employees have to come from the donor firm. We examine the sensitivity of the categories based on the percentage definition, and find that the results stay very similar, with the exception of the identification of the pure successor. We examine the sensitivity based on the count threshold, and find that there are enormous differences, particularly with identifying spinoff businesses.View Full Paper PDF
