monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

89 rows where filer_id = 199 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, last_name, first_name, city, zipcode, employer, occupation, transaction_date, transaction_amt, year_to_date, committee_id, 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
94486 94486 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2023-04-25 2023-01-01 2023-04-24   INC242 COM Oakland Neighbors for Affordable Housing and Safe Streets, Yes on U, 2022     Alameda CA 94501     n   2023-04-06 3500 3500   1039.0  
67830 67830 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC142 OTH Best Bay Apartments Inc.     Oakland CA 94601     n   2020-02-27 10000 10000      
67831 67831 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC130 IND Hellman Judith   San Francisco CA 94104 University of California, San Francisco 3188 Professor, Anesthesia n   2020-02-26 5000 5000      
67832 67832 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC143 IND Hellman Marco   San francisco CA 94104 HMI Capital 10740 Investor n   2020-02-27 10000 10000      
67833 67833 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC125 COM IFPTE Local 21 Issues PAC Fund     San Francisco CA 94103     n   2020-02-25 4000 4000   251.0  
67834 67834 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC131 IND Kuiper Heather   Oakland CA 94618 Self Employed / Same Name 8500 Public Health Consultant n   2020-02-26 500 500      
67835 67835 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC144 IND Montauk Susan   Oakland CA 94618   Retired n   2020-02-27 1000 1000      
67836 67836 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC123 OTH PG&E Corporation     San Francisco CA 94105     n   2020-02-24 7500 7500      
67837 67837 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC145 IND Pitcock Daniel   Oakland CA 94612 Roberts Electric 7982 Electrical Contractor n   2020-02-27 500 500      
67838 67838 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC176 COM Re- Elect Nikki F Bas for City Council 2022     Roseville CA 95661     n   2020-03-16 1000 1000   822.0  
67839 67839 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC121 COM Service Employees International Union Local 1021 Issues PAC     Sacramento CA 95814     n   2020-02-20 10000 10000   238.0  
67840 67840 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC164 IND Taylor Loren   Oakland CA 94605 City Of Oakland 2163 Councilmember n   2020-03-04 500 1000      
67841 67841 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC163 IND Taylor Loren   Oakland CA 94605 City Of Oakland 2163 Councilmember n   2020-03-04 500 1000      
67842 67842 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-27 2020-02-16 2020-06-30   INC207 COM The Oakland Fund     Oakland CA 94607     n   2020-06-01 5000 5000   612.0  
55485 55485 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC91 IND Bliss John   Oakland CA 94618 Sci Consulting Group 8465 Civil Engineer n   2020-02-09 1000 1000      
55486 55486 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC96 OTH California Trust For Public Land Action Fund     San Francisco CA 94104     n   2020-02-12 2500 2500      
55487 55487 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC92 OTH Flynn Investments     San Francisco CA 94133     n   2020-02-10 10000 0      
55488 55488 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 EXP116 OTH Flynn Investments     San Francisco CA 94133     n R 2020-02-10 -10000 0     EXP116
55489 55489 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC107 IND Hardy Patricia   Oakland CA 94610   Retired n   2020-02-13 100 100      
55490 55490 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC51 OTH Kaiser Permanente     Pasadena CA 91103     n   2020-01-21 150000 150000      
55491 55491 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC63 IND Marcone Monica   Oakland CA 94618 Solutions For Good 8804 Nonprofit Consultant n   2020-01-23 250 250      
55492 55492 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC80 IND Milligan Kyle   Oakland CA 94610 Self-Employed / Same Name 8803 Artist n   2020-01-30 300 500      
55493 55493 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC90 IND Schaaf Libby   Oakland CA 94602 City Of Oakland 2163 Mayor n   2020-02-09 1000 1000      
55494 55494 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC79 IND Spears Robert   Oakland CA 94618 Shoreline Venture Management 1226 Venture Capitalist n   2020-02-06 1000 1000      
55495 55495 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC106 IND Takagi Miye   Piedmont CA 94611 40th Street Apartments LLC 1540 Real Estate Owner/Manager n   2020-02-12 100 100      
55496 55496 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC66 IND Udkow Michael   Oakland CA 94610-2441   Not Employed n   2020-01-22 250 250      
55497 55497 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-07-15 2020-01-19 2020-02-15 2020-03-03 INC95 IND Unger Zac   Oakland CA 94618 City Of Oakland 2163 Firefighter n   2020-02-12 100 100      
55498 55498 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC91 IND Bliss John   Oakland CA 94618 Sci Consulting Group 8465 Civil Engineer n   2020-02-09 1000 1000      
55499 55499 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC96 OTH California Trust For Public Land Action Fund     San Francisco CA 94104     n   2020-02-12 2500 2500      
55500 55500 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC92 OTH Flynn Investments     San Francisco CA 94133     n   2020-02-10 10000 0      
55501 55501 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 EXP116 OTH Flynn Investments     San Francisco CA 94133     n R 2020-02-10 -10000 0     EXP116
55502 55502 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC107 IND Hardy Patricia   Oakland CA 94610   Retired n   2020-02-13 100 100      
55503 55503 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC51 OTH Kaiser Permanente     Pasadena CA 91103     n   2020-01-21 150000 150000      
55504 55504 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC63 IND Marcone Monica   Oakland CA 94618 Solutions For Good 8804 Nonprofit Consultant n   2020-01-23 250 250      
55505 55505 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC80 IND Milligan Kyle   Oakland CA 94610 Self-Employed / Same Name 8803 Artist n   2020-01-30 300 500      
55506 55506 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC90 IND Schaaf Libby   Oakland CA 94602 City Of Oakland 2163 Mayor n   2020-02-09 1000 1000      
55507 55507 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC79 IND Spears Robert   Oakland CA 94618 Shoreline Venture Management 1226 Venture Capitalist n   2020-02-06 1000 1000      
55508 55508 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC106 IND Takagi Miye   Piedmont CA 94611 40th Street Apartments LLC 1540 Real Estate Owner/Manager n   2020-02-12 100 100      
55509 55509 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC66 IND Udkow Michael   Oakland CA 94610-2441   Not Employed n   2020-01-22 250 250      
55510 55510 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC95 IND Unger Zac   Oakland CA 94618 City Of Oakland 2163 Firefighter n   2020-02-12 100 100      
55511 55511 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC91 IND Bliss John   Oakland CA 94618 Sci Consulting Group 8465 Civil Engineer n   2020-02-09 1000 1000      
55512 55512 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC96 OTH California Trust For Public Land Action Fund     San Francisco CA 94104     n   2020-02-12 2500 2500      
55513 55513 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC92 OTH Flynn Investments     San Francisco CA 94133     n   2020-02-10 10000 0      
55514 55514 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 EXP116 OTH Flynn Investments     San Francisco CA 94133     n R 2020-02-10 -10000 0     EXP116
55515 55515 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC107 IND Hardy Patricia   Oakland CA 94610   Retired n   2020-02-13 100 100      
55516 55516 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC51 OTH Kaiser Permanente     Pasadena CA 91103     n   2020-01-21 150000 150000      
55517 55517 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC63 IND Marcone Monica   Oakland CA 94618 Solutions For Good 8804 Nonprofit Consultant n   2020-01-23 250 250      
55518 55518 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC80 IND Milligan Kyle   Oakland CA 94610 Self-Employed / Same Name 8803 Artist n   2020-01-30 300 500      
55519 55519 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC90 IND Schaaf Libby   Oakland CA 94602 City Of Oakland 2163 Mayor n   2020-02-09 1000 1000      
55520 55520 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC79 IND Spears Robert   Oakland CA 94618 Shoreline Venture Management 1226 Venture Capitalist n   2020-02-06 1000 1000      
55521 55521 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC106 IND Takagi Miye   Piedmont CA 94611 40th Street Apartments LLC 1540 Real Estate Owner/Manager n   2020-02-12 100 100      
55522 55522 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC66 IND Udkow Michael   Oakland CA 94610-2441   Not Employed n   2020-01-22 250 250      
55523 55523 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-21 2020-01-19 2020-02-15 2020-03-03 INC95 IND Unger Zac   Oakland CA 94618 City Of Oakland 2163 Firefighter n   2020-02-12 100 100      
55524 55524 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC91 IND Bliss John   Oakland CA 94618 Sci Consulting Group 8465 Civil Engineer n   2020-02-09 1000 1000      
55525 55525 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC96 OTH California Trust For Public Land Action Fund     San Francisco CA 94104     n   2020-02-12 2500 2500      
55526 55526 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC92 OTH Flynn Investments     San Francisco CA 94133     n   2020-02-10 10000 10000      
55527 55527 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC107 IND Hardy Patricia   Oakland CA 94610   Retired n   2020-02-13 100 100      
55528 55528 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC51 OTH Kaiser Permanente     Pasadena CA 91103     n   2020-01-21 150000 150000      
55529 55529 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC63 IND Marcone Monica   Oakland CA 94618 Solutions For Good 8804 Nonprofit Consultant n   2020-01-23 250 250      
55530 55530 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC80 IND Milligan Kyle   Oakland CA 94610 Self-Employed / Same Name 8803 Artist n   2020-01-30 300 500      
55531 55531 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC90 IND Schaaf Libby   Oakland CA 94602 City Of Oakland 2163 Mayor n   2020-02-09 1000 1000      
55532 55532 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC79 IND Spears Robert   Oakland CA 94618 Shoreline Venture Management 1226 Venture Capitalist n   2020-02-06 1000 1000      
55533 55533 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC106 IND Takagi Miye   Piedmont CA 94611 40th Street Apartments LLC 1540 Real Estate Owner/Manager n   2020-02-12 100 100      
55534 55534 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC66 IND Udkow Michael   Oakland CA 94610-2441   Not Employed n   2020-01-22 250 250      
55535 55535 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-20 2020-01-19 2020-02-15 2020-03-03 INC95 IND Unger Zac   Oakland CA 94618 City Of Oakland 2163 Firefighter n   2020-02-12 100 100      
52773 52773 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2019-01-01 2019-12-31   INC9 IND LeClair Thomas   Oakland CA 94608 Jerome And Horner 8483 Business Owner n   2019-12-23 100 100      
52774 52774 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2019-01-01 2019-12-31   INC6 IND Levin Brooke   Oakland CA 94618   Retired n   2019-12-20 1000 1000      
52775 52775 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2019-01-01 2019-12-31   INC1 COM The Oakland Fund     Oakland CA 94607     n   2019-12-16 10000 10000   671.0  
52776 52776 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2019-01-01 2019-12-31   INC7 IND Udkow Michael   Oakland CA 94610-2441   Not Employed n   2019-12-21 100 100      
55478 55478 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-01 2020-01-18 2020-03-03 INC34 IND Milligan Kyle   Oakland CA 94610 Self-Employed / Same Name 8803 Artist n   2020-01-14 200 200      
55479 55479 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-01 2020-01-18 2020-03-03 INC14 IND Rickard Rick   Oakland   94602   Retired n   2020-01-05 100 100      
69244 69244 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC91 IND Bliss John   Oakland CA 94618 Sci Consulting Group 8465 Civil Engineer n   2020-02-09 1000 1000      
69245 69245 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC96 OTH California Trust For Public Land Action Fund     San Francisco CA 94104     n   2020-02-12 2500 2500      
69246 69246 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC92 OTH Flynn Investments     San Francisco CA 94133     n   2020-02-10 10000 10000      
69247 69247 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC107 IND Hardy Patricia   Oakland CA 94610   Retired n   2020-02-13 100 100      
69248 69248 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC51 OTH KP Financial SVCS OPS     Pasadena CA 91103     n   2020-01-21 150000 150000      
69249 69249 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC63 IND Marcone Monica   Oakland CA 94618 Solutions For Good 8804 Nonprofit Consultant n   2020-01-23 250 250      
69250 69250 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC80 IND Milligan Kyle   Oakland CA 94610 Self-Employed / Same Name 8803 Artist n   2020-01-30 300 500      
69251 69251 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC90 IND Schaaf Libby   Oakland CA 94602 City Of Oakland 2163 Mayor n   2020-02-09 1000 1000      
69252 69252 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC79 IND Spears Robert   Oakland CA 94618 Shoreline Venture Management 1226 Venture Capitalist n   2020-02-06 1000 1000      
69253 69253 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC106 IND Takagi Miye   Piedmont CA 94611 40th Street Apartments LLC 1540 Real Estate Owner/Manager n   2020-02-12 100 100      
69254 69254 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC66 IND Udkow Michael   Oakland CA 94610-2441   Not Employed n   2020-01-22 250 250      
69255 69255 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-02-16 2020-01-19 2020-02-15 2020-03-03 INC95 IND Unger Zac   Oakland CA 94618 City Of Oakland 2163 Firefighter n   2020-02-12 100 100      
69274 69274 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-01-20 2020-01-01 2020-01-18 2020-03-03 INC34 IND Casentini Susan   Oakland CA 94610 Self Employed 90 Artist n   2020-01-14 200 200      
69275 69275 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-01-20 2020-01-01 2020-01-18 2020-03-03 INC14 IND Rickard Rick   Oakland   94602   Retired n   2020-01-05 100 100      
54414 54414 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-01-09 2019-01-01 2019-12-31   INC9 IND LeClair Thomas   Oakland CA 94608 Jerome And Horner 8483 Business Owner n   2019-12-23 100 100      
54415 54415 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-01-09 2019-01-01 2019-12-31   INC6 IND Levin Brooke   Oakland CA 94618 City of Oakland 8 Director of Public Works n   2019-12-20 1000 1000      
54416 54416 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-01-09 2019-01-01 2019-12-31   INC1 COM The Oakland Fund     Oakland CA 94607     n   2019-12-16 10000 10000   671.0  
54417 54417 1423153 199 Yes on Q! Oakland Neighbors for our Parks and People 250 2020-01-09 2019-01-01 2019-12-31   INC7 IND Udkow Michael   Oakland CA 94610   Not Employed n   2019-12-21 100 100      

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