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)
Suggested facets: bio_gender, name_suffix, bio_birthday (date), id_fec (array)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
F000061 | Russell Feingold | F000061 | 300042 | 49309 | Russ Feingold | Q356475 | kg:/m/01nvvl | Russell | Feingold | 1953-03-02 | M | D. | Russ Feingold | 01331 | 53361 | S230 | N00000036 | [ "S8WI00026" ] |
|||||||||||
C000127 | Maria Cantwell | C000127 | 300018 | 39310 | Maria Cantwell | Q22250 | kg:/m/01x68t | Maria | Cantwell | 1958-10-13 | F | 10608 | Maria Cantwell | 00172 | 26137 | 27122 | S275 | Maria Cantwell | N00007836 | [ "S8WA00194", "H2WA01054" ] |
544 | ||||||||
W000154 | John Warner | W000154 | 300099 | 14712 | John Warner | Q464810 | kg:/m/01w8b5 | John | Warner | 1927-02-18 | M | W. | 01452 | 53356 | S143 | N00002061 | [ "S8VA00107" ] |
||||||||||||
R000615 | Mitt Romney | R000615 | 412841 | 41902 | Mitt Romney | Q4496 | kg:/m/0271_s | Mitt | Romney | 1947-03-12 | M | Mitt Romney | 21942 | S401 | Mitt Romney | N00000286 | [ "S8UT00176", "S4MA00143" ] |
||||||||||||
M001176 | Jeff Merkley | M001176 | 412325 | 40908 | Jeff Merkley | Q1368405 | kg:/m/026k60f | Jeff | Merkley | 1956-10-24 | M | Jeff Merkley | 01900 | 1029842 | 23644 | S322 | Jeff Merkley | N00029303 | [ "S8OR00207" ] |
807 | |||||||||
V000126 | George Voinovich | V000126 | 300098 | 49903 | George Voinovich | Q529873 | kg:/m/01_pgn | George | Voinovich | 1936-07-15 | M | V. | 01575 | 1783 | 21745 | S271 | N00003583 | [ "S8OH00011" ] |
|||||||||||
S000148 | Charles Schumer | S000148 | 300087 | 14858 | Chuck Schumer | Q380900 | kg:/m/01w74d | Charles | Schumer | 1950-11-23 | M | 21322 | E. | Chuck | Chuck Schumer | 01036 | 5929 | 26976 | S270 | Charles E. Schumer | N00001093 | [ "S8NY00082", "H0NY16010" ] |
606 | [ { "title": "Senate Minority Leader", "chamber": "senate", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "Senate Minority Leader", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Minority Leader", "chamber": "senate", "start": "2021-01-03", "end": "2021-01-20" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2021-01-20" } ] |
|||||
E000194 | John Ensign | E000194 | 300040 | 29537 | John Ensign | Q529372 | kg:/m/0204wp | John | Ensign | 1958-03-25 | M | 12839 | Eric | 00348 | 37076 | 22139 | S281 | N00006619 | [ "S8NV00073" ] |
||||||||||
D000407 | Pete Domenici | D000407 | 300036 | 14103 | Pete Domenici | Q964959 | kg:/m/01vjn1 | Pete | Domenici | 1932-05-07 | M | V. | 01319 | 53325 | S027 | N00006515 | [ "S8NM00010" ] |
||||||||||||
J000291 | Mike Johanns | J000291 | 412320 | 40905 | Mike Johanns | Q448880 | kg:/m/02722_ | Mike | Johanns | 1950-06-18 | M | Mike Johanns | 01899 | 56552 | 21309 | S321 | Mike Johanns | N00029444 | [ "S8NE00117" ] |
802 | |||||||||
H001049 | Kay Hagan | H001049 | 412324 | 40907 | Kay Hagan | Q261003 | kg:/m/02b56f | Kay | Hagan | 1953-05-26 | F | 15594 | Kay Hagan | 01902 | 1028015 | 21082 | S320 | Kay R. Hagan | N00029617 | [ "S8NC00239" ] |
806 | [ { "name": "Lawton M. Chiles Jr.", "relation": "niece" } ] |
|||||||
B000243 | Max Baucus | B000243 | 300005 | 14203 | Max Baucus | Q470748 | kg:/m/01rcm2 | Max | Baucus | 1941-12-11 | M | 9092 | S. | Max Baucus | 00066 | 1727 | 53315 | S127 | Max Baucus | N00004643 | [ "S8MT00010" ] |
533 | |||||||
H001079 | Cindy Hyde-Smith | H001079 | 412743 | 41707 | Cindy Hyde-Smith | Q5120540 | kg:/m/03wc2px | Cindy | Hyde-Smith | 1959-05-10 | F | Cindy Hyde-Smith | 113208 | 20784 | S395 | Cindy Hyde-Smith | N00043298 | [ "S8MS00261" ] |
|||||||||||
L000447 | Trent Lott | L000447 | 300069 | 14031 | Trent Lott | Q50608 | kg:/m/014sn2 | Trent | Lott | 1941-10-09 | M | 17151 | 00707 | 1886 | 53311 | S203 | N00003329 | [ "S8MS00162" ] |
|||||||||||
C000567 | Thad Cochran | C000567 | 300023 | 14009 | Thad Cochran | Q723896 | kg:/m/01fmcd | Thad | Cochran | 1937-12-07 | M | 11160 | Thad Cochran | 00213 | 1200 | 53312 | S136 | Thad Cochran | N00003328 | [ "S8MS00055" ] |
549 | ||||||||
H001089 | Joshua Hawley | H001089 | 412840 | 41901 | Josh Hawley | Q23020745 | kg:/g/11bwy_95zy | Joshua | Hawley | 1979-12-31 | M | Josh | Josh Hawley | 169716 | S399 | Josh Hawley | N00041620 | [ "S8MO00160" ] |
|||||||||||
S001203 | Tina Smith | S001203 | 412742 | 41706 | Tina Smith | Q18631509 | kg:/m/0127xvy3 | Tina | Smith | 1958-03-04 | F | Flint | Tina Smith | 111313 | 152968 | S394 | Tina Smith | N00042353 | [ "S8MN00578" ] |
2253 | |||||||||
F000457 | Alan Franken | F000457 | 412378 | 40904 | Al Franken | Q319084 | kg:/m/01lct6 | Alan | Franken | 1951-05-21 | M | Stuart | Al | Al Franken | 01969 | 23334 | 108924 | S332 | Al Franken | N00029016 | [ "S8MN00438" ] |
1189 | |||||||
S000770 | Debbie Stabenow | S000770 | 300093 | 29732 | Debbie Stabenow | Q241092 | kg:/m/01xh64 | Debbie | Stabenow | 1950-04-29 | F | 22090 | Ann | Debbie Stabenow | 01531 | 45451 | 515 | S284 | Debbie Stabenow | N00004118 | [ "S8MI00281", "H6MI08163" ] |
612 | [ { "title": "Senate Democratic Policy & Communications Committee Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Democratic Policy & Communications Committee Chair", "chamber": "senate", "start": "2021-01-03" } ] |
||||||
L000261 | Carl Levin | L000261 | 300066 | 14709 | Carl Levin | Q444652 | kg:/m/01xh6j | Carl | Levin | 1934-06-28 | M | Carl Levin | 01384 | 2592 | 53307 | S131 | Carl Levin | N00001691 | [ "S8MI00158" ] |
587 | [ { "name": "Sander Martin Levin", "relation": "brother" } ] |
||||||||
B001066 | Jim Bunning | B001066 | 300014 | 15406 | Jim Bunning | Q918265 | kg:/m/0lbm2 | Jim | Bunning | 1931-10-23 | M | 10150 | 00146 | 1457 | 26874 | S265 | N00003437 | [ "S8KY00118" ] |
|||||||||||
B001310 | Mike Braun | B001310 | 412839 | 41900 | Mike Braun | Q42804470 | kg:/g/11f2ckdwty | Mike | Braun | 1954-03-24 | M | Mike Braun | 148564 | S397 | Mike Braun | N00041731 | [ "S8IN00171" ] |
||||||||||||
B001233 | Evan Bayh | B001233 | 300006 | 49901 | Evan Bayh | Q344930 | kg:/m/01rcnr | Evan | Bayh | 1955-12-26 | M | 01572 | 22418 | S264 | N00003762 | [ "S8IN00049" ] |
|||||||||||||
R000584 | James Risch | R000584 | 412322 | 40902 | Jim Risch | Q721871 | kg:/m/06y9p0 | James | Risch | 1943-05-03 | M | E. | Jim Risch | 01896 | 1020034 | 2919 | S323 | James E. Risch | N00029441 | [ "S8ID00092" ] |
804 | ||||||||
C000880 | Michael Crapo | C000880 | 300030 | 29345 | Mike Crapo | Q734319 | kg:/m/021pgp | Michael | Crapo | 1951-05-20 | M | 11556 | D. | Mike | Mike Crapo | 00250 | 26440 | 26830 | S266 | Mike Crapo | N00006267 | [ "S8ID00027", "H2ID02034" ] |
556 | ||||||
S001217 | Rick Scott | S001217 | 412838 | 41903 | Rick Scott | Q439729 | kg:/m/0btx2g | Rick | Scott | 1952-12-01 | M | Rick Scott | 124204 | S404 | Rick Scott | N00043290 | [ "S8FL00273" ] |
||||||||||||
N000032 | Bill Nelson | N000032 | 300078 | 14651 | Bill Nelson | Q358437 | kg:/m/01_pb_ | Bill | Nelson | 1942-09-29 | M | 18875 | Bill Nelson (Florida) | 00859 | 1931 | 1606 | S282 | Bill Nelson | N00009926 | [ "S8FL00166" ] |
598 | ||||||||
C000174 | Thomas Carper | C000174 | 300019 | 15015 | Tom Carper | Q457432 | kg:/m/01xw7t | Thomas | Carper | 1947-01-23 | M | 10671 | Richard | Tom Carper | 00179 | 663 | 22421 | S277 | Thomas R. Carper | N00012508 | [ "S8DE00079" ] |
545 | |||||||
B000444 | Joseph Biden | B000444 | 300008 | 14101 | Joe Biden | Q6279 | kg:/m/012gx2 | Joseph | Biden | 1942-11-20 | M | R. | Joe Biden | Jr. | 01284 | 34 | 53279 | S010 | N00001669 | [ "S8DE00012" ] |
|||||||||
L000304 | Joseph Lieberman | L000304 | 300067 | 15704 | Joe Lieberman | Q160157 | kg:/m/0jw5r | Joseph | Lieberman | 1942-02-24 | M | I. | 01385 | 4363 | 53278 | S210 | Joseph I. Lieberman | N00000616 | [ "S8CT00022" ] |
||||||||||
M001197 | Martha McSally | M001197 | 412611 | 21501 | Martha McSally | Q6774492 | kg:/m/027fybv | Martha | McSally | 1966-03-22 | F | 15032414876 | Martha McSally | 02225 | 29126 | 137299 | S400 | Martha McSally | N00033982 | [ "S8AZ00221", "H2AZ08102" ] |
2067 | ||||||||
L000035 | Blanche Lincoln | L000035 | 300068 | 29305 | Blanche Lincoln | Q237681 | kg:/m/01xb1j | Blanche | Lincoln | 1960-09-30 | F | 16621 | Lambert | [ { "middle": null, "last": "Lambert", "end": "1995-01-03" } ] |
01570 | 26202 | 26723 | S269 | N00008092 | [ "S8AR00112", "H2AR01022" ] |
|||||||||
S001202 | Luther Strange | S001202 | 412734 | 41704 | Luther Strange | Q6705642 | kg:/m/06w5pjw | Luther | Strange | 1953-03-01 | M | Luther Strange | 9278255 | 121424 | S392 | Luther Strange | N00040607 | [ "S8AL00308" ] |
2245 | ||||||||||
B001265 | Mark Begich | B001265 | 412326 | 40900 | Mark Begich | Q454133 | kg:/m/05pqtr | Mark | Begich | 1962-03-30 | M | Mark Begich | 01898 | 1030732 | 79426 | S319 | Mark Begich | N00029901 | [ "S8AK00090" ] |
808 | [ { "name": "Nicholas J. Begich", "relation": "son" } ] |
||||||||
E000285 | Michael Enzi | E000285 | 300041 | 49706 | Mike Enzi | Q432431 | kg:/m/021ph1 | Michael | Enzi | 1944-02-01 | M | B. | Mike Enzi | 01542 | 45824 | 558 | S254 | Michael B. Enzi | N00006249 | [ "S6WY00126" ] |
565 | ||||||||
B001261 | John Barrasso | B001261 | 412251 | 40707 | John Barrasso | Q720521 | kg:/m/02rsm32 | John | Barrasso | 1952-07-21 | M | A. | John Barrasso | 01881 | 1024777 | 52662 | S317 | John Barrasso | N00006236 | [ "S6WY00068" ] |
732 | [ { "title": "Senate Republican Conference Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Republican Conference Chair", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
B001210 | Robert Byrd | B001210 | 300016 | 1366 | Robert Byrd | Q276524 | kg:/m/06bss | Robert | Byrd | 1917-11-20 | M | 10332 | C. | 01299 | 53359 | S017 | N00002200 | [ "S6WV00014" ] |
|||||||||||
K000305 | Herbert Kohl | K000305 | 300061 | 15703 | Herb Kohl | Q560447 | kg:/m/04fy4q | Herbert | Kohl | 1935-02-07 | M | H. | Herb | 01380 | 4030 | 53362 | S209 | Herb Kohl | N00004309 | [ "S6WI00061" ] |
|||||||||
W000803 | Jim Webb | W000803 | 412249 | 40706 | Jim Webb | Q532279 | kg:/m/0574xy | Jim | Webb | 1946-02-09 | M | 01822 | 1914 | 60043 | S315 | Jim Webb | N00028058 | [ "S6VA00127" ] |
|||||||||||
W000805 | Mark Warner | W000805 | 412321 | 40909 | Mark Warner | Q453893 | kg:/m/024mm1 | Mark | Warner | 1954-12-15 | M | R. | Mark Warner | 01897 | 7630 | 535 | S327 | Mark R. Warner | N00002097 | [ "S6VA00093", "P80003023" ] |
803 | ||||||||
H000338 | Orrin Hatch | H000338 | 300052 | 14503 | Orrin Hatch | Q381157 | kg:/m/016mj4 | Orrin | Hatch | 1934-03-22 | M | G. | Orrin Hatch | 01351 | 189 | 53352 | S118 | Orrin G. Hatch | N00009869 | [ "S6UT00063", "P00003806" ] |
574 | ||||||||
C001071 | Bob Corker | C001071 | 412248 | 40705 | Bob Corker | Q331719 | kg:/m/0d9fz3 | Bob | Corker | 1952-08-24 | M | Bob Corker | 01825 | 1021114 | 65905 | S310 | Bob Corker | N00027441 | [ "S6TN00216", "S4TN00187" ] |
729 | |||||||||
J000177 | Tim Johnson | J000177 | 300058 | 15425 | Tim Johnson (South Dakota politician) | Q925052 | kg:/m/01xwcp | Tim | Johnson | 1946-12-28 | M | 15920 | P. | Tim Johnson, South Dakota | 00604 | 2545 | 27067 | S257 | Tim Johnson | N00010084 | [ "S6SD00051", "H6SD00044" ] |
579 | |||||||
W000802 | Sheldon Whitehouse | W000802 | 412247 | 40704 | Sheldon Whitehouse | Q652066 | kg:/m/07qw94 | Sheldon | Whitehouse | 1955-10-20 | M | Sheldon Whitehouse | 01823 | 92235 | 2572 | S316 | Sheldon Whitehouse | N00027533 | [ "S6RI00221" ] |
728 | |||||||||
R000122 | John Reed | R000122 | 300081 | 29142 | Jack Reed (Rhode Island politician) | Q528979 | kg:/m/0202mc | John | Reed | 1949-11-12 | M | 20232 | F. | Jack | Jack Reed | 00949 | 24239 | 27060 | S259 | Jack Reed | N00000362 | [ "S6RI00163", "H0RI02071" ] |
600 | ||||||
C001070 | Robert Casey | C001070 | 412246 | 40703 | Bob Casey Jr. | Q887841 | kg:/m/047ymw | Robert | Casey | 1960-04-13 | M | P. | Bob | Bob Casey, Jr. | Jr. | 01828 | 47036 | 2541 | S309 | Robert P. Casey, Jr. | N00027503 | [ "S6PA00217" ] |
727 | ||||||
S000709 | Arlen Specter | S000709 | 300092 | 14910 | Arlen Specter | Q363055 | kg:/m/0204ym | Arlen | Specter | 1930-02-12 | M | 01437 | 53340 | S161 | N00001604 | [ "S6PA00100" ] |
|||||||||||||
W000779 | Ron Wyden | W000779 | 300100 | 14871 | Ron Wyden | Q529344 | kg:/m/0178p9 | Ron | Wyden | 1949-05-03 | M | 24150 | Ron Wyden | 01247 | 1962 | 27036 | S247 | Ron Wyden | N00007724 | [ "S6OR00110", "H0OR03026" ] |
619 | ||||||||
S001142 | Gordon Smith | S001142 | 300090 | 49705 | Gordon H. Smith | Q607069 | kg:/m/09kd23 | Gordon | Smith | 1952-05-25 | M | Harold | 01549 | 425 | S262 | N00007815 | [ "S6OR00094" ] |
||||||||||||
C001113 | Catherine Cortez Masto | C001113 | 412681 | 41700 | Catherine Cortez Masto | Q5052604 | kg:/m/02rtp9t | Catherine | Cortez Masto | 1964-03-29 | F | Catherine Cortez Masto | 105698 | 69579 | S385 | Catherine Cortez Masto | N00037161 | [ "S6NV00200" ] |
2193 | ||||||||||
R000146 | Harry Reid | R000146 | 300082 | 15054 | Harry Reid | Q314459 | kg:/m/0204x1 | Harry | Reid | 1939-12-02 | M | 20266 | M. | Harry Reid | 00952 | 1683 | 53320 | S198 | Harry Reid | N00009922 | [ "S6NV00028" ] |
601 | [ { "title": "Senate Majority Leader", "chamber": "senate", "start": "2007-01-04", "end": "2009-01-06" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2009-01-06", "end": "2011-01-05" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "Senate Minority Leader", "chamber": "senate", "start": "2015-01-03", "end": "2017-01-03" } ] |
||||||
H001076 | Margaret Hassan | H001076 | 412680 | 41702 | Maggie Hassan | Q24053 | kg:/m/03c3zch | Margaret | Hassan | 1958-02-27 | F | Wood | Maggie | Maggie Hassan | 67481 | 42552 | S388 | Margaret Wood Hassan | N00038397 | [ "S6NH00091" ] |
2192 | ||||||||
N000180 | Ben Nelson | N000180 | 300077 | 40103 | Ben Nelson | Q718542 | kg:/m/01_pcc | Ben | Nelson | 1941-05-17 | M | E. | 01627 | 16991 | 21744 | S283 | Ben Nelson | N00005329 | [ "S6NE00095" ] |
||||||||||
H001028 | Charles Hagel | H001028 | 300050 | 49704 | Chuck Hagel | Q381670 | kg:/m/01_pcr | Charles | Hagel | 1946-10-04 | M | T. | Chuck | 01545 | 231 | S255 | N00005301 | [ "S6NE00087" ] |
|||||||||||
C000705 | Kent Conrad | C000705 | 300026 | 15502 | Kent Conrad | Q553349 | kg:/m/021fx2 | Kent | Conrad | 1948-03-12 | M | Kent | 01307 | 2517 | 53331 | S201 | Kent Conrad | N00004613 | [ "S6ND00058" ] |
||||||||||
T000464 | Jon Tester | T000464 | 412244 | 40702 | Jon Tester | Q529351 | kg:/m/066cdp | Jon | Tester | 1956-08-21 | M | Jon Tester | 01829 | 1020176 | 20928 | S314 | Jon Tester | N00027605 | [ "S6MT00162" ] |
726 | |||||||||
M001170 | Claire McCaskill | M001170 | 412243 | 40701 | Claire McCaskill | Q22260 | kg:/m/040_w4 | Claire | McCaskill | 1953-07-24 | F | 18811 | Claire McCaskill | 01820 | 44501 | 2109 | S312 | Claire McCaskill | N00027694 | [ "S6MO00305", "P80005721" ] |
725 | ||||||||
B000611 | Christopher Bond | B000611 | 300010 | 15501 | Kit Bond | Q560427 | kg:/m/01_6h2 | Christopher | Bond | 1939-03-06 | M | S. | Kit | 01286 | 2360 | 53313 | S200 | N00005178 | [ "S6MO00289" ] |
||||||||||
K000367 | Amy Klobuchar | K000367 | 412242 | 40700 | Amy Klobuchar | Q22237 | kg:/m/05fbpt | Amy | Klobuchar | 1960-05-25 | F | 16558 | Jean | Amy Klobuchar | 01826 | 83701 | 65092 | S311 | Amy Klobuchar | N00027500 | [ "S6MN00267" ] |
724 | [ { "title": "Senate Democratic Steering Committee Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Democratic Steering Committee Chair", "chamber": "senate", "start": "2021-01-03" } ] |
||||||
C001035 | Susan Collins | C001035 | 300025 | 49703 | Susan Collins | Q22279 | kg:/m/020y8m | Susan | Collins | 1952-12-07 | F | 11742 | M. | Susan Collins | 01541 | 45738 | 379 | S252 | Susan M. Collins | N00000491 | [ "S6ME00159" ] |
551 | |||||||
M000687 | Kweisi Mfume | M000687 | 407672 | 15433 | Kweisi Mfume | Q519504 | kg:/m/04znp2 | Kweisi | Mfume | 1948-10-24 | M | 18186 | 00798 | Kweisi Mfume | N00001799 | [ "S6MD03185", "H6MD07020", "H0MD07114" ] |
|||||||||||||
M000702 | Barbara Mikulski | M000702 | 300073 | 14440 | Barbara Mikulski | Q261147 | kg:/m/0206nm | Barbara | Mikulski | 1936-07-20 | F | 18207 | A. | Barbara Mikulski | 00802 | 1396 | 53304 | S182 | Barbara A. Mikulski | N00001945 | [ "S6MD00140" ] |
594 | |||||||
K000105 | Edward Kennedy | K000105 | 300059 | 10808 | Ted Kennedy | Q134549 | kg:/m/0194xc | Edward | Kennedy | 1932-02-22 | M | M. | Ted | 01377 | 53305 | S055 | N00000308 | [ "S6MA00015" ] |
|||||||||||
L000550 | Mary Landrieu | L000550 | 300063 | 49702 | Mary Landrieu | Q22338 | kg:/m/019tyn | Mary | Landrieu | 1955-11-23 | F | 17280 | L. | Mary Landrieu | 01546 | 22357 | 661 | S258 | Mary L. Landrieu | N00005395 | [ "S6LA00227", "P00003483" ] |
584 | |||||||
B000953 | Samuel Brownback | B000953 | 300013 | 29523 | Sam Brownback | Q317618 | kg:/m/0202ny | Samuel | Brownback | 1956-09-12 | M | 10006 | D. | Sam | 00137 | 21952 | S249 | N00005244 | [ "S6KS00122" ] |
||||||||||
R000307 | Pat Roberts | R000307 | 300083 | 14852 | Pat Roberts | Q538375 | kg:/m/01_pdv | Pat | Roberts | 1936-04-20 | M | 20465 | Pat Roberts | 00968 | 16354 | 26866 | S260 | Pat Roberts | N00005285 | [ "S6KS00080", "H0KS01016" ] |
602 | ||||||||
D000563 | Richard Durbin | D000563 | 300038 | 15021 | Dick Durbin | Q434804 | kg:/m/01xcd1 | Richard | Durbin | 1944-11-21 | M | 12527 | J. | Dick Durbin | 00326 | 6741 | 26847 | S253 | Richard J. Durbin | N00004981 | [ "S6IL00151", "H2IL20026" ] |
563 | [ { "title": "Senate Minority Whip", "chamber": "senate", "start": "2005-01-04", "end": "2007-01-03" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2007-01-04", "end": "2009-01-06" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2009-01-06", "end": "2011-01-05" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "Senate Minority Whip", "chamber": "senate", "start": "2015-01-03", "end": "2017-01-03" }, { "title": "Senate Minority Whip", "chamber": "senate", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "Senate Minority Whip", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Minority Whip", "chamber": "senate", "start": "2021-01-03", "end": "2021-01-20" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2021-01-20" } ] |
||||||
I000055 | John Isakson | I000055 | 400194 | 29909 | Johnny Isakson | Q130024 | kg:/m/02556q | John | Isakson | 1944-12-28 | M | 15687 | H. | Johnny | Johnny Isakson | 01608 | 59135 | 1721 | S305 | Johnny Isakson | N00002593 | [ "S6GA00119", "H8GA06146" ] |
298 | ||||||
A000109 | Wayne Allard | A000109 | 300003 | 29108 | Wayne Allard | Q724250 | kg:/m/01rbt7 | Wayne | Allard | 1943-12-02 | M | 8410 | A. | 00011 | 26783 | S250 | N00009082 | [ "S6CO00168" ] |
|||||||||||
H001075 | Kamala Harris | H001075 | 412678 | 41701 | Kamala Harris | Q10853588 | kg:/m/08sry2 | Kamala | Harris | 1964-10-20 | F | Kamala Harris | 1018696 | 120012 | S387 | Kamala D. Harris | N00036915 | [ "S6CA00584" ] |
2190 | ||||||||||
M000303 | John McCain | M000303 | 300071 | 15039 | John McCain | Q10390 | kg:/m/0bymv | John | McCain | 1936-08-29 | M | 17696 | S. | John McCain | 00754 | 7476 | 53270 | S197 | John McCain | N00006424 | [ "S6AZ00019", "P80002801" ] |
592 | |||||||
S001141 | Jefferson Sessions | S001141 | 300088 | 49700 | Jeff Sessions | Q358443 | kg:/m/020yjg | Jefferson | Sessions | 1946-12-24 | M | B. | Jeff | Jeff Sessions | 01548 | 44441 | 443 | S261 | Jeff Sessions | N00003062 | [ "S6AL00195" ] |
607 | |||||||
S000320 | Richard Shelby | S000320 | 300089 | 94659 | Richard Shelby | Q472254 | kg:/m/020yj1 | Richard | Shelby | 1934-05-06 | M | 21534 | C. | Richard Shelby | 01049 | 1859 | 53266 | S184 | Richard C. Shelby | N00009920 | [ "S6AL00013" ] |
608 | |||||||
T000162 | Craig Thomas | T000162 | 300097 | 15633 | Craig L. Thomas | Q1138576 | kg:/m/021phv | Craig | Thomas | 1933-02-17 | M | 22827 | 01149 | S246 | N00006246 | [ "S4WY00055", "H8WY00106" ] |
|||||||||||||
R000361 | John Rockefeller | R000361 | 300084 | 14922 | Jay Rockefeller | Q285102 | kg:/m/01xmnh | John | Rockefeller | 1937-06-18 | M | D. | Jay | Jay Rockefeller | IV | 01424 | 1238 | 53360 | S176 | John D. Rockefeller, IV | N00001685 | [ "S4WV00027" ] |
603 | [ { "name": "Nelson Aldrich Rockefeller", "relation": "nephew" }, { "name": "Nelson Aldrich", "relation": "great grandson" }, { "name": "Charles Harting Percy", "relation": "son in law" } ] |
|||||
L000174 | Patrick Leahy | L000174 | 300065 | 14307 | Patrick Leahy | Q59315 | kg:/m/0202kf | Patrick | Leahy | 1940-03-31 | M | J. | Patrick Leahy | 01383 | 1552 | 53353 | S057 | Patrick J. Leahy | N00009918 | [ "S4VT00017" ] |
586 | [ { "title": "President Pro Tempore of the Senate", "chamber": "senate", "start": "2021-01-20" } ] |
|||||||
H001016 | Kay Hutchison | H001016 | 300054 | 49306 | Kay Bailey Hutchison | Q239928 | kg:/m/02050j | Kay | Hutchison | 1943-07-22 | F | 15537 | Bailey | 01368 | 24713 | 53349 | S235 | Kay Bailey Hutchison | N00005675 | [ "S4TX00086" ] |
|||||||||
R000605 | Mike Rounds | R000605 | 412669 | 41505 | Mike Rounds | Q722503 | kg:/m/020z2p | Mike | Rounds | 1954-10-24 | M | Mike Rounds | 02288 | 78317 | 7455 | S381 | Mike Rounds | N00035187 | [ "S4SD00049" ] |
2125 | |||||||||
D000595 | Jim DeMint | D000595 | 400105 | 29936 | Jim DeMint | Q22201 | kg:/m/02v30g | Jim | DeMint | 1951-09-02 | M | 12566 | W. | Jim DeMint | 01605 | 57895 | 25026 | S302 | Jim DeMint | N00002472 | [ "S4SC00083" ] |
||||||||
T000461 | Patrick Toomey | T000461 | 400408 | 29935 | Pat Toomey | Q971308 | kg:/m/02_kk7 | Patrick | Toomey | 1961-11-17 | M | 23202 | J. | Pat | Pat Toomey | 02085 | 7958 | 24096 | S351 | Patrick J. Toomey | N00001489 | [ "S4PA00121", "H8PA15096" ] |
1406 | ||||||
C000560 | Thomas Coburn | C000560 | 400576 | 29555 | Tom Coburn | Q509093 | kg:/m/03wnjr | Thomas | Coburn | 1948-03-14 | M | 11151 | A. | Tom Coburn | 00212 | 36751 | 22085 | S301 | Tom Coburn | N00005601 | [ "S4OK00174", "H4OK02048" ] |
623 | |||||||
I000024 | James Inhofe | I000024 | 300055 | 15424 | Jim Inhofe | Q723134 | kg:/m/021kpl | James | Inhofe | 1934-11-17 | M | 15645 | M. | Jim | Jim Inhofe | 00583 | 5619 | 27027 | S236 | James M. Inhofe | N00005582 | [ "S4OK00083", "H6OK01102" ] |
576 | ||||||
B001288 | Cory Booker | B001288 | 412598 | 41308 | Cory Booker | Q1135767 | kg:/m/06p430 | Cory | Booker | 1969-04-27 | M | Anthony | Cory Booker | 02194 | 84679 | 76151 | S370 | Cory A. Booker | N00035267 | [ "S4NJ00185" ] |
2051 | ||||||||
S001197 | Benjamin Sasse | S001197 | 412671 | 41503 | Ben Sasse | Q16192221 | kg:/m/0j5wk_6 | Benjamin | Sasse | 1972-02-22 | M | Eric | Ben | Ben Sasse | 02289 | 77429 | 150182 | S382 | Ben Sasse | N00035544 | [ "S4NE00090" ] |
2127 | |||||||
T000476 | Thom Tillis | T000476 | 412668 | 41504 | Thom Tillis | Q7786750 | kg:/m/0fq0395 | Thom | Tillis | 1960-08-30 | M | Thom Tillis (North Carolina) | 02291 | 77055 | 57717 | S384 | Thom Tillis | N00035492 | [ "S4NC00162" ] |
2124 | |||||||||
B001135 | Richard Burr | B001135 | 400054 | 29548 | Richard Burr | Q331278 | kg:/m/03g_s9 | Richard | Burr | 1955-11-30 | M | 10236 | M. | Richard Burr | 00153 | 31054 | 21787 | S300 | Richard Burr | N00002221 | [ "S4NC00089", "H2NC05074" ] |
172 | |||||||
W000818 | John Walsh | W000818 | 412602 | John Walsh (Montana politician) | Q6262874 | kg:/m/0nbx8tv | John | Walsh | 1960-11-03 | M | E. | 02198 | 73846 | 111027 | S371 | John E. Walsh | N00035686 | [ "S4MT00118" ] |
2055 | ||||||||||
S000663 | Olympia Snowe | S000663 | 300091 | 14661 | Olympia Snowe | Q22290 | kg:/m/020yg2 | Olympia | Snowe | 1947-02-21 | F | 21955 | J. | 01085 | 26885 | S245 | Olympia J. Snowe | N00000480 | [ "S4ME00055" ] |
||||||||||
K000148 | John Kerry | K000148 | 300060 | 14920 | John Kerry | Q22316 | kg:/m/0d3qd0 | John | Kerry | 1943-12-11 | M | Forbes | 01379 | 1485 | 53306 | S173 | John F. Kerry | N00000245 | [ "S4MA00069" ] |
581 | |||||||||
K000393 | John Kennedy | K000393 | 412679 | 41703 | John Kennedy (Louisiana politician) | Q6250211 | kg:/m/0fl2sv | John | Kennedy | 1951-11-21 | M | Neely | John Neely Kennedy | 1011723 | 35496 | S389 | John Kennedy | N00026823 | [ "S4LA00065" ] |
2191 | |||||||||
V000127 | David Vitter | V000127 | 400418 | 29918 | David Vitter | Q519780 | kg:/m/025jr2 | David | Vitter | 1961-05-03 | M | 21030 | David Vitter | 01609 | 60672 | 4615 | S299 | David Vitter | N00009659 | [ "S4LA00057", "H0LA01079" ] |
503 | ||||||||
L000504 | Richard Lugar | L000504 | 300070 | 14506 | Richard Lugar | Q363079 | kg:/m/01d_bx | Richard | Lugar | 1932-04-04 | M | G. | 01387 | 255 | 53292 | S105 | Richard G. Lugar | N00001764 | [ "S4IN00014" ] |
||||||||||
O000167 | Barack Obama | O000167 | 400629 | 40502 | Barack Obama | Q76 | kg:/m/02mjmr | Barack | Obama | 1961-08-04 | M | 19276 | Barack Obama | 01763 | 9490 | S298 | N00009638 | [ "S4IL00180" ] |
|||||||||||
B001266 | Roland Burris | B001266 | 412328 | 40903 | Roland Burris | Q609172 | kg:/m/09sztf | Roland | Burris | 1937-08-03 | M | 10429 | 01963 | 2462 | 18168 | S328 | N00015389 | [ "S4IL00057" ] |
|||||||||||
E000295 | Joni Ernst | E000295 | 412667 | 41502 | Joni Ernst | Q13475242 | kg:/m/0gg4wkg | Joni | Ernst | 1970-07-01 | F | 15032414877 | Joni Ernst | 02283 | 75342 | 128583 | S376 | Joni Ernst | N00035483 | [ "S4IA00129" ] |
2123 | [ { "title": "Senate Republican Conference Vice Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Republican Conference Vice Chair", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
Y000066 | David Young | Y000066 | 412628 | 21521 | David Young (Iowa politician) | Q19321008 | kg:/m/0127pc92 | David | Young | 1968-05-11 | M | 02242 | 76211 | 155218 | David Young | N00035509 | [ "S4IA00103", "H4IA03115" ] |
2084 | |||||||||||
H000206 | Thomas Harkin | H000206 | 300051 | 14230 | Tom Harkin | Q465617 | kg:/m/020ynq | Thomas | Harkin | 1939-11-19 | M | 14542 | Tom | Tom Harkin | 00501 | 2005 | 53294 | S172 | Tom Harkin | N00004207 | [ "S4IA00020", "P20000741" ] |
573 | |||||||
S001194 | Brian Schatz | S001194 | 412507 | 41112 | Brian Schatz | Q1827902 | kg:/m/0dd109 | Brian | Schatz | 1972-10-20 | M | Emanuel | Brian E. Schatz | 02173 | 87784 | 17852 | S353 | Brian Schatz | N00028138 | [ "S4HI00136", "H6HI02244" ] |
1728 | ||||||||
I000025 | Daniel Inouye | I000025 | 300056 | 4812 | Daniel Inouye | Q312845 | kg:/m/021sv1 | Daniel | Inouye | 1924-09-07 | M | 15647 | K. | 01369 | 2568 | 53285 | S051 | Daniel K. Inouye | N00001762 | [ "S4HI00011" ] |
|||||||||
P000612 | David Perdue | P000612 | 412666 | 41501 | David Perdue | Q17402717 | kg:/m/03wp8v4 | David | Perdue | 1949-12-10 | M | David Perdue | 02286 | 75920 | 151330 | S379 | David Perdue | N00035516 | [ "S4GA11285" ] |
2122 |
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);