monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

65 rows where filer_id = 42 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, 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
32277 32277 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2016-10-27 2016-09-25 2016-10-22 2016-11-08 FhtC7S1ybA1D IND Kernighan Patricia   Oakland CA 94610 City of Oakland 8 Councilmember n   2016-10-10 500 500      
13627 13627 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2015-01-31 2014-07-01 2014-12-31   ExQSJXRKwdkl IND McGee Otis Mr. Oakland CA 94619 City of Oakland 8 Attorney n   2014-09-12 500 500      
4853 4853 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   5T8WgzTs4IFZ IND Katz Alex   Oakland CA 94608 Oakland City Attorney's Office 1514 Chief of Staff n   2013-01-29 350 700      
4854 4854 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   EaoeuY4azkk9 IND Morodomi Mark   Oakland CA 94603 City of Oakland 8 Supervising Attorney n   2013-01-31 700 700      
4855 4855 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   1lNrrUqbLD4e IND Deluca Niccolo   Sacramento CA 95818 Townsend & Associates 1515 Lobbyist n   2013-02-22 500 500      
4856 4856 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   b2TjXRKgDqFI IND Hudson-Harmon Yvonne   Oakland CA 94619 Oakland City Attorney's Office 1514 Administrator n   2013-02-22 200 450      
4857 4857 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   l3OYCZvcGli3 IND Lee Heather   Walnut Creek CA 94595 Oakland City Attorney's Office 1514 Attorney n   2013-02-22 350 600      
4858 4858 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   FzRmbWYIqLFF OTH East Bay Rental Housing Association PAC     Oakland CA 94618     n   2013-05-13 500 500      
4859 4859 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   qwkwZ4YzgRpi IND Nishioka Krisida   Oakland CA 94619 Retired 124 Attorney n   2013-05-15 700 700      
4860 4860 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   qz9lCEcQJhDE IND Nishioka Wayne   Oakland CA 94619 Self Employed 90 Attorney n   2013-05-15 700 700      
4861 4861 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   iEnfkLGcWTEo IND Nye Bruce   Oakland CA 94618 Adams Nye 1516 Attorney n   2013-05-15 250 250      
4862 4862 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   2Gbg37IpDJ9z IND Altemus Dan   Oakland CA 94610 Self Employed 90 Arbitrator n   2013-05-16 250 250      
4863 4863 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   Z3tYLrZq3DXc IND Bodzin Robert   San Francisco CA 94114 Burnham Brown 168 Attorney n   2013-05-22 250 250      
4864 4864 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   2yidm1jmcmuX IND Thompson Anthony   Oakland CA 94612 Summit Bank 1517 Vice President n   2013-05-23 125 125      
4865 4865 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   rc1lAmAX85O5 OTH Colliers International     Clayton CA 94517     n   2013-05-24 250 250      
4866 4866 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   udb5RIfvlJvA OTH California Nurses Association PAC     Sacramento CA 95814     n   2013-05-28 700 700      
4867 4867 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   OtraihfZpqm3 IND Morgan Bert   Martinez CA 94553 unknown 1518 unknown n   2013-05-28 150 150      
4868 4868 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   xIbCPalJFQXB IND Garrison Paul   Oakland CA 94610 Self Employed 90 Attorney n   2013-05-29 100 100      
4869 4869 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   rEjeJqBHtQq4 IND Gibson Clare   Oakland CA 94611 Jarvis Fay Doporto & Gibson 1519 Attorney n   2013-05-29 250 250      
4870 4870 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   Ylj9jxnbEccE OTH Arias Cathy   Oakland   94602 Burnham Brown 168 Attorney n   2013-05-30 250 250      
4871 4871 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   Zua888p5lbc9 IND Fay Benjamin   Oakland CA 94611 Jarvis Fay Doporto & Gibson 1519 Attorney n   2013-05-30 250 250      
4872 4872 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   iQeUf3Wwpwly OTH Recology INC.     San Francisco CA 94111     n   2013-05-30 700 700      
4873 4873 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   UzB61qtyBOjs OTH The Clorox Company     Oakland CA 94623     n   2013-05-30 500 500      
4874 4874 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   SuQhAAXZLfmh IND Tinley Patricia   Lafayette CA 94549 unknown 1518 unknown n   2013-05-30 250 250      
4875 4875 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   UvHgwO6AMixw OTH A & B Vehicle Processing, INC.     Oakland CA 94621     n   2013-05-31 700 700      
4876 4876 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   N8v6IvacwdAt IND Alexander David   Oakland CA 94612 Hanson Bridgett 835 Attorney n   2013-05-31 250 250      
4877 4877 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   bw7fuyiguMXY IND Anderson Tamsen   San Francisco CA 94118 Holland & Knight 612 Attorney n   2013-05-31 250 250      
4878 4878 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   LTohtcThyugE IND Bloch Susan   Oakland CA 94610 Burke Williams 1520 Attorney n   2013-05-31 100 100      
4879 4879 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   vkvfFkF7O4Fc IND Caleo Paul   Oakland CA 94611 Burnham Brown 168 Attorney n   2013-05-31 250 250      
4880 4880 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   ZpYwhW7kHX2v IND Cutmore Mark   Berkeley CA 94703 Kaiser Permanente 137 Clinical Social Worker n   2013-05-31 700 700      
4881 4881 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   TT7FIjA8gd8e IND Epstein Barry   Oakland CA 94602 Fitzgerald Abbott 1521 Attorney n   2013-05-31 300 300      
4882 4882 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   cu8yf1mcVs1C IND Fuller Margurite   Oakland CA 94601 Retired 124 Retired n   2013-05-31 100 100      
4883 4883 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   b2vZFNMuZ8Pz IND Hall Randolph   El Sobrante CA 94803 Oakland City Attorney's Office 1514 Attorney n   2013-05-31 200 200      
4884 4884 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   XLeZ1dqEmG2C IND Hamlin Earl   Oakland CA 94618 Retired 124 Retired n   2013-05-31 700 700      
4885 4885 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   ABD683sMFwAu IND Hernandez Jennifer   Berkeley CA 94707 Holland & Knight 612 Attorney n   2013-05-31 500 500      
4886 4886 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   6HMY6CP7di22 IND Hughes Roger   Walnut Creek CA 94597 Wendel Rosen 1093 Attorney n   2013-05-31 500 500      
4887 4887 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   YhSLfdewWXFz IND Illgen Richard   Albany CA 94706 Oakland City Attorney's Office 1514 Attorney n   2013-05-31 250 250      
4888 4888 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   buTcPcYpn2fr IND Jackson Scott   Oakland CA 94619 Fitzgerald Abbott & Beardsley 242 Attorney n   2013-05-31 250 250      
4889 4889 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   SLYEUdk8h52K IND Jain Kiran   Berkeley CA 94707 Oakland City Attorney's Office 1514 Attorney n   2013-05-31 400 400      
4890 4890 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   nIGv337k8HrB IND Lake Elizabeth   Oakland CA 94611 Holland & Knight 612 Attorney n   2013-05-31 250 250      
4891 4891 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   8ylWRp94bwbS IND Lee David   Pleasant Hill CA 94523 Fitzgerald Abbott & Beardsley 242 Attorney n   2013-05-31 250 250      
4892 4892 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   HaQwpWeciIGX IND Lee Heather   Walnut Creek CA 94595 Oakland City Attorney's Office 1514 Attorney n   2013-05-31 250 600      
4893 4893 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   ilQBAOqQI9U8 IND Nasca Laura   Oakland CA 94606 California Commercial and Investment Group 1522 Assistant n   2013-05-31 500 500      
4894 4894 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   wZUg5yjQJWFo IND Nicholas Helen   Oakland CA 94611 Alain Pinel 1523 Realtor n   2013-05-31 250 250      
4895 4895 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   6PWHXnQ8kv99 IND Pearlman Lise   Oakland CA 94610 Retired 124 Attorney n   2013-05-31 250 250      
4896 4896 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   4uP8Npz2wEAA IND Schaaf Libby   Oakland CA 94602 Oakland City Council 1524 Council Member n   2013-05-31 250 250      
4897 4897 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   qofswgv5jRkE IND Schoenberger Charles   Alamo CA 94507 Self Employed 90 Photographer n   2013-05-31 200 200      
4898 4898 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   4YkI88xUw7nI IND Siegel Kevin   San Francisco CA 94114 Burke Williams 1520 Attorney n   2013-05-31 300 300      
4899 4899 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   CyUoAHWKKZWX IND Skinner Trinette   Oakley CA 94561 City of Oakland 8 Analyst n   2013-05-31 250 250      
4900 4900 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   XNA2pRF4QCzW OTH Turbo Auto Body, Inc.     Oakland CA 94606     n   2013-05-31 500 500      
4901 4901 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   NZz6ZDGlv6sP IND Valdez- Schoenberger Lupe   Alamo CA 94507 State of California 422 District Director n   2013-05-31 250 250      
4902 4902 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   s2UubVZkoQp9 IND Verber John   Danville CA 94506 Burnham Brown 168 Attorney n   2013-05-31 500 500      
4903 4903 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   1ZcOKoZjYeJa IND Wan Danny   Oakland CA 94601 Port of Oakland 421 Attorney n   2013-05-31 700 700      
4904 4904 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   oih2yU7M24tW IND Ward Michael   El Cerrito CA 94530 Fitzgerald Abbott & Beardsley 242 Attorney n   2013-05-31 250 250      
4905 4905 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   fQKfBoKA7re6 IND Sarapochillo Joseph   Oakland CA 94617 Sarco Construction 122 Contractor n   2013-06-01 350 350      
4906 4906 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   x7x4kIpJi7Vc OTH Foster Employment Law     Oakland CA 94610     n   2013-06-03 500 500      
4907 4907 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   552FoLuE8rrk OTH PMACC - DBA Harborside Health Center     Oakland CA 94606     n   2013-06-03 700 700      
4908 4908 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   zXCHyJCcrycz IND Skinner David   Moraga CA 94556 Meyers Nave 116 Attorney n   2013-06-04 200 200      
4909 4909 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   bLpZXq6QzQ28 OTH Wareham Development Corporation     San Rafael CA 94901     n   2013-06-04 700 700      
4910 4910 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   aikbKYfVCDfU IND Williams Jayne   San Francisco CA 94117 Meyers Nave 116 Attorney n   2013-06-05 250 250      
4911 4911 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   UfWtwfgH7SHE IND Hartinger Arthur   Oakland CA 94607 Meyers Nave 116 Attorney n   2013-06-06 250 250      
4912 4912 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   l4QSRpsnWgnj IND Hudson-Harmon Yvonne   Oakland CA 94619 Oakland City Attorney's Office 1514 Administrator n   2013-06-06 250 450      
4913 4913 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   QgUHXM9lnmOZ IND Katz Alex   Oakland CA 94608 Oakland City Attorney's Office 1514 Chief of Staff n   2013-06-06 350 700      
4914 4914 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   4tJsT5bdnzqh OTH International Association of Firefighters, Local 55 - Political Action Committee     Oakland CA 94612     n   2013-06-10 1400 1400      
4915 4915 1352921 42 Barbara Parker City Attorney Officeholder Account 20 2013-07-30 2013-01-01 2013-06-30   yE5lrgmoZC7N OTH Teamsters National D.R.I.V.E Political Fund Committee     Washington DC 20001     n   2013-06-27 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");