monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

29 rows where employer = 8593 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, 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
90674 90674 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-08-01 2022-01-01 2022-06-30   INC10600 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2022-01-28 4.17 16.68     INC10600
90700 90700 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-08-01 2022-01-01 2022-06-30   INC10626 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2022-02-28 4.17 16.68     INC10626
90723 90723 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-08-01 2022-01-01 2022-06-30   INC10655 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2022-03-28 4.17 16.68     INC10655
90746 90746 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-08-01 2022-01-01 2022-06-30   INC10683 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2022-04-28 4.17 16.68     INC10683
72265 72265 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-01-31 2021-07-01 2021-12-31   INC10348 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-07-28 4.17 50.04     INC10348
72294 72294 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-01-31 2021-07-01 2021-12-31   INC10380 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-08-28 4.17 50.04     INC10380
72323 72323 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-01-31 2021-07-01 2021-12-31   INC10415 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-09-28 4.17 50.04     INC10415
72348 72348 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-01-31 2021-07-01 2021-12-31   INC10444 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-10-28 4.17 50.04     INC10444
72391 72391 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-01-31 2021-07-01 2021-12-31   INC10492 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-11-28 4.17 50.04     INC10492
72418 72418 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2022-01-31 2021-07-01 2021-12-31   INC10519 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-12-28 4.17 50.04     INC10519
74467 74467 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2021-08-02 2021-01-01 2021-06-30   INC10096 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-01-28 4.17 25.02     INC10096
74506 74506 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2021-08-02 2021-01-01 2021-06-30   INC10142 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-02-28 4.17 25.02     INC10142
74544 74544 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2021-08-02 2021-01-01 2021-06-30   INC10183 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-03-28 4.17 25.02     INC10183
74582 74582 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2021-08-02 2021-01-01 2021-06-30   INC10228 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-04-28 4.17 25.02     INC10228
74620 74620 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2021-08-02 2021-01-01 2021-06-30   INC10268 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-05-28 4.17 25.02     INC10268
74655 74655 1331137 36 GO Public Schools Advocates Community-Powered Candidate Committee 331 2021-08-02 2021-01-01 2021-06-30   INC10307 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2021-06-28 4.17 25.02     INC10307
61267 61267 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2021-02-01 2020-10-18 2020-12-31   INC9940 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-10-28 4.17 50.04     INC9940
61313 61313 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2021-02-01 2020-10-18 2020-12-31   INC9988 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-11-28 4.17 50.04     INC9988
61355 61355 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2021-02-01 2020-10-18 2020-12-31   INC10031 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-12-28 4.17 50.04     INC10031
62455 62455 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 INC9738 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-09-28 4.17 37.53     INC9738
64802 64802 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 INC9547 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-07-28 4.17 33.36     INC9547
64850 64850 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 INC9636 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-08-28 4.17 33.36     INC9636
67283 67283 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9120 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-01-28 4.17 25.02     INC9120
67332 67332 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9168 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-02-28 4.17 25.02     INC9168
67384 67384 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9230 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-03-28 4.17 25.02     INC9230
67437 67437 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9342 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-04-28 4.17 25.02     INC9342
67488 67488 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9393 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-05-28 4.17 25.02     INC9393
67586 67586 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9513 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2020-06-28 4.17 25.02     INC9513
53750 53750 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC9066 IND LOO CLINTON   OAKLAND CA 94619 FRECKLE EDUCATION 8593 CURRICULUM DESIGN MANAGER n   2019-12-30 4.17 4.17     INC9066

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