monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

38 rows where employer = 2850 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, 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
71754 71754 1441375 259 Loren Taylor for Mayor 2022 332 2022-01-31 2021-07-01 2021-12-31   3161233 IND Aikens Dwayne   Oakland CA 94610-1320 CITY OF OAKLAND 2850 COMMISSIONER, ADVISORY COMMISSION n   2021-11-06 50 151.83      
71865 71865 1441375 259 Loren Taylor for Mayor 2022 332 2022-01-31 2021-07-01 2021-12-31   3573865 IND Aikens Dwayne   Oakland CA 94610-1320 CITY OF OAKLAND 2850 COMMISSIONER, ADVISORY COMMISSION n   2021-12-06 50 151.83      
72028 72028 1441375 259 Loren Taylor for Mayor 2022 332 2022-01-31 2021-07-01 2021-12-31   2976668 IND Aikens Dwayne   Oakland CA 94610-1320 CITY OF OAKLAND 2850 COMMISSIONER, ADVISORY COMMISSION n   2021-10-27 51.83 151.83      
72570 72570 1441375 259 Loren Taylor for Mayor 2022 332 2022-01-31 2021-07-01 2021-12-31   3161233 IND Aikens Dwayne   Oakland CA 94610-1320 CITY OF OAKLAND 2850 COMMISSIONER, ADVISORY COMMISSION n   2021-11-06 50 151.83      
72665 72665 1441375 259 Loren Taylor for Mayor 2022 332 2022-01-31 2021-07-01 2021-12-31   3573865 IND Aikens Dwayne   Oakland CA 94610-1320 CITY OF OAKLAND 2850 COMMISSIONER, ADVISORY COMMISSION n   2021-12-06 50 151.83      
72811 72811 1441375 259 Loren Taylor for Mayor 2022 332 2022-01-31 2021-07-01 2021-12-31   2976668 IND Aikens Dwayne   Oakland CA 94610-1320 CITY OF OAKLAND 2850 COMMISSIONER, ADVISORY COMMISSION n   2021-10-27 51.83 151.83      
53364 53364 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2020-01-27 2019-07-01 2019-12-31   INC8503 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2019-07-12 8.35 75.1     INC8503
53447 53447 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2020-01-27 2019-07-01 2019-12-31   INC8582 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2019-08-12 8.35 75.1     INC8582
53516 53516 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2020-01-27 2019-07-01 2019-12-31   INC8722 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2019-09-12 8.35 75.1     INC8722
54658 54658 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2019-07-31 2019-01-01 2019-06-30   INC7312 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2019-01-12 8.34 50.04     INC7312
54759 54759 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2019-07-31 2019-01-01 2019-06-30   INC7410 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2019-02-12 8.34 50.04     INC7410
54857 54857 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2019-07-31 2019-01-01 2019-06-30   INC7507 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2019-03-12 8.34 50.04     INC7507
54950 54950 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2019-07-31 2019-01-01 2019-06-30   INC7598 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2019-04-12 8.34 50.04     INC7598
55041 55041 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2019-07-31 2019-01-01 2019-06-30   INC7687 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2019-05-12 8.34 50.04     INC7687
55127 55127 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2019-07-31 2019-01-01 2019-06-30   INC7771 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2019-06-12 8.34 50.04     INC7771
43741 43741 1410279 156 OAKLANDERS FOR RESPONSIBLE LEADERSHIP, OPPOSING DESLEY BROOKS FOR OAKLAND CITY COUNCIL 2018 197 2019-01-31 2018-10-21 2018-12-31   INC151 IND SCHAAF LIBBY   OAKLAND CA 94602 CITY OF OAKLAND 2850 MAYOR n   2018-10-29 999.99 999.99      
43954 43954 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2019-01-30 2018-10-21 2018-12-31   INC6996 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2018-11-12 8.34 75.04     INC6996
44067 44067 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2019-01-30 2018-10-21 2018-12-31   INC7113 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2018-12-12 8.34 75.04     INC7113
42544 42544 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2018-11-05 2018-09-23 2018-10-20 2018-11-06 INC6535 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2018-10-11 8.34 58.36     INC6535
45686 45686 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2018-10-25 2018-09-23 2018-10-20 2018-11-06 INC6535 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2018-10-11 8.34 58.36     INC6535
47419 47419 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2018-09-27 2018-07-01 2018-09-22 2018-11-06 INC6264 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2018-08-09 20.84 57.31     INC6264
47562 47562 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2018-09-27 2018-07-01 2018-09-22 2018-11-06 INC6370 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2018-09-10 26.05 57.31     INC6370
47566 47566 1331137 34 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 193 2018-09-27 2018-07-01 2018-09-22 2018-11-06 INC6371 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 DIRECTOR OF EDUCATION n   2018-09-11 10.42 57.31     INC6371
36267 36267 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2018-01-31 2017-07-01 2017-12-31   INC3332 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 EDUCATION DIRECTOR n   2017-09-09 20 80     INC3332
36382 36382 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2018-01-31 2017-07-01 2017-12-31   INC3448 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 EDUCATION DIRECTOR n   2017-10-12 20 80     INC3448
36493 36493 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2018-01-31 2017-07-01 2017-12-31   INC3675 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 EDUCATION DIRECTOR n   2017-11-06 20 80     INC3675
36621 36621 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2018-01-31 2017-07-01 2017-12-31   INC3792 IND SILVER DAVID   OAKLAND CA 94602 CITY OF OAKLAND 2850 EDUCATION DIRECTOR n   2017-12-15 20 80     INC3792
29535 29535 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2017-12-21 2016-07-01 2016-09-24 2016-11-08 INC2765 IND SCHAAF LIBBY   OAKLAND CA 94602 CITY OF OAKLAND 2850 MAYOR n   2016-08-04 264.74 264.74      
33186 33186 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC2765 IND SCHAAF LIBBY   OAKLAND CA 94602 CITY OF OAKLAND 2850 MAYOR n   2016-08-04 264.74 264.74      
34549 34549 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC166 IND FLYNN RACHEL   OAKLAND CA 94606 CITY OF OAKLAND 2850 DIRECTOR, PLANNING AND BUILDING DEPARTMENT n   2016-06-25 100 100      
34562 34562 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC192 IND KAPLAN REBECCA   OAKLAND CA 94608 CITY OF OAKLAND 2850 COUNCILMEMBER n   2016-06-30 180 180      
8926 8926 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2015-02-02 2014-07-01 2014-09-30 2014-11-04 INC878 IND RUBY COURTNEY   OAKLAND CA 94605 CITY OF OAKLAND 2850 CITY AUDITOR n   2014-08-20 100 175      
9018 9018 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2015-02-02 2014-07-01 2014-09-30 2014-11-04 INC1470 IND JAIN KIRAN   BERKELEY CA 94707 CITY OF OAKLAND 2850 SENIOR DEPUTY CITY ATTORNEY n   2014-09-23 40 40     INC1470
9055 9055 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2015-02-02 2014-07-01 2014-09-30 2014-11-04 INC1507 IND RUBY COURTNEY   OAKLAND CA 94605 CITY OF OAKLAND 2850 CITY AUDITOR n   2014-09-23 75 175     INC1507
16242 16242 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC878 IND RUBY COURTNEY   OAKLAND CA 94605 CITY OF OAKLAND 2850 CITY AUDITOR n   2014-08-20 100 175      
16334 16334 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC1470 IND JAIN KIRAN   BERKELEY CA 94707 CITY OF OAKLAND 2850 SENIOR DEPUTY CITY ATTORNEY n   2014-09-23 40 40     INC1470
16371 16371 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC1507 IND RUBY COURTNEY   OAKLAND CA 94605 CITY OF OAKLAND 2850 CITY AUDITOR n   2014-09-23 75 175     INC1507
18581 18581 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2014-07-31 2014-01-01 2014-06-30   INC753 IND GARZON GERRY   OAKLAND CA 94604 CITY OF OAKLAND 2850 LIBRARIAN n   2014-06-26 50 50      

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