Lobbyist Database API
Since January 2010, lobbyists registered with the Ethics Commission have been required to file monthly electronic disclosure statements that include contact information, client lists, activity expenses, contacts of public officials, political contributions, and payments promised by clients. The contents of the disclosure statements are accessible on the Ethics Commission's lobbyist web site.
The Ethics Commission is now making the disclosure statements accessible to application developers via a Lobbyist Database Application Programming Interface (API). The API returns Javascript Object Notation (JSON) from GET requests. The following methods are accessible from the API:
Insert the required variable in the URL where { } are provided below. The { } should be removed from the URL after inserting a variable.
All Filers by Year
This method returns all lobbyists that have filed at least one statement in the calendar year and includes contact information, filer ID, and current status.
- http://system.netfile.com/Sunlight/Api/Lobbyist/Sf/v10/Filers/{year}
All Filings by Filer
This method returns a list of all filings filed by a lobbyist filer with the Commission. The lookup filer ID is obtained using the prior method.
- http://system.netfile.com/Sunlight/Api/Lobbyist/Sf/v10/Filers/{filerId}/Filings
All Clients and Entities Reported on a Filing
These methods return all clients or entities reported on a particular filing. The filing ID is obtained using the prior method. A "Full Name" is the name of the client or entity as reported by the lobbyist. The "Mapped Name" is the name of the client or entity as corrected by Commission staff for the purposes of consistent spelling or mapping Aides to the correct member of the Board of Supervisors.
- http://system.netfile.com/Sunlight/Api/Lobbyist/Sf/v10/Filings/{filingId}/Clients
- http://system.netfile.com/Sunlight/Api/Lobbyist/Sf/v10/Filings/{filingId}/Entities
All Contacts of a Public Official, Political Contributions, Activity Expenses, and Payments Promised by Clients Reported on a Filing
These methods return all Contacts of a Public Official, Political Contributions, Activity Expenses, and Payments Promised by Clients reported on a particular filing. The filing ID is obtained using the "All Filings by Filer" method.
- http://system.netfile.com/Sunlight/Api/Lobbyist/Sf/v10/Filings/{filingId}/ContactsOfPublicOfficials
- http://system.netfile.com/Sunlight/Api/Lobbyist/Sf/v10/Filings/{filingId}/PoliticalContributions
- http://system.netfile.com/Sunlight/Api/Lobbyist/Sf/v10/Filings/{filingId}/ActivityExpenses
- http://system.netfile.com/Sunlight/Api/Lobbyist/Sf/v10/Filings/{filingId}/PaymentsPromisedByClients
Lobbyist Photos
At the time of registration with the Ethics Commission, lobbyists must supply a digital color photograph of the lobbyist's head and shoulders. All photos are stored in JPEG format at 130 x 150 pixels. Lobbyist photographs are stored using the following URL format:
- http://system.netfile.com/Sunlight/sf/lobbyist/picture/{year}/1/{filerId}
Monitor New Lobbyist Filings
New lobbyist filings can also be tracked by monitoring the following RSS feed. The feed is updated when a new filing is accessible in the database.
- http://system.netfile.com/Sunlight/sf/Lobbyist/FilingRSSFeed
Assistance with the API
For additional assistance, please contact the Ethics Commission at ethics.commission@sfgov.org or at 415-252-3100.