A. SUMMARY This dataset combines the names of Entities, Affiliates, and Subcontractors which are reported on Form 126f4 or 126f2. Candidates for City elective office are prohibited under certain circumstances from accepting campaign contributions from parties named on Form 126f2 or 126f4. For more information, visit the Ethics Commission's City Contracts page. B. HOW THE DATASET IS CREATED During the contracting process, department contracting officers enter information into the City's ServiceNow system of record. City elective officers or their representatives are sent approval requests at the appropriate stage, which are recorded as Filings with the Ethics Commission. After a filing is approved or completed, records of the filing will appear on this dataset. Each City agency seeking to enter into a contract that has a total anticipated or actual value of $100,000 or more must file form 126f2 with the Ethics Commission within 30 days of the submission of a proposal. Each City elective officer who approves a contract that has a total anticipated or actual value of $100,000 or more must file form 126f4 with the Ethics Commission within five business days of approval by: (a) the City elective officer, (b) any board on which the City elective officer serves, or (c) the board of any state agency on which an appointee of the City elective officer serves. C. UPDATE PROCESS The data is automatically extracted from ServiceNow on a nightly schedule. D. HOW TO USE THIS DATASET Certain columns are only applicable to the 126f2, while others are only applicable to the 126f4; Refer to the column descriptions. A single filing of the 126f form may appear on multiple rows of this dataset, with each row representing a unique affiliate or contractor associated with the contract. The column "Office or Board" indicates the elected office to which the political contributions prohibition is applied. E. RELATED DATASETS For 126F filings that were previously submitted via DocuSign: 126f4 - Contract Approvals List 126f2 - Notifications of Submission of Proposal

City candidates and elected officeholders are subject to detailed public disclosure requirements regarding their political fundraising activities. Contributions are from Recipient Committee Campaign Statements (CA460) filed online by officeholders and candidates since October 2001. (NOTE: Records on Schedule I are "Misc. Increases to Cash" and should not be totaled with contribution records in schedules A, B, and C.)

Each City elective officer who approves a contract that has a total anticipated or actual value of $100,000 or more must file this form with the Ethics Commission within five business days of approval by: (a) the City elective officer, (b) any board on which the City elective officer serves, or (c) the board of any state agency on which an appointee of the City elective officer serves. For more information, see: https://sfethics.org/compliance/city-officers/contract-approval-city-officers. This dataset includes the affiliates and subcontractors on efiled SFEC Form 126 Notification of Contract Approval and SFEC 126f4 Notification of Contract Approval Filings. The Affiliates and Subcontractors dataset (https://data.sfgov.org/d/czjm-dat8/) must be joined with the parent dataset (https://data.sfgov.org/d/ite2-5y3b) using the DocuSignID to connect affiliates and subcontractors to the approved contract.

Each City elective officer who approves a contract that has a total anticipated or actual value of $100,000 or more must file this form with the Ethics Commission within five business days of approval by: (a) the City elective officer, (b) any board on which the City elective officer serves, or (c) the board of any state agency on which an appointee of the City elective officer serves. For more information, see: https://sfethics.org/compliance/city-officers/city-contracts/contract-approval-by-city-elective-officers. This dataset includes paper SFEC Form 126 Notification of Contract Approval Filings from 2002 to November 2018, electronic SFEC Form 126 Notification of Contract Approval Filings between mid-October 2018 to December 31, 2018 and SFEC Form 126f4 Notification of Contract Approval Filings beginning January 1, 2019. A copy of legacy filings without a url in the "Filing" column can be found archived on the Ethics Commission website: https://sfethics.org/ethics/category/contracts The Affiliates and Subcontractors dataset (https://data.sfgov.org/d/czjm-dat8/) must be joined with the parent dataset (https://data.sfgov.org/d/ite2-5y3b) using the DocuSignID to connect affiliates and subcontractors to the approved contract.

SFEC Form 122 must be filed whenever funds held in a candidate’s campaign account are transferred to another committee established by or on behalf of the candidate. Any contributions being transferred must be attributed to specific contributors using a “first in, first out” (FIFO) or “last in, first out” (LIFO) accounting method. This dataset contains filings as of March 2, 2020.

A. SUMMARY Section 3.217 of the Campaign and Governmental Conduct Code requires each Department Head to disclose payments that their department receives from a source that is not a federal, state, or local government and for which the department does not provide equal or greater consideration. Each department accepting gifts will disclose all gifts received during the calendar month from a source that is not a federal, state, or local government. Departments will be expected to submit one disclosure form covering all gifts received in the preceding calendar month, when applicable. This dataset provides an overview of each department filing, such as the total number of gifts and gift value, filing period, and amendments. For more information, visit the Ethics Commission’s webpage on Gifts to city departments. B. HOW THE DATASET IS CREATED Data for this dataset is created when departments file the gifts disclosure form provided by the Ethics Commission, starting in December 2024. This form is due within 15 calendar days after the end of the month the department received the gift(s). If a department has not received any gifts in a given month, no filing is necessary. C. UPDATE PROCESS The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by city departments. D. HOW TO USE THIS DATASET The unique row identifier for this dataset is “Envelope Id”. Individual filings from departments can be identified by the columns Filing Month, Filing Year, and DepartmentNameLookup. Amendment filings can be identified by the column TypeOfFiling. E. RELATED DATASETS For detailed information about individual gifts reported by departments, visit the associated dataset SFEC Departmental Gifts Disclosure List of Gifts. A combined view of both datasets is also available: SFEC Departmental Gifts Disclosure Joined View.

City candidates and elected officeholders are subject to detailed public disclosure requirements regarding their political fundraising and expenditure activities. Recipient Committee Campaign Statements (CA460) are filed online by officeholders and candidates.

This dataset lists candidates who have been certified by the Ethics Commission as eligible to receive public funds. Each row represents a qualifying or matching request by a candidate that was approved by the Ethics Commission and the amount of funds to be issued. More information about San Francisco’s public financing program for qualified City candidates, visit the Ethics Commission’s Public Financing Program page.

City candidates and elected officeholders are subject to detailed public disclosure requirements regarding their political fundraising activities. Expenditures are from Recipient Committee Campaign Statements (CA460) filed online by officeholders and candidates since October 2001.

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