legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_google_entity_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: name_suffix, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
L000589 | Debbie Lesko | L000589 | 412745 | 21757 | Debbie Lesko | Q16731415 | kg:/m/0zwmkgq | Debbie | Lesko | 1958-11-14 | F | Debbie Lesko | 106483 | Debbie Lesko | N00042056 | [ "H8AZ08158" ] |
|||||||||||||
M001194 | John Moolenaar | M001194 | 412634 | 21526 | John Moolenaar | Q16194212 | kg:/m/0z6rww4 | John | Moolenaar | 1961-05-08 | M | R. | John Moolenaar | 02248 | 76660 | 37676 | John R. Moolenaar | N00036275 | [ "H4MI04126" ] |
2090 | |||||||||
M001192 | Vance McAllister | M001192 | 412599 | Vance McAllister | Q15304910 | kg:/m/0ywyyqz | Vance | McAllister | 1974-01-07 | M | Vance McAllister | 02195 | 73009 | 145379 | Vance M. McAllister | N00035593 | [ "H4LA05130" ] |
2052 | |||||||||||
H001070 | Cresent Hardy | H001070 | 412645 | Cresent Hardy | Q16189291 | kg:/m/0yp3l3w | Cresent | Hardy | 1957-06-23 | M | Cresent Hardy | 02260 | 121872 | Cresent Hardy | N00035628 | [ "H4NV04017" ] |
2101 | ||||||||||||
T000473 | Mark Takai | T000473 | 412626 | Mark Takai | Q16197299 | kg:/m/0yp0gs4 | Mark | Takai | 1967-07-01 | M | 02240 | Mark Takai | N00035535 | [ "H4HI01134" ] |
2082 | ||||||||||||||
T000486 | Ritchie Torres | T000486 | 456838 | Ritchie Torres | Q16205227 | kg:/m/0x11h9s | Ritchie | Torres | 1988-03-12 | M | John | Ritchie Torres | Ritchie Torres | N00044346 | [ "H0NY15160" ] |
||||||||||||||
T000475 | Dave Trott | T000475 | 412636 | 21528 | Dave Trott (politician) | Q16982345 | kg:/m/0x0fzkk | Dave | Trott | 1960-10-16 | M | 02250 | 76679 | 152477 | David A. Trott | N00035607 | [ "H4MI11097" ] |
2092 | |||||||||||
G000574 | Ruben Gallego | G000574 | 412612 | 21502 | Ruben Gallego | Q16218474 | kg:/m/0wy0mz5 | Ruben | Gallego | 1979-11-20 | M | Ruben Gallego | 02226 | 77233 | 123732 | Ruben Gallego | N00036097 | [ "H4AZ07043" ] |
2068 | ||||||||||
S001204 | Michael San Nicolas | S001204 | 412770 | Michael San Nicolas | Q16221559 | kg:/m/0wy0mjt | Michael | San Nicolas | 1981-01-30 | M | F. Q. | Michael F. Q. San Nicolas | N00042619 | [ "H8GU01020" ] |
|||||||||||||||
L000583 | Barry Loudermilk | L000583 | 412624 | 21515 | Barry Loudermilk | Q16731643 | kg:/m/0wqdmcm | Barry | Loudermilk | 1963-12-22 | M | Barry Loudermilk | 02238 | 76165 | 31618 | Barry Loudermilk | N00035347 | [ "H4GA11061" ] |
2080 | ||||||||||
W000821 | Bruce Westerman | W000821 | 412610 | 21563 | Bruce Westerman | Q16197421 | kg:/m/0wklff5 | Bruce | Westerman | 1967-11-18 | M | Bruce Westerman | 02224 | 76097 | 119120 | Bruce Westerman | N00035527 | [ "H4AR04048" ] |
2066 | ||||||||||
G000575 | Gwen Graham | G000575 | 412620 | Gwen Graham | Q16195097 | kg:/m/0wk57s1 | Gwen | Graham | 1963-01-31 | F | 15032409716 | Gwen Graham | 02234 | 146129 | Gwen Graham | N00035688 | [ "H4FL02062" ] |
2076 | |||||||||||
L000266 | Jacob LaTurner | L000266 | 456824 | Jake LaTurner | Q16731273 | kg:/m/0w32xrn | Jacob | LaTurner | 1988-02-17 | M | Jake | Jake LaTurner | N00044232 | [ "H0KS02188" ] |
|||||||||||||||
C001103 | Earl Carter | C001103 | 412622 | 21513 | Buddy Carter | Q16240994 | kg:/m/0w32xj9 | Earl | Carter | 1957-09-06 | M | L. | Buddy | Earl "Buddy" Carter | 02236 | 76158 | 32085 | Earl L. "Buddy" Carter | N00035346 | [ "H4GA01039" ] |
2078 | ||||||||
S001210 | Ross Spano | S001210 | 412765 | 21967 | Ross Spano | Q16196710 | kg:/m/0v3c060 | Ross | Spano | 1966-07-16 | M | Ross Spano | 142164 | Ross Spano | N00043319 | [ "H8FL15230" ] |
|||||||||||||
M001196 | Seth Moulton | M001196 | 412632 | 21525 | Seth Moulton | Q18045052 | kg:/m/0sgh587 | Seth | Moulton | 1978-10-24 | M | Seth Moulton | 02246 | 78453 | 146299 | Seth Moulton | N00035431 | [ "H4MA06090" ] |
2088 | ||||||||||
G000578 | Matt Gaetz | G000578 | 412690 | 21719 | Matt Gaetz | Q16221742 | kg:/m/0s8w2_s | Matt | Gaetz | 1982-05-07 | M | Matt Gaetz | 104528 | 117101 | Matt Gaetz | N00039503 | [ "H6FL01119" ] |
2202 | |||||||||||
G000587 | Sylvia Garcia | G000587 | 412827 | 21922 | Sylvia Garcia | Q13562489 | kg:/m/0ryt4bt | Sylvia | Garcia | 1950-09-06 | F | R. | Sylvia Garcia | 49734 | Sylvia R. Garcia | N00042282 | [ "H8TX29052" ] |
||||||||||||
J000116 | Andrew Johnson | J000116 | 406017 | 4940 | Andrew Johnson | Q8612 | kg:/m/0rmg | Andrew | Johnson | 1808-12-29 | M | 15840 | |||||||||||||||||
J000005 | Andrew Jackson | J000005 | 405913 | 4843 | Andrew Jackson | Q11817 | kg:/m/0rlz | Andrew | Jackson | 1767-03-15 | M | 15699 | |||||||||||||||||
C001099 | William Cowan | C001099 | 412586 | Mo Cowan | Q3915426 | kg:/m/0qftmjh | William | Cowan | 1969-04-04 | M | Mo | Mo Cowan | 02189 | 69395 | 144307 | S367 | William M. Cowan | N99999896 | 2044 | ||||||||||
D000360 | Everett Dirksen | D000360 | 403477 | 2609 | Everett Dirksen | Q1382002 | kg:/m/0q43q | Everett | Dirksen | 1896-01-04 | M | 12276 | McKinley | ||||||||||||||||
K000389 | Ro Khanna | K000389 | 412684 | 21728 | Ro Khanna | Q7339221 | kg:/m/0q3z5xy | Ro | Khanna | 1976-09-13 | M | Ro Khanna | 31129 | 29473 | Ro Khanna | N00026427 | [ "H4CA12055" ] |
2196 | |||||||||||
P000613 | Jimmy Panetta | P000613 | 412685 | 21740 | Jimmy Panetta | Q27733776 | kg:/m/0pyy9y4 | Jimmy | Panetta | 1969-10-01 | M | Jimmy Panetta | 104727 | 169078 | Jimmy Panetta | N00038601 | [ "H6CA20152" ] |
2197 | |||||||||||
L000418 | Huey Long | L000418 | 406909 | 5758 | Huey Long | Q314384 | kg:/m/0py1g | Huey | Long | 1893-08-30 | M | Pierce | |||||||||||||||||
R000417 | Carlos Romero-Barceló | R000417 | 400615 | Carlos Romero Barceló | Q2183412 | kg:/m/0p9vw | Carlos | Romero-Barceló | 1932-09-04 | M | 20602 | 00980 | |||||||||||||||||
D000631 | Madeleine Dean | D000631 | 412809 | 21915 | Madeleine Dean | Q6726900 | kg:/m/0nfwmy_ | Madeleine | Dean | 1959-06-06 | F | Madeleine Dean | 136484 | Madeleine Dean | N00042894 | [ "H8PA04116" ] |
|||||||||||||
R000604 | Steve Russell | R000604 | 412650 | 21546 | Steve Russell (politician) | Q16195304 | kg:/m/0ndnv6f | Steve | Russell | 1963-05-25 | M | 02265 | 77286 | 106528 | Steve Russell | N00036175 | [ "H4OK05132" ] |
2106 | |||||||||||
P000614 | Chris Pappas | P000614 | 412795 | 21951 | Chris Pappas (politician) | Q5107684 | kg:/m/0nd3t8z | Chris | Pappas | 1980-06-04 | M | Chris Pappas | 42635 | Chris Pappas | N00042161 | [ "H8NH01210" ] |
|||||||||||||
C001089 | David Curson | C001089 | 412504 | 31100 | David Curson | Q1174126 | kg:/m/0nd2pq0 | David | Curson | 1948-11-04 | M | Alan | 02095 | 143373 | David Alan Curson | N00034982 | [ "H2MI11190" ] |
||||||||||||
S001193 | Eric Swalwell | S001193 | 412514 | 21306 | Eric Swalwell | Q3466996 | kg:/m/0ncq55g | Eric | Swalwell | 1980-11-16 | M | Eric Swalwell | 02104 | 79729 | 129529 | Eric Swalwell | N00033508 | [ "H2CA15094" ] |
1738 | ||||||||||
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 | ||||||||||
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" } ] |
|||||||||
G000585 | Jimmy Gomez | G000585 | 412739 | 21754 | Jimmy Gomez | Q6200205 | kg:/m/0n_73h1 | Jimmy | Gomez | 1974-11-25 | M | 15032449022 | Jimmy Gomez | 108883 | 138524 | Jimmy Gomez | N00040597 | [ "H8CA34266" ] |
2250 | ||||||||||
D000627 | Val Demings | D000627 | 412696 | 21713 | Val Demings | Q7909083 | kg:/m/0n52xwn | Val | Demings | 1957-03-12 | F | Butler | Val Demings | 623713 | 137637 | Val Butler Demings | N00033449 | [ "H2FL08063" ] |
2208 | ||||||||||
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" } ] |
||||||||
M001189 | Luke Messer | M001189 | 412540 | 21332 | Luke Messer | Q3225316 | kg:/m/0n48dw8 | Luke | Messer | 1969-02-27 | M | Luke Messer | 02130 | 11245 | 33997 | Luke Messer | N00012546 | [ "H0IN02125", "H0IN05094" ] |
1764 | ||||||||||
M001191 | Patrick Murphy | M001191 | 412527 | 21319 | Patrick Murphy (Florida politician) | Q3182011 | kg:/m/0n47ttk | Patrick | Murphy | 1983-03-30 | M | Patrick Murphy (Florida) | 02117 | 95348 | 137652 | Patrick Murphy | N00033091 | [ "H2FL22072" ] |
1751 | ||||||||||
L000580 | Michelle Lujan Grisham | L000580 | 412558 | 21341 | Michelle Lujan Grisham | Q3917203 | kg:/m/0n3vkrv | Michelle | Lujan Grisham | 1959-10-24 | F | 15032387385 | Michelle Lujan Grisham | 02146 | 94791 | 102404 | Michelle Lujan Grisham | N00029400 | [ "H8NM01257" ] |
1782 | |||||||||
B000145 | Alben Barkley | B000145 | 401146 | 437 | Alben W. Barkley | Q273549 | kg:/m/0myyb | Alben | Barkley | 1877-11-24 | M | 8958 | William | ||||||||||||||||
G000074 | John Garner | G000074 | 404446 | 3482 | John Nance Garner | Q298991 | kg:/m/0mywx | John | Garner | 1868-11-22 | M | 13655 | Nance | ||||||||||||||||
C001008 | Charles Curtis | C001008 | 403115 | 2269 | Charles Curtis | Q271023 | kg:/m/0myvl | Charles | Curtis | 1860-01-25 | M | 11714 | |||||||||||||||||
S000345 | James Sherman | S000345 | 409841 | 8453 | James S. Sherman | Q310831 | kg:/m/0mysy | James | Sherman | 1855-10-24 | M | 21567 | Schoolcraft | ||||||||||||||||
F000003 | Charles Fairbanks | F000003 | 403965 | 3046 | Charles W. Fairbanks | Q270539 | kg:/m/0myr7 | Charles | Fairbanks | 1852-05-11 | M | Warren | |||||||||||||||||
S000889 | Adlai Stevenson | S000889 | 410350 | 8918 | Adlai Stevenson I | Q310839 | kg:/m/0myqt | Adlai | Stevenson | 1835-10-23 | M | 22239 | Ewing | ||||||||||||||||
F000374 | John Frémont | F000374 | 404319 | 3366 | John C. Frémont | Q169011 | kg:/m/0mq2c | John | Frémont | 1813-01-21 | M | Charles | |||||||||||||||||
M001018 | Levi Morton | M001018 | 407985 | 6742 | Levi P. Morton | Q298997 | kg:/m/0m8mp | Levi | Morton | 1824-05-16 | M | 18601 | Parsons | ||||||||||||||||
H000493 | Thomas Hendricks | H000493 | 405356 | 4319 | Thomas A. Hendricks | Q310843 | kg:/m/0m8m6 | Thomas | Hendricks | 1819-09-07 | M | 14894 | Andrews | ||||||||||||||||
W000341 | William Wheeler | W000341 | 411503 | 9995 | William A. Wheeler | Q310835 | kg:/m/0m8lc | William | Wheeler | 1819-06-30 | M | 23623 | Almon | ||||||||||||||||
W000585 | Henry Wilson | W000585 | 411739 | 10225 | Henry Wilson | Q313302 | kg:/m/0m8k6 | Henry | Wilson | 1812-02-16 | M | ||||||||||||||||||
C000626 | Schuyler Colfax | C000626 | 402755 | 1938 | Schuyler Colfax | Q310852 | kg:/m/0m8hx | Schuyler | Colfax | 1823-03-23 | M | 11234 | |||||||||||||||||
B000789 | John Breckinridge | B000789 | 401746 | 995 | John C. Breckinridge | Q273212 | kg:/m/0m8gj | John | Breckinridge | 1821-01-16 | M | 9799 | Cabell | ||||||||||||||||
K000217 | William King | K000217 | 406377 | 5275 | William R. King | Q298985 | kg:/m/0m8fn | William | King | 1786-04-07 | M | 16350 | Rufus de Vane | ||||||||||||||||
D000011 | George Dallas | D000011 | 403154 | 2305 | George M. Dallas | Q310849 | kg:/m/0m89b | George | Dallas | 1792-07-10 | M | 7701 | Mifflin | ||||||||||||||||
J000170 | Richard Johnson | J000170 | 406067 | 4988 | Richard Mentor Johnson | Q109463 | kg:/m/0m87r | Richard | Johnson | 1780-10-17 | M | 15909 | Mentor | ||||||||||||||||
R000566 | Jim Ryun | R000566 | 400353 | 29723 | Jim Ryun | Q1345537 | kg:/m/0m6p3 | Jim | Ryun | 1947-04-29 | M | 20778 | R. | 01521 | N00005218 | ||||||||||||||
M001187 | Mark Meadows | M001187 | 412552 | 21348 | Mark Meadows (North Carolina politician) | Q3956796 | kg:/m/0lqdy32 | Mark | Meadows | 1959-07-28 | M | Mark Meadows, North Carolina | 02142 | 79621 | 136459 | Mark Meadows | N00033631 | [ "H2NC11080" ] |
1776 | ||||||||||
C001093 | Doug Collins | C001093 | 412531 | 21323 | Doug Collins (politician) | Q3162841 | kg:/m/0lq9rkz | Doug | Collins | 1966-08-16 | M | Doug Collins | 02121 | 79719 | 67851 | Doug Collins | N00033518 | [ "H2GA09150" ] |
1755 | ||||||||||
M001190 | Markwayne Mullin | M001190 | 412568 | 21355 | Markwayne Mullin | Q3448772 | kg:/m/0lq78pn | Markwayne | Mullin | 1977-07-26 | M | Markwayne Mullin | 02156 | 1034045 | 135898 | Markwayne Mullin | N00033410 | [ "H2OK02083" ] |
1792 | ||||||||||
V000132 | Filemon Vela | V000132 | 412580 | 21366 | Filemon Vela Jr. | Q4069225 | kg:/m/0ll43fz | Filemon | Vela | 1963-02-13 | M | Filemon Vela | 02167 | 95434 | 137719 | Filemon Vela | N00034349 | [ "H2TX27190" ] |
1804 | ||||||||||
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" ] |
|||||||||||
D000621 | Ron DeSantis | D000621 | 412526 | 21318 | Ron DeSantis | Q3105215 | kg:/m/0l8mn35 | Ron | DeSantis | 1978-09-14 | M | Ron DeSantis | 02116 | 79744 | 137630 | Ron DeSantis | N00034746 | [ "H2FL00292" ] |
1750 | ||||||||||
R000596 | Trey Radel | R000596 | 412528 | 21320 | Trey Radel | Q3182072 | kg:/m/0l8m0r5 | Trey | Radel | 1976-04-20 | M | Trey Radel | 02118 | 79974 | 137658 | Trey Radel | N00034017 | [ "H2FL14194" ] |
1752 | ||||||||||
Y000065 | Ted Yoho | Y000065 | 412525 | 21317 | Ted Yoho | Q3090476 | kg:/m/0l8lwvh | Ted | Yoho | 1955-04-13 | M | S. | Ted Yoho | 02115 | 63943 | 137622 | Ted S. Yoho | N00033220 | [ "H2FL06109" ] |
1749 | |||||||||
E000293 | Elizabeth Esty | E000293 | 412524 | 21316 | Elizabeth Esty | Q3090454 | kg:/m/0l8ll7_ | Elizabeth | Esty | 1959-08-25 | F | 15032387067 | H. | Elzabeth Esty | 02114 | 1020906 | 72826 | Elizabeth H. Esty | N00033217 | [ "H2CT05131" ] |
1748 | ||||||||
R000108 | Brazilla Reece | R000108 | 409088 | 7777 | B. Carroll Reece | Q903196 | kg:/m/0kzh1 | Brazilla | Reece | 1889-12-22 | M | 20214 | Carroll | ||||||||||||||||
C000918 | David Crockett | C000918 | 403030 | 2187 | Davy Crockett | Q311070 | kg:/m/0kycs | David | Crockett | 1786-08-17 | M | 11603 | |||||||||||||||||
J000295 | David Joyce | J000295 | 412566 | 21353 | David Joyce (politician) | Q976778 | kg:/m/0ktwnp_ | David | Joyce | 1957-03-17 | M | P. | David Joyce | 02154 | 68561 | 143052 | David P. Joyce | N00035007 | [ "H2OH14064" ] |
1790 | |||||||||
A000133 | John Allen | A000133 | 400789 | 116 | John J. Allen Jr. | Q1700644 | kg:/m/0ktcpm | John | Allen | 1899-11-27 | M | 8445 | Joseph | Jr. | |||||||||||||||
P000385 | Vance Plauché | P000385 | 408779 | 7485 | Vance Plauché | Q1479745 | kg:/m/0ktcct | Vance | Plauché | 1897-08-25 | M | 19755 | Gabriel | ||||||||||||||||
M000875 | William Montgomery | M000875 | 407847 | 6610 | William Montgomery (congressman) | Q8015750 | kg:/m/0ktc3j | William | Montgomery | 1818-04-11 | M | 18430 | |||||||||||||||||
D000350 | Milo Dimmick | D000350 | 403468 | 2600 | Milo Melankthon Dimmick | Q13219602 | kg:/m/0ktc2s | Milo | Dimmick | 1811-10-30 | M | 12261 | Melankthon | ||||||||||||||||
D000351 | William Dimmick | D000351 | 403469 | 2601 | William Harrison Dimmick | Q8010946 | kg:/m/0ktc20 | William | Dimmick | 1815-12-20 | M | 12262 | Harrison | ||||||||||||||||
S000921 | William Stewart | S000921 | 410381 | 8947 | William Stewart (Pennsylvania politician) | Q8018828 | kg:/m/0ktc17 | William | Stewart | 1810-09-10 | M | 22277 | |||||||||||||||||
J000281 | Benjamin Junkin | J000281 | 406173 | 5086 | Benjamin Franklin Junkin | Q4888651 | kg:/m/0ktc0h | Benjamin | Junkin | 1822-11-12 | M | 16051 | Franklin | ||||||||||||||||
H000046 | Chapin Hall | H000046 | 404931 | 3934 | Chapin Hall | Q5073163 | kg:/m/0ktc03 | Chapin | Hall | 1816-07-12 | M | 14345 | |||||||||||||||||
B000002 | Elijah Babbitt | B000002 | 401008 | 312 | Elijah Babbitt | Q5360882 | kg:/m/0ktbz_ | Elijah | Babbitt | 1795-07-29 | M | 8775 | |||||||||||||||||
L000432 | Henry Longnecker | L000432 | 406923 | 5769 | Henry Clay Longnecker | Q5719508 | kg:/m/0ktbyh | Henry | Longnecker | 1820-04-17 | M | 17131 | Clay | ||||||||||||||||
M000782 | William Millward | M000782 | 407760 | 6535 | William Millward | Q8015652 | kg:/m/0ktbxr | William | Millward | 1822-06-30 | M | 18309 | |||||||||||||||||
V000090 | John Verree | V000090 | 411145 | 9664 | John Paul Verree | Q6252287 | kg:/m/0ktbwm | John | Verree | 1817-03-09 | M | 20983 | Paul | ||||||||||||||||
M000975 | Edward Morris | M000975 | 407943 | 6702 | Edward Joy Morris | Q5343862 | kg:/m/0ktbw_ | Edward | Morris | 1815-07-16 | M | 18550 | Joy | ||||||||||||||||
W000696 | John Wood | W000696 | 411848 | 10326 | John Wood (congressman) | Q2729966 | kg:/m/0ktbvv | John | Wood | 1816-09-06 | M | 24047 | |||||||||||||||||
D000143 | William Davis | D000143 | 403276 | 2418 | William Morris Davis (congressman) | Q8015836 | kg:/m/0ktbtn | William | Davis | 1815-08-16 | M | 12009 | Morris | ||||||||||||||||
H000562 | John Hickman | H000562 | 405424 | 4384 | John Hickman (Pennsylvania politician) | Q6239195 | kg:/m/0ktbt7 | John | Hickman | 1810-09-11 | M | 14978 | |||||||||||||||||
F000214 | Thomas Florence | F000214 | 404169 | 3229 | Thomas Birch Florence | Q13219622 | kg:/m/0ktbql | Thomas | Florence | 1812-01-26 | M | 13239 | Birch | ||||||||||||||||
L000227 | William Lehman | L000227 | 406731 | 5592 | William Eckart Lehman | Q8008363 | kg:/m/0ktbq6 | William | Lehman | 1821-08-21 | M | 16874 | Eckart | ||||||||||||||||
S000158 | John Schwartz | S000158 | 409665 | 8286 | John Schwartz | Q6257008 | kg:/m/0ktbpv | John | Schwartz | 1793-10-27 | M | 21336 | |||||||||||||||||
M000503 | Jacob McKenty | M000503 | 407498 | 6297 | Jacob Kerlin McKenty | Q6118849 | kg:/m/0ktbpg | Jacob | McKenty | 1827-01-19 | M | 17957 | Kerlin | ||||||||||||||||
C000763 | Thomas Cooper | C000763 | 402883 | 2057 | Thomas Buchecker Cooper | Q7788001 | kg:/m/0ktbmk | Thomas | Cooper | 1823-12-29 | M | 11411 | Buchecker | ||||||||||||||||
M000531 | Robert McKnight | M000531 | 407523 | 6319 | Robert McKnight | Q7347557 | kg:/m/0ktb_r | Robert | McKnight | 1820-01-20 | M | 17991 | |||||||||||||||||
S000036 | Jared Sanders | S000036 | 409553 | 8198 | Jared Y. Sanders Jr. | Q1683484 | kg:/m/0ktb8_ | Jared | Sanders | 1892-04-20 | M | 21177 | Young | Jr. | |||||||||||||||
S000147 | John Schumaker | S000147 | 409655 | 8276 | John G. Schumaker | Q219486 | kg:/m/0ktb86 | John | Schumaker | 1826-06-27 | M | 21320 | Godfrey | ||||||||||||||||
S000035 | Jared Sanders | S000035 | 409552 | 8197 | Jared Y. Sanders Sr. | Q433026 | kg:/m/0kt9wr | Jared | Sanders | 1869-01-29 | M | 21176 | Young | ||||||||||||||||
C000088 | James Campbell | C000088 | 402244 | 1453 | James Hepburn Campbell | Q6135946 | kg:/m/0kt9wc | James | Campbell | 1820-02-08 | M | 10555 | Hepburn | ||||||||||||||||
H000032 | James Hale | H000032 | 404917 | 3920 | James Tracy Hale | Q6144388 | kg:/m/0kt9n7 | James | Hale | 1810-10-14 | M | 14328 | Tracy | ||||||||||||||||
T000345 | Henry Tracy | T000345 | 410916 | 9449 | Henry Wells Tracy | Q5729994 | kg:/m/0kt9mh | Henry | Tracy | 1807-09-24 | M | 23058 | Wells | ||||||||||||||||
B000142 | Abraham Barker | B000142 | 401143 | 434 | Abraham Andrews Barker | Q4668747 | kg:/m/0kt9m3 | Abraham | Barker | 1816-03-30 | M | 8954 | Andrews | ||||||||||||||||
J000168 | Philip Johnson | J000168 | 406065 | 4986 | Philip Johnson (congressman) | Q7183858 | kg:/m/0kt9lq | Philip | Johnson | 1818-01-17 | M | 15906 | |||||||||||||||||
B000043 | Joseph Bailey | B000043 | 401048 | 346 | Joseph Bailey (congressman) | Q6281276 | kg:/m/0kt9l9 | Joseph | Bailey | 1810-03-18 | M | 8828 | |||||||||||||||||
M000295 | Archibald McAllister | M000295 | 407310 | 6121 | Archibald McAllister | Q4786428 | kg:/m/0kt9kk | Archibald | McAllister | 1813-10-12 | M | 17687 |
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);