Member Profile: Trades, Speeches, Bills

Complete profile for a member of Congress — their stock trades, floor speeches, and sponsored bills. Enter a bioguide_id (e.g., G000386 for Chuck Grassley).

Custom SQL query (hide) 

SELECT cm.full_name, cm.party, cm.state, cm.chamber, cm.first_served, cm.last_served, (SELECT COUNT(*) FROM stock_trades WHERE bioguide_id = cm.bioguide_id) AS total_trades, (SELECT COUNT(*) FROM crec_speakers WHERE bioguide_id = cm.bioguide_id) AS total_speeches, (SELECT COUNT(*) FROM legislation WHERE sponsor_bioguide_id = cm.bioguide_id) AS bills_sponsored, (SELECT GROUP_CONCAT(DISTINCT ticker) FROM stock_trades WHERE bioguide_id = cm.bioguide_id AND ticker != '') AS tickers_traded FROM congress_members cm WHERE cm.bioguide_id = :bioguide_id

Query parameters

Edit SQL

0 results