Lobbyist Activity - Contacts with Public Officials (Schedule A)

This dataset includes contacts with City Officials by lobbyists to influence a governmental (municipal) decision on behalf of a client or employer listed in Schedule A 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-contacts-with-public-officials-ucs9-a92d\".\"lobbyist_activity_contacts_with_public_officials\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.