monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

35 rows where filer_name = 500 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, entity_type, 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
99863 99863 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC72 IND Baird Jeffrey   Berkeley CA 94705 Merritt Point Partners 14941 Finance Officer n   2024-11-16 100 100     INC72
99864 99864 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC74 IND Booker Frederick   Berkeley CA 94705-1632   Retired n   2024-11-19 100 100      
99865 99865 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC61 IND Brodersen Shelagh   Berkeley CA 94705-1441   Retired n   2024-10-22 300 300      
99866 99866 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC62 IND Conolly Daniel D.   Berkeley CA 94705   Retired n   2024-10-22 250 250      
99867 99867 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC76 IND Cotton Betsy   Berkeley CA 94705 Women's Catalytic Fund 10477 Nonprofit Manager n   2024-11-19 250 250     INC76
99868 99868 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC77 IND Foran Mary P.   Berkeley CA 94705   Retired n   2024-11-21 100 100      
99869 99869 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC100 IND Loughman Katharine H.   Berkeley CA 94705   Retired n   2024-12-02 100 100      
99870 99870 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC73 IND Parekh Jean   Hillsborough CA 94010   Not Employed n   2024-11-14 150 150     INC73
99871 99871 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC75 IND Sklar Ralph   Oakland CA 94611-3204 Silver Transitions Financial & Insurance Solutions 14942 Principal and Financial Adviser n   2024-11-19 1000 1000      
99872 99872 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   PAY143 IND Stage Elizabeth   Berkeley CA 94705   Not Employed n F 2024-12-31 13328.63 15828.63      
99873 99873 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC99 IND Suhami Iren   Berkeley CA 94705 Contra Costa Jewish Day School 414 Board of Trustees n   2024-12-02 100 100      
99874 99874 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC101 IND Williams Frank   Berkeley CA 94705 Big Bend 14943 Drilling company owner n   2024-12-03 250 250     INC101
99875 99875 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2025-01-27 2024-10-20 2024-12-31   INC71 IND Wozniak Gordon   Berkeley CA 94705   Not Employed n   2024-11-16 250 250     INC71
100527 100527 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC54 OTH Alward Construction Comp, Inc.     Berkeley CA 94710-2638     n   2024-10-14 250 250      
100528 100528 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC52 IND Debare Ilana   Oakland CA 94618-1750 Golden Gate Audubon Society 7663 Communications Director n   2024-10-16 150 150     INC52
100529 100529 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC44 IND Goldhaber Marilyn   San Antonio TX 78230   Not Employed n   2024-10-07 200 200     INC44
100530 100530 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC56 IND Gordon Andrea   Berkeley CA 94705 Andrea Gordon 15029 Realtor n   2024-10-12 100 100     INC56
100531 100531 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC21 COM International Association of Firefighter Local 55 PAC (IAFF)     Oakland CA 94612     n   2024-10-08 10000 10000   59.0  
100532 100532 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC50 IND Kaufman Jonathan   Berkeley CA 94705-1510   Retired n   2024-10-17 1000 2000     INC50
100533 100533 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC43 IND Meyers Robert   Oakland CA 94611   Not Employed n   2024-10-10 200 200     INC43
100534 100534 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC45 IND Mueller Nancy   Berkeley CA 94705   Not Employed n   2024-10-07 100 200     INC45
100535 100535 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC55 IND Nicholas Helen   Oakland CA 94611 Compass 8821 Real Estate Broker n   2024-10-14 250 250     INC55
100536 100536 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC42 OTH PG&E Corporation     Oakland CA 94612     n   2024-10-10 5200 5200      
100537 100537 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC53 IND Proctor Don   Berkeley CA 94705   Not Employed n   2024-10-15 100 100     INC53
100538 100538 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC51 IND Rosenberg Emily   Oakland CA 94619   Not Employed n   2024-10-16 500 500     INC51
100539 100539 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC17 OTH Star Grocery     Berkeley CA 94705     n   2024-09-30 100 100      
100540 100540 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-10-21 2024-09-22 2024-10-19 2024-11-05 INC16 IND Tao Jinee   Berkeley CA 94705   Not Employed n   2024-09-29 1000 1000     INC16
103022 103022 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-09-23 2024-01-01 2024-09-21 2024-11-05 INC11 OTH Claremont Canyon Conservancy     Berkeley CA 94705     n   2024-09-20 5000 5000      
103023 103023 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-09-23 2024-01-01 2024-09-21 2024-11-05 INC9 IND Harami Brandon   Oakland CA 94611 City Of Oakland 2163 Special Assistant To The Mayor n   2024-09-19 100 100     INC9
103024 103024 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-09-23 2024-01-01 2024-09-21 2024-11-05 INC2 IND Kaufman Jonathan   Berkeley CA 94705-1510   Retired n   2024-08-21 1000 1000      
103025 103025 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-09-23 2024-01-01 2024-09-21 2024-11-05 INC6 IND Kessler David   Berkeley CA 94705   Not Employed n   2024-09-12 100 100     INC6
103026 103026 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-09-23 2024-01-01 2024-09-21 2024-11-05 INC10 IND McGreal Derek   Berkeley CA 94705   Not Employed n   2024-09-18 250 250     INC10
103027 103027 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-09-23 2024-01-01 2024-09-21 2024-11-05 INC7 IND Morgenstern Marc   Cleveland OH 44120 Blue Mesa Partners 15248 Managing Partner n   2024-09-11 100 100     INC7
103028 103028 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-09-23 2024-01-01 2024-09-21 2024-11-05 INC3 IND Mueller Nancy   Berkeley CA 94705   Not Employed n   2024-08-26 100 100      
103029 103029 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 2024-09-23 2024-01-01 2024-09-21 2024-11-05 INC4 IND Stage Elizabeth   Berkeley CA 94705   Not Employed n   2024-09-01 2500 2500     INC4

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