monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

788 rows where filer_name = 122 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, entity_type, state, transaction_type, transaction_description, committee_id, memo_reference_number, report_date (date), report_start_date (date), report_end_date (date), election_date (date), transaction_date (date)

Link rowid filer_id filer_name report_date ▲ report_start_date report_end_date election_date transaction_id entity_type last_name first_name prefix city state zipcode employer occupation self_employed transaction_type transaction_date transaction_amt year_to_date transaction_description committee_id memo_reference_number
52389 52389 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   INC940 IND Chen Ping Ping   San Leandro CA 94579 San Francisco University 7553 Administration n   2018-02-15 700 700      
52390 52390 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   INC929 OTH Emerson Westreich Community Property Trust     Oakland CA 94611     n   2018-01-31 100 100      
52391 52391 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   INC941 IND Jiang Yaoyao Annabella   Richmond CA 94805 World Financial Group 7354 Sales Representative n   2018-02-15 700 700      
52392 52392 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   PAY966 IND Kaplan Rebecca D.   Oakland CA 94608 City of Oakland 8 City Councilmember n F 2018-06-27 700 4000     PAY966
52393 52393 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   PAY972 IND Kaplan Rebecca D.   Oakland CA 94608 City of Oakland 8 City Councilmember n F 2018-06-27 2000 4000     PAY972
52394 52394 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   PAY968 IND Kaplan Rebecca D.   Oakland CA 94608 City of Oakland 8 City Councilmember n F 2018-06-27 1300 4000     PAY968
52395 52395 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   INC939 IND Liu Judy Y.   Oakland CA 94610 Aqua Skin Care 5565 Manager n   2018-02-15 700 700      
52396 52396 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   INC937 IND Mac Ibana   Elk Grove CA 95757 Genentech, Inc. 5992 Cardiogram Examiner n   2018-02-15 700 700      
52397 52397 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   INC942 IND Ng Charlie   Sacramento CA 95828 Sancha Bar 5568 Manager n   2018-02-15 700 700      
52398 52398 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   INC938 IND Saechao Sen C.   Oakland CA 94606 Boys & Girls Club 8453 Director n   2018-02-15 700 700      
52399 52399 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   INC936 COM San Francisco Laborer's Local 261 PAC     San Francisco CA 94110     n   2018-02-13 750 750   231.0  
52400 52400 1381183 112 Kaplan for Oakland City Council 2016 122 2018-07-17 2018-01-01 2018-06-27   INC931 OTH Slainte Bar, LLC     Oakland CA 94607     n   2018-01-31 200 200      
36816 36816 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC880 IND Azimi Nasser   Orangevale CA 95662 Teranomic 6022 Partner n   2017-11-07 700 700      
36817 36817 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC858 IND Chu Judy   Oakland CA 94607 Goldenland Investment 3020 Real Estate Broker n   2017-07-26 200 200      
36818 36818 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC916 IND Foo Lora Jo   Oakland CA 94602   Retired n   2017-12-26 100 100      
36819 36819 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC917 IND Friedkin Gerald S.   Oakland CA 94607 Friedkin Investment Company 6023 Real Estate n   2017-12-26 250 250      
36820 36820 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC896 IND Held Liana   Oakland CA 94611 May Wellness, Inc. 6024 Special Projects n   2017-12-15 100 100      
36821 36821 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC868 IND Kevlin John C.   Oakland CA 94611 Reuben, Junius & Rose, LLP 3687 Attorney n   2017-08-23 500 500      
36822 36822 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC893 IND Klein Jane   Oakland CA 94611 Quick Trading Company 6025 Publishing n   2017-12-15 100 100      
36823 36823 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC894 IND Kramer Evrett   San Francisco CA 94114 Foggy Date Delivery 6026 Chief Executive Officer n   2017-12-15 100 100      
36824 36824 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC869 OTH Lighthouse Public Affairs, LLC     San Francisco CA 94133     n   2017-08-23 700 700      
36825 36825 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC912 IND Murray Erik   Lafayette CA 94549 Oak Industrial Funds, LLC 6027 Real Estate n   2017-12-14 180 180      
36826 36826 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC921 IND Raich Robert   Oakland CA 94619 Robert A. Raich, P.C. 2435 Attorney n   2017-12-25 150 0      
36827 36827 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   EXP923 IND Raich Robert   Oakland CA 94619 Robert A. Raich, P.C. 2435 Attorney n R 2017-12-31 -150 0 Refund of Contribution   EXP923
36828 36828 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC859 IND Smith Bernestine   Brentwood CA 94513 Allen Temple Baptist Church 3739 Reverend n   2017-07-26 200 200      
36829 36829 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC915 OTH Sunflower Alliance     Berkeley CA 94709     n   2017-12-18 200 200      
36830 36830 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC914 IND Verzura Tony   Oakland CA 94611 Advesa 6028 Owner n   2017-12-14 300 300      
36831 36831 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC891 OTH W. Purcell Commercial Property Services     Danville CA 94506     n   2017-12-15 200 300      
36832 36832 1381183 112 Kaplan for Oakland City Council 2016 122 2018-01-22 2017-07-01 2017-12-31   INC895 IND Zavell A. Stephen   Oakland CA 94618   Retired n   2017-12-15 125 125      
30584 30584 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC680 SCC California Nurses Association PAC (CNA PAC) Small Contributor Committee     Sacramento CA 95814     n   2016-11-28 500 1500   95.0  
30585 30585 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC713 COM Campaign for Equality     Berkeley CA 94707     n   2016-12-31 500 500   419.0  
30586 30586 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC633 IND Catalano Tuij I.   San Francisco CA 94104 Reuben, Junius & Rose, LLP 3687 Attorney n   2016-11-07 200 200      
30587 30587 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC571 IND Caviglia Rick   Castro Valley CA 94546 Worldnet Cellular Communications, Inc. 5127 President n   2016-10-31 500 700 To be Refunded    
30588 30588 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   EXP620 IND Caviglia Rick   Castro Valley CA 94546 Worldnet Cellular Communications, Inc. 5127 President n R 2016-11-08 -100 700     EXP620
30589 30589 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC569 IND Clemens Alexander   Alameda CA 94501 Lighthouse Public Affairs 5128 Public Affairs n   2016-11-01 500 500      
30590 30590 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC641 IND Cobb Paul L.   Oakland CA 94607 Oakland Private Industry Council 44 Chief Executive Officer n   2016-11-17 36 128      
30591 30591 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC642 IND Colbruno Michael J.   Oakland CA 94610 Milo Group of California 3513 Partner n   2016-11-17 350 600      
30592 30592 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC630 SCC Construction & General Laborers Local 304 PAC Small Contributor Committee     Sacramento CA 95814     n   2016-11-15 1500 1500   66.0  
30593 30593 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC657 IND Copes James   Oakland CA 94610 Old School Copes 5129 Designer Apparel n   2016-11-08 100 100      
30594 30594 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC709 IND De Luca Niccolo   Sacramento CA 95818 Townsend Public Affairs 254 Advocate n   2016-12-22 400 400      
30595 30595 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC722 IND De Luca Niccolo   Sacramento CA 95818 Townsend Public Affairs 254 Advocate n   2016-12-22 100 400      
30596 30596 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   EXP712 IND De Luca Niccolo   Sacramento CA 95818 Townsend Public Affairs 254 Advocate n R 2016-12-31 -100 400     EXP712
30597 30597 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC634 IND Drake Jay F.   Corte Madera CA 94925 Reuben, Junius & Rose LLP 5130 Attorney n   2016-11-07 200 200      
30598 30598 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC656 IND Echols Elizabeth   Berkeley CA 94708 State of California 422 Public Official n   2016-11-15 100 100      
30599 30599 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC580 IND Epstein Kathryn Kelly   Oakland CA 94606 Holy Names University 2399 Professor n   2016-10-27 80 120      
30600 30600 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC597 IND Franklin Theodore   Oakland CA 94610 Weinberg, Roger & Rosenfeld 5131 Attorney n   2016-10-31 100 100      
30601 30601 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC664 IND Frattin Daniel   San Diego CA 92107 Reuben, Junius & Rose, LLP 3687 Attorney n   2016-11-03 120 180      
30602 30602 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC663 IND Frattin Daniel   San Diego CA 92107 Reuben, Junius & Rose, LLP 3687 Attorney n   2016-11-03 60 180      
30603 30603 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC568 IND Goldsberry Deborah   Oakland CA 94602 Magnolia Wellness 2974 Administator n   2016-10-28 100 100      
30604 30604 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC631 IND Hackney Carl   Oakland CA 94619 CenterForce 5132 Board President n   2016-11-15 500 500      
30605 30605 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC666 COM International Federation of Professional and Technical Engineers Local 21 (IFPTE) T.J. Anthony PAC Fund     San Francisco CA 94103     n   2016-11-18 900 1500   31.0  
30606 30606 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC635 IND Junius Andrew J.   San Francisco CA 94133 Reuben, Junius & Rose, LLP 3687 Attorney n   2016-11-07 250 250      
30607 30607 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC679 IND Kaplan Rebecca D.   Oakland CA 94608 City of Oakland 8 City Councilmember n   2016-11-17 50 44050      
30608 30608 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC600 IND Kuiper Heather   Oakland CA 94618 Heather Kuiper 5133 Public Health n   2016-10-31 250 250      
30609 30609 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC574 OTH Lamumba, Inc.     Oakland CA 94612     n   2016-10-29 200 500      
30610 30610 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC636 IND Lannin Cortlin H.   Oakland CA 94611 Covington & Burling LLP 2104 Attorney n   2016-11-07 200 200      
30611 30611 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC699 OTH Law Offices of Charles Tillman Ramsey     El Cerrito CA 94530     n   2016-12-21 500 500      
30612 30612 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC659 IND Levitan Doron   San Francisco CA 94107 Priority Parking 5134 Chief Executive Officer n   2016-11-07 300 300      
30613 30613 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC667 IND Lewis Jan H.   Oakland CA 94618 Mentoring Academy 4845 Teacher n   2016-11-18 200 400      
30614 30614 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC572 IND Lowe Stephen   Oakland CA 94607 Stephen Lowe 5135 Real Estate Development n   2016-10-31 450 700      
30615 30615 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC566 IND Lubeck Susan Lee   Oakland CA 94602 Bend the Arc: A Jewish Partnership for Justice 5136 Field Director n   2016-10-23 108 108      
30616 30616 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC674 IND Ludwig Mark   Piedmont CA 94611 Mark Ludwig 5052 Psychotherapist n   2016-11-19 100 300      
30617 30617 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC706 IND Ludwig Mark   Piedmont CA 94611 Mark Ludwig 5052 Psychotherapist n   2016-12-19 100 300      
30618 30618 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC649 IND Lymen Kimberly   Oakland CA 94605   Retired n   2016-11-09 100 100      
30619 30619 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC714 COM Nate Miley for Supervisor 2016     Oakland CA 94618     n   2016-12-31 500 500   99.0  
30620 30620 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC681 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy     Oakland CA 94618     n   2016-11-28 200 700   221.0  
30621 30621 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC573 IND Pallatto Elizabeth   Oakland CA 94612 Sierra Club 1770 Training Director n   2016-10-31 60 160      
30622 30622 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC614 IND Pallatto Elizabeth   Oakland CA 94612 Sierra Club 1770 Training Director n   2016-10-31 100 160      
30623 30623 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC637 IND Reuben Sheryl   San Francisco CA 94121   Homemaker n   2016-11-07 500 500      
30624 30624 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC638 IND Rose Kevin H.   Martinez CA 94553 Reuben, Junius & Rose LLP 5130 Attorney n   2016-11-07 150 150      
30625 30625 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC645 IND Rosselli Sal   San Francisco CA 94134 National Union of Healthcare Workers 1567 Organizer n   2016-11-17 100 100      
30626 30626 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC576 COM Scott Haggerty for Supervisor 2016     Fremont CA 94538     n   2016-10-29 200 200   352.0  
30627 30627 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC632 IND Stephenson Susan C.   Oakland CA 94611 The Regeneration Project 5137 Executive Director n   2016-11-15 100 100      
30628 30628 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC662 IND Stone Betty   Oakland CA 94618   Retired n   2016-11-06 100 100      
30629 30629 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC562 IND Tepperman Jean   Berkeley CA 94704   Retired n   2016-10-25 120 120      
30630 30630 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC644 OTH The Milo Group of California, Inc.     Oakland CA 94612     n   2016-11-17 700 700      
30631 30631 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC610 IND Umeh Laurie   Oakland CA 94601   Retired n   2016-10-31 100 100      
30632 30632 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC646 IND Vail Mary   Oakland CA 94602   Retired n   2016-11-17 200 650      
30633 30633 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC698 IND Vail Mary   Oakland CA 94602   Retired n   2016-12-21 100 650      
30634 30634 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2016-10-23 2016-12-31   INC660 IND Yakubova Inna   San Francisco CA 94121 Sanmo 5138 President n   2016-11-07 500 500      
37850 37850 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC825 OTH AB&I Foundry     Oakland CA 94621     n   2017-06-22 700 700      
37851 37851 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC744 IND Apodaca Robert J.   Oakland CA 94607 ZeZen Advisors 4694 Principal n   2017-02-06 500 500      
37852 37852 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC813 IND Castillo Nelson E.   Dublin CA 94568 E.C. Auto Body 6228 Co-Owner n   2017-04-06 700 700      
37853 37853 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC746 IND Cruz-Lopez Esmeralda   Oakland CA 94601 Esmeralda Cruz-Lopez 6229 Concert Promoter n   2017-02-06 700 700      
37854 37854 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC783 IND Cruz-Lopez Esmeralda   Oakland CA 94601 Esmeralda Cruz-Lopez 6229 Concert Promoter n   2017-02-14 -700 700     INC783
37855 37855 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC785 IND Cruz-Lopez Esmeralda   Oakland CA 94601 Esmeralda Cruz-Lopez 6229 Concert Promoter n   2017-02-22 700 700      
37856 37856 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC826 IND Dunbar Francesca   Alamo CA 94507 McWane, Inc./AB&I Foundry 6227 Director of Group Marketing n   2017-06-21 100 100      
37857 37857 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC817 COM International Association of Firefighter Local 55 PAC     Oakland CA 94612     n   2017-04-06 870 870   59.0  
37858 37858 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC830 IND Lowe Michael   Pleasant Hill CA 94523 Ab&I Foundry 6230 Manager n   2017-06-28 700 700      
37859 37859 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC753 IND Ludwig Mark   Piedmont CA 94611 Mark Ludwig 5052 Psychotherapist n   2017-01-19 100 300      
37860 37860 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC789 IND Ludwig Mark   Piedmont CA 94611 Mark Ludwig 5052 Psychotherapist n   2017-02-19 100 300      
37861 37861 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC812 IND Ludwig Mark   Piedmont CA 94611 Mark Ludwig 5052 Psychotherapist n   2017-03-19 100 300      
37862 37862 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC824 OTH Madison Park Financial Corporation     Oakland CA 94612     n   2017-06-22 700 700      
37863 37863 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC750 IND McConnell Kituria   Danville CA 94506   Retired n   2017-01-31 500 500      
37864 37864 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC724 OTH Northbay Networks, Inc.     Emeryville CA 94608     n   2017-01-20 700 700      
37865 37865 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC749 COM Oakland Jobs PAC     Oakland CA 94618     n   2017-02-06 700 700   507.0  
37866 37866 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC803 IND Post Gara   Los Angeles CA 90046 The Now Massage Boutique 6231 Co-Founder n   2017-03-14 700 700      
37867 37867 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC804 IND Post Jason   Los Angeles CA 90046 Post Investment Group 5366 President n   2017-03-14 700 700      
37868 37868 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC805 OTH Robert Arnold & Company     Oakland CA 94610     n   2017-03-14 100 100      
37869 37869 1381183 112 Kaplan for Oakland City Council 2016 122 2017-07-26 2017-01-01 2017-06-30   INC751 IND Rohr Mimi   Oakland CA 94611 The McConnell Group 179 Political Consultant n   2017-01-30 250 250      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "monetary_contributions" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "last_name" TEXT,
  "first_name" TEXT,
  "prefix" INTEGER,
  "city" TEXT,
  "state" TEXT,
  "zipcode" TEXT,
  "employer" INTEGER,
  "occupation" TEXT,
  "self_employed" TEXT,
  "transaction_type" INTEGER,
  "transaction_date" TEXT,
  "transaction_amt" INTEGER,
  "year_to_date" INTEGER,
  "transaction_description" INTEGER,
  "committee_id" TEXT,
  "memo_reference_number" INTEGER
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
    FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id),
    FOREIGN KEY ("employer") REFERENCES [businesses](id));
CREATE INDEX ["monetary_contributions_filer_id"] ON [monetary_contributions]("filer_id");
CREATE INDEX ["monetary_contributions_filer_name"] ON [monetary_contributions]("filer_name");
CREATE INDEX ["monetary_contributions_committee_id"] ON [monetary_contributions]("committee_id");
CREATE INDEX ["monetary_contributions_employer"] ON [monetary_contributions]("employer");