legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by family descending
This data as json, copyable, CSV (advanced)
Suggested facets: name_suffix, bio_birthday (date)
id_fec (array) >30 ✖
- H0AL01055 1
- H0AL02087 1
- H0AL05049 1
- H0AL05163 1
- H0AL07060 1
- H0AL07086 1
- H0AR01083 1
- H0AR02107 1
- H0AR03055 1
- H0AR04038 1
- H0AS00018 1
- H0AZ01184 1
- H0AZ01259 1
- H0AZ03362 1
- H0CA03078 1
- H0CA08135 1
- H0CA10073 1
- H0CA10149 1
- H0CA11022 1
- H0CA14042 1
- H0CA15148 1
- H0CA19173 1
- H0CA25105 1
- H0CA27085 1
- H0CA31087 1
- H0CA32101 1
- H0CA33117 1
- H0CA48024 1
- H0CA48198 1
- H0CA49055 1
- …
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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
L000563 | Daniel Lipinski | L000563 | 400630 | 20508 | Dan Lipinski | Q518424 | kg:/m/0508fv | Daniel | Lipinski | 1966-07-15 | M | 17303 | William | Daniel Lipinski | 01781 | 1013046 | 33692 | Daniel Lipinski | N00027239 | [ "H4IL03077" ] |
636 | [ { "name": "William Oliver Lipinski", "relation": "son" } ] |
|||||||
C001049 | Wm. Clay | C001049 | 400074 | 20147 | Lacy Clay | Q959455 | kg:/m/024vjr | Wm. | Clay | 1956-07-27 | M | 11766 | Lacy | William Lacy Clay | Jr. | 01654 | 88332 | 8967 | Wm. Lacy Clay | N00012460 | [ "H0MO01066" ] |
191 | [ { "name": "William Lacy Clay Sr.", "relation": "son" } ] |
||||||
C001036 | Lois Capps | C001036 | 400062 | 29774 | Lois Capps | Q459693 | kg:/m/024tfg | Lois | Capps | 1938-01-10 | F | 11744 | 01471 | 54075 | 16886 | Lois Capps | N00007232 | [ "H8CA22089" ] |
180 | [ { "name": "Walter Capps", "relation": "wife" } ] |
|||||||||
J000255 | Walter Jones | J000255 | 400209 | 29546 | Walter B. Jones Jr. | Q512537 | kg:/m/03g_r5 | Walter | Jones | 1943-02-10 | M | 16015 | B. | Walter B. Jones | Jr. | 00612 | 36693 | 21785 | Walter B. Jones | N00002299 | [ "H2NC01081" ] |
309 | [ { "name": "Walter Beaman Jones Sr.", "relation": "son" } ] |
||||||
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" } ] |
|||||||
U000039 | Tom Udall | U000039 | 400413 | 29924 | Tom Udall | Q957690 | kg:/m/033t35 | Tom | Udall | 1948-05-18 | M | 20879 | S. | Tom Udall | 01567 | 10075 | 22658 | S326 | Tom Udall | N00006561 | [ "H8NM03097", "S8NM00184" ] |
498 | [ { "name": "Stewart Lee Udall", "relation": "son" }, { "name": "Morris K. Udall", "relation": "nephew" }, { "name": "Mark Udall", "relation": "cousin" }, { "name": "Gordon H. Smith", "relation": "cousin" } ] |
||||||
S001168 | John Sarbanes | S001168 | 412212 | 20724 | John Sarbanes | Q984509 | kg:/m/08_r8n | John | Sarbanes | 1962-05-22 | M | 22592 | P. | John Sarbanes | 01854 | 1022884 | 66575 | John P. Sarbanes | N00027751 | [ "H6MD03292" ] |
697 | [ { "name": "Senator Paul Sarbanes", "relation": "son" } ] |
|||||||
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" } ] |
||||||||
H001032 | Rush Holt | H001032 | 400184 | 29923 | Rush Holt Jr. | Q528359 | kg:/m/0g6t4q | Rush | Holt | 1948-10-15 | M | 15560 | D. | 01580 | 57967 | 22574 | Rush Holt | N00000860 | [ "H6NJ12144" ] |
289 | [ { "name": "Rush D. Holt", "relation": "son" } ] |
||||||||
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" } ] |
||||||||
M001163 | Doris Matsui | M001163 | 400663 | 20538 | Doris Matsui | Q399561 | kg:/m/059hdf | Doris | Matsui | 1944-09-25 | F | 18797 | O. | Doris Matsui | 01814 | 26602 | 28593 | Doris O. Matsui | N00027459 | [ "H6CA05195" ] |
668 | [ { "name": "Robert Matsui", "relation": "wife" } ] |
|||||||
F000372 | Rodney Frelinghuysen | F000372 | 400142 | 29541 | Rodney Frelinghuysen | Q338190 | kg:/m/03bktp | Rodney | Frelinghuysen | 1946-04-29 | M | 13440 | P. | 00414 | 37781 | 22177 | Rodney P. Frelinghuysen | N00000684 | [ "H2NJ05014" ] |
252 | [ { "name": "Peter Hood Ballantine Frelinghuysen Jr.", "relation": "son" }, { "name": "Frederick Frelinghuysen", "relation": "great great grandson" }, { "name": "Theodore Frelinghuysen", "relation": "great great great nephew" } ] |
||||||||
T000465 | Niki Tsongas | T000465 | 412254 | 20754 | Niki Tsongas | Q440246 | kg:/m/02qn5w8 | Niki | Tsongas | 1946-04-26 | F | 23209 | S. | Niki Tsongas | 01884 | 21764 | 89417 | Niki Tsongas | N00029026 | [ "H8MA05143" ] |
735 | [ { "name": "Paul Tsongas", "relation": "wife" } ] |
|||||||
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" } ] |
||||||||
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" } ] |
|||||
U000038 | Mark Udall | U000038 | 400412 | 29906 | Mark Udall | Q631195 | kg:/m/024zbx | Mark | Udall | 1950-07-18 | M | 20877 | E. | Mark Udall | 01595 | 7634 | 12329 | S325 | Mark Udall | N00008051 | [ "H8CO02087", "S8CO00172" ] |
497 | [ { "name": "Morris K. Udall", "relation": "son" }, { "name": "Thomas Udall", "relation": "cousin" }, { "name": "Stewart Lee Udall", "relation": "nephew" }, { "name": "Gordon H. Smith", "relation": "cousin" } ] |
||||||
B001257 | Gus Bilirakis | B001257 | 412250 | 20758 | Gus Bilirakis | Q1555314 | kg:/m/0dy3z1 | Gus | Bilirakis | 1963-02-08 | M | 10413 | M. | Gus M. Bilirakis | 01838 | 1022873 | 17318 | Gus M. Bilirakis | N00027462 | [ "H6FL09070" ] |
731 | [ { "name": "Michael Bilirakis", "relation": "son" } ] |
|||||||
S001156 | Linda Sánchez | S001156 | 400355 | 20310 | Linda Sánchez | Q291143 | kg:/m/024xc7 | Linda | Sánchez | 1969-01-28 | F | 22572 | T. | Linda Sánchez | 01757 | 1003554 | 29674 | Linda T. Sánchez | N00024870 | [ "H2CA39078" ] |
448 | [ { "name": "Loretta Sanchez", "relation": "sister" } ] |
|||||||
S000030 | Loretta Sanchez | S000030 | 400356 | 29709 | Loretta Sanchez | Q469094 | kg:/m/0jbty | Loretta | Sanchez | 1960-01-07 | F | 21168 | B. | 01522 | 45639 | 203 | Loretta Sanchez | N00008274 | [ "H6CA46033" ] |
449 | [ { "name": "Linda Sanchez", "relation": "sister" } ] |
||||||||
D000600 | Mario Diaz-Balart | D000600 | 400108 | 20316 | Mario Díaz-Balart | Q767270 | kg:/m/02536z | Mario | Diaz-Balart | 1961-09-25 | M | 12575 | Mario Diaz-Balart | 01717 | 1003562 | 24312 | Mario Diaz-Balart | N00025337 | [ "H2FL25018" ] |
221 | [ { "name": "Lincoln Diaz Balart", "relation": "brother" } ] |
||||||||
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" } ] |
|||||||
C001072 | André Carson | C001072 | 412258 | 20757 | André Carson | Q517649 | kg:/m/03qcvz1 | André | Carson | 1974-10-16 | M | 11806 | Andre Carson | 01889 | 1027364 | 84917 | André Carson | N00029513 | [ "H8IN07184" ] |
739 | [ { "name": "Julia Carson", "relation": "grandson" } ] |
||||||||
K000379 | Joseph Kennedy | K000379 | 412543 | 21335 | Joe Kennedy III | Q1707784 | kg:/m/0j28kl9 | Joseph | Kennedy | 1980-10-04 | M | P. | Joseph Kennedy III | III | 02172 | 79948 | 141275 | Joseph P. Kennedy III | N00034044 | [ "H2MA04073" ] |
1767 | [ { "name": "Joseph Patrick Kennedy II", "relation": "son" }, { "name": "Edward Moore Kennedy", "relation": "great nephew" }, { "name": "John Fitzgerald Kennedy", "relation": "great nephew" }, { "name": "John Francis Fitzgerald", "relation": "great great grandson" }, { "name": "Patrick Joseph Kennedy", "relation": "first cousin once removed" } ] |
|||||||
D000533 | John Duncan | D000533 | 400116 | 15455 | Jimmy Duncan (politician) | Q653994 | kg:/m/0450rl | John | Duncan | 1947-07-21 | M | 12493 | J. | Jimmy | Jr. | 00322 | 6114 | 27069 | John J. Duncan, Jr. | N00003209 | [ "H8TN02069" ] |
228 | [ { "name": "John James Duncan", "relation": "son" } ] |
||||||
D000355 | John Dingell | D000355 | 400110 | 2605 | John Dingell | Q600393 | kg:/m/0226cw | John | Dingell | 1926-07-08 | M | 12268 | D. | John D. Dingell | 00299 | 470 | 26917 | John D. Dingell | N00001783 | [ "H6MI16034" ] |
223 | [ { "name": "John David Dingell", "relation": "son" } ] |
|||||||
F000456 | John Fleming | F000456 | 412275 | 20918 | John Fleming (American politician) | Q1699486 | kg:/m/04z_dt3 | John | Fleming | 1951-07-05 | M | 13559 | John Fleming (Louisiana) | 01924 | 1031345 | 108811 | John Fleming | N00029679 | [ "H8LA04225" ] |
757 | [ { "name": "Henry Clay", "relation": "relative" }, { "name": "James Brown Clay", "relation": "relative" } ] |
||||||||
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" } ] |
|||||
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" } ] |
||||||
R000486 | Lucille Roybal-Allard | R000486 | 400347 | 29317 | Lucille Roybal-Allard | Q469115 | kg:/m/024txf | Lucille | Roybal-Allard | 1941-06-12 | F | 20686 | Lucille Roybal-Allard | 00997 | 26136 | 26766 | Lucille Roybal-Allard | N00006671 | [ "H2CA33048" ] |
440 | [ { "name": "Edward R. Roybal", "relation": "daughter" } ] |
||||||||
S001154 | Bill Shuster | S001154 | 409888 | 20134 | Bill Shuster | Q862455 | kg:/m/03tm89 | Bill | Shuster | 1961-01-10 | M | 22568 | 01681 | 89108 | 55693 | Bill Shuster | N00013770 | [ "H2PA09035" ] |
669 | [ { "name": "E. G. \"Bud\" Shuster", "relation": "son" } ] |
|||||||||
H001048 | Duncan Hunter | H001048 | 412283 | 20963 | Duncan D. Hunter | Q540521 | kg:/m/047tpf2 | Duncan | Hunter | 1976-12-07 | M | 15592 | D. | Duncan Hunter | 01909 | 1032398 | 104308 | Duncan Hunter | N00029258 | [ "H8CA52052" ] |
765 | [ { "name": "Duncan Lee Hunter", "relation": "son" } ] |
|||||||
P000604 | Donald Payne | P000604 | 412506 | 31103 | Donald Payne Jr. | Q1240224 | kg:/m/0jwr2v8 | Donald | Payne | 1958-12-17 | M | M. | Donald Payne Jr. | Jr. | 02097 | 65639 | 90668 | Donald M. Payne, Jr. | N00034639 | [ "H2NJ10154" ] |
1687 | [ { "name": "Donald Milford Payne", "relation": "son" } ] |
|||||||
L000566 | Robert Latta | L000566 | 412256 | 20755 | Bob Latta | Q888061 | kg:/m/02z6_j1 | Robert | Latta | 1956-04-18 | M | 17309 | E. | Robert E. Latta | 01885 | 1028071 | 9926 | Robert E. Latta | N00012233 | [ "H8OH05036" ] |
737 | [ { "name": "Delbert L. Latta ", "relation": "son" } ] |
|||||||
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" } ] |
||||||||
M000689 | John Mica | M000689 | 400273 | 29331 | John Mica | Q918506 | kg:/m/02520m | John | Mica | 1943-01-27 | M | 18189 | L. | John L. Mica | 00800 | 26395 | 26805 | John L. Mica | N00002793 | [ "H2FL08055" ] |
369 | [ { "name": "Daniel Andrew Mica", "relation": "brother" } ] |
|||||||
K000380 | Daniel Kildee | K000380 | 412546 | 21372 | Dan Kildee | Q3880272 | kg:/m/0n4c3yt | Daniel | Kildee | 1958-08-11 | M | T. | Dan Kildee | 02134 | 623723 | 136102 | Daniel T. Kildee | N00033395 | [ "H2MI05119" ] |
1770 | [ { "name": "Dale Edward Kildee", "relation": "nephew" } ] |
||||||||
L000263 | Sander Levin | L000263 | 400238 | 15033 | Sander Levin | Q971943 | kg:/m/02n8p2 | Sander | Levin | 1931-09-06 | M | 16921 | M. | Sander Levin | 00683 | 251 | 26918 | Sander M. Levin | N00003950 | [ "H2MI17023" ] |
339 | [ { "name": "Carl Levin", "relation": "brother" } ] |
|||||||
C001047 | Shelley Capito | C001047 | 400061 | 20146 | Shelley Moore Capito | Q459618 | kg:/m/024pwq | Shelley | Capito | 1953-11-26 | F | 11762 | Moore | Shelley Moore Capito | 01676 | 83737 | 11701 | S372 | Shelley Moore Capito | N00009771 | [ "H0WV02138", "S4WV00159" ] |
179 | [ { "name": "Arch Alfred Moore Jr.", "relation": "daughter" } ] |
||||||
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 |
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);