ie_contributions

FPPC Form 496, Part 3 Contributions

Data source: F496P3_Contributions

33 rows where employer = 4963 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, report_date, transaction_id, last_name, first_name, occupation, transaction_date, transaction_amt, year_to_date, memo_reference_number, report_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
7503 7503 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-10-17       INC9787 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2020-10-14 8.58 105.8      
7527 7527 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-10-15       INC9787 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2020-10-14 8.58 105.8      
7543 7543 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-10-15       INC9787 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2020-10-14 8.58 105.8      
7544 7544 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-10-15       INC9787 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2020-10-14 8.58 105.8      
1918 1918 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-11-04       INC5299 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-07-14 8.58 111.74     INC:A:5299
1941 1941 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-11-04       INC5368 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-07-28 20.84 111.74     INC:A:5368
1967 1967 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-11-04       INC6281 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-08-14 8.58 111.74     INC:A:6281
1994 1994 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-11-04       INC6335 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-08-28 20.84 111.74     INC:A:6335
2132 2132 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-11-04       INC6672 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-09-28 20.84 141.16     INC:A:6672
2186 2186 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-11-04       INC6541 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-10-14 8.58 149.74     INC:A:6541
2218 2218 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-11-04       INC6751 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-10-28 20.84 170.58     INC:A:6751
2295 2295 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-10-30       INC6751 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-10-28 20.84 170.58     INC:A:6751
2334 2334 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-10-16       INC6541 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-10-14 8.58 151.89     INC:A:6541
2160 2160 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-10-04       INC6433 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-09-28 20.84 143.31     INC:A:6433
7292 7292 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-10-03       INC6433 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-09-28 20.84 143.31     INC:A:6433
7319 7319 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-23       INC6377 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-09-14 10.73 122.47     INC:A:6377
2012 2012 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-06       INC5299 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-07-14 8.58 111.74     INC:A:5299
2032 2032 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-06       INC5368 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-07-28 20.84 111.74     INC:A:5368
2056 2056 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-06       INC6080 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-08-14 8.58 111.74     INC:A:6080
2079 2079 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-06       INC6134 IND TORNEY ROBERT   OAKLAND CA 94606 LODESTAR 4963 ASSISTANT PRINCIPAL n   2018-08-28 20.84 111.74     INC:A:6134
588 588 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-28       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
776 776 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-28       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
895 895 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-20       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
1008 1008 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-20       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
1121 1121 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-16       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
1218 1218 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-16       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
1315 1315 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-16       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
1412 1412 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-16       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
1509 1509 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-09       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
1603 1603 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-01       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
1691 1691 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-01       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
1779 1779 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-01       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      
1867 1867 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-08-26       INC2655 IND ZIKA BRIANNE   OAKLAND CA 94606 LODESTAR 4963 TEACHER n   2016-08-13 10 10      

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "ie_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" TEXT,
  "city" TEXT,
  "state" TEXT,
  "zipcode" TEXT,
  "employer" INTEGER,
  "occupation" TEXT,
  "self_employed" TEXT,
  "transaction_type" TEXT,
  "transaction_date" TEXT,
  "transaction_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "transaction_description" TEXT,
  "committee_id" TEXT,
  "memo_reference_number" TEXT
,
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 ["ie_contributions_filer_id"] ON [ie_contributions]("filer_id");
CREATE INDEX ["ie_contributions_filer_name"] ON [ie_contributions]("filer_name");
CREATE INDEX ["ie_contributions_committee_id"] ON [ie_contributions]("committee_id");
CREATE INDEX ["ie_contributions_employer"] ON [ie_contributions]("employer");