Icon for Socrata external plugin
Open repository in Console
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" \
{"sql": "
    SELECT *
    FROM \"oaklandca-gov/lobbyist-activity-political-contributions-schedule-xvc7-ctj7\".\"lobbyist_activity_political_contributions_schedule\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • lobbyist_activity_political_contributions_schedule