About this Dataset

Campaign Finance - San Francisco Campaign Filers

A. SUMMARY This dataset contains a list of active and terminated campaign committees and non-committee campaign finance filers in the Ethics Commission's records database. B. HOW THE DATASET IS CREATED This dataset comes from an export of the Ethics Commission's filer database. C. UPDATE PROCESS Each night starting at midnight Pacific time a script runs replacing this dataset with a complete list of all filers within the Ethics Commission's filing database. This 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 The "Filer Name" is the most current version of a committee name as registered with the Ethics Commission. Properties suffixed with "-nid" can be used to join the data between Filers, Filings, and Transaction datasets. The California Secretary of State issues "FPPCIds" to committees when registering. After the committee registers with the SOS, the committee can file a courtesy copy of their registration with the Ethics Commission. Until that filing is received, committees' fppcids may appear as "pending". Committees are (generally) only required to register with the Ethics Commission if they participating in local elections. 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:11.936197
Tags: campaign-finance, ethics

Tables

Table 1

@usgov.city_of_san_francisco_campaign_finance_san_francisco_c_030954e0.table_1

229.96 KB
5155 rows
12 columns


CREATE TABLE table_1 (
  "filer_nid" BIGINT,
  "fppc_id" VARCHAR,
  "filer_name" VARCHAR,
  "filer_type" VARCHAR,
  "status" VARCHAR,
  "is_terminated" BOOLEAN,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "candidate_name" VARCHAR,
  "data_as_of" TIMESTAMP,
  "data_loaded_at" TIMESTAMP
);