About this Dataset

Lobbyist Filings Directory

A. SUMMARY This is a directory of lobbyist statements filed with the Ethics Commission. Learn more about the lobbyist program at the SF Ethics Commission website. 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. D. HOW TO USE THIS DATASET This dataset contains the metadata for all filings received. An individual filing can be amended by a lobbyist, superseding the content of the original filing.
Organization: City of San Francisco
Last updated: 2021-08-07T18:51:58.785730
Tags: ethics, lobbyist

Tables

Table 1

@usgov.city_of_san_francisco_lobbyist_filings_directory.table_1

3.17 MB
31,303 rows
16 columns

CREATE TABLE table_1 (
  "filing_date" VARCHAR,
  "lobbyist_name" VARCHAR,
  "firm_name" VARCHAR,
  "lobbyist_type" VARCHAR,
  "filing_type" VARCHAR,
  "period_start_date" VARCHAR,
  "period_end_date" VARCHAR,
  "period" VARCHAR,
  "filing_id" VARCHAR,
  "lobbyist_id" VARCHAR,
  "agency_filing_id" BIGINT,
  "document" VARCHAR,
  "amends" VARCHAR,
  "amendment_sequence_number" BIGINT,
  "is_superceded" BOOLEAN,
  "is_termination" BOOLEAN
);