Skip to content

Instantly share code, notes, and snippets.

@ldaly
ldaly / Totals_Mod5.csv
Created May 16, 2015 21:04
Summary of Monetary Contributions (scatter plot)
Name totOakland totNotOakland percTotIsOak percent grandTotal
Abel Guillen for City Council 40530.35 34446 0.540575128 54.1 74976.35
Andrew Park for City Council 11852.32 10638 0.526996503 52.7 22490.32
Annie Campbell Washington for City Council 28460 13550 0.677457748 67.7 42010
Charles R. Williams for Mayor 21100 700 0.967889908 96.8 21800
Committee to Elect Michael Johnson City Council 9483 9671 0.495092409 49.5 19154
Courtney Ruby for Mayor 109306.39 77246 0.58592865 58.6 186552.39
Dan Siegel for Mayor 14890.81 31335 0.322131943 32.2 46225.81
Dana King for City Council 49535 38035.22 0.565660335 56.6 87570.22
Jill Broadhurst for Council 54300 30750 0.638447972 63.8 85050
@ldaly
ldaly / CF_AllSummary.csv
Created April 13, 2015 01:58
Summary of Monetary Contributions
Name Total
Abel Guillen for City Council 74976.35
Andrew Park for City Council 22490.32
Annie Campbell Washington for City Council 42010
Charles R. Williams for Mayor 21800
Committee to Elect Michael Johnson for City Council 19154
Courtney Ruby for Mayor 186552.39
Dan Siegel for Mayor 46225.81
Dana King for City Council 87570.22
Jill Broadhurst for Council 85050
@ldaly
ldaly / CF_AllSummary.csv
Last active August 29, 2015 14:19
Campaign Finance - Summary Chart of Monetary Contributions
Name Total
Abel Guillen for Oakland City Council 2014 54676.35
Andrew Park for City Council 2014 22490.32
Annie Campbell Washington for Oakland City Council 2014 42010
Charles R. Williams for Mayor of Oakland 2014 21800
Committee to Elect Michael V. Johnson City Council 2014 19154
Courtney Ruby for Oakland Mayor 2014 186552.39
Dan Siegel for Mayor, 2014 46225.81
Dana King for City Council 2014 87570.22
Jill Broadhurst for Council 2014 85050
@ldaly
ldaly / CampaignFinance_MonetaryContributions.csv
Last active August 29, 2015 14:18
Oakland Campaign Finance
We can't make this file beautiful and searchable because it's too large.
Filer_ID,Filer_NamL,Committee_Type,Rpt_Date,From_Date,Thru_Date,Elect_Date,Rec_Type,Form_Type,Entity_Cd,Tran_NamL,Tran_NamF,Tran_City,Tran_State,Tran_Zip4,ZipTxt,Tran_Emp,Tran_Occ,Tran_Date,Tran_Amt1,Tran_Amt2
1365384,Abel Guillen for Oakland City Council 2014,CTL,10/22/14,7/1/14,9/30/14,11/4/14,RCPT,A,OTH,Campaign for Equality,N/A,Berkeley,CA,94709,94709,N/A,N/A,9/24/14,250,250
1354678,Re-Elect Mayor Quan 2014,CTL,1/27/14,7/1/13,12/31/13,11/4/14,RCPT,A,IND,Baylosis,Max,Alamda,CA,94501,94501,retired,retired,10/26/13,100,100
1354678,Re-Elect Mayor Quan 2014,CTL,1/27/14,7/1/13,12/31/13,11/4/14,RCPT,A,IND,Szeto,Stephen,Alameda,CA,94501,94501,retired,retired,10/21/13,100,100
1354678,Re-Elect Mayor Quan 2014,CTL,7/29/14,1/1/14,6/30/14,11/4/14,RCPT,A,IND,Swanson,Sandre,Alameda,CA,94502,94502,City of Oakland,deputy mayor,6/7/14,100,100
1354678,Re-Elect Mayor Quan 2014,CTL,7/29/14,1/1/14,6/30/14,11/4/14,RCPT,A,IND,Semere,Kesete,Alameda,CA,94501,94501,San Francisco Cab Company,driver,6/30/14,100,100
1354678,Re-Elect M
@ldaly
ldaly / Monetary Contributions
Created March 20, 2015 03:09
Campaign Finance (Monetary Contributions in the 2014 City of Oakland Election Cycle)
Filer_ID,Filer_NamL,Committee_Type,Rpt_Date,From_Date,Thru_Date,Elect_Date,Rec_Type,Form_Type,Entity_Cd,Tran_NamL,Tran_NamF,Tran_City,Tran_State,Tran_Zip4,ZipTxt,Tran_Emp,Tran_Occ,Tran_Date,Tran_Amt1,Tran_Amt2
1365384,Abel Guillen for Oakland City Council 2014,CTL,10/22/14,7/1/14,9/30/14,11/4/14,RCPT,A,OTH,Campaign for Equality,N/A,Berkeley,CA,94709,94709,N/A,N/A,9/24/14,250,250
1354678,Re-Elect Mayor Quan 2014,CTL,1/27/14,7/1/13,12/31/13,11/4/14,RCPT,A,IND,Baylosis,Max,Alamda,CA,94501,94501,retired,retired,10/26/13,100,100
1354678,Re-Elect Mayor Quan 2014,CTL,1/27/14,7/1/13,12/31/13,11/4/14,RCPT,A,IND,Szeto,Stephen,Alameda,CA,94501,94501,retired,retired,10/21/13,100,100
1354678,Re-Elect Mayor Quan 2014,CTL,7/29/14,1/1/14,6/30/14,11/4/14,RCPT,A,IND,Swanson,Sandre,Alameda,CA,94502,94502,City of Oakland,deputy mayor,6/7/14,100,100
1354678,Re-Elect Mayor Quan 2014,CTL,7/29/14,1/1/14,6/30/14,11/4/14,RCPT,A,IND,Semere,Kesete,Alameda,CA,94501,94501,San Francisco Cab Company,driver,6/30/14,100,100
1354678,Re-Elect M