monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

83 rows where filer_id = 51 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, report_date, report_start_date, report_end_date, entity_type, city, state, transaction_amt, year_to_date, committee_id, report_date (date), report_start_date (date), report_end_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
37705 37705 1361954 51 Dan Kalb City Council Officeholder 2013 116 2018-01-11 2017-07-01 2017-12-31   CwGSA3Skm1jv IND Kalb Dan   Oakland CA 94618     n   2017-09-25 400 400      
37706 37706 1361954 51 Dan Kalb City Council Officeholder 2013 116 2018-01-11 2017-07-01 2017-12-31   hv8RIhTSna1y COM Re-Elect Dan Kalb Oakland City Council 2016     Oakland CA 94612     n   2017-12-20 70.14 1457.14   506.0  
37707 37707 1361954 51 Dan Kalb City Council Officeholder 2013 116 2018-01-11 2017-07-01 2017-12-31   xULumYb2VLi8 COM Re-Elect Dan Kalb Oakland City Council 2016     Oakland CA 94612     n   2017-12-20 87 1457.14   506.0  
37708 37708 1361954 51 Dan Kalb City Council Officeholder 2013 116 2018-01-11 2017-07-01 2017-12-31   PIHe8GaFPa87 IND Kalb Dan   Oakland CA 94618 City of Oakland 8 City Councilmember n   2017-12-31 900 900      
37840 37840 1361954 51 Dan Kalb City Council Officeholder 2013 116 2017-07-31 2017-01-01 2017-06-30   cmnipcJp3Cnj COM Re-Elect Dan Kalb Oakland City Council 2016     Oakland CA 94612     n   2017-01-01 500 1300   506.0  
37841 37841 1361954 51 Dan Kalb City Council Officeholder 2013 116 2017-07-31 2017-01-01 2017-06-30   lgTOSMrFeMow COM Re-Elect Dan Kalb Oakland City Council 2016     Oakland CA 94612     n   2017-03-07 800 1300   506.0  
31103 31103 1361954 51 Dan Kalb City Council Officeholder 2013 116 2017-02-02 2016-10-23 2016-12-31   CUmwP9IbbAvP COM Re-Elect Dan Kalb Oakland City Council 2016     Oakland CA 94612     n   2016-12-31 600 600   422.0  
34504 34504 1361954 51 Dan Kalb City Council Officeholder 2013 116 2016-08-02 2016-01-01 2016-06-30   Idfu5hdiMxQX IND Piper Sue   Oakland CA 94618 Susan Piper Public Relations 4136 Public Relations Consultant n   2016-03-22 100 100      
34505 34505 1361954 51 Dan Kalb City Council Officeholder 2013 116 2016-08-02 2016-01-01 2016-06-30   SNOQjoyjBzrw IND Jaicks Agar   San Francisco CA 94117 Retired 124 Retired n   2016-06-30 500 500      
22628 22628 1361954 51 Dan Kalb City Council Officeholder 2013 116 2016-02-01 2015-07-01 2015-12-31   dgKZZkfqJWv9 IND Guillen Abel   Oakland CA 94609 City of Oakland 8 City Councilmember n   2015-07-23 150 150      
22629 22629 1361954 51 Dan Kalb City Council Officeholder 2013 116 2016-02-01 2015-07-01 2015-12-31   4OHoBUZgZsiA IND Raich Robert   Oakland CA 94619 Self 228 Attorney n   2015-10-06 700 700      
22630 22630 1361954 51 Dan Kalb City Council Officeholder 2013 116 2016-02-01 2015-07-01 2015-12-31   Nalna2lHN63o IND Barnett Michael   Oakland CA 94618 Lawrence Berkeley National Laboratory 1013 Physicist n   2015-10-17 50 200      
22631 22631 1361954 51 Dan Kalb City Council Officeholder 2013 116 2016-02-01 2015-07-01 2015-12-31   ByLkJgW3dDzl OTH Northern California Carpenters Regional Council Small Contributor Committee     Oakland CA 94621     n   2015-12-15 700 700      
22632 22632 1361954 51 Dan Kalb City Council Officeholder 2013 116 2016-02-01 2015-07-01 2015-12-31   BtqhhV2f6Jju COM Sheet Metal Workers' Local Union No.104 Political Action Committee     San Ramon CA 94583     n   2015-12-30 700 700   81.0  
27598 27598 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   q56QGIUHtJsN COM Rob Bonta for Assembly 2016     Sacramento CA 95815     n   2015-03-30 700 700   236.0  
27599 27599 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   hvfxFlQLTiNW IND Lounds Darin   Oakland CA 94606 Housing Consortium of the East Bay 3148 Affordable housing developer n   2015-04-06 150 150      
27600 27600 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   1g39iEFYIyNZ IND Shawl Susan   Oakland CA 94618 Retired 124 Retired n   2015-04-10 100 100      
27601 27601 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   ssB8VlxYD3s8 IND Swanson Sandre   Alameda CA 94502 Self-employed 265 Unknown n   2015-04-10 150 150      
27602 27602 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   TAm3r67ildqa IND Wright Moe   Oakland CA 94607 BBI Construction 334 Principal n   2015-04-10 500 500      
27603 27603 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   7FpCAOkFldsz IND Zolno Steve   Oakland CA 94618 New Way Services 4639 Program Manager n   2015-04-12 150 150      
27604 27604 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   WqPAncR229oL IND Barnett Michael   Oakland CA 94618 Lawrence Berkeley National Laboratory 1013 Physicist n   2015-04-13 150 150      
27605 27605 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   XN7TjigxieE7 COM Alameda Fire Fighters Association Political Action Committee     Alameda CA 94501-2126     n   2015-04-16 300 300   225.0  
27606 27606 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   PiCXkX9EtLuW IND Borsuk Mark   San Francisco CA 94123 Mark Borsuk, Inc. 1539 Commercial Real Estate Broker n   2015-04-16 150 150      
27607 27607 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   jHl9HfSPHJel IND Bruce Gloria   Oakland CA 94609 East Bay Housing Organizations 4640 Interim Executive Director n   2015-04-16 100 100      
27608 27608 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   f6aW4bRepDjF COM International Association of Firefighters, Local 55     Oakland CA 94612     n   2015-04-16 500 500   276.0  
27609 27609 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   GDwZotzyTiBw IND Lighty Michael   Oakland CA 94611-1109 California Nurses Association 2099 Director of Public Policy n   2015-04-16 150 150      
27610 27610 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   pTZG9qdlGf5P IND McCarthy Joseph   Moraga CA 94556 BRIDGE Housing Corporation 73 Senior Project Manager n   2015-04-16 150 150      
27611 27611 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   h2lqExwtVSFV IND Skinner Nancy   Berkeley CA 94702 UC Davis 1868 Researcher n   2015-04-16 250 250      
27612 27612 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   kAU5hsjzyzhJ IND Stivers Evelyn   Oakland CA 94610-4320 Non-Profit Housing of N. California 4641 Field Director n   2015-04-16 100 100      
27613 27613 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   8TNUNtTETbOL IND Fishman Amie   Oakland CA 94602 Nonprofit Housing Association of Northern California 4642 Executive Director n   2015-04-19 100 100      
27614 27614 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   DkBiNYBCF7BK IND Alterman Ronald   Oakland CA 94618 Global Technology Solutions Group/International Business Machines Corporation 4143 Consultant n   2015-04-24 150 150      
27615 27615 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   VPMebMH5VwQh OTH Full Court Press Communications     Oakland CA 94612     n   2015-04-26 300 300      
27616 27616 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   Qex1IrZEyAQ1 IND Fusillo Patrice   Oakland CA 94618-1852 Self-employed 265 Author n   2015-04-26 100 100      
27617 27617 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   HB4dK73zEwk6 IND Hamlin Earl   Oakland CA 94618 Port of Oakland 421 Port Commissioner n   2015-04-26 500 500      
27618 27618 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   jXWiefzYWt15 IND Raburn Robert   Oakland CA 94602 Bay Area Rapid Transit 1165 Director n   2015-04-26 300 300      
27619 27619 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   bPpOHxelxEUR COM Bay Area Citizens PAC     Oakland CA 94612-1427     n   2015-05-20 700 700   83.0  
27620 27620 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   mAdqzbRzUUsk COM San Francisco Fire Fighters Political Action Committee     San Francisco CA 94103     n   2015-06-01 300 300   253.0  
27621 27621 1361954 51 Dan Kalb City Council Officeholder 2013 116 2015-07-31 2015-01-01 2015-06-30   9Yfo5U2Ja8P5 COM Operating Engineers Local Union No. 3 District 20 PAC     Alameda CA 94502     n   2015-06-29 1150 1150   28.0  
13402 13402 1361954 51 Dan Kalb City Council Officeholder Committee 44 2015-01-25 2014-07-01 2014-12-31   rZGlIKHOq3Ig COM Rob Bonta for Assembly 2014     Sacramento CA 95815     n   2014-08-04 700 700   85.0  
13403 13403 1361954 51 Dan Kalb City Council Officeholder Committee 44 2015-01-25 2014-07-01 2014-12-31   r8xEldNrgDVD COM Sheet Metal Workers' Local Union No.104 Political Action Committee     San Ramon CA 94583     n   2014-09-19 750 750   81.0  
18752 18752 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   htsySk15hM4i COM International Association of Firefighters, Local 55     Oakland CA 94612     n   2014-03-19 600 600   276.0  
18753 18753 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   C1Bch8gV5rSQ IND Piper Sue   Oakland CA 94618 Susan Piper Public Relations 4136 Public Relations Consultant n   2014-05-19 150 150      
18754 18754 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   QSPPaDhIgGYn IND Ubell Michael   Oakland CA 94618 Retired 124 Retired n   2014-05-20 100 100      
18755 18755 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   e7vAtzMpzkuz IND Nunez Jody   Oakland CA 94611 County of Alameda 2540 Attorney n   2014-05-23 500 500      
18756 18756 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   37jj4IramqvY IND Altshuler Lynn   San Francisco CA 94118 Independent Law Practice Professional 4137 Attorney n   2014-05-28 100 100      
18757 18757 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   mB1iI7tVi3Hl IND Schlichtmann Laura   Oakland CA 94618 Retired 124 Retired n   2014-05-29 100 100      
18758 18758 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   DPLHNtakoKhE IND Abrams James   Oakland CA 94107 Greene, Radovsky, Maloney, Share & Hennigh 4138 Attorney n   2014-06-01 200 200      
18759 18759 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   A5odJZQSBDpf COM DRIVE Committee     WASHINGTON DC 20001     n   2014-06-02 500 500   41.0  
18760 18760 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   H4swWHfcGOoG IND McCarthy Joseph   Moraga CA 94556 BRIDGE Housing Corporation 73 Senior Project Manager n   2014-06-02 150 150      
18761 18761 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   NQOCJK5NqjB7 IND Shawl Susan   Oakland CA 94618 Retired 124 Retired n   2014-06-02 100 100      
18762 18762 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   raE6zb4BlOUc IND Belcher Judith Anne   Oakland CA 94609 Retired 124 Retired n   2014-06-04 100 100      
18763 18763 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   Z9TvhqI8d38e IND Hamlin Earl   Oakland CA 94618 Port of Oakland 421 Port Commissioner n   2014-06-04 700 700      
18764 18764 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   VjbSvq8dNWu1 IND Kaplan Rebecca   Oakland CA 94607 City of Oakland 8 City Councilmember n   2014-06-04 180 180      
18765 18765 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   ufby9VrizdWO IND Lewandowski Kent   Oakland CA 94606 Kaiser Permanente 137 Senior Data Consultant n   2014-06-04 150 150      
18766 18766 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   pFIoHcb2md4L IND Niesar Ortrun   Oakland CA 94618 Sothebys 4139 Realtor n   2014-06-04 100 100      
18767 18767 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   xgdBKvZ4enJC IND Nye Bruce   Oakland CA 94618 Adams, Nye, Becht LLP 4140 Attorney n   2014-06-04 150 150      
18768 18768 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   2nTORHXSbHrC IND Raich Robert   Oakland CA 94619 Self 228 Attorney n   2014-06-04 500 500      
18769 18769 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   kJjsbWBKAQpm IND Rosenthal Susan   Oakland CA 94610 Operating Engineers Local Union No. 3 4141 Staff n   2014-06-04 100 100      
18770 18770 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   zelyPkRhg8AZ OTH Susan Piper Public Relations     Oakland CA 94618     n   2014-06-04 100 100      
18771 18771 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   Q9dDwtMtbf4v IND Toney Mark   Oakland CA 94619 TURN 449 Executive Director n   2014-06-04 100 100      
18772 18772 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   r9e6qI2vdfib IND Wasserman Robert   Oakland CA 94610 Wendel, Rosen, Black & Dean LLP 816 Partner/Lawyer n   2014-06-04 250 250      
18773 18773 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   OXIaRTgvfJr6 IND Willis Amy   Oakland CA 94612 International Longshore and Warehouse Union 4142 Researcher/International Organizer n   2014-06-04 100 100      
18774 18774 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   YK5NEho2TArS IND Alterman Ronald   Oakland CA 94618 Global Technology Solutions Group/International Business Machines Corporation 4143 Consultant n   2014-06-05 150 150      
18775 18775 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   ald5XSPJKc6k OTH Realtor Christina, Inc.     Redwood City CA 94063     n   2014-06-06 150 150      
18776 18776 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   T4oayKpiOBkk IND Jaicks Agar   San Francisco CA 94117 Retired 124 Retired n   2014-06-09 200 200      
18777 18777 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   9hcmkVP9kbwc IND Horne Nina   Oakland CA 94610 Public Insight 4144 Policy Consulting n   2014-06-25 100 100      
18778 18778 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   IFP9i38VqGs6 IND Bair Jonathan   Oakland CA 94612 Circlepoint 1808 Senior Associate, Strategic Communications n   2014-06-29 100 100      
2803 2803 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   BNKBkb52ROuw COM Dan Kalb for City Council 2012     Oakland CA 94612     n   2013-11-09 200 200   82.0  
2804 2804 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   OdnzPxWL3lVj IND Flashman Stuart   Oakland CA 94618 Law Offices of Stuart Flashman 314 Attorney n   2013-11-25 300 300      
2805 2805 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   iLvfR8G5uUO2 IND Anderson Tim   Oakland CA 94609 F T I Consulting, Inc. 821 Consultant n   2013-11-27 700 700      
2806 2806 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   R9rsFq2qOmpq IND Bliss John   Oakland CA 94618 SCI Consulting Group 822 Engineer n   2013-11-29 500 500      
2807 2807 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   XSnMzcjVc3tU COM Bay Area Citizens PAC     Oakland CA 94612-1427     n   2013-12-09 700 700   83.0  
2808 2808 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   8kUUcBnApOPm IND Cox Janet   Oakland CA 94611 Association of Bay Area Governments 823 Communications n   2013-12-09 100 100      
2809 2809 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   tbMLMZPqv3q4 IND McPherson Wendy   Oakland CA 94607 The Sunnyside Cafe 824 Owner n   2013-12-09 699 699      
2810 2810 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   gh3FO7owswoJ OTH Rena Rickles Attorney at Law     Oakland CA 94612     n   2013-12-09 100 100      
2811 2811 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   vwnsbCNkkuYI IND Shireman Bob   Berkeley CA 94707 Community Initiatives 825 Executive Director, California Competes n   2013-12-09 125 125      
2812 2812 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   ok7e7SBUkrvy IND Koteen Earl   Berkeley CA 94709 Unitarian Universalist Legislative Ministry California 826 Minister n   2013-12-12 100 100      
2813 2813 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   gzbR9ksx67TG IND Raich Robert   Oakland CA 94619 Self 228 Attorney n   2013-12-16 500 500      
2814 2814 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   U4LD3yrFL9yt COM Service Employees International Union Local 1021     Santa Rosa CA 95401     n   2013-12-17 700 700   39.0  
2815 2815 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   ob2NS2Z3Wwc6 IND Cornu-Toney Sharon   Oakland CA 94619 Opportunity Partners 827 Chief Strategy Officer n   2013-12-18 100 100      
2816 2816 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   GhpHONa4tpVE COM INTERNATIONAL FEDERATION OF PROFESSIONAL AND TECHNICAL ENGINEERS     San Francisco CA 94102     n   2013-12-23 500 500   31.0  
2817 2817 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   TTR6DuBFKG6V COM DRIVE Committee     WASHINGTON DC 20001     n   2013-12-31 500 500   41.0  
2818 2818 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   GLlLl8Xagfsv COM SIKH PAC     Concord CA 94518-2331     n   2013-12-31 1300 1300   84.0  

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");