Open repository in Console
Readme
Updated 1 month ago
‧ Indexed 2 hours ago
Lobbyist Activity - Political Contributions (Schedule D)
This dataset includes contributions to elected officials and candidates for City office solicited by lobbyists listed in Schedule D of the Quarterly Lobbyist Activity Reports submitted to the City of Oakland. The dataset only includes data from reports submitted electronically. The data is current as of the last modified date on this dataset. To see complete reports visit the Public Lobbyist Dashboard and Data Portal at: https://apps.oaklandca.gov/pec/Lobbyist_Dashboard.aspx
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/lobbyist-activity-political-contributions-schedule-xvc7-ctj7\".\"lobbyist_activity_political_contributions_schedule\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.