Baselight

Campaign Consultants - Client Payments

City of San Francisco

@usgov.city_of_san_francisco_campaign_consultants_client_payments

Loading...
Loading...

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
  • 74.13 KB
  • 1836 rows
  • 9 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.