Data – Page 11 – Use It for Good

Online Analysis Tool Now Exports CSV Output

September 29, 2021June 2, 2021 by mpcblog

By Matthew Sobek

IPUMS is pleased to announce a major usability upgrade to our online analysis tool: the ability to download tabular output as a CSV file. No more cleaning up html!

The IPUMS online analysis tool has been a big hit with our users, and we’ve made it available for most of the IPUMS data collections. If you haven’t tried it, you should. We even have a tutorial.

Despite its popularity with users, the SDA (Survey Documentation and Analysis) software that drives the system has always had a significant limitation: it produces tables in html format, which is fine for web display but highly inconvenient for cutting and pasting into documents.

In spring 2020 the SDA folks at the Institute for Scientific Analysis were looking for a new project and thoughtfully asked what change we thought users would most appreciate. We responded immediately “CSV downloads,” and within a few months, they had produced a working version of the software that incorporates the new feature. We have now upgraded all the IPUMS sites that offer online analysis to the new version of SDA.

How has COVID-19 affected 2020 data collection efforts?

September 29, 2021March 3, 2021 by mpcblog

By Julia A. Rivera Drew, Sarah M. Flood, Renae Rodgers

IPUMS integrates data from several major US surveys that collect data throughout the year. Below, we discuss how COVID-19 has affected how US statistical agencies have collected these survey data in 2020.

Current Population Survey (CPS)

The Bureau of Labor Statistics (BLS) and the Census Bureau have continued to collect data on a monthly basis during the COVID-19 pandemic, implementing some procedural modifications to protect the safety of respondents and Census Bureau employees and adding a short supplement to capture the effects of the pandemic on work in the United States.

Changes to Interviewing Procedures

Current Population Survey (CPS) data collection for March had already begun when the Census Bureau suspended in-person data collection on March 20th, 2020. Two call centers that assist with CPS data collection also closed down at this time. However, data collection continued exclusively by phone through June of 2020. In July, in-person interviews began in some areas of the country and the call centers that had been closed in March re-opened. In-person interviews were resumed in all areas of the country in September 2020 and data collection has returned to a normal routine. More information on how alternative data collection procedures affected response rates, attrition, and employment data is available on the IPUMS CPS website.

Additional COVID-related content

The COVID-19 outbreak prompted the BLS to add five questions to the monthly CPS survey about work in the time of COVID-19. These questions were first asked in May. Though the question about foregoing medical care due to the pandemic was dropped from the survey after October of 2020, all other questions will remain in the survey until further notice. Researchers may preview the questions or access the COVID-specific variables via IPUMS CPS.

IPUMS CPS will continue to update our documentation on the effects of the pandemic on CPS data collection and to make new data available as quickly as possible. Follow @ipums on Twitter for the latest updates.

Mapping Block-Level Segregation: The Twin Cities’ Black Population, 1980-2010

December 21, 2021February 10, 2021 by mpcblog

Research, data preparation, story and graphics by Amalea Jubara and Yaxuan Zhang (Minnesota Population Center, Summer Diversity Fellows), mentored by Jonathan Schroeder (IPUMS Research Scientist) and Ying Song (Assistant Professor, Department of Geography, Environment & Society)

Edited by Jonathan Schroeder (IPUMS Research Scientist)

IPUMS NHGIS Block Data: An Expanding Collection

The most spatially precise U.S. census data are block-level tables, summarizing population and housing characteristics for millions of blocks throughout the country. IPUMS NHGIS provides block-level tables for the 1970 to 2010 decennial censuses as well as block boundary files for 1990, 2000 and 2010. This collection is set to grow substantially in the next few years as NHGIS adds new 2020 census block data and as we continue with a major initiative to construct 1980 and 1970 block boundary files. This expansion will open up new possibilities for high-precision spatial analysis across a longer time span.

A Case Study of the Twin Cities’ Black Population

To demonstrate some of the potential value of this expanding collection, we use NHGIS block data, including some not-yet-released 1980 block boundaries, to explore the recent history of racial segregation and integration in the Black population of the Twin Cities of Minneapolis and St. Paul, Minnesota, from 1980 to 2010. We present the block data in an interactive map along with data on early-20th-century racial covenants and the “redlining” zones of the Home Owners’ Loan Corporation (HOLC), recently published by the Mapping Prejudice and Mapping Inequality projects.

The block-level changes since 1980 show a striking trend toward greater dispersion and integration of Black residents, but segregation persists; several neighborhoods still have uniformly low or high proportions of Black residents. By overlaying racial covenants and HOLC zones with the block data, we can also find cases where the historical discriminatory practices appear to have left a lasting imprint on the distribution of Black residents.