ie_contributions

FPPC Form 496, Part 3 Contributions

Data source: F496P3_Contributions

13 rows where filer_name = 531 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, transaction_id, entity_type, last_name, city, state, zipcode, transaction_date, transaction_amt, year_to_date, committee_id, report_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
9223 9223 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-04-08       INC79 COM MEDICARE FOR ALL PAC     WASHINGTON DC 20006     n   2025-04-03 20000 20000      
9224 9224 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-04-08       INC76 COM SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1021 CANDIDATE PAC     SACRAMENTO CA 95814     n   2025-04-03 40000 90000   148.0  
9225 9225 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-04-08       INC80 COM UNITY PAC, A SPONSORED COMMITTEE OF THE ALAMEDA LABOR COUNCIL, AFL-CIO     OAKLAND CA 94621     n   2025-04-03 15000 15000   147.0  
9226 9226 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-04-08       INC85 COM SMART JUSTICE CALIFORNIA ACTION FUND     SACRAMENTO CA 95815     n   2025-04-04 10000 10000   1086.0  
9218 9218 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-04-02       INC57 COM SEIU UNITED HEALTHCARE WORKERS WEST POLITICAL ACTION COMMITTEE     LOS ANGELES CA 90017     n   2025-03-27 25000 25000   407.0  
9241 9241 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-04-02       INC69 COM DIGNITY CA SERVICE EMPLOYEES INTERNATIONAL UNION SEIU LOCAL 2015     SACRAMENTO CA 95814     n   2025-03-31 25000 25000   150.0  
9259 9259 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-03-28       INC57 COM SEIU UNITED HEALTHCARE WORKERS WEST POLITICAL ACTION COMMITTEE     LOS ANGELES CA 90017     n   2025-03-27 25000 25000   407.0  
9263 9263 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-03-26       INC50 COM STEAMFITTERS LOCAL 342 POLITICAL ACTION COMMITTEE     CONCORD CA 94518     n   2025-03-24 5000 10000   37.0  
9284 9284 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-03-17       INC23 IND ADAMS GREGORY   ALTADENA CA 91001-2828 KAISER FOUNDATION HEALTH PLAN, INC. 16552 CHAIR & CHIEF EXECUTIVE OFFICER n   2025-03-14 20000 20000      
9285 9285 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-03-13       INC13 COM INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 595 PAC     DUBLIN CA 94568     n   2025-03-03 10000 10000   297.0  
9286 9286 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-03-13       INC18 IND DELUCA NICCOLO   SACRAMENTO CA 95818 TOWNSEND PUBLIC AFFAIRS 16551 VICE PRESIDENT n   2025-03-04 800 800      
9287 9287 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-03-13       INC19 OTH TERRE FORTE(BARBARA DELUCA)     OAKLAND CA 94612     n   2025-03-04 900 900      
9288 9288 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 2025-03-13       INC20 COM SHEET METAL WORKERS LOCAL UNION 104 POLITICAL COMMITTEE     LIVERMORE CA 94551     n   2025-03-11 5000 10000   81.0  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "ie_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" TEXT,
  "city" TEXT,
  "state" TEXT,
  "zipcode" TEXT,
  "employer" INTEGER,
  "occupation" TEXT,
  "self_employed" TEXT,
  "transaction_type" TEXT,
  "transaction_date" TEXT,
  "transaction_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "transaction_description" TEXT,
  "committee_id" 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 ("employer") REFERENCES [businesses](id));
CREATE INDEX ["ie_contributions_filer_id"] ON [ie_contributions]("filer_id");
CREATE INDEX ["ie_contributions_filer_name"] ON [ie_contributions]("filer_name");
CREATE INDEX ["ie_contributions_committee_id"] ON [ie_contributions]("committee_id");
CREATE INDEX ["ie_contributions_employer"] ON [ie_contributions]("employer");