Icon for Socrata external plugin
Open repository in Console
Updated over 8 years ago
Indexed 2 hours ago

2014 Lobbyist Directory

Directory of registered lobbyists and their respective clients. This list includes both current and past clients for each lobbyist. Lobbyist clients are disclosed by lobbyists registered with the Public Ethics Commission on a quarterly basis in compliance with the Lobbyist Registration 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" \
{"sql": "
    SELECT *
    FROM \"oaklandca-gov/2014-lobbyist-directory-7jq6-spyn\".\"2014_lobbyist_directory\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • 2014_lobbyist_directory