Lobbyist Directory

<strong>A. SUMMARY</strong>

This is a directory of lobbyists registered with the Ethics Commission. Learn more

about the lobbyist program at the <a href="https://sfethics.org/guidance/lobbyists">SF

Ethics Commission</a> website. Contact and Expenditure Lobbyists both show up in this

dataset. Lobbyists active only prior to 2018 were not required to file a "Registration"

type statement, and will not appear in this dataset. Those lobbyist's filings and

activities will still appear in the corresponding lobbyst datasets.

<strong>B. HOW THE DATASET IS CREATED</strong>

Lobbyists are required to register and file regular statements with the Ethics Commission.

This dataset is updated with the lobbyist filings. The <a href="https://netfile.com/lobbyistpub/#sfo">live

lobbyist system</a> can be accessed as well.

<strong>C. UPDATE PROCESS</strong>

This dataset is updated with a sync script that checks nightly for new filings. Lobbyists are required to register and file monthly statements.

<strong>D. HOW TO USE THIS DATASET</strong>

Only the most recent firm for a lobbyist is displayed.

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 \"sfgov/lobbyist-directory-b947-pj2q\".\"lobbyist_directory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.