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_wikidata descending
This data as json, copyable, CSV (advanced)
Suggested facets: name_nickname, bio_birthday (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
C000321 | William Chappell | C000321 | 402463 | 12007 | Bill Chappell | Q999912 | kg:/m/02rk020 | William | Chappell | 1922-02-03 | M | 10856 | Venroe | Jr. | 00191 | ||||||||||||||
B001008 | John Buchanan | B001008 | 401958 | 10706 | John Hall Buchanan Jr. | Q999881 | kg:/m/02qj8c1 | John | Buchanan | 1928-03-19 | M | 10078 | Hall | Jr. | 00143 | ||||||||||||||
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 | ||||||
B001251 | George Butterfield | B001251 | 400616 | 20340 | G. K. Butterfield | Q983532 | kg:/m/03g_pq | George | Butterfield | 1947-04-27 | M | 10401 | Kenneth | G.K. | G.K. Butterfield | Jr. | 01761 | 1013540 | 41077 | G. K. Butterfield | N00027035 | [ "H4NC01046" ] |
624 | ||||||
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 | |||||||
W000362 | Compton White | W000362 | 411524 | 10637 | Compton I. White Jr. | Q979283 | kg:/m/06bjv9 | Compton | White | 1920-12-19 | M | 23645 | Ignatius | Jr. | |||||||||||||||
B001255 | Charles Boustany | B001255 | 400636 | 20514 | Charles Boustany | Q972735 | kg:/m/04wdx3 | Charles | Boustany | 1956-02-21 | M | 10409 | W. | Charles Boustany Jr. | Jr. | 01787 | 1013047 | 35514 | Charles W. Boustany Jr. | N00026595 | [ "H4LA07029" ] |
642 | |||||||
G000277 | John Goode | G000277 | 404639 | 3666 | John Goode (Virginia politician) | Q968146 | kg:/m/07d7n9 | John | Goode | 1829-05-27 | M | 13913 | Jr. | ||||||||||||||||
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 | |||||||
B000280 | Robin Beard | B000280 | 401274 | 14004 | Robin Beard | Q963419 | kg:/m/03z10z | Robin | Beard | 1939-08-21 | M | 9139 | Leo | Jr. | 00069 | ||||||||||||||
B001235 | Henry Brown | B001235 | 400049 | 20137 | Henry E. Brown Jr. | Q962919 | kg:/m/03tpvc | Henry | Brown | 1935-12-20 | M | 10370 | E. | Jr. | 01669 | 1000221 | 3993 | N00002428 | [ "H0SC01071" ] |
||||||||||
Y000028 | Andrew Young | Y000028 | 411962 | 14063 | Andrew Young | Q959635 | kg:/m/018t4c | Andrew | Young | 1932-03-12 | M | 21064 | Jackson | Jr. | 01254 | ||||||||||||||
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" } ] |
||||||
F000260 | Gerald Ford | F000260 | 404212 | 3268 | Gerald Ford | Q9582 | kg:/m/0c_md_ | Gerald | Ford | 1913-07-14 | M | 13301 | Rudolph | Jr. | 00399 | ||||||||||||||
S000244 | F. Sensenbrenner | S000244 | 400365 | 14657 | Jim Sensenbrenner | Q952268 | kg:/m/024tp2 | F. | Sensenbrenner | 1943-06-14 | M | 21438 | James | Jim Sensenbrenner | Jr. | 01041 | 1507 | 27142 | F. James Sensenbrenner, Jr. | N00004291 | [ "H8WI09050" ] |
456 | |||||||
W000763 | James Wright | W000763 | 411912 | 10391 | Jim Wright | Q949514 | kg:/m/029yzb | James | Wright | 1922-12-22 | M | 24127 | Claude | Jr. | 01244 | ||||||||||||||
M001090 | Edward Murphy | M001090 | 408054 | 6806 | Edward Murphy Jr. | Q945610 | kg:/m/09wnxg | Edward | Murphy | 1836-12-15 | M | Jr. | |||||||||||||||||
N000140 | Moses Norris | N000140 | 408224 | 6961 | Moses Norris Jr. | Q939960 | kg:/m/0d7mvf | Moses | Norris | 1799-11-08 | M | 19006 | Jr. | ||||||||||||||||
W000281 | Daniel Wells | W000281 | 411446 | 9941 | Daniel Wells Jr. | Q938432 | kg:/m/02vrqv4 | Daniel | Wells | 1808-07-16 | M | 23556 | Jr. | ||||||||||||||||
C000480 | Clement Clay | C000480 | 402618 | 1808 | Clement Claiborne Clay | Q928988 | kg:/m/03gcq7 | Clement | Clay | 1816-12-13 | M | Claiborne | Jr. | ||||||||||||||||
T000200 | Frank Thompson | T000200 | 410779 | 9322 | Frank Thompson | Q913444 | kg:/m/08gl3w | Frank | Thompson | 1918-07-26 | M | 22878 | Jr. | 01152 | |||||||||||||||
B000641 | Charles Borland | B000641 | 401606 | 864 | Charles Borland Jr. | Q892029 | kg:/m/02rkmtv | Charles | Borland | 1786-06-29 | M | 9612 | Jr. | ||||||||||||||||
H000082 | John Hallock | H000082 | 404965 | 3964 | John Hallock Jr. | Q892023 | kg:/m/02rksdd | John | Hallock | M | 14389 | Jr. | |||||||||||||||||
L000371 | Robert Livingston | L000371 | 406863 | 14469 | Bob Livingston | Q888069 | kg:/m/025bm7 | Robert | Livingston | 1943-04-30 | M | 17057 | Linligthgow | Jr. | 00696 | ||||||||||||||
E000093 | Robert Ehrlich | E000093 | 400523 | 29529 | Bob Ehrlich | Q888007 | kg:/m/027_zq | Robert | Ehrlich | 1957-11-25 | M | 12713 | L. | Jr. | 00340 | N00001925 | |||||||||||||
C001070 | Robert Casey | C001070 | 412246 | 40703 | Bob Casey Jr. | Q887841 | kg:/m/047ymw | Robert | Casey | 1960-04-13 | M | P. | Bob | Bob Casey, Jr. | Jr. | 01828 | 47036 | 2541 | S309 | Robert P. Casey, Jr. | N00027503 | [ "S6PA00217" ] |
727 | ||||||
G000159 | Ernest Gibson | G000159 | 404526 | 3559 | Ernest W. Gibson Jr. | Q885614 | kg:/m/0cw1s9 | Ernest | Gibson | 1901-03-06 | M | William | Jr. | ||||||||||||||||
D000346 | Paul Dillingham | D000346 | 403464 | 2596 | Paul Dillingham | Q885200 | kg:/m/02r7h13 | Paul | Dillingham | 1799-08-10 | M | 12257 | Jr. | ||||||||||||||||
S000694 | Richard Spaight | S000694 | 410165 | 8757 | Richard Dobbs Spaight Jr. | Q884075 | kg:/m/02j1nz | Richard | Spaight | M | 21995 | Dobbs | Jr. | ||||||||||||||||
W000253 | Lowell Weicker | W000253 | 411421 | 12032 | Lowell Weicker | Q881318 | kg:/m/02jmd9 | Lowell | Weicker | 1931-05-16 | M | 23520 | Palmer | Jr. | 01453 | ||||||||||||||
L000481 | Lloyd Lowndes | L000481 | 406969 | 5813 | Lloyd Lowndes Jr. | Q881279 | kg:/m/047p6p | Lloyd | Lowndes | 1845-02-21 | M | 17193 | Jr. | ||||||||||||||||
T000400 | James Tucker | T000400 | 410969 | 14457 | Jim Guy Tucker | Q881069 | kg:/m/01rqq1 | James | Tucker | 1943-06-13 | M | 23123 | (Jim) Guy | Jr. | 01171 | ||||||||||||||
T000389 | Jonathan Trumbull | T000389 | 410958 | 9489 | Jonathan Trumbull Jr. | Q881004 | kg:/m/01rbqk | Jonathan | Trumbull | 1740-03-26 | M | 23110 | 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 | ||||||||||||||
D000050 | Colgate Darden | D000050 | 403189 | 2335 | Colgate Darden | Q880393 | kg:/m/05nnw0 | Colgate | Darden | 1897-02-11 | M | 11891 | Whitehead | Jr. | |||||||||||||||
B000505 | Loring Black | B000505 | 401484 | 749 | Loring M. Black Jr. | Q866845 | kg:/m/02r7x0q | Loring | Black | 1886-05-17 | M | 9427 | Milton | Jr. | |||||||||||||||
Z000004 | William Zeliff | Z000004 | 411997 | 29130 | Bill Zeliff | Q862681 | kg:/m/026yxgp | William | Zeliff | 1936-06-12 | M | 21115 | H. | Jr. | 01263 | ||||||||||||||
G000528 | William Gunter | G000528 | 404873 | 14017 | Bill Gunter | Q862158 | kg:/m/0cl03k | William | Gunter | 1934-07-16 | M | 14226 | Dawson | Bill | Jr. | 00477 | |||||||||||||
G000349 | Willis Gradison | G000349 | 404705 | 14225 | Bill Gradison | Q862136 | kg:/m/0343_v | Willis | Gradison | 1928-12-28 | M | 14000 | David | Jr. | 00451 | ||||||||||||||
C000555 | William Cobey | C000555 | 402688 | 15091 | Bill Cobey | Q862019 | kg:/m/02fppy | William | Cobey | 1939-05-13 | M | 11143 | Wilfred | Jr. | 00210 | ||||||||||||||
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 | |||||||||||||
A000213 | Beryl Anthony | A000213 | 400898 | 14601 | Beryl Anthony Jr. | Q829269 | kg:/m/02pv4nd | Beryl | Anthony | 1938-02-21 | M | 8556 | Franklin | Jr. | 00024 | ||||||||||||||
P000146 | William Paulding | P000146 | 408551 | 7269 | William Paulding Jr. | Q82449 | kg:/m/026t9n6 | William | Paulding | 1770-03-07 | M | 19454 | Jr. | ||||||||||||||||
P000330 | Benjamin Pickman | P000330 | 408727 | 7432 | Benjamin Pickman Jr. | Q817647 | kg:/m/02rhcnn | Benjamin | Pickman | 1763-09-30 | M | 19688 | Jr. | ||||||||||||||||
G000268 | Barry Goldwater | G000268 | 404630 | 12037 | Barry Goldwater Jr. | Q809039 | kg:/m/09ly_0 | Barry | Goldwater | 1938-07-15 | M | 13899 | Morris | Jr. | 00444 | ||||||||||||||
C000616 | William Cole | C000616 | 402745 | 1930 | William Purington Cole Jr. | Q808708 | kg:/m/0916k3 | William | Cole | 1889-05-11 | M | 11220 | Purington | Jr. | |||||||||||||||
K000122 | William Kennon | K000122 | 406288 | 5192 | William Kennon Jr. | Q8013940 | kg:/m/02rm3ps | William | Kennon | 1802-06-12 | M | 16229 | Jr. | ||||||||||||||||
M000770 | William Milliken | M000770 | 407748 | 6524 | William H. Milliken Jr. | Q8010514 | kg:/m/0dzrrc | William | Milliken | 1897-08-19 | M | 18293 | H. | 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 | ||||||||||||||
F000252 | Wallace Foote | F000252 | 404206 | 3261 | Wallace T. Foote Jr. | Q7962904 | kg:/m/02rkxjb | Wallace | Foote | 1864-04-07 | M | 13292 | Turner | Jr. | |||||||||||||||
W000654 | Robert Wise | W000654 | 400614 | 15077 | Bob Wise | Q780398 | kg:/m/026b40 | Robert | Wise | 1948-01-06 | M | 23996 | E. | Jr. | 01237 | ||||||||||||||
H000855 | Thomas Howe | H000855 | 405702 | 4641 | Thomas Y. Howe Jr. | Q7795367 | kg:/m/02rkxdk | Thomas | Howe | M | 15343 | Y. | Jr. | ||||||||||||||||
P000314 | Thomas Phillips | P000314 | 408713 | 7419 | Thomas Wharton Phillips Jr. | Q7795027 | kg:/m/0ft52l | Thomas | Phillips | 1874-11-21 | M | 19663 | Wharton | Jr. | |||||||||||||||
M001115 | Thomas Murray | M001115 | 408078 | 6825 | Thomas Murray Jr. | Q7792626 | kg:/m/027hk6w | Thomas | Murray | M | 18719 | Jr. | |||||||||||||||||
A000163 | James Almond | A000163 | 400818 | 144 | J. Lindsay Almond | Q777975 | kg:/m/04hsqf | James | Almond | 1898-06-15 | M | 8482 | Lindsay | Jr. | |||||||||||||||
W000770 | Silas Wright | W000770 | 411919 | 10398 | Silas Wright | Q777453 | kg:/m/02z5dk | Silas | Wright | 1795-05-24 | M | 24137 | Jr. | ||||||||||||||||
G000539 | James Guyon | G000539 | 404882 | 3886 | James Guyon Jr. | Q74972 | kg:/m/02rkr5b | James | Guyon | 1778-12-24 | M | 14240 | Jr. | ||||||||||||||||
D000267 | Butler Derrick | D000267 | 403403 | 14212 | Butler Derrick | Q745814 | kg:/m/0265rj1 | Butler | Derrick | 1936-09-30 | M | 12159 | Carson | Jr. | 00289 | ||||||||||||||
M000633 | Return Meigs | M000633 | 407620 | 6408 | Return J. Meigs Jr. | Q744819 | kg:/m/0340r0 | Return | Meigs | 1764-11-17 | M | Jonathan | Jr. | ||||||||||||||||
C000356 | Lawton Chiles | C000356 | 402495 | 13101 | Lawton Chiles | Q744098 | kg:/m/027165 | Lawton | Chiles | 1930-04-03 | M | Mainor | Jr. | 01304 | |||||||||||||||
F000111 | Jack Fields | F000111 | 404068 | 14822 | Jack Fields | Q743157 | kg:/m/0dygxz | Jack | Fields | 1952-02-03 | M | 13114 | Milton | Jr. | 00380 | ||||||||||||||
M000354 | Samuel McConnell | M000354 | 407362 | 6169 | Samuel K. McConnell Jr. | Q7411886 | kg:/m/0dzvln | Samuel | McConnell | 1901-04-06 | M | 17768 | Kerns | Jr. | |||||||||||||||
S000479 | Daniel Slaughter | S000479 | 409968 | 15115 | D. French Slaughter Jr. | Q738053 | kg:/m/02qct_5 | Daniel | Slaughter | 1925-05-20 | M | 21736 | French | Jr. | 01068 | ||||||||||||||
O000105 | Robert Orr | O000105 | 408362 | 7088 | Robert Orr Jr. | Q7348159 | kg:/m/0276x4l | Robert | Orr | 1786-03-05 | M | 19195 | Jr. | ||||||||||||||||
C000586 | Robert Coffey | C000586 | 402715 | 1901 | Robert L. Coffey | Q7346534 | kg:/m/0dp81_ | Robert | Coffey | 1918-10-21 | M | 11185 | Lewis | Jr. | |||||||||||||||
A000044 | Robert Adams | A000044 | 400705 | 36 | Robert Adams Jr. | Q7341350 | kg:/m/0dhs2_ | Robert | Adams | 1849-02-26 | M | 8315 | Jr. | ||||||||||||||||
D000259 | Jeremiah Denton | D000259 | 403397 | 14901 | Jeremiah Denton | Q731680 | kg:/m/036x4p | Jeremiah | Denton | 1924-07-15 | M | Andrew | Jr. | 01316 | |||||||||||||||
T000174 | John Thomas | T000174 | 410755 | 9300 | John Lewis Thomas Jr. | Q724953 | kg:/m/0ghh6g | John | Thomas | 1835-05-20 | M | 22841 | Lewis | Jr. | |||||||||||||||
R000536 | Richard Russell | R000536 | 409493 | 8138 | Richard Russell Jr. | Q718415 | kg:/m/0268my | Richard | Russell | 1897-11-02 | M | Brevard | Jr. | ||||||||||||||||
I000006 | Peter Ihrie | I000006 | 405868 | 4795 | Peter Ihrie Jr. | Q7174825 | kg:/m/026t9gc | Peter | Ihrie | 1796-02-03 | M | 15625 | Jr. | ||||||||||||||||
M000020 | Peter Mack | M000020 | 407048 | 5884 | Peter F. Mack Jr. | Q7173908 | kg:/m/02rkc8x | Peter | Mack | 1916-11-01 | M | 17354 | Francis | Jr. | |||||||||||||||
M000466 | Paul McHale | M000466 | 407465 | 29399 | Paul McHale | Q7152365 | kg:/m/07qhlg | Paul | McHale | 1950-07-26 | M | 17908 | F. | Jr. | 00772 | ||||||||||||||
W000128 | Artemas Ward | W000128 | 411303 | 9809 | Artemas Ward Jr. | Q706555 | kg:/m/0cg1m4 | Artemas | Ward | 1762-01-09 | M | 23365 | Jr. | ||||||||||||||||
C000866 | Nathaniel Craley | C000866 | 402981 | 10714 | Nathaniel N. Craley Jr. | Q6969784 | kg:/m/0dn3v6 | Nathaniel | Craley | 1927-11-17 | M | 11539 | Neiman | Jr. | |||||||||||||||
S000232 | Armistead Selden | S000232 | 409737 | 8353 | Armistead I. Selden Jr. | Q688628 | kg:/m/02rk1cm | Armistead | Selden | 1921-02-20 | M | 21423 | Inge | Jr. | |||||||||||||||
J000099 | John Jenrette | J000099 | 406001 | 14241 | John Jenrette | Q676392 | kg:/m/0570ng | John | Jenrette | 1936-05-19 | M | 15818 | Wilson | Jr. | 00596 | ||||||||||||||
C000110 | Ezekiel Candler | C000110 | 402262 | 1473 | Ezekiel S. Candler Jr. | Q675971 | kg:/m/02x2r2_ | Ezekiel | Candler | 1862-01-18 | M | 10584 | Samuel | Jr. | |||||||||||||||
W000267 | David Weldon | W000267 | 400427 | 29509 | Dave Weldon | Q672269 | kg:/m/0252yz | David | Weldon | 1953-08-31 | M | 23538 | J. | Dave | Jr. | 01215 | 22159 | N00002807 | [ "H4FL15114" ] |
||||||||||
O000036 | Benjamin Odell | O000036 | 408321 | 7024 | Benjamin Odell (politician) | Q663205 | kg:/m/038qlc | Benjamin | Odell | 1854-01-14 | M | 19114 | Baker | Jr. | |||||||||||||||
C000442 | John Clark | C000442 | 402580 | 1774 | John Bullock Clark Jr. | Q655809 | kg:/m/0g1h8w | John | Clark | 1831-01-14 | M | 11005 | Bullock | Jr. | |||||||||||||||
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" } ] |
||||||
M000418 | Harris McDowell | M000418 | 407418 | 6224 | Harris McDowell | Q651271 | kg:/m/0b2bpy | Harris | McDowell | 1906-02-10 | M | 17851 | Brown | 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. | |||||||||||||||
S000739 | William Spong | S000739 | 410208 | 11206 | William Spong Jr. | Q6329296 | kg:/m/053s_8 | William | Spong | 1920-09-29 | M | Belser | Jr. | ||||||||||||||||
S000514 | Albert Smith | S000514 | 409999 | 14862 | Albert L. Smith Jr. | Q632825 | kg:/m/02qhvzf | Albert | Smith | 1931-08-31 | M | 21778 | Lee | Jr. | 01070 | ||||||||||||||
E000248 | Joshua Evans | E000248 | 403931 | 3014 | Joshua Evans Jr. | Q6289786 | kg:/m/026xqdm | Joshua | Evans | 1777-01-20 | M | 12906 | Jr. | ||||||||||||||||
F000397 | Joseph Fry | F000397 | 404339 | 3384 | Joseph Fry Jr. | Q6283263 | kg:/m/026t8sc | Joseph | Fry | 1781-08-04 | M | 13470 | Jr. | ||||||||||||||||
B000444 | Joseph Biden | B000444 | 300008 | 14101 | Joe Biden | Q6279 | kg:/m/012gx2 | Joseph | Biden | 1942-11-20 | M | R. | Joe Biden | Jr. | 01284 | 34 | 53279 | S010 | N00001669 | [ "S8DE00012" ] |
|||||||||
E000011 | Jonas Earll | E000011 | 403707 | 2817 | Jonas Earll Jr. | Q6272064 | kg:/m/02rkt0p | Jonas | Earll | M | 12615 | Jr. | |||||||||||||||||
C000836 | John Cox | C000836 | 402953 | 29116 | John W. Cox Jr. | Q6262204 | kg:/m/0dnv7x | John | Cox | 1947-07-10 | M | 11502 | W. | Jr. | 00243 | ||||||||||||||
K000269 | John Klingensmith | K000269 | 406427 | 5323 | John Klingensmith Jr. | Q6243282 | kg:/m/0277flx | John | Klingensmith | 1786-03-26 | M | 16414 | Jr. | ||||||||||||||||
A000301 | John Arnot | A000301 | 400943 | 253 | John Arnot Jr. | Q6219444 | kg:/m/02rkr_p | John | Arnot | 1831-03-11 | M | 8679 | Jr. | ||||||||||||||||
L000018 | John Lafore | L000018 | 406528 | 5404 | John A. Lafore Jr. | Q6217775 | kg:/m/0dztk2 | John | Lafore | 1905-05-25 | M | 16598 | Armand | Jr. | |||||||||||||||
T000367 | Paul Trible | T000367 | 410936 | 14456 | Paul Trible | Q6215217 | kg:/m/05_rmm | Paul | Trible | 1946-12-29 | M | 23084 | Seward | Jr. | 01169 | ||||||||||||||
W000012 | James Wadsworth | W000012 | 411191 | 9705 | James Wolcott Wadsworth Jr. | Q6145741 | kg:/m/04fv36 | James | Wadsworth | 1877-08-12 | M | 23235 | Wolcott | Jr. | |||||||||||||||
S000561 | James Smith | S000561 | 410043 | 8641 | James Smith Jr. | Q6143301 | kg:/m/0b35xd | James | Smith | 1851-06-12 | M | Jr. | |||||||||||||||||
S000431 | James Simpson | S000431 | 409925 | 8528 | James Simpson Jr. | Q6143202 | kg:/m/02rkb7x | James | Simpson | 1905-01-07 | M | 21675 | Jr. | ||||||||||||||||
A000157 | James Allison | A000157 | 400812 | 138 | James Allison Jr. | Q6128654 | kg:/m/027gbjp | James | Allison | 1772-10-04 | M | 8473 | Jr. | ||||||||||||||||
A000095 | James Alexander | A000095 | 400753 | 83 | James Alexander Jr. | Q6128502 | kg:/m/0269r6l | James | Alexander | 1789-10-17 | M | 8390 | 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 |
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);