Sunlight Foundation

OGD: Transparency for Whom?

Most of the raw data released by the Open Government Directive on Friday was released in an XML format.  For those of you who dont know what that is or what to do with it, thats because it most likely isnt for you.  Common knowledge about XML is that its a platform only Web developers and programmers use.  And thats what it looked like after opening up the datasets in XML on The unfamiliar code can be off-putting and might cause people to not try to figure out whats in these high value datasets.  In order to use XML one has to know how to convert it or how to use an XML reader. Its also possible to import XML to Microsoft Excel, and thats only if the file isnt so big it crashes the gentle Microsoft application. (We've had marginal success using Microsoft Access 2007 to look at some of the XML data.)

After finding an XML coded dataset that could be successfully imported to Excel, it became clear that the XML released in the name of transparency was delivered in bad XML. Take for example the Targeted Investment Program data, a program under TARP. Not only is that information already available in PDF and Excel formats on, those formats provide a more accurate and clear version of the data. The columns and rows are confused in the XML converted version, omitting the meaning of the data.

Most reporters that deal with data will say the best way to receive data files so they can be studied and displayed is in a CSV format. Luckily some of the raw data released on is in CSV format, and not XML, making for an easy import to Excel. But even the CSV files arent entirely sufficient to accomplish transparency.  The truth is not every American is tech savvy enough to navigate raw data. 

After a lot of toying with the information released on, it doesn't seem that the raw datasets provide much use for regular people.  The tools provided on, however, have shown some promise. The FAFSA application data released by the Department of Education is a good example. The tool makes it easy to see where the bulk of the subsidized loans are going. Make sure to check out the Myfood-a-Pedia put out by the Department of Agriculture, Its at least fun.

Search the Blog

Popular tags

2012 election 2012 elections 2013 Inauguration Ad Ad Hawk Ad Hoc AIG american crossroads Arab Spring Barack Obama BP budget Campaign contributions Campaign Finance Center for Responsive Politics Citizens United Colorado consumer banking Contracting Conventions2012 Correspondence crossroads GPS dark money Data Mine datamine debt ceiling Disclose act Distributed Research Dodd-Frank Earmarks Election 2012 Elizabeth Warren EPA FARA FCC FDA FEC Federal Election Commission Fellows Finance Data Catalog Financial Bailout Financial Reform FLIT FOIA follow the unlimited money Foreign lobbying Foreign Lobbying Influence Tracker freshmen Fundraising Guns Handy Tools health care Hoc House House Freshmen 112th House Majority PAC Immigration Independent Expenditure Independent expenditures influence Influence Explorer investment James Bopp Jr. John Boehner John Kerry Lobbying lobbying tracker Logs_6553 Majority PAC Mark Sanford Market Meltdown Media Medicare meeting logs Mitt Romney National Rifle Association Newt Gingrich nonprofits NRA obama OGD Open Government Directive Orrin Hatch outside spending Party Time PMA Group political ad sleuth Political Party Time Politwoops President Obama Priorities USA Action Recovery Rep. John Murtha Research Restore Our Future revolving door Rick Perry Rick Santorum Romney Ron Paul Sen. Christopher Dodd Senate Sheldon Adelson states of transparency Stealthy Wealthy stimulus Sunlight Live super committee super congress Super PAC super PAC profile Super PACs supercommittee Supercongress supreme court TARP Taxpayers for Common Sense transparency