Find data on CA Justices

[ychoy]

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:

Associate Justice, Supreme Court

• LEONDRA R. KRUGER

Associate Justice, Supreme Court

• CAROL A. CORRIGAN

Presiding Justice, Court of Appeal 6th Dist.

• MARY J. GREENWOOD

Associate Justice, COA 6th Dist.

• NATHAN D. MIHARA
  • ALLISON MARSTON DANNER

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 do this one.

[hanstxu]

I couldn't find campaign finance info on the judges. Is it possible that they are not democratically elected? I don't remember.