legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_ballotpedia 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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" } ] |
|||||||
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 | |||||||
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" } ] |
||||||
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 | |||||||||
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" ] |
|||||||||||||
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 | ||||||||
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 | |||||||||
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 | ||||||||||
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 | |||||||||
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 | |||||||||
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" ] |
||||||||||
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 | ||||||||
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 | |||||||
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" } ] |
|||||||
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 | ||||||||
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 | ||||||||||
C000332 | Salmon Chase | C000332 | 402473 | 1672 | Salmon P. Chase | Q433051 | kg:/m/019vz0 | Salmon | Chase | 1808-01-13 | M | Portland | Salmon Portland Chase | ||||||||||||||||
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" ] |
|||||||||||||
F000061 | Russell Feingold | F000061 | 300042 | 49309 | Russ Feingold | Q356475 | kg:/m/01nvvl | Russell | Feingold | 1953-03-02 | M | D. | Russ Feingold | 01331 | 53361 | S230 | N00000036 | [ "S8WI00026" ] |
|||||||||||
Y000067 | Rudy Yakym | Y000067 | 456873 | Rudy Yakym | Q115137719 | Rudy | Yakym | 1984-02-24 | M | Rudy Yakym | 210545 | [ "H2IN02295" ] |
|||||||||||||||||
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 | ||||||||
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" ] |
|||||||||||||
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" ] |
||||||||||||||
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" ] |
|||||||||||||
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 | ||||||||
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 | ||||||||||
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 | |||||||
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 | ||||||||||
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 | ||||||||
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 | ||||||||||
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 | ||||||||
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" } ] |
|||||||
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 | ||||||||||
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 | ||||||||
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 | ||||||
B001250 | Rob Bishop | B001250 | 400029 | 20357 | Rob Bishop | Q433857 | kg:/m/02tn41 | Rob | Bishop | 1951-07-13 | M | 10399 | Rob Bishop | 01753 | 1003621 | 50544 | Rob Bishop | N00025292 | [ "H2UT01094" ] |
150 | |||||||||
K000389 | Ro Khanna | K000389 | 412684 | 21728 | Ro Khanna | Q7339221 | kg:/m/0q3z5xy | Ro | Khanna | 1976-09-13 | M | Ro Khanna | 31129 | 29473 | Ro Khanna | N00026427 | [ "H4CA12055" ] |
2196 | |||||||||||
T000486 | Ritchie Torres | T000486 | 456838 | Ritchie Torres | Q16205227 | kg:/m/0x11h9s | Ritchie | Torres | 1988-03-12 | M | John | Ritchie Torres | Ritchie Torres | N00044346 | [ "H0NY15160" ] |
||||||||||||||
S001217 | Rick Scott | S001217 | 412838 | 41903 | Rick Scott | Q439729 | kg:/m/0btx2g | Rick | Scott | 1952-12-01 | M | Rick Scott | 124204 | S404 | Rick Scott | N00043290 | [ "S8FL00273" ] |
||||||||||||
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 | ||||||||||
N000127 | Richard Nolan | N000127 | 408211 | 14263 | Rick Nolan | Q2151594 | kg:/m/0dgfyp | Richard | Nolan | 1943-12-17 | M | 18988 | M. | Rick Nolan | 00867 | 1001760 | 138505 | Richard M. Nolan | N00021207 | [ "H2MN08111" ] |
1730 | ||||||||
L000560 | Rick Larsen | L000560 | 400232 | 20145 | Rick Larsen | Q503529 | kg:/m/025953 | Rick | Larsen | 1965-06-15 | M | 17298 | Rick Larsen | 01675 | 86610 | 56231 | Rick Larsen | N00009759 | [ "H0WA02080" ] |
333 | |||||||||
C001087 | Eric Crawford | C001087 | 412400 | 21106 | Rick Crawford (politician) | Q2151554 | kg:/m/0czb3pp | Eric | Crawford | 1966-01-22 | M | 11831 | A. | Rick | Rick Crawford | 01989 | 623259 | 119208 | Eric A. "Rick" Crawford | N00030770 | [ "H0AR01083" ] |
1414 | |||||||
A000372 | Rick Allen | A000372 | 412625 | 21516 | Rick W. Allen | Q18683976 | kg:/m/0127y9dk | Rick | Allen | 1951-11-07 | M | W. | Rick Allen | 02239 | 62545 | 136062 | Rick W. Allen | N00033720 | [ "H2GA12121" ] |
2081 | |||||||||
S000320 | Richard Shelby | S000320 | 300089 | 94659 | Richard Shelby | Q472254 | kg:/m/020yj1 | Richard | Shelby | 1934-05-06 | M | 21534 | C. | Richard Shelby | 01049 | 1859 | 53266 | S184 | Richard C. Shelby | N00009920 | [ "S6AL00013" ] |
608 | |||||||
N000015 | Richard Neal | N000015 | 400291 | 15616 | Richard Neal | Q1464697 | kg:/m/028vm4 | Richard | Neal | 1949-02-14 | M | 18855 | E. | Richard Neal | 00854 | 6103 | 26895 | Richard E. Neal | N00000153 | [ "H8MA02041" ] |
387 | ||||||||
H001067 | Richard Hudson | H001067 | 412550 | 21346 | Richard Hudson (American politician) | Q3956999 | kg:/m/0nbwfxs | Richard | Hudson | 1971-11-04 | M | Richard Hudson | 02140 | 79622 | 136448 | Richard Hudson | N00033630 | [ "H2NC08185" ] |
1774 | [ { "title": "House Republican Conference Secretary", "chamber": "house", "start": "2021-01-03" } ] |
|||||||||
B001135 | Richard Burr | B001135 | 400054 | 29548 | Richard Burr | Q331278 | kg:/m/03g_s9 | Richard | Burr | 1955-11-30 | M | 10236 | M. | Richard Burr | 00153 | 31054 | 21787 | S300 | Richard Burr | N00002221 | [ "S4NC00089", "H2NC05074" ] |
172 | |||||||
B001277 | Richard Blumenthal | B001277 | 412490 | 41101 | Richard Blumenthal | Q2023708 | kg:/m/03tg8m | Richard | Blumenthal | 1946-02-13 | M | Richard Blumenthal | 02076 | 21799 | 1568 | S341 | Richard Blumenthal | N00031685 | [ "S0CT00177" ] |
1495 | |||||||||
E000291 | Renee Ellmers | E000291 | 412457 | 21159 | Renee Ellmers | Q515971 | kg:/m/0dsdyjp | Renee | Ellmers | 1964-02-09 | F | 12963 | L. | Renee Ellmers | 02036 | 1033793 | 120897 | Renee L. Ellmers | N00031513 | [ "H0NC02059" ] |
1464 | ||||||||
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 | ||||||||
R000599 | Raul Ruiz | R000599 | 412519 | 21311 | Raul Ruiz (politician) | Q3701994 | kg:/m/02p8pz0 | Raul | Ruiz | 1972-08-25 | M | Raul Ruiz | 02109 | 79727 | 136407 | Raul Ruiz | N00033510 | [ "H2CA36439" ] |
1743 | ||||||||||
G000551 | Raúl Grijalva | G000551 | 400162 | 20305 | Raúl Grijalva | Q946606 | kg:/m/024s1z | Raúl | Grijalva | 1948-02-19 | M | 14261 | M. | Raul M. Grijalva | 01708 | 1003551 | 28253 | Raúl M. Grijalva | N00025284 | [ "H2AZ07070" ] |
268 | ||||||||
L000573 | Raúl Labrador | L000573 | 412419 | 21125 | Raúl Labrador | Q555393 | kg:/m/0c3zfwm | Raúl | Labrador | 1967-12-08 | M | 17322 | R. | Raul Labrador | 02011 | 94987 | 57391 | Raúl R. Labrador | N00031377 | [ "H0ID01253" ] |
1431 | ||||||||
T000481 | Rashida Tlaib | T000481 | 412787 | 21975 | Rashida Tlaib | Q7294939 | kg:/m/059_x6c | Rashida | Tlaib | 1976-07-24 | F | Rashida Tlaib | 105368 | Rashida Tlaib | N00042649 | [ "H8MI13250" ] |
|||||||||||||
W000790 | Raphael Warnock | W000790 | 456858 | Raphael Warnock | Q84146599 | Raphael | Warnock | 1969-07-23 | M | Gamaliel | Raphael Warnock | S415 | Raphael G. Warnock | N00046489 | [ "S0GA00559" ] |
||||||||||||||
W000814 | Randy Weber | W000814 | 412574 | 21360 | Randy Weber | Q4014569 | kg:/m/0km63t0 | Randy | Weber | 1953-07-02 | M | K. | Randy Weber | Sr. | 02161 | 79698 | 102026 | Randy K. Weber, Sr. | N00033539 | [ "H2TX14149" ] |
1798 | ||||||||
N000182 | Randy Neugebauer | N000182 | 400441 | 20353 | Randy Neugebauer | Q539536 | kg:/m/03tn5k | Randy | Neugebauer | 1949-12-24 | M | 19060 | Randy Neugebauer | 01758 | 1010920 | 49522 | Randy Neugebauer | N00026043 | [ "H4TX19102" ] |
526 | |||||||||
H001059 | Randy Hultgren | H001059 | 412422 | 21129 | Randy Hultgren | Q556404 | kg:/m/0h0lr9 | Randy | Hultgren | 1966-03-01 | M | 15612 | Randy Hultgren | 02015 | 62575 | 18199 | Randy Hultgren | N00031104 | [ "H0IL14080" ] |
1434 | |||||||||
F000445 | J. Forbes | F000445 | 400137 | 20143 | Randy Forbes | Q2130783 | kg:/m/026gv8q | J. | Forbes | 1952-02-17 | M | 13539 | Randy | Randy Forbes | 01683 | 89584 | 5146 | J. Randy Forbes | N00013799 | [ "H2VA04052" ] |
247 | ||||||||
F000446 | Randy Feenstra | F000446 | 456818 | Randy Feenstra | Q7292187 | kg:/m/05p06tx | Randy | Feenstra | 1969-01-14 | M | L. | Randy Feenstra | 103301 | Randy Feenstra | N00044011 | [ "H0IA04145" ] |
|||||||||||||
P000603 | Rand Paul | P000603 | 412492 | 41104 | Rand Paul | Q463557 | kg:/m/05pdb7q | Rand | Paul | 1963-01-07 | M | Rand Paul | 02082 | 9265241 | 117285 | S348 | Rand Paul | N00030836 | [ "S0KY00156" ] |
1497 | [ { "name": "Ronald Ernest Paul", "relation": "son" } ] |
||||||||
N000190 | Ralph Norman | N000190 | 412738 | 21753 | Ralph Norman | Q7287914 | kg:/m/0f9kbx | Ralph | Norman | 1953-06-20 | M | 15032448994 | Ralph Norman | 61996 | 47930 | Ralph Norman | N00027783 | [ "H8SC05158" ] |
2248 | ||||||||||
H000067 | Ralph Hall | H000067 | 400165 | 14828 | Ralph Hall | Q966332 | kg:/m/026cww | Ralph | Hall | 1923-05-03 | M | 14371 | M. | Ralph Hall | 00484 | 7354 | 27080 | Ralph M. Hall | N00005645 | [ "H0TX04037" ] |
271 | ||||||||
A000374 | Ralph Abraham | A000374 | 412630 | 21522 | Ralph Abraham (politician) | Q18683775 | kg:/m/012dwd7_ | Ralph | Abraham | 1954-09-16 | M | Ralph Abraham | 02244 | 76236 | 155414 | Ralph Lee Abraham | N00036633 | [ "H4LA05221" ] |
2086 | ||||||||||
K000391 | Raja Krishnamoorthi | K000391 | 412701 | 21730 | Raja Krishnamoorthi | Q7285471 | kg:/m/064p225 | Raja | Krishnamoorthi | 1973-07-19 | M | Raja Krishnamoorthi | 103408 | 117519 | Raja Krishnamoorthi | N00033240 | [ "H6IL08147" ] |
2213 | |||||||||||
J000298 | Pramila Jayapal | J000298 | 412730 | 21726 | Pramila Jayapal | Q18978140 | kg:/m/0c3dxcq | Pramila | Jayapal | 1965-09-21 | F | Pramila Jayapal | 9267128 | 153141 | Pramila Jayapal | N00038858 | [ "H6WA07458" ] |
2242 | |||||||||||
R000582 | David Roe | R000582 | 412310 | 20947 | Phil Roe (politician) | Q1665842 | kg:/m/04gtg5_ | David | Roe | 1945-07-21 | M | 20807 | P. | Phil | Phil Roe | 01954 | 1031360 | 65306 | David P. Roe | N00028463 | [ "H6TN01388" ] |
792 | |||||||
W000800 | Peter Welch | W000800 | 412239 | 20750 | Peter Welch | Q1112656 | kg:/m/0db4gl | Peter | Welch | 1947-05-02 | M | 24183 | Peter Welch | 01879 | 1019990 | 51272 | Peter Welch | N00000515 | [ "H6VT00160", "H8VT00034" ] |
722 | |||||||||
K000210 | Peter King | K000210 | 400219 | 29375 | Peter T. King | Q953554 | kg:/m/03tk4w | Peter | King | 1944-04-05 | M | 16338 | T. | Pete | Peter T. King | 00635 | 26487 | 26968 | Peter T. King | N00001193 | [ "H2NY03089" ] |
321 | |||||||
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 | ||||||||
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 | ||||||||
D000191 | Peter DeFazio | D000191 | 400100 | 15410 | Peter DeFazio | Q1758507 | kg:/m/033ttx | Peter | DeFazio | 1947-05-27 | M | 12068 | A. | Peter DeFazio | 00279 | 6068 | 27037 | Peter A. DeFazio | N00007781 | [ "H6OR04047", "S6OR00151" ] |
213 | ||||||||
B001226 | Peter Barca | B001226 | 401134 | 39314 | Peter W. Barca | Q2078827 | kg:/m/076pq2 | Peter | Barca | 1955-08-07 | M | 10353 | William | Peter Barca | 00051 | 27134 | |||||||||||||
S001212 | Pete Stauber | S001212 | 412792 | 21969 | Pete Stauber | Q55955746 | kg:/g/11gjy6v3nv | Pete | Stauber | 1966-05-10 | M | Pete Stauber | 159954 | Pete Stauber | N00041511 | [ "H8MN08043" ] |
|||||||||||||
S000250 | Pete Sessions | S000250 | 400367 | 29759 | Pete Sessions | Q437852 | kg:/m/03v39l | Pete | Sessions | 1955-03-22 | M | 21446 | A. | Pete Sessions | 01525 | 36807 | 288 | Pete Sessions | N00005681 | [ "H2TX03126" ] |
458 | ||||||||
O000168 | Pete Olson | O000168 | 412302 | 20948 | Pete Olson | Q2073303 | kg:/m/0407vf_ | Pete | Olson | 1962-12-09 | M | 19278 | Pete Olson | 01955 | 1031361 | 102008 | Pete Olson | N00029285 | [ "H8TX22107" ] |
784 | |||||||||
G000572 | Pete Gallego | G000572 | 412577 | 21363 | Pete Gallego | Q4014524 | kg:/m/03qfqy8 | Pete | Gallego | 1961-12-02 | M | P. | Pete Gallego | 02164 | 79696 | 5505 | Pete P. Gallego | N00033541 | [ "H2TX23124" ] |
1801 | |||||||||
A000371 | Pete Aguilar | A000371 | 412615 | 21506 | Pete Aguilar | Q7171821 | kg:/m/0jwv0xf | Pete | Aguilar | 1979-06-19 | M | Pete Aguilar | 02229 | 79994 | 70114 | Pete Aguilar | N00033997 | [ "H2CA31125" ] |
2071 | [ { "title": "House Democratic Caucus Vice Chair", "chamber": "house", "start": "2021-01-03" } ] |
|||||||||
T000469 | Paul Tonko | T000469 | 412319 | 20934 | Paul Tonko | Q1373548 | kg:/m/0gzy4c | Paul | Tonko | 1949-06-18 | M | 23217 | Paul Tonko | 01942 | 1031353 | 4403 | Paul Tonko | N00030196 | [ "H8NY21203" ] |
801 |
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);