monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

89 rows where employer = 731 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, filer_name, report_start_date, report_end_date, election_date, last_name, first_name, city, state, zipcode, occupation, transaction_amt, year_to_date, 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
107447 107447 1476843 355 Loren Taylor for Oakland Mayor 2025 480 2025-04-02 2025-01-01 2025-03-01 2025-04-15 INC348 IND Fajana Nikki   Emeryville CA 94608 Deloitte 731 Senior Manager n   2025-01-15 450 450     INC348
107516 107516 1476843 355 Loren Taylor for Oakland Mayor 2025 480 2025-04-02 2025-01-01 2025-03-01 2025-04-15 INC649 IND Gordon Tanneasha   San Francisco CA 94108 Deloitte 731 Principal and Financial Advisor n   2025-02-02 650 650     INC649
110079 110079 1476843 355 Loren Taylor for Oakland Mayor 2025 480 2025-03-06 2025-01-01 2025-03-01 2025-04-15 INC348 IND Fajana Nikki   Emeryville CA 94608 Deloitte 731 Senior Manager n   2025-01-15 450 450     INC348
110148 110148 1476843 355 Loren Taylor for Oakland Mayor 2025 480 2025-03-06 2025-01-01 2025-03-01 2025-04-15 INC649 IND Gordon Tanneasha   San Francisco CA 94108 Deloitte 731 Principal and Financial Advisor n   2025-02-02 650 650     INC649
111840 111840 1477437 356 Kara Murray Badal for Oakland City Council 2025 481 2025-03-05 2025-01-01 2025-03-01 2025-04-15 INC283 IND Bamgbola Oyindamola   Oakland CA 94607 Deloitte 731 Project Analyst n   2025-02-03 100 100      
97570 97570 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 2025-01-29 2024-09-22 2024-10-19 2024-11-05 INC1728 IND Bhatngar Abby   Newark CA 94560 Deloitte 731 Tax Conusltant n   2024-10-12 105.24 105.24      
100899 100899 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 2024-10-24 2024-09-22 2024-10-19 2024-11-05 INC1728 IND Bhatngar Abby   Newark CA 94560 Deloitte 731 Tax Conusltant n   2024-10-12 105.24 105.24      
103569 103569 1467592 333 Wang for Oakland City Council At Large 2024 452 2024-07-31 2024-01-01 2024-06-30 2024-11-05 kVZYopASdcOS IND Bosnic Nevena   Philadelphia PA 19147 Deloitte 731 Consulting n   2024-06-18 100 175      
103570 103570 1467592 333 Wang for Oakland City Council At Large 2024 452 2024-07-31 2024-01-01 2024-06-30 2024-11-05 CSwbGaGyN1jW IND Bosnic Nevena   Philadelphia PA 19147 Deloitte 731 Consulting n   2024-06-18 75 175      
91829 91829 1462377 315 Zac Unger for Oakland City Council 2024 430 2024-04-01 2023-01-01 2023-12-31 2024-11-05 IDT389 IND Blau Andrew   Oakland CA 94618 Deloitte 731 Managing Director, Consulting n I 2023-11-29 100 100      
91433 91433 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-01-01 2023-06-30   CdpPhgfVxoqc IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-01-04 52.23 313.38      
91434 91434 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-01-01 2023-06-30   bsZDBjWpddkQ IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-02-04 52.23 313.38      
91435 91435 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-01-01 2023-06-30   ezz7l5ktjCmi IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-03-04 52.23 313.38      
91436 91436 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-01-01 2023-06-30   QkOBqVxhdOhV IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-04-04 52.23 313.38      
91437 91437 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-01-01 2023-06-30   osvKInRcGiwg IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-05-04 52.23 313.38      
91438 91438 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-01-01 2023-06-30   OF69pZiWkFlc IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-06-04 52.23 313.38      
92168 92168 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-07-01 2023-12-31   xpo7l11545JA IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-07-04 52.23 626.76      
92169 92169 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-07-01 2023-12-31   IbIPfIavZzMA IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-08-04 52.23 626.76      
92170 92170 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-07-01 2023-12-31   jRfObjRXquhU IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-09-04 52.23 626.76      
92171 92171 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-07-01 2023-12-31   5ulv3tzoWbjr IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-10-04 52.23 626.76      
92172 92172 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-07-01 2023-12-31   3PaOiLbBkin9 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-11-04 52.23 626.76      
92173 92173 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2024-02-20 2023-07-01 2023-12-31   AcHsbJGGbCNa IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-12-04 52.23 626.76      
93032 93032 1462377 315 Zac Unger for Oakland City Council 2024 430 2024-01-31 2023-01-01 2023-12-31 2024-11-05 IDT262 IND Blau Andrew   Oakland CA 94618 Deloitte 731 Managing Director, Consulting n I 2023-11-29 100 100      
93991 93991 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-08-01 2023-01-01 2023-06-30   CdpPhgfVxoqc IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-01-04 52.23 313.38      
93992 93992 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-08-01 2023-01-01 2023-06-30   bsZDBjWpddkQ IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-02-04 52.23 313.38      
93993 93993 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-08-01 2023-01-01 2023-06-30   ezz7l5ktjCmi IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-03-04 52.23 313.38      
93994 93994 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-08-01 2023-01-01 2023-06-30   QkOBqVxhdOhV IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-04-04 52.23 313.38      
93995 93995 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-08-01 2023-01-01 2023-06-30   osvKInRcGiwg IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-05-04 52.23 313.38      
93996 93996 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-08-01 2023-01-01 2023-06-30   OF69pZiWkFlc IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2023-06-04 52.23 313.38      
80970 80970 1448165 282 Kyra Mungia for Oakland School Board 2022 365 2023-07-30 2022-09-25 2022-10-22 2022-11-08 INC347 IND Patterson Nicole   Oakland CA 94619 Deloitte 731 Partner n   2022-10-21 250 250      
82615 82615 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-03-22 2022-10-23 2022-12-31   P9XZRVsamDId IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-11-04 52.23 626.76      
82616 82616 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-03-22 2022-10-23 2022-12-31   DyYefIrD41kw IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-12-04 52.23 626.76      
82397 82397 1441375 266 Loren Taylor for Oakland Mayor 2022 343 2023-01-31 2022-10-23 2022-12-31   5749567 IND Fajana Nikki   El Sobrante CA 94803-3362 Deloitte 731 Consultant n   2022-10-24 900 900      
83587 83587 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-01-31 2022-07-01 2022-12-31   ogcTu8KcBbRP IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-07-04 52.23 626.76      
83588 83588 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-01-31 2022-07-01 2022-12-31   EESIbuWdnkFA IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-08-04 52.23 626.76      
83589 83589 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-01-31 2022-07-01 2022-12-31   qwNJNCtKBdmr IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-09-04 52.23 626.76      
83590 83590 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-01-31 2022-07-01 2022-12-31   ykvWujYSVgKv IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-10-04 52.23 626.76      
83591 83591 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-01-31 2022-07-01 2022-12-31   P9XZRVsamDId IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-11-04 52.23 626.76      
83592 83592 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2023-01-31 2022-07-01 2022-12-31   DyYefIrD41kw IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-12-04 52.23 626.76      
83735 83735 1441375 266 Loren Taylor for Oakland Mayor 2022 343 2023-01-31 2022-10-23 2022-12-31   5749567 IND Fajana Nikki   El Sobrante CA 94803-3362 Deloitte 731 Consultant n   2022-10-24 900 900      
81012 81012 1448165 282 Kyra Mungia for Oakland School Board 2022 365 2023-01-19 2022-09-25 2022-10-22 2022-11-08 INC347 IND Patterson Nicole   Oakland CA 94619 Deloitte 731 Partner n   2022-10-21 250 250      
80493 80493 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-10-27 2022-07-01 2022-09-24 2022-11-08 ogcTu8KcBbRP IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-07-04 52.23 470.07      
80494 80494 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-10-27 2022-07-01 2022-09-24 2022-11-08 EESIbuWdnkFA IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-08-04 52.23 470.07      
80495 80495 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-10-27 2022-07-01 2022-09-24 2022-11-08 qwNJNCtKBdmr IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-09-04 52.23 470.07      
84855 84855 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-10-27 2022-09-25 2022-10-22 2022-11-08 ykvWujYSVgKv IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-10-04 52.23 522.3      
85291 85291 1448165 282 Kyra Mungia for Oakland School Board 2022 365 2022-10-26 2022-09-25 2022-10-22 2022-11-08 INC347 IND Patterson Nicole   Oakland CA 94619 Deloitte 731 Partner n   2022-10-21 250 250      
85944 85944 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-09-29 2022-07-01 2022-09-24 2022-11-08 ogcTu8KcBbRP IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-07-04 52.23 470.07      
85945 85945 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-09-29 2022-07-01 2022-09-24 2022-11-08 EESIbuWdnkFA IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-08-04 52.23 470.07      
85946 85946 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-09-29 2022-07-01 2022-09-24 2022-11-08 qwNJNCtKBdmr IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-09-04 52.23 470.07      
77339 77339 1441375 266 Loren Taylor for Oakland Mayor 2022 343 2022-07-31 2022-01-01 2022-06-30   4434928 IND Piattelli Mike   Mill Valley CA 94941-3751 Deloitte 731 Mgr director n   2022-03-26 50 100      
77340 77340 1441375 266 Loren Taylor for Oakland Mayor 2022 343 2022-07-31 2022-01-01 2022-06-30   4885165 IND Piattelli Mike   Mill Valley CA 94941-3751 Deloitte 731 Mgr director n   2022-06-30 50 100      
88642 88642 1441375 266 Loren Taylor for Mayor 2022 344 2022-07-31 2022-01-01 2022-06-30   4434928 IND Piattelli Mike   Mill Valley CA 94941-3751 Deloitte 731 Mgr director n   2022-03-26 50 100      
88643 88643 1441375 266 Loren Taylor for Mayor 2022 344 2022-07-31 2022-01-01 2022-06-30   4885165 IND Piattelli Mike   Mill Valley CA 94941-3751 Deloitte 731 Mgr director n   2022-06-30 50 100      
90981 90981 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-07-29 2022-01-01 2022-06-30   TZvo8u7ZIBU7 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-01-04 52.23 313.38      
90982 90982 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-07-29 2022-01-01 2022-06-30   wZnnj1LBo6el IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-02-04 52.23 313.38      
90984 90984 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-07-29 2022-01-01 2022-06-30   fI1JLvWEEJOh IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-03-04 52.23 313.38      
90985 90985 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-07-29 2022-01-01 2022-06-30   cRjEYjnVXdS6 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-04-04 52.23 313.38      
90986 90986 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-07-29 2022-01-01 2022-06-30   XZgxWClHidQ2 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-05-04 52.23 313.38      
90987 90987 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-07-29 2022-01-01 2022-06-30   a7pBKfbDhJNh IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2022-06-04 52.23 313.38      
73733 73733 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-01-31 2021-07-01 2021-12-31   Fa8yRGEb5KzV IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-07-04 49.64 660.86      
73753 73753 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-01-31 2021-07-01 2021-12-31   UmgToUdAKb66 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-08-04 52.23 660.86      
73757 73757 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-01-31 2021-07-01 2021-12-31   jEfURZ7J6GtG IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-09-04 52.23 660.86      
73758 73758 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-01-31 2021-07-01 2021-12-31   sB3dr7jYLRy9 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-10-04 52.23 660.86      
73759 73759 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-01-31 2021-07-01 2021-12-31   z5DPHhaNj6Z7 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-11-04 52.23 660.86      
73760 73760 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2022-01-31 2021-07-01 2021-12-31   btAzSbXppMBE IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-12-04 52.23 660.86      
69322 69322 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-10-10 2021-01-01 2021-06-30   7qlTjEiJDNuv IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-01-04 49.64 297.84      
69323 69323 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-10-10 2021-01-01 2021-06-30   GVrWoAZVGMc6 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-02-04 49.64 297.84      
69324 69324 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-10-10 2021-01-01 2021-06-30   8stNAxf445X5 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-03-04 49.64 297.84      
69325 69325 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-10-10 2021-01-01 2021-06-30   pKtSQz3luqnu IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-04-04 49.64 297.84      
69326 69326 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-10-10 2021-01-01 2021-06-30   tcI1iBWQjM9G IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-05-04 49.64 297.84      
69327 69327 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-10-10 2021-01-01 2021-06-30   q6fppxr7hgCI IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-06-04 49.64 297.84      
74416 74416 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-08-02 2021-01-01 2021-06-30   7qlTjEiJDNuv IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-01-04 49.64 297.84      
74417 74417 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-08-02 2021-01-01 2021-06-30   GVrWoAZVGMc6 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-02-04 49.64 297.84      
74418 74418 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-08-02 2021-01-01 2021-06-30   8stNAxf445X5 IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-03-04 49.64 297.84      
74419 74419 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-08-02 2021-01-01 2021-06-30   pKtSQz3luqnu IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-04-04 49.64 297.84      
74420 74420 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-08-02 2021-01-01 2021-06-30   tcI1iBWQjM9G IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-05-04 49.64 297.84      
74421 74421 1435459 233 Loren Taylor for City Council 2018 Officeholder Committee 293 2021-08-02 2021-01-01 2021-06-30   q6fppxr7hgCI IND Piattelli Mike   Mill Valley CA 94941 Deloitte 731 Director n   2021-06-04 49.64 297.84      
48485 48485 1406241 173 Charlie Michelson for Oakland City Council 2018 219 2018-09-26 2018-07-01 2018-09-22 2018-11-06 sJFd7sftRXs4 IND Francis Kerry   Oakland CA 94611 Deloitte 731 accountant n   2018-08-27 200 200      
51511 51511 1401499 160 Loren Taylor for Oakland City Council 200 2018-07-31 2018-01-01 2018-06-30 2018-11-06 de5skd5flc18 IND Scherer Kurt   Oakland CA 94618 Deloitte 731 Business Consultant n   2018-06-23 100 100      
37011 37011 1395968 148 Libby Schaaf for Mayor 2018 185 2018-01-13 2017-07-01 2017-12-31   VNHZWG86BS6 IND Francis Kerry   Piedmont CA 94611-3114 Deloitte 731 Accountant n   2017-11-03 800 1600     VNHZWG86BS6
38040 38040 1395968 148 Libby Schaaf for Mayor 2018 185 2017-07-19 2017-01-01 2017-06-30   VNHZWFWPBG6 IND Francis Kerry   Piedmont CA 94611-3114 Deloitte 731 Accountant n   2017-06-28 800 800      
8312 8312 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2015-01-26 2014-07-01 2014-09-30 2014-11-04 INC525 IND Schweizer Joan F.   Potomac MD 20854 Deloitte 731 Director n   2014-09-02 150 150      
8504 8504 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2014-10-22 2014-07-01 2014-09-30 2014-11-04 INC525 IND Schweizer Joan F.   Potomac MD 20854 Deloitte 731 Director n   2014-09-02 150 150      
16888 16888 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC525 IND Schweizer Joan F.   Potomac MD 20854 Deloitte 731 Director n   2014-09-02 150 150      
7888 7888 1362261 34 Libby Schaaf for Oakland Mayor 2014 28 2014-09-30 2014-07-01 2014-09-30 2014-11-04 VNHZWD3B3T3 IND Scherer Kurt   Oakland CA 94618-1741 Deloitte 731 Business Consultant n   2014-09-09 100 100      
17484 17484 1362261 34 Libby Schaaf for Oakland Mayor 2014 28 2014-09-30 2014-07-01 2014-09-30 2014-11-04 VNHZWD3B3T3 IND Scherer Kurt   Oakland CA 94618-1741 Deloitte 731 Business Consultant n   2014-09-09 100 100      
6365 6365 1362261 34 Libby Schaaf for Oakland Mayor 2014 28 2014-07-29 2014-01-01 2014-06-30   VNHZWCTWE79 IND Francis Kerry   Piedmont CA 94611-3114 Deloitte 731 accountant n   2014-06-16 200 200      
20784 20784 1362261 34 Libby Schaaf for Oakland Mayor 2014 28 2014-07-29 2014-01-01 2014-06-30   VNHZWCTWE79 IND Francis Kerry   Piedmont CA 94611-3114 Deloitte 731 accountant n   2014-06-16 200 200      
2354 2354 1362261 34 Libby Schaaf for Oakland Mayor 2014 28 2014-02-19 2013-07-01 2013-12-31   VNHZWBXMJ59 IND Francis Kerry   Piedmont CA 94611-3114 Deloitte 731 accountant n   2013-12-16 500 500      

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