The dataset contains descriptions for each column of historical campaign finance data available on data.sfgov.org or the Excel exports on the Ethics Commission's Campaign Finance Database at http://nf4.netfile.com/pub2?aid=sfoPlease note -- the column header names on different schedules of Form 460 often match, but sometimes have different meanings.

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