monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

16 rows where employer = 801 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, state, 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
80428 80428 1451532 287 COALITION TO ELECT VALARIE BACHELOR FOR SCHOOL BOARD 2022 373 2022-12-07 2022-07-01 2022-09-24 2022-11-08 XkwooRPrjBGs IND Ajayi Adebowale   Annapolis MD 21409 SEIU 801 Labor Organizer n   2022-09-04 200 200      
86071 86071 1451532 287 COALITION TO ELECT VALARIE BACHELOR FOR SCHOOL BOARD 2022 373 2022-09-29 2022-07-01 2022-09-24 2022-11-08 XkwooRPrjBGs IND Ajayi Adebowale   Annapolis MD 21409 SEIU 801 Labor Organizer n   2022-09-04 200 200      
69372 69372 1442804 265 Support Paulina Gonzalez for Oakland City Council District 6, 2022 343 2022-02-24 2021-07-01 2021-12-31 2022-11-08 HLS6YBjcDrqQ IND Weisberg Adam   Columbus OH 43221 SEIU 801 Organizer n   2021-12-15 100 100      
74207 74207 1442804 265 Support Paulina Gonzalez for Oakland City Council District 6, 2022 343 2022-01-28 2021-07-01 2021-12-31 2022-06-07 HLS6YBjcDrqQ IND Weisberg Adam   Columbus OH 43221 SEIU 801 Organizer n   2021-12-15 100 100      
59591 59591 1421347 201 Re-Elect Lynette Gibson-McElhaney for City Council 2020 255 2021-01-18 2020-09-20 2020-10-17 2020-11-03 INC945 IND Giron Bruce   Berkeley CA 94703-2612 SEIU 801 Contractor n   2020-09-23 100 500      
59592 59592 1421347 201 Re-Elect Lynette Gibson-McElhaney for City Council 2020 255 2021-01-18 2020-09-20 2020-10-17 2020-11-03 INC946 IND Giron Bruce   Berkeley CA 94703-2612 SEIU 801 Contractor n   2020-09-23 400 500      
58208 58208 1427585 215 Carroll Fife for City Council 2020 272 2020-10-21 2020-01-01 2020-09-19 2020-11-03 IDT764 IND Garla Sanjay   Oakland CA 94607 SEIU 801 Organizer n I 2020-08-28 250 250      
63420 63420 1421347 201 Re-Elect Lynette Gibson-McElhaney for City Council 2020 255 2020-10-21 2020-09-20 2020-10-17 2020-11-03 INC945 IND Giron Bruce   Berkeley CA 94703-2612 SEIU 801 Contractor n   2020-09-23 100 500      
63421 63421 1421347 201 Re-Elect Lynette Gibson-McElhaney for City Council 2020 255 2020-10-21 2020-09-20 2020-10-17 2020-11-03 INC946 IND Giron Bruce   Berkeley CA 94703-2612 SEIU 801 Contractor n   2020-09-23 400 500      
65346 65346 1427585 215 Carroll Fife for City Council 2020 272 2020-09-24 2020-01-01 2020-09-19 2020-11-03 IDT764 IND Garla Sanjay   Oakland CA 94607 SEIU 801 Organizer n I 2020-08-28 250 250      
44483 44483 1400325 147 Nikki Fortunato Bas for Oakland City Council 2018 180 2019-01-31 2018-10-21 2018-12-31 2018-11-06 IDT385 IND Blue Luisa   Hayward CA 94544 SEIU 801 Orgnaizer n I 2018-10-23 100 100      
6476 6476 1362877 70 Dan Siegel for Mayor, 2014 66 2014-10-06 2014-01-01 2014-06-30   RIAivKUivoBS IND Polanco Yolanda   Oakland CA 94610 SEIU 801 Organizer n   2014-03-27 100 100      
19781 19781 1362877 70 Dan Siegel for Mayor, 2014 66 2014-07-31 2014-01-01 2014-06-30   RIAivKUivoBS IND Polanco Yolanda   Oakland CA 94610 SEIU 801 Organizer n   2014-03-27 100 100      
2724 2724 1342416 49 Committee to Elect Lynette Gibson-McElhaney for Council 2012 47 2014-01-31 2013-01-01 2013-12-31   PrJEbIWzHNia IND Huntsman C. Blake   Oakland CA 94607 SEIU 801 Chairman n   2013-01-10 100 100      
4196 4196 1343715 10 Dan Kalb for City Council 2012 11 2013-08-02 2013-01-01 2013-06-30   1p2QQ8Bt9RLl IND Young Marguerite   Oakland CA 94609 SEIU 801 Coordinator n   2013-05-21 125 125      
4256 4256 1342416 49 Committee to Elect Lynette Gibson-McElhaney for Council 2012 47 2013-08-01 2013-01-01 2013-06-30 2012-11-06 PrJEbIWzHNia IND Huntsman C. Blake   Oakland CA 94607 SEIU 801 Chairman n   2013-01-10 100 100      

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