Explore: Member Profile

Full member profile by bioguide_id with activity counts.

Custom SQL query (hide) 

SELECT cm.*, COALESCE(ms.trade_count, 0) AS trade_count, COALESCE(ms.speech_count, 0) AS speech_count, COALESCE(ms.bills_sponsored, 0) AS bills_sponsored FROM congress_members cm LEFT JOIN member_stats ms ON ms.bioguide_id = cm.bioguide_id WHERE cm.bioguide_id = :bioguide_id

Query parameters

Edit SQL

0 results