monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

16 rows where employer = 1287 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, 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
103410 103410 1464418 311 Patrice Berry for Oakland School Board 2024 450 2024-09-22 2024-07-01 2024-09-21 2024-11-05 157 IND Waters Louise   Oakland CA 94619-2302 Chabot Space and Science Center 1287 educator n   2024-09-02 100 150      
40550 40550 1395580 147 Abel Guillen for City Council 2018 184 2019-04-15 2018-01-01 2018-06-30   INC301 IND Tobin Adam   Oakland CA 94611 Chabot Space and Science Center 1287 Chief Executive Officer n   2018-02-26 100 100      
50366 50366 1395580 147 Abel Guillen for City Council 2018 184 2018-07-31 2018-01-01 2018-06-30   INC301 IND Tobin Adam   Oakland CA 94611 Chabot Space and Science Center 1287 Chief Executive Officer n   2018-02-26 100 100      
38217 38217 1395968 148 Libby Schaaf for Mayor 2018 185 2017-07-19 2017-01-01 2017-06-30   VNHZWFX2409 IND Tobin Adam   Oakland CA 94611-1322 Chabot Space and Science Center 1287 Executive n   2017-06-30 100 100      
5119 5119 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2015-01-26 2014-01-01 2014-06-30 2014-11-04 INC401 IND Casenza Stephanie L.   Oakland CA 94619 Chabot Space and Science Center 1287 Fundraising Consultant n   2014-06-30 100 100      
8171 8171 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2015-01-26 2014-07-01 2014-09-30 2014-11-04 INC524 IND Casenza Stephanie L.   Oakland CA 94619 Chabot Space and Science Center 1287 Fundraising Consultant n   2014-09-02 100 300      
8172 8172 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2015-01-26 2014-07-01 2014-09-30 2014-11-04 INC633 IND Casenza Stephanie L.   Oakland CA 94619 Chabot Space and Science Center 1287 Fundraising Consultant n   2014-09-27 100 300      
13340 13340 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2015-01-26 2014-10-19 2014-12-31 2014-11-04 INC859 IND Casenza Stephanie L.   Oakland CA 94619 Chabot Space and Science Center 1287 Fundraising Consultant n   2014-10-24 70 370      
8363 8363 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2014-10-22 2014-07-01 2014-09-30 2014-11-04 INC524 IND Casenza Stephanie L.   Oakland CA 94619 Chabot Space and Science Center 1287 Fundraising Consultant n   2014-09-02 100 300      
8364 8364 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2014-10-22 2014-07-01 2014-09-30 2014-11-04 INC633 IND Casenza Stephanie L.   Oakland CA 94619 Chabot Space and Science Center 1287 Fundraising Consultant n   2014-09-27 100 300      
16747 16747 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC524 IND Casenza Stephanie L.   Oakland CA 94619 Chabot Space and Science Center 1287 Fundraising Consultant n   2014-09-02 100 300      
16748 16748 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC633 IND Casenza Stephanie L.   Oakland CA 94619 Chabot Space and Science Center 1287 Fundraising Consultant n   2014-09-27 100 300      
5416 5416 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2014-10-04 2014-01-01 2014-06-30 2014-11-04 INC401 IND Casenza Stephanie L.   Oakland CA 94619 Chabot Space and Science Center 1287 Fundraising Consultant n   2014-06-30 100 100      
18100 18100 1365733 83 Shakir-Gilmore for Oakland School Board 2014 81 2014-07-31 2014-04-01 2014-06-30 2014-11-04 oaiGMbUM1DJ8 IND Russo Melissa   Oakland CA 94602 Chabot Space and Science Center 1287 Fundrasier n   2014-06-13 150 150      
21174 21174 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 2014-07-31 2014-01-01 2014-06-30 2014-11-04 INC401 IND Casenza Stephanie L.   Oakland CA 94619 Chabot Space and Science Center 1287 Fundraising Consultant n   2014-06-30 100 100      
4307 4307 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 2013-07-31 2013-01-01 2013-06-30   Ws3llclGOrh2 IND Rosengard-Russo Melissa   Oakland CA 94611 Chabot Space and Science Center 1287 Director of Institutional Advancement n   2013-06-19 300 300      

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