monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

40 rows where filer_name = 181 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, transaction_id, entity_type, last_name, 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
55462 55462 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2019-07-16 2019-01-01 2019-06-30   INC176 OTH ABC Security Service, Inc.     Oakland CA 94606     n   2019-04-19 750 750      
55463 55463 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2019-07-16 2019-01-01 2019-06-30   INC187 IND Batarse Anthony   Oakland CA 94603 Lloyd A. Wise, Co. 8792 Manager n   2019-06-29 750 750      
55464 55464 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2019-07-16 2019-01-01 2019-06-30   INC184 OTH HNTB Holdings Ltd. Federal PAC     Kansas City MO 64105     n   2019-06-18 250 250      
55465 55465 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2019-07-16 2019-01-01 2019-06-30   INC177 OTH Tidewater Group, LLC     Oakland CA 94606     n   2019-04-19 750 750      
55466 55466 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2019-07-16 2019-01-01 2019-06-30   INC167 IND Townsend Michele A.   Laguna Hills CA 92653 Kaiser Permanente 137 Health Educator n   2019-02-11 800 800      
55467 55467 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2019-07-16 2019-01-01 2019-06-30   INC173 IND Uriarte Keith   Oakland CA 94619   Retired n   2019-03-29 100 100      
50848 50848 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC143 OTH Aer Industries, Inc.     San Leandro CA 94577     n   2018-05-21 180 180      
50849 50849 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC144 IND Bobbitt Raymond L.   Alameda CA 94501 Raymond L. Bobbitt 8260 Consultant n   2018-05-21 180 180      
50850 50850 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC145 OTH Bush Street Pizza, Inc. dba Escape From New York Pizza     San Francisco CA 94104     n   2018-05-21 180 180      
50851 50851 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC132 IND Harris Elihu M.   Berkeley CA 94702 Elihu M. Harris 8261 Attorney n   2018-02-15 500 500      
50852 50852 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC128 COM International Association of FireFighters, Local 55 PAC     Oakland CA 94612     n   2018-01-23 1000 1000   59.0  
50853 50853 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC129 IND Janowitz Marc S.   Oakland CA 94605 East Bay Community Law Center 127 Attorney n   2018-01-31 250 250      
50854 50854 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC146 OTH Jump Frog, Inc. dba Nick's Crispy Tacos     Oakland CA 94610     n   2018-05-21 180 180      
50855 50855 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC137 COM Laborers' International Union of North America Local 73 PAC     Stockton CA 95215     n   2018-03-17 700 700   602.0  
50856 50856 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC138 SCC Laborers Local Union 270 PAC Small Contributor Committee     Sacramento CA 95814     n   2018-03-17 700 700   228.0  
50857 50857 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC147 OTH Lily Hu & Associates     Alameda CA 94501     n   2018-06-11 700 700      
50858 50858 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC133 SCC Northern California District Council of Laborers PAC Small Contributor Committee     Sacramento CA 95814     n   2018-02-13 700 700   230.0  
50859 50859 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC134 IND Quan Mon Kil   San Leandro CA 94577 ARDA, LLC 8262 Owner n   2018-02-22 700 700      
50860 50860 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC139 IND Reinhold Sue   Berkeley CA 94708 Jewish Community Federation 8263 Philanthropy Officer n   2018-03-17 700 700      
50861 50861 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-07-30 2018-01-01 2018-06-30   INC135 IND Siegel Daniel M.   Oakland CA 94605 Siegel, Yee and Brunner 8264 Attorney n   2018-03-02 800 800      
36833 36833 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-01-20 2017-07-01 2017-12-31   INC123 SCC Construction & General Laborers Local Union 304 PAC Small Contributor Committee     Sacramento CA 95814     n   2017-12-26 700 700   66.0  
36834 36834 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-01-20 2017-07-01 2017-12-31   INC122 OTH Lamumba, Inc. dba Geoffrey's Inner Circle     Oakland CA 94612     n   2017-12-15 250 250      
36835 36835 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-01-20 2017-07-01 2017-12-31   INC120 OTH Teranomic     Orangevale CA 95662     n   2017-12-15 700 700      
36836 36836 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-01-20 2017-07-01 2017-12-31   INC121 OTH The McConnell Group     Oakland CA 94612     n   2017-12-15 700 700      
35928 35928 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-01-15 2017-01-01 2017-06-30   INC103 SCC California Nurses Association PAC (CNA-PAC) Small Contributor Committee     Sacramento CA 95814     n   2017-03-14 500 500   95.0  
35929 35929 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-01-15 2017-01-01 2017-06-30   INC108 IND Clemens Alexander   San Francisco CA 94133 Lighthouse Public Affairs 5128 Public Affairs n   2017-03-22 250 250      
35930 35930 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-01-15 2017-01-01 2017-06-30   INC105 OTH Lily Hu & Associates     Alameda CA 94501     n   2017-04-06 700 700      
35931 35931 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-01-15 2017-01-01 2017-06-30   INC114 IND Rosin Pamela E.   Oakland CA 94608 Grateful Heart Holistic Therapy Center 5913 MFT Trainee n   2017-06-22 700 700      
35932 35932 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2018-01-15 2017-01-01 2017-06-30   INC104 SCC Service Employees International Union Local 1021 Candidate PAC - Small Contributor Committee     Sacramento CA 95814     n   2017-04-10 1380 1380   148.0  
35933 35933 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-12-13 2017-01-01 2017-06-30   INC103 SCC California Nurses Association PAC (CNA-PAC) Small Contributor Committee     Sacramento CA 95814     n   2017-03-14 500 500   95.0  
35934 35934 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-12-13 2017-01-01 2017-06-30   INC108 IND Clemens Alexander   San Francisco CA 94133 Lighthouse Public Affairs 5128 Public Affairs n   2017-03-22 250 250      
35935 35935 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-12-13 2017-01-01 2017-06-30   INC105 OTH Lily Hu & Associates     Alameda CA 94501     n   2017-04-06 700 700      
35936 35936 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-12-13 2017-01-01 2017-06-30   INC104 SCC Service Employees International Union Local 1021 Candidate PAC - Small Contributor Committee     Sacramento CA 95814     n   2017-04-10 1380 1380   148.0  
35937 35937 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-12-13 2017-01-01 2017-06-30   INC114 IND Rosin Pamela E.   Oakland CA 94608 Grateful Heart Holistic Therapy Center 5913 MFT Trainee n   2017-06-22 700 700      
37844 37844 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-07-24 2017-01-01 2017-06-30   INC103 SCC California Nurses Association PAC (CNA-PAC) Small Contributor Committee     Sacramento CA 95814     n   2017-03-14 500 500   95.0  
37845 37845 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-07-24 2017-01-01 2017-06-30   INC108 IND Clemens Alexander   San Francisco CA 94133 Lighthouse Public Affairs 5128 Public Affairs n   2017-03-22 250 250      
37846 37846 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-07-24 2017-01-01 2017-06-30   INC116 IND Dunbar Francesca   Alamo CA 94507 McWane, Inc./AB&I Foundry 6227 Director of Group Marketing n   2017-06-21 100 100      
37847 37847 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-07-24 2017-01-01 2017-06-30   INC105 OTH Lily Hu & Associates     Alameda CA 94501     n   2017-04-06 700 700      
37848 37848 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-07-24 2017-01-01 2017-06-30   INC114 IND Rosin Pamela E.   Oakland CA 94608 Awakening Presence 2423 Counselor n   2017-06-22 700 700      
37849 37849 1374343 114 Councilmember Rebecca Kaplan 2016 Officeholder Committee 181 2017-07-24 2017-01-01 2017-06-30   INC104 SCC Service Employees International Union Local 1021 Candidate PAC - Small Contributor Committee     Sacramento CA 95814     n   2017-04-10 1380 1380   148.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");