Data Projects – Use It for Good

Working with Subnational Geographies in IPUMS Global Health

June 17, 2025 by mpcblog

By Divya Pandey and Anna Bolgrien

In a research project combining data from IPUMS MICS and IPUMS DHS, IPUMS Global Health staff examined trends in the relationship between open defecation and high infant mortality rates (IMR) in the Eastern Indo-Gangetic Plains. The project focused on selected bordering regions in Nepal, Bangladesh, and India. By analyzing these environmentally and agro-climatically comparable regions, the study aimed to isolate the impact of national and local policies on open defecation and infant mortality rates.

Figure 1: Regions included in the study

A map of the border and surrounding regions of Nepal, Bangladesh, and India that highlights the sub-national regions included in the study.

The study pooled data from IPUMS MICS and IPUMS DHS to look at trends over almost two decades. IPUMS DHS includes data for all three countries, and IPUMS MICS provides additional years of data for Nepal and Bangladesh. Since the study focused on selected bordering geographies, the authors worked with data from lower administrative levels—divisions in Bangladesh, states in India, and regions in Nepal. Leveraging the geography resources provided by IPUMS, the team used both spatially harmonized and sample-specific geography variables (learn more about IPUMS DHS geography variables and IPUMS MICS geography variables). Spatially harmonized geography variables identify geographic regions using a consistent spatial footprint to allow for the comparison of the same physical space over time. Sample-specific geography variables are not harmonized across time; as their name suggests, they use the geographic boundaries that are sample-specific or contemporaneous to the survey-year in a country.

What is going on with the weighted counts in the January 2025 CPS?

May 21, 2025May 6, 2025 by mpcblog

By Kari Williams & Sarah Flood

The signature activity of IPUMS is data harmonization, or making variables interoperable across time, to facilitate pooling of multiple months or years of data, as well as comparative and trend analyses. It’s easy to get carried away in the magic of not needing to perform routine data cleaning and having documentation organized at the variable level, and perhaps miss some bigger picture considerations. The Current Population Survey (CPS) annual population controls adjustment is an excellent example.

Each January, the Census Bureau revises the CPS weights to incorporate new population controls, based on the Census Bureau’s updated population estimates. However, the Census Bureau doesn’t re-release previous weights for the CPS based on the new population controls. If you look at trendlines of weighted count estimates using CPS monthly data, you might notice a discontinuity between each December and January – these are the annual population control adjustments at work. In January 2025, the shift is particularly abrupt; this is because the 2024 vintage population estimates (i.e., the population controls for the 2025 CPS) reflect an improvement in the Census Bureau’s methodology for measuring net international migration.

Line chart showing a general upward trend from 2020-2025 with disruptions each January

Figure from Jed Kolko’s Population adjustments will cause the next jobs report to be misinterpreted and misconstrued.

IPUMS CPS Checks on Basic Monthly Data

April 9, 2025 by mpcblog

By Sarah Flood, Renae Rodgers, and Kari Williams

Federal data are critical for understanding much about the US population from its size and composition to its health and employment. The Current Population Survey (CPS) is our nation’s official source of information about the labor force. At the beginning of each month, we eagerly await the first Friday when the Employment Situation Summary (aka the monthly jobs report) will be released (it isn’t just us, right??). The monthly snapshot of the US labor force serves as a bellwether for how our economy is faring.

The Wednesday after the jobs report is released, we at IPUMS clear the decks in preparation for the release of the CPS Basic Monthly Survey (BMS) by the Census Bureau. The CPS BMS is the individual-level data from which the jobs report is generated. Our goal is always to process these data as soon as they’re released by the Census Bureau so that we can deliver them to IPUMS CPS users as quickly as possible. Those who rely on CPS BMS data each month might be familiar with coping strategies while waiting for the data–obsessive page refreshing, some nervous pacing, maybe wondering why they haven’t yet been released (iykyk).

While quickly processing CPS Basic Monthly data is a priority, so, too, is ensuring data quality. Each month, we carefully inspect CPS BMS data at several points in our process. First, we review all of the variables for codes that are undocumented or have suspicious frequencies. Second, we rely on a suite of tools during our integration process that alert us to any codes in the data that we haven’t accounted for in our variable-level harmonizations. After harmonization, we compare univariate statistics from the newest month data to the previous month of data. Generally we expect very little change across months and we have built tools that are designed to flag variable-level differences above a certain threshold as well as new codes on either end of the distribution.

Unlocking Spatial and Social Data with R: Introducing the R Spatial Notebook Series

May 14, 2025April 4, 2025 by mpcblog

By Kate Vavra-Musser

Introduction: What is the R Spatial Notebooks Project?

