legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
384 rows where name_suffix = "Jr." sorted by id_wikipedia descending
This data as json, copyable, CSV (advanced)
Suggested facets: name_nickname, id_fec (array)
bio_birthday (date) >30 ✖
- 1926-08-07 2
- 1739-07-19 1
- 1740-03-26 1
- 1756-11-03 1
- 1758-11-25 1
- 1760-06-20 1
- 1762-01-09 1
- 1762-05-03 1
- 1762-08-29 1
- 1762-12-05 1
- 1763-09-30 1
- 1764-07-03 1
- 1764-11-17 1
- 1765-06-12 1
- 1765-10-30 1
- 1766-05-01 1
- 1768-08-29 1
- 1768-11-21 1
- 1769-11-20 1
- 1770-03-07 1
- 1771-04-04 1
- 1772-04-25 1
- 1772-10-04 1
- 1777-01-20 1
- 1777-04-05 1
- 1778-01-28 1
- 1778-10-29 1
- 1778-12-24 1
- 1780-09-07 1
- 1781-08-04 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
F000329 | Wyche Fowler | F000329 | 404277 | 14467 | Wyche Fowler | Q446778 | kg:/m/03n_n0 | Wyche | Fowler | 1940-10-06 | M | 13387 | Jr. | 00405 | S183 | ||||||||||||||
W000481 | William Willett | W000481 | 411638 | 10126 | William Willett Jr. | Q2808000 | kg:/m/02rkydx | William | Willett | 1869-11-27 | M | 23789 | Forte | Jr. | |||||||||||||||
A000103 | William Alexander | A000103 | 400761 | 12000 | William Vollie Alexander Jr. | Q861905 | kg:/m/08j19v | William | Alexander | 1934-01-16 | M | 8401 | Vollie | Bill | Jr. | 00010 | |||||||||||||
S000739 | William Spong | S000739 | 410208 | 11206 | William Spong Jr. | Q6329296 | kg:/m/053s_8 | William | Spong | 1920-09-29 | M | Belser | Jr. | ||||||||||||||||
R000460 | William Roth | R000460 | 400565 | 11044 | William Roth | Q1400609 | kg:/m/023xsb | William | Roth | 1921-07-22 | M | 20652 | V. | Jr. | 01425 | S083 | |||||||||||||
H000947 | William Hull | H000947 | 405792 | 4724 | William Raleigh Hull Jr. | Q2580348 | kg:/m/02rwzll | William | Hull | 1906-04-17 | M | 15453 | Raleigh | Jr. | |||||||||||||||
C000616 | William Cole | C000616 | 402745 | 1930 | William Purington Cole Jr. | Q808708 | kg:/m/0916k3 | William | Cole | 1889-05-11 | M | 11220 | Purington | Jr. | |||||||||||||||
P000394 | William Plumer | P000394 | 408788 | 7494 | William Plumer Jr. | Q1495084 | kg:/m/02rj_xj | William | Plumer | 1789-02-09 | M | 19765 | Jr. | ||||||||||||||||
P000146 | William Paulding | P000146 | 408551 | 7269 | William Paulding Jr. | Q82449 | kg:/m/026t9n6 | William | Paulding | 1770-03-07 | M | 19454 | Jr. | ||||||||||||||||
C000997 | William Curlin | C000997 | 403104 | 13051 | William P. Curlin Jr. | Q635447 | kg:/m/02rj_w4 | William | Curlin | 1933-11-30 | M | 11699 | Prather | Jr. | |||||||||||||||
C000694 | William Connery | C000694 | 402819 | 1996 | William P. Connery Jr. | Q2580184 | kg:/m/0dwtz5 | William | Connery | 1888-08-24 | M | 11324 | Patrick | Jr. | |||||||||||||||
M000784 | William Milnes | M000784 | 407762 | 6537 | William Milnes Jr. | Q2580007 | kg:/m/02874z9 | William | Milnes | 1827-12-08 | M | 18311 | Jr. | ||||||||||||||||
M000522 | William McKinley | M000522 | 407515 | 6312 | William McKinley | Q35041 | kg:/m/083p7 | William | McKinley | 1843-01-29 | M | 17980 | Jr. | ||||||||||||||||
K000122 | William Kennon | K000122 | 406288 | 5192 | William Kennon Jr. | Q8013940 | kg:/m/02rm3ps | William | Kennon | 1802-06-12 | M | 16229 | Jr. | ||||||||||||||||
G000421 | William Green | G000421 | 404769 | 3785 | William J. Green Jr. | Q13219635 | kg:/m/0djcwp | William | Green | 1910-03-05 | M | 14100 | Joseph | Jr. | |||||||||||||||
H000411 | William Haywood | H000411 | 405278 | 4250 | William Henry Haywood Jr. | Q5794515 | kg:/m/02kl5v | William | Haywood | 1801-10-23 | M | Henry | Jr. | ||||||||||||||||
H000410 | William Hayward | H000410 | 405277 | 4249 | William Hayward Jr. | Q2655576 | kg:/m/0dz3y6 | William | Hayward | M | 14787 | Jr. | |||||||||||||||||
M000770 | William Milliken | M000770 | 407748 | 6524 | William H. Milliken Jr. | Q8010514 | kg:/m/0dzrrc | William | Milliken | 1897-08-19 | M | 18293 | H. | Jr. | |||||||||||||||
B000949 | William Brown | B000949 | 401902 | 1138 | William Gay Brown Jr. | Q1743263 | kg:/m/03c1s6n | William | Brown | 1856-04-07 | M | 10001 | Gay | Jr. | |||||||||||||||
C000523 | William Clinger | C000523 | 402657 | 14612 | William F. Clinger Jr. | Q8008766 | kg:/m/0dlrhm | William | Clinger | 1929-04-04 | M | 11101 | Floyd | Jr. | 00207 | ||||||||||||||
M000799 | William Minshall | M000799 | 407775 | 6548 | William Edwin Minshall Jr. | Q2578640 | kg:/m/027m5cp | William | Minshall | 1911-10-24 | M | 18333 | Edwin | Jr. | 00816 | ||||||||||||||
T000439 | William Tuttle | T000439 | 411007 | 9532 | William E. Tuttle Jr. | Q1645378 | kg:/m/02x12y2 | William | Tuttle | 1870-12-10 | M | 23173 | Edgar | Jr. | |||||||||||||||
C000902 | William Creighton | C000902 | 403014 | 2172 | William Creighton Jr. | Q250272 | kg:/m/0d7qm5 | William | Creighton | 1778-10-29 | M | 11583 | Jr. | ||||||||||||||||
C000843 | William Coxe | C000843 | 402960 | 2122 | William Coxe Jr. | Q1570579 | kg:/m/02rtnnv | William | Coxe | 1762-05-03 | M | 11511 | Jr. | ||||||||||||||||
S000073 | Willard Saulsbury | S000073 | 409585 | 8224 | Willard Saulsbury Jr. | Q1394349 | kg:/m/07nwwm | Willard | Saulsbury | 1861-04-17 | M | Jr. | |||||||||||||||||
R000406 | William Rogers | R000406 | 409375 | 8037 | Will Rogers Jr. | Q2541984 | kg:/m/08xhry | William | Rogers | 1911-10-20 | M | 20588 | Vann | Jr. | |||||||||||||||
W000565 | Westel Willoughby | W000565 | 411721 | 10207 | Westel Willoughby Jr. | Q3661182 | kg:/m/02rkxp4 | Westel | Willoughby | 1769-11-20 | M | 23884 | Jr. | ||||||||||||||||
B000141 | Walter Baring | B000141 | 401142 | 433 | Walter S. Baring Jr. | Q1716012 | kg:/m/02730wb | Walter | Baring | 1911-09-09 | M | 8952 | Stephan | Jr. | |||||||||||||||
M000608 | Walter McVey | M000608 | 407597 | 10536 | Walter Lewis McVey Jr. | Q2545377 | kg:/m/02rm9v2 | Walter | McVey | 1922-02-19 | M | 18087 | Lewis | Jr. | |||||||||||||||
F000242 | Walter Folger | F000242 | 404196 | 3252 | Walter Folger Jr. | Q1315384 | kg:/m/02rj_1p | Walter | Folger | 1765-06-12 | M | 13279 | Jr. | ||||||||||||||||
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" } ] |
||||||
F000252 | Wallace Foote | F000252 | 404206 | 3261 | Wallace T. Foote Jr. | Q7962904 | kg:/m/02rkxjb | Wallace | Foote | 1864-04-07 | M | 13292 | Turner | Jr. | |||||||||||||||
W000396 | Wallace White | W000396 | 411556 | 10047 | Wallace H. White Jr. | Q442200 | kg:/m/049dlm | Wallace | White | 1877-08-06 | M | 23685 | Humphrey | Jr. | |||||||||||||||
T000221 | Waddy Thompson | T000221 | 410800 | 9342 | Waddy Thompson Jr. | Q2538676 | kg:/m/02ry1yx | Waddy | Thompson | 1798-01-08 | M | 22904 | Jr. | ||||||||||||||||
S001039 | Williamson Stuckey | S001039 | 410495 | 11052 | W. S. Stuckey Jr. | Q1475335 | kg:/m/0cb445 | Williamson | Stuckey | 1935-05-25 | M | 22421 | Sylvester | Jr. | 01120 | ||||||||||||||
F000440 | Vito Fossella | F000440 | 400139 | 29773 | Vito Fossella | Q5738335 | kg:/m/03tt8k | Vito | Fossella | 1965-03-09 | M | 13530 | J. | Jr. | 01484 | 16455 | N00000983 | [ "H8NY13028" ] |
|||||||||||
G000280 | Virgil Goode | G000280 | 400153 | 89767 | Virgil Goode | Q159684 | kg:/m/028vt_ | Virgil | Goode | 1946-10-17 | M | 13917 | H. | Jr. | 01486 | 527 | N00002167 | [ "H6VA05068" ] |
|||||||||||
F000053 | Victor Fazio | F000053 | 404013 | 14624 | Vic Fazio | Q2522387 | kg:/m/09lysg | Victor | Fazio | 1942-10-11 | M | 13032 | Herbert | Jr. | 00374 | ||||||||||||||
G000515 | Vonno Gudger | G000515 | 404860 | 14424 | V. Lamar Gudger | Q2505234 | kg:/m/027h6sk | Vonno | Gudger | 1919-04-30 | M | 14211 | Lamar | Jr. | 00475 | ||||||||||||||
M000839 | Anthony Moffett | M000839 | 407813 | 14258 | Toby Moffett | Q2438226 | kg:/m/0kr__c | Anthony | Moffett | 1944-08-18 | M | 18384 | John | Toby | Jr. | 00821 | |||||||||||||
O000098 | Thomas O’Neill | O000098 | 408307 | 7081 | Tip O'Neill | Q2094491 | kg:/m/01ncrk | Thomas | O’Neill | 1912-12-09 | M | 19187 | Phillip | Tip | Jr. | 00874 | |||||||||||||
H000855 | Thomas Howe | H000855 | 405702 | 4641 | Thomas Y. Howe Jr. | Q7795367 | kg:/m/02rkxdk | Thomas | Howe | M | 15343 | Y. | Jr. | ||||||||||||||||
W000345 | Thomas Whipple | W000345 | 411507 | 9999 | Thomas Whipple Jr. | Q475751 | kg:/m/02rk09y | Thomas | Whipple | M | 23627 | Jr. | |||||||||||||||||
P000314 | Thomas Phillips | P000314 | 408713 | 7419 | Thomas Wharton Phillips Jr. | Q7795027 | kg:/m/0ft52l | Thomas | Phillips | 1874-11-21 | M | 19663 | Wharton | Jr. | |||||||||||||||
R000353 | Thomas Robinson | R000353 | 409324 | 7991 | Thomas Robinson Jr. | Q2426872 | kg:/m/0ds4pr | Thomas | Robinson | M | 20518 | Jr. | |||||||||||||||||
N000078 | Thomas Newton | N000078 | 408165 | 6905 | Thomas Newton Jr. | Q2426306 | kg:/m/01mrzn | Thomas | Newton | 1768-11-21 | M | 18931 | Jr. | ||||||||||||||||
M001115 | Thomas Murray | M001115 | 408078 | 6825 | Thomas Murray Jr. | Q7792626 | kg:/m/027hk6w | Thomas | Murray | M | 18719 | Jr. | |||||||||||||||||
M000431 | Thomas McEwan | M000431 | 407431 | 6237 | Thomas McEwan Jr. | Q2426053 | kg:/m/02x2k5k | Thomas | McEwan | 1854-02-26 | M | 17867 | Jr. | ||||||||||||||||
H000181 | Thomas Hardeman | H000181 | 405062 | 4049 | Thomas Hardeman Jr. | Q2424524 | kg:/m/027crr7 | Thomas | Hardeman | 1825-01-12 | M | 14510 | Jr. | ||||||||||||||||
G000150 | Thomas Gholson | G000150 | 412043 | 3552 | Thomas Gholson Jr. | Q138190 | kg:/m/02vp08h | Thomas | Gholson | M | 13750 | Jr. | |||||||||||||||||
B000252 | Thomas Bayard | B000252 | 401246 | 529 | Thomas F. Bayard Jr. | Q1691899 | kg:/m/06vw0f | Thomas | Bayard | 1868-06-04 | M | Francis | Jr. | ||||||||||||||||
D000007 | Thomas D’Alesandro | D000007 | 403141 | 2304 | Thomas D'Alesandro Jr. | Q1156152 | kg:/m/028qh5 | Thomas | D’Alesandro | 1903-08-01 | M | 11841 | Jr. | ||||||||||||||||
C000353 | Thomas Child | C000353 | 402492 | 1691 | Thomas Child Jr. | Q1193423 | kg:/m/02rkx0j | Thomas | Child | 1818-03-22 | M | 10897 | Jr. | ||||||||||||||||
M000459 | Thomas McGrath | M000459 | 407458 | 10750 | Thomas C. McGrath Jr. | Q1661034 | kg:/m/02rt_z9 | Thomas | McGrath | 1927-04-22 | M | 17897 | Charles | Jr. | |||||||||||||||
H000502 | Thomas Hennings | H000502 | 405365 | 4328 | Thomas C. Hennings Jr. | Q2422886 | kg:/m/0d04bk | Thomas | Hennings | 1903-06-25 | M | 14907 | Carey | Jr. | |||||||||||||||
B000209 | Thomas Bartlett | B000209 | 401207 | 492 | Thomas Bartlett Jr. | Q2422254 | kg:/m/02rjznz | Thomas | Bartlett | 1808-06-18 | M | 9043 | Jr. | ||||||||||||||||
E000258 | Thomas Evans | E000258 | 403939 | 14417 | Thomas B. Evans Jr. | Q2422171 | kg:/m/06t6k4 | Thomas | Evans | 1931-11-05 | M | 12918 | Beverley | Jr. | 00363 | ||||||||||||||
H000530 | Albert Herlong | H000530 | 405392 | 4354 | Syd Herlong | Q2638906 | kg:/m/02rgvx8 | Albert | Herlong | 1909-02-14 | M | 14941 | Sydney | Jr. | |||||||||||||||
B000979 | Stephen Brundidge | B000979 | 401931 | 1164 | Stephen Brundidge Jr. | Q1434311 | kg:/m/02rjzf1 | Stephen | Brundidge | 1857-01-01 | M | 10043 | Jr. | ||||||||||||||||
H000617 | Solomon Hillen Solomon | H000617 | 405476 | 4432 | Solomon Hillen Jr. | Q1586483 | kg:/m/02rl44v | Solomon | Hillen Solomon | 1810-07-10 | M | 15047 | Jr. | ||||||||||||||||
E000167 | Smith Ely | E000167 | 403858 | 2955 | Smith Ely Jr. | Q1193094 | kg:/m/02sbdv | Smith | Ely | 1825-04-17 | M | 12797 | Jr. | ||||||||||||||||
W000770 | Silas Wright | W000770 | 411919 | 10398 | Silas Wright | Q777453 | kg:/m/02z5dk | Silas | Wright | 1795-05-24 | M | 24137 | Jr. | ||||||||||||||||
C000960 | Shepard Crumpacker | C000960 | 403072 | 2227 | Shepard J. Crumpacker Jr. | Q2800593 | kg:/m/02rkhp4 | Shepard | Crumpacker | 1917-02-13 | M | 11652 | J. | Jr. | |||||||||||||||
B000490 | Sanford Bishop | B000490 | 400030 | 29339 | Sanford Bishop | Q983428 | kg:/m/02554k | Sanford | Bishop | 1947-02-04 | M | 7697 | D. | Sanford Bishop Jr. | Jr. | 00091 | 26194 | 26817 | Sanford D. Bishop, Jr. | N00002674 | [ "H2GA02031" ] |
148 | |||||||
M000354 | Samuel McConnell | M000354 | 407362 | 6169 | Samuel K. McConnell Jr. | Q7411886 | kg:/m/0dzvln | Samuel | McConnell | 1901-04-06 | M | 17768 | Kerns | Jr. | |||||||||||||||
E000211 | Samuel Ervin | E000211 | 403898 | 2987 | Sam Ervin | Q322911 | kg:/m/02kly2 | Samuel | Ervin | 1896-09-27 | M | 12860 | James | Jr. | 01326 | ||||||||||||||
H000070 | Sam Hall | H000070 | 404954 | 14291 | Sam B. Hall Jr. | Q1656192 | kg:/m/02q3qz | Sam | Hall | 1924-01-11 | M | 14374 | Blakeley | Jr. | 00485 | ||||||||||||||
D000256 | Stanley Dent | D000256 | 403394 | 2514 | S. Hubert Dent Jr. | Q1592720 | kg:/m/02rk26s | Stanley | Dent | 1869-08-16 | M | 12147 | Hubert | Jr. | |||||||||||||||
T000034 | Robert Tallon | T000034 | 410623 | 15068 | Robin Tallon | Q2159908 | kg:/m/0265rfm | Robert | Tallon | 1946-08-08 | M | 22675 | Mooneyhan | Robin | Jr. | 01136 | |||||||||||||
B000280 | Robin Beard | B000280 | 401274 | 14004 | Robin Beard | Q963419 | kg:/m/03z10z | Robin | Beard | 1939-08-21 | M | 9139 | Leo | Jr. | 00069 | ||||||||||||||
T000185 | Robert Thomas | T000185 | 410766 | 9309 | Robert Y. Thomas Jr. | Q2159247 | kg:/m/02rjyx6 | Robert | Thomas | 1855-07-13 | M | 22858 | Young | Jr. | |||||||||||||||
T000010 | Robert Taft | T000010 | 410600 | 10630 | Robert Taft Jr. | Q1614966 | kg:/m/02rppt | Robert | Taft | 1917-02-26 | M | 22644 | Jr. | 01445 | |||||||||||||||
R000063 | Robert Rantoul | R000063 | 409043 | 7738 | Robert Rantoul Jr. | Q2158571 | kg:/m/0bffpr | Robert | Rantoul | 1805-08-13 | M | 20159 | Jr. | ||||||||||||||||
O000105 | Robert Orr | O000105 | 408362 | 7088 | Robert Orr Jr. | Q7348159 | kg:/m/0276x4l | Robert | Orr | 1786-03-05 | M | 19195 | Jr. | ||||||||||||||||
N000121 | Robert Nodar | N000121 | 408205 | 6944 | Robert Nodar Jr. | Q1103414 | kg:/m/027l9q6 | Robert | Nodar | 1916-03-23 | M | 18981 | Joseph | Jr. | |||||||||||||||
L000005 | Robert La Follette | L000005 | 406515 | 5402 | Robert M. La Follette Jr. | Q377506 | kg:/m/01sv50 | Robert | La Follette | 1895-02-06 | M | Marion | Jr. | ||||||||||||||||
C000586 | Robert Coffey | C000586 | 402715 | 1901 | Robert L. Coffey | Q7346534 | kg:/m/0dp81_ | Robert | Coffey | 1918-10-21 | M | 11185 | Lewis | Jr. | |||||||||||||||
S000860 | Robert Stephens | S000860 | 410323 | 10563 | Robert Grier Stephens Jr. | Q1780413 | kg:/m/0270skp | Robert | Stephens | 1913-08-14 | M | 22203 | Grier | Jr. | 01111 | ||||||||||||||
J000248 | Robert Jones | J000248 | 406141 | 5058 | Robert E. Jones Jr. | Q174690 | kg:/m/02qgx09 | Robert | Jones | 1912-06-12 | M | 16006 | Emmett | Jr. | 00610 | ||||||||||||||
C000868 | Robert Cramer | C000868 | 400084 | 29100 | Robert E. Cramer | Q1368460 | kg:/m/024p0g | Robert | Cramer | 1947-08-22 | M | 11542 | E. | Bud | Jr. | 00247 | 26714 | N00003042 | [ "H0AL05049" ] |
||||||||||
D000037 | Robert Daniel | D000037 | 403177 | 14013 | Robert Daniel | Q1356455 | kg:/m/09dbt_ | Robert | Daniel | 1936-03-17 | M | 11875 | Williams | Jr. | 00260 | ||||||||||||||
A000044 | Robert Adams | A000044 | 400705 | 36 | Robert Adams Jr. | Q7341350 | kg:/m/0dhs2_ | Robert | Adams | 1849-02-26 | M | 8315 | Jr. | ||||||||||||||||
R000536 | Richard Russell | R000536 | 409493 | 8138 | Richard Russell Jr. | Q718415 | kg:/m/0268my | Richard | Russell | 1897-11-02 | M | Brevard | Jr. | ||||||||||||||||
J000025 | Richard Jackson | J000025 | 405931 | 4862 | Richard Jackson Jr. | Q2149883 | kg:/m/02rjyc0 | Richard | Jackson | 1764-07-03 | M | 15721 | Jr. | ||||||||||||||||
S000694 | Richard Spaight | S000694 | 410165 | 8757 | Richard Dobbs Spaight Jr. | Q884075 | kg:/m/02j1nz | Richard | Spaight | M | 21995 | Dobbs | Jr. | ||||||||||||||||
C000602 | Richard Coke | C000602 | 402731 | 1916 | Richard Coke Jr. | Q1680049 | kg:/m/027w8qd | Richard | Coke | 1790-11-16 | M | 11204 | Jr. | ||||||||||||||||
A000230 | Richard Anderson | A000230 | 400857 | 179 | Richard Clough Anderson Jr. | Q2149242 | kg:/m/07jm8p | Richard | Anderson | 1788-08-04 | M | 8586 | Clough | Jr. | |||||||||||||||
M000633 | Return Meigs | M000633 | 407620 | 6408 | Return J. Meigs Jr. | Q744819 | kg:/m/0340r0 | Return | Meigs | 1764-11-17 | M | Jonathan | Jr. | ||||||||||||||||
T000243 | Raymond Thornton | T000243 | 410821 | 14058 | Ray Thornton | Q2133994 | kg:/m/026j600 | Raymond | Thornton | 1928-07-16 | M | 22928 | Hoyt | Ray | Jr. | 01156 | |||||||||||||
K000364 | John Kuhl | K000364 | 400642 | 20520 | Randy Kuhl | Q5925486 | kg:/m/04cvlt | John | Kuhl | 1943-04-19 | M | 16552 | R. | Randy | Jr. | 01795 | 4233 | N00026087 | [ "H4NY29080" ] |
||||||||||
P000516 | Prince Preston | P000516 | 408901 | 7605 | Prince Hulon Preston Jr. | Q1500509 | kg:/m/026xzj8 | Prince | Preston | 1908-07-05 | M | 19917 | Hulon | Jr. | |||||||||||||||
H000197 | Porter Hardy | H000197 | 405078 | 4064 | Porter Hardy Jr. | Q2105061 | kg:/m/02vp0c7 | Porter | Hardy | 1903-06-01 | M | 14530 | Jr. | ||||||||||||||||
V000023 | Pierre Van Cortlandt | V000023 | 411076 | 9603 | Pierre Van Cortlandt Jr. | Q2093953 | kg:/m/026psf9 | Pierre | Van Cortlandt | 1762-08-29 | M | 20906 | Jr. | ||||||||||||||||
M000391 | Philip McCulloch | M000391 | 407392 | 6202 | Philip D. McCulloch Jr. | Q1451039 | kg:/m/02rjy11 | Philip | McCulloch | 1851-06-23 | M | 17813 | Doddridge | Jr. | |||||||||||||||
T000212 | Philip Thompson | T000212 | 410791 | 9334 | Philip B. Thompson Jr. | Q2086047 | kg:/m/02rjy0q | Philip | Thompson | 1845-10-15 | M | 22893 | Burton | Jr. | |||||||||||||||
R000374 | Peter Rodino | R000374 | 409344 | 8010 | Peter W. Rodino | Q2078864 | kg:/m/02gqtn | Peter | Rodino | 1909-06-07 | M | 20545 | Wallace | Jr. | 00973 | ||||||||||||||
I000006 | Peter Ihrie | I000006 | 405868 | 4795 | Peter Ihrie Jr. | Q7174825 | kg:/m/026t9gc | Peter | Ihrie | 1796-02-03 | M | 15625 | Jr. | ||||||||||||||||
F000371 | Peter Frelinghuysen | F000371 | 404317 | 3364 | Peter Frelinghuysen Jr. | Q612300 | kg:/m/04s2q9 | Peter | Frelinghuysen | 1916-01-17 | M | 13438 | Hood Ballantine | Jr. | 00413 | ||||||||||||||
M000020 | Peter Mack | M000020 | 407048 | 5884 | Peter F. Mack Jr. | Q7173908 | kg:/m/02rkc8x | Peter | Mack | 1916-11-01 | M | 17354 | Francis | Jr. | |||||||||||||||
M000343 | Paul McCloskey | M000343 | 407352 | 11063 | Pete McCloskey | Q2073295 | kg:/m/04539r | Paul | McCloskey | 1927-09-29 | M | 17752 | Norton | Pete | Jr. | 00759 |
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);