contribution_reports_24_hours

FPPC Form 497

Data source: 497

23 rows where filer_id = 216 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, report_date, transaction_id, entity_type, entity_last_name, entity_city, entity_zipcode, contribution_date, amount, committee_id, report_date (date), election_date (date), contribution_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type entity_last_name entity_first_name entity_prefix entity_suffix entity_city entity_state entity_zipcode contributor_employer contributor_occupation contributor_self_employed contribution_date amount committee_id candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number incumbent ballot_measure_name ballot_measure_number ballot_measure_jurisdiction memo_reference_number
964 964 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 316 RCP 2020-10-27     2020-11-03 F497P1-20 SCC Service Employees International Union Local 1021 Candidate PAC       Sacramento CA 95814       2020-10-27 00:00:00 63000 1296948 39                        
981 981 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 316 RCP 2020-10-22     2020-11-03 F497P2-64 BNM Yes on 15 - Schools and Communities First sponsored by a Coalition of Labor Groups and Social Justice Organizations Representing Families Students and Essential Workers       Los Angeles CA 90017       2020-10-13 00:00:00 1231.27 1403098 838                 The California Schools and Local Communities Funding Act of 2020 15 Statewide  
982 982 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 316 RCP 2020-10-22     2020-11-03 F497P2-122 BNM Yes on 15 - Schools and Communities First sponsored by a Coalition of Labor Groups and Social Justice Organizations Representing Families Students and Essential Workers       Los Angeles CA 90017       2020-10-13 00:00:00 356.78 1403098 838                 The California Schools and Local Communities Funding Act of 2020 15 Statewide  
1016 1016 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 316 RCP 2020-10-16     2020-11-03 F497P1-19 COM Sheet Metal Workers' International Association Local No. 104 Political Action Committee       San Ramon CA 94583       2020-10-16 00:00:00 1500 850381 81                        
1026 1026 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 316 RCP 2020-10-15     2020-11-03 F497P1-18 SCC INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 595 PAC       DUBLIN CA 94568       2020-10-15 00:00:00 1500 1273532 63                        
1030 1030 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 316 RCP 2020-10-14     2020-11-03 F497P2-64 BNM Yes on 15 - Schools and Communities First sponsored by a Coalition of Labor Groups and Social Justice Organizations Representing Families Students and Essential Workers       Los Angeles CA 90017       2020-10-13 00:00:00 1231.27 1403098 838                 The California Schools and Local Communities Funding Act of 2020 15 Statewide  
1043 1043 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 316 RCP 2020-10-12     2020-11-03 F497P1-17 SCC Service Employees International Union Local 1021 Candidate PAC       Sacramento CA 95814       2020-10-09 00:00:00 25000 1296948 39                        
1072 1072 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 316 RCP 2020-10-05     2020-11-03 F497P1-16 COM INTERNATIONAL ASSOCIATION OF FIREFIGHTER LOCAL 55 POLITICAL ACTION SPONSORED BY: INT'L ASSOC. OF FIREFIGHTER LOCAL 55       OAKLAND CA 94612       2020-10-05 00:00:00 5000 892160 59                        
1073 1073 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 316 RCP 2020-10-05     2020-11-03 F497P1-15 COM International Association of Heat and Frost Insulators and Allied Workers local 16 AFL-CIO PAC Fund       Benicia CA 94510       2020-10-05 00:00:00 1500 1250907 273                        
1079 1079 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 316 RCP 2020-10-02     2020-11-03 F497P1-13 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2020-10-02 00:00:00 7500 1318200 221                        
1080 1080 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 316 RCP 2020-10-02     2020-11-03 F497P1-14 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2020-10-02 00:00:00 1000 1318200 221                        
1099 1099 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 316 RCP 2020-09-25     2020-11-03 F497P1-12 COM IBEW 332 Education Fund sponsored by International Brotherhood of Electrical Workers Local 332       San Jose CA 95125       2020-09-25 00:00:00 1000 1298069 579                        
1100 1100 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 316 RCP 2020-09-24     2020-11-03 F497P1-11 COM Sprinkler Fitters & Apprentices Local 483 Local Political Action Committee       Hayward CA 94545       2020-09-24 00:00:00 5500 1298012 80                        
1120 1120 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 316 RCP 2020-09-18     2020-11-03 F497P1-10 COM INTERNATIONAL FEDERATION OF PROFESSIONAL AND TECHNICAL ENGINEERS- LOCAL 21 TJ ANTHONY PAC FUND       SAN FRANCISCO CA 94103       2020-09-18 00:00:00 50000 881248 31                        
1127 1127 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 316 RCP 2020-09-17     2020-11-03 F497P1-9 COM Unity PAC a Sponsored Committee of the Alameda Labor Council AFL-CIO       Oakland CA 94621       2020-09-17 00:00:00 50000 1294190 58                        
1139 1139 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 316 RCP 2020-09-11     2020-11-03 F497P1-7 SCC Service Employees International Union Local 1021 Candidate PAC       Sacramento CA 95814       2020-09-11 00:00:00 90000 1296948 39                        
1140 1140 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 316 RCP 2020-09-11     2020-11-03 F497P1-8 SCC Service Employees International Union Local 1021 Candidate PAC       Sacramento CA 95814       2020-09-11 00:00:00 82000 1296948 39                        
1148 1148 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 316 RCP 2020-09-09     2020-11-03 F497P1-6 COM ESC Local 20 IFPTE Lou Lucivero Legislative Education & Action Program (LEAP) Sponsored by Engineers & Scientists of California Local 20       Oakland CA 94607       2020-09-08 00:00:00 1000 861160 554                        
1149 1149 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 316 RCP 2020-09-09     2020-11-03 F497P1-5 COM Sheet Metal Workers Local Union 104 Political Committee       San Ramon CA 94583       2020-09-08 00:00:00 5000 850381 81                        
1150 1150 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 316 RCP 2020-09-04     2020-11-03 F497P1-4 SCC INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 595 PAC       DUBLIN CA 94568       2020-09-04 00:00:00 5000 1273532 63                        
1151 1151 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 316 RCP 2020-09-02     2020-11-03 F497P1-3 SCC Service Employees International Union Local 1021 Candidate PAC       Sacramento CA 95814       2020-09-02 00:00:00 30000 1296948 39                        
1156 1156 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife to the Oakland City Council spnsored by Alameda Labor Council AFL-CIO 320 RCP 2020-08-28     2020-11-03 F497P1-2 COM Steamfitters Local 342 Political Action Committee       Concord CA 94518       2020-08-28 00:00:00 5000 890268 37                        
1166 1166 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife to the Oakland City Council spnsored by Alameda Labor Council AFL-CIO 320 RCP 2020-08-21     2020-11-03 F497P1-1 COM Unity PAC a Sponsored Committee of the Alameda Labor Council AFL-CIO       Oakland CA 94621       2020-08-21 00:00:00 25000 1294190 58                        

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "contribution_reports_24_hours" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "committee_type" TEXT,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "entity_last_name" TEXT,
  "entity_first_name" TEXT,
  "entity_prefix" TEXT,
  "entity_suffix" TEXT,
  "entity_city" TEXT,
  "entity_state" TEXT,
  "entity_zipcode" TEXT,
  "contributor_employer" INTEGER,
  "contributor_occupation" TEXT,
  "contributor_self_employed" TEXT,
  "contribution_date" TEXT,
  "amount" NUMERIC,
  "committee_id" INTEGER,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT,
  "incumbent" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "memo_reference_number" TEXT
,
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 ("contributor_employer") REFERENCES [businesses](id));
CREATE INDEX ["contribution_reports_24_hours_filer_id"] ON [contribution_reports_24_hours]("filer_id");
CREATE INDEX ["contribution_reports_24_hours_filer_name"] ON [contribution_reports_24_hours]("filer_name");
CREATE INDEX ["contribution_reports_24_hours_committee_id"] ON [contribution_reports_24_hours]("committee_id");
CREATE INDEX ["contribution_reports_24_hours_contributor_employer"] ON [contribution_reports_24_hours]("contributor_employer");