monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

55 rows where filer_id = 102 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, prefix, city, state, zipcode, employer, occupation, 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
55385 55385 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   gd39In548GBl IND Bennett Edward Mr. Oakland CA 94605   Retired n   2019-01-14 -400 -400      
55386 55386 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   g7HhNtGlRucr IND DeBoni Tom   Fort Meyers FL 33908   Retired n   2019-01-14 -200 -200      
55387 55387 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   QKy3En21nUMR IND Hanson James Mr. Richmond CA 94805 Caltrans 3366 Landscape Architect n   2019-01-14 -200 -200      
55388 55388 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   lFgEN2oce8Bz IND Kim Caroline Ms. Oakland CA 94610   Retired n   2019-01-14 -300 -300      
55389 55389 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   4kVu5rKMWzWc IND Malone Ruth Ms. San Francisco CA 94123 UCSF School of Nursing 3369 Professor & Chairperson, Dept. of Behavioral Sciences n   2019-01-14 -1000 -1000      
55390 55390 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   UkLQJTfvNUaX IND Marburg Sandra   Oakland CA 94619   Retired n   2019-01-14 -250 -250      
55391 55391 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   6uP4nLZDMITn IND Perez Fernando Mr. Oakland CA 94619 Laurence Berkeley Lab 3372 Staff Scientist n   2019-01-14 -500 -500      
55392 55392 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   vhIqYzF2f5nQ IND Ross Victor   Oakland CA 94605   Retired n   2019-01-14 -500 -500      
55393 55393 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   hTfCI26O835g IND Shansab Maryam   Oakland CA 94605 University of CA SF 3375 Post-Doctorate Fellow n   2019-01-14 -501.9 -501.9      
55394 55394 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   HavXkKrMbo4K IND Sugg Sylvia   Oakland CA 94605   retired n   2019-01-14 -500 -500      
55395 55395 1374249 102 Save Knowland Park Referendum Committee 105 2019-07-29 2019-01-01 2019-06-30   Or2fXuCAHeNU IND Yellis Stephanie   Oakland CA 94619   Retired n   2019-01-14 -250 -250      
28369 28369 1374249 102 Save Knowland Park Referendum Committee 105 2015-07-26 2015-01-01 2015-06-30   2LB9yXKTxeCA IND Kezar Donald Mr. Oakland CA 94605 PG&E 214 Distribution Engineer n   2015-01-01 250 250      
28370 28370 1374249 102 Save Knowland Park Referendum Committee 105 2015-07-26 2015-01-01 2015-06-30   joq37xbNiobR IND Stephenson Janet   Oakland CA 94605 San Ramon Medical Center 3376 Registered Nurse n   2015-01-01 250 250      
28371 28371 1374249 102 Save Knowland Park Referendum Committee 105 2015-07-26 2015-01-01 2015-06-30   46RgtxUcFPsD IND Keever Megan Ms. Oakland CA 94618 Stillwater Science 4677 Botanist n   2015-01-03 100 100      
28372 28372 1374249 102 Save Knowland Park Referendum Committee 105 2015-07-26 2015-01-01 2015-06-30   hzBKShPfcjGV IND Meyers Robert Mr. Oakland CA 94611 Retired 122 Architect n   2015-01-03 100 100      
28373 28373 1374249 102 Save Knowland Park Referendum Committee 105 2015-07-26 2015-01-01 2015-06-30   YvdoXnKS9hAK IND Ronner Jeffrey Mr. Oakland CA 94618 Dignity Health 1772 IT Director n   2015-01-04 250 250      
28374 28374 1374249 102 Save Knowland Park Referendum Committee 105 2015-07-26 2015-01-01 2015-06-30   EfC9z9OqbuGc IND Anderson Scott   Oakland CA 94602 The PETA Foundation 3362 Senior VP n   2015-01-05 400 400      
28375 28375 1374249 102 Save Knowland Park Referendum Committee 105 2015-07-26 2015-01-01 2015-06-30   WlqG7vG5zXoS IND Contributions Unitemized   Line 2   1267 FPPC Instructions 4678 Contributions under $100 n   2015-01-05 460 460      
28376 28376 1374249 102 Save Knowland Park Referendum Committee 105 2015-07-26 2015-01-01 2015-06-30   e2EvTX2u87Dp IND Garr Greg Mr. San Francisco CA 94127 Retired 122 Retired n   2015-01-05 100 100      
28377 28377 1374249 102 Save Knowland Park Referendum Committee 105 2015-07-26 2015-01-01 2015-06-30   cDFFZOkdPeqL IND McNeill William Mr. Oakland CA 94605 Legal Aid Society 4447 Dir. of Racial Equality n   2015-01-05 500 500      
11326 11326 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   uiC7oBlMy7dp IND Anderson Scott   Oakland CA 94602 The PETA Foundation 3362 Senior VP n   2014-12-29 1100 1100      
11327 11327 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   37UbkSap3HfD IND Bennett Edward Mr. Oakland CA 94605   Retired n   2014-12-14 400 400      
11328 11328 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   v9qfPCI7R1kA IND Bennett Katherine   San Leandro CA 94577 Realware 3363 Financial Manager n   2014-12-28 100 100      
11329 11329 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   yRjAwdfnelcu IND Brodersen Robert   Berkeley CA 94705   Retired n   2014-12-20 200 200      
11330 11330 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   PO2qv1pGHXRM IND Cwynar Judith   Oakland CA 94605   Retired n   2014-12-30 100 100      
11331 11331 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   qVauCJYCrZiI IND DeBoni Tom   Fort Meyers FL 33908   Retired n   2014-12-15 200 200      
11332 11332 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   5BNpDIeqFr5v IND Dorsey M.   Oakland CA 94605 Oakland Veterinary Hospital 3364 Veterinarian n   2014-12-22 500 500      
11333 11333 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   mRtArl3vh76h IND Farmer Marshall   San Jose CA 95136 Sight Machine 3365 Lead Devops Engineer n   2014-12-19 500 500      
11334 11334 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   ZNXrK2WAeJtj IND Gross Lynda   San Leandro CA 94577 UC Berkeley 124 Computer Programmer n   2014-12-17 400 400      
11335 11335 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   CCErfm4J8SeD IND Hanson James Mr. Richmond CA 94805 Caltrans 3366 Landscape Architect n   2014-12-15 200 200      
11336 11336 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   x95URZwgBu5q IND Hazenfield Carol   Oakland CA 94602 Self 226 Communication Coach n   2014-12-27 100 100      
11337 11337 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   tV1upUbJFUIq IND Kim Caroline Ms. Oakland CA 94610   Retired n   2014-12-15 300 300      
11338 11338 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   C4xPliFbFiv2 IND King Thelda   Oakland CA 94605 L.P. Trucking Inc. 3367 CEO n   2014-12-16 300 300      
11339 11339 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   eKlVLlO49QZA IND Levin Sue   Oakland CA 94610 WWWomen, Inc 3368 Business Owner n   2014-12-19 250 250      
11340 11340 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   kfCNlxjLWXWc IND Malone Ruth Ms. San Francisco CA 94123 UCSF School of Nursing 3369 Professor & Chairperson, Dept. of Behavioral Sciences n   2014-12-14 1000 1000      
11341 11341 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   rs5DgLcYupCJ IND Marburg Sandra   Oakland CA 94619   Retired n   2014-12-15 250 250      
11342 11342 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   eaqPc6wx8BbG IND McCray Darlene   Oakland CA 94605 Cooper Zietz Engineers Inc. 3370 Project Manager n   2014-12-22 500 500      
11343 11343 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   8qwJPPmmVoi5 IND McLeod Cynthia   Oakland CA 94605 E & E Inc 3371 Environmental consultant n   2014-12-21 100 100      
11344 11344 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   ndUewCftyKjT IND Meyer Colton   Somerset CA 95684   Retired n   2014-12-19 200 200      
11345 11345 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   ATEbssEuDy2s IND Nelson Robert   Canyon CA 94577 Self 226 Mechanical Engineer n   2014-12-16 100 100      
11346 11346 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   iEqSWPf4l8QA IND Perez Fernando Mr. Oakland CA 94619 Laurence Berkeley Lab 3372 Staff Scientist n   2014-12-15 500 500      
11347 11347 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   LOWpNOdjzFi5 IND Pilch Nick   Albany CA 94706 Bluescape LCC 3373 Software Director n   2014-12-18 100 100      
11348 11348 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   njjuerO6gANj IND Pitman Laurie   Berkeley CA 94705   Retired n   2014-12-18 100 100      
11349 11349 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   lmqgaacvOKOv IND Reyes Laura   Oakland CA 94605 Hobart 3374 National Account Mgr. n   2014-12-20 250 250      
11350 11350 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   5veS9f4QTqyI IND Ross Victor   Oakland CA 94605   Retired n   2014-12-15 500 500      
11351 11351 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   TQFewf8Zwo3x IND Shansab Maryam   Oakland CA 94605 University of CA SF 3375 Post-Doctorate Fellow n   2014-12-15 600 600      
11352 11352 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   kgP92Y7p1rJa IND Smith Karen   Berkeley CA 94705   Retired n   2014-12-16 500 500      
11353 11353 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   G9cgpFX6t4Z9 IND Stephenson Janet   Oakland CA 94605 San Ramon Medical Center 3376 Registered Nurse n   2014-12-27 150 150      
11354 11354 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   bmy66lgbCxS2 IND Stokestad Robert   Berkeley CA 94708   Retired n   2014-12-18 100 100      
11355 11355 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   RzoRSIGHtbWI IND Sugg Sylvia   Oakland CA 94605   retired n   2014-12-15 500 500      
11356 11356 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   wx8rQCytJbuI IND Sykora Sylvia   Oakland CA 94611   Retired n   2014-12-22 250 250      
11357 11357 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   risfDLYHZ525 IND Truxler Joseph   Cave Rock NV 89448   Retired n   2014-12-22 200 200      
11358 11358 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   5hdzlc7mUIPQ IND West Roy   Berkeley CA 94708 Google, Inc. 2425 Writer n   2014-12-18 150 150      
11359 11359 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   R3GBLrlqqmVA IND Whiteside Catherine   Oakland CA 94609   Retired n   2014-12-28 600 600      
11360 11360 1374249 102 Save Knowland Park Referendum Committee 105 2015-02-03 2014-11-01 2014-12-31   oFq8NreT6292 IND Yellis Stephanie   Oakland CA 94619   Retired n   2014-12-15 250 250      

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