About this Dataset

Campaign Finance - Summary Totals

A. SUMMARY This dataset contains current summary information for electronically filed FPPC campaign forms. The columns in this dataset correspond to the figures reported on the summary page of FPPC forms 450, 460, 461, and 465. Refer to the FPPC Forms represented in this dataset. B. HOW THE DATASET IS CREATED Committees file campaign statements with the Ethics Commission on a periodic basis. Those statements are stored with the Commission's provider. Data is generally presented as-filed by committees. If a committee files an amendment, the data from that filing completely replaces the original and any prior amendments in the filing sequence. C. UPDATE PROCESS Each night starting at midnight Pacific time a script runs to check for new filings with the Commission's database, and updates this dataset with transactions from new filings. The update process can take a variable amount of time to complete. Viewing or downloading this dataset while the update is running may result in incomplete data, therefore it is highly recommended to view or download this data before midnight or after 8am. D. HOW TO USE THIS DATASET Transactions from rejected and superseded filings are not included in this dataset. Transactions from many different FPPC forms are combined in this dataset, refer to the column "Form Type" to differentiate transaction types. A row with no value in the SyncFlag column indicates a paper filing amended an electronic filing. The SFEC is working on how to automatically deal with these cases. Properties suffixed with "-nid" can be used to join the data between Filers, Filings, and Transaction datasets. Refer to the Ethics Commission's webpage for more information. RELATED DATASETS

San Francisco Campaign Filers
Filings Received by SFEC
Summary Totals
Transactions
Organization: City of San Francisco
Last updated: 2022-04-28T05:21:25.950089
Tags: campaign-finance, ethics

Tables

Table 1

@usgov.city_of_san_francisco_campaign_finance_summary_totals.table_1

3.94 MB
16,727 rows
78 columns

CREATE TABLE table_1 (
  "form_type" VARCHAR,
  "filing_id_number" BIGINT,
  "filing_date" TIMESTAMP,
  "filing_start_date" TIMESTAMP,
  "filing_end_date" TIMESTAMP,
  "filing_type" VARCHAR,
  "filer_name" VARCHAR,
  "fppc_id" VARCHAR,
  "filer_type" VARCHAR,
  "sync_flag" VARCHAR,
  "filer_nid" BIGINT,
  "filing_nid" VARCHAR,
  "latest_filing_activity_nid" VARCHAR,
  "data_as_of" TIMESTAMP,
  "data_loaded_at" TIMESTAMP,
  "line_1_col_a" DOUBLE,
  "line_1_col_b" DOUBLE,
  "line_2_col_a" DOUBLE,
  "line_2_col_b" DOUBLE,
  "line_3_col_a" DOUBLE,
  "line_3_col_b" DOUBLE,
  "line_4_col_a" DOUBLE,
  "line_4_col_b" DOUBLE,
  "line_5_col_a" DOUBLE,
  "line_5_col_b" DOUBLE,
  "line_6_col_a" DOUBLE,
  "line_6_col_b" DOUBLE,
  "line_7_col_a" DOUBLE,
  "line_7_col_b" DOUBLE,
  "line_8_col_a" DOUBLE,
  "line_8_col_b" DOUBLE,
  "line_9_col_a" DOUBLE,
  "line_9_col_b" DOUBLE,
  "line_10_col_a" DOUBLE,
  "line_10_col_b" DOUBLE,
  "line_11_col_a" DOUBLE,
  "line_11_col_b" DOUBLE,
  "line_12_col_a" DOUBLE,
  "line_13_col_a" DOUBLE,
  "line_14_col_a" DOUBLE,
  "line_15_col_a" DOUBLE,
  "line_16_col_a" DOUBLE,
  "line_17_col_a" DOUBLE,
  "line_18_col_a" DOUBLE,
  "line_19_col_a" DOUBLE,
  "line_20_col_a" DOUBLE,
  "line_20_col_b" VARCHAR,
  "line_21_col_a" DOUBLE,
  "line_21_col_b" VARCHAR,
  "line_22a_col_a" VARCHAR,
  "line_22b_col_a" VARCHAR,
  "line_22c_col_a" VARCHAR,
  "schedule_a_line_1" DOUBLE,
  "schedule_a_line_2" DOUBLE,
  "schedule_a_line_3" DOUBLE,
  "schedule_b1_line_1" DOUBLE,
  "schedule_b1_line_2" DOUBLE,
  "schedule_b1_line_3" DOUBLE,
  "schedule_c_line_1" DOUBLE,
  "schedule_c_line_2" DOUBLE,
  "schedule_c_line_3" DOUBLE,
  "schedule_d_line_1" DOUBLE,
  "schedule_d_line_2" DOUBLE,
  "schedule_d_line_3" DOUBLE,
  "schedule_e_line_1" DOUBLE,
  "schedule_e_line_2" DOUBLE,
  "schedule_e_line_3" DOUBLE,
  "schedule_e_line_4" DOUBLE,
  "schedule_f_line_1" DOUBLE,
  "schedule_f_line_2" DOUBLE,
  "schedule_f_line_3" DOUBLE,
  "schedule_h_line_1" DOUBLE,
  "schedule_h_line_2" DOUBLE,
  "schedule_h_line_3" DOUBLE,
  "schedule_i_line_1" DOUBLE,
  "schedule_i_line_2" DOUBLE,
  "schedule_i_line_3" DOUBLE,
  "schedule_i_line_4" DOUBLE
);