monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

1,117 rows where filer_id = 147 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_description, 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
40317 40317 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC448 IND Abella David   Richmond CA 94804 Alameda Health System 1608 Attorney n   2018-05-30 125 125      
40318 40318 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC229 IND Adams Mitchell   Oakland CA 94610 OpenText Corporation 6859 Sales n   2018-02-07 250 250      
40319 40319 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC383 IND Aguilar Orson   Oakland CA 94602 Greenlining 5076 President n   2018-04-20 125 250      
40320 40320 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC449 IND Aguilar Orson   Oakland CA 94602 Greenlining 5076 President n   2018-05-30 125 250      
40321 40321 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC283 IND Aikens Dwayne   Oakland CA 94601 We Lead Ours 6860 Executive Director n   2018-02-26 100 150      
40322 40322 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC365 IND Aikens Dwayne   Oakland CA 94601 We Lead Ours 6860 Executive Director n   2018-04-04 50 150      
40323 40323 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC426 OTH Alpha Design & Construction     Oakland CA 94606     n   2018-06-08 800 800      
40324 40324 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC284 IND Altemus Dan   Oakland CA 94610   Not Employed n   2018-02-26 250 250      
40325 40325 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC513 IND Amoni Oraiu   Los Angeles CA 90002 Prime Strategies 6861 Senior Associate n   2018-06-29 250 250      
40326 40326 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC485 IND Anaya Elena   San Francisco CA 94110 Turner Construction 2346 Community & Citizenship Director n   2018-06-22 250 250      
40327 40327 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC366 IND Anderson Tim   Oakland CA 94609 FTI Consulting, Inc. 6862 Technology Consultant n   2018-04-03 800 800      
40328 40328 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC355 IND Anderson Winnie   Oakland CA 94607 Inkwell Studio 4688 Business Owner n   2018-04-05 800 800      
40329 40329 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC587 OTH ARDA, LLC     Oakland CA 94607     n   2018-06-30 800 800      
40330 40330 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC450 IND Avalos Arnoldo   Pleasanton CA 94566   Retired n   2018-05-30 500 500      
40331 40331 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC277 IND Baines Michael E.   Oakland CA 94619 Baines & Robertson 6863 Principal n   2018-03-07 100 143      
40332 40332 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC441 IND Baines Michael E.   Oakland CA 94619 Baines & Robertson 6863 Principal n   2018-06-08 43 143      
40333 40333 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC482 OTH Banister Electrical, Inc.     Antioch CA 94509     n   2018-06-21 800 800      
40334 40334 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC514 IND Bardakian Kim   Oakland CA 94619 Kapor Center 6864 Director of Media Relations n   2018-06-28 125 125      
40335 40335 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC440 IND Barra-Gibson Monica   Oakland CA 94618 City of Oakland 8 Legislative Aide n   2018-06-08 100 100      
40336 40336 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC360 COM Benny Lee for City Council District 4 2016     San Leandro CA 94579     n   2018-04-05 250 250   421.0  
40337 40337 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC395 IND Bliss John   Oakland CA 94618 SCI Consulting Group 822 President n   2018-04-28 800 600      
40338 40338 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   EXP394 IND Bliss John   Oakland CA 94618 SCI Consulting Group 822 President n R 2018-05-09 -500 600     EXP394
40339 40339 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC515 IND Bliss John   Oakland CA 94618 SCI Consulting Group 822 President n   2018-06-26 300 600      
40340 40340 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC315 COM Bricklayers and Allied Craftworkers Local #3 PAC     San Leandro CA 94577     n   2018-03-19 250 250   91.0  
40341 40341 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC518 IND Bueno Marlem   Alameda CA 94501 Tacos Sinaloa 5906 Manager n   2018-06-30 800 800      
40342 40342 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC428 COM Build Jobs PAC     Walnut Creek CA 94597     n   2018-06-08 1500 1500   266.0  
40343 40343 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC322 IND Butner Cestra   Oakland CA 94619 Cestra Butner 6865 Beverage Distribution n   2018-03-30 800 800      
40344 40344 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC323 IND Caldera Arquimides   Alameda CA 94501 City of Fremont 1792 Deputy Human Services Director n   2018-03-28 250 250      
40345 40345 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC230 IND Campbell Andrew   Oakland CA 94611 University of California, Berkeley 384 Executive Director n   2018-02-06 250 375      
40346 40346 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC521 IND Campbell Andrew   Oakland CA 94611 University of California, Berkeley 384 Executive Director n   2018-06-30 125 375      
40347 40347 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC520 IND Campbell Dave   Oakland CA 94612 Bike East Bay 2131 Advocacy Director n   2018-06-28 125 125      
40348 40348 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC285 IND Capristo Francisco   El Cerrito CA 94530 Teecom 6866 Senior Building Information Modeling Specialist n   2018-02-28 100 100      
40349 40349 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC367 IND Chan Daren   Oakland CA 94611 AT&T 1420 Manager n   2018-04-03 125 125      
40350 40350 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC368 IND Chavez Armando   Sacramento CA 95820 California State Senate 2337 Consultant n   2018-04-03 100 100      
40351 40351 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC340 IND Chew Spencer Y.   Rodeo CA 94572   Retired n   2018-04-05 250 250      
40352 40352 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC339 IND Chin Mary L.   Oakland CA 94612   Retired n   2018-04-05 100 100      
40353 40353 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC358 IND Chong Chiming C.   El Sobrante CA 94803   Retired n   2018-04-05 250 250      
40354 40354 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC286 IND Choy Shawn   Oakland CA 94606 Light Hammer, LLC 5982 Real Estate Investor n   2018-02-27 250 0      
40355 40355 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   EXP311 IND Choy Shawn   Oakland CA 94606 Light Hammer, LLC 5982 Real Estate Investor n R 2018-03-19 -250 0     EXP311
40356 40356 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC332 IND Chu Judy   Oakland CA 94607 Golden Land Investment 354 Real Estate Broker n   2018-04-04 500 500      
40357 40357 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC307 IND Cohen Dan   Oakland CA 94612 Full Court Press Communications 426 Principal n   2018-03-07 800 800      
40358 40358 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC287 IND Colbruno Michael   Oakland CA 94610 Milo Group Of California 6867 Managing Partner n   2018-02-26 800 800      
40359 40359 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC345 OTH Commonwealth Companies Real Estate     Oakland CA 94612     n   2018-04-05 500 500      
40360 40360 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC443 IND Connell Raymond K.   Hoboken NJ 07030 Urban Apartment Group 4553 Real Estate n   2018-06-08 250 250      
40361 40361 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC364 COM Construction & General Laborers Local Union 304 PAC     Sacramento CA 95814     n   2018-04-05 1600 1600   66.0  
40362 40362 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC269 IND Cordero Marcus   Oakland CA 94619 UCSF Benioff Children's Hospital Oakland 3338 Compliance/Human Resources n   2018-03-07 100 100      
40363 40363 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC481 OTH Country Builders Construction, Inc.     Livermore CA 94550     n   2018-06-21 500 500      
40364 40364 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC524 IND Covarrubias Michael   San Francisco CA 94104 TMG Partners 1015 Real Estate Developer n   2018-06-27 800 800      
40365 40365 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC454 IND Crawford Alicia   Oakland CA 94611 Alicia Crawford 6868 Nonprofit Consulting n   2018-05-30 100 100      
40366 40366 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC455 IND Cukierman Daniel   Oakland CA 94607 Mad Oak 6869 Business Owner n   2018-06-01 800 800      
40367 40367 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC478 IND Daven, Jr. Fred H.   San Ramon CA 94583 Pinnacle RED Group, LLC 6870 Senior Vice President n   2018-06-21 250 250      
40368 40368 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC343 IND Dea Karen   Oakland CA 94607 Wa Sung Community Service Club 6349 President n   2018-04-05 250 500      
40369 40369 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC447 IND Diamond Stephen P.   Brisbane CA 94005 Diamond Investment Properties 6871 Physician/Real Estate Investor n   2018-06-08 800 800      
40370 40370 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC615 OTH DK Consulting     Walnut Creek CA 94596     n   2018-06-30 500 500      
40371 40371 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC528 IND Dodson Stan   Oakland CA 94605 La Farine Bakery 4588 Operations Manager n   2018-06-29 100 100      
40372 40372 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC529 IND Dong Gilbert   Oakland CA 94610   Retired n   2018-06-29 100 100      
40373 40373 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC264 IND Dwyer Katharine   Oakland CA 94610 Social Justice Collaborative 6872 Board Member n   2018-03-07 100 100      
40374 40374 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC268 IND Dwyer Terrence Steven   Oakland CA 94610 University of California, San Francisco Benioff Children's Hospital Oakland 6873 Chaplain n   2018-03-07 250 250      
40375 40375 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC363 COM East Bay Animal PAC     Oakland CA 94618     n   2018-04-05 1600 1600   551.0  
40376 40376 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC325 IND Eng Tiffany   Oakland CA 94618 Grounded Solutions Network 6874 Non-Profit Program Director n   2018-03-28 200 200      
40377 40377 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC616 OTH ENGEO, Inc.     San Ramon CA 94583     n   2018-06-30 500 500      
40378 40378 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC438 IND Erickson Pamela   Oakland CA 94610 City of Oakland 8 Legislative Aide n   2018-06-08 500 500      
40379 40379 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC276 OTH Experience Auto Body, Inc.     Oakland CA 94606     n   2018-03-07 500 800      
40380 40380 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC589 OTH Experience Auto Body, Inc.     Oakland CA 94606     n   2018-06-30 300 800      
40381 40381 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC236 IND Fearn Emmy   Oakland CA 94610 California State University, East Bay 5986 Professor n   2018-02-22 650 650      
40382 40382 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC237 IND Fearn Jeff   Oakland CA 94610   Not Employed n   2018-02-22 300 300      
40383 40383 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC380 IND Fearn Jonathan   Oakland CA 94609 Summer Hill Apartment Communities 6875 Vice President of Development n   2018-04-10 500 800      
40384 40384 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC530 IND Fearn Jonathan   Oakland CA 94609 Summer Hill Apartment Communities 6875 Vice President of Development n   2018-06-30 300 800      
40385 40385 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC288 IND Fernandez-Smith Kay   San Francisco CA 94111 The San Francisco Foundation 447 Assistant Vice President n   2018-02-27 250 250      
40386 40386 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC532 IND Field Matt   San Francisco CA 94115 TMG Partners 1015 Real Estate n   2018-06-27 250 250      
40387 40387 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC533 IND Fine Sarah   Oakland CA 94610 City of Oakland 8 Project Manager n   2018-06-26 250 250      
40388 40388 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC486 IND Flewellen Brad   Oakland CA 94612 CEF Realty Advisors 6876 Real Estate Advisory n   2018-06-20 250 250      
40389 40389 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC617 OTH FPI Management, Inc.     Folsom CA 95630     n   2018-06-30 500 500      
40390 40390 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC354 OTH Francis Lan Insurance Agency, Inc.     Oakland CA 94607     n   2018-04-05 100 100      
40391 40391 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC534 IND Franco Jimmy   Rocklin CA 95765 Ernst & Young 468 Attorney n   2018-06-30 400 400      
40392 40392 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC317 IND Frankel Aileen   Oakland CA 94618   Not Employed n   2018-03-22 100 100      
40393 40393 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC289 IND Fried Joel   Oakland CA 94610 Bay Area Air Quality Management 6877 Assistant Counsel II n   2018-02-27 100 100      
40394 40394 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC344 IND Friedman Karen   Oakland CA 94612 Karen Friedman 2357 Attorney n   2018-04-05 250 250      
40395 40395 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC291 COM Friends of Bill Riley for Peralta Community College Board of Trustees     Oakland CA 94611     n   2018-03-07 400 400   550.0  
40396 40396 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC535 IND Fuchs Elizabeth   Oakland CA 94610   Retired n   2018-06-28 125 125      
40397 40397 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC508 IND Garcia Abelardo   Fresno CA 93704 Internal Revenue Service 2586 Contact Service Representative n   2018-06-30 100 100      
40398 40398 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC238 IND Gerber Ed   Oakland CA 94611   Volunteer n   2018-02-25 500 500      
40399 40399 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC326 IND Gerber Ed   Oakland CA 94611   Volunteer n   2018-03-29 250 500      
40400 40400 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   EXP333 IND Gerber Ed   Oakland CA 94611   Volunteer n R 2018-04-10 -250 500     EXP333
40401 40401 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC290 IND Gilkerson Tammeil   Oakland CA 94602 Peralta Community College District 1080 Teacher n   2018-02-26 250 250      
40402 40402 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC239 IND Gomez Ivonne   San Pablo CA 94806 Ivonne Gomez 6878 Designer n   2018-02-25 250 250      
40403 40403 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC536 IND Gonzales Rick   Whittier CA 90601 Whittier Union High School District 2360 Teacher n   2018-06-30 400 400      
40404 40404 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC436 IND Gonzales Viola   Oakland CA 94602   Retired n   2018-06-08 129 129      
40405 40405 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC292 IND Grace Daniel   San Leandro CA 94577 Dark Heart Nursery 5146 President n   2018-02-26 500 500      
40406 40406 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC341 IND Guan Guizhen   Oakland CA 94606   Retired n   2018-04-05 250 250      
40407 40407 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC487 IND Guillen Hilario   Martinez CA 94553 Wells Fargo Bank 178 Foreign Exchange n   2018-06-22 125 125      
40408 40408 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC590 IND Guillen Marlene   San Pablo CA 94806   Retired n   2018-06-30 200 200      
40409 40409 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC488 IND Guillen Steve   El Segundo CA 90245 Oath 6879 Account Director n   2018-06-20 250 250      
40410 40410 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC439 IND Hahn Alex   Danville CA 94506 Alex Hahn 5908 Developer n   2018-06-08 500 500      
40411 40411 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC253 IND Hanson James H.   Oakland CA 94610 University of California, San Francisco Benioff Children's Hospital Oakland 6873 Physician n   2018-03-07 100 100      
40412 40412 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC489 IND Heckmann Ron   San Francisco CA 94103 Heckman Communications 6880 Consultant n   2018-06-20 100 100      
40413 40413 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC538 IND Hernandez Jose   Burbank CA 91504 IDEATE California 6881 President n   2018-06-25 800 800      
40414 40414 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC351 IND Hernandez Mary T.   San Francisco CA 94131 Mary T. Hernandez 6882 Attorney n   2018-04-05 100 100      
40415 40415 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC348 IND Hirota Sherry M.   Oakland CA 94619 Asian Health Services 1443 Chief Executive Officer n   2018-04-05 100 100      
40416 40416 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC240 IND Hodge Marcie   Oakland CA 94605 Saint John Boys Home, Inc. 6883 Executive Director n   2018-02-23 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");