Data · dataset · 2022
Campaign Finance - Transactions
Listed in Restaurants Health Score Data in San Francisco
A. SUMMARY Transactions from FPPC Forms 460, 461, 496, 497, and 450.
Description
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.
Read the rest (6 more)
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
Links
Get the data
- CSV data.sf.gov/api/views/pitq-e56w/rows.csv?accessType=DOWNLOAD ↗
download · from data sfgov org
Where it is published
- data.sf.gov /City-Management-and-Ethics/Campaign-Finance-Transactions/pitq-… ↗
Restaurants Health Score Data in San Francisco dataset page
landing page · from data sfgov org
Catalogue records · 1
- SODA API data.sf.gov/resource/pitq-e56w.json ↗
metadata API · from data sfgov org
Topics
- Stated by source
- City Management and Ethics
- From keywords
- Economics & Finance
Related
- Possibly the same asCampaign Finance - Transactions
Provenance · 1 source records, 9 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| Restaurants Health Score Data in San Francisco | pitq-e56w | 11 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| concepts[field].local:field:economics-finance | mapping · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| concepts[topic].socrata_category:data_sfgov_org:city-management-and-ethics | source · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| created_date | source · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| description | source · data sfgov org | connector:data_sfgov_org@1.0.0 | /resource/description |
| license | source · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| publication_date | source · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| title | source · data sfgov org | connector:data_sfgov_org@1.0.0 | /resource/name |
| updated_date | source · data sfgov org | connector:data_sfgov_org@1.0.0 |