monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

36 rows where filer_name = 136 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, 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
31569 31569 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A438 OTH ACTION NOW INITIATIVE     HOUSTON TX 77056     n   2016-10-24 500000 1075000      
31570 31570 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A455 IND Apaydin Janan   Oakland CA 94602 Oakland USD 5339 Teacher n   2016-11-16 100 100      
31571 31571 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A442 OTH AUSINHEILER PHYSICAL THERAPY AND PERSONAL TRAINING PC     OAKLAND CA 94611     n   2016-10-24 500 600      
31572 31572 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A445 IND Caplan Julia   Oakland CA 94609 Public Health Institute 2009 Project Lead n   2016-10-24 100 100      
31573 31573 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A447 IND DIMOCK MICHAEL   SANTA ROSA CA 95401 PUBLIC HEALTH INSTITUTE 5340 PROJECT DIRECTOR n   2016-10-24 125 450      
31574 31574 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A446 IND DIMOCK MICHAEL   SANTA ROSA CA 95401 PUBLIC HEALTH INSTITUTE 5340 PROJECT DIRECTOR n   2016-10-24 125 450      
31575 31575 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A454 IND Dones Alan   Oakland CA 94610 Strategic Urban Development Alliance 5341 Managing Partner n   2016-10-31 500 500      
31576 31576 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A456 IND Hamlin Barbara   Oakland CA 94618 N.A. 1255 Retired n   2016-11-16 100 100      
31577 31577 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A439 IND Higgins Thomas J.   Oakland CA 94612 N.A. 1255 Retired n   2016-10-24 1000 1000      
31578 31578 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A444 IND HUGHES DANA   OAKLAND CA 94611 UNIVERSITY OF CALIFORNIA SAN FRANCISCO 5342 PROFESSOR n   2016-10-24 250 500      
31579 31579 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A441 IND Khaira Kamaljeet   Carmichael CA 95608 Independent 2998 Senior Consultant n   2016-10-24 500 500      
31580 31580 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A451 IND Lans Alan   Oakland CA 94609 N.A. 1255 Retired n   2016-11-03 1000 1000      
31581 31581 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A443 IND Madsen Kristine   Larkspur CA 94939 University California Berkeley 5343 Professor n   2016-10-24 250 250      
31582 31582 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A448 IND Marsom Matthew   Davis CA 95616 Public Health Institute 2009 Vice President for Policy & Programs n   2016-10-24 200 200      
31583 31583 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2017-01-30 2016-10-23 2016-12-31 2016-11-08 A463 COM Yes on Proposition V San Franciscans United to Reduce Diabetes in Children by Imposing 1 Cent Sales Tax on Distribution of Sugary Drinks with Major Funding by Michael Bloomberg & Action Now Iniative     Sacramento CA 95814     n   2016-12-09 200000 200214.72   426.0  
32550 32550 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A397 OTH ACTION NOW INITIATIVE     HOUSTON TX 77056     n   2016-09-28 500000 575000      
32551 32551 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A416 OTH AMERICAN HEART ASSOCIATION INC.     DALLAS TX 75231     n   2016-10-12 10000 15000      
32552 32552 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A419 IND Andrews Bret   Oakland CA 94602 Kaiser Permanente 137 Physican n   2016-10-13 250 250      
32553 32553 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A399 OTH California Dental Association     Oakland CA 94612     n   2016-10-03 5000 33750      
32554 32554 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A414 COM Wilma Chan for Senate 2016     Alameda CA 94501     n   2016-10-04 1000 1000   433.0  
32555 32555 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A435 IND Cowan Richard   Oakland CA 94619 N.A. 1255 Retired n   2016-10-20 100 100      
32556 32556 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A404 IND Dennis Elissa   Oakland CA 94602 Community Economics 4441 Affordable Housing Consultant n   2016-09-27 100 100      
32557 32557 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A427 IND Glupczynski Deborah   Oakland CA 94610 Kaiser Permanente 137 Physician n   2016-10-09 250 250      
32558 32558 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A417 OTH Healthplus Shared Services     Sacramento CA 95814     n   2016-10-12 2500 2500      
32559 32559 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A415 COM International Federation of Professional and Technical Engineers Local 21 Issues PAC     San Francisco CA 94103     n   2016-10-12 3000 3000   251.0  
32560 32560 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A391 OTH Kiwi Pediatrics Medical Group Inc.     Berkeley CA 94703     n   2016-09-26 250 250      
32561 32561 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A406 IND Matthiessen Nancy   Oakland CA 94608 UCSF Medical Center 696 Registered Dietitian Nutritionist n   2016-10-02 100 100      
32562 32562 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A434 IND Mudge Anne   Oakland CA 94611 Cox Castle & Nicholson 5459 Attorney n   2016-10-19 200 200      
32563 32563 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A407 COM OAKLAND POLICE OFFICERS ASSOCIATION POLITICAL ACTION COMMITTEE     Oakland CA 94618     n   2016-10-04 5000 5000   222.0  
32564 32564 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A424 IND Perkins Philip   Albany CA 94706 Philip Perkins Artist 5460 Artist n   2016-10-11 900 900      
32565 32565 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A430 IND Pyatok Michael   Oakland CA 94612 Pyatok Architects Inc. 5461 Architect n   2016-10-04 50 150      
32566 32566 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A426 IND Rose Andrew   Oakland CA 94602 JFCS East Bay 5462 Executive Director n   2016-10-09 100 100      
32567 32567 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A410 COM Sheet Metal Workers' International Association Local No. 104 Issues Account     San Ramon CA 94583     n   2016-10-06 3500 3500   418.0  
32568 32568 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A436 IND Spencer Robert   Oakland CA 94618 Urban Economics 2003 Economist n   2016-10-20 250 250      
32569 32569 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A392 IND Stricklin Marguerite   Oakland CA 94605 California Department of Justice 863 Deputy Attorney General n   2016-09-26 100 100      
32570 32570 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 2016-10-27 2016-09-25 2016-10-22 2016-11-08 A409 IND Taylor Kathryn   Oakland CA 94612 Beneficial State Bank 5463 Co-Founder/Co-CEO n   2016-10-06 25000 25000      

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