San Francisco Campaign Finance Transactions from FPPC Forms

Transactions from FPPC Forms 460, 461, 496, 497, and 450 combine all schedules and include unitemized totals. The City of San Francisco's Ethics Commission provides this data, updated nightly with filings from committees. Only transactions from the most recent version of a filing appear, as amendments completely replace prior data.

Use Cases

• Tracking monetary contributions received by committees based on Schedule A data.
• Analyzing loans made and received by campaigns based on Schedule B1 and H data.
• Monitoring expenditures supporting or opposing candidates based on Schedule D data.
• Investigating unpaid bills and accrued expenses of committees based on Schedule F data.
• Joining transaction records with filer and filing datasets using properties suffixed with '-nid'.

Strengths

• Data is updated nightly, providing relatively current transaction information.
• Combines transactions from multiple FPPC forms and schedules into a single dataset.
• Includes a 'Form Type' column to differentiate transaction types.

Limitations

• Row count and column definitions are unknown, limiting suitability assessment.
• Transactions from rejected filings are excluded, which may omit certain data.
• During nightly updates, viewing or downloading may result in incomplete data.

Provenance

Source

City of San Francisco Ethics Commission

Collection Method

Committees file campaign statements periodically; data is presented as-filed.

Freshness

Updated nightly, with a last recorded update timestamp of 2026-03-22 04:19:33.965093.

Geography

San Francisco, California