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

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

  • Democrat · 262 ✖

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
T000468 Dina Titus Dina Titus   Democrat NV House 1 2009-01-06 2027-01-03 1 N00030191 ["H8NV03036"] 412318 01940 2629   Dina Titus Dina Titus 1950-05-23 F 10   8 471 216 8480 19272839
D000230 Donald Davis Donald G. Davis   Democrat NC House 1 2023-01-03 2027-01-03 1 N00049636 ["H2NC02287"] 456912   102950   Don Davis (North Carolina politician) Donald Davis 1971-08-29 M 3   0 304 53 1686 8103105
N000188 Donald Norcross Donald Norcross   Democrat NJ House 1 2014-11-12 2027-01-03 1 N00036154 ["H4NJ01084"] 412606 02202 116277   Donald Norcross Donald Norcross 1958-12-13 M 7   1 275 98 5669 7432454
B001292 Donald Beyer Donald S. Beyer, Jr.   Democrat VA House 8 2015-01-06 2027-01-03 1 N00036018 ["H4VA08224"] 412657 02272 1707   Don Beyer Don Beyer 1950-06-20 M 7   972 333 217 5621 4744690
M001163 Doris Matsui Doris O. Matsui   Democrat CA House 7 2005-03-10 2027-01-03 1 N00027459 ["H6CA05195"] 400663 01814 28593   Doris Matsui Doris Matsui 1944-09-25 F 12   40 848 272 13037 6476964
E000296 Dwight Evans Dwight Evans   Democrat PA House 3 2016-11-14 2027-01-03 1 N00038450 ["H6PA02171"] 412677   9128   Dwight Evans (politician) Dwight Evans 1954-05-16 M 6   168 152 60 4343 2965387
C001055 Ed Case Ed Case   Democrat HI House 1 2003-01-07 2027-01-03 1 N00025882 ["H2HI02128"] 400069 01693 3422   Ed Case Ed Case 1952-09-27 M 13   10 274 126 5515 1660133
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
N000147 Eleanor Norton Eleanor Holmes Norton   Democrat DC House 0 1991-01-03 2027-01-03 1 N00001692 ["H0DC00058"] 400295 00868 775   Eleanor Holmes Norton Eleanor Holmes Norton 1937-06-13 F 19   29 2805 897 1697 1902115
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
C001061 Emanuel Cleaver Emanuel Cleaver   Democrat MO House 5 2005-01-04 2027-01-03 1 N00026790 ["H4MO05234"] 400639 01790 39507   Emanuel Cleaver Emanuel Cleaver 1944-10-26 M 12   0 551 212 13094 6985456
S001223 Emilia Sykes Emilia Strong Sykes   Democrat OH House 13 2023-01-03 2027-01-03 1 N00050165 ["H2OH13264"] 456930   152164   Emilia Sykes   1986-01-04 F 3   0 171 57 1686 19142755
R000621 Emily Randall Emily Randall   Democrat WA House 6 2025-01-03 2027-01-03 1 N00054078 ["H4WA06117"] 457030       Emily Randall   1985-10-30 F 2   11 46 10 445 3319039
S001225 Eric Sorensen Eric Sorensen   Democrat IL House 17 2023-01-03 2027-01-03 1 N00049558 ["H2IL17147"] 456902   204339   Eric Sorensen (politician)   1976-03-18 M 3   0 49 20 1686 11599688
S001193 Eric Swalwell Eric Swalwell   Democrat CA House 14 2013-01-03 2027-01-03 1 N00033508 ["H2CA15094"] 412514 02104 129529   Eric Swalwell Eric Swalwell 1980-11-16 M 8   4 416 100 6825 4782338
V000138 Eugene Vindman Eugene Simon Vindman   Democrat VA House 7 2025-01-03 2027-01-03 1 N00054112 ["H4VA07234"] 457027       Eugene Vindman   1975-06-06 M 2   0 74 49 445 7817487
M001214 Frank Mrvan Frank J. Mrvan   Democrat IN House 1 2021-01-03 2027-01-03 1 N00045905 ["H0IN01150"] 456821       Frank J. Mrvan   1969-04-16 M 4   0 165 17 2135 10923872
P000034 Frank Pallone Frank Pallone, Jr.   Democrat NJ House 6 1987-01-06 2027-01-03 1 N00000781 ["H8NJ03073", "S6NJ00263"] 400308 00887 26951   Frank Pallone Frank Pallone 1951-10-30 M 21   12 3385 348 14314 18275195
W000808 Frederica Wilson Frederica S. Wilson   Democrat FL House 24 2011-01-05 2027-01-03 1 N00030650 ["H0FL17068"] 412412 02004 17319   Frederica Wilson Frederica Wilson 1942-11-05 F 9   0 448 166 8430 2672674
A000380 Gabe Amo Gabe Amo   Democrat RI House 1 2023-11-07 2027-01-03 1 N00052615 ["H4RI01265"] 456955       Gabe Amo Gabe Amo 1987-12-11 M 3   0 47 21 1043 1101748
V000136 Gabriel (Gabe) Vasquez Gabe Vasquez   Democrat NM House 2 2023-01-03 2027-01-03 1 N00049142 ["H2NM02191"] 456919   201740   Gabe Vasquez Gabriel Vasquez 1984-08-03 M 3   0 53 56 1686 16260628
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
L000606 George Latimer George Latimer   Democrat NY House 16 2025-01-03 2027-01-03 1 N00054136 ["H4NY16087"] 457011       George Latimer (New York politician)   1953-11-22 M 2   0 121 5 445 7276084
W000830 George Whitesides George Whitesides   Democrat CA House 27 2025-01-03 2027-01-03 1 N00052205 ["H4CA27111"] 456977       George T. Whitesides   1974-03-03 M 2   35 16 8 445 16871701
C001123 Gilbert Cisneros Gilbert Ray Cisneros, Jr.   Democrat CA House 31 2019-01-03 2027-01-03 1 N00041464 ["H8CA39174", "H4CA31170"] 412757   179370   Gil Cisneros Gil Cisneros 1971-02-12 M 5   2146 74 29 1397 11528688
I000058 Glenn Ivey Glenn Ivey   Democrat MD House 4 2023-01-03 2027-01-03 1 N00033749 ["H2MD04315"] 456905   166279   Glenn Ivey   1961-02-27 M 3   0 53 10 1686 2890286
M001188 Grace Meng Grace Meng   Democrat NY House 6 2013-01-03 2027-01-03 1 N00034547 ["H2NY06116"] 412560 02148 69157   Grace Meng Grace Meng 1975-10-01 F 8   25 199 287 6820 3206532
C001131 Gregorio Casar Greg Casar   Democrat TX House 35 2023-01-03 2027-01-03 1 N00049855 ["H2TX35144"] 456945   161953   Greg Casar   1989-05-04 M 3   0 30 10 1686 1384824
L000601 Greg Landsman Greg Landsman   Democrat OH House 1 2023-01-03 2027-01-03 1 N00049718 ["H2OH01194"] 456928   186237   Greg Landsman   1976-12-04 M 3   170 85 38 1686 7327035
S001211 Greg Stanton Greg Stanton   Democrat AZ House 4 2019-01-03 2027-01-03 1 N00041750 ["H8AZ09040"] 412753   72030   Greg Stanton Greg Stanton 1970-03-08 M 5   189 169 74 3087 4267146
M001137 Gregory Meeks Gregory W. Meeks   Democrat NY House 5 1997-01-07 2027-01-03 1 N00001171 ["H8NY06048"] 400271 01506 4360   Gregory Meeks Gregory Meeks 1953-09-25 M 16   0 479 213 14309 7732459
M001160 Gwen Moore Gwen Moore   Democrat WI House 4 2005-01-04 2027-01-03 1 N00026914 ["H4WI04183"] 400661 01811 3457   Gwen Moore Gwen Moore 1951-04-18 F 12   0 829 227 13094 6282595
J000294 Hakeem Jeffries Hakeem S. Jeffries   Democrat NY House 8 2013-01-03 2027-01-03 1 N00033640 ["H2NY10092"] 412561 02149 55285   Hakeem Jeffries Hakeem Jeffries 1970-08-04 M 8   23 349 120 6825 9817561
S001215 Haley Stevens Haley M. Stevens   Democrat MI House 11 2019-01-03 2027-01-03 1 N00040915 ["H8MI11254"] 412786   181092   Haley Stevens Haley Stevens 1983-06-24 F 5   0 246 104 3087 20478402
J000288 Henry Johnson Henry C. "Hank" Johnson, Jr. Hank Democrat GA House 4 2007-01-04 2027-01-03 1 N00027848 ["H6GA04129"] 412199 01843 68070   Hank Johnson Henry C. Johnson, Jr. 1954-10-02 M 11   0 1088 217 11886 3833577
C001063 Henry Cuellar Henry Cuellar   Democrat TX House 28 2005-01-04 2027-01-03 1 N00024978 ["H2TX23082"] 400657 01807 5486   Henry Cuellar Henry Cuellar 1955-09-19 M 12   0 801 95 13094 21492072
C001136 Herbert Conaway Herbert C. Conaway, Jr.   Democrat NJ House 3 2025-01-03 2027-01-03 1 N00026951 ["H4NJ03080"] 457008       Herb Conaway   1963-01-30 M 2   0 15 11 445 1326686
S001221 Hillary Scholten Hillary J. Scholten   Democrat MI House 3 2023-01-03 2027-01-03 1 N00044885 ["H0MI03316"] 456906   191584   Hillary Scholten   1982-02-22 F 3   0 80 35 1686 9231549
O000173 Ilhan Omar Ilhan Omar   Democrat MN House 5 2019-01-03 2027-01-03 1 N00043581 ["H8MN05239"] 412791   171628   Ilhan Omar Ilhan Omar 1981-10-04 F 5   0 184 116 3087 4456797
C001110 J. Correa J. Luis Correa   Democrat CA House 46 2017-01-03 2027-01-03 1 N00037260 ["H6CA46116"] 412688   9732   Lou Correa Lou Correa 1958-01-24 M 6   0 509 112 4296 4950686
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
H001081 Jahana Hayes Jahana Hayes   Democrat CT House 5 2019-01-03 2027-01-03 1 N00043421 ["H8CT05245"] 412763   181744   Jahana Hayes Jahana Hayes 1973-03-08 F 5   0 73 115 3087 9191500
A000148 Jake Auchincloss Jake Auchincloss   Democrat MA House 4 2021-01-03 2027-01-03 1 N00045506 ["H0MA04192"] 456825       Jake Auchincloss   1988-01-29 M 4   8 100 23 2135 2575966
H001047 James Himes James A. Himes Jim Democrat CT House 4 2009-01-06 2027-01-03 1 N00029070 ["H8CT04172"] 412282 01913 106744   Jim Himes Jim Himes 1966-07-05 M 10   4 319 100 10085 8938239
C000537 James Clyburn James E. Clyburn Jim Democrat SC House 6 1993-01-05 2027-01-03 1 N00002408 ["H2SC02042"] 400075 00208 27066   Jim Clyburn James E. Clyburn 1940-07-21 M 18   0 908 95 14314 15351699
M000312 James McGovern James P. McGovern Jim Democrat MA House 2 1997-01-07 2027-01-03 1 N00000179 ["H4MA03022"] 400263 01504 552   Jim McGovern (American politician) Jim McGovern (Massachusetts) 1959-11-20 M 16   3 2215 363 14314 3639513

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