home / openregs

Explore: Member Floor Speeches

Congressional Record floor speeches for a specific member.

Custom SQL query (hide)

SELECT cr.granule_id, cr.date, cr.title, cr.chamber, SUBSTR(cr.full_text, 1, 300) AS excerpt FROM crec_speakers cs JOIN congressional_record cr ON cr.granule_id = cs.granule_id WHERE cs.bioguide_id = :bioguide_id ORDER BY cr.date DESC LIMIT 100

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 24.976ms