monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

7 rows where filer_id = 76 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, state, 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
13106 13106 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2015-02-01 2014-10-19 2014-12-31   INC26 OTH DRIVE Committee (FEC #C00032979)     Washington DC 20001     n   2014-10-22 5000 5000      
15119 15119 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2014-10-20 2014-10-01 2014-10-18 2014-11-04 INC6 COM California Teamsters Public Affairs Council, Public Affairs     Sacramento CA 95814     n   2014-10-01 5000 5000   89.0  
15120 15120 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2014-10-20 2014-10-01 2014-10-18 2014-11-04 INC9 COM International Association of Heat and Frost Insulators and Allied Workers Local 16, AFL-CIO     Benicia CA 94510     n   2014-10-06 500 500   273.0  
15121 15121 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2014-10-20 2014-10-01 2014-10-18 2014-11-04 INC8 SCC International Brotherhood of Electrical Workers Local 595 PAC     Dublin CA 94568     n   2014-10-03 2000 2000   63.0  
15122 15122 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2014-10-20 2014-10-01 2014-10-18 2014-11-04 INC10 COM Sheet Metal Workers' International Association Local No. 104     San Ramon CA 94583     n   2014-10-08 1500 1500   81.0  
15123 15123 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2014-10-20 2014-10-01 2014-10-18 2014-11-04 INC20 COM Steamfitters Local 342 Political Action Committee     Concord CA 94518     n   2014-10-09 1300 1300   37.0  
16497 16497 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2014-10-06 2014-01-01 2014-09-30 2014-11-04 INC3 COM International Association of Firefighters Local 55 PAC     Oakland CA 94612     n   2014-09-24 10000 10000   59.0  

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