legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
70 rows where name_middle = "J."
This data as json, copyable, CSV (advanced)
Suggested facets: bio_gender, name_nickname, name_suffix, bio_birthday (date), id_fec (array)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B000151 | Thomas Barlow | B000151 | 401153 | 29351 | Thomas Barlow (Kentucky politician) | Q2439506 | kg:/m/092fm5 | Thomas | Barlow | 1940-08-07 | M | 8965 | J. | III | 00053 | ||||||||||||||
B000909 | Clarence Brown | B000909 | 401866 | 1104 | Clarence J. Brown | Q5126603 | kg:/m/03ldpq | Clarence | Brown | 1893-07-14 | M | 9955 | J. | ||||||||||||||||
B000910 | Clarence Brown | B000910 | 401867 | 10786 | Bud Brown (politician) | Q4983802 | kg:/m/03ldwb | Clarence | Brown | 1927-06-18 | M | 9956 | J. | Jr. | 00131 | ||||||||||||||
C000149 | Patrick Carley | C000149 | 402298 | 1506 | Patrick J. Carley | Q1446721 | kg:/m/08l365 | Patrick | Carley | 1866-02-02 | M | 10638 | J. | ||||||||||||||||
C000266 | Steve Chabot | C000266 | 400071 | 29550 | Steve Chabot | Q506694 | kg:/m/0343vk | Steve | Chabot | 1953-01-22 | M | 10791 | J. | Steve Chabot | 00186 | 36705 | 21790 | Steve Chabot | N00003689 | [ "H8OH01043" ] |
188 | ||||||||
C000605 | Charles Colden | C000605 | 402734 | 1919 | Charles J. Colden | Q166850 | kg:/m/05w2cf | Charles | Colden | 1870-08-24 | M | 11207 | J. | ||||||||||||||||
C000646 | Antonio Colorado | C000646 | 402774 | Antonio Colorado | Q2119871 | kg:/m/04960z | Antonio | Colorado | 1939-09-08 | M | 11261 | J. | 00223 | ||||||||||||||||
C000846 | William Coyne | C000846 | 400543 | 14808 | William J. Coyne | Q8013189 | kg:/m/0dc5_j | William | Coyne | 1936-08-24 | M | 11515 | J. | 00245 | |||||||||||||||
C000960 | Shepard Crumpacker | C000960 | 403072 | 2227 | Shepard J. Crumpacker Jr. | Q2800593 | kg:/m/02rkhp4 | Shepard | Crumpacker | 1917-02-13 | M | 11652 | J. | Jr. | |||||||||||||||
C001073 | Donald Cazayoux | C001073 | 412260 | 20760 | Don Cazayoux | Q1239044 | kg:/m/03m9xkc | Donald | Cazayoux | 1964-01-17 | M | 11807 | J. | Jr. | 01891 | 35272 | N00029680 | [ "H8LA06022" ] |
|||||||||||
D000359 | Joseph DioGuardi | D000359 | 403476 | 15095 | Joe DioGuardi | Q1390725 | kg:/m/0c61cj | Joseph | DioGuardi | 1940-09-20 | M | 12274 | J. | 00300 | |||||||||||||||
D000388 | Christopher Dodd | D000388 | 300034 | 14213 | Chris Dodd | Q319111 | kg:/m/01xcly | Christopher | Dodd | 1944-05-27 | M | 12312 | J. | 00302 | 53277 | S150 | N00000581 | [ "S0CT00037" ] |
|||||||||||
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" } ] |
||||||
D000563 | Richard Durbin | D000563 | 300038 | 15021 | Dick Durbin | Q434804 | kg:/m/01xcd1 | Richard | Durbin | 1944-11-21 | M | 12527 | J. | Dick Durbin | 00326 | 6741 | 26847 | S253 | Richard J. Durbin | N00004981 | [ "S6IL00151", "H2IL20026" ] |
563 | [ { "title": "Senate Minority Whip", "chamber": "senate", "start": "2005-01-04", "end": "2007-01-03" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2007-01-04", "end": "2009-01-06" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2009-01-06", "end": "2011-01-05" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "Senate Minority Whip", "chamber": "senate", "start": "2015-01-03", "end": "2017-01-03" }, { "title": "Senate Minority Whip", "chamber": "senate", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "Senate Minority Whip", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Minority Whip", "chamber": "senate", "start": "2021-01-03", "end": "2021-01-20" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2021-01-20" } ] |
||||||
E000033 | Fred Eckert | E000033 | 403728 | 15097 | Fred J. Eckert | Q5495555 | kg:/m/078xv_ | Fred | Eckert | 1941-05-06 | M | 12641 | J. | 00332 | |||||||||||||||
E000092 | Vernon Ehlers | E000092 | 400119 | 29362 | Vern Ehlers | Q205019 | kg:/m/02d44c | Vernon | Ehlers | 1934-02-06 | M | 12711 | J. | 00339 | 26907 | N00004166 | [ "H4MI03045" ] |
||||||||||||
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" ] |
|||||||||||
F000459 | Charles Fleischmann | F000459 | 412476 | 21178 | Chuck Fleischmann | Q521959 | kg:/m/0ddd54f | Charles | Fleischmann | 1962-10-11 | M | 13563 | J. | Chuck | Charles Fleischmann | 02061 | 95146 | 123456 | Charles J. "Chuck" Fleischmann | N00030815 | [ "H0TN03254" ] |
1481 | |||||||
G000113 | Thomas Geary | G000113 | 404485 | 3520 | Thomas J. Geary | Q964376 | kg:/m/02rjztf | Thomas | Geary | 1854-01-18 | M | 13702 | J. | ||||||||||||||||
G000336 | Porter Goss | G000336 | 400156 | 15605 | Porter Goss | Q455698 | kg:/m/0d18hh | Porter | Goss | 1938-11-26 | M | 13987 | J. | 00450 | N00002960 | ||||||||||||||
H000185 | John Hardin | H000185 | 405066 | 4053 | John J. Hardin | Q6241083 | kg:/m/02rkbqb | John | Hardin | 1810-01-06 | M | 14515 | J. | ||||||||||||||||
H000591 | Ebenezer Hill | H000591 | 405453 | 4409 | Ebenezer J. Hill | Q1278648 | kg:/m/02rhffc | Ebenezer | Hill | 1845-08-04 | M | 15017 | J. | ||||||||||||||||
H001039 | John Hall | H001039 | 412222 | 20734 | John Hall (New York politician) | Q1406115 | kg:/m/0bf27d | John | Hall | 1948-07-23 | M | 15574 | J. | 01865 | 1022042 | 69119 | N00027888 | [ "H6NY19144" ] |
|||||||||||
H001055 | Joseph Heck | H001055 | 412446 | 21151 | Joe Heck | Q24243 | kg:/m/03b_hhb | Joseph | Heck | 1961-10-30 | M | 15604 | J. | Joe Heck | 02040 | 62662 | 44082 | Joseph J. Heck | N00031244 | [ "H0NV03058" ] |
1456 | ||||||||
I000047 | Ernest Istook | I000047 | 400197 | 29392 | Ernest Istook | Q1356373 | kg:/m/033tfn | Ernest | Istook | 1950-02-11 | M | 15675 | J. | Jr. | 00586 | N00005551 | |||||||||||||
I000057 | Steve Israel | I000057 | 400195 | 20129 | Steve Israel | Q2096271 | kg:/m/03v3c9 | Steve | Israel | 1958-05-30 | M | 15691 | J. | Steve Israel | 01663 | 87911 | 55440 | Steve Israel | N00013345 | [ "H0NY02085" ] |
299 | ||||||||
J000070 | William Jefferson | J000070 | 400201 | 29120 | William J. Jefferson | Q983443 | kg:/m/025jsy | William | Jefferson | 1947-03-14 | M | 15783 | J. | 00592 | N00005353 | [ "H0LA02119" ] |
|||||||||||||
J000286 | William Janklow | J000286 | 400200 | 20348 | Bill Janklow | Q862213 | kg:/m/01s1lb | William | Janklow | 1939-09-13 | M | 16061 | J. | Bill | 01746 | N00011046 | |||||||||||||
K000312 | Michael Kopetski | K000312 | 406466 | 29139 | Michael J. Kopetski | Q1236198 | kg:/m/0kssgb | Michael | Kopetski | 1949-10-27 | M | 16473 | J. | 00648 | |||||||||||||||
K000336 | Dennis Kucinich | K000336 | 400227 | 29748 | Dennis Kucinich | Q310588 | kg:/m/01l4vj | Dennis | Kucinich | 1946-10-08 | M | 16506 | J. | 01499 | 45684 | 318 | Dennis J. Kucinich | N00003572 | [ "H6OH23033" ] |
||||||||||
L000174 | Patrick Leahy | L000174 | 300065 | 14307 | Patrick Leahy | Q59315 | kg:/m/0202kf | Patrick | Leahy | 1940-03-31 | M | J. | Patrick Leahy | 01383 | 1552 | 53353 | S057 | Patrick J. Leahy | N00009918 | [ "S4VT00017" ] |
586 | [ { "title": "President Pro Tempore of the Senate", "chamber": "senate", "start": "2021-01-20" } ] |
|||||||
L000297 | William Lewis | L000297 | 406792 | 5651 | William J. Lewis | Q93811 | kg:/m/02vrpl6 | William | Lewis | 1766-07-04 | M | 16962 | J. | ||||||||||||||||
L000507 | Charles Luken | L000507 | 406993 | 15823 | Charlie Luken | Q1066931 | kg:/m/03d64q | Charles | Luken | 1951-07-18 | M | 17224 | J. | 00714 | |||||||||||||||
L000556 | John LaFalce | L000556 | 400537 | 14248 | John J. LaFalce | Q13219122 | kg:/m/093_q8 | John | LaFalce | 1939-10-06 | M | 17290 | J. | 00657 | |||||||||||||||
M000117 | Thomas Manton | M000117 | 407141 | 15107 | Thomas J. Manton | Q7791100 | kg:/m/076dc7 | Thomas | Manton | 1932-11-03 | M | 17475 | J. | 00732 | |||||||||||||||
M000133 | Edward Markey | M000133 | 400253 | 14435 | Ed Markey | Q1282411 | kg:/m/028vr4 | Edward | Markey | 1946-07-11 | M | 17493 | J. | Ed | Ed Markey | 00735 | 260 | 26900 | S369 | Edward J. Markey | N00000270 | [ "H6MA07101", "S4MA00028" ] |
351 | ||||||
M000193 | Lewis Martin | M000193 | 407214 | 6035 | Lewis J. Martin | Q521846 | kg:/m/02x2hsj | Lewis | Martin | 1844-02-22 | M | 17561 | J. | ||||||||||||||||
M000207 | William Martini | M000207 | 407226 | 29540 | William J. Martini | Q1416536 | kg:/m/08st5c | William | Martini | 1947-02-10 | M | 17579 | J. | 00744 | |||||||||||||||
M001100 | Maurice Murphy | M001100 | 408064 | 10815 | Maurice J. Murphy Jr. | Q5997815 | kg:/m/08v652 | Maurice | Murphy | 1927-10-03 | M | J. | Jr. | ||||||||||||||||
M001161 | Charles Melancon | M001161 | 400635 | 20513 | Charlie Melançon | Q504241 | kg:/m/04lq4r | Charles | Melancon | 1947-10-03 | M | 18794 | J. | 01786 | 1011754 | 35601 | N00026840 | [ "H4LA03028" ] |
|||||||||||
M001168 | Patrick Murphy | M001168 | 412233 | 20745 | Patrick Murphy (Pennsylvania politician) | Q5997832 | kg:/m/085srz | Patrick | Murphy | 1973-10-19 | M | 18807 | J. | 01875 | 1021384 | 60031 | N00027594 | [ "H6PA08194" ] |
|||||||||||
M001199 | Brian Mast | M001199 | 412698 | 21735 | Brian Mast | Q27733854 | kg:/g/11cs5xxx_f | Brian | Mast | 1980-07-10 | M | J. | Brian Mast | 104540 | 166245 | Brian J. Mast | N00037269 | [ "H6FL18097" ] |
2210 | ||||||||||
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 | |||||||
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 | |||||||
P000112 | Elizabeth Patterson | P000112 | 408520 | 15171 | Liz J. Patterson | Q1866591 | kg:/m/0fkc60 | Elizabeth | Patterson | 1939-11-18 | F | 19412 | J. | 00897 | |||||||||||||||
P000129 | Thomas Patterson | P000129 | 412172 | 7254 | Thomas J. Paterson | Q3388801 | kg:/m/02rkx60 | Thomas | Patterson | 1805-04-10 | M | 19436 | J. | ||||||||||||||||
P000449 | Robert Portman | P000449 | 400325 | 29386 | Rob Portman | Q926069 | kg:/m/0343xg | Robert | Portman | 1955-12-19 | M | 19838 | J. | Rob | Rob Portman | 00924 | 31819 | 27008 | S349 | Rob Portman | N00003682 | [ "S0OH00133", "H4OH02032" ] |
419 | ||||||
P000609 | Gary Palmer | P000609 | 412608 | 21500 | Gary Palmer (politician) | Q17386504 | kg:/m/0115nklq | Gary | Palmer | 1954-05-14 | M | J. | Gary Palmer | 02221 | 76094 | 146274 | Gary J. Palmer | N00035691 | [ "H4AL06098" ] |
2064 | [ { "title": "House Republican Policy Committee Chair", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Republican Policy Committee Chair", "chamber": "house", "start": "2021-01-03" } ] |
||||||||
R000002 | Benjamin Rabin | R000002 | 408986 | 7683 | Benjamin J. Rabin | Q4888864 | kg:/m/027lb2m | Benjamin | Rabin | 1896-06-03 | M | 20076 | J. | ||||||||||||||||
R000011 | Nick Rahall | R000011 | 400331 | 14448 | Nick Rahall | Q262534 | kg:/m/024zc8 | Nick | Rahall | 1949-05-20 | M | 20087 | J. | Nick Rahall | II | 00940 | 8272 | 27133 | Nick J. Rahall II | N00002198 | [ "H6WV04057" ] |
424 | |||||||
R000577 | Tim Ryan | R000577 | 400352 | 20343 | Tim Ryan (Ohio politician) | Q513960 | kg:/m/039tr9 | Tim | Ryan | 1973-07-16 | M | 20799 | J. | Tim Ryan (Ohio) | 01756 | 1003608 | 45638 | Tim Ryan | N00025280 | [ "H2OH17109" ] |
444 | ||||||||
R000580 | Peter Roskam | R000580 | 412202 | 20715 | Peter Roskam | Q968214 | kg:/m/0gj190 | Peter | Roskam | 1961-09-13 | M | 20803 | J. | Peter Roskam | 01848 | 1021912 | 6382 | Peter J. Roskam | N00004719 | [ "H6IL06117", "H8IL13051" ] |
689 | ||||||||
R000583 | Thomas Rooney | R000583 | 412311 | 20910 | Tom Rooney (Florida politician) | Q506110 | kg:/m/04jl2j4 | Thomas | Rooney | 1970-11-21 | M | 20809 | J. | Thomas J. Rooney | 01916 | 1030486 | 107800 | Thomas J. Rooney | N00029018 | [ "H8FL16022" ] |
793 | ||||||||
R000587 | Reid Ribble | R000587 | 412489 | 21190 | Reid Ribble | Q2139894 | kg:/m/0dddvmy | Reid | Ribble | 1956-04-05 | M | 20815 | J. | Reid Ribble | 02073 | 62776 | 126240 | Reid J. Ribble | N00030968 | [ "H0WI08075" ] |
1494 | ||||||||
R000598 | Keith Rothfus | R000598 | 412570 | 21357 | Keith Rothfus | Q5978897 | kg:/m/0ds0r5g | Keith | Rothfus | 1962-04-25 | M | J. | Keith Rothfus | 02158 | 61949 | 119466 | Keith J. Rothfus | N00031253 | [ "H0PA04220" ] |
1794 | |||||||||
S000059 | Richard Santorum | S000059 | 300085 | 29141 | Rick Santorum | Q155985 | kg:/m/01fgd3 | Richard | Santorum | 1958-05-10 | M | 21206 | J. | Rick | Rick Santorum | 01015 | 27054 | S244 | N00001380 | ||||||||||
S000344 | Brad Sherman | S000344 | 400371 | 29707 | Brad Sherman | Q672919 | kg:/m/024tkr | Brad | Sherman | 1954-10-24 | M | 21565 | J. | Brad Sherman | 01526 | 45124 | 142 | Brad Sherman | N00006897 | [ "H6CA24113" ] |
462 | ||||||||
S000360 | Ebenezer Shields | S000360 | 409856 | 8468 | Ebenezer J. Shields | Q1278655 | kg:/m/0cglp3 | Ebenezer | Shields | 1778-12-22 | M | 21584 | J. | ||||||||||||||||
S000663 | Olympia Snowe | S000663 | 300091 | 14661 | Olympia Snowe | Q22290 | kg:/m/020yg2 | Olympia | Snowe | 1947-02-21 | F | 21955 | J. | 01085 | 26885 | S245 | Olympia J. Snowe | N00000480 | [ "S4ME00055" ] |
||||||||||
S000677 | Peter Somers | S000677 | 410149 | 8740 | Peter J. Somers | Q1309484 | kg:/m/07c9wd | Peter | Somers | 1850-04-12 | M | 21975 | J. | ||||||||||||||||
T000048 | Randy Tate | T000048 | 410636 | 29582 | Randy Tate | Q2130820 | kg:/m/027l921 | Randy | Tate | 1965-11-23 | M | 22693 | J. | 01138 | |||||||||||||||
T000058 | William Tauzin | T000058 | 400397 | 14679 | Billy Tauzin | Q863238 | kg:/m/025jtz | William | Tauzin | 1943-06-14 | M | 22705 | J. | Billy | 01140 | N00005372 | |||||||||||||
T000461 | Patrick Toomey | T000461 | 400408 | 29935 | Pat Toomey | Q971308 | kg:/m/02_kk7 | Patrick | Toomey | 1961-11-17 | M | 23202 | J. | Pat | Pat Toomey | 02085 | 7958 | 24096 | S351 | Patrick J. Toomey | N00001489 | [ "S4PA00121", "H8PA15096" ] |
1406 | ||||||
T000462 | Patrick Tiberi | T000462 | 400406 | 20130 | Pat Tiberi | Q603467 | kg:/m/02zfh_ | Patrick | Tiberi | 1962-10-21 | M | 23204 | J. | Pat | Patrick J. Tiberi | 01664 | 88155 | 8404 | Patrick J. Tiberi | N00009699 | [ "H0OH12062" ] |
493 | |||||||
T000474 | Norma Torres | T000474 | 412617 | 21508 | Norma Torres | Q3343727 | kg:/m/03wd1hs | Norma | Torres | 1965-04-04 | F | 15032410409 | J. | Norma Torres | 02231 | 76129 | 71284 | Norma J. Torres | N00036107 | [ "H4CA35031" ] |
2073 | ||||||||
T000483 | David Trone | T000483 | 412783 | 21978 | David Trone | Q29446408 | kg:/g/11dxnzbmvl | David | Trone | 1955-09-21 | M | J. | David Trone | 167336 | David J. Trone | N00039122 | [ "H6MD08549" ] |
||||||||||||
V000101 | Bird Vincent | V000101 | 411156 | 9673 | Bird J. Vincent | Q865059 | kg:/m/02px_rt | Bird | Vincent | 1880-03-06 | M | 20995 | J. | ||||||||||||||||
V000108 | Peter Visclosky | V000108 | 400417 | 15124 | Pete Visclosky | Q514660 | kg:/m/022r85 | Peter | Visclosky | 1949-08-13 | M | 21005 | J. | Peter J. Visclosky | 01188 | 6785 | 26851 | Peter J. Visclosky | N00003813 | [ "H4IN01012" ] |
502 | ||||||||
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" ] |
||||||||||
W000804 | Robert Wittman | W000804 | 412255 | 20756 | Rob Wittman | Q541251 | kg:/m/03cx7ld | Robert | Wittman | 1959-02-03 | M | 24189 | J. | Robert J. Wittman | 01886 | 1028089 | 58133 | Robert J. Wittman | N00029459 | [ "H8VA01147" ] |
736 |
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);