Transparency Camp is an un-conference designed to convene a trans-partisan tribe of open government advocates from all walks — government representatives, technologists, developers, NGOs, wonks and activists — to share knowledge on how to use new technologies to make our government transparent and meaningfully accessible to the public.Continue reading
Fun with Google Spreadsheets and Fusion Tables
I've been having a lot of fun with Google tools today, and I wanted to share. This morning I was interested in generating this pie chart from the data off of Data.gov in my last post but needed to get all the data out of the Data.gov Data Catalog first.
Google Spreadsheets actually makes this really easy -- if you know what you're doing:
Step 1: Create a new spreadsheet, and put this little line in a cell:
Step 2: There is no step 2. You're done.
Cool huh? You've now got a spreadsheet of all the data in Data.gov. But that's not what I wanted-- what I wanted was a count of each data source by agency to see who was providing the most data. The answer here was Google's new Fusion Tables. In Fusion Tables, I can then take the data, create an aggregation and provide me the counts, imported from my Google Spreadsheet.
Easy data analysis without a lick of code.Continue reading
Here are a few of the more interesting media mentions of Sunlight and our friends and grantees from the past... View ArticleContinue reading
Here are a few of the more interesting media mentions of Sunlight and our friends and grantees from this week:... View ArticleContinue reading
Last week, U.S. Rep. Mike Honda (Calif.) guest blogged on O’Reilly Radar and asked, “how can Congress take advantage of... View ArticleContinue reading
In Washington and have nothing to do on January 9th, the New America Foundation, Wired, and Google are hosting a... View ArticleContinue reading
Sunlight’s John Wonderlich recently spoke on a Google panel about the 2009 Tech Agenda and Open Government. Other panelists included... View ArticleContinue reading