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 descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
P000314 | Thomas Phillips | P000314 | 408713 | 7419 | Thomas Wharton Phillips Jr. | Q7795027 | kg:/m/0ft52l | Thomas | Phillips | 1874-11-21 | M | 19663 | Wharton | Jr. | |||||||||||||||
P000236 | John Perkins | P000236 | 408639 | 7349 | John Perkins Jr. | Q519697 | kg:/m/02rv9g5 | John | Perkins | 1819-07-01 | M | 19572 | Jr. | ||||||||||||||||
P000194 | Herbert Pell | P000194 | 408598 | 7311 | Herbert Pell | Q1035419 | kg:/m/02nmgh | Herbert | Pell | 1884-02-16 | M | 19515 | Claiborne | Jr. | |||||||||||||||
P000152 | Lewis Payne | P000152 | 408556 | 15452 | Lewis F. Payne Jr. | Q1822094 | kg:/m/0gmzw0 | Lewis | Payne | 1945-07-09 | M | 19464 | Franklin | Jr. | 00903 | ||||||||||||||
P000146 | William Paulding | P000146 | 408551 | 7269 | William Paulding Jr. | Q82449 | kg:/m/026t9n6 | William | Paulding | 1770-03-07 | M | 19454 | Jr. | ||||||||||||||||
P000141 | John Patton | P000141 | 408547 | 7263 | John Patton Jr. | Q1701353 | kg:/m/03ksgn | John | Patton | 1850-10-30 | M | Jr. | |||||||||||||||||
P000114 | Francis Patterson | P000114 | 408522 | 7240 | Francis F. Patterson Jr. | Q1441490 | kg:/m/02rz8q7 | Francis | Patterson | 1867-07-30 | M | 19415 | Ford | Jr. | |||||||||||||||
P000097 | Charles Pashayan | P000097 | 408506 | 14652 | Chip Pashayan | Q1065727 | kg:/m/02qxl9v | Charles | Pashayan | 1941-03-27 | M | 19392 | Jr. | 00891 | |||||||||||||||
P000096 | Bill Pascrell | P000096 | 400309 | 29741 | Bill Pascrell | Q529090 | kg:/m/03txs_ | Bill | Pascrell | 1937-01-25 | M | 19391 | J. | Bill Pascrell | Jr. | 01510 | 45543 | 478 | Bill Pascrell, Jr. | N00000751 | [ "H6NJ08118" ] |
403 | |||||||
P000034 | Frank Pallone | P000034 | 400308 | 15454 | Frank Pallone | Q965289 | kg:/m/0g6t5w | Frank | Pallone | 1951-10-30 | M | 19321 | J. | Frank Pallone | Jr. | 00887 | 6107 | 26951 | Frank Pallone, Jr. | N00000781 | [ "H8NJ03073", "S6NJ00263" ] |
402 | |||||||
O000145 | Edward Overton | O000145 | 408396 | 7125 | Edward Overton Jr. | Q5344707 | kg:/m/0ks_ry | Edward | Overton | 1836-02-04 | M | 19245 | Jr. | ||||||||||||||||
O000120 | Frank Osmers | O000120 | 408375 | 7101 | Frank C. Osmers Jr. | Q1443035 | kg:/m/02rysv7 | Frank | Osmers | 1907-12-30 | M | 19213 | Charles | Jr. | |||||||||||||||
O000105 | Robert Orr | O000105 | 408362 | 7088 | Robert Orr Jr. | Q7348159 | kg:/m/0276x4l | Robert | Orr | 1786-03-05 | M | 19195 | Jr. | ||||||||||||||||
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 | |||||||||||||
O000090 | Maston O’Neal | O000090 | 408299 | 10759 | Maston E. O'Neal Jr. | Q1907965 | kg:/m/02rrjl0 | Maston | O’Neal | 1907-07-19 | M | 19176 | Emmett | Jr. | |||||||||||||||
O000036 | Benjamin Odell | O000036 | 408321 | 7024 | Benjamin Odell (politician) | Q663205 | kg:/m/038qlc | Benjamin | Odell | 1854-01-14 | M | 19114 | Baker | Jr. | |||||||||||||||
N000159 | Charles Norwood | N000159 | 400296 | 29513 | Charlie Norwood | Q507092 | kg:/m/0255j2 | Charles | Norwood | 1941-07-27 | M | 19031 | W. | Charlie | Jr. | 00869 | N00002630 | [ "H4GA10022" ] |
|||||||||||
N000140 | Moses Norris | N000140 | 408224 | 6961 | Moses Norris Jr. | Q939960 | kg:/m/0d7mvf | Moses | Norris | 1799-11-08 | M | 19006 | Jr. | ||||||||||||||||
N000133 | Albin Norblad | N000133 | 408217 | 6955 | A. Walter Norblad | Q2545675 | kg:/m/0273644 | Albin | Norblad | 1908-09-12 | M | 18996 | Walter | Jr. | |||||||||||||||
N000121 | Robert Nodar | N000121 | 408205 | 6944 | Robert Nodar Jr. | Q1103414 | kg:/m/027l9q6 | Robert | Nodar | 1916-03-23 | M | 18981 | Joseph | Jr. | |||||||||||||||
N000078 | Thomas Newton | N000078 | 408165 | 6905 | Thomas Newton Jr. | Q2426306 | kg:/m/01mrzn | Thomas | Newton | 1768-11-21 | M | 18931 | Jr. | ||||||||||||||||
N000051 | George Nethercutt | N000051 | 400292 | 29581 | George Nethercutt | Q164014 | kg:/m/025912 | George | Nethercutt | 1944-10-07 | M | 18898 | R. | Jr. | 00860 | N00008166 | |||||||||||||
M001115 | Thomas Murray | M001115 | 408078 | 6825 | Thomas Murray Jr. | Q7792626 | kg:/m/027hk6w | Thomas | Murray | M | 18719 | Jr. | |||||||||||||||||
M001100 | Maurice Murphy | M001100 | 408064 | 10815 | Maurice J. Murphy Jr. | Q5997815 | kg:/m/08v652 | Maurice | Murphy | 1927-10-03 | M | J. | Jr. | ||||||||||||||||
M001090 | Edward Murphy | M001090 | 408054 | 6806 | Edward Murphy Jr. | Q945610 | kg:/m/09wnxg | Edward | Murphy | 1836-12-15 | M | Jr. | |||||||||||||||||
M001082 | Orrice Murdock | M001082 | 408047 | 6800 | Orrice Abram Murdock Jr. | Q1332532 | kg:/m/0ct1c1 | Orrice | Murdock | 1893-07-18 | M | 18681 | Abram | Abe | Jr. | ||||||||||||||
M001049 | Grant Mouser | M001049 | 408016 | 6769 | Grant E. Mouser Jr. | Q5596199 | kg:/m/02rm4ln | Grant | Mouser | 1895-02-20 | M | 18638 | Earl | Jr. | |||||||||||||||
M001034 | Hunter Moss | M001034 | 408001 | 6755 | Hunter Holmes Moss Jr. | Q1638124 | kg:/m/03c2t6_ | Hunter | Moss | 1874-05-26 | M | 18622 | Holmes | Jr. | |||||||||||||||
M000933 | James Moran | M000933 | 400283 | 29149 | Jim Moran | Q1337736 | kg:/m/025bgj | James | Moran | 1945-05-16 | M | 18503 | P. | Jim | Jim Moran | Jr. | 00832 | 4269 | 27118 | James P. Moran | N00002083 | [ "H0VA08040" ] |
380 | ||||||
M000932 | Edward Moran | M000932 | 407903 | 6663 | Edward C. Moran Jr. | Q1291831 | kg:/m/0cc_f9 | Edward | Moran | 1894-12-29 | M | 18501 | Carleton | Jr. | |||||||||||||||
M000892 | Arch Moore | M000892 | 407864 | 6626 | Arch A. Moore Jr. | Q365572 | kg:/m/026b5t | Arch | Moore | 1923-04-16 | M | 18453 | Alfred | Jr. | |||||||||||||||
M000864 | Daniel Montgomery | M000864 | 407837 | 6601 | Daniel Montgomery Jr. | Q5218178 | kg:/m/027lkc9 | Daniel | Montgomery | 1765-10-30 | M | 18419 | Jr. | ||||||||||||||||
M000839 | Anthony Moffett | M000839 | 407813 | 14258 | Toby Moffett | Q2438226 | kg:/m/0kr__c | Anthony | Moffett | 1944-08-18 | M | 18384 | John | Toby | Jr. | 00821 | |||||||||||||
M000799 | William Minshall | M000799 | 407775 | 6548 | William Edwin Minshall Jr. | Q2578640 | kg:/m/027m5cp | William | Minshall | 1911-10-24 | M | 18333 | Edwin | Jr. | 00816 | ||||||||||||||
M000784 | William Milnes | M000784 | 407762 | 6537 | William Milnes Jr. | Q2580007 | kg:/m/02874z9 | William | Milnes | 1827-12-08 | M | 18311 | Jr. | ||||||||||||||||
M000770 | William Milliken | M000770 | 407748 | 6524 | William H. Milliken Jr. | Q8010514 | kg:/m/0dzrrc | William | Milliken | 1897-08-19 | M | 18293 | H. | Jr. | |||||||||||||||
M000633 | Return Meigs | M000633 | 407620 | 6408 | Return J. Meigs Jr. | Q744819 | kg:/m/0340r0 | Return | Meigs | 1764-11-17 | M | Jonathan | Jr. | ||||||||||||||||
M000608 | Walter McVey | M000608 | 407597 | 10536 | Walter Lewis McVey Jr. | Q2545377 | kg:/m/02rm9v2 | Walter | McVey | 1922-02-19 | M | 18087 | Lewis | Jr. | |||||||||||||||
M000589 | James McNulty | M000589 | 407579 | 15043 | James F. McNulty Jr. | Q1680357 | kg:/m/027n4h0 | James | McNulty | 1925-10-18 | M | 18060 | Francis | Jr. | 00784 | ||||||||||||||
M000522 | William McKinley | M000522 | 407515 | 6312 | William McKinley | Q35041 | kg:/m/083p7 | William | McKinley | 1843-01-29 | M | 17980 | Jr. | ||||||||||||||||
M000512 | John McKernan | M000512 | 407506 | 15042 | John R. McKernan Jr. | Q880786 | kg:/m/02hdvy | John | McKernan | 1948-05-20 | M | 17967 | Rettie | Jr. | 00779 | ||||||||||||||
M000466 | Paul McHale | M000466 | 407465 | 29399 | Paul McHale | Q7152365 | kg:/m/07qhlg | Paul | McHale | 1950-07-26 | M | 17908 | F. | Jr. | 00772 | ||||||||||||||
M000459 | Thomas McGrath | M000459 | 407458 | 10750 | Thomas C. McGrath Jr. | Q1661034 | kg:/m/02rt_z9 | Thomas | McGrath | 1927-04-22 | M | 17897 | Charles | Jr. | |||||||||||||||
M000431 | Thomas McEwan | M000431 | 407431 | 6237 | Thomas McEwan Jr. | Q2426053 | kg:/m/02x2k5k | Thomas | McEwan | 1854-02-26 | M | 17867 | Jr. | ||||||||||||||||
M000418 | Harris McDowell | M000418 | 407418 | 6224 | Harris McDowell | Q651271 | kg:/m/0b2bpy | Harris | McDowell | 1906-02-10 | M | 17851 | Brown | Jr. | |||||||||||||||
M000391 | Philip McCulloch | M000391 | 407392 | 6202 | Philip D. McCulloch Jr. | Q1451039 | kg:/m/02rjy11 | Philip | McCulloch | 1851-06-23 | M | 17813 | Doddridge | Jr. | |||||||||||||||
M000354 | Samuel McConnell | M000354 | 407362 | 6169 | Samuel K. McConnell Jr. | Q7411886 | kg:/m/0dzvln | Samuel | McConnell | 1901-04-06 | M | 17768 | Kerns | Jr. | |||||||||||||||
M000343 | Paul McCloskey | M000343 | 407352 | 11063 | Pete McCloskey | Q2073295 | kg:/m/04539r | Paul | McCloskey | 1927-09-29 | M | 17752 | Norton | Pete | Jr. | 00759 | |||||||||||||
M000274 | Edwin May | M000274 | 407292 | 6102 | Edwin H. May Jr. | Q1294630 | kg:/m/02rhfsq | Edwin | May | 1924-05-28 | M | 17662 | Hyland | Jr. | |||||||||||||||
M000241 | Charles Mathias | M000241 | 407259 | 10535 | Charles Mathias | Q457455 | kg:/m/0502g6 | Charles | Mathias | 1922-07-24 | M | 17621 | McCurdy | Jr. | 01391 | ||||||||||||||
M000233 | Frank Mathews | M000233 | 407251 | 6070 | Frank A. Mathews Jr. | Q1442844 | kg:/m/02vq0rq | Frank | Mathews | 1890-08-03 | M | 17611 | Asbury | Jr. | |||||||||||||||
M000223 | Moses Mason | M000223 | 407241 | 6060 | Moses Mason Jr. | Q1949197 | kg:/m/02rv9rt | Moses | Mason | 1789-06-02 | M | 17598 | Jr. | ||||||||||||||||
M000191 | Joseph Martin | M000191 | 407212 | 6033 | Joseph W. Martin Jr. | Q1387262 | kg:/m/01ncr6 | Joseph | Martin | 1884-11-03 | M | 17559 | William | Jr. | |||||||||||||||
M000148 | John Marsh | M000148 | 407171 | 10603 | John Otho Marsh Jr. | Q387744 | kg:/m/07qwp_ | John | Marsh | 1926-08-07 | M | 17508 | Otho | Jr. | |||||||||||||||
M000109 | John Manning | M000109 | 407133 | 5963 | John Manning Jr. | Q1563302 | kg:/m/03c2jc4 | John | Manning | 1830-07-30 | M | 17465 | Jr. | ||||||||||||||||
M000099 | Abijah Mann | M000099 | 407123 | 5955 | Abijah Mann Jr. | Q3388776 | kg:/m/02rklqf | Abijah | Mann | 1793-09-24 | M | 17453 | Jr. | ||||||||||||||||
M000064 | Gabriel Mahon | M000064 | 407092 | 5923 | Gabriel H. Mahon Jr. | Q1489280 | kg:/m/02vrp2d | Gabriel | Mahon | 1889-11-11 | M | 17407 | Heyward | Jr. | |||||||||||||||
M000023 | Kenneth MacKay | M000023 | 407051 | 15038 | Buddy MacKay | Q362669 | kg:/m/035_dy | Kenneth | MacKay | 1933-03-22 | M | 17357 | Hood | Buddy | Jr. | 00722 | |||||||||||||
M000020 | Peter Mack | M000020 | 407048 | 5884 | Peter F. Mack Jr. | Q7173908 | kg:/m/02rkc8x | Peter | Mack | 1916-11-01 | M | 17354 | Francis | Jr. | |||||||||||||||
L000586 | Al Lawson | L000586 | 412693 | 21732 | Al Lawson | Q4723052 | kg:/m/03cg0sv | Al | Lawson | 1948-09-23 | M | Alfred Lawson | Jr. | 90480 | 24263 | Al Lawson, Jr. | N00030642 | [ "H0FL02086" ] |
2205 | ||||||||||
L000525 | John Lyle | L000525 | 407009 | 5847 | John E. Lyle Jr. | Q1699892 | kg:/m/03c2zzz | John | Lyle | 1910-09-04 | M | 17249 | Emmett | Jr. | |||||||||||||||
L000506 | Manuel Luján | L000506 | 406992 | 12022 | Manuel Lujan Jr. | Q445980 | kg:/m/038nvz | Manuel | Luján | 1928-05-12 | M | 17223 | Jr. | 00712 | |||||||||||||||
L000481 | Lloyd Lowndes | L000481 | 406969 | 5813 | Lloyd Lowndes Jr. | Q881279 | kg:/m/047p6p | Lloyd | Lowndes | 1845-02-21 | M | 17193 | Jr. | ||||||||||||||||
L000394 | Henry Lodge | L000394 | 406886 | 5739 | Henry Cabot Lodge Jr. | Q450984 | kg:/m/013zk9 | Henry | Lodge | 1902-07-05 | M | Cabot | Jr. | ||||||||||||||||
L000371 | Robert Livingston | L000371 | 406863 | 14469 | Bob Livingston | Q888069 | kg:/m/025bm7 | Robert | Livingston | 1943-04-30 | M | 17057 | Linligthgow | Jr. | 00696 | ||||||||||||||
L000303 | Michael Liebel | L000303 | 406798 | 5658 | Michael Liebel Jr. | Q1332385 | kg:/m/0g3nzw | Michael | Liebel | 1870-12-12 | M | 16968 | Jr. | ||||||||||||||||
L000290 | Joseph Lewis | L000290 | 406787 | 5645 | Joseph Lewis Jr. (Virginia politician) | Q1297559 | kg:/m/0280mxn | Joseph | Lewis | M | 16952 | Jr. | |||||||||||||||||
L000252 | John Lesinski | L000252 | 406755 | 5617 | John Lesinski Jr. | Q1662994 | kg:/m/02pkyss | John | Lesinski | 1914-12-28 | M | 16905 | Jr. | ||||||||||||||||
L000167 | Anthony Leach | L000167 | 406671 | 14640 | Buddy Leach | Q1001235 | kg:/m/0ghd5x | Anthony | Leach | 1934-03-30 | M | 16806 | Claude | Jr. | 00671 | ||||||||||||||
L000095 | Henry Larcade | L000095 | 406603 | 5476 | Henry D. Larcade Jr. | Q1606649 | kg:/m/02rtmpw | Henry | Larcade | 1890-07-12 | M | 16712 | Dominique | Jr. | |||||||||||||||
L000018 | John Lafore | L000018 | 406528 | 5404 | John A. Lafore Jr. | Q6217775 | kg:/m/0dztk2 | John | Lafore | 1905-05-25 | M | 16598 | Armand | 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. | ||||||||||||||||
K000383 | Angus King | K000383 | 412545 | 41300 | Angus King | Q544464 | kg:/m/02hfx0 | Angus | King | 1944-03-31 | M | S. | Angus King | Jr. | 02185 | 37413 | 22381 | S363 | Angus S. King, Jr. | N00034580 | [ "S2ME00109" ] |
1769 | |||||||
K000374 | Paul Kirk | K000374 | 412381 | 40912 | Paul G. Kirk | Q1363487 | kg:/m/0896g7 | Paul | Kirk | 1938-01-18 | M | G. | Jr. | 01972 | 116298 | S334 | N00031303 | ||||||||||||
K000371 | Frank Kratovil | K000371 | 412289 | 20921 | Frank Kratovil | Q501814 | kg:/m/03whmnf | Frank | Kratovil | 1968-05-29 | M | 16566 | Jr. | 01926 | 1031346 | 101875 | N00029146 | [ "H8MD01086" ] |
|||||||||||
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" ] |
||||||||||
K000269 | John Klingensmith | K000269 | 406427 | 5323 | John Klingensmith Jr. | Q6243282 | kg:/m/0277flx | John | Klingensmith | 1786-03-26 | M | 16414 | Jr. | ||||||||||||||||
K000140 | John Kerr | K000140 | 406306 | 5206 | John Kerr Jr. (congressman) | Q1700699 | kg:/m/0bpl86 | John | Kerr | 1811-02-10 | M | 16254 | Jr. | ||||||||||||||||
K000122 | William Kennon | K000122 | 406288 | 5192 | William Kennon Jr. | Q8013940 | kg:/m/02rm3ps | William | Kennon | 1802-06-12 | M | 16229 | Jr. | ||||||||||||||||
K000025 | Abraham Kazen | K000025 | 406196 | 11023 | Abraham Kazen | Q330149 | kg:/m/027jcfb | Abraham | Kazen | 1919-01-17 | M | 16107 | Jr. | 00621 | |||||||||||||||
K000019 | Robert Kasten | K000019 | 406190 | 14242 | Bob Kasten | Q368462 | kg:/m/03vwyr | Robert | Kasten | 1942-06-19 | M | 16100 | Walter | Jr. | 00619 | S155 | |||||||||||||
J000288 | Henry Johnson | J000288 | 412199 | 20712 | Hank Johnson | Q983537 | kg:/m/0flgyy | Henry | Johnson | 1954-10-02 | M | 16065 | C. | Hank | Henry C. Johnson, Jr. | Jr. | 01843 | 1020576 | 68070 | Henry C. "Hank" Johnson, Jr. | N00027848 | [ "H6GA04129" ] |
686 | ||||||
J000283 | Jesse Jackson | J000283 | 400198 | 29585 | Jesse Jackson Jr. | Q609189 | kg:/m/0255y7 | Jesse | Jackson | 1965-03-11 | M | 16055 | Louis | Jr. | 00587 | 39073 | 72 | Jesse L. Jackson Jr. | N00012457 | [ "H6IL02124" ] |
|||||||||
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" } ] |
||||||
J000248 | Robert Jones | J000248 | 406141 | 5058 | Robert E. Jones Jr. | Q174690 | kg:/m/02qgx09 | Robert | Jones | 1912-06-12 | M | 16006 | Emmett | Jr. | 00610 | ||||||||||||||
J000189 | John Johnston | J000189 | 406084 | 14107 | J. Bennett Johnston | Q4889708 | kg:/m/03bfd1 | John | Johnston | 1932-06-10 | M | Bennett | Jr. | 01373 | S054 | ||||||||||||||
J000151 | Jed Johnson | J000151 | 406049 | 10743 | Jed Johnson Jr. | Q1686121 | kg:/m/02rr77h | Jed | Johnson | 1939-12-27 | M | 15882 | Joseph | Jr. | |||||||||||||||
J000120 | Clete Johnson | J000120 | 406024 | 29343 | Don Johnson Jr. | Q1100647 | kg:/m/0gshtq | Clete | Johnson | 1948-01-30 | M | 15844 | Donald | Don | Jr. | 00598 | |||||||||||||
J000112 | Kensey Johns | J000112 | 406013 | 4937 | Kensey Johns Jr. | Q1739010 | kg:/m/0d8qp7 | Kensey | Johns | 1791-12-10 | M | 15833 | Jr. | ||||||||||||||||
J000099 | John Jenrette | J000099 | 406001 | 14241 | John Jenrette | Q676392 | kg:/m/0570ng | John | Jenrette | 1936-05-19 | M | 15818 | Wilson | Jr. | 00596 | ||||||||||||||
J000096 | John Jennings | J000096 | 405998 | 4925 | John Jennings (American politician) | Q253281 | kg:/m/09bk8c | John | Jennings | 1880-06-06 | M | 15815 | Jr. | ||||||||||||||||
J000035 | Ferris Jacobs | J000035 | 405940 | 4870 | Ferris Jacobs Jr. | Q5445377 | kg:/m/02qlpsg | Ferris | Jacobs | 1836-03-20 | M | 15734 | Jr. | ||||||||||||||||
J000033 | Andrew Jacobs | J000033 | 405939 | 10742 | Andrew Jacobs Jr. | Q505473 | kg:/m/0cddnz | Andrew | Jacobs | 1932-02-24 | M | 15732 | Jr. | 00589 | |||||||||||||||
J000025 | Richard Jackson | J000025 | 405931 | 4862 | Richard Jackson Jr. | Q2149883 | kg:/m/02rjyc0 | Richard | Jackson | 1764-07-03 | M | 15721 | Jr. | ||||||||||||||||
J000009 | Ebenezer Jackson | J000009 | 405916 | 4847 | Ebenezer Jackson Jr. | Q1278652 | kg:/m/02rhffq | Ebenezer | Jackson | 1796-01-31 | M | 15704 | Jr. | ||||||||||||||||
I000047 | Ernest Istook | I000047 | 400197 | 29392 | Ernest Istook | Q1356373 | kg:/m/033tfn | Ernest | Istook | 1950-02-11 | M | 15675 | J. | Jr. | 00586 | N00005551 | |||||||||||||
I000006 | Peter Ihrie | I000006 | 405868 | 4795 | Peter Ihrie Jr. | Q7174825 | kg:/m/026t9gc | Peter | Ihrie | 1796-02-03 | M | 15625 | Jr. | ||||||||||||||||
H000953 | Hubert Humphrey | H000953 | 405797 | 4728 | Hubert Humphrey | Q209989 | kg:/m/0bq6m | Hubert | Humphrey | 1911-05-27 | M | Horatio | Jr. | 01366 | |||||||||||||||
H000947 | William Hull | H000947 | 405792 | 4724 | William Raleigh Hull Jr. | Q2580348 | kg:/m/02rwzll | William | Hull | 1906-04-17 | M | 15453 | Raleigh | Jr. | |||||||||||||||
H000932 | Daniel Hugunin | H000932 | 405777 | 4709 | Daniel Hugunin Jr. | Q5217548 | kg:/m/02rknkx | Daniel | Hugunin | 1790-02-06 | M | 15434 | Jr. |
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);