monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

51 rows where filer_name = 5 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_type, 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
673 673 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 INC304 IND Auerbach Carol   Orinda CA 94563   Not Employed n   2012-10-23 700 700      
674 674 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 INC283 IND Dalziel Bruce   Oakland CA 94618   Retired n   2012-11-04 100 100      
675 675 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 PAY325 IND Raphael Leonard   Oakland CA 94618 Raphael & Associates 9 Certified Public Accountant n F 2012-12-31 2000 41764.96      
676 676 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 PAY324 IND Raphael Leonard   Oakland CA 94618 Raphael & Associates 9 Certified Public Accountant n F 2012-12-31 300 41764.96      
677 677 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 PAY326 IND Raphael Leonard   Oakland CA 94618 Raphael & Associates 9 Certified Public Accountant n F 2012-12-31 2400 41764.96      
678 678 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 PAY330 IND Raphael Leonard   Oakland CA 94618 Raphael & Associates 9 Certified Public Accountant n F 2012-12-31 13000 41764.96      
679 679 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 PAY323 IND Raphael Leonard   Oakland CA 94618 Raphael & Associates 9 Certified Public Accountant n F 2012-12-31 300 41764.96      
680 680 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 PAY322 IND Raphael Leonard   Oakland CA 94618 Raphael & Associates 9 Certified Public Accountant n F 2012-12-31 100 41764.96      
681 681 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 PAY329 IND Raphael Leonard   Oakland CA 94618 Raphael & Associates 9 Certified Public Accountant n F 2012-12-31 11200 41764.96      
682 682 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 PAY327 IND Raphael Leonard   Oakland CA 94618 Raphael & Associates 9 Certified Public Accountant n F 2012-12-31 2500 41764.96      
683 683 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 PAY328 IND Raphael Leonard   Oakland CA 94618 Raphael & Associates 9 Certified Public Accountant n F 2012-12-31 6000 41764.96      
684 684 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 INC180 IND Sanchez Laura   Oakland CA 94611 Self Employed 90 Consultant - Hotel Industry n   2012-10-23 100 250      
685 685 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 INC282 IND Winter Janet   Oakland CA 94618 Evil Empire, Inc. 256 Principal n   2012-11-01 100 100      
686 686 1350016 5 Len Raphael for City Council 2012 5 2013-01-31 2012-10-21 2012-12-31 2012-11-06 EXP318 IND Woodward Frank John   Oakland CA 94618 Bank of America 257 Software Technician n R 2012-12-31 -100 0 Contribution reported in error.    
1265 1265 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC117 IND Bhatia Vivek   Oakland CA 94618 California Physicians Service 366 Management Consulting n   2012-10-02 150 150      
1266 1266 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC141 IND Blecker Matthew   Oakland CA 94609 Google 367 Systems Engineer n   2012-10-14 100 150      
1267 1267 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC128 OTH Brignole & Ghiri Insurance and Real Estate Service, Inc.     Oakland CA 94609     n   2012-10-09 500 500      
1268 1268 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC130 IND Calit Vicki   Oakland CA 94606   Retired n   2012-10-10 700 700      
1269 1269 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC163 IND Downs Yale   Moraga CA 94556   Retired n   2012-10-16 100 100      
1270 1270 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC120 IND Gibb Evelyn   Oakland CA 94605 Self Employed 90 Accountant n   2012-10-08 700 700      
1271 1271 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC129 OTH Jeffrey J. Lee & Company, Certified Public Accountant     Oakland CA 94609     n   2012-10-09 300 300      
1272 1272 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC162 IND Kirschenbaum Debra   Oakland CA 94611 Self Employed 90 Real Estate Consultant n   2012-10-15 100 100      
1273 1273 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC119 IND Lowrey Donald   Oakland CA 94609   Unemployed n   2012-10-07 100 100      
1274 1274 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC122 IND Maguire John   Oakland CA 94619 Dr. John Maguire, DDS 368 Dentist n   2012-10-08 250 250      
1275 1275 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC139 IND McNeil Wong Laurel   Oakland CA 94601   Retired n   2012-10-11 100 200      
1276 1276 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC140 IND McNeil Wong Laurel   Oakland CA 94601   Retired n   2012-10-13 100 200      
1277 1277 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC121 IND Nace Ted   San Francisco CA 94110 Self Employed 90 Writer n   2012-10-08 100 100      
1278 1278 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC165 IND Reed Randy   Oakland CA 94609 Security Central, Inc. 369 Manager n   2012-10-19 250 250      
1279 1279 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC118 IND Urban Gregory   Berkeley CA 94705 Life Technologies 370 Technical Writer n   2012-10-07 500 500      
1280 1280 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC138 IND Whalen Daniel   Oakland CA 94618 The Whalen Foundation 371 President n   2012-10-10 700 700      
1281 1281 1350016 5 Len Raphael for City Council 2012 5 2012-10-25 2012-10-01 2012-10-20 2012-11-06 INC135 IND Zuckerman Barry   Oakland CA 94610 Adax, Inc. 372 Manager n   2012-10-11 700 700      
1396 1396 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC32 IND Brokstein Annise   Oakland CA 94611 Brokstein & Rosen CPAs 393 Accountant n   2012-09-13 250 250      
1397 1397 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC56 IND Bruckmann David   Oakland CA 94609 TC Transcontinental 394 Planning Navigator n   2012-09-15 250 250      
1398 1398 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC37 IND Godfrey Deborah   Scottsdale AZ 85262   Retired n   2012-09-17 100 100      
1399 1399 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC100 IND Hertz Gerald   Oakland CA 94619   Retired n   2012-09-27 500 500      
1400 1400 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC23 IND Keinon Irwin   Orinda CA 94563   Retired n   2012-08-23 250 250      
1401 1401 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC18 IND Kennedy Sydney   Berkeley CA 94704   Retired n   2012-08-30 500 500      
1402 1402 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC22 IND Law Scott   Oakland CA 94611   Not Employed n   2012-08-25 100 300      
1403 1403 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC55 IND Law Scott   Oakland CA 94611   Not Employed n   2012-09-18 200 300      
1404 1404 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC43 IND Lawson Nathaniel   Oakland CA 94611 Root Labs 395 Engineer n   2012-09-18 600 600      
1405 1405 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC38 IND Melland Cathryn   Oakland CA 94619 Michael P. Melland, CPA 396 Certified Public Accountant n   2012-09-17 100 100      
1406 1406 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC20 IND Ott Kenneth   Newark CA 94560 Self-Employed 14 Campaign Consultant n   2012-08-27 300 300      
1407 1407 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC86 IND Purcell Michael   Oakland CA 94618 Valla & Associates 397 Attorney n   2012-09-20 100 100      
1408 1408 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC19 IND Raphael Leonard   Oakland CA 94618 Raphael & Associates 9 Certified Public Accountant n   2012-08-29 1 21364.96      
1409 1409 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC44 IND Sanchez Laura   Oakland CA 94611   Retired n   2012-09-18 150 150      
1410 1410 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC57 IND Schaadt Phillip   Oakland CA 94610 Haddon Hill Group 398 President/CEO n   2012-09-15 250 250      
1411 1411 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC103 IND Valery Kanevsky   Evanston IL 60202 Allstate Insurance 399 Futurist n   2012-09-30 250 250      
1412 1412 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC17 IND Wasserman Andrew   Piedmont CA 94611 Lucien & Co 400 Senior Manager n   2012-09-04 250 250      
1413 1413 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC99 IND Wiles Robert   San Francisco CA 94116   Not Employed n   2012-09-20 100 100      
1414 1414 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC113 IND Woodward Frank John   Oakland CA 94618 Bank of America 257 Software Technician n   2012-09-30 100 100      
1415 1415 1350016 5 Len Raphael for City Council 2012 5 2012-10-03 2012-01-01 2012-09-30 2012-11-06 INC16 IND Yee Ron   Berkeley CA 94708 Ron Yee CPA 401 Certified Public Accountant n   2012-09-05 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");