Total Contributions:
(RCPT is a contribution made by others; LOAN refers to candidate loan, which should be distinguished from RCPT)
Total Expenditures:
(EXPN is campaign expenses, which should be distinguished from RCPT and LOAN)
Current balance
Overall stats about Contributions: % out of state, % within X (district or city), % within California
A break down of total contributions with a list: Donor Name | Donor Occupation | Donor City | Donation Amount | Date of Donation
A break down of total expenditures by category
Get all the data and combine into this format
1) Download the XSL/CSV files on candidates and measures - FPPC Form 460 and Form 460 A (Amendment), add them to the git repository on a new branch
2) Combine the data into one XSL/CSV file per ballot measure/committee
3) Turn the data in JSON
Where to get data To download the data, go to SCC election campaign finance data portal: https://public.netfile.com/pub2/?aid=SCC&AspxAutoDetectCookieSupport=1
Which elections do we want to track? Get 2017-2018 campaign finance data for the General Election candidates:
Reference: https://www.sccgov.org/sites/rov/Info/Nov2018info/Documents/official%20candidate%20list.pdf
If you have the time, extract this data
Get all the data and combine into this format 1) Download the XSL/CSV files on candidates and measures - FPPC Form 460 and Form 460 A (Amendment), add them to the git repository on a new branch 2) Combine the data into one XSL/CSV file per ballot measure/committee 3) Turn the data in JSON
For reference take a look at PR #46