Open repository in Console
Readme
Updated over 8 years ago
‧ Indexed 2 hours ago
2014 Lobbyist Activity
The name of each officer and/or staff member of the City of Oakland with whom a lobbyist made a contact. Contacts of public officials are disclosed by lobbyists registered with the Public Ethics Commission on a quarterly basis in compliance with the registered Lobbyist Act. This dataset is updated weekly.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"oaklandca-gov/2014-lobbyist-activity-gg3z-zvmb\".\"2014_lobbyist_activity\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.