monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

41 rows where employer = 2383 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, transaction_id, last_name, first_name, city, zipcode, occupation, transaction_date, 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
99266 99266 1463441 325 Carroll Fife for City Council 2024 443 2025-01-31 2024-10-20 2024-12-31 2024-11-05 IDT283 IND Rose Josh   Oakland CA 94606 College of Alameda 2383 Librarian n I 2024-11-01 100 172      
99267 99267 1463441 325 Carroll Fife for City Council 2024 443 2025-01-31 2024-10-20 2024-12-31 2024-11-05 IDT336 IND Rose Josh   Oakland CA 94606 College of Alameda 2383 Librarian n I 2024-12-02 24 172      
104148 104148 1442792 264 Councilmember Janani Ramachandran Oakland City Council District 4 Officeholder Committee 436 2024-07-31 2024-01-01 2024-06-30   Gc5vbSIxBd5F IND Frias Betty   Oakland CA 94602 College of Alameda 2383 Counselor n   2024-01-01 200 200      
80405 80405 1451532 287 COALITION TO ELECT VALARIE BACHELOR FOR SCHOOL BOARD 2022 373 2022-12-07 2022-07-01 2022-09-24 2022-11-08 RsyDPFSheWzC IND Sanceri Jeffrey   Berkeley CA 94703 College of Alameda 2383 Instructor n   2022-08-25 100 100      
78104 78104 1448946 289 Committee to Support Pecolia Manigo for School Board Director 2022 375 2022-10-15 2022-07-01 2022-09-24 2022-11-08 EE4xZTuqHvyh IND Maufas KimShree   San Francisco CA 94110 College of Alameda 2383 Adjunct Community College Professor n   2022-08-03 250 250      
86048 86048 1451532 287 COALITION TO ELECT VALARIE BACHELOR FOR SCHOOL BOARD 2022 373 2022-09-29 2022-07-01 2022-09-24 2022-11-08 RsyDPFSheWzC IND Sanceri Jeffrey   Berkeley CA 94703 College of Alameda 2383 Instructor n   2022-08-25 100 100      
87426 87426 1448946 289 Committee to Support Pecolia Manigo for School Board Director 2022 375 2022-09-29 2022-07-01 2022-09-24 2022-11-08 EE4xZTuqHvyh IND Maufas KimShree   San Francisco CA 94110 College of Alameda 2383 Adjunct Community College Professor n   2022-08-03 250 250      
76016 76016 1442792 264 Janani Ramachandran for Oakland City Council Disrict 4 2022 342 2022-08-23 2022-01-01 2022-06-30 2022-11-08 7TWd3yN2Qs4k IND Frias Betty   Oakland CA 94602 College of Alameda 2383 Counselor n   2022-06-30 500 500      
90586 90586 1442792 264 Janani Ramachandran for Oakland City Council Disrict 4 2022 342 2022-08-01 2022-01-01 2022-06-30 2022-11-07 7TWd3yN2Qs4k IND Frias Betty   Oakland CA 94602 College of Alameda 2383 Counselor n   2022-06-30 500 500      
70629 70629 1441375 259 Loren Taylor for Oakland Mayor 2022 331 2022-01-31 2021-07-01 2021-12-31   3887001 IND Altman Hilary   Albany CA 94707-2542 College of Alameda 2383 Marriage and Family Therapist Intern (MFTi) n   2021-12-12 900 900      
71120 71120 1441375 259 Loren Taylor for Oakland Mayor 2022 331 2022-01-31 2021-07-01 2021-12-31   3887001 IND Altman Hilary   Albany CA 94707-2542 College of Alameda 2383 Marriage and Family Therapist Intern (MFTi) n   2021-12-12 900 900      
44147 44147 1236617 19 Desley Brooks for City Council 2018 185 2019-01-31 2018-10-21 2018-12-31 2018-11-06 INC524 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-10-28 25 195      
39153 39153 1236617 19 Desley Brooks for City Council 2018 185 2018-12-18 2018-01-01 2018-06-30 2018-11-06 INC2 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-02-25 50 170      
39154 39154 1236617 19 Desley Brooks for City Council 2018 185 2018-12-18 2018-01-01 2018-06-30 2018-11-06 INC20 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-04-06 60 170      
39155 39155 1236617 19 Desley Brooks for City Council 2018 185 2018-12-18 2018-01-01 2018-06-30 2018-11-06 INC45 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-06-02 60 170      
39296 39296 1236617 19 Desley Brooks for City Council 2018 185 2018-10-25 2018-01-01 2018-06-30 2018-11-06 INC2 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-02-25 50 170      
39297 39297 1236617 19 Desley Brooks for City Council 2018 185 2018-10-25 2018-01-01 2018-06-30 2018-11-06 INC20 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-04-06 60 170      
39298 39298 1236617 19 Desley Brooks for City Council 2018 185 2018-10-25 2018-01-01 2018-06-30 2018-11-06 INC45 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-06-02 60 170      
39439 39439 1236617 19 Desley Brooks for City Council 2018 185 2018-09-25 2018-01-01 2018-06-30 2018-11-06 INC2 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-02-25 50 170      
39440 39440 1236617 19 Desley Brooks for City Council 2018 185 2018-09-25 2018-01-01 2018-06-30 2018-11-06 INC20 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-04-06 60 170      
39441 39441 1236617 19 Desley Brooks for City Council 2018 185 2018-09-25 2018-01-01 2018-06-30 2018-11-06 INC45 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-06-02 60 170      
51117 51117 1236617 19 Desley Brooks for City Council 2018 185 2018-07-31 2018-01-01 2018-06-30 2018-11-06 INC2 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-02-25 50 170      
51118 51118 1236617 19 Desley Brooks for City Council 2018 185 2018-07-31 2018-01-01 2018-06-30 2018-11-06 INC20 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-04-06 60 170      
51119 51119 1236617 19 Desley Brooks for City Council 2018 185 2018-07-31 2018-01-01 2018-06-30 2018-11-06 INC45 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 College Administrator n   2018-06-02 60 170      
32438 32438 1387192 125 Viola Gonzales for City Council 2016 142 2016-10-27 2016-09-25 2016-10-22 2016-11-08 KKsHG95czdoS IND Jelks Betty   Oakland CA 94602 College of Alameda 2383 Academic Counselor n   2016-10-14 200 200      
32615 32615 1386145 119 Coalition for Police Accountability Yes on LL 134 2016-10-25 2016-09-25 2016-10-22 2016-11-08 INC143 IND Cook Toni   Oakland CA 94605 College of Alameda 2383 Dean of Student Services n   2016-09-28 25 25      
27873 27873 1365384 72 Abel Guillen for Oakland City Council 2014 68 2015-07-21 2015-01-01 2015-06-30   INC1105 IND Jelks Betty   Oakland CA 94602 College of Alameda 2383 Adjunct Counselor n   2015-03-18 150 150      
13295 13295 1365384 72 Abel Guillen for Oakland City Council 2014 68 2015-01-31 2014-10-19 2014-12-31   INC901 IND Fearn Emilene   Oakland CA 94610 College of Alameda 2383 Professor n   2014-10-24 100 550      
13296 13296 1365384 72 Abel Guillen for Oakland City Council 2014 68 2015-01-31 2014-10-19 2014-12-31   INC958 IND Fearn Emilene   Oakland CA 94610 College of Alameda 2383 Professor n   2014-10-30 250 550      
7112 7112 1365384 72 Abel Guillen for Oakland City Council 2014 68 2015-01-21 2014-01-01 2014-06-30   INC371 IND Olds Peter   Alameda CA 94501 College of Alameda 2383 Professor of Chemistry n   2014-06-30 100 100      
8581 8581 1365384 72 Abel Guillen for Oakland City Council 2014 68 2015-01-13 2014-07-01 2014-09-30 2014-11-04 INC716 IND Fearn Emilene   Oakland CA 94610 College of Alameda 2383 Professor n   2014-09-29 200 200      
8615 8615 1365384 72 Abel Guillen for Oakland City Council 2014 68 2015-01-13 2014-07-01 2014-09-30 2014-11-04 INC669 IND Jelks Betty   Oakland CA 94602 College of Alameda 2383 Adjunct Conselor n   2014-09-30 150 150      
8636 8636 1365384 72 Abel Guillen for Oakland City Council 2014 68 2015-01-13 2014-07-01 2014-09-30 2014-11-04 INC660 IND Olds Peter   Alameda CA 94501 College of Alameda 2383 Professor of Chemistry n   2014-09-30 100 200      
8733 8733 1365384 72 Abel Guillen for Oakland City Council 2014 68 2014-10-22 2014-07-01 2014-09-30 2014-11-04 INC716 IND Fearn Emilene   Oakland CA 94610 College of Alameda 2383 Professor n   2014-09-29 200 200      
8767 8767 1365384 72 Abel Guillen for Oakland City Council 2014 68 2014-10-22 2014-07-01 2014-09-30 2014-11-04 INC669 IND Jelks Betty   Oakland CA 94602 College of Alameda 2383 Adjunct Conselor n   2014-09-30 150 150      
8788 8788 1365384 72 Abel Guillen for Oakland City Council 2014 68 2014-10-22 2014-07-01 2014-09-30 2014-11-04 INC660 IND Olds Peter   Alameda CA 94501 College of Alameda 2383 Professor of Chemistry n   2014-09-30 100 200      
17363 17363 1354678 51 Re-Elect Mayor Quan 2014 50 2014-10-06 2014-07-01 2014-09-30 2014-11-04 KHPuYcdydMzD IND Fearn Emilene   Oakland CA 94610 College of Alameda 2383 college professor n   2014-09-30 100 100      
16622 16622 1365384 72 Abel Guillen for Oakland City Council 2014 68 2014-10-04 2014-07-01 2014-09-30 2014-11-04 INC716 IND Fearn Emilene   Oakland CA 94610 College of Alameda 2383 Professor n   2014-09-29 200 200      
16655 16655 1365384 72 Abel Guillen for Oakland City Council 2014 68 2014-10-04 2014-07-01 2014-09-30 2014-11-04 INC669 IND Jelks Betty   Oakland CA 94602 College of Alameda 2383 Adjunct Conselor n   2014-09-30 150 150      
16676 16676 1365384 72 Abel Guillen for Oakland City Council 2014 68 2014-10-04 2014-07-01 2014-09-30 2014-11-04 INC660 IND Olds Peter   Alameda CA 94501 College of Alameda 2383 Professor of Chemistry n   2014-09-30 100 200      
18340 18340 1365384 72 Abel Guillen for Oakland City Council 2014 68 2014-07-31 2014-01-01 2014-06-30   INC371 IND Olds Peter   Alameda CA 94501 College of Alameda 2383 Professor of Chemistry n   2014-06-30 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");