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_fec
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
C001054 | Jerry Carl | C001054 | 456799 | Jerry Carl | Q102277702 | kg:/g/11j2j1brnb | Jerry | Carl | 1958-06-17 | M | Lee | Jr. | Jerry L. Carl | N00044245 | [ "H0AL01055" ] |
||||||||||||||
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" ] |
||||||||||
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 | ||||||||||
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" } ] |
||||||
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" ] |
||||||||||
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 | ||||||
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" } ] |
||||||
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" } ] |
|||||||
S000749 | John Spratt | S000749 | 400386 | 15064 | John Spratt | Q502028 | kg:/m/03jdc7 | John | Spratt | 1942-11-01 | M | 22064 | McKee | Jr. | 01092 | 13719 | 27065 | N00002492 | [ "H2SC05052" ] |
||||||||||
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" ] |
||||||||||
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" ] |
|||||||||||
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 | |||||||
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 | ||||||
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" ] |
||||||||||
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 | |||||||
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 | ||||||||
B000716 | Allen Boyd | B000716 | 400044 | 29713 | Allen Boyd | Q2600908 | kg:/m/0251w9 | Allen | Boyd | 1945-06-06 | M | 9711 | Jr. | 01467 | 46164 | 729 | N00002743 | [ "H6FL00046" ] |
|||||||||||
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" ] |
|||||||||
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 | ||||||||
P000323 | Charles Pickering | P000323 | 400319 | 29734 | Chip Pickering | Q452392 | kg:/m/033trc | Charles | Pickering | 1963-08-10 | M | 19675 | W. | Chip | Jr. | 01513 | 279 | N00003341 | [ "H6MS03046" ] |
||||||||||
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 | |||||||
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 | ||||||||
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" ] |
|||||||||||
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 | |||||||
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" ] |
|||||||||||
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" ] |
|||||||||||
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 | |||||||
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" ] |
|||||||||||
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" } ] |
||||||
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 | |||||||
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 | |||||||
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 | ||||||
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" ] |
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);