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).

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 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,

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:,

San Francisco Campaign and Governmental Conduct Code ("S.F. C&GC Code") sections 1.143(c), 1.152(a)(3), 1.161(b), 1.161.5, and 1.160.5 require persons who make any independent expenditure, electioneering communication, or member communication that clearly identifies a candidate for City elective office or who authorizes, administers or pays for a persuasion poll to file disclosure statements with the Ethics Commission. For detailed instructions, please see Third Party Disclosure Form Regarding Candidates.

Under San Francisco Campaign & Governmental Conduct Code Section 1.124, any committee required to file campaign statements with the Ethics Commission must disclose certain additional information no later than the deadline for filing semi-annual or pre-election statements any contribution(s) that, in the aggregate, total $10,000 or more from a single business entity in a single election cycle. For the purposes of this disclosure, the committee must disclose one of the business entity’s principal officers, including but not limited to the Chair of the Board of Directors, President, Vice President, CEO, CFO, COO, Executive Director, Deputy Director, or equivalent positions. The committee must also disclose whether, within the 24 months prior to the date the entity’s contributions to the committee totaled $10,000 or more, the business entity received funds through a contract or grant from any City agency for a project within the jurisdiction of the City and County of San Francisco. If such contract or grant exists, the committee must disclose the name of the agency and the value of the contract or grant. For more information visit www.sfethics.org. Each row on this table represents the contents of a Form 124 filed with the Ethics Commission. There is one sub-tables of information on Form 124: Contracts and Grants. The sub-table is available in a separate dataset: "SFEC Form 124 - Contributions Made by Business Entities - Contracts and Grants" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-124-Contributions-Made-by-Business-Entit/ssx6-3d9r. Join this dataset with the sub-table using the DocuSignID.

Financial Analysis of election campaign.

A listing of campaign public funds payments for candidates for City office during the 2005 election cycle

This dataset lists the audit determinations that the New York City Campaign Finance Board has imposed on New York City political campaigns from the year 2000 to the present.