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_ballotpedia
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
T000174 | John Thomas | T000174 | 410755 | 9300 | John Lewis Thomas Jr. | Q724953 | kg:/m/0ghh6g | John | Thomas | 1835-05-20 | M | 22841 | Lewis | Jr. | |||||||||||||||
T000185 | Robert Thomas | T000185 | 410766 | 9309 | Robert Y. Thomas Jr. | Q2159247 | kg:/m/02rjyx6 | Robert | Thomas | 1855-07-13 | M | 22858 | Young | Jr. | |||||||||||||||
T000200 | Frank Thompson | T000200 | 410779 | 9322 | Frank Thompson | Q913444 | kg:/m/08gl3w | Frank | Thompson | 1918-07-26 | M | 22878 | Jr. | 01152 | |||||||||||||||
T000212 | Philip Thompson | T000212 | 410791 | 9334 | Philip B. Thompson Jr. | Q2086047 | kg:/m/02rjy0q | Philip | Thompson | 1845-10-15 | M | 22893 | Burton | Jr. | |||||||||||||||
T000221 | Waddy Thompson | T000221 | 410800 | 9342 | Waddy Thompson Jr. | Q2538676 | kg:/m/02ry1yx | Waddy | Thompson | 1798-01-08 | M | 22904 | Jr. | ||||||||||||||||
T000243 | Raymond Thornton | T000243 | 410821 | 14058 | Ray Thornton | Q2133994 | kg:/m/026j600 | Raymond | Thornton | 1928-07-16 | M | 22928 | Hoyt | Ray | Jr. | 01156 | |||||||||||||
T000294 | Paul Todd | T000294 | 410867 | 10776 | Paul H. Todd Jr. | Q2059929 | kg:/m/028489n | Paul | Todd | 1921-09-22 | M | 22990 | Harold | Jr. | |||||||||||||||
T000323 | Frank Towey | T000323 | 410895 | 9428 | Frank William Towey Jr. | Q1444392 | kg:/m/0270zpp | Frank | Towey | 1895-11-05 | M | 23029 | William | Jr. | |||||||||||||||
T000335 | John Townsend | T000335 | 410906 | 9439 | John G. Townsend Jr. | Q434691 | kg:/m/06vw4r | John | Townsend | 1871-05-31 | M | Gillis | Jr. | ||||||||||||||||
T000350 | James Traficant | T000350 | 400611 | 15121 | James Traficant | Q465728 | kg:/m/01spk0 | James | Traficant | 1941-05-08 | M | 23065 | A. | Jr. | 01166 | ||||||||||||||
T000367 | Paul Trible | T000367 | 410936 | 14456 | Paul Trible | Q6215217 | kg:/m/05_rmm | Paul | Trible | 1946-12-29 | M | 23084 | Seward | Jr. | 01169 | ||||||||||||||
T000389 | Jonathan Trumbull | T000389 | 410958 | 9489 | Jonathan Trumbull Jr. | Q881004 | kg:/m/01rbqk | Jonathan | Trumbull | 1740-03-26 | M | 23110 | 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 | ||||||||||||||
T000416 | Charles Turner | T000416 | 410985 | 9510 | Charles Turner Jr. | Q1066267 | kg:/m/02rhdk5 | Charles | Turner | 1760-06-20 | M | 23143 | Jr. | ||||||||||||||||
T000439 | William Tuttle | T000439 | 411007 | 9532 | William E. Tuttle Jr. | Q1645378 | kg:/m/02x12y2 | William | Tuttle | 1870-12-10 | M | 23173 | Edgar | 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. | ||||||||||||||||
W000003 | Edmund Waddill | W000003 | 411182 | 9696 | Edmund Waddill Jr. | Q1286933 | kg:/m/05p07th | Edmund | Waddill | 1855-05-22 | M | 23223 | Jr. | ||||||||||||||||
W000012 | James Wadsworth | W000012 | 411191 | 9705 | James Wolcott Wadsworth Jr. | Q6145741 | kg:/m/04fv36 | James | Wadsworth | 1877-08-12 | M | 23235 | Wolcott | Jr. | |||||||||||||||
W000018 | Joseph Waggonner | W000018 | 411197 | 10567 | Joe Waggonner | Q1691636 | kg:/m/0c16hw | Joseph | Waggonner | 1918-09-07 | M | 23241 | David | Jr. | 01191 | ||||||||||||||
W000038 | Alton Waldon | W000038 | 411218 | 15244 | Alton Waldon | Q1027684 | kg:/m/0fq1cv | Alton | Waldon | 1936-12-21 | M | 23263 | R. | Jr. | 01194 | ||||||||||||||
W000128 | Artemas Ward | W000128 | 411303 | 9809 | Artemas Ward Jr. | Q706555 | kg:/m/0cg1m4 | Artemas | Ward | 1762-01-09 | M | 23365 | Jr. | ||||||||||||||||
W000173 | Israel Washburn | W000173 | 411346 | 9851 | Israel Washburn Jr. | Q433008 | kg:/m/07rlbc | Israel | Washburn | 1813-06-06 | M | 23415 | Jr. | ||||||||||||||||
W000253 | Lowell Weicker | W000253 | 411421 | 12032 | Lowell Weicker | Q881318 | kg:/m/02jmd9 | Lowell | Weicker | 1931-05-16 | M | 23520 | Palmer | Jr. | 01453 | ||||||||||||||
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" ] |
||||||||||
W000281 | Daniel Wells | W000281 | 411446 | 9941 | Daniel Wells Jr. | Q938432 | kg:/m/02vrqv4 | Daniel | Wells | 1808-07-16 | M | 23556 | Jr. | ||||||||||||||||
W000308 | James Westcott | W000308 | 411472 | 9966 | James Westcott | Q1681287 | kg:/m/08_y9c | James | Westcott | 1802-05-10 | M | Diament | Jr. | ||||||||||||||||
W000317 | Charles Whalen | W000317 | 411479 | 11054 | Charles W. Whalen Jr. | Q129399 | kg:/m/0c4pxl | Charles | Whalen | 1920-07-31 | M | 23595 | William | Jr. | 01217 | ||||||||||||||
W000345 | Thomas Whipple | W000345 | 411507 | 9999 | Thomas Whipple Jr. | Q475751 | kg:/m/02rk09y | Thomas | Whipple | M | 23627 | Jr. | |||||||||||||||||
W000362 | Compton White | W000362 | 411524 | 10637 | Compton I. White Jr. | Q979283 | kg:/m/06bjv9 | Compton | White | 1920-12-19 | M | 23645 | Ignatius | Jr. | |||||||||||||||
W000396 | Wallace White | W000396 | 411556 | 10047 | Wallace H. White Jr. | Q442200 | kg:/m/049dlm | Wallace | White | 1877-08-06 | M | 23685 | Humphrey | Jr. | |||||||||||||||
W000481 | William Willett | W000481 | 411638 | 10126 | William Willett Jr. | Q2808000 | kg:/m/02rkydx | William | Willett | 1869-11-27 | M | 23789 | Forte | Jr. | |||||||||||||||
W000502 | Harrison Williams | W000502 | 411659 | 10147 | Harrison A. Williams | Q1586255 | kg:/m/051d1d | Harrison | Williams | 1919-12-10 | M | 23812 | Arlington | Jr. | 01455 | ||||||||||||||
W000505 | Isaac Williams | W000505 | 411662 | 10150 | Isaac Williams Jr. | Q2507394 | kg:/m/026_tvl | Isaac | Williams | 1777-04-05 | M | 23815 | Jr. | ||||||||||||||||
W000565 | Westel Willoughby | W000565 | 411721 | 10207 | Westel Willoughby Jr. | Q3661182 | kg:/m/02rkxp4 | Westel | Willoughby | 1769-11-20 | M | 23884 | Jr. | ||||||||||||||||
W000636 | Edward Winn | W000636 | 411790 | 11057 | Larry Winn | Q1689332 | kg:/m/027n4yt | Edward | Winn | 1919-08-22 | M | 23973 | Lawrence | Larry | Jr. | 01235 | |||||||||||||
W000654 | Robert Wise | W000654 | 400614 | 15077 | Bob Wise | Q780398 | kg:/m/026b40 | Robert | Wise | 1948-01-06 | M | 23996 | E. | Jr. | 01237 | ||||||||||||||
W000688 | Alan Wood | W000688 | 411840 | 10318 | Alan Wood Jr. | Q4708090 | kg:/m/0ksyx0 | Alan | Wood | 1834-07-06 | M | 24036 | Jr. | ||||||||||||||||
W000763 | James Wright | W000763 | 411912 | 10391 | Jim Wright | Q949514 | kg:/m/029yzb | James | Wright | 1922-12-22 | M | 24127 | Claude | Jr. | 01244 | ||||||||||||||
W000770 | Silas Wright | W000770 | 411919 | 10398 | Silas Wright | Q777453 | kg:/m/02z5dk | Silas | Wright | 1795-05-24 | M | 24137 | Jr. | ||||||||||||||||
W000777 | Joseph Wyatt | W000777 | 411926 | 14674 | Joseph P. Wyatt Jr. | Q201651 | kg:/m/02rvb24 | Joseph | Wyatt | 1941-10-12 | M | 24147 | Peyton | Jr. | 01245 | ||||||||||||||
Y000028 | Andrew Young | Y000028 | 411962 | 14063 | Andrew Young | Q959635 | kg:/m/018t4c | Andrew | Young | 1932-03-12 | M | 21064 | Jackson | Jr. | 01254 | ||||||||||||||
Z000004 | William Zeliff | Z000004 | 411997 | 29130 | Bill Zeliff | Q862681 | kg:/m/026yxgp | William | Zeliff | 1936-06-12 | M | 21115 | H. | Jr. | 01263 | ||||||||||||||
G000321 | Albert Gore | G000321 | 404679 | 14423 | Al Gore | Q19673 | kg:/m/0d05fv | Albert | Gore | 1948-03-31 | M | 13970 | Arnold | Al Gore | Jr. | 00449 | S170 | ||||||||||||
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 | ||||||||||
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 | |||||||
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 | |||||||
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 | ||||||
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 | |||||||
D000625 | Daniel Donovan | D000625 | 412672 | 21560 | Dan Donovan (politician) | Q5217998 | kg:/m/0c036qd | Daniel | Donovan | 1956-11-06 | M | M. | Daniel Donovan (New York) | Jr. | 02293 | 74763 | 127760 | Daniel M. Donovan, Jr. | N00036928 | [ "H6NY11174" ] |
2161 | ||||||||
B001292 | Donald Beyer | B001292 | 412657 | 21554 | Don Beyer | Q3036086 | kg:/m/053g16 | Donald | Beyer | 1950-06-20 | M | S. | Don Beyer | Jr. | 02272 | 21141 | 1707 | Donald S. Beyer, Jr. | N00036018 | [ "H4VA08224" ] |
2113 | ||||||||
P000604 | Donald Payne | P000604 | 412506 | 31103 | Donald Payne Jr. | Q1240224 | kg:/m/0jwr2v8 | Donald | Payne | 1958-12-17 | M | M. | Donald Payne Jr. | Jr. | 02097 | 65639 | 90668 | Donald M. Payne, Jr. | N00034639 | [ "H2NJ10154" ] |
1687 | [ { "name": "Donald Milford Payne", "relation": "son" } ] |
|||||||
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 | |||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | |||||||
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" ] |
|||||||||
C000714 | John Conyers | C000714 | 400080 | 10713 | John Conyers | Q1370968 | kg:/m/02hy5d | John | Conyers | 1929-05-16 | M | 11348 | John Conyers, Jr. | Jr. | 00229 | 1824 | 26904 | John Conyers, Jr. | N00004029 | [ "H6MI01028" ] |
195 | ||||||||
G000552 | Louie Gohmert | G000552 | 400651 | 20527 | Louie Gohmert | Q532647 | kg:/m/0490h9 | Louie | Gohmert | 1953-08-18 | M | 14263 | B. | Louie Gohmert | Jr. | 01801 | 1011394 | 50029 | Louie Gohmert | N00026148 | [ "H4TX04039" ] |
656 | |||||||
B001262 | Paul Broun | B001262 | 412252 | 20753 | Paul Broun | Q2059020 | kg:/m/02vzlfc | Paul | Broun | 1946-05-14 | M | 10422 | C. | Paul C. Broun | Jr. | 01882 | 1025092 | 70001 | Paul C. Broun | N00028986 | [ "H8GA10049", "S6GA00101", "H0GA03017" ] |
733 | |||||||
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 | |||||||
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" } ] |
||||||
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" } ] |
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);