The R Spatial Notebooks Project is a series of R code notebooks, structured like a textbook, designed to guide users through the intricacies of data extraction, integration, cleaning, analysis, and visualization using R. The notebooks are specifically tailored for social science research and applications using spatial data. The modular textbook-style structure is designed for comprehensive skill development by working through sequences of notebooks. The project was developed through a partnership between the Institute for Social Research and Data Innovation (ISDRI), which houses IPUMS, and the Institute for Geospatial Understanding through an Integrated Discovery Environment (I-GUIDE). IPUMS provides census and survey data from around the world integrated across time and space. I-GUIDE is cyberinfrastructure that combines distributed geospatial data with computing for researchers, students, and policymakers.

The initial R Spatial Notebooks release includes roughly 20 freely-available notebooks on topics including IPUMS data extraction via API, accessing open-source data, data cleaning, foundational spatial data principles, exploratory data analysis, and mapping.

New Data! IPUMS International Spring 2025 Data Release

March 17, 2025 by mpcblog

By Derek Burk, Lara Cleveland, Jane Lee, Rodrigo Lovaton, and Sula Sarkar

Megaphone with Exciting news speech bubble banner.

Great news for IPUMS International (IPUMSI) users! Our ever-expanding census and survey data collection has just released new harmonized census samples from Honduras (2013), Kenya (2019), Malawi (2018), Mongolia (2010, 2020), and Mozambique (2017). We now have an average of 4.5 censuses per country. The Kenya census collection now spans 50 years!

This release also includes a large series of quarterly Labor Force Surveys from the Philippines (1997-2019). The 91 waves of the Philippines Labor Force Survey contain a total of 18 million person records.

Many thanks to the National Statistical Office partners in these countries for their ongoing contributions.

Tools for Combining Data Across IPUMS Global Health Surveys

May 14, 2025March 3, 2025 by mpcblog

By Miriam King, Devon Kristiansen, and Anna Bolgrien

IPUMS Global Health includes integrated data from three international health surveys: Demographic and Health Surveys (IPUMS DHS), Multiple Indicator Cluster Surveys (IPUMS MICS), and Performance Monitoring for Action (IPUMS PMA). All three surveys are nationally representative, primarily focus on low- and middle-income countries, and address issues related to the health and well-being of women and young children. These commonalities make combining integrated data across these data collections appealing. As Figure 1 shows, IPUMS DHS and IPUMS MICS cover different countries; combining them extends the geographic coverage of harmonized versions of data covering similar topics. Researchers can also combine data for those countries included in both IPUMS DHS and IPUMS MICS to provide additional observation points for time-series analyses.

Figure 1: Countries covered by IPUMS DHS and IPUMS MICS

World map with the countries included in IPUMS MICS and IPUMS DHS shaded in

Researchers who want to carry out cross-survey analyses face practical challenges. IPUMS imposes consistent variable names and codes within one kind of survey (DHS, MICS, or PMA); harmonized variable names and codes differ between these surveys. On each project’s website, the documentation for each variable highlights comparability issues to keep in mind when combining multiple samples, either within one type of survey or across survey types. IPUMS users must make separate customized data files from each database and merge those files. And subtle differences in question wording, skip patterns, geographic boundaries, and sampling procedures—such as MICS’ taking reports on child health from caretakers other than the biological mother—can introduce inconsistencies and inadvertent errors.

Even More IPUMS Data Available in the SDA Online Data Analysis Tool

June 15, 2025December 19, 2024 by mpcblog

By Daniel Backman

Beyond offering the ability to create and download customized datasets from the IPUMS microdata collections, we also support web-based analysis of the data through the SDA (Survey Documentation and Analysis) online data analysis tool. SDA empowers users to analyze IPUMS data directly from their web browsers without the need for additional software or advanced programming skills. Whether you’re a seasoned researcher or a student exploring data for the first time, the SDA tool makes it easier than ever to unlock insights from our datasets. If you’re a current SDA user and ready to get started, check out the new datasets from IPUMS CPS and IPUMS MEPS. Otherwise, read on to learn more about SDA and how to use this tool to analyze IPUMS data.

About IPUMS & SDA

What is SDA?

The SDA tool is a web-based interface that allows you to generate frequency tables, cross-tabulations, and summary statistics; create customized data visualizations, including bar charts, line graphs, and scatter plots; perform regression analysis; and export results as a CSV file for presentations or further analysis.

SDA increases the accessibility of data by allowing users to analyze data through a web-interface without needing to use (or purchase!) statistical software. There is detailed guidance on how to use the tool for analyses and how to manipulate variables. Additionally, it provides exceptionally fast real-time processing of data, making it ideal for use in the classroom or other interactive settings. See our data training exercises page for exercises that will guide you through using SDA to analyze IPUMS data.