CREAT: Census Research Exploration and Analysis Tool

Papers Containing Tag(s): 'University of Minnesota'

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

Viewing papers 1 through 10 of 18


  • Working Paper

    Introducing the Medical Expenditure Panel Survey-Insurance Component with Administrative Records (MEPS-ICAR): Description, Data Construction Methodology, and Quality Assessment

    August 2022

    Working Paper Number:

    CES-22-29

    This report introduces a new dataset, the Medical Expenditure Panel Survey-Insurance Component with Administrative Records (MEPS-ICAR), consisting of MEPS-IC survey data on establishments and their health insurance benefits packages linked to Decennial Census data and administrative tax records on MEPS-IC establishments' workforces. These data include new measures of the characteristics of MEPS-IC establishments' parent firms, employee turnover, the full distribution of MEPS-IC workers' personal and family incomes, the geographic locations where those workers live, and improved workforce demographic detail. Next, this report details the methods used for producing the MEPS-ICAR. Broadly, the linking process begins by matching establishments' parent firms to their workforces using identifiers appearing in tax records. The linking process concludes by matching establishments to their own workforces by identifying the subset of their parent firm's workforce that best matches the expected size, total payroll, and residential geographic distribution of the establishment's workforce. Finally, this report presents statistics characterizing the match rate and the MEPS-ICAR data itself. Key results include that match rates are consistently high (exceeding 90%) across nearly all data subgroups and that the matched data exhibit a reasonable distribution of employment, payroll, and worker commute distances relative to expectations and external benchmarks. Notably, employment measures derived from tax records, but not used in the match itself, correspond with high fidelity to the employment levels that establishments report in the MEPS-IC. Cumulatively, the construction of the MEPS-ICAR significantly expands the capabilities of the MEPS-IC and presents many opportunities for analysts.
    View Full Paper PDF
  • Working Paper

    The Evolution of U.S. Retail Concentration

    March 2022

    Working Paper Number:

    CES-22-07

    Increases in national concentration have been a salient feature of industry dynamics in the U.S. and have contributed to concerns about increasing market power. Yet, local trends may be more informative about market power, particularly in the retail sector where consumers have traditionally shopped at nearby stores. We find that local concentration has increased almost in parallel with national concentration using novel Census data on product-level revenue for all U.S. retail stores. The increases in concentration are broad based, affecting most markets, products, and retail industries. We implement a new decomposition of the national Herfindahl Hirschman Index and show that despite similar trends, national and local concentration reflect different changes in the retail sector. The increase in national concentration comes from consumers in different markets increasingly buying from the same firms and does not reflect changes in local market power. We estimate a model of retail competition which links local concentration to markups. The model implies that the increase in local concentration explains one-third of the observed increase in markups.
    View Full Paper PDF
  • Working Paper

    Compositional Nature of Firm Growth and Aggregate Fluctuations

    March 2020

    Working Paper Number:

    CES-20-09

    This paper studies firm dynamics over the business cycle. I present evidence from the United Kingdom that more rapidly growing firms are born in expansions than in recessions. Using administrative records from Census data, I find that this observation also holds for the last four recessions in the United States. I also present suggestive evidence that financial frictions play an important role in determining the types of firms that are born at different stages of the business cycle. I then develop a general equilibrium model in which firms choose their managers' span of control at birth. Firms that choose larger spans of control grow faster and eventually get to be larger, and in this sense have a larger target size. Financial frictions in the form of collateral constraints slow the rate at which firms reach their target size. It takes firms longer to get up to scale when collateral constraints tighten; therefore, businesses with the largest target size are affected disproportionately more. Thus, fewer entrepreneurs find it profitable to choose larger projects when financial conditions deteriorate. Using Bayesian methods, I estimate the model using micro and aggregate data from the United Kingdom. I find that financial shocks account for over 80% of fluctuations in the formation of businesses with a large target size, and TFP and labor wedge shocks account for the remaining 20%. An independently estimated version of the model with no choice over the span of control needs larger aggregate shocks in order to account for the same data series, suggesting that the intensive margin of business formation is important at business cycle frequencies. The model with the choice over the span of control generates an empirically relevant and non-targeted collapse in the right tail of the cumulative growth distribution among firms started in recessions, while the model without such a choice does not. The paper also discusses implications for micro-targeted government stimulus policies.
    View Full Paper PDF
  • Working Paper

    Reservation Employer Establishments: Data from the U.S. Census Longitudinal Business Database

    January 2017

    Working Paper Number:

    CES-17-57

    The presence of employers and jobs on American Indian reservations has been difficult to analyze due to limited data. We are the first to geocode confidential data on employer establishments from the U.S. Census Longitudinal Business Database to identify location on or off American Indian reservations. We identify the per capita establishment count and jobs in reservation-based employer establishments for most federally recognized reservations. Comparisons to nearby non-reservation areas in the lower 48 states across 18 industries reveal that reservations have a similar sectoral distribution of employer establishments but have significantly fewer of them in nearly all sectors, especially when the area population is below 15,000 (as it is on the vast majority of reservations and for the majority of the reservation population). By contrast, the total number of jobs provided by reservation establishments is, on average, at par with or somewhat higher than in nearby county areas but is concentrated among casino-related and government employers. An implication is that average job numbers per establishment are higher in these sectors on reservations, including those with populations below 15,000, while the remaining industries are typically sparser within reservations (in firm count and jobs per capita). Geographic and demographic factors, such as population density and per capita income, statistically account for some but not all of these differences.
    View Full Paper PDF
  • Working Paper

    The Effects of Occupational Licensing Evidence from Detailed Business-Level Data

    January 2017

    Authors: Marek Zapletal

    Working Paper Number:

    CES-17-20

    Occupational licensing regulation has increased dramatically in importance over the last several decades, currently affecting more than one thousand occupations in the United States. I use confidential U.S. Census Bureau micro-data to study the relationship between occupational licensing and key business outcomes, such as number of practitioners, prices for consumers, and practitioners' entry and exit rates. The paper sheds light on the effect of occupational licensing on industry dynamics and intensity of competition, and is the first to study the effects on providers of required occupational training. I find that occupational licensing regulation does not affect the equilibrium number of practitioners or prices of services to consumers, but reduces significantly practitioner entry and exit rates. I further find that providers of occupational licensing training, namely, schools, are larger and seem to do better, in terms of revenues and gross margins, in states with more stringent occupational licensing regulation.
    View Full Paper PDF
  • Working Paper

    Going Entrepreneurial? IPOs and New Firm Creation

    January 2017

    Working Paper Number:

    CES-17-18

    Using matched employee-employer US Census data, we examine the effect of a successful initial public offering (IPO) on employee departures to startups. Accounting for the endogeneity of a firm's choice to go public, we find strong evidence that going public induces employees to leave for start-ups. Moreover, we document that the increase in turnover following an IPO is driven by employees departing to start-ups; we find no change in the rate of employee departures for established firms. We present evidence that, following an IPO, many employees who received stock grants experience a positive shock to their wealth which allows them to better tolerate the risks associated with joining a startup or to obtain funding. Our results suggest that the recent declines in IPO activity and new firm creation in the US may be causally linked. The recent decline in IPOs means fewer workers may move to startups, decreasing overall new firm creation in the economy.
    View Full Paper PDF
  • Working Paper

    Response Error & the Medicaid undercount in the CPS

    December 2016

    Working Paper Number:

    carra-2016-11

    The Current Population Survey Annual Social and Economic Supplement (CPS ASEC) is an important source for estimates of the uninsured population. Previous research has shown that survey estimates produce an undercount of beneficiaries compared to Medicaid enrollment records. We extend past work by examining the Medicaid undercount in the 2007-2011 CPS ASEC compared to enrollment data from the Medicaid Statistical Information System for calendar years 2006-2010. By linking individuals across datasets, we analyze two types of response error regarding Medicaid enrollment - false negative error and false positive error. We use regression analysis to identify factors associated with these two types of response error in the 2011 CPS ASEC. We find that the Medicaid undercount was between 22 and 31 percent from 2007 to 2011. In 2011, the false negative rate was 40 percent, and 27 percent of Medicaid reports in CPS ASEC were false positives. False negative error is associated with the duration of enrollment in Medicaid, enrollment in Medicare and private insurance, and Medicaid enrollment in the survey year. False positive error is associated with enrollment in Medicare and shared Medicaid coverage in the household. We discuss implications for survey reports of health insurance coverage and for estimating the uninsured population.
    View Full Paper PDF
  • Working Paper

    Interstate Migration and Employer-to-Employer Transitions in the U.S.: New Evidence from Administrative Records Data

    January 2016

    Working Paper Number:

    CES-16-44R

    Declines in migration across labor markets have prompted concerns that the U.S. economy is becoming less dynamic. In this paper we examine the relationship between residential migration and employer-to-employer transitions using both survey and administrative records data. We first note strong disagreement between the Current Population Survey (CPS) and other migration statistics on the timing and severity of any decline in interstate migration. Despite these divergent patterns for overall residential migration, we find consistent evidence of a substantial decline in economic migration between 2000 and 2010. We find that composition and the returns to migration have limited ability to explain recent changes in interstate migration.
    View Full Paper PDF
  • Working Paper

    How Credit Constraints Impact Job Finding Rates, Sorting & Aggregate Output*

    January 2016

    Working Paper Number:

    CES-16-25

    We empirically and theoretically examine how consumer credit access affects dis- placed workers. Empirically, we link administrative employment histories to credit reports. We show that an increase in credit limits worth 10% of prior annual earnings allows individuals to take .15 to 3 weeks longer to find a job. Conditional on finding a job, they earn more and work at more productive firms. We develop a labor sorting model with credit to provide structural estimates of the impact of credit on employ- ment outcomes, which we find are similar to our empirical estimates. We use the model to understand the impact of consumer credit on the macroeconomy. We find that if credit limits tighten during a downturn, employment recovers quicker, but output and productivity remain depressed. This is because when limits tighten, low-asset, low- productivity job losers cannot self-insure. Therefore, they search less thoroughly and take more accessible jobs at less productive firms.
    View Full Paper PDF
  • Working Paper

    An outside view: What do observers say about others' races and Hispanic origins?

    August 2015

    Working Paper Number:

    carra-2015-05

    Outsiders' views of a person's race or Hispanic origin can impact how she sees herself, how she reports her race and Hispanic origins, and her social and economic experiences. The way outsiders describe non-strangers in terms of their race and Hispanic origin may reveal popular assumptions about which race/Hispanic categories are salient for Americans, which kinds of people are seen as multiracial, and the types of cues people use when identifying another person's race. We study patterns of observer identification using a unique, large, linked data source with two measures of a person's race and Hispanic origin. One measure (from Census 2000 or the 2010 Census) was provided by a household respondent and the other (from the other census year) was provided by a census proxy reporter (e.g., a neighbor) who responded on behalf of a non-responsive household. We ask: Does an outsider's report of a person's race and Hispanic origin match a household report? We find that in about 90% of our 3.7 million (nonrepresentative) cases, proxy reports of a person's race and Hispanic origin match responses given by the household in a different census year. Match rates are high for the largest groups: non-Hispanic whites, blacks, and Asians and for Hispanics, though proxies are not very able to replicate the race responses of Hispanics. Matches are much less common for people in smaller groups (American Indian/Alaska Native, Pacific Islander, Some Other Race, and multiracial). We also ask: What predicts a matched response and what predicts a particular unmatched response? We find evidence of the persistence of hypodescent for blacks and hyperdescent for American Indians. Biracial Asian-whites and Pacific Islander-whites are more often seen by others as non-Hispanic white than as people of color. Proxy reporters tend to identify children as multiple race and elders as single race, whether they are or not. The race/Hispanic composition of the tract is more powerfully predictive of a particular unmatched response than are tract-level measures of socioeconomic status; unmatched responses are often consistent with the race/Hispanic characteristics of the neighborhood.
    View Full Paper PDF