Baselight

SFEC Campaign Consultant Client Authorization And Termination Statement

City of San Francisco

@usgov.city_of_san_francisco_sfec_campaign_consultant_client__e63874ef

Loading...
Loading...

About this Dataset

SFEC Campaign Consultant Client Authorization And Termination Statement

A. SUMMARY At the time of initial registration, a campaign consultant must submit a separate Authorization Statements for each client. If the client retains the campaign consultant's services after the date of initial registration, The Authorization Statement must be submitted before providing any campaign consulting services to the client and before receiving any economic consideration from the client in exchange for campaign consulting services. The Authorization Statement must be submitted no later than 15 days after being retained by a client to provide campaign consulting services. Once a campaign consultant's services to a client are terminated, a Termination Statement must be submitted to the Ethics Commission within 30 days. After a Termination Statement is submitted, a campaign consultant may not provide campaign consulting services to--or accept economic consideration for campaign consulting services from--the client until a new Authorization Statement has been filed. 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 their Authorization and Termination Statements starting on December 9, 2024. 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 this dataset is “Envelope Id”. Depending on the type of statement (“TypeOfStatement”), not all columns will contain data because of different reporting requirements for each statement. 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:52:14.540998

Tables

Table 1

@usgov.city_of_san_francisco_sfec_campaign_consultant_client__e63874ef.table_1
  • 42.87 KB
  • 59 rows
  • 31 columns
Loading...

CREATE TABLE table_1 (
  "filing_series" VARCHAR,
  "date_signed" VARCHAR,
  "fullnameofcampaignconsultanttosignstatement" VARCHAR,
  "campaignconsultantinformation_nameofcampaignconsultant" VARCHAR,
  "filinginformation_typeofstatement" VARCHAR,
  "campaignconsultantinformation_startdate" TIMESTAMP,
  "campaignconsultantinformation_terminationdate" TIMESTAMP,
  "clientinformation_nameofclient" VARCHAR,
  "clientinformation_clientbusinessaddress_city" VARCHAR,
  "clientinformation_clientbusinessaddress_fulladdress" VARCHAR,
  "clientinformation_clientbusinessaddress_postalcode" BIGINT,
  "clientinformation_clientbusinessaddress_state" VARCHAR,
  "clientinformation_clientbusinessaddress_streetaddress" VARCHAR,
  "clientinformation_clientbusinessphone" VARCHAR,
  "clientinformation_currentcityofficeheldifapplicable" VARCHAR,
  "clientinformation_officesought" VARCHAR,
  "clientinformation_measurename" VARCHAR,
  "clientinformation_committeename" VARCHAR,
  "clientinformation_candidateormeasure" VARCHAR,
  "filinginformation_typeoffiling" VARCHAR,
  "filinginformation_dateoforiginalfiling" TIMESTAMP,
  "filinginformation_descriptionofamendment" VARCHAR,
  "clientstilloweanypaymentstermination" BOOLEAN,
  "additionalpaymentsowed_datepaymentsdue" TIMESTAMP,
  "additionalpaymentsowed_effortstocollectthepayments" VARCHAR,
  "additionalpaymentsowed_willchargeinterest" BOOLEAN,
  "additionalpaymentsowed_termsandrateofinterest" VARCHAR,
  "additionalpaymentsowed_hasreducedorforgave" BOOLEAN,
  "additionalpaymentsowed_termsandamountofthediscount" VARCHAR,
  "envelope_id" VARCHAR,
  "docusign_filing" VARCHAR
);

Share link

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