Lobbyist Activity Directory

<strong>A. SUMMARY</strong>

This dataset shows activity reported by registered lobbyists on their monthly statements. Learn more about the lobbyist program at the <a href="https://sfethics.org/guidance/lobbyists">SF Ethics Commission</a> website.

Activities from both Contact and Expenditure lobbyists are combined in this dataset.

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

Lobbyists are required to register with the Ethics Commission and file monthly statements reporting their activity.

<strong>C. UPDATE PROCESS</strong>

Data from the lobbyist system is synched nightly to DataSF. If any filings have been accepted since the last update, the sync reflects new activity on those filings.

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

Activities are self reported by lobbyists on monthly statements. All types of activities are reflected on this dataset, please refer to the <a href="https://sfethics.org/compliance/lobbyists">SF Ethics Commission website</a> to learn more about the lobbyist program.

Refer to the "related content using this data" section below for links to filtered views by activity type, which limit the visible columns and may be more useful for analysis.

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-activity-directory-s4ub-8j3t\".\"lobbyist_activity_directory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.