major_donor_ie_statements

FPPC Form 461, Part 5 Expenditure

Data source: F461P5_Expenditures

591 rows sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, election_date, entity_type, payee_first_name, payee_state, expenditure_type, candidate_prefix, candidate_suffix, office_sought, office_jurisdiction, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, support_or_oppose, memo_reference_number, business_name, business_address_1, business_address_2, business_city, business_state, business_zipcode, business_interest, business_activity, report_date (date), report_start_date (date), report_end_date (date), election_date (date), expenditure_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type payee_last_name payee_first_name payee_prefix payee_suffix payee_city payee_state zipcode expenditure_date expenditure_amt year_to_date expenditure_type expenditure_description 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 support_or_oppose memo_reference_number business_info_included business_name business_address_1 business_address_2 business_city business_state business_zipcode business_interest business_activity association_interest
587 587 1480057 394 MARTY GLICK 556 MDI 2025-07-26 2025-01-01 2025-06-30   EXP10 COM OAKLAND NEIGHBORS, BUSINESSES & PUBLIC SAFETY ADVOCATES FOR LOREN TAYLOR FOR MAYOR 2025 AND AGAINST BARBARA LEE       SACRAMENTO CA 95814 2025-04-04 00:00:00 20000 20000 MON   1479336 1312 SUPPORT: LOREN TAYLOR; OPPOSE: BARBARA LEE       MAY CITY OF OAKLAND               X GOLDEN STATE WARRIORS 16952 1 WARRIORS WAY   SAN FRANCISCO CA 94158 PROFESSIONAL SPORTS & ENTERTAINMENT    
588 588 1480057 394 MARTY GLICK 556 MDI 2025-07-26 2025-01-01 2025-06-30   EXP12 COM REELECT LENA TAM FOR ALAMEDA COUNTY SUPERVISOR 2026       ALAMEDA CA 94501 2025-06-27 00:00:00 500 500 MON   1478250 1313 LENA TAM       CSU ALAMEDA COUNTY 3.0         S   X GOLDEN STATE WARRIORS 16952 1 WARRIORS WAY   SAN FRANCISCO CA 94158 PROFESSIONAL SPORTS & ENTERTAINMENT    
589 589 1480069 397 MAX HODAK 538 MDI 2025-07-14 2025-01-01 2025-06-30   EXP3 COM KARA MURRAY BADAL FOR OAKLAND CITY COUNCIL 2025       Lakeport CA 95453 2025-03-09 00:00:00 650 650 MON   1477437 1314 KARA MURRAY BADAL       CCM CITY OF OAKLAND 2.0         S   X SCIENCE CORPORATION 16953 300 WIND RIVER WAY   ALAMEDA CA 94501 BIOLOGY TECHNOLOGY    
590 590 1480069 397 MAX HODAK 538 MDI 2025-07-14 2025-01-01 2025-06-30   EXP5 COM RESPONSIBLE LEADERSHIP FOR OAKLAND: ELECT LOREN TAYLOR FOR MAYOR 2025       Sacramento CA 95814 2025-03-17 00:00:00 20000 70000 MON   1479418 1292 LOREN TAYLOR       MAY CITY OF OAKLAND           S   X SCIENCE CORPORATION 16953 300 WIND RIVER WAY   ALAMEDA CA 94501 BIOLOGY TECHNOLOGY    
591 591 1480069 397 MAX HODAK 538 MDI 2025-07-14 2025-01-01 2025-06-30   EXP4 COM RESPONSIBLE LEADERSHIP FOR OAKLAND: ELECT LOREN TAYLOR FOR MAYOR 2025       Sacramento CA 95814 2025-03-28 00:00:00 50000 70000 MON   1479418 1292 LOREN TAYLOR       MAY CITY OF OAKLAND           S   X SCIENCE CORPORATION 16953 300 WIND RIVER WAY   ALAMEDA CA 94501 BIOLOGY TECHNOLOGY    
575 575 1286881 381 Linda C. Hothem 519 MDI 2025-03-12 2024-01-01 2024-12-31 2025-04-15 zXzZQUolDn6e OTH Town Fare       Oakland CA 94607 2024-12-10 00:00:00 16590.04 16590.04 IKD Payment for catering of campaign kick off event for Renia Webb for Oakland Mayor.                         S   X Pacific American Group, LLC 15662 104 Caledonia St. Suite C Sausalito CA 94965.0 Real Estate / Property Management    
576 576 156459 382 Gallagher 520 MDI 2025-02-05 2024-01-01 2024-12-31 2024-11-05 INC4 COM Citizens For A Brighter Oakland Future - Barbara Lee for Mayor 2025       Sacramento CA 95814 2024-07-22 00:00:00 50000 50000 MON   1.4713e+06 1230                       S   X Scott's Seafood Grill & Bar 14492 2 Broadway   Oakland CA 94607.0 Restaurant    
578 578 Pending 22 Elizabeth Stage 486 MDI 2025-01-22 2024-01-01 2024-12-31   EXP3 COM Casey Farmer for East Bay Regional Parks 2024       Alameda CA 94501 2024-03-18 00:00:00 500 500 MON   1.46482e+06 1101 Casey Farmer       OTH East Bay Regional Park Dist           S   X Not employed 511                
579 579 Pending 22 Elizabeth Stage 486 MDI 2025-01-22 2024-01-01 2024-12-31   EXP1 COM Make Oakland Wildfire Safe, Yes on MM       Oakland CA 94607 2024-09-01 00:00:00 2500 15828.63 MON   1.47287e+06 1231                 Wildfire Prevention Zone Ballot Measure parcel tax. MM City of Oakland S   X Not employed 511                
580 580 Pending 22 Elizabeth Stage 486 MDI 2025-01-22 2024-01-01 2024-12-31   EXP6 COM Make Oakland Wildfire Safe, Yes on MM       Oakland CA 94607 2024-10-07 00:00:00 20000 15828.63 LON   1.47287e+06 1231                 Wildfire Prevention Zone Ballot Measure parcel tax. MM City of Oakland S   X Not employed 511                
581 581 Pending 22 Elizabeth Stage 486 MDI 2025-01-22 2024-01-01 2024-12-31   RCV23 COM Make Oakland Wildfire Safe, Yes on MM       Oakland CA 94607 2024-12-31 00:00:00 0 15828.63 MON FORGIVEN LOAN 1.47287e+06 1231                 Wildfire Prevention Zone Ballot Measure parcel tax. MM City of Oakland     X Not employed 511                
582 582 Pending 22 Elizabeth Stage 486 MDI 2025-01-22 2024-01-01 2024-12-31   RCV22 COM Make Oakland Wildfire Safe, Yes on MM       Oakland CA 94607 2024-12-31 00:00:00 -6671.37 15828.63 LON LOAN REPAYMENT 1.47287e+06 1231                 Wildfire Prevention Zone Ballot Measure parcel tax. MM City of Oakland     X Not employed 511                
583 583 Pending 22 Elizabeth Stage 486 MDI 2025-01-22 2024-01-01 2024-12-31   EXP5 COM Oakland United Democratic Campaign       Stockton CA 95202 2024-09-15 00:00:00 2000 2000 MON   1.26679e+06 803                       S   X Not employed 511                
584 584 Pending 22 Elizabeth Stage 486 MDI 2025-01-22 2024-01-01 2024-12-31   EXP4 COM Reelect Ramachandran for Oakland City Council 2026       Alameda CA 94501 2024-06-01 00:00:00 200 200 MON   1.46868e+06 1232 Janani Ramachandran       CCM Oakland 4.0         S   X Not employed 511                
585 585 Pending 22 Oakland Metropolitan Chamber of Commerce 490 MDI 2025-01-07 2024-01-01 2024-12-31   EXP1 COM Oaklanders Together - For A Safer Oakland, Yes on NN       Oakland CA 94607 2024-10-25 00:00:00 0 0 MON   1.46777e+06 1229                 Citywide Violence Reduction Services NN City of Oakland S EXP1                    
577 577 480189 64 Clorox 489 MDI 2025-01-05 2024-01-01 2024-12-31   EXP1 COM Oaklanders Together - For A Safer Oakland, Yes on NN       Oakland CA 94607 2024-10-25 00:00:00 145000 145000 MON   1.46777e+06 1229                 Citywide Violence Reduction Services NN City of Oakland S EXP1                 Consumer and professional products  
586 586 Pending 22 East Bay Asian Youth Center 395 MDI 2024-05-16 2024-01-01 2024-04-30   CRFYxJjVAAOG COM Oaklanders Together - For A Safer Oakland       Oakland CA 94607 2024-04-15 00:00:00 10000 10000 MON   1.46777e+06 1229                       S                   Non-profit youth organization  
574 574   YouthALIVE! 518 MDI 2024-04-30 2024-03-29 2024-03-29 2024-11-05 hJqqLFx2MwmR COM Oakland Together - For a Safer Oakland FPPC       Oakland CA 94607 2024-03-29 00:00:00 50000 50000 MON Measure Z Oakland violence prevention 1.46777e+06 1229                       S                   Measure Z Oakland violence prevention  
505 505 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT23 OTH FRUITVALE VILLAGE       OAKLAND CA 94601 2022-09-15 00:00:00 7 29236.12 IND IND EXP OF EVENT FEE.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
506 506 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT22 OTH GODADDY.COM       TEMPE AZ 85284 2022-09-15 00:00:00 56.21 29236.12 IND IND EXP OF WEBSITE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
507 507 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT21 OTH TWIST INC.       JAMESTOWN OH 45335 2022-09-15 00:00:00 175 29236.12 IND IND EXP OF WEBSITE.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
508 508 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT2 OTH GO PUBLIC SCHOOLS ADVOCATES STAFF       SACRAMENTO CA 95822 2022-09-20 00:00:00 6170.46 29236.12 IND IND EXP OF STAFF TIME                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
509 509 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT3 OTH GO PUBLIC SCHOOLS ADVOCATES STAFF       SACRAMENTO CA 95822 2022-09-26 00:00:00 2406 29236.12 IND IND EXP OF STAFF TIME                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
510 510 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT4 IND RAMIREZ JENNIFER     SEATTLE WA 98175 2022-09-26 00:00:00 1500 29236.12 IND IND EXP OF WEBSITE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
511 511 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT5 OTH CANVA       SURRY HILLS   AUSTRALIA 2022-10-01 00:00:00 170 29236.12 IND IND EXP OF CAMPAIGN LITERATURE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
512 512 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT6 OTH CANVA       SURRY HILLS   AUSTRALIA 2022-10-03 00:00:00 170 29236.12 IND IND EXP OF CAMPAIGN LITERATURE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
513 513 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT8 OTH CANVA       SURRY HILLS   AUSTRALIA 2022-10-03 00:00:00 170 29236.12 IND IND EXP OF CAMPAIGN LITERATURE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
514 514 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT7 OTH OAKLAND FIRST FRIDAYS       OAKLAND CA 94612 2022-10-03 00:00:00 155 29236.12 IND IND EXP OF EVENT FEE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
515 515 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT9 OTH FEDEX       MEMPHIS TN 38120 2022-10-07 00:00:00 77.16 29236.12 IND IND EXP OF CAMPAIGN LITERATURE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
516 516 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT10 OTH CANVA       SURRY HILLS   AUSTRALIA 2022-10-10 00:00:00 170 29236.12 IND IND EXP OF CAMPAIGN LITERATURE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
517 517 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EXP15 COM FRIENDS OF OAKLAND PUBLIC SCHOOLS - YES ON MEASURE H       OAKLAND CA 94607 2022-10-13 00:00:00 7500 7500 MON   960997 152                 PARCEL TAX RENEWAL, MEASURE: H   OAKLAND UNIFIED SCHOOL DISTRICT S                      
518 518 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT24 OTH CANVA       SURRY HILLS   AUSTRALIA 2022-10-14 00:00:00 170 29236.12 IND IND EXP OF CAMPAIGN LITERATURE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
519 519 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT25 OTH CANVA       SURRY HILLS   AUSTRALIA 2022-10-24 00:00:00 170 29236.12 IND IND EXP OF CAMPAIGN LITERATURE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
520 520 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT26 OTH CANVA       SURRY HILLS   AUSTRALIA 2022-10-27 00:00:00 340 29236.12 IND IND EXP OF CAMPAIGN LITERATURE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
521 521 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT27 OTH CHURROS MEXICANOS       OAKLAND CA 94601 2022-10-27 00:00:00 8.28 29236.12 IND IND EXP OF VOLUNTEER FOOD AND BEVERAGE.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
522 522 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT28 OTH OBELISCO RESTAURANT       OAKLAND CA 94601 2022-10-30 00:00:00 13.23 29236.12 IND IND EXP OF VOLUNTEER FOOD AND BEVERAGE.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
523 523 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT11 OTH GO PUBLIC SCHOOLS ADVOCATES STAFF       SACRAMENTO CA 95822 2022-10-31 00:00:00 7083.44 29236.12 IND IND EXP OF STAFF TIME.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
524 524 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT12 OTH CANVA       SURRY HILLS   AUSTRALIA 2022-11-01 00:00:00 170 29236.12 IND IND EXP OF CAMPAIGN LITERATURE                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
525 525 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT13 OTH BINH MINH QUAN       OAKLAND CA 94607 2022-11-08 00:00:00 140.58 29236.12 IND IND EXP OF FOOD AND BEVERAGE.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
526 526 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT19 OTH BLUE BOTTLE COFFEE       OAKLAND CA 94607 2022-11-08 00:00:00 86.37 29236.12 IND IND EXP OF FOOD AND BEVERAGE.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
527 527 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT15 OTH CITY OF OAKLAND       OAKLAND CA 94612 2022-11-08 00:00:00 11 29236.12 IND IND EXP OF TRANSPORTATION FEES.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
528 528 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT16 OTH GO PUBLIC SCHOOLS ADVOCATES STAFF       SACRAMENTO CA 95822 2022-11-08 00:00:00 7500 29236.12 IND IND EXP OF CANVASSERS.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
529 529 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT17 OTH GO PUBLIC SCHOOLS ADVOCATES STAFF       SACRAMENTO CA 95822 2022-11-08 00:00:00 2156.31 29236.12 IND IND EXP OF STAFF TIME AND E-MAIL.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
530 530 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT32 OTH GO PUBLIC SCHOOLS ADVOCATES STAFF       SACRAMENTO CA 95822 2022-11-08 00:00:00 102.75 29236.12 IND IND EXP OF TRANSPORTATION FEES.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
531 531 Pending 22 GO Public Schools Advocates 385 MDI 2023-01-31 2022-01-01 2022-12-31   EDT35 OTH TACOS SINALOA       OAKLAND CA 94606 2022-11-08 00:00:00 57.33 29236.12 IND IND EXP OF FOOD AND BEVERAGE.                   ORDINANCE TO AUTHORIZE VOTING BY NONCITIZEN RESIDENTS FOR OAKLAND BOARD DIRECTOR, MEASURE S CITY OF OAKLAND S                      
541 541 155694 301 James Heerwagen 404 MDI 2023-01-31 2022-07-01 2022-12-31   EXP1 COM Oakland Fair Elections       Oakland CA 94612 2022-08-18 00:00:00 25000 25000 MON   1.44894e+06 1034                 Campaign Reform/Oakland Fair Elections Act     S EXP1 X Voters' Right to Know 13715 28 Liberty Ship Way, Suite 2815   Sausalito CA 94965.0 Transparency    
549 549 Pending 22 End Citizens United//Let America Vote Action Fund 416 MDI 2023-01-30 2022-07-27 2022-12-31 2022-11-08 SPZHebrBByIz COM Oakland Fair Elections, Sponsored by Civic Advocacy Organizations       Oakland CA 94613 2022-07-29 00:00:00 25000 25000 MON   1.44894e+06 1034                       S                      
554 554 Pending 22 California Forward Now 411 MDI 2023-01-30 2022-10-24 2022-12-31 2022-11-08 ZssiApOkMqlL IND Juarez Mario     Oakland CA 94601 2022-11-03 00:00:00 50306.5 50306.5 IND Mailers opposing Ignacio de la Fuente for Mayor 2022 Cumulative Total $110,933 1.44624e+06 1032                       O   X Mario Juarez 13717 1241 High Street   Oakland CA 94601.0 Independent Expenditures    
555 555 Pending 22 California Forward Now 411 MDI 2023-01-30 2022-10-24 2022-12-31 2022-11-08 bbxjLTu5Fg9f IND Juarez Mario     Oakland CA 94601 2022-11-03 00:00:00 60626.5 60626.5 IND Mailers opposing Loren Taylor for Oakland Mayor 2022 Cumulative total $110,933 1.44138e+06 1043                       O   X Mario Juarez 13717 1241 High Street   Oakland CA 94601.0 Independent Expenditures    
556 556   Stand Up America, Inc. 419 MDI 2023-01-26 2022-07-01 2022-12-31 2022-11-08 pXcd4d36AZv6 COM Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations       Oakland CA 94612 2022-07-18 00:00:00 25000 25909.21 MON   1.44894e+06 1034                       S                      
557 557   Stand Up America, Inc. 419 MDI 2023-01-26 2022-07-01 2022-12-31 2022-11-08 h9HkIBkr5B67 COM Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations       Oakland CA 94612 2022-10-22 00:00:00 909.21 25909.21 IKD Est. staff time and expenses related to disseminating communications 1.44894e+06 1034                       S                      
558 558 PENDING 59 THE CONSERVATION SOCIETY OF CALIFORNIA (DBA THE OAKLAND ZOO) 389 MDI 2023-01-24 2022-07-01 2022-12-31   EXP5 COM OAKLANDERS FOR THE OAKLAND ZOO 2022, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA       SAN FRANCISCO CA 94108 2022-08-19 00:00:00 200000 1054162.67 MON   1.44448e+06 1044         OTH       THE 2022 OAKLAND ZOO ANIMAL CARE, EDUCATION AND IMPROVEMENT ORDINANCE Y CITY OF OAKLAND S                   ECOLOGICAL CONSERVATION  
559 559 PENDING 59 THE CONSERVATION SOCIETY OF CALIFORNIA (DBA THE OAKLAND ZOO) 389 MDI 2023-01-24 2022-07-01 2022-12-31   EXP6 COM OAKLANDERS FOR THE OAKLAND ZOO 2022, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA       SAN FRANCISCO CA 94108 2022-10-04 00:00:00 150000 1054162.67 MON   1.44448e+06 1044         OTH       THE 2022 OAKLAND ZOO ANIMAL CARE, EDUCATION AND IMPROVEMENT ORDINANCE Y CITY OF OAKLAND S                   ECOLOGICAL CONSERVATION  
560 560 PENDING 59 THE CONSERVATION SOCIETY OF CALIFORNIA (DBA THE OAKLAND ZOO) 389 MDI 2023-01-24 2022-07-01 2022-12-31   EXP7 COM OAKLANDERS FOR THE OAKLAND ZOO 2022, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA       SAN FRANCISCO CA 94108 2022-10-24 00:00:00 150000 1054162.67 MON   1.44448e+06 1044         OTH       THE 2022 OAKLAND ZOO ANIMAL CARE, EDUCATION AND IMPROVEMENT ORDINANCE Y CITY OF OAKLAND S                   ECOLOGICAL CONSERVATION  
561 561 PENDING 59 THE CONSERVATION SOCIETY OF CALIFORNIA (DBA THE OAKLAND ZOO) 389 MDI 2023-01-24 2022-07-01 2022-12-31   EXP8 COM OAKLANDERS FOR THE OAKLAND ZOO 2022, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA       SAN FRANCISCO CA 94108 2022-11-09 00:00:00 150000 1054162.67 MON   1.44448e+06 1044         OTH       THE 2022 OAKLAND ZOO ANIMAL CARE, EDUCATION AND IMPROVEMENT ORDINANCE Y CITY OF OAKLAND S                   ECOLOGICAL CONSERVATION  
562 562 PENDING 59 THE CONSERVATION SOCIETY OF CALIFORNIA (DBA THE OAKLAND ZOO) 389 MDI 2023-01-24 2022-07-01 2022-12-31   EXP9 COM OAKLANDERS FOR THE OAKLAND ZOO 2022, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA       SAN FRANCISCO CA 94108 2022-12-30 00:00:00 4162.67 1054162.67 MON   1.44448e+06 1044         OTH       THE 2022 OAKLAND ZOO ANIMAL CARE, EDUCATION AND IMPROVEMENT ORDINANCE Y CITY OF OAKLAND S                   ECOLOGICAL CONSERVATION  
550 550 1392148 234 Mick Hellman 296 MDI 2023-01-22 2022-01-01 2022-12-31   EXP72 COM Yes on A, Committee for Safer Streets and Reliable, Accessible Transportation       San Francisco CA 94118 2022-04-15 00:00:00 5000 5000 MON   1.44496e+06 1039                 MUNI Reliability and Street Safety $400,000,000 A City and County of San Francisco S   X HMI Capital Management, L.P. 13716 555 California Street, Suite 4900   San Francisco CA 94104.0 Private Investments    
551 551 1392148 234 Mick Hellman 296 MDI 2023-01-22 2022-01-01 2022-12-31   EXP71 COM No on 30       Sacramento CA 95814 2022-10-19 00:00:00 50000 50000 MON   1.45034e+06 1040                 Provides Funding for Programs to Reduce Greenhouse Gas Emissions by Increasing Tax on Personal Income Over $2 Million 30 Statewide O   X HMI Capital Management, L.P. 13716 555 California Street, Suite 4900   San Francisco CA 94104.0 Private Investments    
552 552 1392148 234 Mick Hellman 296 MDI 2023-01-22 2022-01-01 2022-12-31   EXP73 COM Robinson for Richmond City Council 2022 Doria     Richmond CA 94804 2022-10-20 00:00:00 150 150 MON   1.45182e+06 1041 Doria Robinson       CCM City of Richmond 3.0         S   X HMI Capital Management, L.P. 13716 555 California Street, Suite 4900   San Francisco CA 94104.0 Private Investments    
553 553 1392148 234 Mick Hellman 296 MDI 2023-01-22 2022-01-01 2022-12-31   EXP74 COM Save John F. Kennedy Promenade, Yes on J, No on I       San Francisco CA 94118 2022-10-24 00:00:00 15000 15000 MON   1.44959e+06 1042                 Measure J - Recreational Use of JFK Drive in Golden Gate Park; Measure I - Vehicles on JFK Drive in Golden Gate Park and the Great Highway   City & County of San Francisco S   X HMI Capital Management, L.P. 13716 555 California Street, Suite 4900   San Francisco CA 94104.0 Private Investments    
563 563 1418349 298 Eden Housing Inc 394 MDI 2023-01-17 2022-07-01 2022-12-31 2022-11-08 JNyoj5SdGEde COM Oakland Neighbors for Affordable Housing and Safe Street, Yes on U 2022       Oakland CA 94609 2022-10-19 00:00:00 25000 25000 MON   1.45266e+06 1037                 Affordable Housing Infrastructure Bond U City of Oakland S                   Development, management, and ownership of affordable housing.  
545 545 1388235 297 MidPen Housing Corporation 393 MDI 2023-01-14 2022-01-01 2022-12-31   EXP38 COM Committee for an Affordable & Resilient Berkeley - Yes on L       Berkeley CA 94705 2022-10-19 00:00:00 5000 5000 MON   1.45156e+06 1036                 Affordable Housing and Infrastructure Bond L City of Berkeley S                      
546 546 1388235 297 MidPen Housing Corporation 393 MDI 2023-01-14 2022-01-01 2022-12-31   EXP37 COM Oakland Neighbors for Affordable Housing and Safe Street, Yes on U 2022       Oakland CA 94609 2022-10-18 00:00:00 40000 40000 MON   1.45266e+06 1037                 2022 Affordable Housing and Infrastructure Bonds U City of Oakland S                      
547 547   HOLLAND RESIDENTIAL (CALIFORNIA), INC. 392 MDI 2023-01-13 2022-01-01 2022-12-31   EXP3 COM CALIFORNIANS FOR SAFER STREETS SUPPORTING IGNACIO DE LA FUENTE FOR MAYOR OF OAKLAND 2022       Oakland CA 94607 2022-10-19 00:00:00 10000 10000 MON   1.45245e+06 1029 IGNACIO DE LA FUENTE       MAY CITY OF OAKLAND           S                   PROPERTY MANAGEMENT  
548 548   HOLLAND RESIDENTIAL (CALIFORNIA), INC. 392 MDI 2023-01-13 2022-01-01 2022-12-31   EXP1 COM CITIZENS FOR IMPACTFUL VOTING IN OAKLAND SUPPORTING LOREN TAYLOR, IGNACIO DE LA FUENTE & TREVA REID FOR MAYOR 2022       San Rafael CA 94901 2022-10-19 00:00:00 30000 30000 MON   1.45362e+06 1038 LOREN TAYLOR, IGNACIO DE LA FUENTE & TREVA REID       MAY CITY OF OAKLAND           S                   PROPERTY MANAGEMENT  
532 532 Pending 22 Oakland Bulk & Oversized Terminal LLC 396 MDI 2023-01-11 2022-01-01 2022-12-31   EXP1 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland 2022       Oakland CA 94607 2022-09-07 00:00:00 50000 50000 MON   1.45245e+06 1029 Ignacio de la Fuente       MAY Oakland           S EXP1                 Port Development  
533 533 Pending 22 Oakland Bulk & Oversized Terminal LLC 396 MDI 2023-01-11 2022-01-01 2022-12-31   EXP2 COM Newsom for California Governor 2022       Sacramento CA 95815 2022-10-10 00:00:00 15000 15000 MON   1.41402e+06 1030 Gavin Newsom       GOV             S                   Port Development  
542 542 Pending 22 William Rosetti 414 MDI 2023-01-11 2022-01-01 2022-12-31   EXP1 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland 2022       Oakland CA 94607 2022-09-30 00:00:00 25000 25000 MON   1.45245e+06 1029 Ignacio De La Fuente       MAY Oakland           S EXP1 X J&R Associates 1715 364 41st Street   Oakland CA 94607.0 Real Estate Investment and Management    
543 543 Pending 22 William Rosetti 414 MDI 2023-01-11 2022-01-01 2022-12-31   EXP2 COM Coalition for a Safer Oakland       Oakland CA 94607 2022-09-30 00:00:00 10000 10000 MON   1.45125e+06 1035                       S   X J&R Associates 1715 364 41st Street   Oakland CA 94607.0 Real Estate Investment and Management    
544 544 Pending 22 Boscacci 397 MDI 2023-01-11 2022-01-01 2022-12-31 2022-11-08 INC4 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland 2022       Oakland CA 94612 2022-09-09 00:00:00 10000 10000 MON   1.45245e+06 1029                       S   X   N/a              
534 534 Pending 22 Jonathan Brooks 391 MDI 2023-01-05 2022-01-01 2022-12-31   EXP7 COM Sheng Thao for Oakland Mayor 2022       Oakland CA 94602 2022-06-06 00:00:00 900 900 MON   1.44259e+06 911 Sheng Thao       MAY Oakland           S   X JMB Capital 12183 205 South Martel Avenue   Los Angeles CA 90036.0 Investments    
535 535 Pending 22 Jonathan Brooks 391 MDI 2023-01-05 2022-01-01 2022-12-31   EXP6 COM Nora Vargas For County Supervisor 2024       San Diego CA 92116 2022-07-07 00:00:00 850 850 MON   1.4436e+06 1031 Nora Vargas       CSU San Diego 1.0         S   X JMB Capital 12183 205 South Martel Avenue   Los Angeles CA 90036.0 Investments    
536 536 Pending 22 Jonathan Brooks 391 MDI 2023-01-05 2022-01-01 2022-12-31   EXP2 COM De La Fuente for Mayor 2022       Oakland CA 94606 2022-08-12 00:00:00 900 900 MON   1.44624e+06 1032 Ignacio de la Fuente       MAY Oakland           S   X JMB Capital 12183 205 South Martel Avenue   Los Angeles CA 90036.0 Investments    
537 537 Pending 22 Jonathan Brooks 391 MDI 2023-01-05 2022-01-01 2022-12-31   EXP1 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland       Oakland CA 94607 2022-09-06 00:00:00 50000 550000 MON   1.45245e+06 1029 Ignacio de la Fuente       MAY Oakland           S EXP1 X JMB Capital 12183 205 South Martel Avenue   Los Angeles CA 90036.0 Investments    
538 538 Pending 22 Jonathan Brooks 391 MDI 2023-01-05 2022-01-01 2022-12-31   EXP3 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland       Oakland CA 94607 2022-10-11 00:00:00 250000 550000 MON   1.45245e+06 1029 Ignacio de la Fuente       MAY Oakland           S   X JMB Capital 12183 205 South Martel Avenue   Los Angeles CA 90036.0 Investments    
539 539 Pending 22 Jonathan Brooks 391 MDI 2023-01-05 2022-01-01 2022-12-31   EXP4 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland       Oakland CA 94607 2022-10-20 00:00:00 250000 550000 MON   1.45245e+06 1029 Ignacio de la Fuente       MAY Oakland           S   X JMB Capital 12183 205 South Martel Avenue   Los Angeles CA 90036.0 Investments    
540 540 Pending 22 Jonathan Brooks 391 MDI 2023-01-05 2022-01-01 2022-12-31   EXP5 COM Seneca Scott for Oakland Mayor 2022       Oakland CA 94606 2022-10-25 00:00:00 900 900 MON   1.44432e+06 1033 Seneca Scott       MAY Oakland           S   X JMB Capital 12183 205 South Martel Avenue   Los Angeles CA 90036.0 Investments    
564 564 Pending 22 East Bay Asian Youth Center 395 MDI 2022-10-13 2022-07-01 2022-09-24 2022-11-08 44iVmhGjGKdX COM Friends of Oakland Public Schools       OAKLAND CA 94607 2022-09-21 00:00:00 20000 20000 MON   960997 152                 Yes on H H OUSD S                      
565 565 Pending 22 U.S. Real Estate Investment Fund REIT, Inc. 418 MDI 2022-08-02 2022-01-01 2022-06-30 2022-11-08 IDT3 COM Oaklanders Together, a coalition of small and large businesses, business-serving organizations, and the Oakland Metropolitan Chamber of Commerce       Oakland CA 94607 2022-04-11 00:00:00 71250 71250 MON   1.44585e+06 1045                 Progressive & Equitable Oakland Business Gross Receipts Tax TBD City of Oakland, CA S IDT:PT5:3                 Real Estate  
566 566 Pending 22 Tidewater Capital LLC and affiliated entities 415 MDI 2022-08-02 2022-01-01 2022-06-30 2022-11-08 INC30 COM Oaklanders Together, a coalition of small and large businesses, business-serving organizations, and the Oakland Metropolitan Chamber of Commerce       Oakland CA 94607 2022-04-13 00:00:00 21512.84 75000 MON   1.44585e+06 1045                 Progressive & Equitable Oakland Business Gross Receipts Tax TBD City of Oakland, CA S INC:PT5:30                 Real Estate  
567 567 Pending 22 Tidewater Capital LLC and affiliated entities 415 MDI 2022-08-02 2022-01-01 2022-06-30 2022-11-08 INC91 COM Oaklanders Together, a coalition of small and large businesses, business-serving organizations, and the Oakland Metropolitan Chamber of Commerce       Oakland CA 94607 2022-04-13 00:00:00 53487.16 75000 MON   1.44585e+06 1045                 Progressive & Equitable Oakland Business Gross Receipts Tax TBD City of Oakland, CA S INC:PT5:91                 Real Estate  
568 568 942553734 182 Friends of the Oakland Public Library 234 MDI 2022-07-29 2022-01-01 2022-07-31 2022-06-07 gfFu9OIHeWkE COM Neighbors for the Oakland Library       Oakland CA 94607 2022-03-21 00:00:00 40000 40000 MON   1.44586e+06 1046                 Protect Oakland Libraries C Oakland, CA S                      
569 569 486330 310 Kaiser Foundation Health Plan, Inc. and the Hospitals 421 MDI 2022-07-27 2022-01-01 2022-06-30   EXP194 COM a coalition of small and large businesses, business-serving organizations, and the Oakland Metroplitan Chamber of Commerce Oaklanders Together,     Oakland CA 94607 2022-05-06 00:00:00 25000 25000 MON   1.44585e+06 1045                 Progressive & Equitable Oakland Business Gross Receipts Tax   City of Oakland S EXP194                 Healthcare  
570 570 PENDING 59 THE CONSERVATION SOCIETY OF CALIFORNIA (DBA THE OAKLAND ZOO) 389 MDI 2022-07-27 2022-01-01 2022-06-30   EXP1 COM OAKLANDERS FOR THE OAKLAND ZOO 2022, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA       SAN FRANCISCO CA 94108 2022-01-28 00:00:00 100000 400000 MON   1.44448e+06 1044         OTH       THE 2022 OAKLAND ZOO ANIMAL CARE, EDUCATION AND IMPROVEMENT ORDINANCE TBD CITY OF OAKLAND S EXP1                 ECOLOGICAL CONSERVATION  
571 571 PENDING 59 THE CONSERVATION SOCIETY OF CALIFORNIA (DBA THE OAKLAND ZOO) 389 MDI 2022-07-27 2022-01-01 2022-06-30   EXP2 COM OAKLANDERS FOR THE OAKLAND ZOO 2022, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA       SAN FRANCISCO CA 94108 2022-03-16 00:00:00 100000 400000 MON   1.44448e+06 1044         OTH       THE 2022 OAKLAND ZOO ANIMAL CARE, EDUCATION AND IMPROVEMENT ORDINANCE TBD CITY OF OAKLAND S EXP2                 ECOLOGICAL CONSERVATION  
572 572 PENDING 59 THE CONSERVATION SOCIETY OF CALIFORNIA (DBA THE OAKLAND ZOO) 389 MDI 2022-07-27 2022-01-01 2022-06-30   EXP3 COM OAKLANDERS FOR THE OAKLAND ZOO 2022, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA       SAN FRANCISCO CA 94108 2022-04-27 00:00:00 100000 400000 MON   1.44448e+06 1044         OTH       THE 2022 OAKLAND ZOO ANIMAL CARE, EDUCATION AND IMPROVEMENT ORDINANCE TBD CITY OF OAKLAND S EXP3                 ECOLOGICAL CONSERVATION  
573 573 PENDING 59 THE CONSERVATION SOCIETY OF CALIFORNIA (DBA THE OAKLAND ZOO) 389 MDI 2022-07-27 2022-01-01 2022-06-30   EXP4 COM OAKLANDERS FOR THE OAKLAND ZOO 2022, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA       SAN FRANCISCO CA 94108 2022-05-25 00:00:00 100000 400000 MON   1.44448e+06 1044         OTH       THE 2022 OAKLAND ZOO ANIMAL CARE, EDUCATION AND IMPROVEMENT ORDINANCE TBD CITY OF OAKLAND S EXP4                 ECOLOGICAL CONSERVATION  
504 504 S11791R 196 The Clorox Company 60 MDI 2022-01-04 2021-10-01 2021-12-31 2022-02-15 14632214 RCP Rob Bonta for California Attorney General 2022, ID #1437201       San Francisco CA 94104 2021-11-23 00:00:00 2500 2500 MON   1437201 922 Bonta Rob     ATT Statewide   S       S                   Consumer Houshold Products  
456 456 Pending 22 Michael R. Bloomberg 301 MDI 2021-01-27 2020-01-01 2020-12-31   VrLgHf5XpE5J COM Stanislaus County Democratic Central Committee - State       Sacramento CA 95841 2020-02-27 00:00:00 2500 2500 MON   742328 869                       S   X Bloomberg LP 4698 731 Lexington Avenue   New York NY 10022.0 Founder    
457 457 Pending 22 Michael R. Bloomberg 301 MDI 2021-01-27 2020-01-01 2020-12-31   xKYQIVSIVaKq COM Families and Educators for Public Education, Sponsored by GO Public Schools Advocates       Oakland CA 94607 2020-09-11 00:00:00 300000 300000 MON   1331137 50                       S   X Bloomberg LP 4698 731 Lexington Avenue   New York NY 10022.0 Founder    
458 458 Pending 22 Michael R. Bloomberg 301 MDI 2021-01-27 2020-01-01 2020-12-31   uPHDDRHVZhac COM Power2Families       Sacramento CA 95815 2020-09-11 00:00:00 200000 200000 MON   1431009 773                       S   X Bloomberg LP 4698 731 Lexington Avenue   New York NY 10022.0 Founder    
459 459 Pending 22 Michael R. Bloomberg 301 MDI 2021-01-27 2020-01-01 2020-12-31   2HCvj6MX9YFK COM Central Valley Leadership Fund       Stockton CA 95219 2020-10-07 00:00:00 315000 315000 MON   1363979 870                       S   X Bloomberg LP 4698 731 Lexington Avenue   New York NY 10022.0 Founder    
460 460 Pending 22 Michael R. Bloomberg 301 MDI 2021-01-27 2020-01-01 2020-12-31   VLijRv5SMqJ5 COM Yes on A       San Francisco CA 94118 2020-10-23 00:00:00 250000 250000 MON   1430331 871                 Health and Homelessness,Parks, and Streets Bond A San Francisco S   X Bloomberg LP 4698 731 Lexington Avenue   New York NY 10022.0 Founder    
461 461 Pending 22 LCA Architects Inc. 299 MDI 2021-01-18 2020-07-01 2020-12-31 2020-11-03 tFkAhPPHmKlS COM Friends of Oakland Public Schools       Oakland CA 94611 2020-08-19 00:00:00 20000 20000 MON   960997 152                 School Facilities Bond Measure Y OUSD S                   Architecture  
462 462 Pending 22 LCA Architects Inc. 299 MDI 2021-01-18 2020-07-01 2020-12-31 2020-11-03 NUxbyv6e1nbH COM Friends of Phil Kranenburg for 2020 Marin Community College District, Trustee, ID #1428047       San Rafael CA 94903 2020-09-23 00:00:00 1500 1500 MON Campaign Contribution 1428047 770 Kranenburg Phil     CCB   5.0         S                   Architecture  
463 463 480189 64 The Clorox Company 60 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14156427 RCP Bill Quirk for Assembly 2020       Sacramento CA 95814 2020-10-01 00:00:00 1000 1000 MON   1414232 698 Quirk Bill CA Asm.   ASM Assembly District 20.0 S       S                   Consumer Houshold Products  
464 464 480189 64 The Clorox Company 60 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14156429 RCP Re-Elect Lynette Gibson-McElhaney for City Council 2020       Oakland CA 94607 2020-10-01 00:00:00 900 900 MON   1421347 765 Gibson-McElhaney Lynette     CCM Oakland   S       S                   Consumer Houshold Products  
465 465 480189 64 The Clorox Company 60 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14171362 RCP Nancy Skinner for Senate 2020       Sacramento CA 95814 2020-10-06 00:00:00 1000 1000 MON   1392359 621 Skinner Nancy CA Sen.   SEN Senate District 9.0 S       S                   Consumer Houshold Products  
466 466 480189 64 The Clorox Company 60 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14171363 RCP Cottie Petrie-Norris for Assembly 2020       Sacramento CA 95814 2020-10-06 00:00:00 1500 1500 MON   1414368 703 Petrie-Norris Cottie CA Asm.   ASM Assembly District 74.0 S       S                   Consumer Houshold Products  
467 467 480189 64 The Clorox Company 60 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14176040 RCP Autumn Burke for Assembly 2020       Sacramento CA 95814 2020-10-12 00:00:00 1500 1500 MON   1414347 872 Burke Autumn CA Asm.   ASM Assembly District 62.0 S       S                   Consumer Houshold Products  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "major_donor_ie_statements" (
"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,
  "payee_last_name" TEXT,
  "payee_first_name" TEXT,
  "payee_prefix" TEXT,
  "payee_suffix" TEXT,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "zipcode" TEXT,
  "expenditure_date" TEXT,
  "expenditure_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "expenditure_type" TEXT,
  "expenditure_description" TEXT,
  "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,
  "support_or_oppose" TEXT,
  "memo_reference_number" TEXT,
  "business_info_included" TEXT,
  "business_name" INTEGER,
  "business_address_1" TEXT,
  "business_address_2" TEXT,
  "business_city" TEXT,
  "business_state" TEXT,
  "business_zipcode" TEXT,
  "business_interest" TEXT,
  "business_activity" TEXT,
  "association_interest" 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 ("business_name") REFERENCES [businesses](id));
CREATE INDEX ["major_donor_ie_statements_filer_id"] ON [major_donor_ie_statements]("filer_id");
CREATE INDEX ["major_donor_ie_statements_filer_name"] ON [major_donor_ie_statements]("filer_name");
CREATE INDEX ["major_donor_ie_statements_committee_id"] ON [major_donor_ie_statements]("committee_id");
CREATE INDEX ["major_donor_ie_statements_business_name"] ON [major_donor_ie_statements]("business_name");