monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

45 rows where filer_id = 88 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, election_date, 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
11312 11312 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 gJp1USugMGeh IND Heldman James   Oakland CA 94610 N?A 3366 Retired n   2014-10-22 500 500      
11313 11313 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 uijdUW7Lx1fH IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-10-24 327 31623.69      
11314 11314 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 RWZg9AXHUqFc IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-10-26 205.65 31623.69      
11315 11315 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 dgWY2MevYMLx IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-10-29 534.45 31623.69      
11316 11316 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 iznHhGgLUVNM IND Weinstein Marvin   Brooklyn NY 11230 retired 411 retired n   2014-10-29 100 100      
11317 11317 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 rht5wpxDYGnD IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-10-30 25096.18 31623.69      
11318 11318 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 3CTbNLOHXlDl IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-11-03 400.56 31623.69      
11319 11319 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 kaC4vmAEzDym IND Clements Julia   Oakland CA 94618 self 543 math tutor n   2014-11-04 100 100      
11320 11320 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 CTEpNNNurM4Q IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-11-04 50 31623.69      
11321 11321 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 E6kgl7vdTRpx IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-11-04 478.21 31623.69      
11322 11322 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 3fktzLT18gnG IND Woodward Frank   Oakland CA 94618 BOA 3367 software tech n   2014-11-05 100 100      
11323 11323 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 ol6MnIWztEmI IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-11-25 39 31623.69      
11324 11324 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 sYfIiFlpgtSs IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-12-23 39 31623.69      
11325 11325 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2015-02-04 2014-10-19 2014-12-31 2014-11-04 SSoww4ARWjpQ IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-12-30 4397.06 31623.69      
14462 14462 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-23 2014-10-01 2014-10-18 2014-11-04 mWI3soWifWBr IND Alltizer Andrew   Danville CA 94506 Ernest and Young LLP 3676 CPA n   2014-10-01 500 500      
14463 14463 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-23 2014-10-01 2014-10-18 2014-11-04 jTd8WO4OHR2g IND Levy Hank   Berkeley CA 94618 The Henry Levy Group 3147 CPA n   2014-10-05 350 350      
14464 14464 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-23 2014-10-01 2014-10-18 2014-11-04 pEiuUQAtlsgn IND Raphael Len   Oakland CA 94618 Raphael & Associates 9 CPA n   2014-10-15 56.58 4856.72      
9694 9694 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 J4eZXuhCVAfK IND Ahmed Jamal   Oakland CA 94609 Jamal Ahmed 3064 Business owner n   2014-08-24 200 200      
9695 9695 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 V8AjioXuB7mC IND Arpi David   Piedmont CA 94610 MACH Energy 3065 Chief Financial Officer n   2014-09-18 300 300      
9696 9696 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 Bh3VVt4JIKqY IND Berne Edward   Oakland CA 94618 Michigan Chandelier Co 3066 Executive n   2014-09-17 100 100      
9697 9697 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 aAivMo7lxMgj IND Bruckmann David   Oakland CA 94609 Transcontinental Printing 3067 Manager n   2014-09-24 250 250      
9698 9698 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 9Q7cclvZx4ki IND Downes Yale   Moraga CA 94556 Retired 124 Retired n   2014-09-27 100 100      
9699 9699 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 lyjzgFiSpAAK IND Ferro Michael   Oakland CA 94619 Retired 124 Retired n   2014-08-10 700 700      
9700 9700 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 NJWqwyum7gN6 IND Ghielmetti Michael   Oakland CA 94612 Signature Development Group 1011 Company President n   2014-09-29 100 100      
9701 9701 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 NitcgclihSMG IND Kirschenbaum Debra   Oakland CA 94611     n   2014-09-24 100 100      
9702 9702 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 yJIsdpP5NydF IND Lawson Nathaniel   Oakland CA 94611 SourceDNA 3068 Engineer n   2014-09-30 700 700      
9703 9703 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 zC8QGfJTczUN IND Schulman Daniel   Oakland CA 94611 Viator 621 Marketer n   2014-08-27 200 200      
9704 9704 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 qWPFRrov4NeX IND Silver Alan   Oakland CA 94602 Kay and Markle, LLP 3069 Attorney n   2014-09-22 250 250      
9705 9705 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 sQmAijMrdf94 IND Takhar Neeta   Berkeley CA 94702 Neeta Takhar 3070 Small business owner n   2014-09-24 700 700      
9706 9706 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 9deadcLi4qx1 IND Thompson Susannah   New York NY 10019 RFCUNY 3071 Educator n   2014-09-19 150 150      
9707 9707 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-14 2014-07-01 2014-09-30 2014-11-04 PKuQ1Oo4fWEi IND Whalen Daniel   Oakland CA 94609   Retired n   2014-09-30 500 500      
15706 15706 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 lyjzgFiSpAAK IND Ferro Michael   Oakland CA 94619 Retired 124 Retired n   2014-08-10 700 700      
15707 15707 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 J4eZXuhCVAfK IND Ahmed Jamal   Oakland CA 94609 Self-employed 265 Business owner n   2014-08-24 200 200      
15708 15708 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 zC8QGfJTczUN IND Schulman Daniel   Oakland CA 94611 Viator 621 Marketer n   2014-08-27 200 200      
15709 15709 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 Bh3VVt4JIKqY IND Berne Edward   Oakland CA 94618 Michigan Chandelier Co 3066 Executive n   2014-09-17 100 100      
15710 15710 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 V8AjioXuB7mC IND Arpi David   Piedmont CA 94610 MACH Energy 3065 Chief Financial Officer n   2014-09-18 300 300      
15711 15711 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 9deadcLi4qx1 IND Thompson Susannah   New York NY 10019 RFCUNY 3071 Educator n   2014-09-19 150 150      
15712 15712 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 qWPFRrov4NeX IND Silver Alan   Oakland CA 94602 Kay and Markle, LLP 3069 Attorney n   2014-09-22 250 250      
15713 15713 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 aAivMo7lxMgj IND Bruckmann David   Oakland CA 94609 Transcontinental Printing 3067 Manager n   2014-09-24 250 250      
15714 15714 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 NitcgclihSMG IND Kirschenbaum Debra   Oakland CA 94611     n   2014-09-24 100 100      
15715 15715 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 sQmAijMrdf94 IND Takhar Neeta   Berkeley CA 94702 Self-employed 265 Small business owner n   2014-09-24 700 700      
15716 15716 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 9Q7cclvZx4ki IND Downes Yale   Moraga CA 94556 Retired 124 Retired n   2014-09-27 100 100      
15717 15717 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 NJWqwyum7gN6 IND Ghielmetti Michael   Oakland CA 94612 Signature Development Group 1011 Company President n   2014-09-29 100 100      
15718 15718 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 yJIsdpP5NydF IND Lawson Nathaniel   Oakland CA 94611 SourceDNA 3068 Engineer n   2014-09-30 700 700      
15719 15719 1369263 88 Len Raphael for Oakland City Auditor 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-06 PKuQ1Oo4fWEi IND Whalen Daniel   Oakland CA 94609   Retired n   2014-09-30 500 500      

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