Campaign Consultants - Appointment To Public Office by US Government | Politics and Governance

About this Dataset

Campaign Consultants - Appointment To Public Office

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 the campaign consultant is appointed to public office during the reporting period and the appointment is made by a local officeholder who is the campaign consultant's client, the campaign consultant must report the public office to which the filer was appointed, the date of the appointment, and the name of the officeholder who appointed the campaign consultant.��
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:55.454996
Tags: appointments, campaign-consultant, ethics, public-office

Tables

Table 1

@usgov.city_of_san_francisco_campaign_consultants_appointment_835f2fe8.table_1

7.88 KB
1 row
10 columns


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