monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

63 rows where filer_name = 117 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, 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
34506 34506 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC27 IND RUDDELL DONALD   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-04-06 250 250      
34507 34507 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC40 IND BURG NORMAN   OAKLAND CA 94618 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-04-25 100 100      
34508 34508 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC41 IND FRANZ LARRY   OAKLAND CA 94612 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-04-25 100 100      
34509 34509 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC42 IND LAGOS JOANNE   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-04-25 100 550      
34510 34510 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC45 IND DANIELS JOSHUA   BERKELEY CA 94702 BERKELEY UNIFIED SCHOOL DISTRICT 5669 SCHOOL BOARD MEMBER n   2016-05-04 100 100      
34511 34511 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC62 IND GREAVES JOSEPH   OAKLAND CA 94609 ALAMEDA-CONTRA COSTA MEDICAL ASSOCIATION 5670 ASSISTANT EXECUTIVE DIRECTOR n   2016-05-07 250 250      
34512 34512 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC65 IND RITTERMAN JEFF   RICHMOND CA 94801 TUORO UNIVERSITY 5671 PROFESSOR n   2016-05-14 100 100      
34513 34513 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC68 IND SILVER LYNN   BERKELEY CA 94707 PUBLIC HEALTH INSTITUTE 5340 PHYSICIAN n   2016-05-14 80 360      
34514 34514 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC61 IND AGAZZI MICHELLE   OAKLAND CA 94609 OAKLAND ORTHODONTICS 5672 ORTHODONTIST n   2016-05-25 100 100      
34515 34515 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC50 IND ALEXANDER VICKI   OAKLAND CA 94619 NONE 2832 RETIRED n   2016-05-25 100 350      
34516 34516 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC58 OTH CORAZON B. MANALOTO, D.D.S., INC.     ALAMEDA CA 94501     n   2016-05-25 100 100      
34517 34517 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC57 IND CUROTTO RICHARD J.   OAKLAND CA 94609 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-05-25 100 100      
34518 34518 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC55 IND DEAN MARY JANE   OAKLAND CA 94612 NONE 2832 RETIRED n   2016-05-25 200 200      
34519 34519 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC54 IND LUM KRISTEN   OAKLAND CA 94607 CHILDREN'S HOSPITAL OF OAKLAND 5673 PHYSICIAN n   2016-05-25 100 100      
34520 34520 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC51 IND RENNER RONA   BERKELEY CA 94704 SELF EMPLOYED/SAME NAME 2860 NURSE/PARENTING COACH n   2016-05-25 100 150      
34521 34521 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC59 OTH SHARON L. ALBRIGHT, D.D.S., INC.     OAKLAND CA 94609     n   2016-05-25 500 500      
34522 34522 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC56 IND WONG SAM   OAKLAND CA 94612 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-05-25 100 100      
34523 34523 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC71 OTH ALAMEDA PEDIATRIC DENTISTRY     ALAMEDA CA 94501     n   2016-05-26 500 500      
34524 34524 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC85 OTH FINN H. TONSBERG D.D.S., INC.     ALAMEDA CA 94501     n   2016-05-26 250 250      
34525 34525 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC73 OTH JASBIR S. BEDI, D.D.S. FAMILY DENTISTRY     OAKLAND CA 94609     n   2016-05-26 100 100      
34526 34526 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC76 IND LAGOS JOANNE   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-05-26 200 550      
34527 34527 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC70 IND LEONG AMANDA   ALAMEDA CA 94501 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-05-26 200 200      
34528 34528 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC77 OTH MARINA LANDING DENTISTRY     ALAMEDA CA 94501     n   2016-05-26 100 100      
34529 34529 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC80 IND SOLARZ NORMA   OAKLAND CA 94618 NONE 2832 RETIRED n   2016-05-26 100 100      
34530 34530 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC79 OTH WENDY P LIAO DDS, INC.     ALAMEDA CA 94501     n   2016-05-26 200 200      
34531 34531 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC74 IND BOTHWELL BRUCE   ALAMEDA CA 94501 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-05-31 150 150      
34532 34532 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC75 IND CARTER MARIANELA M.   OAKLAND CA 94609 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-05-31 100 100      
34533 34533 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC81 OTH JEFFREY P. ALEXANDER DDS, A DENTAL CORPORATION     OAKLAND CA 94621     n   2016-05-31 500 500      
34534 34534 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC72 OTH PETERSON-CHAN DENTAL GROUP     OAKLAND CA 94616     n   2016-05-31 100 100      
34535 34535 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC89 IND KWAN JOHN   OAKLAND CA 94609 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-06-01 500 500      
34536 34536 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC90 IND SZETO MARIANNE   OAKLAND CA 94610 SAN FRANCISCO DEPARTMENT OF PUBLIC HEALTH 5674 COMMUNITY HEALTH EDUCATOR n   2016-06-06 100 100      
34537 34537 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC102 OTH DANIEL V. LEWIS, D.D.S., A PROFESSIONAL CORPORATION     OAKLAND CA 94602     n   2016-06-13 100 100      
34538 34538 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC103 IND TSEGAY LULA   SAN LEANDRO CA 94577 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-06-14 250 250      
34539 34539 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC156 IND OBRINSKY DIANA   OAKLAND CA 94611 SELF EMPLOYED/SAME NAME 2860 PEDIATRICIAN n   2016-06-17 100 100      
34540 34540 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC157 IND PASTENA CHRIS   OAKLAND CA 94607 CHOP BAR 5675 OWNER/OPERATOR n   2016-06-18 100 100      
34541 34541 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC158 IND GERBER ED   OAKLAND CA 94611 NONE 2832 RETIRED n   2016-06-20 100 100      
34542 34542 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC161 IND RENNER RONA   BERKELEY CA 94704 SELF EMPLOYED/SAME NAME 2860 NURSE/PARENTING COACH n   2016-06-20 50 150      
34543 34543 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC162 IND BOURQUE MARTIN   BERKELEY CA 94707 ECOLOGY CENTER 5676 EXECUTIVE DIRECTOR n   2016-06-21 100 100      
34544 34544 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC104 IND CRAGO MELISSA   OAKLAND CA 94619 SELF EMPLOYED/SAME NAME 2860 CHIROPRACTOR n   2016-06-21 250 250      
34545 34545 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC163 IND LUBIN BERTRAM   BERKELEY CA 94705 CHILDREN'S HOSPITAL OAKLAND 2818 PRESIDENT & CHEIF EXECUTIVE OFFICER n   2016-06-21 500 500      
34546 34546 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC164 IND LINZER JULIETTE   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2860 MANAGEMENT CONSULTANT n   2016-06-23 100 100      
34547 34547 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC165 IND LAGOS JOANNE   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-06-24 250 550      
34548 34548 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC107 IND SILVER LYNN   BERKELEY CA 94707 PUBLIC HEALTH INSTITUTE 5340 PHYSICIAN n   2016-06-24 80 360      
34549 34549 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC166 IND FLYNN RACHEL   OAKLAND CA 94606 CITY OF OAKLAND 2854 DIRECTOR, PLANNING AND BUILDING DEPARTMENT n   2016-06-25 100 100      
34550 34550 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC109 OTH AUSINHEILER PHYSICAL THERAPY AND PERSONAL TRAINING, PC     OAKLAND CA 94611     n   2016-06-27 100 100      
34551 34551 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC172 IND ESPEJO EILEEN   ALAMEDA CA 94501 CHILDREN NOW 5543 SENIOR MANAGING DIRECTOR n   2016-06-27 100 100      
34552 34552 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC181 IND LUNA JESSICA   OAKLAND CA 94603 ST. ROSE HOSPITAL 5677 NURSE n   2016-06-28 100 100      
34553 34553 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC113 IND ALEXANDER VICKI   OAKLAND CA 94619 NONE 2832 RETIRED n   2016-06-29 250 350      
34554 34554 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC112 OTH AMERICAN HEART ASSOCIATION, INC.     DALLAS TX 75231     n   2016-06-29 5000 5000      
34555 34555 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC114 IND DICKSON CHARLOTTE   BERKELEY CA 94705 PUBLIC HEALTH ADVOCATES 5678 SOCIAL WORKER n   2016-06-29 100 100      
34556 34556 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC115 IND DIMOCK MICHAEL   SANTA ROSA CA 95401 PUBLIC HEALTH INSTITUTE 5340 PROJECT DIRECTOR n   2016-06-29 200 200      
34557 34557 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC116 IND FUJII DARLENE   ALAMEDA CA 94502 COUNTY OF ALAMEDA 5679 PUBLIC HEALTH ADMINISTRATOR n   2016-06-29 250 250      
34558 34558 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC120 COM ALAMEDA-CONTRA COSTA PHYSICIAN'S COMMITTEE     OAKLAND CA 94618     n   2016-06-30 250 250   437.0  
34559 34559 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC189 IND CAPITELLI LAURIE   BERKELEY CA 94703 CITY OF BERKELEY 5680 COUNCILMEMBER n   2016-06-30 200 200      
34560 34560 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC187 IND GUSHONEY KATHLEEN   OAKLAND CA 94612 YMCA FOR THE EAST BAY 5681 NONPROFIT ADMINSTRATION n   2016-06-30 250 250      
34561 34561 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC190 IND HUGHES DANA   OAKLAND CA 94611 UNIVERSITY OF CALIFORNIA SAN FRANCISCO 5342 PROFESSOR n   2016-06-30 250 250      
34562 34562 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC192 IND KAPLAN REBECCA   OAKLAND CA 94608 CITY OF OAKLAND 2854 COUNCILMEMBER n   2016-06-30 180 180      
34563 34563 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-08-01 2016-04-01 2016-06-30   INC188 IND VANDUREN LAURA   OAKLAND CA 94611 NONE 2832 STUDENT n   2016-06-30 100 100      
35798 35798 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-05-02 2016-01-01 2016-03-31   INC11 IND FINE JARED   OAKLAND CA 94611 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-01-29 250 250      
35799 35799 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-05-02 2016-01-01 2016-03-31   INC10 IND JALEN DAVID K.   ALAMEDA CA 94502 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-01-29 250 250      
35800 35800 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-05-02 2016-01-01 2016-03-31   INC12 IND JOHNSON DAVID W.   ALAMEDA CA 94501 ORTHODONTICS FOR CHILDREN & ADULTS 5885 DENTIST n   2016-01-29 500 500      
35801 35801 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-05-02 2016-01-01 2016-03-31   INC13 IND LE HUONG   DANVILLE CA 94506 SELF EMPLOYED/SAME NAME 2860 DENTIST n   2016-01-29 100 100      
35802 35802 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 117 2016-05-02 2016-01-01 2016-03-31   INC21 IND SILVER LYNN   BERKELEY CA 94707 PUBLIC HEALTH INSTITUTE 5340 PHYSICIAN n   2016-03-23 200 200      

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