monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

43 rows where filer_id = 12 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, first_name, city, state, zipcode, employer, occupation, transaction_date, transaction_amt, year_to_date, committee_id, 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
593 593 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 MuNARNgCdJER IND Grube Peter   Oakland CA 94602 Self 228 Business Owner n   2012-07-01 500 700      
594 594 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 fCjD6jfbE1Yq OTH Gilbraith Kathleen       95472     n   2012-07-12 200 200      
595 595 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 fikuOsfPXAdP IND Norris Elizabeth   Oakland CA 94619 Self 228 Business Owner n   2012-07-29 250 500      
596 596 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 BcFuItVTcYjj COM UA Local 342 PAC Fund     Concord CA 94518     n   2012-08-23 500 500   37.0  
597 597 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 Wncius6GREiw IND Carey Zachary   Oakland CA 94611 True Vine Baptist Church 229 Pastor n   2012-08-28 125 125      
598 598 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 4n3BQJyjU6Ud IND Lankford Raymond   Emeryville CA 94608 Voices of Hope 230 Pastor n   2012-08-28 250 250      
599 599 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 BxTOFQRJGtQZ IND Norris Elizabeth   Oakland CA 94619 Self 228 Business Owner n   2012-08-29 250 500      
600 600 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 dqDK5bMBIQod COM Oakland First PAC #1342882     Oakland CA 94610     n   2012-08-31 250 250   27.0  
601 601 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 6ujWqpGz5XAD COM Political Action Committee of CCAA     San Francisco CA 94108     n   2012-08-31 200 200   38.0  
602 602 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 1PwsHDxiUJI6 OTH International Association of Firefighters Local 55     Oakland CA 94612     n   2012-09-03 700 700      
603 603 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 EJ7NF5SEf9x1 IND Davis Regina   Oakland CA 94612     n   2012-09-05 100 100      
604 604 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 4uzrdW3h7yoY IND Dewitt Nyeisha   Oakland CA 94609     n   2012-09-05 32 19032      
605 605 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 VQZEIIOnoXkf IND Jelks Alton   Oakland CA 94602 CSU East Bay 231 Lecturer n   2012-09-05 200 200      
606 606 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 V6Di9IvZib1F IND Johnson Charles   Oakland CA 94619 YLE Solutions 232 CEO n   2012-09-05 100 100      
607 607 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 YXfJklW8IxH3 IND Jordan Frederick   San Francisco CA 94115 FE Jordan Associates Inc 233 President and Chairman n   2012-09-05 200 200      
608 608 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SxMGivF3HFkI IND Mayfiled-Lynch Kimberly   Oakland CA 94605     n   2012-09-05 250 250      
609 609 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 ECdVUNIW2mRc IND Reynolds Chantal   Hercules CA 94547     n   2012-09-05 50 650      
610 610 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 RK6y17tgVBTf IND Simpson Darryl   Oakland CA 94607     n   2012-09-05 100 100      
611 611 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 cYnGs7Kl5YZS OTH The Red Door Catering     Emeryville CA 94608     n   2012-09-05 100 100      
612 612 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 fUxGGBG5vnGW IND Wanzo Benjamin   San Leandro CA 94578 Self 228 Business Owner n   2012-09-05 250 250      
613 613 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 FAbCjT92LhlB IND Huang Xian   Oakland CA 94607     n   2012-09-06 100 100      
614 614 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 kafrNryGkgTq IND Cravanas Delisa   Allen TX 75002 Chase 234 Negotiator n   2012-09-07 175 425      
615 615 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 m8p4FchcE852 IND Cravanas Delisa   Allen TX 75002 Chase 234 Negotiator n   2012-09-15 50 425      
616 616 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 STxxmALw9HXc IND Grube Peter   Oakland CA 94602 Self 228 Business Owner n   2012-09-22 200 700      
617 617 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 TrPSHT5zlmew COM Electrical Workers Local 595 PAC     Dublin CA 94568     n   2012-09-27 700 700   38.0  
618 618 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 gsD3SVQyDICO COM Service Employees International Union Local 1021     Sacramento CA 95814     n   2012-09-27 1300 1300   39.0  
619 619 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 yfujVJ9dDbUw IND Reynolds Chantal   Hercules CA 94547     n   2012-09-28 600 650      
620 620 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 bZaDPETCEyXi IND Delane Michael   San Francisco CA 94107 SF Fire 235 Firefighter n   2012-09-29 100 100      
621 621 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 h4Rd41xKjUyT IND Gonzales Mark   San Francisco CA 94110 SF Fire 235 Firefighter n   2012-09-29 100 100      
622 622 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 sYSxXaQqH1vK IND Jones Laniece   Oakland CA 94605 Self 228 Business Owner n   2012-09-29 660 660      
623 623 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 mWw3MOTBGuAY IND Cravanas Delisa   Allen TX 75002 Chase 234 Negotiator n   2012-09-30 200 425      
624 624 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 IcsSPB6CmHV7 IND Lacy Emmanuel   Oakland CA 94621 Self 228 Entertainment n   2012-09-30 700 700      
625 625 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 npaupTOn75It IND Stanley Pamela   Castro Valley CA 94552     n   2012-10-05 100 100      
626 626 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 GOL4YgEQVFvU IND Epstein Kathryn   Oakland CA 94606     n   2012-10-07 200 200      
627 627 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 ehdX9cJ1vvwd COM United Food & Commercial Workers Local 5 PAC     San Jose CA 95113     n   2012-10-09 250 250   40.0  
628 628 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 xYUYKiPfV6zV IND Hames Charley   Oakland CA 94609 BeBee Memorial Church 236 Pastor n   2012-10-10 100 100      
629 629 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 brWDVvtpol2k IND Vizinau Dexter   Oakland CA 94612 Self 228 Business Owner n   2012-10-12 225 225      
630 630 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SF3dVbfgStYl IND Neidhardt Lynette   Oakland CA 94619     n   2012-10-18 230 230      
631 631 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 aNJlABKXLHhw COM Drive Committee     Washington DC 20001     n   2012-10-24 400 400   41.0  
632 632 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 PwCrKUB1hVRS COM Political Action Together Political Committee     Hanover MD 21076     n   2012-10-25 1000 1000   42.0  
633 633 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 4tPc5IqHE5tM COM San Francisco Police Officers Association PAC     Sacramento CA 95814     n   2012-10-26 250 250   43.0  
634 634 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 Mxgv3KfuhSlQ COM Skinner for Assembly 2012     Sacramento CA 95815     n   2012-10-29 500 500   44.0  
635 635 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 2013-01-31 2012-07-01 2012-12-31 2012-11-06 6qy1pnpJSdss IND Ash Wil   Oakland CA 94610 Self 228 Business Owner n   2012-11-05 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");