Tag Archive: open government data

A New Focus on Sunlight’s APIs

by Nicko Margolies May 6, 2013 11:03 am

At Sunlight we're immensely proud of our community of API users and today we're launching a new section of our website to learn more about them, see how others use the data and use the snazzy query builder.

Evaluating Municipal Lobbying Data: Philadelphia

by Alisha Green

policy

May 3, 2013 10:00 am

Philadelphia-sculpture

“Consistent” is not the first word one would use to describe the landscape of lobbying data released by municipalities. As revealed by our research, the formats and range of information local governments collect and disclose about lobbying activity varies quite a bit from one community context to another. After exploring the best practices for collecting and releasing this information, we created and recently published a Municipal Lobbying Data Guidebook. This guide addresses not only what kinds of information should be included in an ideal lobbying dataset, but also information about how that data should be collected and shared, regulated, and examples of the impact of having this information made available in an open way. (Something we’ll continue to explore in future posts.)

So how do municipalities measure up to these standards? We took a close look at three cities -- Austin, Chicago, and Philadelphia -- to explore what they’re doing well and where their lobbying disclosure can improve.

We've already covered Austin and Chicago. Now we turn to look at Philadelphia, which is a unique case in this set of cities.

WHAT COULD (AND WAS SUPPOSED TO) BE

Philadelphia's online lobbying disclosures were never supposed to look like they do now. When the lobbying disclosure law passed in 2010, the city contracted for software that would utilize electronic filing and share the information in a searchable format -- a requirement under the new law. The city had to cancel that contract, though, when the vendor failed to produce working software for the lobbying portal.

The city's current lobbying disclosure website is a temporary solution. Philadelphia recently put out a notice of intent to contract* for a new website with Acclaim Systems Inc -- the same company working on the state of Pennsylvania's lobbying disclosure system. The RFP for Philadelphia's new website includes a call for the use of unique ID numbers for filers; a way to publish registrations and expense reports "as PDFs and as data to the public searchable site"; user ability to search and download registration and expense reports "easily via the Internet" and to generate PDFs for each of these; and to create an online directory of lobbyists with photos.

The goal is essentially to have Philadelphia's website meet the two stipulations called for in the lobbying disclosure law: e-filing and searchability. The RFP calls for a system "that can be designed and implemented in a four-month timeframe or less," so if the contract receives final approval soon the site could be up this year.

Having some information available in the meantime is better than having none at all. We evaluate the current website with this in mind and with an eye toward how the next iteration of the website that comes after this placeholder might look.

WHAT EXISTS NOW

I. What data is available

Philadelphia links to its lobbying information from a webpage on its Board of Ethics site. It makes registration and reporting forms and instructions available. It also posts some completed lobbying registrations and expense reports.

The lobbying registration forms require the date of registration, the lobbyist name, address, and contact information, details about any affiliated political action committees or candidate political committees, and the name, address, and contact information for any principals or lobbying firms. This level of detail is in line with Sunlight’s Guidebook recommendations.

Evaluating Municipal Lobbying Data: Chicago

by Alisha Green

policy

May 1, 2013 3:01 pm

Chicago-skyline

Last week we covered Austin. Now we turn to Chicago.

I. What data is available

Chicago has two hubs for its information related to lobbying: One is on the Board of Ethics website, and the other is in its data portal, though you can also find these records in the reports section of the Electronic Lobbyist Filing System, which links to a search function and back to the data portal. As we noted when we surveyed the landscape of municipal lobbying data, Chicago appears to release some of the most detailed lobbyist data among U.S. cities. The city's data portal contains information about registered lobbyists, activity, compensation, gifts, expenditures, and termination. Many cities don't collect this much detailed information, let alone post it online.

This data includes many of the form fields mentioned in our Guidebook and some further levels of detail. Registration and termination forms for 2013 include lobbyist names, addresses, and contact information; the filing date and termination date, if relevant; and client information including their address, contact information and industry.

Activity reports include the name of the agency contacted by the lobbyist along with the client being represented and the topic of the action requested. The reports also show how many administrative or legislative actions were requested.

Evaluating Municipal Lobbying Data: Austin

by Alisha Green

policy

Apr 25, 2013 11:00 am

Austin-Texas

“Consistent” is not the first word one would use to describe the landscape of lobbying data released by municipalities. As revealed by our research, the formats and range of information local governments collect and disclose about lobbying activity varies quite a bit from one community context to another. After exploring the best practices for collecting and releasing this information, we created and recently published a Municipal Lobbying Data Guidebook. This guide addresses not only what kinds of information should be included in an ideal lobbying dataset but also information about how that data should be collected, shared, regulated, and examples of the impact of having this information made available in an open way (something we’ll continue to explore in future posts).

So how do municipalities measure up to these standards? We’re taking a close look at three cities -- Austin, Chicago, and Philadelphia -- to explore what they’re doing well and where their lobbying disclosure can improve. Today, we turn to Austin.

I. What data is available

Austin's City Clerk oversees lobbying activity and reporting, sharing some related information with the public in an online portal page. The page includes downloadable template forms for lobbying registration, termination and quarterly activity. The city also posts online lists of registered lobbyists and their clients, along with address information and the nature of business for certain clients.

Downloading any of the template forms shows Austin requires several of the form fields recommended in by our Municipal Lobbying Data Guidebook. The registration form requires information about the lobbyist and their clients. The activity form requires information about the lobbyist and a breakdown of expenditures. (Any expenses less than $100 each can be aggregated.) Campaign finance reports are also linked to from the lobbying portal page. These reports require the name of the contributor, the amount contributed, and the date of the transaction.

Open Data Policy Evolution: San Francisco

by Rebecca Williams

policy

Apr 25, 2013 9:00 am

Since the release of Sunlight’s Open Data Policy Guidelines last June, Chicago, Madison, Montgomery County, and Utah have all enacted open data laws, and the states of Hawaii and Ohio are both in the process of enacting open data legislation. However, the recent amendment of San Francisco’s two-and-a-half-year-old open data ordinance (ancient in the open data policy world) demonstrates a new frontier for these policies: Evolution.

San Francisco is unique in having been one of three cities to have an open data policy enacted before the federal Open Government Directive and in being the only city that has revamped their open data policy not once, but twice: first in 2010, expanding their bare bones 2009 executive order into a longer, more robust administrative code, and for a second time in late March 2013, amending the administrative code language.

Sunlight identified in our Open Data Policy Guidelines the importance of future review for potential changes to policy and law, and we were glad to see that San Francisco’s most recent amendment not only incorporated many more of Sunlight’s Guidelines, but also broke ground in the United States municipal open data policy world -- arguably taking the title from New York City. Of significance, San Francisco’s amended ordinance creates new oversight authority to review implementation of their open data policy requirements (Sunlight guideline #27) by creating the position of Chief Data Officer (CDO) and requiring the appointment of Department Data Coordinators (DCs) to assist in the implementation of San Francisco’s open data policy. The CDO is tasked with working with DCs to create an open data plan for each Department including: “a timeline for the publication of the Department’s open data and a summary of open data efforts” (#22) and “a summary description of all data sets under the control of each Department” (#18). The CDO is also responsible for creating an annual citywide implementation plan, while each department is delegated to conduct quarterly reviews of their progress, the combination of which sets up procedural expectations that help ensure data quality (#17). The amended language also calls on the CDO to produce analytics on the use of San Francisco’s data portal, DataSF, (as recommended by guideline #32 and incredibly important in determining usefulness and in cost benefit analysis), but unfortunately does spell out specific requirements of these analytics.