monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

44 rows where employer = 2856 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, filer_name, report_date, report_start_date, report_end_date, election_date, last_name, first_name, city, zipcode, occupation, 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
37730 37730 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2017-07-30 2017-01-01 2017-06-30   INC3068 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2017-01-19 50 300      
37751 37751 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2017-07-30 2017-01-01 2017-06-30   INC3089 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2017-02-19 50 300      
37775 37775 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2017-07-30 2017-01-01 2017-06-30   INC3118 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2017-03-19 50 300      
37795 37795 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2017-07-30 2017-01-01 2017-06-30   INC3140 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2017-04-19 50 300      
37815 37815 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2017-07-30 2017-01-01 2017-06-30   INC3167 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2017-05-19 50 300      
37835 37835 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2017-07-30 2017-01-01 2017-06-30   INC3189 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2017-06-19 50 300      
31518 31518 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2017-01-31 2016-10-23 2016-12-31   INC2967 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2016-11-19 50 1500      
31543 31543 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2017-01-31 2016-10-23 2016-12-31   INC3012 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2016-12-19 50 1500      
32235 32235 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2016-10-27 2016-09-25 2016-10-22 2016-11-08 INC2874 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2016-10-19 50 1400      
33232 33232 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC2738 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2016-09-19 50 1350      
33259 33259 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC2687 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2016-08-19 50 1350      
33295 33295 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC2600 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2016-07-29 750 1350      
33359 33359 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 144 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A348 IND MAA JOHN   SAN FRANCISCO CA 94109 SELF EMPLOYED/SAME NAME 2856 SURGEON n   2016-08-30 1500 1500      
33376 33376 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 144 2016-09-29 2016-07-01 2016-09-24 2016-11-08 A334 IND YOSHIDA DOUGLAS   OAKLAND CA 94618 SELF EMPLOYED/SAME NAME 2856 PHYSICIAN n   2016-08-22 100 100      
34506 34506 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC27 IND RUDDELL DONALD   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-04-06 250 250      
34507 34507 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC40 IND BURG NORMAN   OAKLAND CA 94618 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-04-25 100 100      
34508 34508 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC41 IND FRANZ LARRY   OAKLAND CA 94612 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-04-25 100 100      
34509 34509 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC42 IND LAGOS JOANNE   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-04-25 100 550      
34517 34517 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC57 IND CUROTTO RICHARD J.   OAKLAND CA 94609 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-05-25 100 100      
34520 34520 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC51 IND RENNER RONA   BERKELEY CA 94704 SELF EMPLOYED/SAME NAME 2856 NURSE/PARENTING COACH n   2016-05-25 100 150      
34522 34522 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC56 IND WONG SAM   OAKLAND CA 94612 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-05-25 100 100      
34526 34526 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC76 IND LAGOS JOANNE   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-05-26 200 550      
34527 34527 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC70 IND LEONG AMANDA   ALAMEDA CA 94501 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-05-26 200 200      
34531 34531 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC74 IND BOTHWELL BRUCE   ALAMEDA CA 94501 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-05-31 150 150      
34532 34532 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC75 IND CARTER MARIANELA M.   OAKLAND CA 94609 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-05-31 100 100      
34535 34535 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC89 IND KWAN JOHN   OAKLAND CA 94609 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-06-01 500 500      
34538 34538 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC103 IND TSEGAY LULA   SAN LEANDRO CA 94577 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-06-14 250 250      
34539 34539 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC156 IND OBRINSKY DIANA   OAKLAND CA 94611 SELF EMPLOYED/SAME NAME 2856 PEDIATRICIAN n   2016-06-17 100 100      
34542 34542 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC161 IND RENNER RONA   BERKELEY CA 94704 SELF EMPLOYED/SAME NAME 2856 NURSE/PARENTING COACH n   2016-06-20 50 150      
34544 34544 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC104 IND CRAGO MELISSA   OAKLAND CA 94619 SELF EMPLOYED/SAME NAME 2856 CHIROPRACTOR n   2016-06-21 250 250      
34546 34546 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC164 IND LINZER JULIETTE   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 MANAGEMENT CONSULTANT n   2016-06-23 100 100      
34547 34547 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-08-01 2016-04-01 2016-06-30   INC165 IND LAGOS JOANNE   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-06-24 250 550      
34714 34714 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2016-08-01 2016-01-01 2016-06-30   INC2274 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2016-03-16 250 500      
34859 34859 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2016-08-01 2016-01-01 2016-06-30   INC2486 IND ANDERSON JENNIFER   OAKLAND CA 94611 SELF EMPLOYED/SAME NAME 2856 CREATIVE DIRECTOR n   2016-06-20 100 100      
34893 34893 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2016-08-01 2016-01-01 2016-06-30   INC2570 IND ROE DAVID   OAKLAND CA 94610 SELF EMPLOYED/SAME NAME 2856 ATTORNEY/CONSULTANT n   2016-06-28 250 500      
34896 34896 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2016-08-01 2016-01-01 2016-06-30   INC2573 IND SCHORR JONATHAN   OAKLAND CA 94602 SELF EMPLOYED/SAME NAME 2856 COMMUNICATIONS CONSULTANT n   2016-06-28 250 250      
34946 34946 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 133 2016-08-01 2016-01-01 2016-06-30   INC2587 IND TOWNSEND AARON   OAKLAND CA 94602 SELF EMPLOYED/SAME NAME 2856 EDUCATOR n   2016-06-30 120 120      
35798 35798 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-05-02 2016-01-01 2016-03-31   INC11 IND FINE JARED   OAKLAND CA 94611 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-01-29 250 250      
35799 35799 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-05-02 2016-01-01 2016-03-31   INC10 IND JALEN DAVID K.   ALAMEDA CA 94502 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-01-29 250 250      
35801 35801 1381041 110 COALITION FOR HEALTHY OAKLAND CHILDREN 118 2016-05-02 2016-01-01 2016-03-31   INC13 IND LE HUONG   DANVILLE CA 94506 SELF EMPLOYED/SAME NAME 2856 DENTIST n   2016-01-29 100 100      
8953 8953 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2015-02-02 2014-07-01 2014-09-30 2014-11-04 INC972 IND WALROD STEPHEN   BERKELEY CA 94705 SELF EMPLOYED/SAME NAME 2856 PSYCHOLOGIST n   2014-09-11 100 350      
9088 9088 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2015-02-02 2014-07-01 2014-09-30 2014-11-04 INC1541 IND WALROD STEPHEN   BERKELEY CA 94705 SELF EMPLOYED/SAME NAME 2856 PSYCHOLOGIST n   2014-09-23 250 350     INC1541
16269 16269 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC972 IND WALROD STEPHEN   BERKELEY CA 94705 SELF EMPLOYED/SAME NAME 2856 PSYCHOLOGIST n   2014-09-11 100 350      
16406 16406 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC1541 IND WALROD STEPHEN   BERKELEY CA 94705 SELF EMPLOYED/SAME NAME 2856 PSYCHOLOGIST n   2014-09-23 250 350     INC1541

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