About this Dataset

SFEC Campaign Consultant Report - City Officeholders & Employees

A. SUMMARY This dataset contains information about the Employment of Local Officeholders and City Employees section of the Campaign Consultant 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 with employment information: Form 3 – Quarterly Disclosure Report for Campaign Consultants Form 6 – Campaign Consultant Termination Statement This dataset contains reports filings starting from December 9, 2024, 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 an employment entry is “Entry Id”. This dataset should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”. E. RELATED DATASETS For detail reporting on campaign consultant activities, visit SFEC Campaign Consultant Report.
Organization: City of San Francisco
Last updated: 2025-03-29T16:57:39.094665

Tables

Table 1

@usgov.city_of_san_francisco_sfec_campaign_consultant_report__97ac8009.table_1

10.88 kB
1 row
11 columns

CREATE TABLE table_1 (
  "localofficeholderandcityemployeeslist_name_first" VARCHAR,
  "localofficeholderandcityemployeeslist_name_last" VARCHAR,
  "localofficeholderandcityemployeeslist_department" VARCHAR,
  "localofficeholderandcityemployeeslist_title" VARCHAR,
  "localofficeholderandcityemployeeslist_describethenatur_00f56c41" VARCHAR  -- LocalOfficeholderAndCityEmployeesList DescribeTheNatureOfServices,
  "localofficeholderandcityemployeeslist_wasemployedbyaclient" BOOLEAN,
  "localofficeholderandcityemployeeslist_nameofclient" VARCHAR,
  "localofficeholderandcityemployeeslist_dateofemployment" VARCHAR,
  "envelope_id" VARCHAR,
  "entry_id" VARCHAR,
  "filingseries" VARCHAR
);