About this Dataset

Campaign Finance Explorer App

This dataset provides the monetary contribution souce data for the campaign finance explorer app at https://data.sfgov.org/campaign_finance.
Learn more about San Francisco campaign finance at https://sfethics.org.
Data comes from campaign filings with the San Francisco Ethics Commission, specifically FPPC Form 460 Schedule A and FPPC Form 497 filings for committees formed to support or oppose candidates and ballot measures in the November 3, 2020 election.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:20.223079
Tags: ethics

Tables

Table 1

@usgov.city_of_san_francisco_campaign_finance_explorer_app.table_1

321.97 kB
13,028 rows
19 columns

CREATE TABLE table_1 (
  "filer_id" VARCHAR,
  "committee_name" VARCHAR,
  "candidate_name" VARCHAR,
  "contributor_type" VARCHAR,
  "amount_of_contribution" DOUBLE,
  "contribution_date" TIMESTAMP,
  "contributor_name" VARCHAR,
  "contributor_city" VARCHAR,
  "contributor_state" VARCHAR,
  "contributor_zip" VARCHAR,
  "election_date" TIMESTAMP,
  "office" VARCHAR,
  "new_georeferenced_column" VARCHAR,
  "election_year" BIGINT,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE
);