Code for MCVL Spanish Social Security Data

Replication files for 'Learning by working in big cities'

The site distributes and documents computer programs to replicate the results obtained by Jorge De la Roca and Diego Puga in their article 'Learning by working in big cities', to be published in Review of Economic Studies.

This research uses anonymized administrative data from the Muestra Continua de Vidas Laborales con Datos Fiscales (MCVL) with the permission of Spain's Dirección General de Ordenación de la Seguridad Social. We are NOT allowed to make the MCVL data available. Thus, in addition to the replication files available here, interested researchers will need to request access to the MCVL data from Spain's Dirección General de Ordenación de la Seguridad Social, by following the application process described in the site.

The MCVL data are extremely rich, containing matched anonymized social security, income tax and census records for a 4% random sample of Spanish workers, pensioners and unemployment benefit recipients. The application process required to obtain the MCVL data is simple, and approved users are allowed to work with the data in their own computers. By providing this replication code, in addition to enabling easy replication of our results, we hope to substantially reduce entry costs for users of the MCVL data.

Neighborhood exposure measures by race and metropolitan area 1980—2010

Replication data set (data_race21st.dta) for 'Race and neighborhoods in the 21st century'

This metropolitan area (CBSA) panel data set provides neighborhood exposure measures by race/ethnicity in 1980, 1990, 2000 and 2010 to replicate the results obtained by Jorge De la Roca, Ingrid Gould Ellen and Katherine M. O'Regan in their article 'Race and neighborhoods in the 21st century', published in Regional Science and Urban Economics.

Measures of exposure to poverty, to college-educated neighbors and to employed neighbors are obtained using census data for 1980, 1990 and 2000, and ACS 2006—2010 data for 2010. Measures of exposure to proficiency in standardized test scores and free/reduced-price lunch eligibility are obtained from the Department of Education for 2008—2009. These measures are calculated as rankings (0—100) within a CBSA. Measures of exposure to violent, property and total crime are available only for 60 CBSAs in 2000 and are obtained from the National Neighborhood Crime Study (Peterson and Krivo, 2000). These measures are also calculated as rankings (0—100) within a CBSA.

The data set also provides CBSA-level measures of residential segregation (dissimilarity and isolation indices) obtained from US2010, a joint project between the Russell Sage Foundation and Brown University, together with CBSA characteristics such as total population, shares of population that are black, Hispanic, Asian, over 65 years, under 15 years, foreign-born, unemployed, working in manufacturing, working in professional occupations and in poverty status. Users of this data set are kindly asked to cite the Regional Science and Urban Economics article as the source.