speaker_activity

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

2,127 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ speaker_name bioguide_id official_name party state total_speeches active_days first_appearance last_appearance chambers congresses_active
1 1 A. Donald McEachin M001200 A. Donald McEachin Democrat VA 143 101 2017-01-05 2022-11-16 HOUSE 3
2 2 A. Drew Ferguson IV F000465 A. Drew Ferguson IV Republican GA 99 91 2017-01-12 2024-12-18 HOUSE 4
3 3 Aaron Bean B001314 Aaron Bean Republican FL 163 143 2023-01-09 2026-10-01 HOUSE 2
4 4 Aaron Schock S001179 Aaron Schock Republican IL 131 104 2009-01-15 2015-03-26 HOUSE,SENATE 4
5 5 Abby Finkenauer F000467 Abby Finkenauer Democrat IA 16 15 2019-01-14 2020-12-09 HOUSE 1
6 6 Abigail Davis Spanberger S001209 Abigail Davis Spanberger Democrat VA 192 160 2019-01-10 2024-12-19 HOUSE 3
7 7 Abraham J. Hamadeh H001098 Abraham J. Hamadeh Republican AZ 15 13 2025-05-06 2026-08-31 HOUSE 1
8 8 Adam B. Schiff S001150 Adam B. Schiff Democrat CA 1648 928 2001-01-31 2026-09-24 HOUSE,SENATE 13
9 9 Adam Gray G000605 Adam Gray Democrat CA 15 14 2025-02-13 2026-09-28 HOUSE 1
10 10 Adam H. Putnam P000586 Adam Putnam Republican FL 315 239 2001-02-14 2010-12-16 HOUSE 5
11 11 Adam Kinzinger K000378 Adam Kinzinger Republican IL 227 196 2011-01-06 2022-12-15 HOUSE,SENATE 6
12 12 Adam Smith S000510 Adam Smith Democrat WA 729 515 1997-02-13 2026-09-17 HOUSE 15
13 13 Addison McDowell M001240 Addison P. McDowell Republican NC 1 1 2025-02-06 2025-02-06 HOUSE 1
14 14 Addison P. McDowell M001240 Addison P. McDowell Republican NC 35 33 2025-02-05 2026-09-10 HOUSE 1
15 15 Adelita S. Grijalva G000606 Adelita S. Grijalva Democrat AZ 46 33 2025-11-18 2026-09-02 HOUSE 1
16 16 Adrian Smith S001172 Adrian Smith Republican NE 493 408 2007-01-09 2026-08-31 HOUSE 10
17 17 Adriano Espaillat E000297 Adriano Espaillat Democrat NY 309 257 2017-01-05 2026-09-02 HOUSE,SENATE 5
18 18 Al Franken F000457 Al Franken Democrat MN 511 287 2009-07-15 2017-12-21 SENATE 5
19 19 Al Franken F000457 Al Franken Democrat MN 6 5 2010-12-14 2017-11-13 SENATE 3
20 20 Al Green G000553 Al Green Democrat TX 1111 830 2005-01-20 2026-09-15 HOUSE,SENATE 11
21 21 Al Lawson, Jr. L000586 Al Lawson, Jr. Democrat FL 51 42 2017-01-05 2022-05-17 HOUSE 3
22 22 Al Swift S001115 Allan Swift Democrat WA 16 8 1994-02-03 1994-10-07 HOUSE 1
23 23 Alan Armstrong A000383 Alan Armstrong Republican OK 13 6 2026-06-23 2026-09-30 SENATE 1
24 24 Alan B. Mollohan M000844 Alan Mollohan Democrat WV 179 125 1994-03-10 2010-12-21 HOUSE,SENATE 9
25 25 Alan Grayson G000556 Alan Grayson Democrat FL 364 207 2009-01-14 2016-12-13 HOUSE 3
26 26 Alan K. Simpson S000429 Alan Simpson Republican WY 374 153 1994-01-25 1996-10-03 SENATE,HOUSE 2
27 27 Alan Nunnelee N000186 Alan Nunnelee Republican MS 71 62 2011-01-06 2014-05-22 HOUSE 2
28 28 Alan S. Lowenthal L000579 Alan S. Lowenthal Democrat CA 248 210 2013-01-15 2022-12-30 HOUSE 5
29 29 Alan Wheat W000326 Alan Wheat Democrat MO 12 9 1994-01-25 1994-10-08 HOUSE 1
30 30 Albert Russell Wynn W000784 Albert Wynn Democrat MD 407 337 1994-03-03 2008-06-03 HOUSE 8
31 31 Albio Sires S001165 Albio Sires Democrat NJ 368 310 2006-11-13 2022-09-15 HOUSE 9
32 32 Alcee L. Hastings H000324 Alcee L. Hastings Democrat FL 1924 1267 1994-10-04 2021-04-01 HOUSE,SENATE 15
33 33 Alex Padilla P000145 Alex Padilla Democrat CA 999 307 2021-02-12 2026-09-30 SENATE 3
34 34 Alexander X. Mooney M001195 Alexander X. Mooney Republican WV 151 135 2015-01-12 2024-12-12 HOUSE 5
35 35 Alexandria Ocasio-Cortez O000172 Alexandria Ocasio-Cortez Democrat NY 105 75 2019-01-16 2026-06-23 HOUSE,SENATE 4
36 36 Alfonse D'Amato D000018 Alfonse D’Amato Republican NY 777 363 1994-01-25 1998-11-12 SENATE,HOUSE 3
37 37 Alfred A. (Al) McCandless M000306 Alfred McCandless Republican CA 8 7 1994-02-01 1994-10-06 HOUSE 1
38 38 Allen B. West W000807 Allen B. West Republican FL 56 51 2011-01-06 2012-12-20 HOUSE 1
39 39 Allen Boyd B000716 Allen Boyd Democrat FL 232 201 1997-02-11 2010-09-16 HOUSE 7
40 40 Allyson Y. Schwartz S001162 Allyson Y. Schwartz Democrat PA 381 291 2005-01-25 2014-12-10 HOUSE 5
41 41 Alma S. Adams A000370 Alma S. Adams Democrat NC 252 214 2014-11-12 2026-07-20 HOUSE 7
42 42 Ami Bera B001287 Ami Bera Democrat CA 188 162 2013-01-15 2026-06-09 HOUSE 7
43 43 Amo Houghton H000814 Amory Houghton Republican NY 254 222 1994-03-17 2004-10-11 HOUSE,SENATE 6
44 44 Amy Klobuchar K000367 Amy Klobuchar Democrat MN 1610 869 2007-01-12 2026-09-30 SENATE 10
45 45 Analilia Mejia M001246 Analilia Mejia Democrat NJ 20 16 2026-05-14 2026-10-22 HOUSE 1
46 46 Ander Crenshaw C001045 Ander Crenshaw Republican FL 308 251 2001-02-08 2016-12-07 HOUSE 8
47 47 Andre Carson C001072 André Carson Democrat IN 485 403 2007-05-07 2026-10-01 HOUSE,SENATE 10
48 48 Andrea H. Seastrand S000213 Andrea Seastrand Republican CA 177 132 1995-01-04 1996-09-28 HOUSE 1
49 49 Andrea Salinas S001226 Andrea Salinas Democrat OR 78 72 2023-01-26 2026-09-01 HOUSE 2
50 50 Andrew Jacobs Jr. J000033 Andrew Jacobs Democrat IN 85 73 1994-01-25 1996-09-28 HOUSE 2
51 51 Andrew Ogles O000175 Andrew Ogles Republican TN 70 60 2023-01-24 2026-07-21 HOUSE 2
52 52 Andrew R. Garbarino G000597 Andrew R. Garbarino Republican NY 65 41 2021-03-02 2026-07-20 HOUSE 3
53 53 Andrew S. Clyde C001116 Andrew S. Clyde Republican GA 191 134 2021-01-13 2026-05-21 HOUSE 3
54 54 Andy Barr B001282 Andy Barr Republican KY 536 388 2013-01-15 2026-08-31 HOUSE 7
55 55 Andy Biggs B001302 Andy Biggs Republican AZ 340 243 2017-01-05 2026-09-02 HOUSE 5
56 56 Andy Harris H001052 Andy Harris Republican MD 262 223 2011-01-06 2026-09-14 HOUSE 8
57 57 Andy Kim K000394 Andy Kim Democrat NJ 279 160 2019-02-13 2026-09-29 HOUSE,SENATE 4
58 58 Andy Levin L000592 Andy Levin Democrat MI 131 117 2019-01-09 2022-12-15 HOUSE 2
59 59 Angela D. Alsobrooks A000382 Angela D. Alsobrooks Democrat MD 96 37 2025-01-29 2026-09-23 SENATE 1
60 60 Angie Craig C001119 Angie Craig Democrat MN 181 135 2019-01-11 2026-10-13 HOUSE 4
61 61 Angus S. King Jr. K000383 Angus S. King, Jr. Independent ME 677 369 2013-04-24 2026-07-15 SENATE 7
62 62 Anh "Joseph" Cao C001079 Anh Cao Republican LA 100 75 2009-02-13 2010-12-15 HOUSE 1
63 63 Anibal Acevedo-Vila A000359 Aníbal Acevedo-Vilá Popular Democrat PR 60 55 2001-03-01 2004-10-07 HOUSE 2
64 64 Ann Kirkpatrick K000368 Ann Kirkpatrick Democrat AZ 184 164 2009-03-25 2022-07-14 HOUSE 5
65 65 Ann M. Kuster K000382 Ann M. Kuster Democrat NH 358 294 2013-02-25 2024-12-20 HOUSE 6
66 66 Ann Marie Buerkle B001276 Ann Marie Buerkle Republican NY 77 53 2011-01-05 2012-09-28 HOUSE 1
67 67 Ann Wagner W000812 Ann Wagner Republican MO 333 258 2013-01-22 2026-09-15 HOUSE 7
68 68 Anna G. Eshoo E000215 Anna G. Eshoo Democrat CA 1609 1137 1994-02-02 2024-12-24 HOUSE,SENATE 16
69 69 Anna Paulina Luna L000596 Anna Paulina Luna Republican FL 36 32 2023-01-05 2026-04-29 HOUSE 2
70 70 Anne M. Northup N000143 Anne Northup Republican KY 168 145 1997-02-06 2006-06-26 HOUSE 5
71 71 Anthony Brindisi B001308 Anthony Brindisi Democrat NY 22 20 2019-01-30 2020-12-16 HOUSE 1
72 72 Anthony C. Beilenson B000318 Anthony Beilenson Democrat CA 164 115 1994-02-02 1996-09-25 HOUSE,SENATE 2
73 73 Anthony D'Esposito D000632 Anthony D’Esposito Republican NY 64 54 2023-01-26 2024-12-18 HOUSE 1
74 74 Anthony D. Weiner W000792 Anthony Weiner Democrat NY 388 292 1999-01-06 2011-05-24 HOUSE 7
75 75 Anthony G. Brown B001304 Anthony G. Brown Democrat MD 131 109 2017-01-05 2022-06-08 HOUSE 3
76 76 Anthony Gonzalez G000588 Anthony Gonzalez Republican OH 51 47 2019-02-25 2022-07-26 HOUSE 2
77 77 Antonio Delgado D000630 Antonio Delgado Democrat NY 51 42 2019-01-16 2022-05-20 HOUSE 2
78 78 Arlen Specter S000709 Arlen Specter Democrat PA 2725 1177 1994-01-26 2010-12-22 SENATE,HOUSE 9
79 79 Arthur Ravenel Jr. R000072 Arthur Ravenel Republican SC 3 3 1994-03-16 1994-08-21 HOUSE,SENATE 1
80 80 Artur Davis D000602 Artur Davis Democrat AL 99 88 2003-02-12 2010-05-24 HOUSE 4
81 81 Asa Hutchinson H001014 Asa Hutchinson Republican AR 197 150 1997-02-11 2001-08-03 HOUSE 3
82 82 Ashley Hinson H001091 Ashley Hinson Republican IA 69 64 2021-02-02 2026-08-31 HOUSE 3
83 83 Ashley Moody M001244 Ashley Moody Republican FL 81 48 2025-02-20 2026-09-30 SENATE 1
84 84 August Pfluger P000048 August Pfluger Republican TX 152 133 2021-02-03 2026-09-15 HOUSE 3
85 85 Aumua Amata Coleman Radewagen R000600 Aumua Amata Coleman Radewagen Republican AS 82 68 2015-02-05 2026-06-10 HOUSE 6
86 86 Austin J. Murphy M001088 Austin Murphy Democrat PA 4 3 1994-02-10 1994-10-07 HOUSE 1
87 87 Austin Scott S001189 Austin Scott Republican GA 256 214 2011-02-09 2026-07-23 HOUSE 8
88 88 Ayanna Pressley P000617 Ayanna Pressley Democrat MA 181 154 2019-01-08 2026-09-02 HOUSE,SENATE 4
89 89 Barack Obama O000167 Barack Obama Democrat IL 534 249 2005-01-06 2008-10-01 SENATE,HOUSE 2
90 90 Barbara A. Mikulski M000702 Barbara A. Mikulski Democrat MD 1793 1114 1994-01-26 2016-12-09 SENATE,HOUSE 12
91 91 Barbara B. Kennelly K000118 Barbara Kennelly Democrat CT 318 233 1994-01-25 1998-12-18 HOUSE,SENATE 3
92 92 Barbara Boxer B000711 Barbara Boxer Democrat CA 3877 1803 1994-01-25 2016-12-09 SENATE,HOUSE 12
93 93 Barbara Comstock C001105 Barbara Comstock Republican VA 381 166 2015-01-09 2018-12-13 HOUSE 2
94 94 Barbara Cubin C000962 Barbara Cubin Republican WY 213 183 1995-01-04 2008-09-25 HOUSE 7
95 95 Barbara F. Vucanovich V000124 Barbara Vucanovich Republican NV 131 92 1994-02-01 1996-09-26 HOUSE,SENATE 2
96 96 Barbara Lee L000551 Barbara Lee Democrat CA 2482 1574 1998-04-21 2024-12-24 HOUSE,SENATE 14
97 97 Barbara-Rose Collins C000633 Barbara-Rose Collins Democrat MI 67 49 1994-02-09 1996-09-26 HOUSE 2
98 98 Barney Frank F000339 Barney Frank Democrat MA 1395 916 1994-01-25 2012-12-31 HOUSE,SENATE 10
99 99 Baron P. Hill H001030 Baron Hill Democrat IN 168 146 1999-02-24 2010-09-14 HOUSE 5
100 100 Barry Loudermilk L000583 Barry Loudermilk Republican GA 175 154 2015-01-07 2026-09-14 HOUSE 6

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE speaker_activity(
  speaker_name TEXT,
  bioguide_id TEXT,
  official_name TEXT,
  party TEXT,
  state TEXT,
  total_speeches,
  active_days,
  first_appearance,
  last_appearance,
  chambers,
  congresses_active
);
CREATE INDEX idx_sa_bioguide ON speaker_activity(bioguide_id);
CREATE INDEX idx_sa_speeches ON speaker_activity(total_speeches DESC);