About this Dataset

Campaign Consultants - Client Payments

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. Campaign Consultants are required to report economic consideration promised by or received from clients in exchange for campaign consulting services during the applicable reporting period. Economic consideration includes payments, fees, commissions, and reimbursements for expenses, gifts or anything else of value.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:55.229870
Tags: campaign-consultant, ethics, payments, promised, received

Tables

Table 1

@usgov.city_of_san_francisco_campaign_consultants_client_payments.table_1

75.91 kB
1,836 rows
9 columns

CREATE TABLE table_1 (
  "campaign_consultant" VARCHAR,
  "client" VARCHAR,
  "services_performed" VARCHAR,
  "total_payments_promised" VARCHAR,
  "total_payments_received" VARCHAR,
  "quarter_start_date" TIMESTAMP,
  "quarter_end_date" TIMESTAMP,
  "year" BIGINT,
  "quarter" BIGINT
);