About this Dataset

[Historical] Campaign Consultants Filings

A. SUMMARY This is a historical record of campaign consultant filings. Filings since December 2024 can be found in the SFEC Campaign Consultant Report dataset. B. HOW THE DATASET IS CREATED This is historical data. C. UPDATE PROCESS No updates will occur. D. HOW TO USE THIS DATASET This dataset contains a historic record of filings. Campaign Consultant filings were submitted on paper, and the data within the filings was manually entered into the following related datasets:

New Campaign Consultant filings are e-filed, and can be found on the SFEC Campaign Consultant Report dataset. For more information on the Campaign Consultant program, refer to the SF Ethics Commission website pages on reporting and disclosures.
Organization: City of San Francisco
Last updated: 2025-05-03T18:14:22.057738

Tables

Table 1

@usgov.city_of_san_francisco_historical_campaign_consultants__e4aab086.table_1

350.26 kB
4,972 rows
12 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "filername" VARCHAR,
  "filing_id" DOUBLE,
  "url" VARCHAR,
  "type" VARCHAR,
  "deadline" TIMESTAMP,
  "start" TIMESTAMP,
  "end" TIMESTAMP,
  "istermination" BOOLEAN,
  "isamendment" BOOLEAN,
  "amends" VARCHAR,
  "id" VARCHAR
);