Data Services – Use It for Good

Introducing the MEPS Variable Builder!

November 19, 2024November 4, 2024 by mpcblog

By Julia A. Rivera Drew

Earlier this year, IPUMS MEPS launched a new feature – the MEPS Variable Builder – to make it dramatically easier to create customized person-level variables that summarize information from the medical event and condition records and add them to your IPUMS extract. If you have ever thought about using the MEPS event and condition data but didn’t know where to begin because of the complexity of the data, the MEPS Variable Builder is for you!

The Medical Expenditure Panel Survey Household Component (MEPS-HC, referred to MEPS here) provides comprehensive information on characteristics of people residing in responding households, as well as information about their medical encounters during the calendar year – e.g., office-based provider visits, emergency room (ER) visits, and hospitalizations – and medical conditions associated with those medical encounters. This unique combination of information makes the MEPS data ideal for research questions that need detailed health care utilization and/or expenditure data alongside individual-level correlates of health. However, these rich data can be difficult to work with, creating barriers for researchers who wish to use the MEPS data.

IPUMS MEPS created the MEPS Variable Builder to enable users to easily build person-level variables summarizing information from the MEPS-HC event and medical condition records, also known as “event summary variables.” Using a point-and-click interface, researchers can create custom event summary variables that count the number of events or sum expenditures across event records, filtered on selected characteristics of events and/or medical conditions. Users can then include these custom event summary variables in their IPUMS extract. At this time, the variable builder does not include prescribed medicines data.

In this blog post, we run through an example where we create a variable that is the sum of all expenditures paid for by Workers’ Compensation for medical visits due to a workplace injury.

Learning and Teaching Resources from IPUMS

August 20, 2024August 20, 2024 by mpcblog

By Kari Williams

In Minneapolis, MN at IPUMS HQ, the days are getting shorter, the nights are getting cooler, and school supplies are on sale in retail stores. Whether you approach “Back to School” season with enthusiasm, dread, or a mixture of the two, we want to remind you that IPUMS has great resources for students, faculty, and researchers!

Why Should I Complete the IPUMS User Survey?

May 12, 2023May 2, 2023 by mpcblog

By Kari Williams

If you are an avid IPUMS user who reads every email update, you have probably noticed that we pepper you with requests to complete our annual user survey. Perhaps you have asked yourself, “why bother?” or assumed we don’t really want YOUR feedback–that the survey is meant for a different type of IPUMS data user. We conduct an annual survey of data users for three reasons: 1) we value your input, 2) we want to invest in areas that benefit users, and 3) we reference your feedback when reporting to funders on current work and in applying for support to expand IPUMS. Let me assure you, we want to hear from YOU and we hope you take a few minutes to complete the survey.

Feedback is an important part of the IPUMS lifecycle. Our mission is to democratize access to the world’s social and economic data; data users are central to the success of this mission. We can learn a lot from registration numbers for each IPUMS data collection, the number and timing of online analysis or custom data extract requests, #poweredbyIPUMS publications, or questions and comments submitted to our User Support team. However, none of these is a substitute for directly asking users what they like most about IPUMS and what we can do better.

Reproducible Research with R Markdown, ipumsr, and the IPUMS API

June 14, 2022June 14, 2022 by mpcblog

By Dan Ehrlich

Have you ever wanted to share a project using IPUMS data with a colleague, but then thought, “Oh wait! It is against the terms of use to redistribute my IPUMS data file!”

Maybe you’d like a colleague to explore your findings. Or maybe you’re a teacher with an exercise you’d like your students to review and replicate. In the past, if you wanted someone to use the same IPUMS data that you did, you would need to provide a list of samples and variables and instructions for your collaborator on how to navigate the online data extract system.

If you’re thinking that sounds like a pain, don’t worry, the brand new IPUMS microdata API makes it easier than ever to share your extract definitions with fellow IPUMS users!!! Using the microdata API, you and your collaborators can:

Save an extract definition as a .json file that can be shared freely
Submit a new extract request based on a .json definition
Download data and metadata directly into your project directory (this feature is a personal favorite)

IPUMS IHGIS: Unlocking International Population and Agricultural Census Data

December 21, 2021November 5, 2020 by mpcblog

By Tracy Kugler

Nearly all countries throughout the world conduct population and housing censuses at least every ten years, and most also conduct agricultural censuses or surveys regularly. These censuses collect information on demographics, education, employment, housing characteristics, migration, agricultural land ownership, agricultural workforce, livestock, crops, and more. The resulting data can be used to study a wide range of questions, from the character of demographic transitions within and across countries, to utilization of irrigation, to educational trends among women.

Unfortunately, this wealth of data has remained largely inaccessible to researchers. The data are typically published in reports as tables summarizing population characteristics. In recent decades, many of these reports have been published as PDF documents and made available on national statistical office websites. While the reports are available, data from a PDF document cannot be easily imported into a statistical or GIS package. Furthermore, the table structures are highly heterogeneous, both across countries and even within the same report.

The International Historical Geographic Information System (IPUMS IHGIS) is designed to provide easy access to these data in a way that researchers can easily use for analysis. In the early phases, IHGIS was known internally as “Project Mako,” named after the Mako shark, which has a global range, voracious appetite, and a reputation for a broad-ranging diet. Like the shark, IHGIS (née Project Mako) will encompass the world and ingest all kinds of data tables.

Cite us! Seriously though…

December 21, 2021August 17, 2020 by mpcblog

By Renae Rodgers and Kari Williams

Hi there IPUMS users! Let’s talk about citations. When using our datasets in your insightful, groundbreaking, interesting work, please cite us!

Seriously though.

Cite us.

You wouldn’t steal a car, you wouldn’t rob a little old lady of her handbag, you wouldn’t base work on that of a colleague and not put their paper(s) in your reference section, right?!? Then don’t use IPUMS data and fail to mention it!

To help you on your way, here are some answers to frequently asked questions:

In the Archive: “25 Years of IPUMS Data”

December 18, 2019July 22, 2019 by mpcblog

“25 Years of IPUMS Data,” the current IPUMS/MPC archive exhibit, highlights a dynamic quarter center history of data innovation at the University of Minnesota. In the late 1980s, the Social History Research Laboratory at the University of Minnesota’s History Department proposed “the creation of a single integrated microdata series composed of public use samples for every year … with the exception of the 1890 census, which was destroyed by fire.” The primary aim was to make the U.S. census microdata “as compatible over time as possible while losing little, if any, of the detail in the original datasets” (Integrated Public Use Microdata Series: A Prospectus).