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

438 rows where chamber = "House" and is_current = 1 sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

state >30

party 2

is_current 1

chamber 1

  • House · 438 ✖
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
G000605 Adam Gray Adam Gray   Democrat CA House 13 2025-01-03 2027-01-03 1 N00050061 ["H2CA13115"] 456975       Adam Gray   1977-09-23 M 2   0 10 7 445 22104963
S000510 Adam Smith Adam Smith   Democrat WA House 9 1997-01-07 2027-01-03 1 N00007833 ["H6WA09025"] 400379 01528 845   Adam Smith (Washington politician) Adam Smith 1965-06-15 M 16   18 716 182 14314 5979737
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
G000606 Adelita Grijalva Adelita S. Grijalva   Democrat AZ House 7 2025-11-12 2027-01-03 1   ["H6AZ07121"] 457037       Adelita Grijalva Adelita Grijalva 1970-10-30 F 2   0 15 4 163 851360
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
E000297 Adriano Espaillat Adriano Espaillat   Democrat NY House 13 2017-01-03 2027-01-03 1 N00034549 ["H2NY13096"] 412718   14379   Adriano Espaillat Adriano Espaillat 1954-09-27 M 6   0 302 227 4296 1999157
G000553 Al Green Al Green   Democrat TX House 9 2005-01-04 2027-01-03 1 N00026686 ["H4TX09095"] 400653 01803 49680   Al Green (politician) Al Green 1947-09-01 M 12   1 1084 329 13094 1379758
O000172 Alexandria Ocasio-Cortez Alexandria Ocasio-Cortez   Democrat NY House 14 2019-01-03 2027-01-03 1 N00041162 ["H8NY15148"] 412804   180416   Alexandria Ocasio-Cortez Alexandria Ocasio-Cortez 1989-10-13 F 5   0 102 58 3087 1230858
A000370 Alma Adams Alma S. Adams   Democrat NC House 12 2014-11-12 2027-01-03 1 N00035451 ["H4NC12100"] 412607 02201 5935   Alma Adams Alma Adams 1946-05-27 F 7   0 251 169 5669 3586318
B001287 Ami Bera Ami Bera   Democrat CA House 6 2013-01-03 2027-01-03 1 N00030717 ["H0CA03078"] 412512 02102 120030   Ami Bera Ami Bera 1965-03-02 M 8   0 175 107 6825 23255736
S001226 Andrea Salinas Andrea Salinas   Democrat OR House 6 2023-01-03 2027-01-03 1 N00049738 ["H2OR06066"] 456934   178196   Andrea Salinas Andrea Salinas 1969-12-06 F 3   0 70 52 1686 7564931
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
C001072 André Carson André Carson   Democrat IN House 7 2008-03-13 2027-01-03 1 N00029513 ["H8IN07184"] 412258 01889 84917   André Carson Andre Carson 1974-10-16 M 10   0 476 164 10637 4314782
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
C001119 Angie Craig Angie Craig   Democrat MN House 2 2019-01-03 2027-01-03 1 N00037039 ["H6MN02131"] 412789   166261   Angie Craig Angie Craig 1972-02-14 F 5   2 152 110 3087 25779787
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
M001232 April McClain Delaney April McClain Delaney   Democrat MD House 6 2025-01-03 2027-01-03 1 N00053899 ["H4MD06340"] 456993       April McClain-Delaney   1964-05-28 F 2   178 0 19 445 941563
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
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
P000617 Ayanna Pressley Ayanna Pressley   Democrat MA House 7 2019-01-03 2027-01-03 1 N00042581 ["H8MA07032"] 412782   122700   Ayanna Pressley Ayanna Pressley 1974-02-03 F 5   0 166 131 3087 822700
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
B001318 Becca Balint Becca Balint   Democrat VT House 0 2023-01-03 2027-01-03 1 N00049900 ["H2VT01076"] 456948   154056   Becca Balint Becca Balint 1968-05-04 F 3   0 83 40 1686 2327534
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
T000193 Bennie Thompson Bennie G. Thompson   Democrat MS House 2 1993-04-13 2027-01-03 1 N00003288 ["H4MS02068"] 400402 01151 26929   Bennie Thompson Bennie Thompson 1948-01-28 M 18   0 2198 202 14314 7583027
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
M001143 Betty McCollum Betty McCollum   Democrat MN House 4 2001-01-03 2027-01-03 1 N00012942 ["H0MN04049"] 400259 01653 3812   Betty McCollum Betty McCollum 1954-07-12 F 14   0 1476 151 14314 5008002
F000454 Bill Foster Bill Foster   Democrat IL House 11 2008-03-08 2027-01-03 1 N00029139 ["H8IL14067", "H2IL11124"] 412257 01888 101632   Bill Foster (politician) Bill Foster 1955-10-07 M 10   0 387 247 9055 13298078
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
W000822 Bonnie Watson Coleman Bonnie Watson Coleman   Democrat NJ House 12 2015-01-06 2027-01-03 1 N00036158 ["H4NJ12149"] 412644 02259 24799   Bonnie Watson Coleman   1945-02-06 F 7   0 281 187 5621 2974117
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
S000344 Brad Sherman Brad Sherman   Democrat CA House 32 1997-01-07 2027-01-03 1 N00006897 ["H6CA24113"] 400371 01526 142   Brad Sherman Brad Sherman 1954-10-24 M 16   14 998 177 14314 7943902
S001190 Bradley Schneider Bradley Scott Schneider Brad Democrat IL House 10 2013-01-03 2027-01-03 1 N00033101 ["H2IL10068"] 412534 02124 134948   Brad Schneider Brad Schneider 1961-08-20 M 8   141 404 205 5500 18995638
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
B001296 Brendan Boyle Brendan F. Boyle   Democrat PA House 2 2015-01-06 2027-01-03 1 N00035307 ["H4PA13199"] 412652 02267 47357   Brendan Boyle Brendan Boyle 1977-02-06 M 7   0 245 125 5621 6493523
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
P000620 Brittany Pettersen Brittany Pettersen   Democrat CO House 7 2023-01-03 2027-01-03 1 N00040878 ["H8CO07045"] 456886   138744   Brittany Pettersen   1981-12-06 F 3   0 579 48 1686 3498247
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
P000597 Chellie Pingree Chellie Pingree   Democrat ME House 1 2009-01-06 2027-01-03 1 N00013817 ["H8ME01120", "S0ME00038"] 412307 01927 6586   Chellie Pingree Chellie Pingree 1955-04-02 F 10   28 333 169 10085 2255756
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
P000614 Chris Pappas Chris Pappas   Democrat NH House 1 2019-01-03 2027-01-03 1 N00042161 ["H8NH01210"] 412795   42635   Chris Pappas (American politician) Chris Pappas 1980-06-04 M 5   0 256 157 3087 14875094
H001085 Chrissy Houlahan Chrissy Houlahan   Democrat PA House 6 2019-01-03 2027-01-03 1 N00040949 ["H8PA06087"] 412810   178893   Chrissy Houlahan Chrissy Houlahan 1967-06-05 F 5   0 114 96 3087 5459127
M001245 Christian Menefee Christian Menefee   Democrat TX House 18 2026-02-02 2027-01-03 1   ["H6TX18232"] 457039       Christian Menefee Christian Menefee 1988-04-18 M 1   0 0 0 34 103250
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
D000530 Chris Deluzio Christopher R. Deluzio   Democrat PA House 17 2023-01-03 2027-01-03 1 N00049160 ["H2PA17103"] 456936   202954   Chris Deluzio   1984-07-13 M 3   0 56 46 1686 11446238
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
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
F000110 Cleo Fields Cleo Fields   Democrat LA House 6 1993-01-05 2027-01-03 1 N00005398 ["H4LA06211"] 404067 00379     Cleo Fields   1962-11-22 M 18   219 102 5 445 521209
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
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
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
G000599 Dan Goldman Daniel S. Goldman   Democrat NY House 10 2023-01-03 2027-01-03 1 N00051424 ["H2NY10308"] 456923   208627   Dan Goldman Daniel Goldman 1976-02-26 M 3   1307 82 51 1686 967551
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
D000096 Danny Davis Danny K. Davis   Democrat IL House 7 1997-01-07 2027-01-03 1 N00004884 ["H4IL07037"] 400093 01477 233   Danny Davis (Illinois politician) Danny K. Davis 1941-09-06 M 16   0 2500 343 14314 4498689
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
S001200 Darren Soto Darren Soto   Democrat FL House 9 2017-01-03 2027-01-03 1 N00037422 ["H6FL09179"] 412695   67618   Darren Soto Darren Soto 1978-02-25 M 6   0 522 134 4296 6668974
M001241 Dave Min Dave Min   Democrat CA House 47 2025-01-03 2027-01-03 1 N00040866 ["H4CA47085"] 456981       Dave Min   1976-03-05 M 2   2 24 15 445 14290785
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
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
S001157 David Scott David Scott   Democrat GA House 13 2003-01-07 2027-01-03 1 N00024871 ["H2GA13012"] 400363 01722 7826   David Scott (Georgia politician) David Scott (Georgia) 1945-06-27 M 13   0 514 115 14314 9052261
D000624 Debbie Dingell Debbie Dingell   Democrat MI House 6 2015-01-06 2027-01-03 1 N00036149 ["H4MI12079"] 412637 02251 152482   Debbie Dingell Debbie Dingell 1953-11-23 F 7   233 873 240 5621 5102910
W000797 Debbie Wasserman Schultz Debbie Wasserman Schultz   Democrat FL House 25 2005-01-04 2027-01-03 1 N00026106 ["H4FL20023"] 400623 01777 24301   Debbie Wasserman Schultz Debbie Wasserman Schultz 1966-09-27 F 12   114 878 159 13094 6704770
R000305 Deborah Ross Deborah K. Ross   Democrat NC House 2 2021-01-03 2027-01-03 1 N00038565 ["H0NC02125"] 456831       Deborah Ross (politician) Deborah Ross 1963-06-20 F 4   28 136 69 2135 2113323
R000617 Delia Ramirez Delia C. Ramirez   Democrat IL House 3 2023-01-03 2027-01-03 1 N00049548 ["H2IL03162"] 456900   177128   Delia Ramirez Delia Ramirez 1983-06-02 F 3   0 113 37 1686 2456556
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
T000491 Derek Tran Derek Tran   Democrat CA House 45 2025-01-03 2027-01-03 1 N00053582 ["H4CA45170"] 456980       Derek Tran   1980-12-22 M 2   0 24 10 445 18446102
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
D000197 Diana DeGette Diana DeGette   Democrat CO House 1 1997-01-07 2027-01-03 1 N00006134 ["H6CO01141"] 400101 01479 561   Diana DeGette Diana DeGette 1957-07-29 F 16   0 635 191 14314 5594348

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