legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by name_official_full 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D000598 | Susan Davis | D000598 | 400097 | 20108 | Susan Davis (politician) | Q460675 | kg:/m/024xs5 | Susan | Davis | 1944-04-13 | F | 12571 | A. | 01641 | 85595 | 8168 | Susan A. Davis | N00009604 | [ "H0CA49055" ] |
207 | |||||||||
M001134 | Sue Myrick | M001134 | 400288 | 29549 | Sue Myrick | Q367796 | kg:/m/03g_vm | Sue | Myrick | 1941-08-01 | F | 18745 | W. | 00849 | 1172 | 21789 | Sue Wilkins Myrick | N00002327 | [ "H4NC09106" ] |
||||||||||
R000462 | Steven Rothman | R000462 | 400346 | 29742 | Steve Rothman | Q1286695 | kg:/m/02dvt1 | Steven | Rothman | 1952-10-14 | M | 20655 | R. | 01520 | 45112 | 481 | Steven R. Rothman | N00008619 | [ "H6NJ09165" ] |
||||||||||
P000601 | Steven Palazzo | P000601 | 412443 | 21148 | Steven Palazzo | Q24230 | kg:/m/0c3y_s5 | Steven | Palazzo | 1970-02-21 | M | 20039 | M. | Steven Palazzo | 02035 | 61886 | 69521 | Steven M. Palazzo | N00031958 | [ "H0MS04120" ] |
1453 | ||||||||
H001066 | Steven Horsford | H001066 | 412559 | 21339 | Steven Horsford | Q3514907 | kg:/m/03c01w9 | Steven | Horsford | 1973-04-29 | M | A. | Steven Horsford | 02147 | 79614 | 44064 | Steven Horsford | N00033638 | [ "H2NV04011" ] |
1783 | |||||||||
L000553 | Steven LaTourette | L000553 | 400235 | 29553 | Steve LaTourette | Q973330 | kg:/m/034cg0 | Steven | LaTourette | 1954-07-22 | M | 17286 | C. | 00667 | 36748 | 21798 | Steven C. LaTourette | N00003545 | [ "H4OH19036" ] |
||||||||||
W000809 | Steve Womack | W000809 | 412402 | 21108 | Steve Womack | Q1029527 | kg:/m/0cmcvkz | Steve | Womack | 1957-02-18 | M | 24197 | Steve Womack | 01991 | 1033625 | 71815 | Steve Womack | N00031857 | [ "H0AR03055" ] |
1416 | |||||||||
W000824 | Steven Watkins | W000824 | 412779 | 21982 | Steve Watkins | Q60428824 | kg:/g/11fk40t80r | Steven | Watkins | 1976-09-18 | M | C. | Steve Watkins | 181200 | Steve Watkins | N00042126 | [ "H8KS02199" ] |
||||||||||||
S000937 | Steve Stockman | S000937 | 410396 | 29570 | Steve Stockman | Q1605321 | kg:/m/03s7kz | Steve | Stockman | 1956-11-14 | M | 22297 | Steve Stockman | 01114 | 3626 | 21703 | Steve Stockman | N00005918 | [ "H6TX22143", "H0TX09077" ] |
1731 | |||||||||
S001187 | Steve Stivers | S001187 | 412461 | 21163 | Steve Stivers | Q324099 | kg:/m/08xnqw | Steve | Stivers | 1965-03-24 | M | 22627 | Steve Stivers | 02047 | 62320 | 45333 | Steve Stivers | N00029574 | [ "H8OH15076" ] |
1467 | |||||||||
S001186 | Steve Southerland | S001186 | 412408 | 21114 | Steve Southerland (Florida politician) | Q2347302 | kg:/m/0cz7x_b | Steve | Southerland | 1965-10-10 | M | 22626 | Steve Southerland II | 02000 | 61775 | 124329 | Steve Southerland II | N00031204 | [ "H0FL02110" ] |
1420 | |||||||||
S001176 | Steve Scalise | S001176 | 412261 | 20759 | Steve Scalise | Q1857141 | kg:/m/0br34c | Steve | Scalise | 1965-10-06 | M | 22608 | Joseph | Steve Scalise | 01892 | 1015311 | 9026 | Steve Scalise | N00009660 | [ "H0LA01087" ] |
742 | [ { "title": "House Majority Whip", "chamber": "house", "start": "2014-08-01", "end": "2015-01-03" }, { "title": "House Majority Whip", "chamber": "house", "start": "2015-01-06", "end": "2017-01-03" }, { "title": "House Majority Whip", "chamber": "house", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2021-01-03" } ] |
|||||||
R000604 | Steve Russell | R000604 | 412650 | 21546 | Steve Russell (politician) | Q16195304 | kg:/m/0ndnv6f | Steve | Russell | 1963-05-25 | M | 02265 | 77286 | 106528 | Steve Russell | N00036175 | [ "H4OK05132" ] |
2106 | |||||||||||
K000362 | Steve King | K000362 | 400220 | 20325 | Steve King | Q749710 | kg:/m/025b7g | Steve | King | 1949-05-28 | M | 16548 | A. | Steve King | 01724 | 1003590 | 10853 | Steve King | N00025237 | [ "H2IA05072" ] |
320 | ||||||||
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 | ||||||||
D000618 | Steve Daines | D000618 | 412549 | 21338 | Steve Daines | Q3200900 | kg:/m/03qlc5t | Steve | Daines | 1962-08-20 | M | Steve Daines | 02138 | 1034037 | 135720 | S375 | Steve Daines | N00033054 | [ "H2MT01060", "S2MT00096" ] |
1773 | |||||||||
C001068 | Steve Cohen | C001068 | 412236 | 20748 | Steve Cohen | Q512330 | kg:/m/04l8cr | Steve | Cohen | 1949-05-24 | M | 11800 | Steve Cohen | 01878 | 1022876 | 24340 | Steve Cohen | N00003225 | [ "H6TN09068" ] |
721 | |||||||||
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 | ||||||||
A000365 | Steve Austria | A000365 | 412265 | 20940 | Steve Austria | Q144226 | kg:/m/04l4w1 | Steve | Austria | 1958-10-12 | M | 8765 | 01947 | 1031355 | 23398 | Steve Austria | N00029412 | [ "H8OH07065" ] |
|||||||||||
P000588 | Stevan Pearce | P000588 | 400313 | 20337 | Steve Pearce (politician) | Q947168 | kg:/m/033t2h | Stevan | Pearce | 1947-08-24 | M | 20015 | E. | Steve | Steve Pearce | 01738 | 12063 | 10655 | Stevan Pearce | N00012672 | [ "H2NM02126", "S0NM00041" ] |
407 | |||||||
F000458 | Stephen Fincher | F000458 | 412479 | 21181 | Stephen Fincher | Q2344713 | kg:/m/0ddgg4w | Stephen | Fincher | 1973-02-07 | M | 13562 | Lee | 02064 | 9268967 | 124659 | Stephen Lee Fincher | N00031141 | [ "H0TN08246" ] |
1484 | |||||||||
K000387 | Steve Knight | K000387 | 412614 | 21505 | Steve Knight (politician) | Q7613060 | kg:/m/05zjrvq | Steve | Knight | 1966-12-17 | M | Stephen Knight | 02228 | 76118 | 71098 | Stephen Knight | N00035820 | [ "H4CA25123" ] |
2070 | ||||||||||
L000562 | Stephen Lynch | L000562 | 400249 | 20119 | Stephen F. Lynch | Q2344921 | kg:/m/028vsz | Stephen | Lynch | 1955-03-31 | M | 17301 | F. | Stephen Lynch | 01686 | 1000222 | 4844 | Stephen F. Lynch | N00013855 | [ "H2MA09072", "S0MA00083" ] |
348 | ||||||||
M001202 | Stephanie Murphy | M001202 | 412694 | 21738 | Stephanie Murphy | Q27804538 | kg:/g/11c48s1mnv | Stephanie | Murphy | 1978-09-16 | F | N. | Stephanie Murphy | 103502 | 173426 | Stephanie N. Murphy | N00040133 | [ "H6FL07140" ] |
2206 | ||||||||||
B000740 | Stephanie Bice | B000740 | 456841 | Stephanie Bice | Q60190894 | kg:/g/11h2hmkrv8 | Stephanie | Bice | 1973-11-11 | F | I. | Stephanie Bice | Stephanie I. Bice | N00044579 | [ "H0OK05205" ] |
||||||||||||||
H000874 | Steny Hoyer | H000874 | 400189 | 14873 | Steny Hoyer | Q516515 | kg:/m/025k5p | Steny | Hoyer | 1939-06-14 | M | 15365 | H. | Steny Hoyer | 00566 | 1919 | 26890 | Steny H. Hoyer | N00001821 | [ "H2MD05155" ] |
293 | [ { "title": "House Minority Whip", "chamber": "house", "start": "2003-01-07", "end": "2005-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2005-01-04", "end": "2007-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2015-01-06", "end": "2017-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "House Majority Leader", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Majority Leader", "chamber": "house", "start": "2021-01-03" } ] |
|||||||
P000610 | Stacey Plaskett | P000610 | 412659 | Stacey Plaskett | Q18739104 | kg:/m/012844_c | Stacey | Plaskett | 1966-05-13 | F | 15032410230 | E. | 02274 | 79090 | 155929 | Stacey E. Plaskett | N00035000 | [ "H2VI00082" ] |
2115 | ||||||||||
B000013 | Spencer Bachus | B000013 | 400010 | 29301 | Spencer Bachus | Q1368315 | kg:/m/024p0v | Spencer | Bachus | 1947-12-28 | M | 8789 | Thomas | Spencer Bachus | III | 00038 | 26397 | 26715 | Spencer Bachus | N00008091 | [ "H2AL06035" ] |
133 | |||||||
R000170 | Silvestre Reyes | R000170 | 400337 | 29764 | Silvestre Reyes | Q966208 | kg:/m/03v397 | Silvestre | Reyes | 1944-11-10 | M | 20297 | 01516 | 45744 | 292 | Silvestre Reyes | N00006067 | [ "H6TX00115" ] |
|||||||||||
B001313 | Shontel Brown | B001313 | 456863 | Shontel Brown | Q107863952 | Shontel | Brown | 1975-06-24 | F | M. | Shontel M. Brown | N00047875 | [ "H2OH11169" ] |
||||||||||||||||
B000944 | Sherrod Brown | B000944 | 400050 | 29389 | Sherrod Brown | Q381880 | kg:/m/034s80 | Sherrod | Brown | 1952-11-09 | M | 9996 | Sherrod Brown | 00136 | 5051 | 27018 | S307 | Sherrod Brown | N00003535 | [ "H2OH13033", "S6OH00163" ] |
168 | ||||||||
C001047 | Shelley Capito | C001047 | 400061 | 20146 | Shelley Moore Capito | Q459618 | kg:/m/024pwq | Shelley | Capito | 1953-11-26 | F | 11762 | Moore | Shelley Moore Capito | 01676 | 83737 | 11701 | S372 | Shelley Moore Capito | N00009771 | [ "H0WV02138", "S4WV00159" ] |
179 | [ { "name": "Arch Alfred Moore Jr.", "relation": "daughter" } ] |
||||||
B001231 | Shelley Berkley | B001231 | 400024 | 29922 | Shelley Berkley | Q460378 | kg:/m/025h7j | Shelley | Berkley | 1951-01-20 | F | 10363 | 01576 | 22744 | Shelley Berkley | N00009818 | [ "H8NV01071" ] |
||||||||||||
W000802 | Sheldon Whitehouse | W000802 | 412247 | 40704 | Sheldon Whitehouse | Q652066 | kg:/m/07qw94 | Sheldon | Whitehouse | 1955-10-20 | M | Sheldon Whitehouse | 01823 | 92235 | 2572 | S316 | Sheldon Whitehouse | N00027533 | [ "S6RI00221" ] |
728 | |||||||||
J000032 | Sheila Jackson Lee | J000032 | 400199 | 29573 | Sheila Jackson Lee | Q461734 | kg:/m/02fj6h | Sheila | Jackson Lee | 1950-01-12 | F | 15730 | Sheila Jackson Lee | 00588 | 36819 | 21692 | Sheila Jackson Lee | N00005818 | [ "H4TX18054" ] |
338 | |||||||||
C001127 | Sheila Cherfilus-McCormick | C001127 | 456865 | Sheila Cherfilus-McCormick | Q109560948 | Sheila | Cherfilus-McCormick | 1979-01-25 | F | Sheila Cherfilus-McCormick | N00043504 | [ "H8FL20032" ] |
|||||||||||||||||
D000629 | Sharice Davids | D000629 | 412780 | 21914 | Sharice Davids | Q58322868 | kg:/g/11fgm1fq16 | Sharice | Davids | 1980-05-22 | F | Sharice Davids | 181201 | Sharice Davids | N00042626 | [ "H8KS03155" ] |
|||||||||||||
M001196 | Seth Moulton | M001196 | 412632 | 21525 | Seth Moulton | Q18045052 | kg:/m/0sgh587 | Seth | Moulton | 1978-10-24 | M | Seth Moulton | 02246 | 78453 | 146299 | Seth Moulton | N00035431 | [ "H4MA06090" ] |
2088 | ||||||||||
M001185 | Sean Maloney | M001185 | 412562 | 21344 | Sean Patrick Maloney | Q2262244 | kg:/m/0b697g | Sean | Maloney | 1966-07-30 | M | Patrick | Sean Maloney | 02150 | 79760 | 139760 | Sean Patrick Maloney | N00034277 | [ "H2NY22139" ] |
1786 | |||||||||
D000614 | Sean Duffy | D000614 | 412488 | 21189 | Sean Duffy | Q1729888 | kg:/m/026m6hd | Sean | Duffy | 1971-10-03 | M | 12601 | P. | Sean Duffy | 02072 | 623570 | 126238 | Sean P. Duffy | N00030967 | [ "H0WI07051" ] |
1493 | ||||||||
C001117 | Sean Casten | C001117 | 412775 | 21906 | Sean Casten | Q55386655 | kg:/g/11hc_0775g | Sean | Casten | 1971-11-23 | M | Sean Casten | 176982 | Sean Casten | N00041338 | [ "H8IL06139" ] |
|||||||||||||
T000477 | Scott Taylor | T000477 | 412727 | 21748 | Scott Taylor (politician) | Q17089502 | kg:/m/011bsmj8 | Scott | Taylor | 1979-06-27 | M | 96047 | 144514 | Scott Taylor | N00031263 | [ "H0VA02118" ] |
2239 | ||||||||||||
T000470 | Scott Tipton | T000470 | 412405 | 21111 | Scott Tipton | Q782994 | kg:/m/0bn82p | Scott | Tipton | 1956-11-09 | M | 23219 | R. | Scott Tipton | 01997 | 60384 | 65403 | Scott R. Tipton | N00027509 | [ "H6CO03139" ] |
1417 | ||||||||
P000605 | Scott Perry | P000605 | 412569 | 21356 | Scott Perry (politician) | Q7437040 | kg:/m/04mwt6y | Scott | Perry | 1962-05-27 | M | Scott Perry | 02157 | 79873 | 59980 | Scott Perry | N00034120 | [ "H2PA04135" ] |
1793 | ||||||||||
B001268 | Scott Brown | B001268 | 412384 | 40913 | Scott Brown (politician) | Q155125 | kg:/m/0bmg6w | Scott | Brown | 1959-09-12 | M | Scott Brown (Massachusetts) | 01975 | 9266532 | 18919 | S335 | Scott P. Brown | N00031174 | [ "S0MA00109" ] |
||||||||||
P000608 | Scott Peters | P000608 | 412523 | 21315 | Scott Peters (politician) | Q3791514 | kg:/m/02rymxd | Scott | Peters | 1958-06-17 | M | H. | Scott Peters | 02113 | 79661 | 70351 | Scott H. Peters | N00033591 | [ "H2CA52089" ] |
1747 | |||||||||
G000548 | Scott Garrett | G000548 | 400145 | 20336 | Scott Garrett | Q981424 | kg:/m/033f6x | Scott | Garrett | 1959-07-09 | M | 14255 | Scott Garrett | 01737 | 1003601 | 4430 | Scott Garrett | N00000743 | [ "H8NJ05052" ] |
254 | |||||||||
F000471 | Scott Fitzgerald | F000471 | 456855 | Scott L. Fitzgerald | Q7436650 | kg:/m/03nvqsc | Scott | Fitzgerald | 1963-11-16 | M | L. | 3446 | Scott Fitzgerald | N00045434 | [ "H0WI05113" ] |
||||||||||||||
D000616 | Scott DesJarlais | D000616 | 412477 | 21179 | Scott DesJarlais | Q2260839 | kg:/m/09k4h2_ | Scott | DesJarlais | 1964-02-21 | M | 12604 | Scott DesJarlais | 02062 | 623517 | 123473 | Scott DesJarlais | N00030957 | [ "H0TN04195" ] |
1482 | |||||||||
C000286 | Saxby Chambliss | C000286 | 300021 | 29512 | Saxby Chambliss | Q734330 | kg:/m/01xcms | Saxby | Chambliss | 1943-11-10 | M | 10813 | Saxby Chambliss | 00188 | 36571 | 22029 | S290 | Saxby Chambliss | N00002685 | [ "S2GA00118", "H2GA08038" ] |
547 | ||||||||
J000305 | Sara Jacobs | J000305 | 456804 | Sara Jacobs | Q50825637 | kg:/g/11ghs2x3tm | Sara | Jacobs | 1989-02-01 | F | Sara Jacobs | N00042081 | [ "H8CA49074" ] |
||||||||||||||||
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 | |||||||
A000366 | Sandy Adams | A000366 | 412414 | 21120 | Sandy Adams | Q513789 | kg:/m/057njwc | Sandy | Adams | 1956-12-14 | F | 8767 | 02006 | 31041 | Sandy Adams | N00030926 | [ "H0FL24049" ] |
||||||||||||
L000263 | Sander Levin | L000263 | 400238 | 15033 | Sander Levin | Q971943 | kg:/m/02n8p2 | Sander | Levin | 1931-09-06 | M | 16921 | M. | Sander Levin | 00683 | 251 | 26918 | Sander M. Levin | N00003950 | [ "H2MI17023" ] |
339 | [ { "name": "Carl Levin", "relation": "brother" } ] |
|||||||
J000174 | Sam Johnson | J000174 | 400206 | 29143 | Sam Johnson | Q539470 | kg:/m/02_21s | Sam | Johnson | 1930-10-11 | M | 15916 | Robert | 00603 | 18711 | 27079 | Sam Johnson | N00008028 | [ "H2TX03118" ] |
307 | |||||||||
G000546 | Sam Graves | G000546 | 400158 | 20124 | Sam Graves | Q465638 | kg:/m/03tnfy | Sam | Graves | 1963-11-07 | M | 14251 | B. | Sam Graves | 01656 | 89873 | 9425 | Sam Graves | N00013323 | [ "H0MO06073" ] |
265 | ||||||||
F000030 | Sam Farr | F000030 | 400129 | 29313 | Sam Farr | Q675348 | kg:/m/024t9w | Sam | Farr | 1941-07-04 | M | 13001 | 00368 | 30645 | 26745 | Sam Farr | N00007312 | [ "H4CA17021" ] |
240 | ||||||||||
C001112 | Salud Carbajal | C001112 | 412686 | 21709 | Salud Carbajal | Q27805429 | kg:/g/11cmh_7rjt | Salud | Carbajal | 1964-11-18 | M | O. | Salud Carbajal | 104728 | 81569 | Salud O. Carbajal | N00037015 | [ "H6CA24303" ] |
2198 | ||||||||||
Z000018 | Ryan Zinke | Z000018 | 412640 | Ryan Zinke | Q7384672 | kg:/m/0gkz1jg | Ryan | Zinke | 1961-11-01 | M | 02254 | 104073 | Ryan K. Zinke | N00035616 | [ "H4MT01041" ] |
2096 | |||||||||||||
C001106 | Ryan Costello | C001106 | 412651 | 21547 | Ryan Costello | Q18631846 | kg:/m/0127dxsz | Ryan | Costello | 1976-09-07 | M | 02266 | 95125 | 133557 | Ryan A. Costello | N00031064 | [ "H0PA06076" ] |
2107 | |||||||||||
F000469 | Russ Fulcher | F000469 | 412773 | 21920 | Russ Fulcher | Q7381134 | kg:/m/05h4vgh | Russ | Fulcher | 1973-07-19 | M | Russ Fulcher | 33091 | Russ Fulcher | N00041335 | [ "H8ID01124" ] |
|||||||||||||
C001060 | Russ Carnahan | C001060 | 400638 | 20516 | Russ Carnahan | Q1667920 | kg:/m/04cb6p | Russ | Carnahan | 1958-07-10 | M | 11784 | 01789 | 1003284 | 39948 | Russ Carnahan | N00005181 | [ "H0MO00019" ] |
|||||||||||
H001032 | Rush Holt | H001032 | 400184 | 29923 | Rush Holt Jr. | Q528359 | kg:/m/0g6t4q | Rush | Holt | 1948-10-15 | M | 15560 | D. | 01580 | 57967 | 22574 | Rush Holt | N00000860 | [ "H6NJ12144" ] |
289 | [ { "name": "Rush D. Holt", "relation": "son" } ] |
||||||||
H000636 | Rubén Hinojosa | H000636 | 400179 | 29763 | Rubén Hinojosa | Q256517 | kg:/m/03fvy5 | Rubén | Hinojosa | 1940-08-20 | M | 15071 | E. | Ruben Hinojosa | 01490 | 45743 | 291 | Rubén Hinojosa | N00006008 | [ "H6TX15055" ] |
285 | ||||||||
K000390 | Ruben Kihuen | K000390 | 412716 | 21729 | Ruben Kihuen | Q7375978 | kg:/m/03hnv7g | Ruben | Kihuen | 1980-04-25 | M | 79707 | 66851 | Ruben J. Kihuen | N00033530 | [ "H2NV00050" ] |
2228 | ||||||||||||
G000574 | Ruben Gallego | G000574 | 412612 | 21502 | Ruben Gallego | Q16218474 | kg:/m/0wy0mz5 | Ruben | Gallego | 1979-11-20 | M | Ruben Gallego | 02226 | 77233 | 123732 | Ruben Gallego | N00036097 | [ "H4AZ07043" ] |
2068 | ||||||||||
B000575 | Roy Blunt | B000575 | 400034 | 29735 | Roy Blunt | Q1525924 | kg:/m/034fn4 | Roy | Blunt | 1950-01-10 | M | 9520 | Roy Blunt | 01464 | 45465 | 418 | S342 | Roy Blunt | N00005195 | [ "H6MO07128", "S0MO00183" ] |
153 | [ { "title": "Senate Republican Policy Committee Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Republican Policy Committee Chair", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
S001210 | Ross Spano | S001210 | 412765 | 21967 | Ross Spano | Q16196710 | kg:/m/0v3c060 | Ross | Spano | 1966-07-16 | M | Ross Spano | 142164 | Ross Spano | N00043319 | [ "H8FL15230" ] |
|||||||||||||
B000208 | Roscoe Bartlett | B000208 | 400017 | 29356 | Roscoe Bartlett | Q1432143 | kg:/m/025k82 | Roscoe | Bartlett | 1926-06-03 | M | 9042 | G. | 00060 | 27026 | 26891 | Roscoe G. Bartlett | N00002017 | [ "H2MD06054" ] |
||||||||||
D000216 | Rosa DeLauro | D000216 | 400103 | 29109 | Rosa DeLauro | Q434952 | kg:/m/024zn0 | Rosa | DeLauro | 1943-03-02 | F | 12101 | L. | Rosa DeLauro | 00281 | 19040 | 26788 | Rosa L. DeLauro | N00000615 | [ "H0CT03072" ] |
215 | ||||||||
J000304 | Ronny Jackson | J000304 | 456847 | Ronny Jackson | Q47270118 | kg:/g/11gfhx0vbg | Ronny | Jackson | 1967-05-04 | M | Lynn | Ronny Jackson | Ronny Jackson | N00046055 | [ "H0TX13228" ] |
||||||||||||||
W000779 | Ron Wyden | W000779 | 300100 | 14871 | Ron Wyden | Q529344 | kg:/m/0178p9 | Ron | Wyden | 1949-05-03 | M | 24150 | Ron Wyden | 01247 | 1962 | 27036 | S247 | Ron Wyden | N00007724 | [ "S6OR00110", "H0OR03026" ] |
619 | ||||||||
W000827 | Ron Wright | W000827 | 412823 | 21984 | Ron Wright (politician) | Q60428775 | kg:/g/11fgkl82tl | Ron | Wright | 1953-04-08 | M | Ronald Wright | 78666 | Ron Wright | N00042240 | [ "H8TX06233" ] |
|||||||||||||
P000583 | Ronald Paul | P000583 | 400311 | 14290 | Ron Paul | Q15257 | kg:/m/016lh0 | Ronald | Paul | 1935-08-20 | M | 20005 | E. | Ron | 00900 | 45747 | 296 | Ron Paul | N00005906 | [ "H6TX22101" ] |
|||||||||
K000188 | Ron Kind | K000188 | 400218 | 29769 | Ron Kind | Q505222 | kg:/m/024ty6 | Ron | Kind | 1963-03-16 | M | 16313 | James | Ron Kind | 01498 | 45870 | 630 | Ron Kind | N00004403 | [ "H6WI03099" ] |
319 | ||||||||
J000293 | Ron Johnson | J000293 | 412496 | 41111 | Ron Johnson (Wisconsin politician) | Q970272 | kg:/m/0cmdpzc | Ron | Johnson | 1955-04-08 | M | Ron Johnson (Wisconsin) | 02086 | 62835 | 126217 | S345 | Ron Johnson | N00032546 | [ "S0WI00197" ] |
1501 | |||||||||
E000298 | Ron Estes | E000298 | 412735 | 21750 | Ron Estes | Q7363747 | kg:/m/0gfgsrm | Ron | Estes | 1956-07-19 | M | 15032448694 | Ron Estes (U.S. House representative) | 107963 | 125031 | Ron Estes | N00040712 | [ "H8KS04112" ] |
2246 | ||||||||||
D000621 | Ron DeSantis | D000621 | 412526 | 21318 | Ron DeSantis | Q3105215 | kg:/m/0l8mn35 | Ron | DeSantis | 1978-09-14 | M | Ron DeSantis | 02116 | 79744 | 137630 | Ron DeSantis | N00034746 | [ "H2FL00292" ] |
1750 | ||||||||||
B001279 | Ron Barber | B001279 | 412502 | 21199 | Ron Barber | Q2165407 | kg:/m/0k0qntf | Ron | Barber | 1945-08-25 | M | Ron Barber | 02093 | 31093 | 137292 | Ron Barber | N00033981 | [ "H2AZ08094" ] |
1683 | ||||||||||
W000816 | Roger Williams | W000816 | 412578 | 21364 | Roger Williams (American politician) | Q4014560 | kg:/m/08rszb | Roger | Williams | 1949-09-13 | M | Roger Williams | 02165 | 623742 | 50112 | Roger Williams | N00030602 | [ "H2TX33040", "S2TX00270" ] |
1802 | ||||||||||
M001198 | Roger Marshall | M001198 | 412704 | 21734 | Roger Marshall (politician) | Q27923290 | kg:/g/11c4btdtm1 | Roger | Marshall | 1960-08-09 | M | Roger Marshall | 103425 | 172080 | S411 | Roger Marshall | N00037034 | [ "H6KS01179", "S0KS00315" ] |
2216 | ||||||||||
W000437 | Roger Wicker | W000437 | 400432 | 29534 | Roger Wicker | Q390491 | kg:/m/025xxb | Roger | Wicker | 1951-07-05 | M | 23734 | F. | Roger Wicker | 01226 | 18203 | 21926 | S318 | Roger F. Wicker | N00003280 | [ "H4MS01078", "S8MS00196" ] |
517 | |||||||
F000372 | Rodney Frelinghuysen | F000372 | 400142 | 29541 | Rodney Frelinghuysen | Q338190 | kg:/m/03bktp | Rodney | Frelinghuysen | 1946-04-29 | M | 13440 | P. | 00414 | 37781 | 22177 | Rodney P. Frelinghuysen | N00000684 | [ "H2NJ05014" ] |
252 | [ { "name": "Peter Hood Ballantine Frelinghuysen Jr.", "relation": "son" }, { "name": "Frederick Frelinghuysen", "relation": "great great grandson" }, { "name": "Theodore Frelinghuysen", "relation": "great great great nephew" } ] |
||||||||
D000619 | Rodney Davis | D000619 | 412536 | 21328 | Rodney Davis (politician) | Q134035 | kg:/m/0jwttjt | Rodney | Davis | 1970-01-05 | M | Rodney Davis (Illinois) | 02126 | 68337 | 9622 | Rodney Davis | N00034784 | [ "H2IL13120" ] |
1760 | ||||||||||
A000361 | Rodney Alexander | A000361 | 400006 | 90327 | Rodney Alexander | Q504508 | kg:/m/025jxc | Rodney | Alexander | 1946-12-05 | M | 8757 | M. | Rodney Alexander | 01727 | 1004256 | 4545 | Rodney Alexander | N00025464 | [ "H2LA05084" ] |
129 | ||||||||
B001294 | Rod Blum | B001294 | 412627 | 21520 | Rod Blum | Q18684853 | kg:/m/0127p02j | Rod | Blum | 1955-04-26 | M | Rod Blum | 02241 | 623771 | 135714 | Rod Blum | N00033744 | [ "H2IA01055" ] |
2083 | ||||||||||
K000385 | Robin Kelly | K000385 | 412595 | 21371 | Robin Kelly | Q3437091 | kg:/m/0g8l32 | Robin | Kelly | 1956-04-30 | F | 15032393262 | L. | Robin Kelly | 02190 | 70399 | 33384 | Robin L. Kelly | N00035215 | [ "H2IL02172" ] |
2045 | ||||||||
S001182 | Robert Schilling | S001182 | 412423 | 21130 | Bobby Schilling | Q888662 | kg:/m/09g7mjc | Robert | Schilling | 1964-01-23 | M | 22619 | T. | Bobby | 02016 | 116570 | Robert T. Schilling | N00030668 | [ "H0IL17059" ] |
||||||||||
P000606 | Robert Pittenger | P000606 | 412551 | 21347 | Robert Pittenger | Q3956848 | kg:/m/02b5bx | Robert | Pittenger | 1948-08-15 | M | Robert Pittenger | 02141 | 9265861 | 41272 | Robert Pittenger | N00034416 | [ "H2NC09134" ] |
1775 | ||||||||||
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 | ||||||
M000639 | Robert Menendez | M000639 | 400272 | 29373 | Bob Menendez | Q888132 | kg:/m/033d3p | Robert | Menendez | 1954-01-01 | M | 18124 | Bob | Bob Menendez | [ { "last": "Menendez" } ] |
00791 | 29608 | 26961 | S306 | Robert Menendez | N00000699 | [ "H2NJ13075", "S6NJ00289" ] |
368 | ||||||
T000471 | Robert Turner | T000471 | 412499 | 21197 | Bob Turner (American politician) | Q32715 | kg:/m/0h51vzj | Robert | Turner | 1941-05-02 | M | 23220 | L. | 02091 | 127071 | Robert L. Turner | N00032601 | [ "H0NY09072" ] |
|||||||||||
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 | ||||||||
D000613 | Bob Dold | D000613 | 412420 | 21127 | Bob Dold | Q2156912 | kg:/m/0b6j_nb | Bob | Dold | 1969-06-23 | M | 12599 | Robert Dold | 02013 | 116548 | Robert J. Dold | N00031103 | [ "H0IL10302" ] |
1432 | ||||||||||
H001060 | Robert Hurt | H001060 | 412484 | 21186 | Robert Hurt (politician) | Q2157642 | kg:/m/04ygsqx | Robert | Hurt | 1969-06-16 | M | 15614 | Robert Hurt | 02069 | 623558 | 50895 | Robert Hurt | N00031265 | [ "H0VA05095" ] |
1489 | |||||||||
L000566 | Robert Latta | L000566 | 412256 | 20755 | Bob Latta | Q888061 | kg:/m/02z6_j1 | Robert | Latta | 1956-04-18 | M | 17309 | E. | Robert E. Latta | 01885 | 1028071 | 9926 | Robert E. Latta | N00012233 | [ "H8OH05036" ] |
737 | [ { "name": "Delbert L. Latta ", "relation": "son" } ] |
|||||||
A000210 | Robert Andrews | A000210 | 400008 | 29132 | Rob Andrews | Q980649 | kg:/m/032mpy | Robert | Andrews | 1957-08-04 | M | 8551 | E. | Rob | 00021 | 19670 | 26949 | Robert E. Andrews | N00000826 | [ "H0NJ01066", "S8NJ00392" ] |
131 | ||||||||
S000185 | Robert Scott | S000185 | 400364 | 39307 | Bobby Scott (politician) | Q888668 | kg:/m/03twgl | Robert | Scott | 1947-04-30 | M | 21368 | C. | Bobby | Robert C. Scott | 01037 | 25888 | 27117 | Robert C. "Bobby" Scott | N00002147 | [ "H6VA01117" ] |
455 | |||||||
A000055 | Robert Aderholt | A000055 | 400004 | 29701 | Robert Aderholt | Q672671 | kg:/m/024p03 | Robert | Aderholt | 1965-07-22 | M | 8333 | B. | Robert B. Aderholt | 01460 | 45516 | 441 | Robert B. Aderholt | N00003028 | [ "H6AL04098" ] |
127 | ||||||||
B001227 | Robert Brady | B001227 | 400047 | 29777 | Bob Brady | Q434522 | kg:/m/03tq5z | Robert | Brady | 1945-04-07 | M | 10355 | Alan | Robert A. Brady | 01469 | 55227 | 2519 | Robert A. Brady | N00001619 | [ "H8PA01153" ] |
165 |
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);