About this Dataset

Campaign Finance - Summary Of Third Party Disclosure Forms Regarding San Francisco Candidates - November 6, 2012

San Francisco Campaign and Governmental Conduct Code ("S.F. C&GC Code") sections 1.143(c), 1.152(a)(3), 1.161(b), 1.161.5, and 1.160.5 require persons who make any independent expenditure, electioneering communication, or member communication that clearly identifies a candidate for City elective office or who authorizes, administers or pays for a persuasion poll to file disclosure statements with the Ethics Commission. For detailed instructions, please see Third Party Disclosure Form Regarding Candidates.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:46.273870
Tags: 2012, campaign, candidates, disclosure, election, ethics, finance, november, third-party

Tables

Table 1

@usgov.city_of_san_francisco_campaign_finance_summary_of_thir_f4b0eda9.table_1

13.15 kB
151 rows
11 columns

CREATE TABLE table_1 (
  "reference_no" VARCHAR  -- Reference No.,
  "date_filed" TIMESTAMP,
  "filer" VARCHAR,
  "filer_id" BIGINT,
  "amount" DOUBLE,
  "candidate_identified" VARCHAR,
  "district" DOUBLE,
  "support_oppose_or_neutral" VARCHAR  -- Support, Oppose Or Neutral,
  "start_date_of_distribution" TIMESTAMP,
  "end_or_only_date_of_distribution" TIMESTAMP,
  "notes" VARCHAR
);