Personal Democracy Plus Our premium content network. LEARN MORE You are not logged in. LOG IN NOW >

San Francisco Publishes New Tool To Interpret Local Lobbying Information

BY Sarah Lai Stirland | Friday, January 20 2012

San Francisco's City Hall. Photo: Flickr/http: 2007

The San Francisco Ethics Commission on Thursday published a new tool that enables web developers to more easily access, interpret and mash up local lobbyist filing information.

San Francisco follows Chicago, which also offers an application programming interface for its lobbyist database. New York City offers a searchable database online, but doesn't have an API.

The San Francisco Ethics Commission has required lobbyists to file detailed electronic disclosure statements since 2010, but much of this data was difficult to use because it wasn't formatted in a way that could be interpreted by relational databases.

The commission was politely prodded about this in December during a local hackathon organized by Adriel Hampton, lead organizer for CityCampSF and the founder of San Francisco Tech Democrats, a group dedicated to open government and transparency issues.

techPresident left a message at the ethics commission for comment on the creation of the application programming interface. In the meantime, the commission's responsiveness generated a round of applause from open government advocates.

"Full access to the lobbyist database is key to being able to produce meaningful analysis of influence in the City," Hampton told techPresident via e-mail.

He further explained:

"This new API will help journalists, researchers and good government activists to more easily compare lobbyist contacts and activities with things like City Planning data, campaign contributions, and legislative actions.

It will also help show which companies and lobbyists are not reporting their efforts to influence city officials. There is a long way to go, but this is a great start."

CitiReport, a muckraking newsletter published by longtime San Franciscan Larry Bush, had sponsored a $1,000 prize for the best "open ethics" application created during the December hackathon. No-one was able to come up with one at the time.

"This is like a great effort to make political influence data accessible at the city level -- San Francisco deserves credit for being a leader on this front," said Tom Lee, director of Sunlight Labs, the portion of the Sunlight Foundation that provides the public with free government data APIs.

"Although the API doesn't expose absolutely everything available on the HTML lobbying portal (links to images of the lobbyists don't seem to be included, for instance), it does include a lot of substantive, useful information."

News Briefs

RSS Feed today >

First POST: Lifestyles

Google's CEO on "work-life balance"; how CloudFlare just doubled the size of the encrypted web; Dems like Twitter; Reps like Pinterest; and much, much more. GO

monday >

First POST: Showdown

How demonstrators in Hong Kong are using mobile tech to route around government control; will the news penetrate mainland China?; dueling spin from Dems and Reps on which party's tech efforts will matter more in November; and much, much more. GO

friday >

Pirate MEP Crowdsources Internet Policy Questions For Designated EU Commissioners

While the Pirate Party within Germany was facing internal disputes over the last week, the German Pirate Party member in the European Parliament, Julia Reda, is seeking to make the European Commission appointment process more transparent by crowdsourcing questions for the designated Commissioner for Digital Economy & Society and the designated Vice President for the Digital Single Market. GO

First POST: Dogfood

What ethical social networking might look like; can the iPhone promise more privacy?; how Obama did on transparency; and much, much more. GO

thursday >

First POST: Sucks

How the FCC can't communicate; tech is getting more political; Facebook might see a lawsuit for its mood manipulation experiment; and much, much more. GO

wednesday >

First POST: Wartime

A bizarre online marketing effort targets actress Emma Watson; why the news media needs to defend the privacy of its online readers; Chicago's playbook for civic user testing; and much, much more. GO

More