As stated in the note from the Sunlight Foundation′s Board Chair, as of September 2020 the Sunlight Foundation is no longer active. This site is maintained as a static archive only.

Follow Us

We Don’t Need a GitHub for Data

by

picture of Lt. Commander Data standing in front of a screen with the GitHub logThere was an interesting exchange this past weekend between Derek Willis of the New York Times and Sunlight's own Labs Director emeritus, Clay Johnson. Clay wrote a post arguing that we need a "GitHub for data":

It's too hard to put data on the web. It’s too hard to get data off the web. We need a GitHub for data.

With a good version control system like Git or Mercurial, I can track changes, I can do rollbacks, branch and merge and most importantly, collaborate. With a web counterpart like GitHub I can see who is branching my source, what’s been done to it, they can easily contribute back and people can create issues and a wiki about the source I’ve written. To publish source to the web, I need only configure my GitHub account, and in my editor I can add a file, commit the change, and publish it to the web in a couple quick keystrokes.

[...]

Getting and integrating data into a project needs to be as easy as integrating code into a project. If I want to interface with Google Analytics with ruby, I can type gem install vigetlabs-garb and I’ve got what I need to talk to the Google Analytics API. Why can I not type into a console gitdata install census-2010 or gitdata install census-2010 —format=mongodb and have everything I need to interface with the coming census data?

On his own blog, Derek pushed back a bit:

[...] The biggest issue, for data-driven apps contests and pretty much any other use of government data, is not that data isn’t easy to store on the Web. It’s that data is hard to understand, no matter where you get it.

[...]

What I’m saying is that the very act of what Clay describes as a hassle:

A developer has to download some strange dataset off of a website like data.gov or the National Data Catalog, prune it, massage it, usually fix it, and then convert it to their database system of choice, and then they can start building their app.

Is in fact what helps a user learn more about the dataset he or she is using. Even a well-documented dataset can have its quirks that show up only in the data itself, and the act of importing often reveals more about the data than the documentation does. We need to import, prune, massage, convert. It’s how we learn.

I think there's a lot to what Derek is saying. Understanding what an MSA is, or how to match Census data up against information that's been geocoded by zip code -- these are bigger challenges than figuring out how to get the Census data itself. The documentation for this stuff is difficult to find and even harder to understand. Most users are driven toward the American Factfinder tool, but if that's not up to telling you what you want, you're going to have to spend some time hunting down the appropriate FTP site and an explanation of its organization -- Clay's right that this is a pain. But it's nothing compared to the challenge of figuring out how to use the data properly. It can be daunting.

But I think there are problems with the "GitHub for data" framing that go beyond the simple fact that the problems GitHub solves aren't the biggest problems facing analysts.

Continue reading

OSCON 2010

by

Last week I was fortunate enough to attend OSCON in Portland, OR. This year OSCON hosted hundreds of talks on a dizzying array of subjects. The hot topics this year were definitely cloud computing and languages, established and emerging.

Most interesting to me though was the emphasis on government, social issues, and information freedom. Tim O'Reilly's opening keynote set the tone for many of the later talks by calling for the open source community to use its expertise in cooperative problem solving to address pressing issues in government and society. There were also keynotes from Portland's Mayor Sam Adams and DC's Chief Technology Officer Bryan Sivak on the importance of open source in local government.

Continue reading

Follow the Money: What kind of wave will 2010 bring ashore?

by

Opinion polls and prognosticators alike suggest that Republicans are poised to make a major comeback in this year’s midterm elections. The comparison du jour is the 1994 “wave” that swept 54 Democrats in the House of Representatives out of office and the Republicans into power for the first time since 1956. A more accurate comparison, based on a Sunlight Foundation analysis of campaign finance disclosure information, would be the 2006 elections when Democrats won 31 seats and a bare majority in the House.

Continue reading

Citizens United: Tennessee’s response

by

The Supreme Court’s decision in the Citizens United v. FEC case has rendered 24 states' election laws unconstitutional. The 5-4 ruling in favor of Citizens United reversed a provision of the McCain-Feingold act that prohibited any electioneering communication—defined as advertising via broadcast, cable or satellite that is paid for by corporations or labor unions. Many states have acted fast to counter corporations’ ability to spend unlimited amounts of money to influence elections by passing laws that force disclosure of all independent expenditures in near real time. The Sunlight Foundation Reporting Group has decided to report what each of ...

Continue reading

States of Transparency: Missouri

by

The Open Government Directive encouraged states to put valuable government data online. In this series we're reviewing each state's efforts in this direction.

This week: Missouri
Website: www.mapyourtaxes.mo.gov


Residents of Missouri who want a glimpse at their state's official checkbook have a great resource in the so-called Missouri Accountability Portal (MAP). It's lacking one important tool, however: an accounting of state revenues. Online since 2005, the site boasts real-time updates, full downloadability and checkbook-level details. While it could benefit from a couple of improvements -- such as a list of the dates purchases were ...

Continue reading

CFC (Combined Federal Campaign) Today 59063

Charity Navigator