monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

23 rows where employer = 58 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, 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
91583 91583 1462377 315 Zac Unger for Oakland City Council 2024 430 2024-04-01 2023-01-01 2023-12-31 2024-11-05 IDT1 IND Bonta Mia   Sacramento CA 95815 California State Assembly 58 Assemblymember n I 2023-08-29 600 600      
92786 92786 1462377 315 Zac Unger for Oakland City Council 2024 430 2024-01-31 2023-01-01 2023-12-31 2024-11-05 IDT1 IND Bonta Mia   Sacramento CA 95815 California State Assembly 58 Assemblymember n I 2023-08-29 600 600      
89088 89088 1442594 258 Sheng Thao for Oakland Mayor 2022 330 2022-08-01 2022-01-01 2022-06-30 2022-11-08 OCbVAxnRS7QN IND Ramoso Melissa   Artesia CA 90701 California State Assembly 58 District Director n   2022-05-23 100 100      
69458 69458 1442594 258 Sheng Thao for Oakland Mayor 2022 330 2022-07-30 2021-11-10 2021-12-31 2022-11-08 jcewkwQ4QjZk IND Lee Alex   San Jose CA 95133 California State Assembly 58 State Assembly Member n   2021-12-02 100 100      
69464 69464 1442594 258 Sheng Thao for Oakland Mayor 2022 330 2022-07-30 2021-11-10 2021-12-31 2022-11-08 ej1eBeOgMGh3 IND Pham Annie   Elk Grove CA 95758 California State Assembly 58 Consultant n   2021-12-03 100 100      
70414 70414 1442079 265 Treva Reid for Oakland Mayor 2022 342 2022-07-14 2021-01-01 2021-12-31 2022-11-08 INC356 IND Chekal Mark   Berkeley CA 94705 California State Assembly 58 District Director n   2021-12-31 200 200      
72902 72902 1442079 265 Treva Reid for Oakland Mayor 2022 342 2022-01-31 2021-01-01 2021-12-31 2022-11-08 INC356 IND Chekal Mark   Berkeley CA 94705 California State Assembly 58 District Director n   2021-12-31 200 200      
73890 73890 1442594 258 Sheng Thao for Oakland Mayor 2022 330 2022-01-28 2021-11-10 2021-12-31 2022-11-08 jcewkwQ4QjZk IND Lee Alex   San Jose CA 95133 California State Assembly 58 State Assembly Member n   2021-12-02 100 100      
73896 73896 1442594 258 Sheng Thao for Oakland Mayor 2022 330 2022-01-28 2021-11-10 2021-12-31 2022-11-08 ej1eBeOgMGh3 IND Pham Annie   Elk Grove CA 95758 California State Assembly 58 Consultant n   2021-12-03 100 100      
61220 61220 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 2021-02-01 2020-10-18 2020-12-31 2020-11-03 A1020 IND Huen Lailan   Oakland CA 94606 California State Assembly 58 Senior Field Representative n   2020-12-30 600 600      
57206 57206 960997 41 Friends of Oakland Public Schools - Yes on Measure Y 271 2021-01-19 2020-07-01 2020-09-19 2020-11-03 INC836 IND Bonta Rob   Sacramento CA 95815 California State Assembly 58 Assemblymember n   2020-09-08 1000 1000      
57301 57301 960997 41 Friends of Oakland Public Schools - Yes on Measure Y 271 2020-10-20 2020-07-01 2020-09-19 2020-11-03 INC836 IND Bonta Rob   Sacramento CA 95815 California State Assembly 58 Assemblymember n   2020-09-08 1000 1000      
57919 57919 1366759 95 Treva Reid for Oakland City Council 2020 160 2020-10-18 2020-07-01 2020-09-19 2020-11-03 INC1058 IND Mathews Alana   Elk Grove CA 95758 California State Assembly 58 Attorney n   2020-08-14 100 100      
66708 66708 1419930 207 Davis For Oakland School Board 2020 263 2020-09-24 2020-07-01 2020-09-19 2020-11-03 PxM4mB9uga89 IND Bonta Rob   Sacramento CA 95815 California State Assembly 58 Assemblymember n   2020-09-14 500 500      
65921 65921 1366759 95 Treva Reid for Oakland City Council 2020 160 2020-09-22 2020-07-01 2020-09-19 2020-11-03 INC1058 IND Mathews Alana   Elk Grove CA 95758 California State Assembly 58 Attorney n   2020-08-14 100 100      
66421 66421 960997 41 Friends of Oakland Public Schools - Yes on Measure Y 271 2020-09-22 2020-07-01 2020-09-19 2020-11-03 INC836 IND Bonta Rob   Sacramento CA 95815 California State Assembly 58 Assemblymember n   2020-09-08 1000 1000      
44900 44900 1404085 154 Doutherd for School Board 2018 192 2019-01-24 2018-10-21 2018-12-31   INC501 IND Rausa Justin   Oakland CA 94619 California State Assembly 58 Legislative Staff n   2018-10-23 250 250      
45735 45735 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 2018-10-25 2018-07-01 2018-10-20 2018-11-06 A504 IND Huen Lailan   Oakland CA 94606 California State Assembly 58 Senior Field Representative n   2018-09-04 500 750      
46231 46231 1405456 177 Sheng Thao for Oakland City Council 2018 226 2018-10-25 2018-09-23 2018-10-20 2018-11-06 sPniPcmTcuRF IND Nou Catherina   Sacramento CA 95816 California State Assembly 58 Consultant n   2018-10-17 100 100      
51086 51086 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 2018-07-30 2018-05-20 2018-06-30 2018-06-05 A479 IND Huen Lailan   Oakland CA 94606 California State Assembly 58 Senior Field Representative n   2018-06-28 250 250      
13080 13080 1366759 95 Treva Reid for Oakland City Council 2016 96 2015-01-31 2014-07-01 2014-12-31 2016-11-08 INC35 IND Baranco Brandon   Oakland CA 94605 California State Assembly 58 Field Representative n   2014-10-22 150 150      
121 121 1304073 9 Re-Elect Jumoke Hinton Hodge for Oakland School Board 9 2012-12-31 2012-07-01 2012-09-30 2012-11-06 C6606288 IND Huen Lailan   Oakland CA 94606 California State Assembly 58 Senior Field Representative n   2012-09-28 150 150      
1796 1796 1304073 9 Re-Elect Jumoke Hinton Hodge for Oakland School Board 9 2012-10-05 2012-07-01 2012-09-30 2012-11-06 C6606288 IND Huen Lailan   Oakland CA 94606 California State Assembly 58 Senior Field Representative n   2012-09-28 150 150      

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