A. SUMMARY This dataset contains information about the 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 employee information: Form 1 – Registration Report Form 2 – Re-registration Report 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 employee entry is “Entry Id”. This data set 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 political contributions 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 political contribution 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 contribution 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 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:,

A. SUMMARY This dataset contains data from financial statements of state committees that (1) contribute to or (2) receive funds from a San Francisco committee which was Primarily Formed for a local election, or (3) filed a Late Reporting Period statement with the SFEC during the 90 days before an election. The search period for financial statements begins two years before an election and runs through the next semi-annual filing deadline. The dataset currently filters by the elections of 2024-03-05 and 2024-11-05. B. HOW THE DATASET IS CREATED During an election period, an automated script runs nightly to examine filings by Primarily Formed San Francisco committees. If a primarily formed committee reports accepting money from or giving money to a second committee, that second committee's ID number is added to a filter list. If a committee electronically files a late reporting period form with the San Francisco Ethics Commission, the committee's ID number is also included in the filter list. The filter list is used in a second step that looks for filings by committees that file with the San Francisco Ethics Commission or the California Secretary of State. This dataset shows the committees that file with the California Secretary of State. The data comes from a nightly export of the Secretary of State's database. A second dataset includes Non-Primarily Formed committees that file with the San Francisco Ethics Commission. C. UPDATE PROCESS This dataset is rewritten nightly based on data derived from campaign filings. The update script runs automatically on a timer during the 90 days before an election. Refer to the "Data Last Updated" date in the section "About This Dataset" on the landing page to see when the script last ran successfully. D. HOW TO USE THIS DATASET Transactions from all FPPC Form 460 schedules are presented together, refer to the Form Type to differentiate. Transactions with a Form Type of D, E, F, G, H, F496, or F497P2 represent expenditures or money spent by the committee. Transactions with Form Type A, B1, C, I, F496P3, and F497P1 represent receipts or money taken in by the committee. Refer to the instructions for Forms 460, 496, and 497 for more details. Transactions on Form 460 Schedules D, F, G, and H are also reported on Schedule E. When doing summary statistics use care not to double count expenditures. Transactions from FPPC Form 496 and Form 497 filings are also in this dataset. Transactions that were reported on these forms are also reported on the Form 460 at the next filing deadline. If a 460 filing deadline has passed and the committee has filed a campaign statement, transactions on filings from the late reporting period should be disregarded. This dataset only shows transactions from the most recent filing version. Committee's amendments overwrite filings which come before in sequence. Campaign Committees are required to file statements according to a schedule set out by the California Fair Political Practices Commission. Depending on timing, transactions which have occurred may not be listed as they might not have been reported yet. E. RELATED DATASETS

A. SUMMARY This dataset contains data from financial statements of campaign committees that file with the San Francisco Ethics Commission and (1) contribute to or (2) receive funds from a San Francisco committee which was Primarily Formed for a local election, or (3) filed a Late Reporting Period statement with the SFEC. Financial statements are included for a committee if they meet any of the three criteria for each election included in the search parameters and are not primarily formed for the election. The search period for financial statements begins two years before an election and runs through the next semi-annual filing deadline. The dataset currently filters by the elections of 2024-03-05 and 2024-11-05. B. HOW THE DATASET IS CREATED During an election period an automated script runs nightly to examine filings by Primarily Formed San Francisco committees. If a primarily formed committee reports accepting money from or giving money to a second committee, that second committee's ID number is added to a filter list. If a committee electronically files a late reporting period form with the San Francisco Ethics Commission, the committee's ID number is also included in the filter list. The filter list is used in a second step that looks for filings by committees that file with the San Francisco Ethics Commission or the California Secretary of State. This dataset shows the output of the second step for committees that file with the San Francisco Ethics Commission. The data comes from a nightly search of the Ethics Commission campaign database. A second dataset includes committees that file with the Secretary of State. C. UPDATE PROCESS This dataset is rewritten nightly and is based on data derived from campaign filings. The update script runs automatically on a timer during the 90 days before an election. Refer to the "Data Last Updated" date in the section "About This Dataset" on the landing page to see when the script last ran successfully. D. HOW TO USE THIS DATASET Transactions from all FPPC Form 460 schedules are presented together, refer to the Form Type to differentiate. Transactions from FPPC Form 461 and Form 465 filings are presented together, refer to the Form Type to differentiate. Transactions with a Form Type of D, E, F, G, H, F461P5, F465P3, F496, or F497P2 represent expenditures, or money spent by the committee. Transactions with Form Type A, B1, C, I, F496P3, and F497P1 represent receipts, or money taken in by the committee. Refer to the instructions for Forms 460, 496, and 497 for more details. Transactions on Form 460 Schedules D, F, G, and H are also reported on Schedule E. When doing summary statistics use care not to double count expenditures. Transactions from FPPC Form 496 and Form 497 filings are presented in this dataset. Transactions that were reported on these forms are also reported on the Form 460 at the next filing deadline. If a 460 filing deadline has passed and the committee has filed a campaign statement, transactions on 496/497 filings from the late reporting period should be disregarded. This dataset only shows transactions from the most recent filing version. Committee amendments overwrite filings which come before in sequence. Campaign Committees are required to file statements according to a schedule set out by the C

A. SUMMARY This dataset shows activity reported by registered lobbyists on their monthly statements. Learn more about the lobbyist program at the SF Ethics Commission website. Activities from both Contact and Expenditure lobbyists are combined in this dataset. B. HOW THE DATASET IS CREATED Lobbyists are required to register with the Ethics Commission and file monthly statements reporting their activity. C. UPDATE PROCESS Data from the lobbyist system is synched nightly to DataSF. If any filings have been accepted since the last update, the sync reflects new activity on those filings. D. HOW TO USE THIS DATASET Activities are self reported by lobbyists on monthly statements. All types of activities are reflected on this dataset, please refer to the SF Ethics Commission website to learn more about the lobbyist program. Refer to the "related content using this data" section below for links to filtered views by activity type, which limit the visible columns and may be more useful for analysis.

This dataset will no longer be updated as of March 2024, and is scheduled to be replaced with a new dataset in January of 2025. New filings are available in scanned paper format through the Ethics Commission's public disclosure portal. In 1997, San Francisco voters approved the Regulation of Campaign Consultants Ordinance (“Ordinance”). The Ordinance requires persons who earn $1,000 or more per year for campaign consultant services to register with the Ethics Commission and file quarterly activity reports. The Ordinance defines “campaign consultant” as a person or entity that receives or is promised $1,000 or more in a calendar year for either campaign management or campaign strategy.

This dataset will no longer be updated as of March 2024, and is scheduled to be replaced with a new dataset in January of 2025. New filings are available in scanned paper format through the Ethics Commission's public disclosure portal. Filers must report each political contribution of $100 or more to a candidate for local office, a committee controlled by a local officeholder or a candidate for local office, or a ballot measure committee whether or not the committee is controlled by a local officeholder or a candidate for local office. Filers must report contributions of $100 or more made or delivered by the filer, or made by the filer�۪s client at the filer�۪s behest, or for which the filer acted as an agent or intermediary during the reporting period. This chart indicates the political contributions made by campaign consultants during the reporting period.

This dataset will no longer be updated as of March 2024, and is scheduled to be replaced with a new dataset in January of 2025. New filings are available in scanned paper format through the Ethics Commission's public disclosure portal. Campaign consultants must report economic consideration promised to or received by the filer during the reporting period from vendors and sub-vendors who provide campaign-related goods or services to the filer's current clients.