home / openregs

Search Congress Members

Find current or historical members of Congress by name.

Custom SQL query returning 200 rows (hide)

SELECT bioguide_id, full_name, party, state, chamber, CASE WHEN is_current THEN 'Yes' ELSE 'No' END AS current, first_served, last_served FROM congress_members WHERE full_name LIKE '%' || :name || '%' OR last_name LIKE '%' || :name || '%' ORDER BY is_current DESC, last_served DESC LIMIT 200

Query parameters

Edit SQL

This data as json, CSV

bioguide_idfull_namepartystatechambercurrentfirst_servedlast_served
W000802 Sheldon Whitehouse Democrat RI Senate Yes 2007-01-04 2031-01-03
S001217 Rick Scott Republican FL Senate Yes 2019-01-08 2031-01-03
C001114 John R. Curtis Republican UT Senate Yes 2017-11-13 2031-01-03
M001243 David McCormick Republican PA Senate Yes 2025-01-03 2031-01-03
K000383 Angus S. King, Jr. Independent ME Senate Yes 2013-01-03 2031-01-03
B001303 Lisa Blunt Rochester Democrat DE Senate Yes 2017-01-03 2031-01-03
B001299 Jim Banks Republican IN Senate Yes 2017-01-03 2031-01-03
R000608 Jacky Rosen Democrat NV Senate Yes 2017-01-03 2031-01-03
W000437 Roger F. Wicker Republican MS Senate Yes 1995-01-04 2031-01-03
M001242 Bernie Moreno Republican OH Senate Yes 2025-01-03 2031-01-03
C000127 Maria Cantwell Democrat WA Senate Yes 1993-01-05 2031-01-03
S001150 Adam B. Schiff Democrat CA Senate Yes 2001-01-03 2031-01-03
K000384 Tim Kaine Democrat VA Senate Yes 2013-01-03 2031-01-03
G000574 Ruben Gallego Democrat AZ Senate Yes 2015-01-06 2031-01-03
B001261 John Barrasso Republican WY Senate Yes 2007-06-25 2031-01-03
J000312 James C. Justice Republican WV Senate Yes 2025-01-14 2031-01-03
K000367 Amy Klobuchar Democrat MN Senate Yes 2007-01-04 2031-01-03
S000033 Bernard Sanders Independent VT Senate Yes 1991-01-03 2031-01-03
G000555 Kirsten E. Gillibrand Democrat NY Senate Yes 2007-01-04 2031-01-03
B001230 Tammy Baldwin Democrat WI Senate Yes 1999-01-06 2031-01-03
B001243 Marsha Blackburn Republican TN Senate Yes 2003-01-07 2031-01-03
H001046 Martin Heinrich Democrat NM Senate Yes 2009-01-06 2031-01-03
H001042 Mazie K. Hirono Democrat HI Senate Yes 2007-01-04 2031-01-03
M001169 Christopher Murphy Democrat CT Senate Yes 2007-01-04 2031-01-03
W000817 Elizabeth Warren Democrat MA Senate Yes 2013-01-03 2031-01-03
C001096 Kevin Cramer Republican ND Senate Yes 2013-01-03 2031-01-03
F000463 Deb Fischer Republican NE Senate Yes 2013-01-03 2031-01-03
C001098 Ted Cruz Republican TX Senate Yes 2013-01-03 2031-01-03
S001208 Elissa Slotkin Democrat MI Senate Yes 2019-01-03 2031-01-03
K000394 Andy Kim Democrat NJ Senate Yes 2019-01-03 2031-01-03
H001089 Josh Hawley Republican MO Senate Yes 2019-01-03 2031-01-03
A000382 Angela D. Alsobrooks Democrat MD Senate Yes 2025-01-03 2031-01-03
S001232 Tim Sheehy Republican MT Senate Yes 2025-01-03 2031-01-03
B001236 John Boozman Republican AR Senate Yes 2001-11-29 2029-01-03
W000779 Ron Wyden Democrat OR Senate Yes 1981-01-05 2029-01-03
M000934 Jerry Moran Republican KS Senate Yes 1997-01-07 2029-01-03
H001061 John Hoeven Republican ND Senate Yes 2011-01-05 2029-01-03
M001111 Patty Murray Democrat WA Senate Yes 1993-01-05 2029-01-03
W000800 Peter Welch Democrat VT Senate Yes 2007-01-04 2029-01-03
F000479 John Fetterman Democrat PA Senate Yes 2023-01-03 2029-01-03
D000622 Tammy Duckworth Democrat IL Senate Yes 2013-01-03 2029-01-03
B001319 Katie Boyd Britt Republican AL Senate Yes 2023-01-03 2029-01-03
B001267 Michael F. Bennet Democrat CO Senate Yes 2009-01-22 2029-01-03
V000128 Chris Van Hollen Democrat MD Senate Yes 2003-01-07 2029-01-03
J000293 Ron Johnson Republican WI Senate Yes 2011-01-05 2029-01-03
T000250 John Thune Republican SD Senate Yes 1997-01-07 2029-01-03
C000880 Mike Crapo Republican ID Senate Yes 1993-01-05 2029-01-03
P000603 Rand Paul Republican KY Senate Yes 2011-01-05 2029-01-03
K000377 Mark Kelly Democrat AZ Senate Yes 2020-12-02 2029-01-03
B001277 Richard Blumenthal Democrat CT Senate Yes 2011-01-05 2029-01-03
G000386 Chuck Grassley Republican IA Senate Yes 1975-01-14 2029-01-03
L000575 James Lankford Republican OK Senate Yes 2011-01-05 2029-01-03
L000577 Mike Lee Republican UT Senate Yes 2011-01-05 2029-01-03
M001153 Lisa Murkowski Republican AK Senate Yes 2003-01-07 2029-01-03
S000148 Charles E. Schumer Democrat NY Senate Yes 1981-01-05 2029-01-03
S001184 Tim Scott Republican SC Senate Yes 2011-01-05 2029-01-03
Y000064 Todd Young Republican IN Senate Yes 2011-01-05 2029-01-03
S001194 Brian Schatz Democrat HI Senate Yes 2012-12-27 2029-01-03
K000393 John Kennedy Republican LA Senate Yes 2017-01-03 2029-01-03
H001076 Margaret Wood Hassan Democrat NH Senate Yes 2017-01-03 2029-01-03
C001113 Catherine Cortez Masto Democrat NV Senate Yes 2017-01-03 2029-01-03
B001305 Ted Budd Republican NC Senate Yes 2017-01-03 2029-01-03
P000145 Alex Padilla Democrat CA Senate Yes 2021-01-20 2029-01-03
W000790 Raphael G. Warnock Democrat GA Senate Yes 2021-01-20 2029-01-03
S001227 Eric Schmitt Republican MO Senate Yes 2023-01-03 2029-01-03
G000583 Josh Gottheimer Democrat NJ House Yes 2017-01-03 2027-01-03
C001123 Gilbert Ray Cisneros, Jr. Democrat CA House Yes 2019-01-03 2027-01-03
T000278 Tommy Tuberville Republican AL Senate Yes 2021-01-03 2027-01-03
M001136 Lisa C. McClain Republican MI House Yes 2021-01-03 2027-01-03
F000462 Lois Frankel Democrat FL House Yes 2013-01-03 2027-01-03
G000599 Daniel S. Goldman Democrat NY House Yes 2023-01-03 2027-01-03
L000590 Susie Lee Democrat NV House Yes 2019-01-03 2027-01-03
B001292 Donald S. Beyer, Jr. Democrat VA House Yes 2015-01-06 2027-01-03
F000450 Virginia Foxx Republican NC House Yes 2005-01-04 2027-01-03
H001082 Kevin Hern Republican OK House Yes 2018-11-13 2027-01-03
P000608 Scott H. Peters Democrat CA House Yes 2013-01-03 2027-01-03
S001201 Thomas R. Suozzi Democrat NY House Yes 2017-01-03 2027-01-03
C001047 Shelley Moore Capito Republican WV Senate Yes 2001-01-03 2027-01-03
D000617 Suzan K. DelBene Democrat WA House Yes 2012-11-13 2027-01-03
B001327 Robert P. Bresnahan, Jr. Republican PA House Yes 2025-01-03 2027-01-03
C001035 Susan M. Collins Republican ME Senate Yes 1997-01-07 2027-01-03
S001229 Jefferson Shreve Republican IN House Yes 2025-01-03 2027-01-03
C001101 Katherine M. Clark Democrat MA House Yes 2013-12-12 2027-01-03
J000310 Julie Johnson Democrat TX House Yes 2025-01-03 2027-01-03
L000397 Zoe Lofgren Democrat CA House Yes 1995-01-04 2027-01-03
M001217 Jared Moskowitz Democrat FL House Yes 2023-01-03 2027-01-03
S000250 Pete Sessions Republican TX House Yes 1997-01-07 2027-01-03
H001094 Val T. Hoyle Democrat OR House Yes 2023-01-03 2027-01-03
C001080 Judy Chu Democrat CA House Yes 2009-07-16 2027-01-03
R000609 John H. Rutherford Republican FL House Yes 2017-01-03 2027-01-03
M001232 April McClain Delaney Democrat MD House Yes 2025-01-03 2027-01-03
F000246 Pat Fallon Republican TX House Yes 2021-01-03 2027-01-03
A000372 Rick W. Allen Republican GA House Yes 2015-01-06 2027-01-03
W000804 Robert J. Wittman Republican VA House Yes 2007-12-13 2027-01-03
J000307 John James Republican MI House Yes 2023-01-03 2027-01-03
P000609 Gary J. Palmer Republican AL House Yes 2015-01-06 2027-01-03
B001325 Sheri Biggs Republican SC House Yes 2025-01-03 2027-01-03
L000595 Julia Letlow Republican LA House Yes 2021-04-14 2027-01-03
F000472 Scott Franklin Republican FL House Yes 2021-01-03 2027-01-03
M001236 Tim Moore Republican NC House Yes 2025-01-03 2027-01-03
F000110 Cleo Fields Democrat LA House Yes 1993-01-05 2027-01-03
C001075 Bill Cassidy Republican LA Senate Yes 2009-01-06 2027-01-03
W000821 Bruce Westerman Republican AR House Yes 2015-01-06 2027-01-03
P000197 Nancy Pelosi Democrat CA House Yes 1987-01-06 2027-01-03
D000624 Debbie Dingell Democrat MI House Yes 2015-01-06 2027-01-03
P000595 Gary C. Peters Democrat MI Senate Yes 2009-01-06 2027-01-03
K000375 William R. Keating Democrat MA House Yes 2011-01-05 2027-01-03
T000490 David J. Taylor Republican OH House Yes 2025-01-03 2027-01-03
S001211 Greg Stanton Democrat AZ House Yes 2019-01-03 2027-01-03
J000309 Jonathan L. Jackson Democrat IL House Yes 2023-01-03 2027-01-03
N000189 Dan Newhouse Republican WA House Yes 2015-01-06 2027-01-03
E000296 Dwight Evans Democrat PA House Yes 2016-11-14 2027-01-03
D000399 Lloyd Doggett Democrat TX House Yes 1995-01-04 2027-01-03
S001198 Dan Sullivan Republican AK Senate Yes 2015-01-06 2027-01-03
L000601 Greg Landsman Democrat OH House Yes 2023-01-03 2027-01-03
C001069 Joe Courtney Democrat CT House Yes 2007-01-04 2027-01-03
J000295 David P. Joyce Republican OH House Yes 2013-01-03 2027-01-03
D000032 Byron Donalds Republican FL House Yes 2021-01-03 2027-01-03
T000486 Ritchie Torres Democrat NY House Yes 2021-01-03 2027-01-03
M001198 Roger Marshall Republican KS Senate Yes 2017-01-03 2027-01-03
K000398 Thomas H. Kean, Jr. Republican NJ House Yes 2023-01-03 2027-01-03
B001260 Vern Buchanan Republican FL House Yes 2007-01-04 2027-01-03
M001213 Blake D. Moore Republican UT House Yes 2021-01-03 2027-01-03
C001068 Steve Cohen Democrat TN House Yes 2007-01-04 2027-01-03
S001190 Bradley Scott Schneider Democrat IL House Yes 2013-01-03 2027-01-03
H000273 John W. Hickenlooper Democrat CO Senate Yes 2021-01-03 2027-01-03
M001205 Carol D. Miller Republican WV House Yes 2019-01-03 2027-01-03
M001234 Kelly Morrison Democrat MN House Yes 2025-01-03 2027-01-03
W000805 Mark R. Warner Democrat VA Senate Yes 2009-01-06 2027-01-03
D000628 Neal P. Dunn Republican FL House Yes 2017-01-03 2027-01-03
F000468 Lizzie Fletcher Democrat TX House Yes 2019-01-03 2027-01-03
W000797 Debbie Wasserman Schultz Democrat FL House Yes 2005-01-04 2027-01-03
S001148 Michael K. Simpson Republican ID House Yes 1999-01-06 2027-01-03
T000476 Thom Tillis Republican NC Senate Yes 2015-01-06 2027-01-03
S001189 Austin Scott Republican GA House Yes 2011-01-05 2027-01-03
M001199 Brian J. Mast Republican FL House Yes 2017-01-03 2027-01-03
S000168 Maria Elvira Salazar Republican FL House Yes 2021-01-03 2027-01-03
G000591 Michael Guest Republican MS House Yes 2019-01-03 2027-01-03
L000560 Rick Larsen Democrat WA House Yes 2001-01-03 2027-01-03
M001204 Daniel Meuser Republican PA House Yes 2019-01-03 2027-01-03
C001066 Kathy Castor Democrat FL House Yes 2007-01-04 2027-01-03
J000305 Sara Jacobs Democrat CA House Yes 2021-01-03 2027-01-03
K000376 Mike Kelly Republican PA House Yes 2011-01-05 2027-01-03
H000601 Bill Hagerty Republican TN Senate Yes 2021-01-03 2027-01-03
H001072 J. French Hill Republican AR House Yes 2015-01-06 2027-01-03
M001222 Max L. Miller Republican OH House Yes 2023-01-03 2027-01-03
T000488 Shri Thanedar Democrat MI House Yes 2023-01-03 2027-01-03
S001203 Tina Smith Democrat MN Senate Yes 2018-01-03 2027-01-03
C001108 James Comer Republican KY House Yes 2016-11-14 2027-01-03
C001103 Earl L. "Buddy" Carter Republican GA House Yes 2015-01-06 2027-01-03
S001216 Kim Schrier Democrat WA House Yes 2019-01-03 2027-01-03
M001163 Doris O. Matsui Democrat CA House Yes 2005-03-10 2027-01-03
W000830 George Whitesides Democrat CA House Yes 2025-01-03 2027-01-03
C001088 Christopher A. Coons Democrat DE Senate Yes 2010-11-15 2027-01-03
L000557 John B. Larson Democrat CT House Yes 1999-01-06 2027-01-03
P000048 August Pfluger Republican TX House Yes 2021-01-03 2027-01-03
C001120 Dan Crenshaw Republican TX House Yes 2019-01-03 2027-01-03
Y000067 Rudy Yakym III Republican IN House Yes 2022-11-14 2027-01-03
R000618 Pete Ricketts Republican NE Senate Yes 2023-01-23 2027-01-03
S000929 Victoria Spartz Republican IN House Yes 2021-01-03 2027-01-03
S001199 Lloyd Smucker Republican PA House Yes 2017-01-03 2027-01-03
R000305 Deborah K. Ross Democrat NC House Yes 2021-01-03 2027-01-03
S000185 Robert C. "Bobby" Scott Democrat VA House Yes 1993-01-05 2027-01-03
W000816 Roger Williams Republican TX House Yes 2013-01-03 2027-01-03
P000597 Chellie Pingree Democrat ME House Yes 2009-01-06 2027-01-03
M001220 Morgan McGarvey Democrat KY House Yes 2023-01-03 2027-01-03
N000147 Eleanor Holmes Norton Democrat DC House Yes 1991-01-03 2027-01-03
J000294 Hakeem S. Jeffries Democrat NY House Yes 2013-01-03 2027-01-03
G000603 Brandon Gill Republican TX House Yes 2025-01-03 2027-01-03
L000566 Robert E. Latta Republican OH House Yes 2007-12-13 2027-01-03
M001188 Grace Meng Democrat NY House Yes 2013-01-03 2027-01-03
R000612 John W. Rose Republican TN House Yes 2019-01-03 2027-01-03
S001214 W. Gregory Steube Republican FL House Yes 2019-01-03 2027-01-03
M001196 Seth Moulton Democrat MA House Yes 2015-01-06 2027-01-03
I000056 Darrell Issa Republican CA House Yes 2001-01-03 2027-01-03
G000359 Lindsey Graham Republican SC Senate Yes 1995-01-04 2027-01-03
M001206 Joseph D. Morelle Democrat NY House Yes 2018-11-13 2027-01-03
C001055 Ed Case Democrat HI House Yes 2003-01-07 2027-01-03
S000510 Adam Smith Democrat WA House Yes 1997-01-07 2027-01-03
R000603 David Rouzer Republican NC House Yes 2015-01-06 2027-01-03
B001291 Brian Babin Republican TX House Yes 2015-01-06 2027-01-03
T000480 William R. Timmons IV Republican SC House Yes 2019-01-03 2027-01-03
E000298 Ron Estes Republican KS House Yes 2017-04-25 2027-01-03
T000463 Michael R. Turner Republican OH House Yes 2003-01-07 2027-01-03
W000798 Tim Walberg Republican MI House Yes 2007-01-04 2027-01-03
G000597 Andrew R. Garbarino Republican NY House Yes 2021-01-03 2027-01-03
L000597 Laurel M. Lee Republican FL House Yes 2023-01-03 2027-01-03
S001213 Bryan Steil Republican WI House Yes 2019-01-03 2027-01-03
H001091 Ashley Hinson Republican IA House Yes 2021-01-03 2027-01-03
L000562 Stephen F. Lynch Democrat MA House Yes 2001-10-23 2027-01-03
B001288 Cory A. Booker Democrat NJ Senate Yes 2013-10-31 2027-01-03
P000034 Frank Pallone, Jr. Democrat NJ House Yes 1987-01-06 2027-01-03
C001117 Sean Casten Democrat IL House Yes 2019-01-03 2027-01-03
T000482 Lori Trahan Democrat MA House Yes 2019-01-03 2027-01-03
S000344 Brad Sherman Democrat CA House Yes 1997-01-07 2027-01-03
R000605 Mike Rounds Republican SD Senate Yes 2015-01-06 2027-01-03
R000614 Chip Roy Republican TX House Yes 2019-01-03 2027-01-03
R000621 Emily Randall Democrat WA House Yes 2025-01-03 2027-01-03
A000148 Jake Auchincloss Democrat MA House Yes 2021-01-03 2027-01-03
A000379 Mark Alford Republican MO House Yes 2023-01-03 2027-01-03
Powered by Datasette · Queries took 0.791ms