Find data on CA State Senate and Assembly General Election Nov 6, 2018

[ychoy]

Where to get data http://powersearch.sos.ca.gov/

Which elections do we want to track? Get 2017-2018 campaign finance data for the General Election candidates:

10th State Senate

• VICTOR G. SAN VICENTE
• BOB WIECKOWSKI

24th Assembly

• Marc Berman
• Alex Glew

25th Assembly

• Kansen Chu
• Bob Brunton

27th Assembly

• Ash Kalra
• G. Burt Lancaster

28th Assembly

• MICHAEL L. SNYDER
• EVAN LOW

29th Assembly

• VICKI L. NOHRDEN
• MARK STONE

30th Assembly

• ROBERT RIVAS
• NEIL G. KITCHENS

Reference: https://www.sccgov.org/sites/rov/Info/Nov2018info/Documents/official%20candidate%20list.pdf

If you have the time, extract this data

• Name of candidate /measure
• 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

For reference take a look at PR #46

[hanstxu]

I'll try to help for this issue.