monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

48 rows where filer_name = 199 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, city, state, zipcode, transaction_date, transaction_amt, year_to_date, report_date (date), report_start_date (date), report_end_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
44542 44542 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC75 IND Ahrens Josie   Oakland CA 94611   Student n   2018-10-26 700 700      
44543 44543 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC54 IND Beem Elizabeth   San Francisco CA 94116 San Francisco Public Utilities Commission 5886 Analyst n   2018-10-24 400 400      
44544 44544 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC53 IND Bossy Adam   San Francisco CA 94110 Patreon 7559 Engineering Manager n   2018-10-24 100 100      
44545 44545 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC88 IND Brown Clementine   Berkeley CA 94703 Hospice by the Bay 7560 Counselor n   2018-10-29 1000 1000      
44546 44546 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC117 COM Committee To Save Our Neighborhoods     Los Angeles CA 90017     n   2018-11-28 600 600   571.0  
44547 44547 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC81 IND Conley Eli I.   Berkeley CA 94703 Eli I. Conley 7561 Singer-Songwriter and Voice Teacher n   2018-10-26 500 500      
44548 44548 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC37 IND Crary-Ross Shane   Santa Rosa CA 95404 California Rural Legal Assistance 7562 Legal Services n   2018-10-23 300 300      
44549 44549 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC35 IND Farnsworth Irene   Oakland CA 94611   Student n   2018-10-23 100 100      
44550 44550 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC97 IND Fernandez Ubaldo   Berkeley CA 94703 East Bay Community Law Center 127 Attorney n   2018-10-30 100 100      
44551 44551 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC13 IND Fishlyn Zeph   Oakland CA 94601 Zeph Fishlyn 7563 Artist n   2018-10-22 250 250      
44552 44552 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC12 IND Fox Marie   Oakland CA 94610 Thornhill Parent & Faculty Club 7564 Library Technician n   2018-10-22 250 250      
44553 44553 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC11 IND Garrett-Farb Bryan   Berkeley CA 94705 Western Pacific 7565 Cook n   2018-10-22 100 100      
44554 44554 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC18 IND Gelman Rachel   Oakland CA 94611 JYCA 7566 Youth Educator n   2018-10-22 2000 2000      
44555 44555 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC26 IND Gordon Meghan   Albany CA 94706 East Bay Community Law Center 127 Attorney n   2018-10-23 100 100      
44556 44556 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC98 IND Hall David   Berkeley CA 94702 East Bay Community Law Center 127 Attorney n   2018-10-30 100 100      
44557 44557 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC50 IND Hansen Gordon   Oakland CA 94609 City of Berkeley 1666 Transportation Planner n   2018-10-24 150 150      
44558 44558 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC96 IND Hom Rebecca   Oakland CA 94601 Causa Justa :: Just Cause 2789 Community Organizer n   2018-10-30 100 100      
44559 44559 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC49 IND Jacobs Josh   Berkeley CA 94709   Student n   2018-10-24 500 500      
44560 44560 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC39 IND Jong Iris   Arcadia CA 91007 1990 7567 Non-Profit n   2018-10-23 200 200      
44561 44561 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC46 IND Kaufman Diane   Oakland CA 94610   Retired n   2018-10-24 300 300      
44562 44562 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC69 IND Kirstein Paige   San Francisco CA 94109 True Link Financial 6678 Product Manager n   2018-10-25 500 500      
44563 44563 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC67 IND Kivel Paul   Oakland CA 94610 Paul Kivel 7568 Activist n   2018-10-25 250 250      
44564 44564 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC51 IND Klyman Jay   Oakland CA 94610 Seneca Family of Agencies 5656 Mental Health Counselor n   2018-10-24 150 150      
44565 44565 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC47 IND Leber Matthew   Oakland CA 94609 AFSC 7569 Organizer n   2018-10-24 100 100      
44566 44566 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC7 IND Levy Zeno   Sacramento CA 95816 US Geological Survey 7570 Hydrogeologist n   2018-10-22 550 550      
44567 44567 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC19 IND Lewis Daniel   Berkeley CA 94707   Not Employed n   2018-10-22 2500 5000      
44568 44568 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC20 IND Lewis Daniel   Berkeley CA 94707   Not Employed n   2018-10-23 2500 5000      
44569 44569 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC74 IND Li Kevin   San Francisco CA 94107 Split 7571 Product Manager n   2018-10-25 100 100      
44570 44570 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC34 IND Mallillin Allistair   Boston MA 02124 Common Counsel Foundation 6189 Senior Program Officer n   2018-10-23 200 200      
44571 44571 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC86 IND Marszalek Julian   Berkeley CA 94703 Macrae Consulting 7572 Carpenter n   2018-10-29 105 105      
44572 44572 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC71 IND Mayo Tyler   Berkeley CA 94703 Strozzi Institute 7573 Program Manager n   2018-10-25 100 100      
44573 44573 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC36 IND McClure Molly   Oakland CA 94619 Causa Justa :: Just Cause 2789 Volunteer Coordinator n   2018-10-23 150 150      
44574 44574 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC15 IND Mellard O'Neil Megan   Oakland CA 94610 Local Clean Enery Alliance 7574 Project Manager n   2018-10-22 100 500      
44575 44575 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC29 IND Mellard O'Neil Megan   Oakland CA 94610 Local Clean Enery Alliance 7574 Project Manager n   2018-10-23 400 500      
44576 44576 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC33 IND Miller Caitlin   Oakland CA 94602 OB Hospitalist Group 7575 Midwife n   2018-10-23 100 100      
44577 44577 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC17 IND Omura Anne   Oakland CA 94609 Eviction Defense Center 213 Attorney n   2018-10-22 200 200      
44578 44578 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC87 IND Orr Katherine B.   Pittsburgh PA 15232   Student n   2018-10-29 15000 15000      
44579 44579 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC52 IND Parpia Zakir   Oakland CA 94601 CA School-Age Consortium 7576 Director of Fiscal Partnerships n   2018-10-24 500 500      
44580 44580 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC8 IND Pien Andrea   San Francisco CA 94122 Bay School of San Francisco 7577 Counselor n   2018-10-22 200 200      
44581 44581 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC27 IND Prier Megan B   Malvern PA 19355 UC Berkeley 126 Basic Needs Food Manager n   2018-10-23 100 100      
44582 44582 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC14 IND Sakaguchi Dan   Emeryville CA 94608 Communities for a Better Environment 4866 Researcher n   2018-10-22 100 100      
44583 44583 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC65 IND Schottenfeld Lisa   Oakland CA 94610 Mathematica Policy Research 7578 Research n   2018-10-25 100 100      
44584 44584 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC38 IND Silveira Alison   Oakland CA 94618 Causa Justa :: Just Cause 2789 Specialist n   2018-10-23 200 200      
44585 44585 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC92 OTH Urban Habitat     Oakland CA 94612     n   2018-11-01 5550 5550      
44586 44586 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC72 IND Van Wesep Pater   Oakland CA 94609   Retired n   2018-10-25 500 500      
44587 44587 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC21 IND Weinstein Ari   Philadelphia PA 19119 Apple, Inc. 2718 Software Engineer n   2018-10-23 500 500      
44588 44588 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC32 IND Weisgrau Austin   Oakland CA 94609 1991 7579 Youth Worker n   2018-10-23 100 100      
44589 44589 1413440 159 Protect Oakland Renters, Yes on Measure Y. Sponsored by Community Organizations 199 2019-01-20 2018-10-21 2018-12-31   INC31 IND Yedidia Dalia   San Francisco CA 94118   Student n   2018-10-23 100 100      

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