legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_house_history
This data as json, copyable, CSV (advanced)
Suggested facets: bio_gender, id_fec (array)
bio_birthday (date) >30 ✖
- 1802-06-12 4
- 1818-10-08 4
- 1898-04-12 4
- 1786-12-25 3
- 1789-10-20 3
- 1807-02-17 3
- 1808-02-11 3
- 1808-06-18 3
- 1808-09-21 3
- 1811-01-06 3
- 1811-11-11 3
- 1813-10-13 3
- 1813-12-25 3
- 1815-01-18 3
- 1817-04-22 3
- 1819-01-22 3
- 1821-04-12 3
- 1825-04-17 3
- 1826-10-08 3
- 1828-12-16 3
- 1829-03-02 3
- 1829-08-07 3
- 1836-11-15 3
- 1840-01-01 3
- 1841-04-08 3
- 1844-08-01 3
- 1847-09-10 3
- 1848-10-04 3
- 1850-08-25 3
- 1851-02-07 3
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B000226 | Richard Bassett | B000226 | 401222 | 507 | Richard Bassett (Delaware politician) | Q518823 | kg:/m/02pz46 | Richard | Bassett | 1745-04-02 | M | ||||||||||||||||||
D000013 | Tristram Dalton | D000013 | 403156 | 2307 | Tristram Dalton | Q1365791 | kg:/m/03ynvb | Tristram | Dalton | 1738-05-28 | M | ||||||||||||||||||
M000031 | William Maclay | M000031 | 407058 | 5891 | William Maclay (Pennsylvania senator) | Q442393 | kg:/m/02d56c | William | Maclay | 1737-07-20 | M | ||||||||||||||||||
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 | ||||||||||||||||||
R000350 | Moses Robinson | R000350 | 409321 | 7989 | Moses Robinson | Q888648 | kg:/m/05k_0t | Moses | Robinson | 1741-03-22 | M | ||||||||||||||||||
E000075 | John Edwards | E000075 | 403764 | 2866 | John Edwards (Kentucky politician) | Q432795 | kg:/m/08rgfg | John | Edwards | M | |||||||||||||||||||
B000739 | William Bradford | B000739 | 401699 | 951 | William Bradford (Rhode Island politician) | Q932530 | kg:/m/01htjz | William | Bradford | 1729-11-04 | M | ||||||||||||||||||
M000166 | Alexander Martin | M000166 | 407188 | 6012 | Alexander Martin | Q642264 | kg:/m/02j2c6 | Alexander | Martin | M | |||||||||||||||||||
S001009 | Caleb Strong | S001009 | 410466 | 9028 | Caleb Strong | Q546613 | kg:/m/03d7pr | Caleb | Strong | 1745-01-09 | M | ||||||||||||||||||
T000107 | Henry Tazewell | T000107 | 410689 | 9238 | Henry Tazewell | Q765041 | kg:/m/03psr6 | Henry | Tazewell | 1753-11-27 | M | ||||||||||||||||||
M000155 | Humphrey Marshall | M000155 | 407176 | 6000 | Humphrey Marshall (politician) | Q1386353 | kg:/m/08g5df | Humphrey | Marshall | M | |||||||||||||||||||
P000026 | Elijah Paine | P000026 | 408437 | 7164 | Elijah Paine | Q382730 | kg:/m/0b0xrk | Elijah | Paine | 1757-01-21 | M | ||||||||||||||||||
T000052 | Josiah Tattnall | T000052 | 410640 | 9189 | Josiah Tattnall (politician) | Q357713 | kg:/m/0b2f92 | Josiah | Tattnall | M | |||||||||||||||||||
C000369 | Nathaniel Chipman | C000369 | 402508 | 1706 | Nathaniel Chipman | Q433382 | kg:/m/0cvgv1 | Nathaniel | Chipman | 1752-11-15 | M | ||||||||||||||||||
F000313 | Theodore Foster | F000313 | 404262 | 3315 | Theodore Foster | Q431894 | kg:/m/03zxpg | Theodore | Foster | 1752-04-29 | M | ||||||||||||||||||
L000377 | James Lloyd | L000377 | 406869 | 5725 | James Lloyd (Maryland politician) | Q433351 | kg:/m/05r_rm | James | Lloyd | M | |||||||||||||||||||
M000226 | Stevens Mason | M000226 | 407244 | 6063 | Stevens Thomson Mason (senator) | Q331107 | kg:/m/04bz1d | Stevens | Mason | 1760-12-29 | M | Thomson | |||||||||||||||||
R000448 | James Ross | R000448 | 409412 | 8070 | James Ross (Pennsylvania politician) | Q503524 | kg:/m/043p20 | James | Ross | 1762-07-12 | M | ||||||||||||||||||
R000550 | John Rutherfurd | R000550 | 409506 | 8150 | John Rutherfurd | Q376716 | kg:/m/08ldzv | John | Rutherfurd | 1760-09-20 | M | ||||||||||||||||||
C000497 | Joshua Clayton | C000497 | 402634 | 1823 | Joshua Clayton | Q652987 | kg:/m/0886hv | Joshua | Clayton | 1744-07-20 | M | ||||||||||||||||||
H000661 | John Hobart | H000661 | 405516 | 4469 | John Sloss Hobart | Q437169 | kg:/m/067yvr | John | Hobart | 1738-05-06 | M | Sloss | |||||||||||||||||
N000142 | William North | N000142 | 408226 | 6963 | William North | Q6017855 | kg:/m/06gh8j | William | North | M | |||||||||||||||||||
W000202 | James Watson | W000202 | 411373 | 9874 | James Watson (New York politician) | Q438181 | kg:/m/02qkt0 | James | Watson | 1750-04-06 | M | ||||||||||||||||||
C000572 | William Cocke | C000572 | 402701 | 1888 | William Cocke | Q5610267 | kg:/m/03jz31 | William | Cocke | M | |||||||||||||||||||
G000427 | Ray Greene | G000427 | 404775 | 3791 | Ray Greene (politician) | Q371165 | kg:/m/0d2q83 | Ray | Greene | 1765-02-02 | M | ||||||||||||||||||
B000787 | John Breckinridge | B000787 | 401744 | 994 | John Breckinridge (U.S. Attorney General) | Q959976 | kg:/m/0184mx | John | Breckinridge | 1760-12-02 | M | ||||||||||||||||||
C000627 | John Colhoun | C000627 | 402756 | 1939 | John E. Colhoun | Q1699879 | kg:/m/0d05wz | John | Colhoun | M | Ewing | ||||||||||||||||||
E000114 | Christopher Ellery | E000114 | 403805 | 2903 | Christopher Ellery | Q447135 | kg:/m/0d2r5z | Christopher | Ellery | 1768-11-01 | M | ||||||||||||||||||
L000401 | George Logan | L000401 | 406892 | 5744 | George Logan | Q5541811 | kg:/m/060v2g | George | Logan | 1753-09-09 | M | ||||||||||||||||||
O000041 | Aaron Ogden | O000041 | 408324 | 7029 | Aaron Ogden | Q302436 | kg:/m/070cr1 | Aaron | Ogden | 1756-12-03 | M | ||||||||||||||||||
O000060 | Simeon Olcott | O000060 | 408335 | 7048 | Simeon Olcott | Q2287091 | kg:/m/0d4dhm | Simeon | Olcott | 1735-10-01 | M | ||||||||||||||||||
C000525 | De Clinton | C000525 | 402659 | 1847 | DeWitt Clinton | Q527462 | kg:/m/0fd_1 | De | Clinton | 1769-03-02 | M | Witt | |||||||||||||||||
P000393 | William Plumer | P000393 | 408787 | 7493 | William Plumer | Q132185 | kg:/m/04jvdg | William | Plumer | 1759-06-25 | M | ||||||||||||||||||
P000468 | Samuel Potter | P000468 | 408854 | 7559 | Samuel J. Potter | Q431949 | kg:/m/0d1ybr | Samuel | Potter | 1753-06-29 | M | John | |||||||||||||||||
S000567 | John Smith | S000567 | 410048 | 8645 | John Smith (Ohio politician, died 1824) | Q541460 | kg:/m/02r2h7 | John | Smith | M | |||||||||||||||||||
W000392 | Samuel White | W000392 | 411552 | 10043 | Samuel White (American politician) | Q443094 | kg:/m/05rqrq | Samuel | White | M | |||||||||||||||||||
H000870 | Benjamin Howland | H000870 | 405717 | 4656 | Benjamin Howland | Q432864 | kg:/m/0d1yg7 | Benjamin | Howland | 1755-07-27 | M | ||||||||||||||||||
F000074 | James Fenner | F000074 | 404032 | 3104 | James Fenner | Q880519 | kg:/m/0bjmgh | James | Fenner | 1771-01-22 | M | ||||||||||||||||||
S000524 | Daniel Smith | S000524 | 410007 | 8608 | Daniel Smith (surveyor) | Q343267 | kg:/m/04bv59 | Daniel | Smith | 1748-10-29 | M | ||||||||||||||||||
T000249 | Buckner Thruston | T000249 | 410827 | 9366 | Buckner Thruston | Q744435 | kg:/m/0b3dr6 | Buckner | Thruston | 1763-02-09 | M | ||||||||||||||||||
B000745 | Stephen Bradley | B000745 | 401704 | 956 | Stephen R. Bradley | Q943343 | kg:/m/08l8zw | Stephen | Bradley | 1754-02-20 | M | Row | |||||||||||||||||
J000220 | George Jones | J000220 | 406114 | 5031 | George Jones (U.S. senator) | Q1291920 | kg:/m/0cr6ny | George | Jones | 1766-02-25 | M | ||||||||||||||||||
M000240 | Elisha Mathewson | M000240 | 407258 | 6076 | Elisha Mathewson | Q446820 | kg:/m/0d2r8g | Elisha | Mathewson | 1767-04-18 | M | ||||||||||||||||||
P000067 | Nahum Parker | P000067 | 408477 | 7200 | Nahum Parker | Q1963767 | kg:/m/0d74z_ | Nahum | Parker | 1760-03-04 | M | ||||||||||||||||||
T000268 | Edward Tiffin | T000268 | 410841 | 9380 | Edward Tiffin | Q884891 | kg:/m/034156 | Edward | Tiffin | 1766-06-19 | M | ||||||||||||||||||
M000633 | Return Meigs | M000633 | 407620 | 6408 | Return J. Meigs Jr. | Q744819 | kg:/m/0340r0 | Return | Meigs | 1764-11-17 | M | Jonathan | Jr. | ||||||||||||||||
A000197 | Joseph Anderson | A000197 | 400852 | 174 | Joseph Anderson | Q925017 | kg:/m/03b05p | Joseph | Anderson | 1757-11-05 | M | ||||||||||||||||||
C000076 | Alexander Campbell | C000076 | 402232 | 1442 | Alexander Campbell (American politician) | Q2621553 | kg:/m/0351_d | Alexander | Campbell | M | |||||||||||||||||||
G000136 | Obadiah German | G000136 | 404505 | 3539 | Obadiah German | Q2008660 | kg:/m/09p5mx | Obadiah | German | 1766-04-22 | M | ||||||||||||||||||
G000489 | Stanley Griswold | G000489 | 404834 | 3847 | Stanley Griswold | Q430588 | kg:/m/03520g | Stanley | Griswold | 1763-11-14 | M | ||||||||||||||||||
R000346 | Jonathan Robinson | R000346 | 409317 | 7985 | Jonathan Robinson (American politician) | Q434708 | kg:/m/08l9p3 | Jonathan | Robinson | 1756-08-11 | M | ||||||||||||||||||
W000411 | Jenkin Whiteside | W000411 | 411571 | 10061 | Jenkin Whiteside | Q1686878 | kg:/m/04bv98 | Jenkin | Whiteside | M | |||||||||||||||||||
C001031 | Charles Cutts | C001031 | 403138 | 2292 | Charles Cutts | Q1064014 | kg:/m/0d7jmr | Charles | Cutts | 1769-01-31 | M | ||||||||||||||||||
W000750 | Thomas Worthington | W000750 | 411899 | 10379 | Thomas Worthington (governor) | Q368387 | kg:/m/0340l5 | Thomas | Worthington | 1773-07-16 | M | ||||||||||||||||||
C000895 | William Crawford | C000895 | 403007 | 2165 | William H. Crawford | Q175877 | kg:/m/021k0n | William | Crawford | 1772-02-24 | M | Harris | |||||||||||||||||
H000865 | Jeremiah Howell | H000865 | 405712 | 4651 | Jeremiah B. Howell | Q454964 | kg:/m/0d2rbw | Jeremiah | Howell | 1771-08-28 | M | Brown | |||||||||||||||||
T000423 | James Turner | T000423 | 410991 | 9517 | James Turner (North Carolina politician) | Q369751 | kg:/m/02j26s | James | Turner | 1766-12-20 | M | ||||||||||||||||||
D000273 | Jean Destréhan | D000273 | 403408 | Jean Noël Destréhan | Q435963 | kg:/m/0b079s | Jean | Destréhan | M | Noel | |||||||||||||||||||
M000056 | Allan Magruder | M000056 | 407084 | 5916 | Allan B. Magruder | Q1543671 | kg:/m/0d32rg | Allan | Magruder | M | Bowie | ||||||||||||||||||
P000450 | Thomas Posey | P000450 | 408838 | 7543 | Thomas Posey | Q885976 | kg:/m/05mmtq | Thomas | Posey | 1750-07-09 | M | ||||||||||||||||||
B000554 | Jesse Bledsoe | B000554 | 401529 | 792 | Jesse Bledsoe | Q1688140 | kg:/m/0c0h4_ | Jesse | Bledsoe | 1776-04-06 | M | ||||||||||||||||||
B001051 | William Bulloch | B001051 | 401999 | 1230 | William Bellinger Bulloch | Q1335026 | kg:/m/09zxwr | William | Bulloch | M | Bellinger | ||||||||||||||||||
D000002 | David Daggett | D000002 | 403146 | 2296 | David Daggett | Q1659660 | kg:/m/01z_zn | David | Daggett | 1764-12-31 | M | ||||||||||||||||||
F000389 | Eligius Fromentin | F000389 | 412126 | 3377 | Eligius Fromentin | Q1329343 | kg:/m/095vrl | Eligius | Fromentin | M | |||||||||||||||||||
M000217 | Jeremiah Mason | M000217 | 407235 | 6054 | Jeremiah Mason | Q918671 | kg:/m/0d7jzv | Jeremiah | Mason | 1768-04-27 | M | ||||||||||||||||||
T000015 | Charles Tait | T000015 | 410605 | 9157 | Charles Tait | Q1066214 | kg:/m/0bkw4y | Charles | Tait | 1768-02-01 | M | ||||||||||||||||||
W000287 | William Wells | W000287 | 411452 | 9947 | William H. Wells | Q666838 | kg:/m/097jm4 | William | Wells | 1769-01-07 | M | Hill | |||||||||||||||||
K000141 | Joseph Kerr | K000141 | 406307 | 5210 | Joseph Kerr | Q1707394 | kg:/m/03561t | Joseph | Kerr | M | |||||||||||||||||||
L000387 | Francis Locke | L000387 | 406879 | Francis Locke Jr. | Q269495 | kg:/m/02kl4c | Francis | Locke | 1776-10-31 | M | |||||||||||||||||||
W000053 | George Walker | W000053 | 411232 | 9741 | George Walker (Kentucky politician) | Q1508496 | kg:/m/0c16f2 | George | Walker | M | |||||||||||||||||||
G000322 | Christopher Gore | G000322 | 404680 | 3705 | Christopher Gore | Q880929 | kg:/m/07n732 | Christopher | Gore | 1758-09-21 | M | ||||||||||||||||||
H000795 | Outerbridge Horsey | H000795 | 405644 | 4586 | Outerbridge Horsey | Q2041967 | kg:/m/064nq7f | Outerbridge | Horsey | 1777-03-05 | M | ||||||||||||||||||
H000991 | William Hunter | H000991 | 405831 | 4762 | William Hunter (senator) | Q2579380 | kg:/m/094dfy | William | Hunter | 1774-11-26 | M | ||||||||||||||||||
T000264 | Isaac Tichenor | T000264 | 410838 | 9378 | Isaac Tichenor | Q709124 | kg:/m/031p2y | Isaac | Tichenor | 1754-02-08 | M | ||||||||||||||||||
W000595 | James Wilson | W000595 | 411750 | 10235 | James J. Wilson | Q1680626 | kg:/m/044ffj | James | Wilson | M | Jefferson | ||||||||||||||||||
A000317 | Eli Ashmun | A000317 | 400963 | 271 | Eli P. Ashmun | Q1328837 | kg:/m/0b4g10 | Eli | Ashmun | 1770-06-24 | M | Porter | |||||||||||||||||
H000186 | Martin Hardin | H000186 | 405067 | 4054 | Martin D. Hardin | Q1235648 | kg:/m/0c16n2 | Martin | Hardin | 1780-06-21 | M | D. | |||||||||||||||||
M000213 | Armistead Mason | M000213 | 407231 | 6050 | Armistead Thomson Mason | Q256631 | kg:/m/02j5kg | Armistead | Mason | 1787-08-04 | M | Thomson | |||||||||||||||||
S000949 | Montfort Stokes | S000949 | 410408 | 8971 | Montfort Stokes | Q882982 | kg:/m/02j1qp | Montfort | Stokes | 1762-03-12 | M | ||||||||||||||||||
B001137 | James Burrill | B001137 | 402080 | 1305 | James Burrill Jr. | Q382718 | kg:/m/04rpwj | James | Burrill | 1772-04-25 | M | Jr. | |||||||||||||||||
L000177 | Walter Leake | L000177 | 406679 | 5542 | Walter Leake | Q359450 | kg:/m/021k3n | Walter | Leake | 1762-05-25 | M | ||||||||||||||||||
M000966 | David Morril | M000966 | 407934 | 6693 | David L. Morril | Q773273 | kg:/m/08570g | David | Morril | 1772-06-10 | M | Lawrence | |||||||||||||||||
W000516 | John Williams | W000516 | 411672 | 10160 | John Williams (Tennessee politician) | Q460926 | kg:/m/03458w | John | Williams | 1778-01-29 | M | ||||||||||||||||||
E000078 | Ninian Edwards | E000078 | 403770 | 2871 | Ninian Edwards | Q744084 | kg:/m/03bgz9 | Ninian | Edwards | 1775-03-17 | M | ||||||||||||||||||
M000636 | Prentiss Mellen | M000636 | 407623 | 6410 | Prentiss Mellen | Q2108752 | kg:/m/08hkw1 | Prentiss | Mellen | 1764-10-11 | M | ||||||||||||||||||
P000045 | William Palmer | P000045 | 408455 | 7182 | William A. Palmer | Q283798 | kg:/m/091_3z | William | Palmer | 1781-09-12 | M | Adams | |||||||||||||||||
B000921 | James Brown | B000921 | 401876 | 1111 | James Brown (Louisiana politician) | Q1592759 | kg:/m/04r1w2 | James | Brown | 1766-09-11 | M | ||||||||||||||||||
E000124 | John Elliott | E000124 | 403815 | 2913 | John Elliott (Georgia politician) | Q1486508 | kg:/m/0ct0n8 | John | Elliott | 1773-10-24 | M | ||||||||||||||||||
L000083 | James Lanman | L000083 | 406592 | 5465 | James Lanman | Q984116 | kg:/m/05g9y6 | James | Lanman | 1767-06-14 | M | ||||||||||||||||||
L000405 | William Logan | L000405 | 406896 | 5748 | William Logan (Kentuckian) | Q2579764 | kg:/m/0c0hdl | William | Logan | 1776-12-08 | M | ||||||||||||||||||
L000485 | Walter Lowrie | L000485 | 406973 | 5817 | Walter Lowrie (politician) | Q951798 | kg:/m/08pzc9 | Walter | Lowrie | 1784-12-10 | M | ||||||||||||||||||
T000102 | Waller Taylor | T000102 | 410685 | 9233 | Waller Taylor | Q2542744 | kg:/m/093gw0 | Waller | Taylor | M | |||||||||||||||||||
T000377 | William Trimble | T000377 | 410946 | 9477 | William A. Trimble | Q340200 | kg:/m/0351z0 | William | Trimble | 1786-04-04 | M | Allen | |||||||||||||||||
W000052 | Freeman Walker | W000052 | 411231 | 9740 | Freeman Walker | Q1260033 | kg:/m/0bj08p | Freeman | Walker | 1780-10-25 | M | ||||||||||||||||||
W000061 | John Walker | W000061 | 411240 | 9749 | John Williams Walker | Q512509 | kg:/m/03gb0x | John | Walker | 1783-08-12 | M | Williams | |||||||||||||||||
T000017 | Isham Talbot | T000017 | 410607 | 9159 | Isham Talbot | Q1673872 | kg:/m/0b678j | Isham | Talbot | M | |||||||||||||||||||
B000127 | James Barbour | B000127 | 401128 | 420 | James Barbour | Q878772 | kg:/m/03h_gl | James | Barbour | 1775-06-10 | M | ||||||||||||||||||
B000577 | Elijah Boardman | B000577 | 401548 | 810 | Elijah Boardman | Q1329376 | kg:/m/0bf9yq | Elijah | Boardman | 1760-03-07 | M | ||||||||||||||||||
D000295 | James De Wolf | D000295 | 403330 | 2549 | James DeWolf | Q5618956 | kg:/m/0d1yy1 | James | De Wolf | 1764-03-18 | 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);