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: Monetary Contributions Received


• B1: Loans Received


• B2: Loan Guarantors


• C: Nonmonetary Contributions Received


• D: Summary of Expenditures Supporting/Opposing Other Candidates, Measures and Committees


• E: Payments Made


• F: Accrued Expenses (Unpaid Bills)


• G: Payments Made by an Agent or Independent Contractor (on Behalf of This Committee)


• H: Loans Made to Others


• I: Miscellaneous Increases to Cash

RELATED DATASETS

• San Francisco Campaign Filers


• Filings Received by SFEC


• Summary Totals


• Transactions

A. SUMMARY
This dataset shows employment 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. Please refer to the SF Ethics Commission website to learn more about the lobbyist program.

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

• San Francisco Campaign Filers


• Filings Received by SFEC


• Summary Totals


• Transactions

A. SUMMARY
This dataset shows activity expenses reported by registered contact lobbyists. Learn more about the lobbyist program at the SF Ethics Commission website.

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. Please refer to the SF Ethics Commission website to learn more about the lobbyist program.

A. SUMMARY
This dataset shows Received Payments reported by Contact lobbyists on their monthly statements. Learn more about the lobbyist program at the SF Ethics Commission website.

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. Please refer to the SF Ethics Commission website to learn more about the lobbyist program.

Under section 3.234(a)(1) of the San Francisco Campaign and Governmental Conduct Code, no former officer or employee of the City and County of San Francisco may make communications before any court or public agency in connection with any particular matter in which the City is a party or has a direct and substantial interest, in which the former officer or employee participated personally and substantially, and which involved specific parties at the time of such participation. Under section 3.234(a)(2), no current or former officer or employee may, for one year after termination of service or employment, communicate with his or her former department to influence a government decision on behalf of any other person. Under section 3.234(a)(3), no current or former officer or employee may be employed by or otherwise receive compensation from a person or entity that entered into a contract with the city within the past 12 months where the officer or employee personally and substantially participated in the award of the contract. Under section 3.234(c)(1), the Ethics Commission may waive the restrictions in subsections (a)(1) and (a)(2) if the Commission determines that granting a waiver would not create the potential for undue influence or unfair advantage. Under section 3.234(c)(2), the Commission may grant a waiver from the restrictions in subsections (a)(1) and (a)(2) for members of City boards and commissions who, by law, must be appointed to represent any profession, trade, business union or association. Under section 3.234(c)(3), the Commission may waive the ban in subsection (a)(3) if the Commission determines that imposing the restriction would cause extreme hardship for the City officer or employee. This is a table of the waivers that have been granted under section 3.234(c).

Under section 3.234(a)(1) of the San Francisco Campaign and Governmental Conduct Code, no former officer or employee of the City and County of San Francisco may make communications before any court or public agency in connection with any particular matter in which the City is a party or has a direct and substantial interest, in which the former officer or employee participated personally and substantially, and which involved specific parties at the time of such participation. Under section 3.234(a)(2), no current or former officer or employee may, for one year after termination of service or employment, communicate with his or her former department to influence a government decision on behalf of any other person. Under section 3.234(a)(3), no current or former officer or employee may be employed by or otherwise receive compensation from a person or entity that entered into a contract with the city within the past 12 months where the officer or employee personally and substantially participated in the award of the contract. Under section 3.234(c)(1), the Ethics Commission may waive the restrictions in subsections (a)(1) and (a)(2) if the Commission determines that granting a waiver would not create the potential for undue influence or unfair advantage. Under section 3.234(c)(2), the Commission may grant a waiver from the restrictions in subsections (a)(1) and (a)(2) for members of City boards and commissions who, by law, must be appointed to represent any profession, trade, business union or association. Under section 3.234(c)(3), the Commission may waive the ban in subsection (a)(3) if the Commission determines that imposing the restriction would cause extreme hardship for the City officer or employee. This is a table of the waivers that have been granted under section 3.234(c).

This is a directory of lobbyists registered with the Ethics Commission. Learn more
about the lobbyist program at the SF
Ethics Commission website. Contact and Expenditure Lobbyists both show up in this
dataset. Lobbyists active only prior to 2018 were not required to file a "Registration"
type statement, and will not appear in this dataset. Those lobbyist's filings and
activities will still appear in the corresponding lobbyst datasets.

Lobbyists are required to register and file regular statements with the Ethics Commission.
This dataset is updated with the lobbyist filings. The live
lobbyist system can be accessed as well.

This dataset is updated with a sync script that checks nightly for new filings. Lobbyists are required to register and file monthly statements.

Only the most recent firm for a lobbyist is displayed.

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:

• SFEC161 - Itemized Disclosure Statement for Mass Mailings


• SFEC162 - Electioneering Communication Report


• SFEC163 - Member Communication Report

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.

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
Filings received on paper will not have corresponding data in the Transactions or Summary datasets.
A "rejected" filing is usually one made in error, under the wrong filing account, or containing an error in reporting period.
Amendment filings supersede all transactions from the original filing and any prior amendments. Transactions from prior filings are removed from the accompanying "Transactions" dataset in order to represent the most up-to-date version of transactions.
"Filer Name" reflects the name of the committee at time of filing. Committees can change names over time.

Refer to the Ethics Commission's webpage for more information.

RELATED DATASETS

• San Francisco Campaign Filers


• Filings Received by SFEC


• Summary Totals


• Transactions

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.