Cosponsors for a Bill

View all cosponsors for a specific bill. Enter bill_id format: congress-type-number (e.g., '118-hr-3684').

Custom SQL query (hide) 

SELECT lc.bioguide_id, cm.full_name, lc.party, lc.state, CASE WHEN lc.is_original_cosponsor THEN 'Original' ELSE 'Added later' END AS cosponsor_type, lc.sponsorship_date, cm.chamber FROM legislation_cosponsors lc LEFT JOIN congress_members cm ON lc.bioguide_id = cm.bioguide_id WHERE lc.bill_id = :bill_id ORDER BY lc.is_original_cosponsor DESC, lc.sponsorship_date

Query parameters

Edit SQL

0 results