Most Active Speakers in Congress

Members of Congress with the most floor speeches, filtered by Congress number (e.g., 118 for 2023-2024).

Custom SQL query (hide)

SELECT cs.speaker_name, COUNT(*) AS speeches, MIN(cr.date) AS first_speech, MAX(cr.date) AS last_speech, GROUP_CONCAT(DISTINCT cr.chamber) AS chambers FROM crec_speakers cs JOIN congressional_record cr ON cs.granule_id = cr.granule_id WHERE cr.congress = :congress GROUP BY cs.speaker_name ORDER BY speeches DESC LIMIT 100

Query parameters

congress

Edit SQL

0 results