Monster Mashups Shine Light on Government

Let our journalists help you make sense of the noise: Subscribe to the Mother Jones Daily newsletter and get a recap of news that matters.

This story first appeared on the Miller-McCune website.

The gushing effluvia of spreadsheets and thick reports that flow from government are dissected, reconstituted and displayed by a dedicated band of coders.

Clay Johnson pulled out his iPhone to illustrate the kind of mashup that’s possible when coders get their hands on data churned out by government, whole reams of transactions on where federal money is spent, who gets it and how it’s used.

On the screen was a live view up 19th Street in northwest Washington, the moving picture overlaid with small bubbles representing projects on this very block paid for by the American Reinvestment and Recovery Act.

“It blows your mind, right?” Johnson asked. “This is the tip of the iceberg.”

What if, he suggests, an application could track all government spending on the federal, state, district and city level? What if it were able to personalize the data by inputting the taxes you paid this year to calculate — to the cent — what your contribution was to this road you’re walking down right now?

The Recovery “augmented reality” mashup was created by James Turk, a developer in the Sunlight Labs project that Johnson directs. Their experiment is an arm of the Sunlight Foundation, an open-government advocacy group Miller-McCune first mentioned in the January/February 2009 issue of the magazine.

Johnson spoke about the labs outside a coffee shop near the Sunlight office, today a mess of boxes and packing material as the growing foundation moves into a larger D.C. home.

Some of the organization’s other projects turn dense government data into vivid graphics and charts laymen can appreciate. Someone, though, has to make the data available to the coders to get it to citizens. And that is where Sunlight Labs comes in. Today, it is an open-source community of more than 1,000 developers from across the Internet hacking away on data sets newly available through sites like, devising interesting ways to parse and present them.

“[Sunlight Labs] now is, I think, where I’ve always wanted it to be,” Johnson said, “which is out of our control.”

Now largely run by the community itself, Sunlight Labs has created a kind of online app store (a free one, that is) for open government, with about 100 apps that do things like track which senators are most likely to block legislation using a filibuster (the aptly named app “filibusted”), or to mash up any two data sets off (“datamasher”). Both were winners of the labs’ “Apps for America” contests.

“Programmers think very rationally,” Johnson said, “and I think a lot of programmers want to basically digitize their government so that it behaves to them more rationally.”

The project predates Barack Obama’s arrival in Washington with his Gov2.0 pledges to make the town more transparent. But opening up the current administration, Johnson said, isn’t less frustrating than opening up the notoriously tight-lipped previous one. “It’s just different frustrating,” he said.

“Here’s a good example: dating,” he explained, laughing at his own analogy. “Who would you rather be courting? You go after someone and say, ‘Do you want to go out?’ And he or she says, ‘No.’ Or, you go after someone and say, ‘Do you want to go out”? ‘Yeah sure, maybe some day.’ That’s what the current administration does to an extent.”

A lot of the data the government does provide now is messy in a man-made way, riddled with typos a computer can’t correct, or presented in a format — like PDF files — a developer can’t readily work with. And so Sunlight Labs works not just to invent possibilities for developers, but also to show government what’s possible with a more dedicated effort — like the mashup of Recovery Act spending in your neighborhood, on your iPhone.

As the administration should appreciate, such a tool blunts at least some of the criticism that people can’t see where that money has gone.


Headshot of Editor in Chief of Mother Jones, Clara Jeffery

It sure feels that way to me, and here at Mother Jones, we’ve been thinking a lot about what journalism needs to do differently, and how we can have the biggest impact.

We kept coming back to one word: corruption. Democracy and the rule of law being undermined by those with wealth and power for their own gain. So we're launching an ambitious Mother Jones Corruption Project to do deep, time-intensive reporting on systemic corruption, and asking the MoJo community to help crowdfund it.

We aim to hire, build a team, and give them the time and space needed to understand how we got here and how we might get out. We want to dig into the forces and decisions that have allowed massive conflicts of interest, influence peddling, and win-at-all-costs politics to flourish.

It's unlike anything we've done, and we have seed funding to get started, but we're looking to raise $500,000 from readers by July when we'll be making key budgeting decisions—and the more resources we have by then, the deeper we can dig. If our plan sounds good to you, please help kickstart it with a tax-deductible donation today.

Thanks for reading—whether or not you can pitch in today, or ever, I'm glad you're with us.

Signed by Clara Jeffery

Clara Jeffery, Editor-in-Chief

payment methods

We Recommend