Committees for a Member

See all committee assignments for a specific member. Enter bioguide_id.

Custom SQL query (hide) 

SELECT c.committee_id, c.name, c.chamber, cm.title AS role, cm.rank, c.parent_committee_id, COALESCE(p.name, '') AS parent_committee FROM committee_memberships cm JOIN committees c ON cm.committee_id = c.committee_id LEFT JOIN committees p ON c.parent_committee_id = p.committee_id WHERE cm.bioguide_id = :bioguide_id ORDER BY c.chamber, c.name

Query parameters

Edit SQL

0 results