FEC: Top PAC Donors to a Candidate

Largest PAC/committee contributors to a specific member of Congress.

Custom SQL query (hide) 

SELECT fc.cmte_id, fc.cmte_name, SUM(fc.transaction_amt) AS total, COUNT(*) AS contributions, MIN(fc.cycle) AS first_cycle, MAX(fc.cycle) AS last_cycle FROM fec_contributions fc JOIN fec_candidate_crosswalk xw ON xw.fec_candidate_id = fc.cand_id WHERE xw.bioguide_id = :bioguide_id GROUP BY fc.cmte_id ORDER BY total DESC LIMIT 50

Query parameters

Edit SQL

0 results