legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_fec descending
This data as json, copyable, CSV (advanced)
id | name | id_bioguide | id_govtrack | id_icpsr | id_wikipedia | id_wikidata | id_google_entity_id | name_first | name_last | bio_birthday | bio_gender | id_house_history | name_middle | name_nickname | id_ballotpedia | name_suffix | id_bioguide_previous | id_house_history_alternate | other_names | id_thomas | id_cspan | id_votesmart | id_lis | name_official_full | id_opensecrets | id_fec ▲ | id_maplight | leadership_roles | family |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
M001162 | Mel Martinez | M001162 | 400621 | 40501 | Mel Martínez | Q435010 | kg:/m/01rbpt | Mel | Martinez | 1946-10-23 | M | 01769 | 31193 | S304 | N00026748 | [ "S4FL00298" ] |
|||||||||||||
S001163 | Ken Salazar | S001163 | 400619 | 40500 | Ken Salazar | Q342586 | kg:/m/03mdtj | Ken | Salazar | 1955-03-02 | M | 01762 | 1541 | S297 | N00026892 | [ "S4CO00163" ] |
|||||||||||||
K000352 | Jon Kyl | K000352 | 300062 | 15429 | Jon Kyl | Q371031 | kg:/m/01y0mp | Jon | Kyl | 1942-04-25 | M | 16529 | 00655 | 26721 | S243 | Jon Kyl | N00006406 | [ "S4AZ00030" ] |
|||||||||||
S001198 | Dan Sullivan | S001198 | 412665 | 41500 | Dan Sullivan (U.S. senator) | Q5218668 | kg:/m/07s4r4q | Dan | Sullivan | 1964-11-13 | M | Daniel S. Sullivan | 02290 | 1023262 | 114964 | S383 | Dan Sullivan | N00035774 | [ "S4AK00214" ] |
2121 | |||||||||
M001153 | Lisa Murkowski | M001153 | 300075 | 40300 | Lisa Murkowski | Q22360 | kg:/m/0202kt | Lisa | Murkowski | 1957-05-22 | F | 18778 | A. | Lisa Murkowski | 01694 | 1004138 | 15841 | S288 | Lisa Murkowski | N00026050 | [ "S4AK00099" ] |
595 | [ { "name": "Frank Hughes Murkowski", "relation": "daughter" } ] |
||||||
M001111 | Patty Murray | M001111 | 300076 | 49308 | Patty Murray | Q258825 | kg:/m/018qx5 | Patty | Murray | 1950-10-11 | F | 18715 | Patty Murray | 01409 | 25277 | 53358 | S229 | Patty Murray | N00007876 | [ "S2WA00189" ] |
596 | [ { "title": "Assistant Senate Minority Leader", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Assistant Senate Minority Leader", "chamber": "senate", "start": "2021-01-03", "end": "2021-01-20" }, { "title": "Assistant Senate Majority Leader", "chamber": "senate", "start": "2021-01-20" } ] |
|||||||
K000384 | Timothy Kaine | K000384 | 412582 | 41305 | Tim Kaine | Q359888 | kg:/m/053f8h | Timothy | Kaine | 1958-02-26 | M | Tim | Tim Kaine | 02176 | 49219 | 50772 | S362 | Tim Kaine | N00033177 | [ "S2VA00142" ] |
1806 | ||||||||
B000382 | Robert Bennett | B000382 | 300007 | 49307 | Bob Bennett (politician) | Q715787 | kg:/m/01xtg9 | Robert | Bennett | 1933-09-18 | M | F. | 01280 | 25708 | 53351 | S231 | N00006347 | [ "S2UT00104" ] |
|||||||||||
C001098 | Ted Cruz | C001098 | 412573 | 41304 | Ted Cruz | Q2036942 | kg:/m/07j6ty | Ted | Cruz | 1970-12-22 | M | Ted Cruz | 02175 | 1019953 | 135705 | S355 | Ted Cruz | N00033085 | [ "S2TX00312" ] |
1797 | |||||||||
C001056 | John Cornyn | C001056 | 300027 | 40305 | John Cornyn | Q719568 | kg:/m/01xcqs | John | Cornyn | 1952-02-02 | M | John Cornyn | 01692 | 93131 | 15375 | S287 | John Cornyn | N00024852 | [ "S2TX00106" ] |
553 | [ { "title": "Senate Minority Whip", "chamber": "senate", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2015-01-03", "end": "2017-01-03" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2017-01-03", "end": "2019-01-03" } ] |
||||||||
A000360 | Lamar Alexander | A000360 | 300002 | 40304 | Lamar Alexander | Q419976 | kg:/m/01rbs3 | Lamar | Alexander | 1940-07-03 | M | Lamar Alexander | 01695 | 5 | 15691 | S289 | Lamar Alexander | N00009888 | [ "S2TN00058", "P60003225" ] |
530 | |||||||||
T000250 | John Thune | T000250 | 400546 | 29754 | John Thune | Q462981 | kg:/m/03ybyn | John | Thune | 1961-01-07 | M | 22937 | John Thune | 01534 | 45552 | 398 | S303 | John Thune | N00004572 | [ "S2SD00068", "H6SD00085" ] |
621 | [ { "title": "Assistant Senate Majority Leader", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2021-01-03", "end": "2021-01-20" }, { "title": "Senate Minority Whip", "chamber": "senate", "start": "2021-01-20" } ] |
|||||||
B000468 | Jeff Bingaman | B000468 | 300009 | 14912 | Jeff Bingaman | Q705498 | kg:/m/01xck2 | Jeff | Bingaman | 1943-10-03 | M | 01285 | 590 | 53326 | S167 | Jeff Bingaman | N00006518 | [ "S2NM00021" ] |
|||||||||||
L000123 | Frank Lautenberg | L000123 | 300064 | 14914 | Frank Lautenberg | Q508752 | kg:/m/01wsvs | Frank | Lautenberg | 1924-01-23 | M | R. | 01381 | 2515 | 53324 | S166 | Frank R. Lautenberg | N00000659 | [ "S2NJ00080" ] |
585 | |||||||||
G000445 | Judd Gregg | G000445 | 300049 | 14826 | Judd Gregg | Q553116 | kg:/m/0206mj | Judd | Gregg | 1947-02-14 | M | 14129 | A. | 00466 | 53321 | S224 | N00000444 | [ "S2NH00025" ] |
|||||||||||
F000463 | Deb Fischer | F000463 | 412556 | 41302 | Deb Fischer | Q2580649 | kg:/m/0c4cp0 | Deb | Fischer | 1951-03-01 | F | 15032390640 | Deb Fischer | 02179 | 1034067 | 41963 | S357 | Deb Fischer | N00033443 | [ "S2NE00094" ] |
1780 | ||||||||
H001069 | Heidi Heitkamp | H001069 | 412554 | 41303 | Heidi Heitkamp | Q50597 | kg:/m/02f501 | Heidi | Heitkamp | 1955-10-30 | F | 15032390641 | Heidi Heitkamp | 02174 | 95414 | 41716 | S360 | Heidi Heitkamp | N00033782 | [ "S2ND00099" ] |
1778 | ||||||||
D000432 | Byron Dorgan | D000432 | 300037 | 14812 | Byron Dorgan | Q555735 | kg:/m/021fyn | Byron | Dorgan | 1942-05-14 | M | 12370 | L. | 00308 | 2318 | 53332 | S222 | N00004615 | [ "S2ND00040" ] |
||||||||||
D000601 | Elizabeth Dole | D000601 | 300035 | 40303 | Elizabeth Dole | Q239571 | kg:/m/01f0yh | Elizabeth | Dole | 1936-07-29 | F | 12577 | H. | 01698 | 41533 | S292 | N00008071 | [ "S2NC00083" ] |
|||||||||||
C001057 | Norm Coleman | C001057 | 300024 | 40302 | Norm Coleman | Q706661 | kg:/m/01jhtj | Norm | Coleman | 1949-08-17 | M | 01697 | 20239 | S291 | N00013870 | [ "S2MN00126" ] |
|||||||||||||
P000611 | Bruce Poliquin | P000611 | 412633 | 21524 | Bruce Poliquin | Q4978147 | kg:/m/0hrbhmw | Bruce | Poliquin | 1953-11-01 | M | 02247 | 76253 | 120909 | Bruce Poliquin | N00034584 | [ "S2ME00158", "H4ME02234" ] |
2089 | |||||||||||
K000383 | Angus King | K000383 | 412545 | 41300 | Angus King | Q544464 | kg:/m/02hfx0 | Angus | King | 1944-03-31 | M | S. | Angus King | Jr. | 02185 | 37413 | 22381 | S363 | Angus S. King, Jr. | N00034580 | [ "S2ME00109" ] |
1769 | |||||||
W000817 | Elizabeth Warren | W000817 | 412542 | 41301 | Elizabeth Warren | Q434706 | kg:/m/01qh39 | Elizabeth | Warren | 1949-06-22 | F | 15032390639 | Elizabeth Warren | 02182 | 1023023 | 141272 | S366 | Elizabeth Warren | N00033492 | [ "S2MA00170" ] |
1766 | ||||||||
M000355 | Mitch McConnell | M000355 | 300072 | 14921 | Mitch McConnell | Q355522 | kg:/m/01z6ls | Mitch | McConnell | 1942-02-20 | M | Mitch McConnell | 01395 | 2351 | 53298 | S174 | Mitch McConnell | N00003389 | [ "S2KY00012" ] |
593 | [ { "title": "Senate Minority Leader", "chamber": "senate", "start": "2007-01-04", "end": "2009-01-06" }, { "title": "Senate Minority Leader", "chamber": "senate", "start": "2009-01-06", "end": "2011-01-05" }, { "title": "Senate Minority Leader", "chamber": "senate", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "Senate Minority Leader", "chamber": "senate", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2015-01-03", "end": "2017-01-03" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2021-01-03", "end": "2021-01-20" }, { "title": "Senate Minority Leader", "chamber": "senate", "start": "2021-01-20" } ] |
||||||||
C000286 | Saxby Chambliss | C000286 | 300021 | 29512 | Saxby Chambliss | Q734330 | kg:/m/01xcms | Saxby | Chambliss | 1943-11-10 | M | 10813 | Saxby Chambliss | 00188 | 36571 | 22029 | S290 | Saxby Chambliss | N00002685 | [ "S2GA00118", "H2GA08038" ] |
547 | ||||||||
L000572 | George LeMieux | L000572 | 412380 | 40911 | George LeMieux | Q978350 | kg:/m/04m_msl | George | LeMieux | 1969-05-21 | M | S. | 01971 | 46456 | 17431 | S333 | N00031304 | [ "S2FL00227" ] |
|||||||||||
P000145 | Alejandro Padilla | P000145 | 456856 | Alex Padilla | Q4717593 | Alejandro | Padilla | 1973-03-22 | M | Alex | Alex Padilla | S413 | Alex Padilla | N00047888 | [ "S2CA00955" ] |
||||||||||||||
B000711 | Barbara Boxer | B000711 | 300011 | 15011 | Barbara Boxer | Q237560 | kg:/m/01c1n5 | Barbara | Boxer | 1940-11-11 | F | 9704 | Barbara Boxer | 00116 | 2470 | 53274 | S223 | Barbara Boxer | N00006692 | [ "S2CA00286", "H2CA06028", "P80003247" ] |
539 | ||||||||
S000888 | Ted Stevens | S000888 | 300094 | 12109 | Ted Stevens | Q50599 | kg:/m/018r3g | Ted | Stevens | 1923-11-18 | M | F. | 01440 | 53268 | S090 | N00007997 | [ "S2AK00010" ] |
||||||||||||
M001183 | Joe Manchin | M001183 | 412391 | 40915 | Joe Manchin | Q538868 | kg:/m/04lc5t | Joe | Manchin | 1947-08-24 | M | Joe Manchin III | III | 01983 | 62864 | 7547 | S338 | Joe Manchin, III | N00032838 | [ "S0WV00090" ] |
1372 | ||||||||
J000293 | Ron Johnson | J000293 | 412496 | 41111 | Ron Johnson (Wisconsin politician) | Q970272 | kg:/m/0cmdpzc | Ron | Johnson | 1955-04-08 | M | Ron Johnson (Wisconsin) | 02086 | 62835 | 126217 | S345 | Ron Johnson | N00032546 | [ "S0WI00197" ] |
1501 | |||||||||
L000577 | Mike Lee | L000577 | 412495 | 41110 | Mike Lee (American politician) | Q627098 | kg:/m/09v5q9x | Mike | Lee | 1971-06-04 | M | Mike Lee | 02080 | 9267977 | 66395 | S346 | Mike Lee | N00031696 | [ "S0UT00165" ] |
1500 | |||||||||
H000601 | Bill Hagerty | H000601 | 456798 | Bill Hagerty (politician) | Q27734214 | kg:/g/11c1xp6h9v | Bill | Hagerty | 1959-08-14 | M | Francis | Bill Hagerty | 128466 | S407 | Bill Hagerty | N00045369 | [ "S0TN00169" ] |
||||||||||||
G000359 | Lindsey Graham | G000359 | 300047 | 29566 | Lindsey Graham | Q22212 | kg:/m/01_pdg | Lindsey | Graham | 1955-07-09 | M | 14015 | O. | Lindsey Graham | 00452 | 36782 | 21992 | S293 | Lindsey Graham | N00009975 | [ "S0SC00149", "H4SC03087" ] |
569 | |||||||
P000449 | Robert Portman | P000449 | 400325 | 29386 | Rob Portman | Q926069 | kg:/m/0343xg | Robert | Portman | 1955-12-19 | M | 19838 | J. | Rob | Rob Portman | 00924 | 31819 | 27008 | S349 | Rob Portman | N00003682 | [ "S0OH00133", "H4OH02032" ] |
419 | ||||||
C001041 | Hillary Clinton | C001041 | 300022 | 40105 | Hillary Clinton | Q6294 | kg:/m/0d06m5 | Hillary | Clinton | 1947-10-26 | F | 11751 | Rodham | Hillary Clinton | 01631 | 55463 | S278 | N00000019 | [ "S0NY00188" ] |
||||||||||
A000368 | Kelly Ayotte | A000368 | 412493 | 41106 | Kelly Ayotte | Q22354 | kg:/m/0g9g4r | Kelly | Ayotte | 1968-06-27 | F | 8771 | Kelly A. Ayotte | 02075 | 95241 | 42352 | S340 | Kelly Ayotte | N00030980 | [ "S0NH00235" ] |
1498 | ||||||||
S001181 | Jeanne Shaheen | S001181 | 412323 | 40906 | Jeanne Shaheen | Q270316 | kg:/m/01rrm2 | Jeanne | Shaheen | 1947-01-28 | F | 22618 | Jeanne Shaheen | 01901 | 22850 | 1663 | S324 | Jeanne Shaheen | N00024790 | [ "S0NH00219" ] |
805 | ||||||||
S001078 | John Sununu | S001078 | 300095 | 29740 | John E. Sununu | Q1699908 | kg:/m/0170zz | John | Sununu | 1964-09-10 | M | 22472 | E. | 01532 | 617 | S296 | N00000397 | [ "S0NH00201" ] |
|||||||||||
H001061 | John Hoeven | H001061 | 412494 | 41107 | John Hoeven | Q374762 | kg:/m/01qb45 | John | Hoeven | 1957-03-13 | M | John Hoeven | 02079 | 85233 | 41788 | S344 | John Hoeven | N00031688 | [ "S0ND00093" ] |
1499 | |||||||||
B001268 | Scott Brown | B001268 | 412384 | 40913 | Scott Brown (politician) | Q155125 | kg:/m/0bmg6w | Scott | Brown | 1959-09-12 | M | Scott Brown (Massachusetts) | 01975 | 9266532 | 18919 | S335 | Scott P. Brown | N00031174 | [ "S0MA00109" ] |
||||||||||
P000603 | Rand Paul | P000603 | 412492 | 41104 | Rand Paul | Q463557 | kg:/m/05pdb7q | Rand | Paul | 1963-01-07 | M | Rand Paul | 02082 | 9265241 | 117285 | S348 | Rand Paul | N00030836 | [ "S0KY00156" ] |
1497 | [ { "name": "Ronald Ernest Paul", "relation": "son" } ] |
||||||||
C000542 | Daniel Coats | C000542 | 402675 | 14806 | Dan Coats | Q632321 | kg:/m/0jl26 | Daniel | Coats | 1943-05-16 | M | 11126 | Ray | Dan Coats | 00209 | 6080 | 53291 | S212 | Daniel Coats | N00003845 | [ "S0IN00053" ] |
1407 | |||||||
C000858 | Larry Craig | C000858 | 300029 | 14809 | Larry Craig | Q371025 | kg:/m/021pfw | Larry | Craig | 1945-07-20 | M | 11530 | E. | 00246 | 53288 | S215 | N00002091 | [ "S0ID00057" ] |
|||||||||||
G000386 | Charles Grassley | G000386 | 300048 | 14226 | Chuck Grassley | Q529294 | kg:/m/020ymy | Charles | Grassley | 1933-09-17 | M | 14050 | E. | Chuck | Chuck Grassley | 00457 | 1167 | 53293 | S153 | Chuck Grassley | N00001758 | [ "S0IA00028" ] |
570 | [ { "title": "President Pro Tempore of the Senate", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "President Pro Tempore of the Senate", "chamber": "senate", "start": "2021-01-03", "end": "2021-01-20" } ] |
|||||
A000069 | Daniel Akaka | A000069 | 300001 | 14400 | Daniel Akaka | Q359366 | kg:/m/01rbrq | Daniel | Akaka | 1924-09-11 | M | 8354 | Kahikina | 00007 | 8704 | 53286 | S213 | Daniel K. Akaka | N00007653 | [ "S0HI00084" ] |
|||||||||
W000790 | Raphael Warnock | W000790 | 456858 | Raphael Warnock | Q84146599 | Raphael | Warnock | 1969-07-23 | M | Gamaliel | Raphael Warnock | S415 | Raphael G. Warnock | N00046489 | [ "S0GA00559" ] |
||||||||||||||
L000594 | Kelly Loeffler | L000594 | 456790 | Kelly Loeffler | Q76570207 | kg:/g/11j3kgpjlx | Kelly | Loeffler | 1970-11-27 | F | Kelly Loeffler | 188718 | S405 | Kelly Loeffler | N00046125 | [ "S0GA00526" ] |
|||||||||||||
R000595 | Marco Rubio | R000595 | 412491 | 41102 | Marco Rubio | Q324546 | kg:/m/0dpr5f | Marco | Rubio | 1971-05-28 | M | Marco Rubio | 02084 | 87599 | 1601 | S350 | Marco Rubio | N00030612 | [ "S0FL00338" ] |
1496 | |||||||||
C001088 | Christopher Coons | C001088 | 412390 | 40916 | Chris Coons | Q923242 | kg:/m/082d3d | Christopher | Coons | 1963-09-09 | M | Andrew | Chris Coons | 01984 | 9269028 | 122834 | S337 | Christopher A. Coons | N00031820 | [ "S0DE00092" ] |
1371 | ||||||||
B001277 | Richard Blumenthal | B001277 | 412490 | 41101 | Richard Blumenthal | Q2023708 | kg:/m/03tg8m | Richard | Blumenthal | 1946-02-13 | M | Richard Blumenthal | 02076 | 21799 | 1568 | S341 | Richard Blumenthal | N00031685 | [ "S0CT00177" ] |
1495 | |||||||||
D000388 | Christopher Dodd | D000388 | 300034 | 14213 | Chris Dodd | Q319111 | kg:/m/01xcly | Christopher | Dodd | 1944-05-27 | M | 12312 | J. | 00302 | 53277 | S150 | N00000581 | [ "S0CT00037" ] |
|||||||||||
H000273 | John Hickenlooper | H000273 | 456797 | John Hickenlooper | Q430518 | kg:/m/04g_1z | John | Hickenlooper | 1952-02-07 | M | Wright | John Hickenlooper | S408 | John W. Hickenlooper | N00044206 | [ "S0CO00575" ] |
|||||||||||||
B001297 | Ken Buck | B001297 | 412619 | 21510 | Ken Buck | Q1439421 | kg:/m/05zzjd2 | Ken | Buck | 1959-02-16 | M | Ken Buck | 02233 | 78285 | 125319 | Ken Buck | N00030829 | [ "S0CO00237", "H4CO04090" ] |
2075 | ||||||||||
B001267 | Michael Bennet | B001267 | 412330 | 40910 | Michael Bennet | Q554792 | kg:/m/05b60qf | Michael | Bennet | 1964-11-28 | M | F. | Michael Bennet | 01965 | 1031622 | 110942 | S330 | Michael F. Bennet | N00030608 | [ "S0CO00211" ] |
1092 | ||||||||
F000062 | Dianne Feinstein | F000062 | 300043 | 49300 | Dianne Feinstein | Q230733 | kg:/m/01gqws | Dianne | Feinstein | 1933-06-22 | F | 13044 | Dianne Feinstein | 01332 | 13061 | 53273 | S221 | Dianne Feinstein | N00007364 | [ "S0CA00199" ] |
567 | ||||||||
K000377 | Mark Kelly | K000377 | 456794 | Mark Kelly | Q357510 | Mark | Kelly | 1964-02-21 | M | Mark Kelly | S406 | Mark Kelly | N00044223 | [ "S0AZ00350" ] |
|||||||||||||||
P000590 | Mark Pryor | P000590 | 300080 | 40301 | Mark Pryor | Q470755 | kg:/m/01gb3p | Mark | Pryor | 1963-01-10 | M | Mark Pryor | 01701 | 1002201 | 35 | S295 | Mark L. Pryor | N00013823 | [ "S0AR00028" ] |
599 | [ { "name": "David H. Pryor", "relation": "son" } ] |
||||||||
T000278 | Tommy Tuberville | T000278 | 456796 | Tommy Tuberville | Q7819948 | kg:/m/04tmr4 | Tommy | Tuberville | 1954-09-18 | M | Hawley | Tommy Tuberville | 188306 | S412 | Tommy Tuberville | N00044434 | [ "S0AL00230" ] |
||||||||||||
J000300 | Doug Jones | J000300 | 412741 | 41705 | Doug Jones (politician) | Q30122825 | kg:/g/11dyzdzg1j | Doug | Jones | 1954-05-04 | M | Doug Jones (Alabama) | 1024592 | 176464 | S393 | Doug Jones | N00024817 | [ "S0AL00156" ] |
2252 | ||||||||||
L000571 | Cynthia Lummis | L000571 | 412294 | 20953 | Cynthia Lummis | Q456064 | kg:/m/02qvjv3 | Cynthia | Lummis | 1954-09-10 | F | 17319 | M. | Cynthia Lummis | 01960 | 1031365 | 15546 | S410 | Cynthia M. Lummis | N00029788 | [ "H8WY00148", "S0WY00137" ] |
776 | |||||||
M001205 | Carol Miller | M001205 | 412837 | 21946 | Carol Miller (politician) | Q16145531 | kg:/m/0102fnyn | Carol | Miller | 1950-11-04 | F | D. | Carol Miller (West Virginia) | 52123 | Carol D. Miller | N00041542 | [ "H8WV03097" ] |
||||||||||||
S000244 | F. Sensenbrenner | S000244 | 400365 | 14657 | Jim Sensenbrenner | Q952268 | kg:/m/024tp2 | F. | Sensenbrenner | 1943-06-14 | M | 21438 | James | Jim Sensenbrenner | Jr. | 01041 | 1507 | 27142 | F. James Sensenbrenner, Jr. | N00004291 | [ "H8WI09050" ] |
456 | |||||||
S001213 | Bryan Steil | S001213 | 412836 | 21970 | Bryan Steil | Q58494431 | kg:/g/11fhnfybnd | Bryan | Steil | 1981-03-30 | M | Bryan Steil | 181289 | Bryan Steil | N00043379 | [ "H8WI01156" ] |
|||||||||||||
R000570 | Paul Ryan | R000570 | 400351 | 29939 | Paul Ryan | Q203966 | kg:/m/024v2j | Paul | Ryan | 1970-01-29 | M | 20785 | D. | Paul Ryan | 01560 | 57970 | 26344 | Paul D. Ryan | N00004357 | [ "H8WI01024" ] |
445 | [ { "title": "Speaker of the House", "chamber": "house", "start": "2015-10-28", "end": "2017-01-03" }, { "title": "Speaker of the House", "chamber": "house", "start": "2017-01-03", "end": "2019-01-03" } ] |
|||||||
B001230 | Tammy Baldwin | B001230 | 400013 | 29940 | Tammy Baldwin | Q40628 | kg:/m/024v02 | Tammy | Baldwin | 1962-02-11 | F | 10361 | Tammy Baldwin | 01558 | 57884 | 3470 | S354 | Tammy Baldwin | N00004367 | [ "H8WI00018", "S2WI00219" ] |
136 | [ { "title": "Senate Democratic Caucus Secretary", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
S001216 | Kim Schrier | S001216 | 412835 | 21962 | Kim Schrier | Q58333616 | kg:/g/11fk1mqvq7 | Kim | Schrier | 1968-08-23 | F | Kim Schrier | 181124 | Kim Schrier | N00041606 | [ "H8WA08189" ] |
|||||||||||||
M000404 | Jim McDermott | M000404 | 400262 | 15613 | Jim McDermott | Q321457 | kg:/m/0249sh | Jim | McDermott | 1936-12-28 | M | 17831 | A. | 00766 | 5761 | 27128 | Jim McDermott | N00009829 | [ "H8WA07132" ] |
359 | |||||||||
S000033 | Bernard Sanders | S000033 | 400357 | 29147 | Bernie Sanders | Q359442 | kg:/m/01_gbv | Bernard | Sanders | 1941-09-08 | M | 21173 | Bernie | Bernie Sanders | 01010 | 994 | 27110 | S313 | Bernard Sanders | N00000528 | [ "H8VT01016", "S4VT00033" ] |
450 | |||||||
C001078 | Gerald Connolly | C001078 | 412272 | 20952 | Gerry Connolly | Q1514859 | kg:/m/04f40kn | Gerald | Connolly | 1950-03-30 | M | 11817 | E. | Gerald Connolly | 01959 | 1015936 | 95078 | Gerald E. Connolly | N00029891 | [ "H8VA11062" ] |
754 | ||||||||
W000825 | Jennifer Wexton | W000825 | 412834 | 21983 | Jennifer Wexton | Q16206735 | kg:/m/0_flt0x | Jennifer | Wexton | 1968-05-27 | F | Jennifer Wexton | 147013 | Jennifer Wexton | N00041002 | [ "H8VA10106" ] |
|||||||||||||
S001209 | Abigail Spanberger | S001209 | 412833 | 21966 | Abigail Spanberger | Q55603085 | kg:/g/11fgm1ffs7 | Abigail | Spanberger | 1979-08-07 | F | Davis | Abigail Spanberger | 179682 | Abigail Davis Spanberger | N00041418 | [ "H8VA07094" ] |
||||||||||||
C001118 | Ben Cline | C001118 | 412832 | 21908 | Ben Cline | Q4885439 | kg:/m/04yf6mk | Ben | Cline | 1972-02-29 | M | Ben Cline | 50959 | Ben Cline | N00042296 | [ "H8VA06104" ] |
|||||||||||||
R000611 | Denver Riggleman | R000611 | 412831 | 21957 | Denver Riggleman | Q28086149 | kg:/g/11fjn2r1c7 | Denver | Riggleman | 1970-03-01 | M | Denver Riggleman | 181445 | Denver Riggleman | N00043541 | [ "H8VA05171" ] |
|||||||||||||
P000600 | Thomas Perriello | P000600 | 412304 | 20951 | Tom Perriello | Q1628398 | kg:/m/03crz_4 | Thomas | Perriello | 1974-10-09 | M | 20038 | S. P. | 01958 | 1031364 | 109344 | N00029339 | [ "H8VA05106" ] |
|||||||||||
L000591 | Elaine Luria | L000591 | 412830 | 21941 | Elaine Luria | Q58323073 | kg:/g/11gtd16xvy | Elaine | Luria | 1975-08-15 | F | G. | Elaine Luria | 179677 | Elaine G. Luria | N00042293 | [ "H8VA02111" ] |
||||||||||||
N000183 | Glenn Nye | N000183 | 412301 | 20950 | Glenn Nye | Q919254 | kg:/m/04p_ygb | Glenn | Nye | 1974-09-09 | M | 19062 | C. | 01957 | 1031363 | 109342 | N00029784 | [ "H8VA02046" ] |
|||||||||||
W000804 | Robert Wittman | W000804 | 412255 | 20756 | Rob Wittman | Q541251 | kg:/m/03cx7ld | Robert | Wittman | 1959-02-03 | M | 24189 | J. | Robert J. Wittman | 01886 | 1028089 | 58133 | Robert J. Wittman | N00029459 | [ "H8VA01147" ] |
736 | ||||||||
M001209 | Ben McAdams | M001209 | 412829 | 21943 | Ben McAdams | Q4886138 | kg:/m/0bbv3kw | Ben | McAdams | 1974-12-05 | M | Ben McAdams | 117512 | Ben McAdams | N00042013 | [ "H8UT04053" ] |
|||||||||||||
C001114 | John Curtis | C001114 | 412740 | 21755 | John Curtis (Utah politician) | Q6253810 | kg:/m/0bmdhtb | John | Curtis | 1960-05-10 | M | R. | John Curtis (Utah) | 123390 | John R. Curtis | N00041221 | [ "H8UT03238" ] |
2251 | |||||||||||
C001076 | Jason Chaffetz | C001076 | 412270 | 20949 | Jason Chaffetz | Q1683881 | kg:/m/047blr4 | Jason | Chaffetz | 1967-03-26 | M | 11813 | Jason Chaffetz | 01956 | 1031362 | 103482 | Jason Chaffetz | N00028958 | [ "H8UT03089" ] |
752 | |||||||||
A000376 | Colin Allred | A000376 | 412828 | 21900 | Colin Allred | Q5144845 | Colin | Allred | 1983-04-15 | M | Z. | Colin Allred | 177357 | Colin Z. Allred | N00040989 | [ "H8TX32098" ] |
|||||||||||||
G000587 | Sylvia Garcia | G000587 | 412827 | 21922 | Sylvia Garcia | Q13562489 | kg:/m/0ryt4bt | Sylvia | Garcia | 1950-09-06 | F | R. | Sylvia Garcia | 49734 | Sylvia R. Garcia | N00042282 | [ "H8TX29052" ] |
||||||||||||
R000568 | Ciro Rodriguez | R000568 | 400339 | 29771 | Ciro Rodriguez | Q546932 | kg:/m/03tvkv | Ciro | Rodriguez | 1946-12-09 | M | 20781 | D. | 01518 | 48779 | 16389 | N00009828 | [ "H8TX28013" ] |
|||||||||||
C001115 | Michael Cloud | C001115 | 412746 | 21758 | Michael Cloud | Q55313952 | kg:/g/11f6y3n6vk | Michael | Cloud | 1975-05-13 | M | Michael Cloud (Texas) | 10322 | 177350 | Michael Cloud | N00041882 | [ "H8TX27049" ] |
||||||||||||
O000168 | Pete Olson | O000168 | 412302 | 20948 | Pete Olson | Q2073303 | kg:/m/0407vf_ | Pete | Olson | 1962-12-09 | M | 19278 | Pete Olson | 01955 | 1031361 | 102008 | Pete Olson | N00029285 | [ "H8TX22107" ] |
784 | |||||||||
R000614 | Chip Roy | R000614 | 412826 | 21961 | Chip Roy | Q58333615 | kg:/g/11fghyq4y1 | Chip | Roy | 1972-08-07 | M | Chip Roy | 177319 | Chip Roy | N00042268 | [ "H8TX21307" ] |
|||||||||||||
G000544 | Charles Gonzalez | G000544 | 400152 | 29943 | Charlie Gonzalez | Q539459 | kg:/m/03jsbn | Charles | Gonzalez | 1945-05-05 | M | 14247 | A. | Charlie | 01555 | 25445 | Charles A. Gonzalez | N00005960 | [ "H8TX20077" ] |
||||||||||
E000299 | Veronica Escobar | E000299 | 412825 | 21917 | Veronica Escobar | Q52274267 | kg:/g/11ghdw9g9p | Veronica | Escobar | 1969-09-15 | F | Veronica Escobar | 99345 | Veronica Escobar | N00041702 | [ "H8TX16109" ] |
|||||||||||||
F000468 | Lizzie Fletcher | F000468 | 412824 | 21919 | Lizzie Fletcher | Q58324313 | kg:/g/11gzqssv7p | Lizzie | Fletcher | 1975-02-13 | F | Lizzie Pannill Fletcher | 177031 | Lizzie Fletcher | N00041194 | [ "H8TX07140" ] |
|||||||||||||
E000071 | Jake Ellzey | E000071 | 456862 | Jake Ellzey | Q105061782 | Jake | Ellzey | 1970-01-24 | M | Jake Ellzey | Jake Ellzey | N00042243 | [ "H8TX06266" ] |
||||||||||||||||
W000827 | Ron Wright | W000827 | 412823 | 21984 | Ron Wright (politician) | Q60428775 | kg:/g/11fgkl82tl | Ron | Wright | 1953-04-08 | M | Ronald Wright | 78666 | Ron Wright | N00042240 | [ "H8TX06233" ] |
|||||||||||||
E000063 | Thomas Edwards | E000063 | 400118 | 29144 | Chet Edwards | Q784037 | kg:/m/03fmkq | Thomas | Edwards | 1951-11-24 | M | 12678 | Chet | 00335 | 20693 | 27087 | N00005794 | [ "H8TX06035" ] |
|||||||||||
G000589 | Lance Gooden | G000589 | 412822 | 21925 | Lance Gooden | Q6483406 | kg:/m/0jkx4bp | Lance | Gooden | 1982-12-01 | M | Lance Gooden | 177282 | Lance Gooden | N00042237 | [ "H8TX05144" ] |
|||||||||||||
T000479 | Van Taylor | T000479 | 412821 | 21973 | Van Taylor | Q7913689 | kg:/m/0f9kk3 | Van | Taylor | 1972-08-01 | M | Van Taylor | 147737 | Van Taylor | N00027709 | [ "H8TX03123" ] |
|||||||||||||
C001120 | Dan Crenshaw | C001120 | 412820 | 21911 | Dan Crenshaw | Q58301995 | kg:/g/11hcj7fy00 | Dan | Crenshaw | 1984-03-14 | M | Daniel Crenshaw | 177270 | Dan Crenshaw | N00042224 | [ "H8TX02166" ] |
|||||||||||||
T000038 | John Tanner | T000038 | 400395 | 15628 | John S. Tanner | Q71863 | kg:/m/03tlxb | John | Tanner | 1944-09-22 | M | 22680 | S. | 01137 | 6116 | 27074 | N00003254 | [ "H8TN08033" ] |
|||||||||||
G000590 | Mark Green | G000590 | 412819 | 21926 | Mark E. Green | Q16224587 | kg:/m/09rx6jq | Mark | Green | 1964-11-08 | M | E. | Mark Green (Tennessee) | 139030 | Mark E. Green | N00041873 | [ "H8TN07076" ] |
||||||||||||
R000612 | John Rose | R000612 | 412818 | 21959 | John Rose (Tennessee politician) | Q33044040 | kg:/g/11g8xhg1mz | John | Rose | 1965-02-23 | M | W. | John Rose (Tennessee) | 180452 | John Rose | N00041599 | [ "H8TN06094" ] |
||||||||||||
B001309 | Tim Burchett | B001309 | 412817 | 21905 | Tim Burchett | Q7803244 | kg:/m/03yt07 | Tim | Burchett | 1964-08-25 | M | Tim Burchett | 24379 | Tim Burchett | N00041594 | [ "H8TN02119" ] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [legislators] ( [id] TEXT PRIMARY KEY, [name] TEXT, [id_bioguide] TEXT, [id_govtrack] INTEGER, [id_icpsr] INTEGER, [id_wikipedia] TEXT, [id_wikidata] TEXT, [id_google_entity_id] TEXT, [name_first] TEXT, [name_last] TEXT, [bio_birthday] TEXT, [bio_gender] TEXT , [id_house_history] INTEGER, [name_middle] TEXT, [name_nickname] TEXT, [id_ballotpedia] TEXT, [name_suffix] TEXT, [id_bioguide_previous] TEXT, [id_house_history_alternate] INTEGER, [other_names] TEXT, [id_thomas] TEXT, [id_cspan] INTEGER, [id_votesmart] INTEGER, [id_lis] TEXT, [name_official_full] TEXT, [id_opensecrets] TEXT, [id_fec] TEXT, [id_maplight] INTEGER, [leadership_roles] TEXT, [family] TEXT);