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

274 rows where is_current = 1 and party = "Republican" 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

chamber 2

party 1

  • Republican · 274 ✖

is_current 1

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
B001314 Aaron Bean Aaron Bean   Republican FL House 4 2023-01-03 2027-01-03 1 N00051369 ["H2FL04211"] 456888   53932   Aaron Bean Aaron Bean 1967-01-25 M 3   0 137 40 1686 3394546
H001098 Abraham Hamadeh Abraham J. Hamadeh   Republican AZ House 8 2025-01-03 2027-01-03 1 N00053795 ["H4AZ08108"] 456973       Abraham Hamadeh   1991-05-15 M 2   0 6 21 445 1475208
M001240 Addison McDowell Addison P. McDowell   Republican NC House 6 2025-01-03 2027-01-03 1 N00054055 ["H4NC06177"] 457001       Addison McDowell   1994-01-21 M 2   0 23 13 445 752221
S001172 Adrian Smith Adrian Smith   Republican NE House 3 2007-01-04 2027-01-03 1 N00027623 ["H6NE03115"] 412217 01860 21284   Adrian Smith (politician) Adrian Smith 1970-12-19 M 11   9 482 131 11886 8384271
O000175 Andrew Ogles Andrew Ogles   Republican TN House 5 2023-01-03 2027-01-03 1 N00050943 ["H2TN05446"] 456939   48673   Andy Ogles Andy Ogles 1971-06-18 M 3   0 68 118 1686 3110291
G000597 Andrew Garbarino Andrew R. Garbarino   Republican NY House 2 2021-01-03 2027-01-03 1 N00046030 ["H0NY02234"] 456836       Andrew Garbarino   1984-09-27 M 4   16 50 89 2135 12272948
C001116 Andrew Clyde Andrew S. Clyde   Republican GA House 9 2021-01-03 2027-01-03 1 N00046654 ["H0GA09246"] 456813       Andrew Clyde   1963-11-22 M 4   0 186 64 2135 1789701
B001282 Garland Barr Andy Barr Andy Republican KY House 6 2013-01-03 2027-01-03 1 N00031233 ["H0KY06104"] 412541 02131 117290   Andy Barr (American politician) Andy Barr 1973-07-24 M 8   4 523 202 6825 16547296
B001302 Andy Biggs Andy Biggs   Republican AZ House 5 2017-01-03 2027-01-03 1 N00039293 ["H6AZ05083"] 412683   28088   Andy Biggs Andy Biggs 1958-11-07 M 6   0 325 889 4296 1418051
H001052 Andy Harris Andy Harris   Republican MD House 1 2011-01-05 2027-01-03 1 N00029147 ["H8MD01094"] 412434 02026 19157   Andy Harris (politician) Andrew Harris 1957-01-25 M 9   1 258 40 8430 6338416
W000812 Ann Wagner Ann Wagner   Republican MO House 2 2013-01-03 2027-01-03 1 N00033106 ["H2MO02102"] 412548 02137 136083   Ann Wagner Ann Wagner 1962-09-13 F 8   68 325 120 6825 17390196
L000596 Anna Luna Anna Paulina Luna   Republican FL House 13 2023-01-03 2027-01-03 1 N00045228 ["H0FL13158"] 456891   191344   Anna Paulina Luna Anna Paulina Luna 1989-05-06 F 3   4 35 64 1686 9326703
H001091 Ashley Hinson Ashley Hinson   Republican IA House 2 2021-01-03 2027-01-03 1 N00044521 ["H0IA01174"] 456816   168783   Ashley Hinson Ashley Hinson 1983-06-27 F 4   14 65 84 2135 11082438
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
P000048 August Pfluger August Pfluger   Republican TX House 11 2021-01-03 2027-01-03 1 N00045421 ["H0TX11230"] 456846       August Pfluger   1978-12-28 M 4   27 143 147 2135 2900029
R000600 Aumua Amata Radewagen Aumua Amata Coleman Radewagen   Republican AS House 0 2015-01-06 2027-01-03 1 N00007635 ["H4AS00036"] 412664 02222 128380   Amata Coleman Radewagen Amata Radewagen 1947-12-29 F 7   0 81 41 905 189905
S001189 Austin Scott Austin Scott   Republican GA House 8 2011-01-05 2027-01-03 1 N00032457 ["H0GA08099"] 412417 02009 11812   Austin Scott (politician) Austin Scott 1969-12-10 M 9   114 240 72 8430 4818423
L000583 Barry Loudermilk Barry Loudermilk   Republican GA House 11 2015-01-06 2027-01-03 1 N00035347 ["H4GA11061"] 412624 02238 31618   Barry Loudermilk Barry Loudermilk 1963-12-22 M 7   0 170 72 5621 3340535
M001212 Barry Moore Barry Moore   Republican AL House 1 2021-01-03 2027-01-03 1 N00041295 ["H8AL02171"] 456800   121792   Barry Moore (American politician) Barry Moore (Alabama) 1966-09-26 M 4   8 91 56 2135 3405379
C001118 Ben Cline Ben Cline   Republican VA House 6 2019-01-03 2027-01-03 1 N00042296 ["H8VA06104"] 412832   50959   Ben Cline Ben Cline 1972-02-29 M 5   0 271 51 3087 1815038
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
V000134 Beth Van Duyne Beth Van Duyne   Republican TX House 24 2021-01-03 2027-01-03 1 N00045167 ["H0TX24209"] 456850   79150   Beth Van Duyne Beth Van Duyne 1970-11-16 F 4   0 325 101 2135 11756779
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
H001058 Bill Huizenga Bill Huizenga   Republican MI House 4 2011-01-05 2027-01-03 1 N00030673 ["H0MI02094"] 412437 02028 38351   Bill Huizenga Bill Huizenga 1969-01-31 M 9   1 429 142 8430 9481822
M001213 Blake Moore Blake D. Moore   Republican UT House 1 2021-01-03 2027-01-03 1 N00046598 ["H0UT01205"] 456851       Blake Moore   1980-06-22 M 4   152 132 82 2135 3435182
F000475 Brad Finstad Brad Finstad   Republican MN House 1 2022-08-12 2027-01-03 1 N00050649 ["H2MN01223"] 456869   38612   Brad Finstad Brad Finstad 1976-05-30 M 3   0 43 56 1686 4600597
K000405 Brad Knott Brad Knott   Republican NC House 13 2025-01-03 2027-01-03 1 N00053743 ["H4NC13116"] 457004       Brad Knott   1986-04-17 M 2   3 9 3 445 2648577
G000603 Brandon Gill Brandon Gill   Republican TX House 26 2025-01-03 2027-01-03 1 N00054402 ["H4TX26149"] 457023       Brandon Gill   1994-02-26 M 2   23 28 20 445 3569810
G000558 Brett Guthrie Brett Guthrie   Republican KY House 2 2009-01-06 2027-01-03 1 N00029675 ["H8KY02031"] 412278 01922 18829   Brett Guthrie Brett Guthrie 1964-02-18 M 10   1 498 133 10085 13539361
B001291 Brian Babin Brian Babin   Republican TX House 36 2015-01-06 2027-01-03 1 N00005736 ["H6TX02079"] 412655 02270 360   Brian Babin Brian Babin 1948-03-23 M 7   8 449 89 5621 3434041
M001199 Brian Mast Brian J. Mast   Republican FL House 21 2017-01-03 2027-01-03 1 N00037269 ["H6FL18097"] 412698   166245   Brian Mast Brian Mast 1980-07-10 M 6   99 148 138 4296 7241097
J000311 Brian Jack Brian Jack   Republican GA House 3 2025-01-03 2027-01-03 1 N00055118 ["H4GA03126"] 456987       Brian Jack   1988-02-17 M 2   0 11 7 445 3857225
F000466 Brian Fitzpatrick Brian K. Fitzpatrick   Republican PA House 1 2017-01-03 2027-01-03 1 N00038779 ["H6PA08277"] 412721   167708   Brian Fitzpatrick (American politician) Brian Fitzpatrick 1973-12-17 M 6   0 563 234 4296 28363525
W000821 Bruce Westerman Bruce Westerman   Republican AR House 4 2015-01-06 2027-01-03 1 N00035527 ["H4AR04048"] 412610 02224 119120   Bruce Westerman Bruce Westerman 1967-11-18 M 7   213 540 74 5621 5255585
S001213 Bryan Steil Bryan Steil   Republican WI House 1 2019-01-03 2027-01-03 1 N00043379 ["H8WI01156"] 412836   181289   Bryan Steil Bryan Steil 1981-03-30 M 5   14 183 86 3087 7503615
O000086 Clarence Owens Burgess Owens Burgess Republican UT House 4 2021-01-03 2027-01-03 1 N00045812 ["H0UT04076"] 456852   191166   Burgess Owens Burgess Owens 1951-08-02 M 4   0 101 53 2135 9536742
D000032 Byron Donalds Byron Donalds   Republican FL House 19 2021-01-03 2027-01-03 1 N00034016 ["H2FL14186"] 456808   137655   Byron Donalds Byron Donalds 1978-10-28 M 4   142 57 136 2135 3751624
G000593 Carlos Gimenez Carlos A. Gimenez   Republican FL House 28 2021-01-03 2027-01-03 1 N00046394 ["H0FL26036"] 456809   81366   Carlos A. Giménez Carlos Gimenez 1954-01-17 M 4   0 98 53 2135 10480026
M001205 Carol Miller Carol D. Miller   Republican WV House 1 2019-01-03 2027-01-03 1 N00041542 ["H8WV03097"] 412837   52123   Carol Miller (politician) Carol Miller (West Virginia) 1950-11-04 F 5   119 97 94 3087 5548682
M001228 Celeste Maloy Celeste Maloy   Republican UT House 2 2023-11-21 2027-01-03 1 N00052817 ["H4UT02296"] 456956   212289   Celeste Maloy Celeste Maloy 1981-05-22 F 3   0 21 36 1010 1366834
F000459 Charles Fleischmann Charles J. "Chuck" Fleischmann Chuck Republican TN House 3 2011-01-05 2027-01-03 1 N00030815 ["H0TN03254"] 412476 02061 123456   Chuck Fleischmann Charles Fleischmann 1962-10-11 M 9   89 158 45 8430 4701576
R000614 Chip Roy Chip Roy   Republican TX House 21 2019-01-03 2027-01-03 1 N00042268 ["H8TX21307"] 412826   177319   Chip Roy Chip Roy 1972-08-07 M 5   8 479 166 3087 9519748
S000522 Christopher Smith Christopher H. Smith Chris Republican NJ House 4 1981-01-05 2027-01-03 1 N00009816 ["H8NJ04014"] 400380 01071 26952   Chris Smith (New Jersey politician) Chris Smith (New Jersey) 1953-03-04 M 24   0 2073 536 14314 3070105
E000246 Charles (Chuck) Edwards Chuck Edwards   Republican NC House 11 2023-01-03 2027-01-03 1 N00049670 ["H2NC14050"] 456914   166600   Chuck Edwards   1960-09-13 M 3   0 134 41 1686 1405486
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
T000478 Claudia Tenney Claudia Tenney   Republican NY House 24 2017-01-03 2027-01-03 1 N00036351 ["H4NY22051"] 412720   127668   Claudia Tenney Claudia Tenney 1961-02-04 F 6   0 294 200 3313 25814723
H001077 Clay Higgins Clay Higgins   Republican LA House 3 2017-01-03 2027-01-03 1 N00039953 ["H6LA03148"] 412705   174484   Clay Higgins Clay Higgins 1961-08-24 M 6   0 163 147 4296 1519025
B000668 Cliff Bentz Cliff Bentz   Republican OR House 2 2021-01-03 2027-01-03 1 N00045773 ["H0OR02127"] 456842       Cliff Bentz   1952-01-12 M 4   5 77 21 2135 1841533
M001216 Cory Mills Cory Mills   Republican FL House 7 2023-01-03 2027-01-03 1 N00048179 ["H2FL07156"] 456889   209085   Cory Mills   1980-07-30 M 3   0 27 38 1686 489035
G000601 Craig Goldman Craig A. Goldman   Republican TX House 12 2025-01-03 2027-01-03 1 N00053861 ["H4TX12065"] 457021       Craig Goldman   1968-10-03 M 2   0 31 8 445 2683811
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
S001220 Dale Strong Dale W. Strong   Republican AL House 5 2023-01-03 2027-01-03 1 N00048145 ["H2AL05102"] 456878   81485   Dale Strong Dale Strong 1970-05-08 M 3   0 33 26 1686 2228170
C001120 Dan Crenshaw Dan Crenshaw   Republican TX House 2 2019-01-03 2027-01-03 1 N00042224 ["H8TX02166"] 412820   177270   Dan Crenshaw Daniel Crenshaw 1984-03-14 M 5   33 66 90 3087 5952727
N000189 Dan Newhouse Dan Newhouse   Republican WA House 4 2015-01-06 2027-01-03 1 N00036403 ["H4WA04104"] 412660 02275 51522   Dan Newhouse Dan Newhouse 1955-07-10 M 7   181 398 150 5621 7842638
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
M001204 Daniel Meuser Daniel Meuser   Republican PA House 9 2019-01-03 2027-01-03 1 N00029416 ["H8PA10147"] 412811   102438   Dan Meuser Dan Meuser 1964-02-10 M 5   76 269 61 3087 2642730
W000806 Daniel Webster Daniel Webster   Republican FL House 11 2011-01-05 2027-01-03 1 N00026335 ["H0FL08208", "S4FL00256"] 412410 02002 24302   Daniel Webster (Florida politician) Daniel Webster 1949-04-27 M 9   0 304 52 8430 5359132
L000585 Darin LaHood Darin LaHood   Republican IL House 16 2015-09-17 2027-01-03 1 N00037031 ["H6IL18088"] 412674 02295 128760   Darin LaHood Darin LaHood 1968-07-05 M 7   1 346 133 5125 10031850
I000056 Darrell Issa Darrell Issa   Republican CA House 48 2001-01-03 2027-01-03 1 N00007017 ["H0CA48024", "S8CA00135"] 400196 01640 16553   Darrell Issa Darrell Issa 1953-11-01 M 14   20 757 350 13362 7217834
V000129 David Valadao David G. Valadao   Republican CA House 22 2013-01-03 2027-01-03 1 N00033367 ["H2CA20094"] 412515 02105 120200   David Valadao David G. Valadao 1977-04-14 M 8   0 373 79 5865 41996396
T000490 David Taylor David J. Taylor   Republican OH House 2 2025-01-03 2027-01-03 1 N00054098 ["H4OH02248"] 457014       David Taylor (Ohio politician)   1969-11-16 M 2   128 28 27 445 477167
K000392 David Kustoff David Kustoff   Republican TN House 8 2017-01-03 2027-01-03 1 N00025445 ["H2TN07103"] 412724   48997   David Kustoff David Kustoff 1966-10-08 M 6   27 110 104 4296 4198184
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
J000295 David Joyce David P. Joyce   Republican OH House 14 2013-01-03 2027-01-03 1 N00035007 ["H2OH14064"] 412566 02154 143052   David Joyce (politician) David Joyce 1957-03-17 M 8   173 110 131 6825 10191451
R000603 David Rouzer David Rouzer   Republican NC House 7 2015-01-06 2027-01-03 1 N00033527 ["H2NC07096"] 412641 02256 102964   David Rouzer David Rouzer 1972-02-16 M 7   19 160 93 5621 8112382
S001183 David Schweikert David Schweikert   Republican AZ House 1 2011-01-05 2027-01-03 1 N00006460 ["H4AZ06045", "H8AZ05097"] 412399 01994 106387   David Schweikert David Schweikert 1962-03-03 M 9   0 403 158 8430 30210342
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
S001228 Derek Schmidt Derek Schmidt   Republican KS House 2 2025-01-03 2027-01-03 1 N00055179 ["H4KS02164"] 456990       Derek Schmidt   1968-01-23 M 2   0 15 11 445 1059391
V000135 Derrick Van Orden Derrick Van Orden   Republican WI House 3 2023-01-03 2027-01-03 1 N00046843 ["H0WI03175"] 456950   192343   Derrick Van Orden Derrick Van Orden 1969-09-15 M 3   0 0 56 1686 11480960
H001086 Diana Harshbarger Diana Harshbarger   Republican TN House 1 2021-01-03 2027-01-03 1 N00046688 ["H0TN01118"] 456844   190524   Diana Harshbarger Diana Harshbarger 1960-01-01 F 4   21 134 64 2135 2447435
B001298 Don Bacon Don Bacon   Republican NE House 2 2017-01-03 2027-01-03 1 N00037049 ["H6NE02125"] 412713   166299   Don Bacon Don Bacon 1963-08-16 M 6   0 226 188 4296 34772951
J000301 Dusty Johnson Dusty Johnson   Republican SD House 0 2019-01-03 2027-01-03 1 N00040559 ["H8SD01055"] 412816   48307   Dusty Johnson Dusty Johnson 1976-09-30 M 5   0 157 132 3087 4032345
C001103 Earl Carter Earl L. "Buddy" Carter Buddy Republican GA House 1 2015-01-06 2027-01-03 1 N00035346 ["H4GA01039"] 412622 02236 32085   Buddy Carter Earl "Buddy" Carter 1957-09-06 M 7   44 1350 206 5621 7095136
C001132 Eli Crane Elijah Crane   Republican AZ House 2 2023-01-03 2027-01-03 1 N00048953 ["H2AZ01354"] 456879   205885   Eli Crane Eli Crane 1980-01-03 M 3   0 32 39 1686 3208671
S001196 Elise Stefanik Elise M. Stefanik   Republican NY House 21 2015-01-06 2027-01-03 1 N00035523 ["H4NY21079"] 412648 02263 152539   Elise Stefanik Elise Stefanik 1984-07-02 F 7   0 558 185 5621 8969662
C001087 Eric Crawford Eric A. "Rick" Crawford Rick Republican AR House 1 2011-01-05 2027-01-03 1 N00030770 ["H0AR01083"] 412400 01989 119208   Rick Crawford (politician) Rick Crawford 1966-01-22 M 9   0 267 125 8430 6298250
B001316 Eric Burlison Eric Burlison   Republican MO House 7 2023-01-03 2027-01-03 1 N00049123 ["H2MO07143"] 456910   104635   Eric Burlison Eric Burlison 1976-10-02 M 3   1 66 42 1686 2135923
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
H001093 Erin Houchin Erin Houchin   Republican IN House 9 2023-01-03 2027-01-03 1 N00037427 ["H6IN09143"] 456903   149614   Erin Houchin   1976-09-24 F 3   0 59 56 1686 3033640
L000491 Frank Lucas Frank D. Lucas   Republican OK House 3 1993-05-10 2027-01-03 1 N00005559 ["H4OK06056"] 400247 00711 27032   Frank Lucas (Oklahoma politician) Frank D. Lucas 1960-01-06 M 18   0 374 90 14314 7736959
E000300 Gabe Evans Gabe Evans   Republican CO House 8 2025-01-03 2027-01-03 1 N00053312 ["H4CO08034"] 456984       Gabe Evans   1986-07-28 M 2   0 16 19 445 14019694
P000609 Gary Palmer Gary J. Palmer   Republican AL House 6 2015-01-06 2027-01-03 1 N00035691 ["H4AL06098"] 412608 02221 146274   Gary Palmer (politician) Gary Palmer 1954-05-14 M 7   261 124 94 5621 2467124
G000576 Glenn Grothman Glenn Grothman   Republican WI House 6 2015-01-06 2027-01-03 1 N00036409 ["H4WI06048"] 412661 02276 3493   Glenn Grothman Glenn Grothman 1955-07-03 M 7   5 568 143 5621 2776053
T000467 Glenn Thompson Glenn Thompson   Republican PA House 15 2009-01-06 2027-01-03 1 N00029736 ["H8PA05071"] 412317 01952 24046   Glenn Thompson (politician) Glenn Thompson (Pennsylvania) 1959-07-27 M 10   0 2128 161 10085 6617548
M001210 Gregory Murphy Gregory F. Murphy   Republican NC House 3 2019-09-17 2027-01-03 1 N00044027 ["H0NC03172"] 412845   166135   Greg Murphy (politician) Gregory Murphy 1963-03-05 M 5   3 182 113 2556 3489159
B001257 Gus Bilirakis Gus M. Bilirakis   Republican FL House 12 2007-01-04 2027-01-03 1 N00027462 ["H6FL09070"] 412250 01838 17318   Gus Bilirakis Gus M. Bilirakis 1963-02-08 M 11   18 957 284 11886 6766246
R000610 Guy Reschenthaler Guy Reschenthaler   Republican PA House 14 2019-01-03 2027-01-03 1 N00041871 ["H8PA18199"] 412813   166004   Guy Reschenthaler Guy Reschenthaler 1983-04-17 M 5   6 170 56 3087 4343721
G000568 H. Griffith H. Morgan Griffith   Republican VA House 9 2011-01-05 2027-01-03 1 N00032029 ["H0VA09055"] 412485 02070 5148   Morgan Griffith Morgan Griffith 1958-03-15 M 9   0 413 194 8430 5301820
R000395 Harold Rogers Harold Rogers Hal Republican KY House 5 1981-01-05 2027-01-03 1 N00003473 ["H0KY05015"] 400340 00977 26875   Hal Rogers Harold Rogers 1937-12-31 M 24   147 863 76 14314 5301555
H001096 Harriet Hageman Harriet M. Hageman   Republican WY House 0 2023-01-03 2027-01-03 1 N00049197 ["H2WY00166"] 456951   182961   Harriet Hageman Harriet Hageman 1962-10-18 F 3   0 94 87 1686 2699545
H001072 J. Hill J. French Hill   Republican AR House 2 2015-01-06 2027-01-03 1 N00035792 ["H4AR02141"] 412609 02223 146290   French Hill (politician) French Hill 1956-12-05 M 7   64 648 134 5621 14543484
B001301 Jack Bergman Jack Bergman   Republican MI House 1 2017-01-03 2027-01-03 1 N00039533 ["H6MI01226"] 412709   170172   Jack Bergman Jack Bergman 1947-02-02 M 6   0 427 95 4296 6611717
E000071 Jake Ellzey Jake Ellzey   Republican TX House 6 2021-07-30 2027-01-03 1 N00042243 ["H8TX06266"] 456862       Jake Ellzey Jake Ellzey 1970-01-24 M 4   0 53 11 1881 2674255
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
M001219 James (Jim) Moylan James C. Moylan   Republican GU House 0 2023-01-03 2027-01-03 1 N00050604 ["H2GU01031"] 456896       James Moylan James Moylan 1962-07-18 M 3   0 95 54 589 90200
C001108 James Comer James Comer   Republican KY House 1 2016-11-14 2027-01-03 1 N00038260 ["H6KY01110"] 412676   35169   James Comer (politician) James Comer Jr. 1972-08-19 M 6   58 341 43 4343 3152114
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

Next page

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);