monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

75 rows where employer = 2919 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, report_date, report_start_date, report_end_date, election_date, first_name, 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
90666 90666 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-08-01 2022-01-01 2022-06-30   INC10592 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2022-01-16 16 64     INC10592
90693 90693 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-08-01 2022-01-01 2022-06-30   INC10619 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2022-02-16 16 64     INC10619
90716 90716 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-08-01 2022-01-01 2022-06-30   INC10648 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2022-03-16 16 64     INC10648
90739 90739 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-08-01 2022-01-01 2022-06-30   INC10676 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2022-04-16 16 64     INC10676
61284 61284 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2021-02-01 2020-10-18 2020-12-31   INC10004 IND SPENCER LINDA   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2020-11-07 16 576     INC10004
61327 61327 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2021-02-01 2020-10-18 2020-12-31   INC10047 IND SPENCER LINDA   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2020-12-07 16 576     INC10047
62484 62484 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-10-22 2020-09-20 2020-10-17 2020-11-03 INC9831 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2020-10-16 16 1144     INC9831
64784 64784 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-09-24 2020-07-01 2020-09-19 2020-11-03 INC9564 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL/ECONOMIST n   2020-07-16 16 1128     INC9564
64831 64831 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-09-24 2020-07-01 2020-09-19 2020-11-03 INC9617 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL/ECONOMIST n   2020-08-16 16 1128     INC9617
64871 64871 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-09-24 2020-07-01 2020-09-19 2020-11-03 INC9682 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL/ECONOMIST n   2020-09-07 1000 1128      
64888 64888 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-09-24 2020-07-01 2020-09-19 2020-11-03 INC9681 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL/ECONOMIST n   2020-09-16 16 1128     INC9681
67312 67312 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9185 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2020-02-16 16 80     INC9185
67364 67364 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9247 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2020-03-16 16 80     INC9247
67416 67416 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9359 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2020-04-16 16 80     INC9359
67469 67469 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9410 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2020-05-16 16 80     INC9410
67557 67557 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9484 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2020-06-16 16 80     INC9484
53374 53374 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC8551 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2019-07-16 16 96     INC8551
53457 53457 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC8624 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2019-08-16 16 96     INC8624
53526 53526 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC8758 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2019-09-16 16 96     INC8758
53598 53598 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC8935 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2019-10-16 16 96     INC8935
53668 53668 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC9031 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2019-11-16 16 96     INC9031
53728 53728 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC9082 IND SPENCER ROBERT D   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2019-12-16 16 96     INC9082
54669 54669 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-07-31 2019-01-01 2019-06-30   INC7321 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2019-01-16 16 64     INC7321
54770 54770 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-07-31 2019-01-01 2019-06-30   INC7420 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2019-02-16 16 64     INC7420
54868 54868 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-07-31 2019-01-01 2019-06-30   INC7517 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2019-03-16 16 64     INC7517
54961 54961 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-07-31 2019-01-01 2019-06-30   INC7605 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2019-04-16 16 64     INC7605
43928 43928 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-01-30 2018-10-21 2018-12-31   INC6964 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-11-05 20 256     INC6964
43966 43966 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-01-30 2018-10-21 2018-12-31   INC7004 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-11-16 16 256     INC7004
44080 44080 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-01-30 2018-10-21 2018-12-31   INC7125 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-12-16 16 256     INC7125
42517 42517 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-11-05 2018-09-23 2018-10-20 2018-11-06 INC6513 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-10-05 20 204     INC6513
42559 42559 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-11-05 2018-09-23 2018-10-20 2018-11-06 INC6552 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-10-16 16 204     INC6552
45659 45659 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-10-25 2018-09-23 2018-10-20 2018-11-06 INC6513 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-10-05 20 204     INC6513
45701 45701 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-10-25 2018-09-23 2018-10-20 2018-11-06 INC6552 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-10-16 16 204     INC6552
47302 47302 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-27 2018-07-01 2018-09-22 2018-11-06 INC5307 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-07-16 16 172     INC5307
47399 47399 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-27 2018-07-01 2018-09-22 2018-11-06 INC6250 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-08-05 20 172     INC6250
47442 47442 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-27 2018-07-01 2018-09-22 2018-11-06 INC6290 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-08-16 16 172     INC6290
47538 47538 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-27 2018-07-01 2018-09-22 2018-11-06 INC6193 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-09-05 20 172     INC6193
47580 47580 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-27 2018-07-01 2018-09-22 2018-11-06 INC6383 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-09-16 20 172     INC6383
49561 49561 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4304 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-03-12 16 80     INC4304
49695 49695 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4382 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-04-06 16 80     INC4382
49828 49828 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4519 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-05-25 16 80      
50002 50002 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4704 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-06-11 16 80     INC4704
50041 50041 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4837 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2018-06-16 16 80     INC4837
36153 36153 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3265 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2017-07-18 25 239      
36271 36271 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3350 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2017-09-09 16 239     INC3350
36386 36386 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3480 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2017-10-12 16 239     INC3480
36498 36498 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3705 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2017-11-06 16 239     INC3705
36627 36627 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3861 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2017-12-15 16 239     INC3861
35957 35957 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-26 2017-01-01 2017-06-30   INC3067 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2017-01-18 25 150      
35979 35979 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-26 2017-01-01 2017-06-30   INC3088 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2017-02-18 25 150      
36000 36000 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-26 2017-01-01 2017-06-30   INC3113 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2017-03-18 25 150      
36021 36021 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-26 2017-01-01 2017-06-30   INC3139 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2017-04-18 25 150      
36041 36041 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-26 2017-01-01 2017-06-30   INC3166 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2017-05-18 25 150      
36061 36061 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-26 2017-01-01 2017-06-30   INC3188 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2017-06-18 25 150      
29505 29505 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2017-12-21 2016-07-01 2016-09-24 2016-11-08 INC2617 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2016-07-18 25 225      
29625 29625 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2017-12-21 2016-07-01 2016-09-24 2016-11-08 INC2676 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2016-08-18 25 225      
29660 29660 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2017-12-21 2016-07-01 2016-09-24 2016-11-08 INC2733 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2016-09-18 25 225      
30377 30377 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2017-12-21 2016-09-25 2016-10-22 2016-11-08 INC2866 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2016-10-18 25 250      
30778 30778 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2017-12-21 2016-10-23 2016-12-31   INC2977 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2016-11-18 25 300      
30803 30803 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2017-12-21 2016-10-23 2016-12-31   INC3011 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2016-12-18 25 300      
30830 30830 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2017-12-21 2016-10-23 2016-12-31 2016-11-08 INC2977 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2016-11-18 25 300      
30855 30855 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2017-12-21 2016-10-23 2016-12-31 2016-11-08 INC3011 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2016-12-18 25 300      
32232 32232 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-10-27 2016-09-25 2016-10-22 2016-11-08 INC2866 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRESIDENT n   2016-10-18 25 250      
33215 33215 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC2733 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRESIDENT n   2016-09-18 25 225      
33282 33282 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC2617 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRESIDENT n   2016-07-18 25 225      
33309 33309 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC2676 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRESIDENT n   2016-08-18 25 225      
34580 34580 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-08-01 2016-01-01 2016-06-30   INC2083 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRESIDENT n   2016-01-18 25 150      
34614 34614 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-08-01 2016-01-01 2016-06-30   INC2112 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRESIDENT n   2016-02-18 25 150      
34753 34753 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-08-01 2016-01-01 2016-06-30   INC2166 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRESIDENT n   2016-03-18 25 150      
34786 34786 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-08-01 2016-01-01 2016-06-30   INC2204 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRESIDENT n   2016-04-18 25 150      
34819 34819 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-08-01 2016-01-01 2016-06-30   INC2343 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRESIDENT n   2016-05-18 25 150      
34854 34854 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-08-01 2016-01-01 2016-06-30   INC2464 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRESIDENT n   2016-06-18 25 150      
9063 9063 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-02-02 2014-07-01 2014-09-30 2014-11-04 INC1515 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2014-09-23 500 500     INC1515
16379 16379 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC1515 IND SPENCER ROBERT   OAKLAND CA 94610 URBAN ECONOMICS 2919 PRINCIPAL n   2014-09-23 500 500     INC1515
18709 18709 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2014-07-31 2014-01-01 2014-06-30   INC688 IND SPENCER LINDA   OAKLAND CA 94610 URBAN ECONOMICS 2919 CONSULTANT n   2014-06-06 250 750      

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