monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

59 rows where employer = 248 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, filer_name, report_date, report_start_date, report_end_date, election_date, last_name, first_name, city, state, zipcode, occupation, transaction_amt, year_to_date, 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
69282 69282 1426780 210 Derreck Johnson for Oakland City Council 2020 266 2022-07-17 2021-01-01 2021-06-30 2020-11-03 INC1827 IND Monroe Peter   Oakland CA 94605 Coldwell Banker 248 Real Estate Agent n   2021-05-06 500 500      
70600 70600 1442079 265 Treva Reid for Oakland Mayor 2022 342 2022-07-14 2021-01-01 2021-12-31 2022-11-08 INC79 IND Watson Nanine   Oakland CA 94619 Coldwell Banker 248 Realtor n   2021-12-08 100 100      
71528 71528 1441375 266 Loren Taylor for Oakland Mayor 2022 343 2022-01-31 2021-07-01 2021-12-31   3957825 IND Tolbert Reva   Oakland CA 94602-2105 Coldwell Banker 248 Realtor n   2021-12-16 258.32 258.32      
71838 71838 1441375 266 Loren Taylor for Mayor 2022 344 2022-01-31 2021-07-01 2021-12-31   3957825 IND Tolbert Reva   Oakland CA 94602-2105 Coldwell Banker 248 Realtor n   2021-12-16 258.32 258.32      
72642 72642 1441375 266 Loren Taylor for Mayor 2022 344 2022-01-31 2021-07-01 2021-12-31   3957825 IND Tolbert Reva   Oakland CA 94602-2105 Coldwell Banker 248 Realtor n   2021-12-16 258.32 258.32      
73091 73091 1442079 265 Treva Reid for Oakland Mayor 2022 342 2022-01-31 2021-01-01 2021-12-31 2022-11-08 INC79 IND Watson Nanine   Oakland CA 94619 Coldwell Banker 248 Realtor n   2021-12-08 100 100      
74814 74814 1419466 206 Re-Elect Rebecca Kaplan for City Council 2020 258 2021-07-22 2021-01-01 2021-06-30   INC1242 IND Robinson Antonia   Vallejo CA 94591 Coldwell Banker 248 Real Estate Sales n   2021-06-16 500 900      
74815 74815 1419466 206 Re-Elect Rebecca Kaplan for City Council 2020 258 2021-07-22 2021-01-01 2021-06-30   INC1243 IND Robinson Antonia   Vallejo CA 94591 Coldwell Banker 248 Real Estate Sales n   2021-06-16 400 900      
74745 74745 1426780 210 Derreck Johnson for Oakland City Council 2020 266 2021-07-10 2021-01-01 2021-06-30 2020-11-03 INC1827 IND Monroe Peter   Oakland CA 94605 Coldwell Banker 248 Real Estate Agent n   2021-05-06 500 500      
60949 60949 1421001 203 Bob Jackson for Oakland City Council 2020 255 2021-02-08 2020-01-01 2020-12-31 2020-11-03 tQLpemxytFvO IND Harris Isabel   Hayward CA 94544 Coldwell Banker 248 Broker n   2020-03-10 100 100      
60984 60984 1421001 203 Bob Jackson for Oakland City Council 2020 255 2021-02-08 2020-01-01 2020-12-31 2020-11-03 zxM1F98VoTIc IND Harris Isabel   Hayward CA 94544 Coldwell Banker 248 Associate Broker n   2020-07-05 100 100      
60993 60993 1421001 203 Bob Jackson for Oakland City Council 2020 255 2021-02-08 2020-01-01 2020-12-31 2020-11-03 4dJUJTvgVFc1 IND Harris Isabel   Hayward CA 94544 Coldwell Banker 248 Associate Broker n   2020-07-14 500 500      
62763 62763 1428941 242 Aaron Clay for Oakland City Council 2020 306 2020-10-22 2020-09-20 2020-10-17 2020-11-03 3XfhqevgcUzt IND Monroe Peter   Oakland CA 94605 Coldwell Banker 248 Real Estate Agent n   2020-09-20 100 100      
64127 64127 1421001 203 Bob Jackson for Oakland City Council 2020 255 2020-09-27 2020-07-01 2020-09-19 2020-11-03 zxM1F98VoTIc IND Harris Isabel   Hayward CA 94544 Coldwell Banker 248 Associate Broker n   2020-07-05 100 100      
64136 64136 1421001 203 Bob Jackson for Oakland City Council 2020 255 2020-09-27 2020-07-01 2020-09-19 2020-11-03 4dJUJTvgVFc1 IND Harris Isabel   Hayward CA 94544 Coldwell Banker 248 Associate Broker n   2020-07-14 500 500      
55763 55763 1426780 210 Derreck Johnson for Oakland City Council 2020 266 2020-09-18 2020-01-01 2020-06-30 2020-11-03 INC465 IND Monroe Peter   Oakland CA 94605 Coldwell Banker 248 Real Estate Agent n   2020-06-29 400 400      
56597 56597 1421001 203 Bob Jackson for Oakland City Council 2020 255 2020-08-25 2020-01-01 2020-06-30 2020-11-03 tQLpemxytFvO IND Harris Isabel   Hayward CA 94544 Coldwell Banker 248 Broker n   2020-03-10 100 100      
56650 56650 1421001 203 Bob Jackson for Oakland City Council 2020 255 2020-08-25 2020-01-01 2020-06-30 2020-11-03 tQLpemxytFvO IND Harris Isabel   Hayward CA 94544 Coldwell Banker 248 Broker n   2020-03-10 100 100      
67168 67168 1421001 203 Bob Jackson for Oakland City Council 2020 255 2020-07-31 2020-01-01 2020-06-30 2020-11-03 tQLpemxytFvO IND Harris Isabel   Hayward CA 94544 Coldwell Banker 248 Broker n   2020-03-10 100 100      
68759 68759 1426780 210 Derreck Johnson for Oakland City Council 2020 266 2020-07-29 2020-01-01 2020-06-30 2020-11-03 INC465 IND Monroe Peter   Oakland CA 94605 Coldwell Banker 248 Real Estate Agent n   2020-06-29 400 400      
69145 69145 1418926 197 Dominguez Walton for City Council 2020 248 2020-07-09 2020-01-01 2020-06-30 2020-11-03 CqikDiOS5pLv IND Andersen Rebecca   Oakland CA 94610 Coldwell Banker 248 Real Estate Agent n I 2020-06-15 250 250      
50129 50129 1406153 176 Joseph Tanios for Oakland City Council 2018 225 2018-07-31 2018-01-01 2018-06-30   EaLyfLF8eIhK IND Tegner Annie   San Leandro CA 94578 Coldwell Banker 248 Realtor n   2018-06-29 150 150      
51298 51298 1401499 160 Loren Taylor for Oakland City Council 200 2018-07-31 2018-01-01 2018-06-30 2018-11-06 BSkJkfgzW5wn IND Tolbert Reva   Oakland CA 94602 Coldwell Banker 248 Realtor n   2018-03-28 250 250      
31814 31814 1387905 121 Larry Reid for Council 2016 Officeholder Committee 162 2017-01-22 2016-10-23 2016-12-31 2016-11-08 INC169 IND Vail Edward   Bodega Bay CA 94923 Coldwell Banker 248 Real Estate n   2016-10-31 500 500      
35618 35618 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 2016-07-26 2016-01-01 2016-06-30   VNHZWESBTT5 IND Watson Nanine   Oakland CA 94619-3612 Coldwell Banker 248 Reator n I 2016-05-19 100 100      
11229 11229 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 pd2XZCYLcsLd IND Hansen Chris   Oakland CA 94610-1620 Coldwell Banker 248 Realtor n   2014-12-27 10 180      
27737 27737 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2015-07-28 2015-01-01 2015-06-30 2014-11-04 IDT57 IND Kulka Terry   Oakland CA 94602 Coldwell Banker 248 Real Estate Broker n I 2015-01-27 100 100      
13652 13652 1342416 35 Committee to Elect Lynette Gibson-McElhaney for Council 2012 29 2015-01-30 2014-01-01 2014-12-31 2014-11-04 4eqbvv6g2vMV IND Robinson Antonia   Oakland CA 94611 Coldwell Banker 248 Realtor n   2014-01-16 250 250      
13965 13965 1359017 39 Joe Tuman for Mayor 2014 33 2015-01-28 2014-07-01 2014-12-31 2014-11-04 2fkU8JdZTXBh IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-08-15 100 650      
14031 14031 1359017 39 Joe Tuman for Mayor 2014 33 2015-01-28 2014-07-01 2014-12-31 2014-11-04 jOYupSfgOZw2 IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-09-23 100 650      
14078 14078 1359017 39 Joe Tuman for Mayor 2014 33 2015-01-28 2014-07-01 2014-12-31 2014-11-04 ykz3F4oQTgAg IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-09-29 50 650      
14109 14109 1359017 39 Joe Tuman for Mayor 2014 33 2015-01-28 2014-07-01 2014-12-31 2014-11-04 IzgOd3p7PCkS IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-09-30 100 650      
9315 9315 1367270 80 Kaplan for Oakland Mayor 2014 78 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN8ZND0VA74 IND Duffield Joan   Oakland CA 94611-2801 Coldwell Banker 248 Realtor n   2014-09-29 500 500      
14278 14278 1342416 35 Committee to Elect Lynette Gibson-McElhaney for Council 2012 29 2015-01-05 2014-01-01 2014-06-30 2014-11-04 4eqbvv6g2vMV IND Robinson Antonia   Oakland CA 94611 Coldwell Banker 248 Realtor n   2014-01-16 250 250      
9606 9606 1367270 80 Kaplan for Oakland Mayor 2014 78 2014-10-23 2014-07-01 2014-09-30 2014-11-04 VN8ZND0VA74 IND Duffield Joan   Oakland CA 94611-2801 Coldwell Banker 248 Realtor n   2014-09-29 500 500      
15532 15532 1360826 91 Committee to Elect Michael V. Johnson City Council 2014 40 2014-10-08 2014-07-01 2014-09-30 2014-11-04 VN8V4CV4N46 IND Hansen Chris Mrs. Oakland CA 94610-1620 Coldwell Banker 248 Realtor n   2014-07-27 10 50      
15533 15533 1360826 91 Committee to Elect Michael V. Johnson City Council 2014 40 2014-10-08 2014-07-01 2014-09-30 2014-11-04 VN8V4CXNWT2 IND Hansen Chris Mrs. Oakland CA 94610-1620 Coldwell Banker 248 Realtor n   2014-08-27 10 50      
15534 15534 1360826 91 Committee to Elect Michael V. Johnson City Council 2014 40 2014-10-08 2014-07-01 2014-09-30 2014-11-04 VN8V4D0N2P3 IND Hansen Chris Mrs. Oakland CA 94610-1620 Coldwell Banker 248 Realtor n   2014-09-27 10 50      
15562 15562 1360826 91 Committee to Elect Michael V. Johnson City Council 2014 40 2014-10-08 2014-07-01 2014-09-30 2014-11-04 VN8V4CRTTJ4 IND Porche Dalisa   Berkeley CA 94709-1410 Coldwell Banker 248 Residential & Commercial Realtor n   2014-07-01 100 100      
7355 7355 1359017 39 Joe Tuman for Mayor 2014 33 2014-10-06 2014-07-01 2014-09-30 2014-11-04 2fkU8JdZTXBh IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-08-15 100 650      
7415 7415 1359017 39 Joe Tuman for Mayor 2014 33 2014-10-06 2014-07-01 2014-09-30 2014-11-04 jOYupSfgOZw2 IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-09-23 100 650      
7461 7461 1359017 39 Joe Tuman for Mayor 2014 33 2014-10-06 2014-07-01 2014-09-30 2014-11-04 ykz3F4oQTgAg IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-09-29 50 650      
7491 7491 1359017 39 Joe Tuman for Mayor 2014 33 2014-10-06 2014-07-01 2014-09-30 2014-11-04 IzgOd3p7PCkS IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-09-30 100 650      
15923 15923 1367270 80 Kaplan for Oakland Mayor 2014 78 2014-10-06 2014-07-01 2014-09-30 2014-11-04 VN8ZND0VA74 IND Duffield Joan   Oakland CA 94611-2801 Coldwell Banker 248 Realtor n   2014-09-29 500 500      
16154 16154 1367083 82 Cheri Spigner for School Board 2014 80 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC269 IND Tolbert Reva   Oakland CA 94602 Coldwell Banker 248 Realtor n   2014-09-29 100 100      
17840 17840 1359017 39 Joe Tuman for Mayor 2014 33 2014-10-02 2014-07-01 2014-09-30 2014-11-04 2fkU8JdZTXBh IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-08-15 100 650      
17900 17900 1359017 39 Joe Tuman for Mayor 2014 33 2014-10-02 2014-07-01 2014-09-30 2014-11-04 jOYupSfgOZw2 IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-09-23 100 650      
17946 17946 1359017 39 Joe Tuman for Mayor 2014 33 2014-10-02 2014-07-01 2014-09-30 2014-11-04 ykz3F4oQTgAg IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-09-29 50 650      
17976 17976 1359017 39 Joe Tuman for Mayor 2014 33 2014-10-02 2014-07-01 2014-09-30 2014-11-04 IzgOd3p7PCkS IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-09-30 100 650      
19462 19462 1367083 82 Cheri Spigner for School Board 2014 80 2014-07-31 2014-01-01 2014-06-30 2014-11-04 INC75 IND Tolbert Reva   Oakland Ca 94602 Coldwell Banker 248 Realtor n   2014-06-26 500 500      
19944 19944 1359017 39 Joe Tuman for Mayor 2014 33 2014-07-31 2014-01-01 2014-06-30 2014-11-04 KQhDhTizqBFu IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-04-17 100 300      
20044 20044 1359017 39 Joe Tuman for Mayor 2014 33 2014-07-31 2014-01-01 2014-06-30 2014-11-04 h3YdLXVMHHzJ IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-06-27 100 300      
20067 20067 1359017 39 Joe Tuman for Mayor 2014 33 2014-07-31 2014-01-01 2014-06-30 2014-11-04 XhKcBpDSavub IND Bowman Claudia   Oakland CA 94610 Coldwell Banker 248 Realtor n   2014-06-30 100 300      
2682 2682 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3S8 IND Hansen Chris Mrs. Oakland CA 94611-2801 Coldwell Banker 248 Realtor n   2013-08-29 100 100      
3764 3764 1359017 39 Joe Tuman for Mayor 2014 33 2014-01-28 2013-07-01 2013-12-31 2014-11-04 ml9k7dmvs9YS IND Hymer Dian   Oakland CA 94611 Coldwell Banker 248 Real Estate Broker n   2013-11-10 500 700      
3765 3765 1359017 39 Joe Tuman for Mayor 2014 33 2014-01-28 2013-07-01 2013-12-31 2014-11-04 wbXGO3xyXaau IND Hymer Dian   Oakland CA 94611 Coldwell Banker 248 Real Estate Broker n   2013-12-30 200 700      
3942 3942 1359017 39 Joe Tuman for Mayor 2014 33 2014-01-28 2013-07-01 2013-12-31 2014-11-04 sW54nrnHudcA IND Strand Laurel   Oakland CA 94611 Coldwell Banker 248 Broker n   2013-11-08 250 700      
3943 3943 1359017 39 Joe Tuman for Mayor 2014 33 2014-01-28 2013-07-01 2013-12-31 2014-11-04 2n9nDpMlVqSM IND Strand Laurel   Oakland CA 94611 Coldwell Banker 248 Broker n   2013-12-31 450 700      
659 659 1345266 15 Re-Elect Larry Reid for City Council 2012 15 2013-01-31 2012-10-21 2012-12-31 2012-11-06 INC225 IND Robinson Gary   Oakland CA 94618 Coldwell Banker 248 Real Estate n   2012-11-05 250 250      

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