About this Dataset

Campaign Finance - Summary Financial Data For Committees Controlled By Candidates For Mayor - November 8, 2011 Election

This dataset contains the financial summary information reported on Fair Political Practices Commission Form 460 by committees controlled by candidates running for Mayor in the November 8, 2011 election. The data covers the period of 2009-2011 and is current as of 3/8/2012.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:25.872485
Tags: 2011, campaign, cash, contributions, election, expenditures, finance, loans, mayor

Tables

Table 1

@usgov.city_of_san_francisco_campaign_finance_summary_financi_55f35892.table_1

23.02 kB
2,555 rows
11 columns

CREATE TABLE table_1 (
  "fppc_filer_id" BIGINT,
  "committee_name" VARCHAR,
  "candidate_name" VARCHAR,
  "report_version_number" BIGINT,
  "report_date" TIMESTAMP,
  "period_start_date" TIMESTAMP,
  "period_end_date" TIMESTAMP,
  "schedule" VARCHAR,
  "line_item" VARCHAR,
  "total_this_period" DOUBLE,
  "calendar_year_total_to_date" DOUBLE
);