About this Dataset

SFEC Campaign Consultant Report

A. SUMMARY Each campaign consultant must register with the Ethics Commission by filing a registration report and one or more client authorization statements. To remain active, campaign consultants must file a re-registration report annually no later than January 1st. Each quarter, campaign consultants must file a disclosure report. A campaign consultant must comply with these reporting requirements until the campaign consultant ceases all activity as a campaign consultant and files both a client termination statement for each respective client and a statement of termination with the Ethics Commission. A statement of termination must include all information required of the disclosure report for the period since the campaign consultant's last disclosure report. For more information, visit the Ethics Commission’s webpage on Campaign Consultants. B. HOW THE DATASET IS CREATED Data for this dataset is created when campaign consultants electronically file the following reports: Form 1 – Registration Report Form 2 – Re-registration Report Form 3 – Quarterly Disclosure Report for Campaign Consultants Form 6 – Campaign Consultant Termination Statement This dataset contains reports filings starting from 2025, when electronic filing of campaign consultant reports will be required. C. UPDATE PROCESS The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants. D. HOW TO USE THIS DATASET The unique row identifier for this dataset is “Entry Id”. Depending on the type of report (“ReportType”), not all columns will contain data because of different reporting requirements for the reports. E. RELATED DATASETS For data on campaign consultant client registration history, visit SFEC Campaign Consultant Client Authorization and Termination Statement.
Organization: City of San Francisco
Last updated: 2025-03-29T17:01:50.815504

Tables

Table 1

@usgov.city_of_san_francisco_sfec_campaign_consultant_report.table_1

58.93 KB
90 rows
45 columns


CREATE TABLE table_1 (
  "filing_series" VARCHAR,
  "date_signed" VARCHAR,
  "filinginformation_originalfilingdate" TIMESTAMP,
  "filinginformation_reporttype" VARCHAR,
  "filinginformation_filingtype" VARCHAR,
  "filinginformation_reportingperiodstartdate" TIMESTAMP,
  "filinginformation_reportingperiodenddate" TIMESTAMP,
  "filinginformation_descriptionofamendment" VARCHAR,
  "campaignconsultantname" VARCHAR,
  "campaignconsultantbusinessaddress_streetaddress" VARCHAR,
  "campaignconsultantbusinessaddress_city" VARCHAR,
  "campaignconsultantbusinessaddress_state" VARCHAR,
  "campaignconsultantbusinessaddress_postalcode" BIGINT,
  "campaignconsultantbusinessaddress_fulladdress" VARCHAR,
  "campaignconsultantinformation_typeofcampaignconsultant" VARCHAR,
  "campaignconsultantinformation_phone" VARCHAR,
  "employerinformation_employername" VARCHAR,
  "employerinformation_address_streetaddress" VARCHAR,
  "employerinformation_address_city" VARCHAR,
  "employerinformation_address_state" VARCHAR,
  "employerinformation_address_postalcode" DOUBLE,
  "employerinformation_address_fulladdress" VARCHAR,
  "employerinformation_employertelephone" VARCHAR,
  "employerinformation_descriptionbusinessactivity" VARCHAR,
  "employerinformation_isthecampaignconsultantselfemployed" BOOLEAN,
  "employeeinformation_hasemployedanyindividuals" BOOLEAN,
  "acknowledgements_lobbyistregistration" VARCHAR,
  "acknowledgements_codeofconductstatement" VARCHAR,
  "acknowledgements_acknowledgereceivedcopies" BOOLEAN,
  "clientinformation_hasclients" BOOLEAN,
  "clientinformation_total" DOUBLE,
  "politicalcontributions_totalunitemizedcontributions" BIGINT,
  "politicalcontributions_didconsultantmakecontributions" BOOLEAN,
  "politicalcontributions_subtotalofitemizedcontributions" BIGINT,
  "politicalcontributions_totalcontributions" BIGINT,
  "giftsmadetolocalofficeholders_total" BIGINT,
  "giftsmadetolocalofficeholders_didcampaignconsultantmakegifts" BOOLEAN,
  "vendorsandsubvendors_hasvendors" BOOLEAN,
  "vendorsandsubvendors_total" DOUBLE,
  "employmentoflocalofficeholdersandcityemployees_hasempl_2c92b68c" BOOLEAN,
  "citycontracts_hascitycontracts" BOOLEAN,
  "citycontracts_total" BIGINT,
  "cityappointments_hascityappointments" BOOLEAN,
  "envelope_id" VARCHAR,
  "docusign_filing" VARCHAR
);