A. SUMMARY Transactions from FPPC Forms 460, 461, 496, 497, and 450. This dataset combines all schedules, pages, and includes unitemized totals. Only transactions from the "most recent" version of a filing (original/amendment) appear here. 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 data 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. During the update, some fields are copied from the Filings dataset into this dataset for viewing convenience. The copy process may occasionally fail for some transactions due to timing issues but should self-correct the following day. Transactions with a blank 'Filing Id Number' or 'Filing Date' field are such transactions, but can be joined with the appropriate record using the 'Filing Activity Nid' field shared between Filing and Transaction datasets. D. HOW TO USE THIS DATASET Transactions from rejected filings are not included in this dataset. Transactions from many different FPPC forms and schedules are combined in this dataset, refer to the column "Form Type" to differentiate transaction types. 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. Fppc Form460 is organized into Schedules as follows:,

A. SUMMARY This dataset lists the current campaign filings received by the SFEC; Campaign forms include FPPC forms 410, 450, 460, 461, 465, 470, 496, 497. Refer to the FPPC page for forms represented in this dataset. Filings of the following SFEC forms are also recorded in this dataset:,

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.

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,

The campaign finance database is the San Francisco Ethics Commission's repository for campaign finance filings. It can answer questions about who is contributing money, who is receiving money, and how it is being spent. Use the campaign finance database to research campaign contributions and expenditures reported on forms provided by the Fair Political Practices Commission. The database provides live access to the Ethics Commission's records. Filings are accessible once processed/posted by the Ethics Commission.Forms filed with the Ethics Commission can be downloaded in PDF format. Forms filed electronically can be searched and exported in Microsoft Excel format. The following Excel exports are available:- Excel file based on a search of itemized transactions up to 2,000 rows (Updated immediately, with the exception of FPPC filing deadlines -- within 48 hours);- Excel file by year or for entire life of a single committee (Updated immediately upon filing submission); and- Excel file by year for all committees in a single calendar year (Updated every 24 hours).

A. SUMMARY This dataset contains information about the clients section of the Campaign Consultant Report. For more information, visit the Ethics Commission’s webpage on Campaign Consultants. B. HOW THE DATASET IS CREATED Data for this dataset is created when campaign consultants electronically file the following reports with client information: Form 1 – Registration Report Form 3 – Quarterly Disclosure Report for Campaign Consultants Form 6 – Campaign Consultant Termination Statement This dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required. C. UPDATE PROCESS The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants. D. HOW TO USE THIS DATASET The unique row identifier for a client entry is “Entry Id”. This dataset should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”. E. RELATED DATASETS For detail reporting on campaign consultant activities, visit SFEC Campaign Consultant Report.

A. SUMMARY This dataset contains information about the Vendors and Subvendors section of the Campaign Consultant Report. For more information, visit the Ethics Commission’s webpage on Campaign Consultants. B. HOW THE DATASET IS CREATED Data for this dataset is created when campaign consultants electronically file the following reports with vendors information: Form 3 – Quarterly Disclosure Report for Campaign Consultants Form 6 – Campaign Consultant Termination Statement This dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required. C. UPDATE PROCESS The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants. D. HOW TO USE THIS DATASET The unique row identifier for a vendor entry is “Entry Id”. This dataset should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”. E. RELATED DATASETS For detail reporting on campaign consultant activities, visit SFEC Campaign Consultant Report.

Campaign finance reports from 2019 to the present: The tables below show different cuts of the campaign finance reports data related to Philadelphia elections provided by filers (including candidates and political committees) about their contributions, expenditures and debt. You can explore an [interactive dashboard](https://www.phila.gov/cf-dashboard) that visualizes much of this data, use the [video tutorial](https://ethics.pub/CFvizdemo) to learn how to navigate the dashboard, or read the [technical document](https://docs.google.com/document/d/1VzeY_HJOATS17pE4639OZq0fhrF7Jppps-Mc3dZhDqY/edit?usp=sharing) to understand how we compiled the data and dashboard. If you want to use the raw, unfiltered data, please visit the [searchable database](https://apps.phila.gov/search/all). Filers can submit reports on via the [campaign finance filing system](https://apps.phila.gov/auth).

A. SUMMARY This dataset contains information about the Employment of Local Officeholders and City Employees section of the Campaign Consultant Report. For more information, visit the Ethics Commission’s webpage on Campaign Consultants. B. HOW THE DATASET IS CREATED Data for this dataset is created when campaign consultants electronically file the following reports with employment information: Form 3 – Quarterly Disclosure Report for Campaign Consultants Form 6 – Campaign Consultant Termination Statement This dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required. C. UPDATE PROCESS The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants. D. HOW TO USE THIS DATASET The unique row identifier for an employment entry is “Entry Id”. This dataset should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”. E. RELATED DATASETS For detail reporting on campaign consultant activities, visit SFEC Campaign Consultant Report.

A. SUMMARY This dataset contains information about the City Contracts section of the Campaign Consultant Report. For more information, visit the Ethics Commission’s webpage on Campaign Consultants. B. HOW THE DATASET IS CREATED Data for this dataset is created when campaign consultants electronically file the following reports with city contract information: Form 3 – Quarterly Disclosure Report for Campaign Consultants Form 6 – Campaign Consultant Termination Statement This dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required. C. UPDATE PROCESS The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants. D. HOW TO USE THIS DATASET The unique row identifier for a city contract entry is “Entry Id”. This dataset should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”. E. RELATED DATASETS For detail reporting on campaign consultant activities, visit SFEC Campaign Consultant Report.