monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

39 rows where filer_name = 138 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, first_name, city, state, zipcode, employer, 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
33338 33338 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A285 OTH ACTION NOW INITIATIVE     HOUSTON TX 77056     n   2016-07-14 75000 75000      
33339 33339 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A327 IND AURICH LEE   OAKLAND CA 94612 N.A. 1255 RETIRED n   2016-07-19 250 250      
33340 33340 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A383 IND Bell James   San Francisco CA 94110 Burns Institute 5536 Attorney n   2016-09-18 100 100      
33341 33341 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A340 IND BIXBY KAREN   PIEDMONT CA 94611 N.A. 1255 RETIRED n   2016-08-23 200 200      
33342 33342 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A384 IND Block Randall   Alameda CA 94501 Sedgwick Law 5537 Attorney n   2016-09-18 150 150      
33343 33343 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A286 IND BLOOMBERG MICHAEL   NEW YORK NY 10022 BLOOMBERG LP 4685 EXECUTIVE n   2016-07-14 75000 1772962.5      
33344 33344 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A349 IND Boxer Amy   Oakland CA 94610 Pura Vida Design Group 5538 Business Owner n   2016-09-06 1000 1000      
33345 33345 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A364 IND Brevet-Stott Ericac   Oakland CA 94611 EBP Consulting Services Inc. 5539 Consultant n   2016-09-09 200 200      
33346 33346 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A388 IND Brevet Frits   Oakland CA 94618 Brevet & Associates Insurance Brokers 5540 Insurance Broker n   2016-09-18 100 100      
33347 33347 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A379 OTH Chase & Chase     Oakland CA 94607     n   2016-09-18 100 100      
33348 33348 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A365 IND Cohen David   Oakland CA 94610 David Cohen Consultant 5541 Consultant n   2016-09-09 100 125      
33349 33349 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A359 IND Cohen David   Oakland CA 94610 David Cohen Consultant 5541 Consultant n   2016-09-07 25 125      
33350 33350 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A355 IND Cooper Justin   San Francisco CA 94129 Orrick Herrington & Sutcliffe 5542 Attorney n   2016-09-01 1000 1000      
33351 33351 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A350 IND De Luca Niccolo   Sacramento CA 95818 Townsend Public Affairs 254 Advocate n   2016-09-06 1000 1000      
33352 33352 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A366 IND ESPEJO EILEEN   ALAMEDA CA 94501 CHILDREN NOW 5543 SENIOR MANAGING DIRECTOR n   2016-09-09 100 200      
33353 33353 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A387 IND Harcourt James   Oakland CA 94611 James Harcourt Contractor 5544 Contractor n   2016-09-18 100 100      
33354 33354 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A329 IND HARVEY ANN   OAKLAND CA 94609 CONTRA COSTA HEALTH SERVICES 5545 PHYSICIAN n   2016-07-28 100 100      
33355 33355 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A341 IND HOLT EDWARD   PIEDMONT CA 94610 SUTTER HEALTH 5546 PHYSICIAN n   2016-08-25 100 100      
33356 33356 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A358 COM John George Democratic Club     Oakland CA 94612     n   2016-09-19 250 250   436.0  
33357 33357 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A370 IND Karno Mitchell   Santa Barbara CA 93103 Mitchell Karno PhD 5547 Psychologist n   2016-09-14 250 250      
33358 33358 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A375 IND Lindheim Susan   Oakland CA 94607 Kaiser 140 Pediatrician n   2016-09-19 200 200      
33359 33359 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A348 IND MAA JOHN   SAN FRANCISCO CA 94109 SELF EMPLOYED/SAME NAME 2860 SURGEON n   2016-08-30 1500 1500      
33360 33360 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A354 IND MERYASH KAREN   BERKELEY CA 94705 N.A. 1255 RETIRED n   2016-09-18 1000 1500      
33361 33361 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A333 IND MERYASH KAREN   BERKELEY CA 94705 N.A. 1255 RETIRED n   2016-08-21 500 1500      
33362 33362 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A389 IND MEYERS ROBERT   OAKLAND CA 94611 ROBERT MEYERS ASSOCIATES 5548 ARCHITECT n   2016-09-02 50 225      
33363 33363 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A357 IND MEYERS ROBERT   OAKLAND CA 94611 ROBERT MEYERS ASSOCIATES 5548 ARCHITECT n   2016-09-16 100 225      
33364 33364 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A284 IND MEYERS ROBERT   OAKLAND CA 94611 ROBERT MEYERS ASSOCIATES 5548 ARCHITECT n   2016-07-05 75 225      
33365 33365 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A346 IND PENHOET EDWARD   SAN FRANCISCO CA 94111 ALTA PARTNERS 5549 DIRECTOR n   2016-08-30 1000 1000      
33366 33366 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A347 IND PERATA REBECCA   ALAMEDA CA 94501 VOX POPULI 5550 COMMUNICATIONS CONSULTANT n   2016-08-30 350 350      
33367 33367 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A376 IND Perry David   Alameda CA 94501 Alameda Pediatric Dentistry 5551 Pediatric Dentist n   2016-09-19 500 500      
33368 33368 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A380 IND Pies Cheri   Berkeley CA 94705 University of California Berkeley 5552 Professor n   2016-09-18 100 100      
33369 33369 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A363 IND Pyatok Michael   Oakland CA 94612 Pyatok Architects Inc. 5461 Architect n   2016-09-09 100 100      
33370 33370 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A325 IND RATLIFF JIM   OAKLAND CA 94610 FTI CONSULTING 5553 ECONOMIST n   2016-07-03 250 250      
33371 33371 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A343 IND SAPERSTEIN JEANINE   PIEDMONT CA 94611 N.A. 1255 RETIRED n   2016-08-29 5000 5000      
33372 33372 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A345 IND SILBERSTEIN STEPHEN   BELVEDERE CA 94920 N.A. 1255 RETIRED n   2016-08-30 3000 3000      
33373 33373 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A338 COM SKINNER FOR SENATE 2016     SACRAMENTO CA 95815     n   2016-08-23 500 500   218.0  
33374 33374 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A374 IND TERLET ARIANE   BERKELEY CA 94705 LA CLINICA DE LA RAZA 4118 DENTIST n   2016-09-19 200 250      
33375 33375 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A330 COM WELLSTONE DEMOCRATIC RENEWAL CLUB PAC     Oakland CA 94612     n   2016-07-28 250 250   282.0  
33376 33376 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A334 IND YOSHIDA DOUGLAS   OAKLAND CA 94618 SELF EMPLOYED/SAME NAME 2860 PHYSICIAN n   2016-08-22 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");