monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

1,127 rows where filer_name = 87 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_amt, 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
27863 27863 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1060 COM Aimee Eng for School Board 2014     Oakland CA 94610     n   2015-01-16 175 175   160.0  
27864 27864 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1102 OTH Baines Group, Inc.     Oakland CA 94612     n   2015-03-18 100 100      
27865 27865 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1095 IND Borsuk Mark   San Francisco CA 94123 Mark Borsuk, Inc. 1539 Real Estate Broker n   2015-03-17 500 500      
27866 27866 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1071 SCC Construction & General Laborers Local Union 304 PAC     Sacramento CA 95814     n   2015-02-11 700 700   66.0  
27867 27867 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1079 COM David Vela for School Board 2015     Los Angeles CA 90010     n   2015-03-03 250 250   349.0  
27868 27868 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1096 IND Esposito Christopher   San Francisco CA 94131 Grace and Company 4673 Director of Human Resources n   2015-03-18 300 300      
27869 27869 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1087 IND Fearn Emilene   Oakland CA 94610   Not Employed n   2015-03-05 150 150      
27870 27870 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1089 IND Fearn Jeffrey   Oakland CA 94610   Retired n   2015-03-10 350 350     INC1089
27871 27871 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1103 IND Grace Daniel   San Leandro CA 94577 Grace & Co., Inc. 2361 Nurseryman n   2015-03-18 200 200      
27872 27872 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1141 IND Gulassa Cyril   Oakland CA 94618 Peralata College 2362 Trustee n   2015-06-26 100 100      
27873 27873 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1105 IND Jelks Betty   Oakland CA 94602 College of Alameda 2385 Adjunct Counselor n   2015-03-18 150 150      
27874 27874 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1073 SCC Laborers Local Union 270 PAC Small Contributor Committee     Sacramento CA 95814     n   2015-02-17 700 700   228.0  
27875 27875 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1098 IND Lopez Jose   Oakland CA 94612 Devlabs 3294 Coder n   2015-03-17 150 150      
27876 27876 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1107 OTH Mobile Connectory LLC     Oakland CA 94618     n   2015-03-18 700 700      
27877 27877 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1072 SCC Northern California District Council of Laborers PAC Small Contributor Committee     Sacramento CA 95814     n   2015-02-11 700 700   230.0  
27878 27878 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1121 IND Rosario Dionisio   Oakland CA 94610 Alameda Labor Council 3300 Executive Committee Member n   2015-04-30 100 100      
27879 27879 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1108 IND Ruybal Robert   Napa CA 94558 Xerox Corporation 4674 Strategic Account Executive n   2015-03-18 100 100      
27880 27880 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1070 COM San Francisco Laborer's Local 261 PAC     San Francisco CA 94110     n   2015-02-11 700 700   231.0  
27881 27881 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1090 IND Stein David   Oakland CA 94610 Donahue Fitzgerald, LLP 3279 Attorney n   2015-03-11 150 150      
27882 27882 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1099 IND Sullivan Michael   Oakland CA 94611 Genentech 2165 Policy n   2015-03-18 250 500      
27883 27883 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1100 IND Sullivan Michael   Oakland CA 94611 Genentech 2165 Policy n   2015-03-19 250 500      
27884 27884 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1109 IND Terry Timothy S.   Oakland CA 94610 Bridge the Chasm 819 Communications, Research and Affiliations n   2015-03-18 100 100      
27885 27885 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1106 OTH The McConnell Group     Danville CA 94506     n   2015-03-18 700 700      
27886 27886 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1134 COM United Food & Commercial Workers Local 5 PAC     San Jose CA 95113     n   2015-06-08 250 250   40.0  
27887 27887 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-07-21 2015-01-01 2015-06-30   INC1110 IND Wasserman Robert Z.   Oakland CA 94610 Wendel Rosen Black & Dean LLP 3031 Attorney n   2015-03-18 250 250      
11018 11018 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC912 IND Anaya Elena   Oakland CA 94611 Turner Construction 2346 Community Affairs Director n   2014-10-28 100 150      
11019 11019 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC971 OTH Anthonio, Inc.     Castro Valley CA 94546     n   2014-11-04 500 500      
11020 11020 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1007 IND Apodaca Robert J.   Oakland CA 94607 ZeZen 2329 Business Development n   2014-12-08 100 350      
11021 11021 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC973 IND Arreola Pro Rosario   Woodland CA 95776 California Rual Indian Health Board 3283 Health Care Administrator n   2014-11-05 100 100      
11022 11022 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC946 IND Bair Jonathan   Oakland CA 94612 Circlepoint 1808 Communications Strategist n   2014-10-29 25 375      
11023 11023 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1023 COM Bay Area Citizens PAC     Emeryville CA 94608     n   2014-12-08 700 700   83.0  
11024 11024 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC954 IND Bent Elizabeth   Oakland CA 94610 Nelson/Nygaard 2762 Transportation Planner n   2014-10-30 50 300      
11025 11025 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC910 COM Berkeley Firefighters Association Local 1227 PAC     Sacramento CA 95814     n   2014-10-30 1000 1000   259.0  
11026 11026 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC982 IND Bonilla Julina   Oakland CA 94606 Julina Bonilla 2332 Workforce Development Expert n   2014-11-22 100 200      
11027 11027 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC970 IND Boone Elisa Arevalo   Oakland CA 94610 Wells Fargo 294 Regional Sales Consultant n   2014-11-04 100 100      
11028 11028 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC975 IND Briones Louis   Oakland CA 94602 Briones International LLC 3284 Accountant n   2014-11-04 100 100      
11029 11029 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1003 IND Caldera Arquimides Tomas   Alameda CA 94501 City of Fremont 1792 Deputy Human Services Director n   2014-12-08 75 600      
11030 11030 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC972 SCC California Nurses Association PAC Small Contributor Committee     Sacramento CA 95814     n   2014-11-04 500 500   95.0  
11031 11031 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1021 IND Chan Carl   Alameda CA 94502 Claremont Realty 353 Realtor n   2014-12-08 250 250      
11032 11032 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC955 IND Chavez Michael   Berkeley CA 94702 Mass Mutual 3141 Financial Advisor n   2014-10-31 25 190      
11033 11033 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC899 IND Chen Arthur   Oakland CA 94610 Arthur Chen 3285 Physician n   2014-10-24 600 600      
11034 11034 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC983 IND Coaston Shirley   Oakland CA 94605   Retired n   2014-11-22 100 100      
11035 11035 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC984 IND Compton Kerry K.   Oakland CA 94618 Peralta Community College District 1080 Vice President of Student Services n   2014-11-22 100 200      
11036 11036 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1015 IND Correa Beverly   Oakland CA 94610-2103 OBDC Small Business Finance 2342 Managing Director n   2014-12-08 50 150      
11037 11037 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC957 IND Delgado-Olson Benito   Oakland CA 94619 K to College 648 Executive Director n   2014-10-30 50 100      
11038 11038 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC985 IND Eagan Anne   Oakland CA 94607 Anne Eagan 2350 Fundraising Consultant n   2014-11-22 25 225      
11039 11039 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC901 IND Fearn Emilene   Oakland CA 94610   Not Employed n   2014-10-24 100 550      
11040 11040 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC958 IND Fearn Emilene   Oakland CA 94610   Not Employed n   2014-10-30 250 550      
11041 11041 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1020 IND Fearn Jeffrey   Oakland CA 94610   Retired n   2014-12-08 250 700      
11042 11042 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC952 IND Galaviz Felix   Hayward CA 94542   Retired n   2014-11-01 250 250      
11043 11043 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1043 OTH Gallo Noah   Oakland CA 94601 Oracle 320 Enterprise Consultant n   2014-12-07 250 250      
11044 11044 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1018 IND Goodall Brendalynn   Oakland CA 94605   Retired n   2014-12-08 100 250      
11045 11045 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC967 IND Grant Ronald   Oakland CA 94605   Retired n   2014-11-04 100 100      
11046 11046 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC934 IND Guillen Kevin   San Pablo CA 94806 Wells Fargo Bank 178 Personal Banker n   2014-10-21 150 375      
11047 11047 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC935 IND Gunston Elizabeth   Oakland CA 94610 Bay Area Union Debate League (BAUDL) 3286 Operations Manager n   2014-10-20 100 100      
11048 11048 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1029 IND Hirschfield C.J.   Oakland CA 94610 Childrens Fairyland 3287 Executive n   2014-12-29 100 100      
11049 11049 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC905 COM IBEW Local Union 1245 Political Donation Account     Vacaville CA 95696     n   2014-10-30 500 500   56.0  
11050 11050 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC961 IND Irigui Eriberto   Bonita CA 91902 Chula Vista Elementary School District 3288 Administrator n   2014-11-03 100 100      
11051 11051 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC997 IND Jensen Anne   Oakland CA 94610 Episcopal Church 3289 Director n   2014-11-25 100 100      
11052 11052 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC966 IND Jongco Angelica K.   Oakland CA 94610 Public Advocates Making Rights Real 3290 Attorney n   2014-11-04 50 100      
11053 11053 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1010 IND Jongco Angelica K.   Oakland CA 94610 Public Advocates Making Rights Real 3290 Attorney n   2014-12-08 50 100      
11054 11054 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1044 IND Joshi Viral   Oakland CA 94609 C2 Financial Corporation 3291 Loan Consultant/Branch Manager n   2014-12-03 100 100      
11055 11055 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1002 IND Katz Alex   Emeryville CA 94608 City Attorney Barbara Parker 3292 Chief of Staff n   2014-12-08 150 150      
11056 11056 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC965 IND Kerner Lakshmi Hannah   Oakland CA 94602   Retired n   2014-11-04 100 250      
11057 11057 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC936 IND Klement Tal   Oakland CA 94608 San Fransico Public Defender's Office 3293 Attorney n   2014-10-20 100 100      
11058 11058 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC914 IND Leon Maurilio   Oakland CA 94601 Four Leaf Consulting 809 Consultant n   2014-10-28 100 700      
11059 11059 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC977 IND Lopez Jose   Oakland CA 94612 Devlabs 3294 Coder n   2014-11-05 250 250      
11060 11060 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1046 IND Lounds Darin Ryan   Oakland CA 94606 Housing Consortium of the East Bay 3148 Executive Director n   2014-12-06 50 150      
11061 11061 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1005 IND Maxwell Helene   Oakland CA 94602   Retired n   2014-12-08 100 439      
11062 11062 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC959 IND Mayer Guillermo   Oakland CA 94610 Public Advocates, Inc. 3295 Attorney n   2014-10-31 250 250      
11063 11063 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC938 IND Murphy Stacey H.   Oakland CA 94609 Abode Services 2381 Director of Strategic Initiatives n   2014-10-23 250 500      
11064 11064 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC986 IND Nexica Irene   Oakland CA 94609 San Francisco State University 3296 Adjunct Professor n   2014-11-22 25 100      
11065 11065 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC987 IND Nguyen Thuy   Castro Valley CA 94552 Peralta Community College District 1080 Attorney n   2014-11-22 200 200      
11066 11066 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC909 COM Northern California Chapter, NECA PAC     Dublin CA 94568-3006     n   2014-10-30 500 1000   229.0  
11067 11067 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1001 IND Pham Thunguyet   Oakland CA 94619 Dr. Hai Pham, DDS 3297 Office Manager n   2014-12-10 500 500      
11068 11068 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC998 IND Raich Robert   Oakland CA 94619 Robert Raich 3298 Attorney n   2014-11-26 700 700      
11069 11069 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC939 IND Raya Richard   Oakland CA 94608 ClimatePlan 3299 Director n   2014-10-25 325 335      
11070 11070 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC916 IND Raya Richard   Oakland CA 94608 ClimatePlan 3299 Director n   2014-10-28 10 335      
11071 11071 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1037 IND Rocha Olivia   El Cerrito CA 94530 OCM, Inc. 2400 Project Manager n   2014-12-08 100 300      
11072 11072 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC950 IND Rosario Dionisio   Oakland CA 94610 Alameda Labor Council 3300 Executive Committee Member n   2014-10-29 50 100      
11073 11073 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC902 IND Rubin Victor   Oakland CA 94602 Center for Collaborative Research for an Equitable California 3301 Vice President for Research n   2014-10-24 100 100      
11074 11074 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC895 SCC Service Employees International Union Local 1000 Candidate PAC Small Contributor Committee     Sacramento CA 95814     n   2014-10-24 1400 1400   260.0  
11075 11075 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC991 COM Sprinkler Fitters and Apprentices Local 483 Local PAC     Sacramento CA 95814     n   2014-11-25 500 500   80.0  
11076 11076 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC988 IND Stein David   Oakland CA 94610 Donahue Fitzgerald, LLP 3279 Attorney n   2014-11-22 250 350      
11077 11077 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1006 IND Stroup Ruth   Oakland CA 94602 Farmer's Insurance 360 Agency Owner n   2014-12-08 250 500      
11078 11078 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC999 IND Tang My   Oakland CA 94619 Wells & Bennett 3302 Realtor n   2014-11-25 100 100      
11079 11079 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1013 IND Ubelhart Sara E.   San Leandro CA 94577 Zocalo Coffee Shop 3303 Owner n   2014-12-08 700 700      
11080 11080 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC907 COM Unite HERE Tip State & Local Fund     New York NY 10001     n   2014-10-30 700 700   261.0  
11081 11081 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC1012 IND Wasserman Robert Z.   Oakland CA 94610 Wendel Rosen Black & Dean LLP 3031 Attorney n   2014-12-08 250 250      
11082 11082 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-06-26 2014-10-19 2014-12-31   INC940 IND Weltin Daniel   Concord CA 94518 Weltin, Sterb & Weltin 2413 Attorney n   2014-10-21 100 400      
13274 13274 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-01-31 2014-10-19 2014-12-31   INC912 IND Anaya Elena   Oakland CA 94611 Turner Construction 2346 Community Affairs Director n   2014-10-28 100 150      
13275 13275 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-01-31 2014-10-19 2014-12-31   INC971 OTH Anthonio, Inc.     Castro Valley CA 94546     n   2014-11-04 500 500      
13276 13276 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-01-31 2014-10-19 2014-12-31   INC1007 IND Apodaca Robert J.   Oakland CA 94607 ZeZen 2329 Business Development n   2014-12-08 100 350      
13277 13277 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-01-31 2014-10-19 2014-12-31   INC973 IND Arreola Pro Rosario   Woodland CA 95776 California Rual Indian Health Board 3283 Health Care Administrator n   2014-11-05 100 100      
13278 13278 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-01-31 2014-10-19 2014-12-31   INC946 IND Bair Jonathan   Oakland CA 94612 Circlepoint 1808 Communications Strategist n   2014-10-29 25 375      
13279 13279 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-01-31 2014-10-19 2014-12-31   INC1023 COM Bay Area Citizens PAC     Emeryville CA 94608     n   2014-12-08 700 700   83.0  
13280 13280 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-01-31 2014-10-19 2014-12-31   INC954 IND Bent Elizabeth   Oakland CA 94610 Nelson/Nygaard 2762 Transportation Planner n   2014-10-30 50 300      
13281 13281 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-01-31 2014-10-19 2014-12-31   INC910 COM Berkeley Firefighters Association Local 1227 PAC     Sacramento CA 95814     n   2014-10-30 1000 1000   259.0  
13282 13282 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-01-31 2014-10-19 2014-12-31   INC982 IND Bonilla Julina   Oakland CA 94606 Julina Bonilla 2332 Workforce Development Expert n   2014-11-22 100 200      
13283 13283 1365384 87 Abel Guillen for Oakland City Council 2014 87 2015-01-31 2014-10-19 2014-12-31   INC970 IND Boone Elisa Arevalo   Oakland CA 94610 Wells Fargo 294 Regional Sales Consultant n   2014-11-04 100 100      

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