monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

29 rows where filer_id = 100 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, last_name, 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
52380 52380 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2018-07-20 2018-01-01 2018-06-30 2014-11-04 23TWMXuEeLpA IND Roberts Brenda   Oakland CA 94618 Accretive Solutions 3496 Consultant n   2018-06-30 2000 62000      
52381 52381 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2018-07-20 2018-01-01 2018-06-30 2014-11-04 JgMQSvZptm36 IND Roberts Brenda   Oakland CA 94618 Accretive Solutions 3496 Consultant n   2018-06-30 3000 62000      
52382 52382 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2018-07-20 2018-01-01 2018-06-30 2014-11-04 SsP3koEVCghX IND Roberts Brenda   Oakland CA 94618 Accretive Solutions 3496 Consultant n   2018-06-30 3000 62000      
52383 52383 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2018-07-20 2018-01-01 2018-06-30 2014-11-04 zHlu2vQpimWv IND Roberts Brenda   Oakland CA 94618 Accretive Solutions 3496 Consultant n   2018-06-30 6000 62000      
52384 52384 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2018-07-20 2018-01-01 2018-06-30 2014-11-04 dsWbmON7FCzi IND Roberts Brenda   Oakland CA 94618 Accretive Solutions 3496 Consultant n   2018-06-30 22000 62000      
52385 52385 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2018-07-20 2018-01-01 2018-06-30 2014-11-04 c7Xw1GZi7GWP IND Roberts Brenda   Oakland CA 94618 Accretive Solutions 3496 Consultant n   2018-06-30 6000 62000      
52386 52386 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2018-07-20 2018-01-01 2018-06-30 2014-11-04 EWtRdp1VaBR3 IND Roberts Brenda   Oakland CA 94618 Accretive Solutions 3496 Consultant n   2018-06-30 3000 62000      
52387 52387 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2018-07-20 2018-01-01 2018-06-30 2014-11-04 dhiF6cqh47Uk IND Roberts Brenda   Oakland CA 94618 Accretive Solutions 3496 Consultant n   2018-06-30 2000 62000      
52388 52388 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2018-07-20 2018-01-01 2018-06-30 2014-11-04 vQGLlxbUZ7qw IND Roberts Brenda   Oakland CA 94618 Accretive Solutions 3496 Consultant n   2018-06-30 15000 62000      
14316 14316 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2015-01-07 2014-10-19 2014-12-31 2014-11-04 RgDVEsRq3Ve2 IND Jairam Jay   Fremont CA 94539 Jairam & Associates 3644 Consultant n   2014-10-19 100 100      
14317 14317 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2015-01-07 2014-10-19 2014-12-31 2014-11-04 ZWi9tho3BhxZ IND Hickerson Carlos   Oakland CA 94610 Accrretive Solutions 3645 Consultant n   2014-10-21 200 700      
14318 14318 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2015-01-07 2014-10-19 2014-12-31 2014-11-04 FwjHQW3PfCl4 IND Lawrence Stephen   Vacaville CA 95687 U.S. Dept. Interior 3646 Auditor n   2014-10-24 100 200      
14319 14319 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2015-01-07 2014-10-19 2014-12-31 2014-11-04 Au5wTMCyZ5lY OTH National Women's Political Caucus     Oakland CA 94612     n   2014-10-28 250 250      
15463 15463 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-20 2014-10-01 2014-10-18 2014-11-04 lzK4YmhdJ654 IND Adams Shari   Oakland CA 94618-2619 City of San Francisco 159 Program Manager n   2014-10-01 100 100      
15464 15464 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-20 2014-10-01 2014-10-18 2014-11-04 sbtPURCJg3ff IND Weinman Todd   Oakland CA 94610 Self 228 Recruiter n   2014-10-09 100 100      
15465 15465 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-20 2014-10-01 2014-10-18 2014-11-04 aG4XFsbfFK49 IND Li Hui   Fremont CA 94539 Core-Mark Int'l., Inc. 3743 Accountant n   2014-10-10 100 100      
15466 15466 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-20 2014-10-01 2014-10-18 2014-11-04 mfkiPaXMEyV6 IND Schoenrock Mark   Alameda CA 94501 Core-Mark Int'l., Inc. 3743 Finance n   2014-10-10 250 250      
18011 18011 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 g1miZNLrLPmq IND Arnold Kathleen   Oakland CA 94605 AAA NCNU 3995 Internal Auditor n   2014-07-31 100 100      
18012 18012 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 V6NrCkSlwOqM IND Violet Lisa   Oakland CA 94611 Wells Fargo Bank 178 Director, Internal Audit n   2014-07-31 250 250      
18013 18013 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 372gWrlM21XD IND Hickerson Carlos   Oakland CA 94610 Accrretive Solutions 3645 Consultant n   2014-09-02 250 500      
18014 18014 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 dMxflGUp6yd6 IND Richardson Harriet   W. University Place WA 98467 City of Palo Alto 1718 City Auditor n   2014-09-07 250 250      
18015 18015 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 SPbEi1bjDtWf IND Lawrence Stephen   Vacaville CA 95687 U.S. Dept. Interior 3646 Auditor n   2014-09-16 100 100      
18016 18016 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 wOLNQfhqJ9T5 OTH Alameda FireFighters Assn., Local 689     Alameda CA 94501-2126     n   2014-09-24 500 500      
18017 18017 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 8F1CcwFKFwpz OTH Int'l Assn. of FireFighters, Local 55     Oakland CA 94612     n   2014-09-24 1400 1400      
18018 18018 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 12jVNzYNSGnG IND Hickerson Carlos   Oakland CA 94610 Accrretive Solutions 3645 Consultant n   2014-09-28 250 500      
18019 18019 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 G4IKT2MGRGzh IND Pickett Erika   Spring Creek NV 89815 Elko Co. School District 3996 Administrator n   2014-09-28 100 100      
18020 18020 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 XdnK6BG1el1M OTH Alameda Labor Council     Oakland CA 94618     n   2014-09-29 1000 1000      
18021 18021 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 wqZzx8qDbuTO OTH Oakland Police Officers' Assn.     Oakland CA 94607     n   2014-09-30 1400 1400      
18022 18022 136810 100 Brenda Roberts for Oakland City Auditor 2014 101 2014-10-01 2014-07-01 2014-09-30 2014-11-04 ckfeYCn5oAgY IND Ruparel Ramila   Pleasanton CA 94566 Auction.Com 3997 VP, Global Tax n   2014-09-30 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");