monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

21 rows where filer_name = 125 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, city, zipcode, occupation, transaction_date, transaction_amt, year_to_date, committee_id, report_date (date), report_start_date (date), report_end_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
35439 35439 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2016-07-26 2016-01-01 2016-06-30   INC93 COM International Association of Firefighter Local 55 Political Action     Oakland CA 94612     n   2016-06-30 700 700   59.0  
35440 35440 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2016-07-26 2016-01-01 2016-06-30   INC86 SCC Service Employees International Union Local 1021 Candidate PAC - Small Contributor Committee     Sacramento CA 95814     n   2016-01-21 1400 1400   39.0  
22881 22881 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2016-01-19 2015-07-01 2015-12-31   INC81 IND Fergusson Kelly Jean   Menlo Park CA 94025 OpTerra Energy 4615 Clean Energy Executive n   2015-12-14 150 150      
22882 22882 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2016-01-19 2015-07-01 2015-12-31   INC78 SCC International Brotherhood of Electrical Workers Local 595 Small Contributor Committee PAC     Dublin CA 94568     n   2015-11-30 1400 1400   63.0  
22883 22883 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2016-01-19 2015-07-01 2015-12-31   INC68 COM Sheet Metal Workers' International Association Local Union 104 PAC     San Ramon CA 94583     n   2015-08-27 1400 1400   81.0  
22884 22884 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2016-01-19 2015-07-01 2015-12-31   INC82 IND Spencer Patricia V.   Alameda CA 94501 City of Alameda 196 Mayor n   2015-12-14 100 100      
27841 27841 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC33 IND Behan Michael   San Francisco CA 94110 Behan Construction 4666 Principal n   2015-01-28 700 700      
27842 27842 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC46 COM California Metals Coalition PAC     El Dorado Hills CA 95762     n   2015-02-09 250 250   232.0  
27843 27843 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC36 IND Doyle Siobhan   San Francisco CA 94118 Danny Coyle's 4667 Owner n   2015-01-28 700 700      
27844 27844 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC48 OTH Floor Sure Interiors     Oakland CA 94605     n   2015-03-04 700 700      
27845 27845 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC41 IND Grace Daniel   San Leandro CA 94577 Grace & Co., Inc. 2361 Nurseryman n   2015-02-23 250 250      
27846 27846 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC34 IND Kaufman Martin   San Anselmo CA 94960 Agramed 4668 Office Manager n   2015-01-28 500 500      
27847 27847 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC47 IND Lawson Maurice B.   Oakland CA 94602   Retired n   2015-03-04 700 700      
27848 27848 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC40 IND Neal Kathy   Oakland CA 94611 Kathy Neal 3129 Consultant n   2015-02-06 200 200      
27849 27849 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC37 IND O'Sullivan Fergus   San Francisco CA 94117 Sullivan Properties 4669 Investor n   2015-01-28 700 700      
27850 27850 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC29 IND Ramirez Maria   Hayward CA 94544 San Leandro Braces 984 Office Manager n   2015-01-06 700 700      
27851 27851 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC32 OTH Schnitzer Steel Industries     Oakland CA 94607     n   2015-01-28 700 700      
27852 27852 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC49 SCC Service Employees International Union Local 1021 Candidate PAC - Small Contributor Committee     Sacramento CA 95814     n   2015-03-04 1400 1400   39.0  
27853 27853 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC35 OTH SK Builders     Oakland CA 94612     n   2015-01-28 500 500      
27854 27854 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC42 COM U.A. Local 342 PAC Fund     Concord CA 94518     n   2015-06-30 700 700   37.0  
27855 27855 1374343 114 Councilmember Rebecca Kaplan 2012 Officeholder Committee 125 2015-07-27 2015-01-01 2015-06-30   INC38 IND Walker Ross   Los Angeles CA 90049 Hawkins Way Capital 4670 Real Estate n   2015-02-06 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");