Stock Trades by Committee Members

All stock trades by members of a specific committee. Enter committee ID.

Custom SQL query (hide) 

SELECT cm.member_name, cm.title AS committee_role, st.ticker, st.transaction_type, st.transaction_date, st.amount_range, st.asset_description FROM committee_memberships cm JOIN stock_trades st ON cm.bioguide_id = st.bioguide_id WHERE cm.committee_id = :committee_id AND st.ticker IS NOT NULL AND st.ticker != '' ORDER BY st.transaction_date DESC LIMIT 500

Query parameters

Edit SQL

0 results