legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by leadership_roles descending
This data as json, copyable, CSV (advanced)
Suggested facets: bio_gender, bio_birthday (date), id_bioguide_previous (array), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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" } ] |
|||||||
B000589 | John Boehner | B000589 | 400036 | 29137 | John Boehner | Q11702 | kg:/m/039rwf | John | Boehner | 1949-11-17 | M | 9538 | A. | John Boehner | 00102 | 16740 | 27015 | John A. Boehner | N00003675 | [ "H0OH08029" ] |
155 | [ { "title": "Speaker of the House", "chamber": "house", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "Speaker of the House", "chamber": "house", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "Speaker of the House", "chamber": "house", "start": "2015-01-06", "end": "2015-10-28" } ] |
|||||||
B000575 | Roy Blunt | B000575 | 400034 | 29735 | Roy Blunt | Q1525924 | kg:/m/034fn4 | Roy | Blunt | 1950-01-10 | M | 9520 | Roy Blunt | 01464 | 45465 | 418 | S342 | Roy Blunt | N00005195 | [ "H6MO07128", "S0MO00183" ] |
153 | [ { "title": "Senate Republican Policy Committee Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Republican Policy Committee Chair", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
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" } ] |
|||||||
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" } ] |
|||||||
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" } ] |
||||||||
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" } ] |
||||||
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" } ] |
|||||
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" } ] |
||||||||
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" } ] |
||||||
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" } ] |
||||||
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" } ] |
||||||
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" } ] |
|||||||
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" } ] |
|||||||
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" } ] |
|||||
P000609 | Gary Palmer | P000609 | 412608 | 21500 | Gary Palmer (politician) | Q17386504 | kg:/m/0115nklq | Gary | Palmer | 1954-05-14 | M | J. | Gary Palmer | 02221 | 76094 | 146274 | Gary J. Palmer | N00035691 | [ "H4AL06098" ] |
2064 | [ { "title": "House Republican Policy Committee Chair", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Republican Policy Committee Chair", "chamber": "house", "start": "2021-01-03" } ] |
||||||||
J000299 | Mike Johnson | J000299 | 412706 | 21727 | Mike Johnson (Louisiana politician) | Q19880665 | kg:/m/0131jn2m | Mike | Johnson | 1972-01-30 | M | Mike Johnson (Louisiana) | 106095 | 156097 | Mike Johnson | N00039106 | [ "H6LA04138" ] |
2218 | [ { "title": "House Republican Conference Vice Chair", "chamber": "house", "start": "2021-01-03" } ] |
||||||||||
H001067 | Richard Hudson | H001067 | 412550 | 21346 | Richard Hudson (American politician) | Q3956999 | kg:/m/0nbwfxs | Richard | Hudson | 1971-11-04 | M | Richard Hudson | 02140 | 79622 | 136448 | Richard Hudson | N00033630 | [ "H2NC08185" ] |
1774 | [ { "title": "House Republican Conference Secretary", "chamber": "house", "start": "2021-01-03" } ] |
|||||||||
S001196 | Elise Stefanik | S001196 | 412648 | 21541 | Elise Stefanik | Q18211057 | kg:/m/0110fjsf | Elise | Stefanik | 1984-07-02 | F | 15032411587 | M. | Elise Stefanik | 02263 | 76364 | 152539 | Elise M. Stefanik | N00035523 | [ "H4NY21079" ] |
2104 | [ { "title": "House Republican Conference Chair", "chamber": "house", "start": "2021-05-14" } ] |
|||||||
C001109 | Liz Cheney | C001109 | 412732 | 21710 | Liz Cheney | Q5362573 | kg:/m/04slt0 | Liz | Cheney | 1966-07-28 | F | Liz Cheney | 86147 | 171319 | Liz Cheney | N00035504 | [ "H6WY00159" ] |
2244 | [ { "title": "House Republican Conference Chair", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Republican Conference Chair", "chamber": "house", "start": "2021-01-03", "end": "2021-05-14" } ] |
||||||||||
H000874 | Steny Hoyer | H000874 | 400189 | 14873 | Steny Hoyer | Q516515 | kg:/m/025k5p | Steny | Hoyer | 1939-06-14 | M | 15365 | H. | Steny Hoyer | 00566 | 1919 | 26890 | Steny H. Hoyer | N00001821 | [ "H2MD05155" ] |
293 | [ { "title": "House Minority Whip", "chamber": "house", "start": "2003-01-07", "end": "2005-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2005-01-04", "end": "2007-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2015-01-06", "end": "2017-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "House Majority Leader", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Majority Leader", "chamber": "house", "start": "2021-01-03" } ] |
|||||||
P000197 | Nancy Pelosi | P000197 | 400314 | 15448 | Nancy Pelosi | Q170581 | kg:/m/012v1t | Nancy | Pelosi | 1940-03-26 | F | 19519 | Nancy Pelosi | 00905 | 6153 | 26732 | Nancy Pelosi | N00007360 | [ "H8CA05035" ] |
408 | [ { "title": "House Minority Leader", "chamber": "house", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "House Minority Leader", "chamber": "house", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "House Minority Leader", "chamber": "house", "start": "2015-01-06", "end": "2017-01-03" }, { "title": "House Minority Leader", "chamber": "house", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "Speaker of the House", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Speaker of the House", "chamber": "house", "start": "2021-01-03" } ] |
[ { "name": "Thomas D'Alesandro Jr.", "relation": "daughter" } ] |
|||||||
C000537 | James Clyburn | C000537 | 400075 | 39301 | Jim Clyburn | Q1289889 | kg:/m/03c469 | James | Clyburn | 1940-07-21 | M | 11119 | E. | Jim | James E. Clyburn | 00208 | 21607 | 27066 | James E. Clyburn | N00002408 | [ "H2SC02042" ] |
192 | [ { "title": "House Majority Whip", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Majority Whip", "chamber": "house", "start": "2021-01-03" } ] |
[ { "name": "George Washington Murray", "relation": "relative" } ] |
|||||
S001176 | Steve Scalise | S001176 | 412261 | 20759 | Steve Scalise | Q1857141 | kg:/m/0br34c | Steve | Scalise | 1965-10-06 | M | 22608 | Joseph | Steve Scalise | 01892 | 1015311 | 9026 | Steve Scalise | N00009660 | [ "H0LA01087" ] |
742 | [ { "title": "House Majority Whip", "chamber": "house", "start": "2014-08-01", "end": "2015-01-03" }, { "title": "House Majority Whip", "chamber": "house", "start": "2015-01-06", "end": "2017-01-03" }, { "title": "House Majority Whip", "chamber": "house", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2021-01-03" } ] |
|||||||
M001165 | Kevin McCarthy | M001165 | 412190 | 20703 | Kevin McCarthy (California politician) | Q766866 | kg:/m/074qxm | Kevin | McCarthy | 1965-01-26 | M | 18801 | Kevin McCarthy (California) | 01833 | 85231 | 28918 | Kevin McCarthy | N00028152 | [ "H6CA22125" ] |
677 | [ { "title": "House Majority Whip", "chamber": "house", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "House Majority Whip", "chamber": "house", "start": "2013-01-03", "end": "2014-07-31" }, { "title": "House Majority Leader", "chamber": "house", "start": "2014-08-01", "end": "2015-01-03" }, { "title": "House Majority Leader", "chamber": "house", "start": "2015-01-06", "end": "2017-01-03" }, { "title": "House Majority Leader", "chamber": "house", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "House Minority Leader", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Minority Leader", "chamber": "house", "start": "2021-01-03" } ] |
||||||||
C001046 | Eric Cantor | C001046 | 400060 | 20144 | Eric Cantor | Q497271 | kg:/m/027z_f | Eric | Cantor | 1963-06-06 | M | 11760 | I. | Eric Cantor | 01674 | 87402 | 5121 | Eric Cantor | N00013131 | [ "H0VA07042" ] |
178 | [ { "title": "House Majority Leader", "chamber": "house", "start": "2011-01-03", "end": "2014-08-01" }, { "title": "House Minority Whip", "chamber": "house", "start": "2009-01-03", "end": "2011-01-03" } ] |
|||||||
A000371 | Pete Aguilar | A000371 | 412615 | 21506 | Pete Aguilar | Q7171821 | kg:/m/0jwv0xf | Pete | Aguilar | 1979-06-19 | M | Pete Aguilar | 02229 | 79994 | 70114 | Pete Aguilar | N00033997 | [ "H2CA31125" ] |
2071 | [ { "title": "House Democratic Caucus Vice Chair", "chamber": "house", "start": "2021-01-03" } ] |
|||||||||
J000294 | Hakeem Jeffries | J000294 | 412561 | 21343 | Hakeem Jeffries | Q5640425 | kg:/m/025_74m | Hakeem | Jeffries | 1970-08-04 | M | S. | Hakeem Jeffries | 02149 | 79612 | 55285 | Hakeem S. Jeffries | N00033640 | [ "H2NY10092" ] |
1785 | [ { "title": "House Democratic Caucus Chair", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Democratic Caucus Chair", "chamber": "house", "start": "2021-01-03" } ] |
||||||||
C001101 | Katherine Clark | C001101 | 412600 | 21375 | Katherine Clark | Q6376330 | kg:/m/0fpjc8b | Katherine | Clark | 1963-07-17 | F | 15032398493 | M. | Katherine Clark | 02196 | 73178 | 35858 | Katherine M. Clark | N00035278 | [ "H4MA05084" ] |
2053 | [ { "title": "Assistant Speaker of the House", "chamber": "house", "start": "2021-01-03" } ] |
|||||||
L000570 | Ben Luján | L000570 | 412293 | 20932 | Ben Ray Luján | Q324256 | kg:/m/0412qzq | Ben | Luján | 1972-06-07 | M | 17317 | Ray | Ben Ray Luján | 01939 | 1031351 | 102842 | S409 | Ben Ray Luján | N00029562 | [ "H8NM03196", "S0NM00058" ] |
775 | [ { "title": "Assistant Speaker of the House", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" } ] |
||||||
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" } ] |
|||||||
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" } ] |
|||||||
B000226 | Richard Bassett | B000226 | 401222 | 507 | Richard Bassett (Delaware politician) | Q518823 | kg:/m/02pz46 | Richard | Bassett | 1745-04-02 | M | ||||||||||||||||||
B000546 | Theodorick Bland | B000546 | 401521 | 786 | Theodorick Bland (congressman) | Q1749152 | kg:/m/033mf4 | Theodorick | Bland | 1742-03-21 | M | 9479 | |||||||||||||||||
B001086 | Aedanus Burke | B001086 | 402032 | 1260 | Aedanus Burke | Q380504 | kg:/m/03yccv | Aedanus | Burke | 1743-06-16 | M | 10177 | |||||||||||||||||
C000187 | Daniel Carroll | C000187 | 402334 | 1538 | Daniel Carroll | Q674371 | kg:/m/02q22c | Daniel | Carroll | 1730-07-22 | M | 10687 | |||||||||||||||||
C000538 | George Clymer | C000538 | 402671 | 1859 | George Clymer | Q708913 | kg:/m/01mpsj | George | Clymer | 1739-03-16 | M | 11120 | |||||||||||||||||
C000710 | Benjamin Contee | C000710 | 402834 | 2010 | Benjamin Contee | Q868334 | kg:/m/03xb7p | Benjamin | Contee | M | 11343 | ||||||||||||||||||
D000013 | Tristram Dalton | D000013 | 403156 | 2307 | Tristram Dalton | Q1365791 | kg:/m/03ynvb | Tristram | Dalton | 1738-05-28 | M | ||||||||||||||||||
E000155 | Jonathan Elmer | E000155 | 403846 | 2943 | Jonathan Elmer | Q929830 | kg:/m/03zxl_ | Jonathan | Elmer | 1745-11-29 | M | 12784 | |||||||||||||||||
F000100 | William Few | F000100 | 404057 | 3128 | William Few | Q664099 | kg:/m/02pz57 | William | Few | 1748-06-08 | M | 13100 | |||||||||||||||||
F000224 | William Floyd | F000224 | 404179 | 3237 | William Floyd | Q1381060 | kg:/m/01mpvf | William | Floyd | 1734-12-17 | M | 13251 | |||||||||||||||||
G000012 | George Gale | G000012 | 404389 | 3430 | George Gale (congressman) | Q1619320 | kg:/m/03_mdj | George | Gale | 1756-06-03 | M | 13580 | |||||||||||||||||
G000403 | William Grayson | G000403 | 404753 | 3771 | William Grayson | Q471060 | kg:/m/03zxy1 | William | Grayson | M | 14074 | ||||||||||||||||||
G000500 | Jonathan Grout | G000500 | 404845 | 3857 | Jonathan Grout | Q1703183 | kg:/m/08tx4v | Jonathan | Grout | 1737-07-23 | M | 14192 | |||||||||||||||||
H000368 | Benjamin Hawkins | H000368 | 405237 | 4212 | Benjamin Hawkins | Q2896102 | kg:/m/02g9m0 | Benjamin | Hawkins | 1754-08-15 | M | 14735 | |||||||||||||||||
H000995 | Benjamin Huntington | H000995 | 405835 | 4766 | Benjamin Huntington | Q581141 | kg:/m/04vfjf | Benjamin | Huntington | 1736-04-19 | M | 15507 | |||||||||||||||||
I000053 | Ralph Izard | I000053 | 412129 | 4837 | Ralph Izard | Q969896 | kg:/m/0376kk | Ralph | Izard | M | 15684 | ||||||||||||||||||
J000182 | William Johnson | J000182 | 406077 | 4998 | William Samuel Johnson | Q182543 | kg:/m/02pyzk | William | Johnson | 1727-10-07 | M | 15927 | Samuel | ||||||||||||||||
J000198 | Samuel Johnston | J000198 | 406093 | 5012 | Samuel Johnston | Q730149 | kg:/m/02j2g3 | Samuel | Johnston | 1733-12-15 | M | 15947 | |||||||||||||||||
L000201 | Richard Lee | L000201 | 406704 | 5565 | Richard Henry Lee | Q725907 | kg:/m/06k58 | Richard | Lee | 1732-01-20 | M | 16846 | Henry | ||||||||||||||||
M000031 | William Maclay | M000031 | 407058 | 5891 | William Maclay (Pennsylvania senator) | Q442393 | kg:/m/02d56c | William | Maclay | 1737-07-20 | M | ||||||||||||||||||
M000234 | George Mathews | M000234 | 407252 | 6071 | George Mathews (soldier) | Q887630 | kg:/m/0357nx | George | Mathews | 1739-08-30 | M | 17612 | |||||||||||||||||
M000985 | Robert Morris | M000985 | 407953 | 6712 | Robert Morris (financier) | Q464876 | kg:/m/01hh_b | Robert | Morris | 1734-01-20 | M | 18562 | |||||||||||||||||
P000092 | George Partridge | P000092 | 408502 | 7224 | George Partridge | Q1508042 | kg:/m/06gh02 | George | Partridge | 1740-02-08 | M | 19385 | |||||||||||||||||
P000102 | William Paterson | P000102 | 408510 | 7231 | William Paterson (judge) | Q729054 | kg:/m/01r022 | William | Paterson | 1745-12-24 | M | 19400 | |||||||||||||||||
S000624 | William Smith | S000624 | 410099 | 8693 | William Smith (Maryland politician) | Q978343 | kg:/m/03nqjd | William | Smith | 1728-04-12 | M | 21907 | |||||||||||||||||
S000961 | Michael Stone | S000961 | 410420 | 8983 | Michael Jenifer Stone | Q219505 | kg:/m/07xtws | Michael | Stone | M | 22329 | Jenifer | |||||||||||||||||
V000053 | Jeremiah Van Rensselaer | V000053 | 411095 | 9629 | Jeremiah Van Rensselaer | Q1687548 | kg:/m/0506gg | Jeremiah | Van Rensselaer | 1738-08-27 | M | 20938 | |||||||||||||||||
W000783 | Henry Wynkoop | W000783 | 411931 | 10405 | Henry Wynkoop | Q5730595 | kg:/m/03tpf2 | Henry | Wynkoop | 1737-03-02 | M | 24156 | |||||||||||||||||
D000324 | Philemon Dickinson | D000324 | 403444 | 2576 | Philemon Dickinson | Q2702466 | kg:/m/03zxkh | Philemon | Dickinson | 1739-04-05 | M | 12231 | |||||||||||||||||
W000059 | John Walker | W000059 | 411238 | 9747 | John Walker (Virginia politician) | Q450549 | kg:/m/03zy19 | John | Walker | 1744-02-13 | M | 23286 | |||||||||||||||||
A000307 | John Ashe | A000307 | 400951 | 259 | John Baptista Ashe (Continental Congress) | Q1699261 | kg:/m/02__xr | John | Ashe | M | 8686 | Baptista | |||||||||||||||||
B000167 | Robert Barnwell | B000167 | 401169 | 456 | Robert Barnwell | Q2156471 | kg:/m/027gy1 | Robert | Barnwell | 1761-12-21 | M | 8986 | |||||||||||||||||
B001133 | Aaron Burr | B001133 | 402077 | 1302 | Aaron Burr | Q179090 | kg:/m/0fsc6 | Aaron | Burr | 1756-02-06 | M | ||||||||||||||||||
C000009 | George Cabot | C000009 | 402171 | 1384 | George Cabot | Q382723 | kg:/m/043103 | George | Cabot | 1752-12-03 | M | ||||||||||||||||||
C000185 | Charles Carroll | C000185 | 402332 | 1536 | Charles Carroll of Carrollton | Q466009 | kg:/m/01jtw2 | Charles | Carroll | 1737-09-19 | M | 10684 | of Carrollton | ||||||||||||||||
E000147 | Oliver Ellsworth | E000147 | 403838 | 2936 | Oliver Ellsworth | Q515858 | kg:/m/027xqz | Oliver | Ellsworth | 1745-04-29 | M | 12776 | Oliver Ellsworth | ||||||||||||||||
G000139 | Elbridge Gerry | G000139 | 404507 | 3541 | Elbridge Gerry | Q219797 | kg:/m/02sp2 | Elbridge | Gerry | 1744-07-17 | M | 13737 | |||||||||||||||||
H000916 | Daniel Huger | H000916 | 405761 | 4695 | Daniel Huger | Q1161182 | kg:/m/04vc5n | Daniel | Huger | 1742-02-20 | M | 15416 | |||||||||||||||||
J000036 | Israel Jacobs | J000036 | 405941 | 4871 | Israel Jacobs | Q6087007 | kg:/m/09q5_d | Israel | Jacobs | 1726-06-09 | M | 15735 | |||||||||||||||||
K000158 | Philip Key | K000158 | 406322 | 5224 | Philip Key (U.S. politician) | Q219450 | kg:/m/05583l | Philip | Key | M | 16275 | ||||||||||||||||||
R000091 | George Read | R000091 | 409071 | 7762 | George Read (American politician, born 1733) | Q471303 | kg:/m/01mrhw | George | Read | 1733-09-18 | M | 20195 | |||||||||||||||||
R000350 | Moses Robinson | R000350 | 409321 | 7989 | Moses Robinson | Q888648 | kg:/m/05k_0t | Moses | Robinson | 1741-03-22 | M | ||||||||||||||||||
S000140 | Cornelius Schoonmaker | S000140 | 409648 | 8272 | Cornelius C. Schoonmaker | Q653373 | kg:/m/09q5dw | Cornelius | Schoonmaker | M | 21310 | Corneliusen | |||||||||||||||||
S000242 | Joshua Seney | S000242 | 409746 | 8363 | Joshua Seney | Q501799 | kg:/m/06ll_8 | Joshua | Seney | 1756-03-04 | M | 21435 | |||||||||||||||||
S000340 | Upton Sheredine | S000340 | 409837 | 8449 | Upton Sheredine | Q2119992 | kg:/m/08yry1 | Upton | Sheredine | M | 21559 | ||||||||||||||||||
S000349 | Roger Sherman | S000349 | 409845 | 8457 | Roger Sherman | Q354721 | kg:/m/01mp_3 | Roger | Sherman | 1721-04-19 | M | 21573 | |||||||||||||||||
S000412 | Peter Silvester | S000412 | 409906 | 8511 | Peter Silvester (1734–1808) | Q2078354 | kg:/m/09l13b | Peter | Silvester | M | 21650 | ||||||||||||||||||
S000832 | John Steele | S000832 | 410296 | 8869 | John Steele (North Carolina politician) | Q1701809 | kg:/m/04f8lz | John | Steele | 1764-11-16 | M | 22170 | |||||||||||||||||
S000866 | Samuel Sterett | S000866 | 410328 | 8896 | Samuel Sterett | Q1203736 | kg:/m/0557st | Samuel | Sterett | M | 22211 | ||||||||||||||||||
S001047 | Jonathan Sturges | S001047 | 410501 | 9062 | Jonathan Sturges | Q1703315 | kg:/m/06qk1k | Jonathan | Sturges | 1740-08-23 | M | 22432 | |||||||||||||||||
T000403 | Thomas Tucker | T000403 | 410972 | 9501 | Thomas Tudor Tucker | Q464466 | kg:/m/06rg8t | Thomas | Tucker | 1745-06-25 | M | 23126 | Tudor | ||||||||||||||||
W000216 | Anthony Wayne | W000216 | 411384 | 9885 | Anthony Wayne | Q574116 | kg:/m/0k2g0 | Anthony | Wayne | 1745-01-01 | M | 23476 | |||||||||||||||||
W000352 | Alexander White | W000352 | 411514 | 10006 | Alexander White (Virginia politician) | Q2643271 | kg:/m/07v7xs | Alexander | White | M | 23635 | ||||||||||||||||||
W000551 | Hugh Williamson | W000551 | 411707 | 10193 | Hugh Williamson | Q663151 | kg:/m/02pyy0 | Hugh | Williamson | 1735-12-05 | M | 23868 | |||||||||||||||||
W000560 | Francis Willis | W000560 | 411716 | 10202 | Francis Willis (Representative) | Q1361138 | kg:/m/0265tn5 | Francis | Willis | 1745-01-05 | M | 23877 | |||||||||||||||||
E000075 | John Edwards | E000075 | 403764 | 2866 | John Edwards (Kentucky politician) | Q432795 | kg:/m/08rgfg | John | Edwards | M | |||||||||||||||||||
P000473 | Richard Potts | P000473 | 408858 | 7564 | Richard Potts | Q6054920 | kg:/m/05rgs3 | Richard | Potts | 1753-07-19 | M | 19865 | |||||||||||||||||
A000280 | James Armstrong | A000280 | 400920 | 231 | James Armstrong (Pennsylvania politician) | Q6128836 | kg:/m/094g01 | James | Armstrong | 1748-08-29 | M | 8653 | |||||||||||||||||
B000282 | John Beatty | B000282 | 401276 | 554 | John Beatty (Continental Congress) | Q1413402 | kg:/m/033lbp | John | Beatty | 1749-12-10 | M | 9141 | |||||||||||||||||
B000661 | Elias Boudinot | B000661 | 401623 | 878 | Elias Boudinot | Q51753 | kg:/m/02rjz | Elias | Boudinot | 1740-05-02 | M | 9640 | |||||||||||||||||
B000671 | Shearjashub Bourne | B000671 | 401633 | 886 | Shearjashub Bourne | Q1535213 | kg:/m/08vt2f | Shearjashub | Bourne | 1746-06-14 | M | 9651 | |||||||||||||||||
B000739 | William Bradford | B000739 | 401699 | 951 | William Bradford (Rhode Island politician) | Q932530 | kg:/m/01htjz | William | Bradford | 1729-11-04 | M | ||||||||||||||||||
C000012 | Lambert Cadwalader | C000012 | 402174 | 1387 | Lambert Cadwalader (representative) | Q1119528 | kg:/m/031gtk | Lambert | Cadwalader | M | 10457 | ||||||||||||||||||
C000163 | Thomas Carnes | C000163 | 402311 | 1518 | Thomas P. Carnes | Q1526302 | kg:/m/08t6dm | Thomas | Carnes | M | 10658 | Petters | |||||||||||||||||
C000418 | Abraham Clark | C000418 | 402557 | 1750 | Abraham Clark | Q329870 | kg:/m/01mpsy | Abraham | Clark | 1726-02-15 | M | 10975 | |||||||||||||||||
C000545 | David Cobb | C000545 | 402678 | 1865 | David Cobb (Massachusetts politician) | Q1174031 | kg:/m/080bgg | David | Cobb | 1748-09-14 | M | 11129 | |||||||||||||||||
C000591 | Peleg Coffin | C000591 | 402720 | 1906 | Peleg Coffin Jr. | Q2067932 | kg:/m/08vvd0 | Peleg | Coffin | 1756-11-03 | M | 11191 | Jr. | ||||||||||||||||
D000157 | William Dawson | D000157 | 412032 | 2432 | William Johnston Dawson | Q2579535 | kg:/m/04f920 | William | Dawson | M | 12026 | Johnson |
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);