Campaign Finance Expenditures Explorer App by US Government | Finance and Economics

About this Dataset

Campaign Finance Expenditures Explorer App

A. SUMMARY This dataset provides the expenditure source 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. B. HOW THE DATASET IS CREATED Data comes from campaign filings with the San Francisco Ethics Commission, specifically FPPC Form 460 Schedule E filings for committees formed to support or oppose candidates and ballot measures in the November 3, 2020 election. C. UPDATE PROCESS The data comes from campaign filings due on a semi-annual basis, refer to the FPPC filing schedule. D. HOW TO USE THIS DATASET Some committees may have submitted amendments to the SFEC since the last update to this dataset. The next update is scheduled for August 1, 2021. For the most up-to-date numbers, see the Ethics Commission website.
Organization: City of San Francisco
Last updated: 2021-08-07T18:54:08.110321
Tags: campaign-finance, ethics

Tables

Table 1

@usgov.city_of_san_francisco_campaign_finance_expenditures_ex_2db6a56e.table_1

96.87 KB
6429 rows
12 columns


CREATE TABLE table_1 (
  "filer_id" VARCHAR,
  "candidate_name" VARCHAR,
  "election_date" BIGINT,
  "recipient_name" VARCHAR,
  "amount_of_expenditure" DOUBLE,
  "expenditure_date" VARCHAR,
  "expenditure_type" VARCHAR,
  "expenditure_description" VARCHAR,
  "recipient_city" VARCHAR,
  "recipient_state" VARCHAR,
  "recipient_zip" DOUBLE,
  "office" VARCHAR
);