About this Dataset

Campaign Consultants - Employment Of Local Officeholders And City Employees

This dataset will no longer be updated as of March 2024, and is scheduled to be replaced with a new dataset in January of 2025. New filings are available in scanned paper format through the Ethics Commission's public disclosure portal. If a campaign consultant employs a local officeholder or City employee during the reporting period, the filer must report the name of the officeholder or City employee and describe the nature of the employment by the filer. In addition, if a client of the filer employs a local officeholder or City employee at the behest of the filer during the reporting period, the filer must report the name of the client, the name of each officeholder or City employee hired by the client, and the nature of the employment by the client.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:45.955717
Tags: campaign-consultant, city-employees, employment, ethics, local-officeholders

Tables

Table 1

@usgov.city_of_san_francisco_campaign_consultants_employment__c71f15c8.table_1

7.82 kB
9 rows
9 columns

CREATE TABLE table_1 (
  "campaign_consultant" VARCHAR,
  "employee" VARCHAR,
  "position" VARCHAR,
  "department" VARCHAR,
  "city_position" VARCHAR,
  "quarter_start_date" VARCHAR,
  "quarter_end_date" VARCHAR,
  "year" BIGINT,
  "quarter" BIGINT
);