congress_members

All current and historical members of Congress (12,700+) from the congress-legislators project. Includes bioguide_id (universal key), party, state, chamber, and cross-reference IDs for OpenSecrets, FEC, GovTrack, and more.

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

100 rows where chamber = "Senate" and is_current = 1 sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: nickname, last_served, gender, terms_count, first_served (date), last_served (date), birthday (date), fec_ids (array)

state >30

party 3

is_current 1

chamber 1

  • Senate · 100 ✖
bioguide_id first_name last_name full_name ▼ nickname party state chamber district first_served last_served is_current opensecrets_id fec_ids govtrack_id thomas_id votesmart_id lis_id wikipedia_id ballotpedia_id birthday gender terms_count served_until trade_count speech_count bills_sponsored vote_count fec_total_received
S001150 Adam Schiff Adam B. Schiff   Democrat CA Senate   2001-01-03 2031-01-03 1 N00009585 ["H0CA27085", "S4CA00555"] 400361 01635 9489 S427 Adam Schiff Adam Schiff 1960-06-22 M 6   32 1550 312 14572 4888475
P000145 Alejandro Padilla Alex Padilla Alex Democrat CA Senate   2021-01-20 2029-01-03 1 N00047888 ["S2CA00955"] 456856   59742 S413 Alex Padilla Alex Padilla 1973-03-22 M 2   0 843 248 2343 2811407
K000367 Amy Klobuchar Amy Klobuchar   Democrat MN Senate   2007-01-04 2031-01-03 1 N00027500 ["S6MN00267"] 412242 01826 65092 S311 Amy Klobuchar Amy Klobuchar 1960-05-25 F 5   0 1574 973 6662 6467562
K000394 Andy Kim Andy Kim   Democrat NJ Senate   2019-01-03 2031-01-03 1 N00041370 ["H8NJ03206", "S4NJ00466"] 412797   179640 S426 Andy Kim (politician) Andrew Kim (New Jersey) 1982-07-12 M 3   0 218 107 3345 12597254
A000382 Angela Alsobrooks Angela D. Alsobrooks   Democrat MD Senate   2025-01-03 2031-01-03 1 N00053033 ["S4MD00327"] 456965     S428 Angela Alsobrooks   1971-02-23 F 2   0 50 23 705 34339278
K000383 Angus King Angus S. King, Jr.   Independent ME Senate   2013-01-03 2031-01-03 1 N00034580 ["S2ME00109"] 412545 02185 22381 S363 Angus King Angus King 1944-03-31 M 4   116 665 231 4823 9000844
M001244 Ashley Moody Ashley Moody   Republican FL Senate   2025-01-21 2026-11-03 1   ["S6FL00640"] 457033     S439 Ashley Moody   1975-03-28 F 1   57 30 28 697 1369965
L000570 Ben Luján Ben Ray Luján   Democrat NM Senate   2009-01-06 2027-01-03 1 N00029562 ["H8NM03196", "S0NM00058"] 412293 01939 102842 S409 Ben Ray Luján Ben Ray Luján 1972-06-07 M 4   0 398 341 10295 9337078
S000033 Bernard Sanders Bernard Sanders Bernie Independent VT Senate   1991-01-03 2031-01-03 1 N00000528 ["H8VT01016", "S4VT00033"] 400357 01010 27110 S313 Bernie Sanders Bernie Sanders 1941-09-08 M 7   0 2569 427 9090 2437587
M001242 Bernie Moreno Bernie Moreno   Republican OH Senate   2025-01-03 2031-01-03 1 N00048437 ["S4OH00192"] 456967     S434 Bernie Moreno   1967-02-14 M 2   6 87 22 705 158943992
C001075 Bill Cassidy Bill Cassidy   Republican LA Senate   2009-01-06 2027-01-03 1 N00030245 ["H8LA00017", "S4LA00107"] 412269 01925 69494 S373 Bill Cassidy Bill Cassidy 1957-09-28 M 4   215 800 489 8630 25398324
H000601 Bill Hagerty Bill Hagerty   Republican TN Senate   2021-01-03 2027-01-03 1 N00045369 ["S0TN00169"] 456798   128466 S407 Bill Hagerty Bill Hagerty 1959-08-14 M 2   65 333 80 2345 6508207
S001194 Brian Schatz Brian Schatz   Democrat HI Senate   2012-12-27 2029-01-03 1 N00028138 ["S4HI00136", "H6HI02244"] 412507 02173 17852 S353 Brian Schatz Brian E. Schatz 1972-10-20 M 3   0 896 375 4843 5899723
C001113 Catherine Cortez Masto Catherine Cortez Masto   Democrat NV Senate   2017-01-03 2029-01-03 1 N00037161 ["S6NV00200"] 412681   69579 S385 Catherine Cortez Masto Catherine Cortez Masto 1964-03-29 F 3   0 582 408 3664 121744661
S000148 Charles Schumer Charles E. Schumer Chuck Democrat NY Senate   1981-01-05 2029-01-03 1 N00001093 ["S8NY00082", "H0NY16010"] 300087 01036 26976 S270 Chuck Schumer Chuck Schumer 1950-11-23 M 9   0 10647 897 9287 12813719
V000128 Chris Van Hollen Chris Van Hollen   Democrat MD Senate   2003-01-07 2029-01-03 1 N00013820 ["H2MD08126", "S6MD03441"] 400415 01729 6098 S390 Chris Van Hollen Chris Van Hollen 1959-01-10 M 5   10 2095 360 13682 7322942
C001088 Christopher Coons Christopher A. Coons   Democrat DE Senate   2010-11-15 2027-01-03 1 N00031820 ["S0DE00092"] 412390 01984 122834 S337 Chris Coons Chris Coons 1963-09-09 M 3   34 894 449 5360 7629243
M001169 Christopher Murphy Christopher Murphy   Democrat CT Senate   2007-01-04 2031-01-03 1 N00027566 ["H6CT05124", "S2CT00132"] 412194 01837 17189 S364 Chris Murphy Chris Murphy (Connecticut) 1973-08-03 M 5   0 1201 326 9884 6996209
G000386 Charles Grassley Chuck Grassley Chuck Republican IA Senate   1975-01-14 2029-01-03 1 N00001758 ["S0IA00028"] 300048 00457 53293 S153 Chuck Grassley Chuck Grassley 1933-09-17 M 10   0 6372 794 9287 13001247
H001079 Cindy Hyde-Smith Cindy Hyde-Smith   Republican MS Senate   2018-04-09 2027-01-03 1 N00043298 ["S8MS00261"] 412743   20784 S395 Cindy Hyde-Smith Cindy Hyde-Smith 1959-05-10 F 2   0 220 101 3276 8616793
B001288 Cory Booker Cory A. Booker   Democrat NJ Senate   2013-10-31 2027-01-03 1 N00035267 ["S4NJ00185"] 412598 02194 76151 S370 Cory Booker Cory Booker 1969-04-27 M 3   13 759 621 4598 6260634
L000571 Cynthia Lummis Cynthia M. Lummis   Republican WY Senate   2009-01-06 2027-01-03 1 N00029788 ["H8WY00148", "S0WY00137"] 412294 01960 15546 S410 Cynthia Lummis Cynthia Lummis 1954-09-10 F 4   5 416 150 8134 4255612
S001198 Dan Sullivan Dan Sullivan   Republican AK Senate   2015-01-06 2027-01-03 1 N00035774 ["S4AK00214"] 412665 02290 114964 S383 Dan Sullivan (U.S. senator) Daniel S. Sullivan 1964-11-13 M 3   170 934 294 4166 39349648
M001243 Dave McCormick David McCormick   Republican PA Senate   2025-01-03 2031-01-03 1 N00050244 ["S2PA00661"] 456968     S433 Dave McCormick   1965-08-17 M 2   226 21 27 705 122118852
F000463 Deb Fischer Deb Fischer   Republican NE Senate   2013-01-03 2031-01-03 1 N00033443 ["S2NE00094"] 412556 02179 41963 S357 Deb Fischer Deb Fischer 1951-03-01 F 4   0 592 217 4823 20577773
M000133 Edward Markey Edward J. Markey Ed Democrat MA Senate   1975-01-14 2027-01-03 1 N00000270 ["H6MA07101", "S4MA00028"] 400253 00735 26900 S369 Ed Markey Ed Markey 1946-07-11 M 9   0 1900 957 12493 14910347
S001208 Elissa Slotkin Elissa Slotkin   Democrat MI Senate   2019-01-03 2031-01-03 1 N00041357 ["H8MI08102", "S4MI00470"] 412784   181080 S436 Elissa Slotkin Elissa Slotkin 1976-07-10 F 3   0 245 174 3347 110627871
W000817 Elizabeth Warren Elizabeth Warren   Democrat MA Senate   2013-01-03 2031-01-03 1 N00033492 ["S2MA00170"] 412542 02182 141272 S366 Elizabeth Warren Elizabeth Warren 1949-06-22 F 4   0 904 446 4823 7656779
S001227 Eric Schmitt Eric Schmitt   Republican MO Senate   2023-01-03 2029-01-03 1 N00048414 ["S2MO00544"] 456875   104474 S420 Eric Schmitt Eric Schmitt 1975-06-20 M 2   0 207 71 1396 13532251
P000595 Gary Peters Gary C. Peters   Democrat MI Senate   2009-01-06 2027-01-03 1 N00029277 ["H8MI09068", "S4MI00355"] 412305 01929 8749 S380 Gary Peters Gary Peters 1958-12-01 M 4   202 1113 555 8630 78915125
R000122 John Reed Jack Reed Jack Democrat RI Senate   1991-01-03 2027-01-03 1 N00000362 ["S6RI00163", "H0RI02071"] 300081 00949 27060 S259 Jack Reed (Rhode Island politician) Jack Reed 1949-11-12 M 7   0 3395 467 9287 4757051
R000608 Jacky Rosen Jacky Rosen   Democrat NV Senate   2017-01-03 2031-01-03 1 N00038734 ["H6NV03139", "S8NV00156"] 412715   169471 S402 Jacky Rosen Jacky Rosen 1957-08-02 F 3   26 403 249 4274 82085703
J000312 Jim Justice James C. Justice   Republican WV Senate   2025-01-14 2031-01-03 1 N00053062 ["S4WV00332"] 456969     S437 Jim Justice   1951-04-27 M 2   1 10 8 703 6811413
R000584 James Risch James E. Risch   Republican ID Senate   2009-01-06 2027-01-03 1 N00029441 ["S8ID00092"] 412322 01896 2919 S323 Jim Risch Jim Risch 1943-05-03 M 4   0 1189 247 6005 3941717
L000575 James Lankford James Lankford   Republican OK Senate   2011-01-05 2029-01-03 1 N00031129 ["H0OK05114", "S4OK00232"] 412464 02050 124938 S378 James Lankford James Lankford 1968-03-04 M 4   0 1117 289 6975 6874480
S001181 Jeanne Shaheen Jeanne Shaheen   Democrat NH Senate   2009-01-06 2027-01-03 1 N00024790 ["S0NH00219"] 412323 01901 1663 S324 Jeanne Shaheen Jeanne Shaheen 1947-01-28 F 4   3 1450 592 6005 17027727
M001176 Jeff Merkley Jeff Merkley   Democrat OR Senate   2009-01-06 2027-01-03 1 N00029303 ["S8OR00207"] 412325 01900 23644 S322 Jeff Merkley Jeff Merkley 1956-10-24 M 4   0 1806 617 6005 4978375
M000934 Jerry Moran Jerry Moran   Republican KS Senate   1997-01-07 2029-01-03 1 N00005282 ["H6KS01096", "S0KS00091"] 400284 01507 542 S347 Jerry Moran Jerry Moran 1954-05-29 M 6   279 1568 422 11193 8716152
B001299 Jim Banks Jim Banks   Republican IN Senate   2017-01-03 2031-01-03 1 N00037185 ["H6IN03229", "S4IN00196"] 412702   116801 S429 Jim Banks Jim Banks 1979-07-16 M 3   55 240 228 4556 8775961
B001261 John Barrasso John Barrasso   Republican WY Senate   2007-06-25 2031-01-03 1 N00006236 ["S6WY00068"] 412251 01881 52662 S317 John Barrasso John Barrasso 1952-07-21 M 5   1 2986 344 6436 11259582
B001236 John Boozman John Boozman   Republican AR Senate   2001-11-29 2029-01-03 1 N00013873 ["H2AR03176", "S0AR00150"] 400040 01687 27958 S343 John Boozman John Boozman 1950-12-10 M 5   334 1421 234 11193 10058733
C001056 John Cornyn John Cornyn   Republican TX Senate   2002-11-30 2027-01-03 1 N00024852 ["S2TX00106"] 300027 01692 15375 S287 John Cornyn John Cornyn 1952-02-02 M 5   2 5217 803 7982 42730377
F000479 John Fetterman John Fetterman   Democrat PA Senate   2023-01-03 2029-01-03 1 N00038201 ["S6PA00274"] 456877   166286 S418 John Fetterman John Fetterman 1969-08-15 M 2   69 15 59 1396 122801073
H001061 John Hoeven John Hoeven   Republican ND Senate   2011-01-05 2029-01-03 1 N00031688 ["S0ND00093"] 412494 02079 41788 S344 John Hoeven John Hoeven 1957-03-13 M 4   225 758 207 5309 6528965
K000393 John Kennedy John Kennedy   Republican LA Senate   2017-01-03 2029-01-03 1 N00026823 ["S4LA00065"] 412679   35496 S389 John Kennedy (Louisiana politician) John Neely Kennedy 1951-11-21 M 3   0 719 326 3664 4869509
C001114 John Curtis John R. Curtis   Republican UT Senate   2017-11-13 2031-01-03 1 N00041221 ["H8UT03238", "S4UT00282"] 412740   123390 S431 John Curtis (Utah politician) John Curtis (Utah) 1960-05-10 M 3   338 137 173 3934 13164975
T000250 John Thune John Thune   Republican SD Senate   1997-01-07 2029-01-03 1 N00004572 ["S2SD00068", "H6SD00085"] 400546 01534 398 S303 John Thune John Thune 1961-01-07 M 6   2 6939 456 7307 11600577
H000273 John Hickenlooper John W. Hickenlooper   Democrat CO Senate   2021-01-03 2027-01-03 1 N00044206 ["S0CO00575"] 456797     S408 John Hickenlooper John Hickenlooper 1952-02-07 M 2   120 164 104 2345 26224287
H001104 Jon Husted Jon Husted   Republican OH Senate   2025-01-21 2026-11-03 1   ["S6OH00304"] 457032     S438 Jon Husted   1967-08-25 M 1   1 36 31 697 1745868
O000174 Jon Ossoff Jon Ossoff   Democrat GA Senate   2021-01-20 2027-01-03 1 N00040675 ["H8GA06195", "S8GA00180"] 456857   176134 S414 Jon Ossoff Jon Ossoff 1987-02-16 M 2   0 215 141 2343 186372546
E000295 Joni Ernst Joni Ernst   Republican IA Senate   2015-01-06 2027-01-03 1 N00035483 ["S4IA00129"] 412667 02283 128583 S376 Joni Ernst Joni Ernst 1970-07-01 F 3   0 811 340 4166 133534970
H001089 Joshua Hawley Josh Hawley Josh Republican MO Senate   2019-01-03 2031-01-03 1 N00041620 ["S8MO00160"] 412840   169716 S399 Josh Hawley Josh Hawley 1979-12-31 M 3   0 321 199 3065 36246770
B001319 Katie Britt Katie Boyd Britt   Republican AL Senate   2023-01-03 2029-01-03 1 N00048812 ["S2AL00145"] 456874   201704 S416 Katie Britt Katie Britt 1982-02-02 F 2   26 103 39 1396 16548804
C001096 Kevin Cramer Kevin Cramer   Republican ND Senate   2013-01-03 2031-01-03 1 N00004614 ["H0ND01026", "H6ND00074", "S8ND00120"] 412555 02144 444 S398 Kevin Cramer Kevin Cramer 1961-01-21 M 4   0 400 120 6803 13899499
G000555 Kirsten Gillibrand Kirsten E. Gillibrand   Democrat NY Senate   2007-01-04 2031-01-03 1 N00027658 ["H6NY20167", "S0NY00410"] 412223 01866 65147 S331 Kirsten Gillibrand Kirsten Gillibrand 1966-12-09 F 5   0 697 612 7820 8160313
G000359 Lindsey Graham Lindsey Graham   Republican SC Senate   1995-01-04 2027-01-03 1 N00009975 ["S0SC00149", "H4SC03087"] 300047 00452 21992 S293 Lindsey Graham Lindsey Graham 1955-07-09 M 6   19 1191 398 7982 29283180
B001303 Lisa Blunt Rochester Lisa Blunt Rochester   Democrat DE Senate   2017-01-03 2031-01-03 1 N00038414 ["H6DE00206", "S4DE00060"] 412689   173249 S430 Lisa Blunt Rochester Lisa Blunt Rochester 1962-02-10 F 3   63 179 125 4556 7288512
M001153 Lisa Murkowski Lisa Murkowski   Republican AK Senate   2003-01-07 2029-01-03 1 N00026050 ["S4AK00099"] 300075 01694 15841 S288 Lisa Murkowski Lisa Murkowski 1957-05-22 F 5   0 2121 599 7982 19254369
H001076 Margaret Hassan Margaret Wood Hassan Maggie Democrat NH Senate   2017-01-03 2029-01-03 1 N00038397 ["S6NH00091"] 412680   42552 S388 Maggie Hassan Maggie Hassan 1958-02-27 F 3   0 534 248 3664 62485960
C000127 Maria Cantwell Maria Cantwell   Democrat WA Senate   1993-01-05 2031-01-03 1 N00007836 ["S8WA00194", "H2WA01054"] 300018 00172 27122 S275 Maria Cantwell Maria Cantwell 1958-10-13 F 7   6 1780 462 8615 620082
K000377 Mark Kelly Mark Kelly   Democrat AZ Senate   2020-12-02 2029-01-03 1 N00044223 ["S0AZ00350"] 456794   190594 S406 Mark Kelly Mark Kelly 1964-02-21 M 2   1 259 109 2390 117300033
W000805 Mark Warner Mark R. Warner   Democrat VA Senate   2009-01-06 2027-01-03 1 N00002097 ["S6VA00093", "P80003023"] 412321 01897 535 S327 Mark Warner Mark Warner 1954-12-15 M 4   115 917 332 6005 11472627
M001190 Markwayne Mullin Markwayne Mullin   Republican OK Senate   2013-01-03 2027-01-03 1 N00033410 ["H2OK02083", "S2OK00186"] 412568 02156 135898 S419 Markwayne Mullin Markwayne Mullin 1977-07-26 M 3   557 131 132 6535 8436438
B001243 Marsha Blackburn Marsha Blackburn   Republican TN Senate   2003-01-07 2031-01-03 1 N00003105 ["H2TN06030", "S8TN00337"] 400032 01748 25186 S396 Marsha Blackburn Marsha Blackburn 1952-06-06 F 5   0 1979 496 14292 38279120
H001046 Martin Heinrich Martin Heinrich   Democrat NM Senate   2009-01-06 2031-01-03 1 N00029835 ["H8NM01224", "S2NM00088"] 412281 01937 74517 S359 Martin Heinrich Martin Heinrich 1971-10-17 M 4   0 601 305 8083 14054849
H001042 Mazie Hirono Mazie K. Hirono   Democrat HI Senate   2007-01-04 2031-01-03 1 N00028139 ["H6HI02251", "S2HI00106"] 412200 01844 1677 S361 Mazie Hirono Mazie K. Hirono 1947-11-03 F 5   0 1206 416 9884 5542568
B001267 Michael Bennet Michael F. Bennet   Democrat CO Senate   2009-01-22 2029-01-03 1 N00030608 ["S0CO00211"] 412330 01965 110942 S330 Michael Bennet Michael Bennet 1964-11-28 M 4   10 1184 384 5995 32308392
C000880 Michael Crapo Mike Crapo Mike Republican ID Senate   1993-01-05 2029-01-03 1 N00006267 ["S8ID00027", "H2ID02034"] 300030 00250 26830 S266 Mike Crapo Mike Crapo 1951-05-20 M 7   1 1460 300 9287 10137509
L000577 Mike Lee Mike Lee   Republican UT Senate   2011-01-05 2029-01-03 1 N00031696 ["S0UT00165"] 412495 02080 66395 S346 Mike Lee Mike Lee 1971-06-04 M 4   0 2279 578 5309 15287291
R000605 Mike Rounds Mike Rounds   Republican SD Senate   2015-01-06 2027-01-03 1 N00035187 ["S4SD00049"] 412669 02288 7455 S381 Mike Rounds Mike Rounds 1954-10-24 M 3   10 437 253 4166 7570218
M000355 Mitch McConnell Mitch McConnell   Republican KY Senate   1985-01-03 2027-01-03 1 N00003389 ["S2KY00012"] 300072 01395 53298 S174 Mitch McConnell Mitch McConnell 1942-02-20 M 8   0 15935 309 9287 42685689
M001111 Patty Murray Patty Murray   Democrat WA Senate   1993-01-05 2029-01-03 1 N00007876 ["S2WA00189"] 300076 01409 53358 S229 Patty Murray Patty Murray 1950-10-11 F 7   161 3339 541 9287 30543004
R000618 Pete Ricketts Pete Ricketts   Republican NE Senate   2023-01-23 2027-01-03 1 N00027695 ["S6NE00129"] 456952   57777 S423 Pete Ricketts Pete Ricketts 1964-08-19 M 1   30 124 72 1396 2199600
W000800 Peter Welch Peter Welch   Democrat VT Senate   2007-01-04 2029-01-03 1 N00000515 ["H6VT00160", "H8VT00034", "S2VT00235"] 412239 01879 51272 S422 Peter Welch Peter Welch 1947-05-02 M 4   167 1025 436 11595 4873070
P000603 Rand Paul Rand Paul   Republican KY Senate   2011-01-05 2029-01-03 1 N00030836 ["S0KY00156"] 412492 02082 117285 S348 Rand Paul Rand Paul 1963-01-07 M 4   1 1215 452 5309 9835595
W000790 Raphael Warnock Raphael G. Warnock   Democrat GA Senate   2021-01-20 2029-01-03 1 N00046489 ["S0GA00559"] 456858   189794 S415 Raphael Warnock Raphael Warnock 1969-07-23 M 2   0 211 112 2343 232478100
B001277 Richard Blumenthal Richard Blumenthal   Democrat CT Senate   2011-01-05 2029-01-03 1 N00031685 ["S0CT00177"] 412490 02076 1568 S341 Richard Blumenthal Richard Blumenthal 1946-02-13 M 4   0 1416 665 5309 8467088
D000563 Richard Durbin Richard J. Durbin   Democrat IL Senate   1983-01-03 2027-01-03 1 N00004981 ["S6IL00151", "H2IL20026"] 300038 00326 26847 S253 Dick Durbin Dick Durbin 1944-11-21 M 8   0 13210 994 9287 5891828
S001217 Rick Scott Rick Scott   Republican FL Senate   2019-01-08 2031-01-03 1 N00043290 ["S8FL00273"] 412838   124204 S404 Rick Scott Rick Scott 1952-12-01 M 3   397 532 421 3065 44718792
W000437 Roger Wicker Roger F. Wicker   Republican MS Senate   1995-01-04 2031-01-03 1 N00003280 ["H4MS01078", "S8MS00196"] 400432 01226 21926 S318 Roger Wicker Roger Wicker 1951-07-05 M 7   10 1181 400 9759 8697001
M001198 Roger Marshall Roger Marshall   Republican KS Senate   2017-01-03 2027-01-03 1 N00037034 ["H6KS01179", "S0KS00315"] 412704   172080 S411 Roger Marshall Roger Marshall 1960-08-09 M 2   156 666 228 4506 30752495
J000293 Ron Johnson Ron Johnson   Republican WI Senate   2011-01-05 2029-01-03 1 N00032546 ["S0WI00197"] 412496 02086 126217 S345 Ron Johnson Ron Johnson (Wisconsin) 1955-04-08 M 4   2 629 192 5309 82015908
W000779 Ron Wyden Ron Wyden   Democrat OR Senate   1981-01-05 2029-01-03 1 N00007724 ["S6OR00110", "H0OR03026"] 300100 01247 27036 S247 Ron Wyden Ron Wyden 1949-05-03 M 9   321 3477 818 9287 10156894
G000574 Ruben Gallego Ruben Gallego   Democrat AZ Senate   2015-01-06 2031-01-03 1 N00036097 ["H4AZ07043", "S4AZ00139"] 412612 02226 123732 S432 Ruben Gallego Ruben Gallego 1979-11-20 M 3   2 280 165 5881 53669548
W000802 Sheldon Whitehouse Sheldon Whitehouse   Democrat RI Senate   2007-01-04 2031-01-03 1 N00027533 ["S6RI00221"] 412247 01823 2572 S316 Sheldon Whitehouse Sheldon Whitehouse 1955-10-20 M 5   1010 2396 470 6662 4294894
C001047 Shelley Capito Shelley Moore Capito   Republican WV Senate   2001-01-03 2027-01-03 1 N00009771 ["H0WV02138", "S4WV00159"] 400061 01676 11701 S372 Shelley Moore Capito Shelley Moore Capito 1953-11-26 F 5   731 1072 279 12859 10570792
D000618 Steve Daines Steve Daines   Republican MT Senate   2013-01-03 2027-01-03 1 N00033054 ["H2MT01060", "S2MT00096"] 412549 02138 135720 S375 Steve Daines Steve Daines 1962-08-20 M 3   2 1253 363 5370 66786456
C001035 Susan Collins Susan M. Collins   Republican ME Senate   1997-01-07 2027-01-03 1 N00000491 ["S6ME00159"] 300025 01541 379 S252 Susan Collins Susan Collins 1952-12-07 F 6   635 3255 580 9287 74808480
B001230 Tammy Baldwin Tammy Baldwin   Democrat WI Senate   1999-01-06 2031-01-03 1 N00004367 ["H8WI00018", "S2WI00219"] 400013 01558 3470 S354 Tammy Baldwin Tammy Baldwin 1962-02-11 F 6   0 1054 482 12312 100365432
D000622 Tammy Duckworth Tammy Duckworth   Democrat IL Senate   2013-01-03 2029-01-03 1 N00027860 ["H6IL06141", "S6IL00292"] 412533 02123 57442 S386 Tammy Duckworth Tammy Duckworth 1968-03-12 F 3   44 481 362 6193 14162758
B001305 Ted Budd Ted Budd   Republican NC Senate   2017-01-03 2029-01-03 1 N00039551 ["H6NC13129", "S2NC00505"] 412712   171489 S417 Ted Budd Ted Budd 1971-10-21 M 3   0 336 200 4006 48357134
C001098 Ted Cruz Ted Cruz   Republican TX Senate   2013-01-03 2031-01-03 1 N00033085 ["S2TX00312"] 412573 02175 135705 S355 Ted Cruz Ted Cruz 1970-12-22 M 4   0 969 568 4823 32805635
T000476 Thom Tillis Thom Tillis   Republican NC Senate   2015-01-06 2027-01-03 1 N00035492 ["S4NC00162"] 412668 02291 57717 S384 Thom Tillis Thom Tillis (North Carolina) 1960-08-30 M 3   102 912 219 4166 158483777
K000384 Timothy Kaine Tim Kaine Tim Democrat VA Senate   2013-01-03 2031-01-03 1 N00033177 ["S2VA00142"] 412582 02176 50772 S362 Tim Kaine Tim Kaine 1958-02-26 M 4   3 1068 288 4823 39018557
S001184 Tim Scott Tim Scott   Republican SC Senate   2011-01-05 2029-01-03 1 N00031782 ["H0SC01279", "S4SC00240"] 412471 02056 11940 S365 Tim Scott Tim Scott 1965-09-19 M 4   0 444 299 6428 15514281
S001232 Tim Sheehy Tim Sheehy   Republican MT Senate   2025-01-03 2031-01-03 1 N00053174 ["S4MT00183"] 456966     S435 Tim Sheehy (American politician)   1985-11-18 M 2   0 26 50 705 85141758
S001203 Tina Smith Tina Smith   Democrat MN Senate   2018-01-03 2027-01-03 1 N00042353 ["S8MN00578"] 412742   152968 S394 Tina Smith Tina Smith 1958-03-04 F 2   41 307 271 3339 8298420
Y000064 Todd Young Todd Young   Republican IN Senate   2011-01-05 2029-01-03 1 N00030670 ["H0IN09070", "S6IN00191"] 412428 02019 120345 S391 Todd Young Todd Young 1972-08-24 M 4   0 468 270 7798 31034448
C001095 Tom Cotton Tom Cotton   Republican AR Senate   2013-01-03 2027-01-03 1 N00033363 ["H2AR04083", "S4AR00103"] 412508 02098 135651 S374 Tom Cotton Tom Cotton 1977-05-13 M 3   0 694 353 5370 28661576
T000278 Tommy Tuberville Tommy Tuberville   Republican AL Senate   2021-01-03 2027-01-03 1 N00044434 ["S0AL00230"] 456796   188306 S412 Tommy Tuberville Tommy Tuberville 1954-09-18 M 2   1444 520 71 2345 3180677

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE congress_members (
    bioguide_id TEXT PRIMARY KEY,
    first_name TEXT,
    last_name TEXT,
    full_name TEXT,
    nickname TEXT,
    party TEXT,
    state TEXT,
    chamber TEXT,
    district INTEGER,
    first_served TEXT,
    last_served TEXT,
    is_current INTEGER,
    opensecrets_id TEXT,
    fec_ids TEXT,
    govtrack_id INTEGER,
    thomas_id TEXT,
    votesmart_id INTEGER,
    lis_id TEXT,
    wikipedia_id TEXT,
    ballotpedia_id TEXT,
    birthday TEXT,
    gender TEXT,
    terms_count INTEGER,
    served_until TEXT
, trade_count INTEGER DEFAULT 0, speech_count INTEGER DEFAULT 0, bills_sponsored INTEGER DEFAULT 0, vote_count INTEGER DEFAULT 0, fec_total_received INTEGER DEFAULT 0);
CREATE INDEX idx_cm_name ON congress_members(last_name, first_name);
CREATE INDEX idx_cm_party ON congress_members(party);
CREATE INDEX idx_cm_state ON congress_members(state);
CREATE INDEX idx_cm_chamber ON congress_members(chamber);
CREATE INDEX idx_cm_current ON congress_members(is_current);
CREATE INDEX idx_cm_current_trades ON congress_members(is_current DESC, trade_count DESC);