Floor Debate for a Specific Bill

All Congressional Record entries referencing a specific bill. Enter bill_id format: congress-type-number (e.g., '118-hr-3684').

Custom SQL query (hide) 

SELECT cr.date, cr.title, cr.chamber, cs_agg.speakers, cr.page_start, substr(cr.full_text, 1, 400) AS excerpt FROM crec_bills cb JOIN congressional_record cr ON cb.granule_id = cr.granule_id LEFT JOIN (SELECT granule_id, GROUP_CONCAT(speaker_name, '; ') AS speakers FROM crec_speakers GROUP BY granule_id) cs_agg ON cr.granule_id = cs_agg.granule_id WHERE cb.bill_id = :bill_id ORDER BY cr.date

Query parameters

Edit SQL

0 results