monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

31 rows where filer_id = 216 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, transaction_id, entity_type, last_name, city, zipcode, transaction_date, transaction_amt, year_to_date, committee_id, 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
75108 75108 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-03-05 2021-01-01 2021-03-05 2020-11-03 A24 COM Unity PAC a Sponsored Committee of the Alameda Labor Council AFL-CIO     Oakland CA 94621     n   2021-02-16 4500 4500   58.0  
60029 60029 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-02-01 2020-09-20 2020-10-17 2020-11-03 A12 COM IBEW 332 Education Fund sponsored by International Brotherhood of Electrical Workers Local 332     San Jose CA 95125     n   2020-09-25 1000 1000   579.0  
60030 60030 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-02-01 2020-09-20 2020-10-17 2020-11-03 A16 COM INTERNATIONAL ASSOCIATION OF FIREFIGHTER LOCAL 55 POLITICAL ACTION SPONSORED BY: INT'L ASSOC. OF FIREFIGHTER LOCAL 55     OAKLAND CA 94612     n   2020-10-05 5000 5000   59.0  
60031 60031 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-02-01 2020-09-20 2020-10-17 2020-11-03 A15 COM International Association of Heat and Frost Insulators and Allied Workers local 16 AFL-CIO PAC Fund     Benicia CA 94510     n   2020-10-05 1500 1500   273.0  
60032 60032 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-02-01 2020-09-20 2020-10-17 2020-11-03 A18 SCC INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 595 PAC     DUBLIN CA 94568     n   2020-10-15 1500 6500   63.0  
60033 60033 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-02-01 2020-09-20 2020-10-17 2020-11-03 A14 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy     Sacramento CA 95815     n   2020-10-02 1000 8500   221.0  
60034 60034 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-02-01 2020-09-20 2020-10-17 2020-11-03 A13 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy     Sacramento CA 95815     n   2020-10-02 7500 8500   221.0  
60035 60035 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-02-01 2020-09-20 2020-10-17 2020-11-03 A17 SCC Service Employees International Union Local 1021 Candidate PAC     Sacramento CA 95814     n   2020-10-09 25000 227000   39.0  
60036 60036 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-02-01 2020-09-20 2020-10-17 2020-11-03 A19 COM Sheet Metal Workers' International Association Local No. 104 Political Action Committee     San Ramon CA 94583     n   2020-10-16 1500 6500   81.0  
60037 60037 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-02-01 2020-09-20 2020-10-17 2020-11-03 A11 COM Sprinkler Fitters & Apprentices Local 483 Local Political Action Committee     Hayward CA 94545     n   2020-09-24 5500 5500   80.0  
61196 61196 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-01-29 2020-10-18 2020-12-31 2020-11-03 A20 SCC Service Employees International Union Local 1021 Candidate PAC     Sacramento CA 95814     n   2020-10-27 63000 290000   39.0  
61197 61197 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-01-29 2020-10-18 2020-12-31 2020-11-03 A23 COM Unity PAC a Sponsored Committee of the Alameda Labor Council AFL-CIO     Oakland CA 94621     n   2020-12-09 30000 105000   58.0  
62922 62922 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-10-22 2020-09-20 2020-10-17 2020-11-03 A12 COM IBEW 332 Education Fund sponsored by International Brotherhood of Electrical Workers Local 332     San Jose CA 95125     n   2020-09-25 1000 1000   579.0  
62923 62923 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-10-22 2020-09-20 2020-10-17 2020-11-03 A16 COM INTERNATIONAL ASSOCIATION OF FIREFIGHTER LOCAL 55 POLITICAL ACTION SPONSORED BY: INT'L ASSOC. OF FIREFIGHTER LOCAL 55     OAKLAND CA 94612     n   2020-10-05 5000 5000   59.0  
62924 62924 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-10-22 2020-09-20 2020-10-17 2020-11-03 A15 COM International Association of Heat and Frost Insulators and Allied Workers local 16 AFL-CIO PAC Fund     Benicia CA 94510     n   2020-10-05 1500 1500   273.0  
62925 62925 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-10-22 2020-09-20 2020-10-17 2020-11-03 A18 SCC INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 595 PAC     DUBLIN CA 94568     n   2020-10-15 1500 6500   63.0  
62926 62926 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-10-22 2020-09-20 2020-10-17 2020-11-03 A14 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy     Sacramento CA 95815     n   2020-10-02 1000 8500   221.0  
62927 62927 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-10-22 2020-09-20 2020-10-17 2020-11-03 A13 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy     Sacramento CA 95815     n   2020-10-02 7500 8500   221.0  
62928 62928 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-10-22 2020-09-20 2020-10-17 2020-11-03 A17 SCC Service Employees International Union Local 1021 Candidate PAC     Sacramento CA 95814     n   2020-10-09 25000 227000   39.0  
62929 62929 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-10-22 2020-09-20 2020-10-17 2020-11-03 A19 COM Sheet Metal Workers' International Association Local No. 104 Political Action Committee     San Ramon CA 94583     n   2020-10-16 1500 6500   81.0  
62930 62930 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-10-22 2020-09-20 2020-10-17 2020-11-03 A11 COM Sprinkler Fitters & Apprentices Local 483 Local Political Action Committee     Hayward CA 94545     n   2020-09-24 5500 5500   80.0  
66689 66689 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-09-23 2020-01-01 2020-09-19 2020-11-03 A6 COM ESC Local 20 IFPTE Lou Lucivero Legislative Education & Action Program (LEAP) Sponsored by Engineers & Scientists of California Local 20     Oakland CA 94607     n   2020-09-08 1000 1000   554.0  
66690 66690 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-09-23 2020-01-01 2020-09-19 2020-11-03 A4 SCC INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 595 PAC     DUBLIN CA 94568     n   2020-09-04 5000 5000   63.0  
66691 66691 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-09-23 2020-01-01 2020-09-19 2020-11-03 A10 COM INTERNATIONAL FEDERATION OF PROFESSIONAL AND TECHNICAL ENGINEERS- LOCAL 21 TJ ANTHONY PAC FUND     SAN FRANCISCO CA 94103     n   2020-09-18 50000 50000   31.0  
66692 66692 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-09-23 2020-01-01 2020-09-19 2020-11-03 A8 SCC Service Employees International Union Local 1021 Candidate PAC     Sacramento CA 95814     n   2020-09-11 82000 202000   39.0  
66693 66693 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-09-23 2020-01-01 2020-09-19 2020-11-03 A7 SCC Service Employees International Union Local 1021 Candidate PAC     Sacramento CA 95814     n   2020-09-11 90000 202000   39.0  
66694 66694 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-09-23 2020-01-01 2020-09-19 2020-11-03 A3 SCC Service Employees International Union Local 1021 Candidate PAC     Sacramento CA 95814     n   2020-09-02 30000 202000   39.0  
66695 66695 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-09-23 2020-01-01 2020-09-19 2020-11-03 A5 COM Sheet Metal Workers Local Union 104 Political Committee     San Ramon CA 94583     n   2020-09-08 5000 5000   81.0  
66696 66696 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-09-23 2020-01-01 2020-09-19 2020-11-03 A2 COM Steamfitters Local 342 Political Action Committee     Concord CA 94518     n   2020-08-28 5000 5000   37.0  
66697 66697 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-09-23 2020-01-01 2020-09-19 2020-11-03 A9 COM Unity PAC a Sponsored Committee of the Alameda Labor Council AFL-CIO     Oakland CA 94621     n   2020-09-17 50000 75000   58.0  
66698 66698 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2020-09-23 2020-01-01 2020-09-19 2020-11-03 A1 COM Unity PAC a Sponsored Committee of the Alameda Labor Council AFL-CIO     Oakland CA 94621     n   2020-08-21 25000 75000   58.0  

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