monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

45 rows where filer_name = 44 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, employer, occupation, transaction_date, transaction_amt, year_to_date, committee_id, 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
13402 13402 1361954 51 Dan Kalb City Council Officeholder Committee 44 2015-01-25 2014-07-01 2014-12-31   rZGlIKHOq3Ig COM Rob Bonta for Assembly 2014     Sacramento CA 95815     n   2014-08-04 700 700   85.0  
13403 13403 1361954 51 Dan Kalb City Council Officeholder Committee 44 2015-01-25 2014-07-01 2014-12-31   r8xEldNrgDVD COM Sheet Metal Workers' Local Union No.104 Political Action Committee     San Ramon CA 94583     n   2014-09-19 750 750   81.0  
18752 18752 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   htsySk15hM4i COM International Association of Firefighters, Local 55     Oakland CA 94612     n   2014-03-19 600 600   276.0  
18753 18753 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   C1Bch8gV5rSQ IND Piper Sue   Oakland CA 94618 Susan Piper Public Relations 4136 Public Relations Consultant n   2014-05-19 150 150      
18754 18754 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   QSPPaDhIgGYn IND Ubell Michael   Oakland CA 94618 Retired 124 Retired n   2014-05-20 100 100      
18755 18755 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   e7vAtzMpzkuz IND Nunez Jody   Oakland CA 94611 County of Alameda 2540 Attorney n   2014-05-23 500 500      
18756 18756 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   37jj4IramqvY IND Altshuler Lynn   San Francisco CA 94118 Independent Law Practice Professional 4137 Attorney n   2014-05-28 100 100      
18757 18757 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   mB1iI7tVi3Hl IND Schlichtmann Laura   Oakland CA 94618 Retired 124 Retired n   2014-05-29 100 100      
18758 18758 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   DPLHNtakoKhE IND Abrams James   Oakland CA 94107 Greene, Radovsky, Maloney, Share & Hennigh 4138 Attorney n   2014-06-01 200 200      
18759 18759 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   A5odJZQSBDpf COM DRIVE Committee     WASHINGTON DC 20001     n   2014-06-02 500 500   41.0  
18760 18760 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   H4swWHfcGOoG IND McCarthy Joseph   Moraga CA 94556 BRIDGE Housing Corporation 73 Senior Project Manager n   2014-06-02 150 150      
18761 18761 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   NQOCJK5NqjB7 IND Shawl Susan   Oakland CA 94618 Retired 124 Retired n   2014-06-02 100 100      
18762 18762 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   raE6zb4BlOUc IND Belcher Judith Anne   Oakland CA 94609 Retired 124 Retired n   2014-06-04 100 100      
18763 18763 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   Z9TvhqI8d38e IND Hamlin Earl   Oakland CA 94618 Port of Oakland 421 Port Commissioner n   2014-06-04 700 700      
18764 18764 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   VjbSvq8dNWu1 IND Kaplan Rebecca   Oakland CA 94607 City of Oakland 8 City Councilmember n   2014-06-04 180 180      
18765 18765 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   ufby9VrizdWO IND Lewandowski Kent   Oakland CA 94606 Kaiser Permanente 137 Senior Data Consultant n   2014-06-04 150 150      
18766 18766 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   pFIoHcb2md4L IND Niesar Ortrun   Oakland CA 94618 Sothebys 4139 Realtor n   2014-06-04 100 100      
18767 18767 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   xgdBKvZ4enJC IND Nye Bruce   Oakland CA 94618 Adams, Nye, Becht LLP 4140 Attorney n   2014-06-04 150 150      
18768 18768 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   2nTORHXSbHrC IND Raich Robert   Oakland CA 94619 Self 228 Attorney n   2014-06-04 500 500      
18769 18769 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   kJjsbWBKAQpm IND Rosenthal Susan   Oakland CA 94610 Operating Engineers Local Union No. 3 4141 Staff n   2014-06-04 100 100      
18770 18770 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   zelyPkRhg8AZ OTH Susan Piper Public Relations     Oakland CA 94618     n   2014-06-04 100 100      
18771 18771 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   Q9dDwtMtbf4v IND Toney Mark   Oakland CA 94619 TURN 449 Executive Director n   2014-06-04 100 100      
18772 18772 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   r9e6qI2vdfib IND Wasserman Robert   Oakland CA 94610 Wendel, Rosen, Black & Dean LLP 816 Partner/Lawyer n   2014-06-04 250 250      
18773 18773 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   OXIaRTgvfJr6 IND Willis Amy   Oakland CA 94612 International Longshore and Warehouse Union 4142 Researcher/International Organizer n   2014-06-04 100 100      
18774 18774 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   YK5NEho2TArS IND Alterman Ronald   Oakland CA 94618 Global Technology Solutions Group/International Business Machines Corporation 4143 Consultant n   2014-06-05 150 150      
18775 18775 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   ald5XSPJKc6k OTH Realtor Christina, Inc.     Redwood City CA 94063     n   2014-06-06 150 150      
18776 18776 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   T4oayKpiOBkk IND Jaicks Agar   San Francisco CA 94117 Retired 124 Retired n   2014-06-09 200 200      
18777 18777 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   9hcmkVP9kbwc IND Horne Nina   Oakland CA 94610 Public Insight 4144 Policy Consulting n   2014-06-25 100 100      
18778 18778 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-07-31 2014-01-01 2014-06-30   IFP9i38VqGs6 IND Bair Jonathan   Oakland CA 94612 Circlepoint 1808 Senior Associate, Strategic Communications n   2014-06-29 100 100      
2803 2803 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   BNKBkb52ROuw COM Dan Kalb for City Council 2012     Oakland CA 94612     n   2013-11-09 200 200   82.0  
2804 2804 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   OdnzPxWL3lVj IND Flashman Stuart   Oakland CA 94618 Law Offices of Stuart Flashman 314 Attorney n   2013-11-25 300 300      
2805 2805 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   iLvfR8G5uUO2 IND Anderson Tim   Oakland CA 94609 F T I Consulting, Inc. 821 Consultant n   2013-11-27 700 700      
2806 2806 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   R9rsFq2qOmpq IND Bliss John   Oakland CA 94618 SCI Consulting Group 822 Engineer n   2013-11-29 500 500      
2807 2807 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   XSnMzcjVc3tU COM Bay Area Citizens PAC     Oakland CA 94612-1427     n   2013-12-09 700 700   83.0  
2808 2808 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   8kUUcBnApOPm IND Cox Janet   Oakland CA 94611 Association of Bay Area Governments 823 Communications n   2013-12-09 100 100      
2809 2809 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   tbMLMZPqv3q4 IND McPherson Wendy   Oakland CA 94607 The Sunnyside Cafe 824 Owner n   2013-12-09 699 699      
2810 2810 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   gh3FO7owswoJ OTH Rena Rickles Attorney at Law     Oakland CA 94612     n   2013-12-09 100 100      
2811 2811 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   vwnsbCNkkuYI IND Shireman Bob   Berkeley CA 94707 Community Initiatives 825 Executive Director, California Competes n   2013-12-09 125 125      
2812 2812 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   ok7e7SBUkrvy IND Koteen Earl   Berkeley CA 94709 Unitarian Universalist Legislative Ministry California 826 Minister n   2013-12-12 100 100      
2813 2813 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   gzbR9ksx67TG IND Raich Robert   Oakland CA 94619 Self 228 Attorney n   2013-12-16 500 500      
2814 2814 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   U4LD3yrFL9yt COM Service Employees International Union Local 1021     Santa Rosa CA 95401     n   2013-12-17 700 700   39.0  
2815 2815 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   ob2NS2Z3Wwc6 IND Cornu-Toney Sharon   Oakland CA 94619 Opportunity Partners 827 Chief Strategy Officer n   2013-12-18 100 100      
2816 2816 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   GhpHONa4tpVE COM INTERNATIONAL FEDERATION OF PROFESSIONAL AND TECHNICAL ENGINEERS     San Francisco CA 94102     n   2013-12-23 500 500   31.0  
2817 2817 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   TTR6DuBFKG6V COM DRIVE Committee     WASHINGTON DC 20001     n   2013-12-31 500 500   41.0  
2818 2818 1361954 51 Dan Kalb City Council Officeholder Committee 44 2014-01-31 2013-07-01 2013-12-31   GLlLl8Xagfsv COM SIKH PAC     Concord CA 94518-2331     n   2013-12-31 1300 1300   84.0  

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