About this Dataset

Lobbyist Directory

A. SUMMARY This is a directory of lobbyists registered with the Ethics Commission. Learn more about the lobbyist program at the SF Ethics Commission 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. B. HOW THE DATASET IS CREATED Lobbyists are required to register and file regular statements with the Ethics Commission. This dataset is updated with the lobbyist filings. The live lobbyist system can be accessed as well. C. UPDATE PROCESS This dataset is updated with a sync script that checks nightly for new filings. Lobbyists are required to register and file monthly statements. D. HOW TO USE THIS DATASET Only the most recent firm for a lobbyist is displayed.
Organization: City of San Francisco
Last updated: 2021-08-07T18:37:21.659916
Tags: ethics, lobbyist

Tables

Table 1

@usgov.city_of_san_francisco_lobbyist_directory.table_1

28.59 kB
539 rows
6 columns

CREATE TABLE table_1 (
  "lobbyist_id" VARCHAR,
  "lobbyist_name" VARCHAR,
  "firm_name" VARCHAR,
  "lobbyist_type" VARCHAR,
  "initial_registration_date" TIMESTAMP,
  "most_recent_filing" TIMESTAMP
);