legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_lis descending
This data as json, copyable, CSV (advanced)
Suggested facets: bio_birthday (date), id_bioguide_previous (array), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
W000790 | Raphael Warnock | W000790 | 456858 | Raphael Warnock | Q84146599 | Raphael | Warnock | 1969-07-23 | M | Gamaliel | Raphael Warnock | S415 | Raphael G. Warnock | N00046489 | [ "S0GA00559" ] |
||||||||||||||
O000174 | Jon Ossoff | O000174 | 456857 | Jon Ossoff | Q28839536 | Jon | Ossoff | 1987-02-16 | M | Jon Ossoff | S414 | Jon Ossoff | N00040675 | [ "H8GA06195", "S8GA00180" ] |
|||||||||||||||
P000145 | Alejandro Padilla | P000145 | 456856 | Alex Padilla | Q4717593 | Alejandro | Padilla | 1973-03-22 | M | Alex | Alex Padilla | S413 | Alex Padilla | N00047888 | [ "S2CA00955" ] |
||||||||||||||
T000278 | Tommy Tuberville | T000278 | 456796 | Tommy Tuberville | Q7819948 | kg:/m/04tmr4 | Tommy | Tuberville | 1954-09-18 | M | Hawley | Tommy Tuberville | 188306 | S412 | Tommy Tuberville | N00044434 | [ "S0AL00230" ] |
||||||||||||
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 | ||||||||||
L000571 | Cynthia Lummis | L000571 | 412294 | 20953 | Cynthia Lummis | Q456064 | kg:/m/02qvjv3 | Cynthia | Lummis | 1954-09-10 | F | 17319 | M. | Cynthia Lummis | 01960 | 1031365 | 15546 | S410 | Cynthia M. Lummis | N00029788 | [ "H8WY00148", "S0WY00137" ] |
776 | |||||||
L000570 | Ben Luján | L000570 | 412293 | 20932 | Ben Ray Luján | Q324256 | kg:/m/0412qzq | Ben | Luján | 1972-06-07 | M | 17317 | Ray | Ben Ray Luján | 01939 | 1031351 | 102842 | S409 | Ben Ray Luján | N00029562 | [ "H8NM03196", "S0NM00058" ] |
775 | [ { "title": "Assistant Speaker of the House", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" } ] |
||||||
H000273 | John Hickenlooper | H000273 | 456797 | John Hickenlooper | Q430518 | kg:/m/04g_1z | John | Hickenlooper | 1952-02-07 | M | Wright | John Hickenlooper | S408 | John W. Hickenlooper | N00044206 | [ "S0CO00575" ] |
|||||||||||||
H000601 | Bill Hagerty | H000601 | 456798 | Bill Hagerty (politician) | Q27734214 | kg:/g/11c1xp6h9v | Bill | Hagerty | 1959-08-14 | M | Francis | Bill Hagerty | 128466 | S407 | Bill Hagerty | N00045369 | [ "S0TN00169" ] |
||||||||||||
K000377 | Mark Kelly | K000377 | 456794 | Mark Kelly | Q357510 | Mark | Kelly | 1964-02-21 | M | Mark Kelly | S406 | Mark Kelly | N00044223 | [ "S0AZ00350" ] |
|||||||||||||||
L000594 | Kelly Loeffler | L000594 | 456790 | Kelly Loeffler | Q76570207 | kg:/g/11j3kgpjlx | Kelly | Loeffler | 1970-11-27 | F | Kelly Loeffler | 188718 | S405 | Kelly Loeffler | N00046125 | [ "S0GA00526" ] |
|||||||||||||
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" ] |
||||||||||||
S001191 | Kyrsten Sinema | S001191 | 412509 | 21300 | Kyrsten Sinema | Q1556541 | kg:/m/03qnndb | Kyrsten | Sinema | 1976-07-12 | F | 15032387755 | Kyrsten Sinema | 02099 | 68489 | 28338 | S403 | Kyrsten Sinema | N00033983 | [ "H2AZ09019", "S8AZ00197" ] |
1733 | ||||||||
R000608 | Jacky Rosen | R000608 | 412715 | 21743 | Jacky Rosen | Q27825033 | kg:/g/11cntnvwkg | Jacky | Rosen | 1957-08-02 | F | 104738 | 169471 | S402 | Jacky Rosen | N00038734 | [ "H6NV03139", "S8NV00156" ] |
2227 | |||||||||||
R000615 | Mitt Romney | R000615 | 412841 | 41902 | Mitt Romney | Q4496 | kg:/m/0271_s | Mitt | Romney | 1947-03-12 | M | Mitt Romney | 21942 | S401 | Mitt Romney | N00000286 | [ "S8UT00176", "S4MA00143" ] |
||||||||||||
M001197 | Martha McSally | M001197 | 412611 | 21501 | Martha McSally | Q6774492 | kg:/m/027fybv | Martha | McSally | 1966-03-22 | F | 15032414876 | Martha McSally | 02225 | 29126 | 137299 | S400 | Martha McSally | N00033982 | [ "S8AZ00221", "H2AZ08102" ] |
2067 | ||||||||
H001089 | Joshua Hawley | H001089 | 412840 | 41901 | Josh Hawley | Q23020745 | kg:/g/11bwy_95zy | Joshua | Hawley | 1979-12-31 | M | Josh | Josh Hawley | 169716 | S399 | Josh Hawley | N00041620 | [ "S8MO00160" ] |
|||||||||||
C001096 | Kevin Cramer | C001096 | 412555 | 21350 | Kevin Cramer | Q3957020 | kg:/m/02rhrnw | Kevin | Cramer | 1961-01-21 | M | Kevin Cramer | 02144 | 7600 | 444 | S398 | Kevin Cramer | N00004614 | [ "H0ND01026", "H6ND00074", "S8ND00120" ] |
1779 | |||||||||
B001310 | Mike Braun | B001310 | 412839 | 41900 | Mike Braun | Q42804470 | kg:/g/11f2ckdwty | Mike | Braun | 1954-03-24 | M | Mike Braun | 148564 | S397 | Mike Braun | N00041731 | [ "S8IN00171" ] |
||||||||||||
B001243 | Marsha Blackburn | B001243 | 400032 | 20351 | Marsha Blackburn | Q458971 | kg:/m/01fnkt | Marsha | Blackburn | 1952-06-06 | F | 10385 | W. | Marsha Blackburn | 01748 | 31226 | 25186 | S396 | Marsha Blackburn | N00003105 | [ "H2TN06030", "S8TN00337" ] |
151 | |||||||
H001079 | Cindy Hyde-Smith | H001079 | 412743 | 41707 | Cindy Hyde-Smith | Q5120540 | kg:/m/03wc2px | Cindy | Hyde-Smith | 1959-05-10 | F | Cindy Hyde-Smith | 113208 | 20784 | S395 | Cindy Hyde-Smith | N00043298 | [ "S8MS00261" ] |
|||||||||||
S001203 | Tina Smith | S001203 | 412742 | 41706 | Tina Smith | Q18631509 | kg:/m/0127xvy3 | Tina | Smith | 1958-03-04 | F | Flint | Tina Smith | 111313 | 152968 | S394 | Tina Smith | N00042353 | [ "S8MN00578" ] |
2253 | |||||||||
J000300 | Doug Jones | J000300 | 412741 | 41705 | Doug Jones (politician) | Q30122825 | kg:/g/11dyzdzg1j | Doug | Jones | 1954-05-04 | M | Doug Jones (Alabama) | 1024592 | 176464 | S393 | Doug Jones | N00024817 | [ "S0AL00156" ] |
2252 | ||||||||||
S001202 | Luther Strange | S001202 | 412734 | 41704 | Luther Strange | Q6705642 | kg:/m/06w5pjw | Luther | Strange | 1953-03-01 | M | Luther Strange | 9278255 | 121424 | S392 | Luther Strange | N00040607 | [ "S8AL00308" ] |
2245 | ||||||||||
Y000064 | Todd Young | Y000064 | 412428 | 21133 | Todd Young | Q25483 | kg:/m/0ds030m | Todd | Young | 1972-08-24 | M | 21109 | C. | Todd Young | 02019 | 1033743 | 120345 | S391 | Todd Young | N00030670 | [ "H0IN09070", "S6IN00191" ] |
1439 | |||||||
V000128 | Chris Van Hollen | V000128 | 400415 | 20330 | Chris Van Hollen | Q1077819 | kg:/m/025kb5 | Chris | Van Hollen | 1959-01-10 | M | 21032 | Chris Van Hollen | 01729 | 20756 | 6098 | S390 | Chris Van Hollen | N00013820 | [ "H2MD08126", "S6MD03441" ] |
500 | ||||||||
K000393 | John Kennedy | K000393 | 412679 | 41703 | John Kennedy (Louisiana politician) | Q6250211 | kg:/m/0fl2sv | John | Kennedy | 1951-11-21 | M | Neely | John Neely Kennedy | 1011723 | 35496 | S389 | John Kennedy | N00026823 | [ "S4LA00065" ] |
2191 | |||||||||
H001076 | Margaret Hassan | H001076 | 412680 | 41702 | Maggie Hassan | Q24053 | kg:/m/03c3zch | Margaret | Hassan | 1958-02-27 | F | Wood | Maggie | Maggie Hassan | 67481 | 42552 | S388 | Margaret Wood Hassan | N00038397 | [ "S6NH00091" ] |
2192 | ||||||||
H001075 | Kamala Harris | H001075 | 412678 | 41701 | Kamala Harris | Q10853588 | kg:/m/08sry2 | Kamala | Harris | 1964-10-20 | F | Kamala Harris | 1018696 | 120012 | S387 | Kamala D. Harris | N00036915 | [ "S6CA00584" ] |
2190 | ||||||||||
D000622 | Tammy Duckworth | D000622 | 412533 | 21325 | Tammy Duckworth | Q3036410 | kg:/m/09vqjr | Tammy | Duckworth | 1968-03-12 | F | 15032387037 | Tammy Duckworth | 02123 | 94484 | 57442 | S386 | Tammy Duckworth | N00027860 | [ "H6IL06141", "S6IL00292" ] |
1757 | ||||||||
C001113 | Catherine Cortez Masto | C001113 | 412681 | 41700 | Catherine Cortez Masto | Q5052604 | kg:/m/02rtp9t | Catherine | Cortez Masto | 1964-03-29 | F | Catherine Cortez Masto | 105698 | 69579 | S385 | Catherine Cortez Masto | N00037161 | [ "S6NV00200" ] |
2193 | ||||||||||
T000476 | Thom Tillis | T000476 | 412668 | 41504 | Thom Tillis | Q7786750 | kg:/m/0fq0395 | Thom | Tillis | 1960-08-30 | M | Thom Tillis (North Carolina) | 02291 | 77055 | 57717 | S384 | Thom Tillis | N00035492 | [ "S4NC00162" ] |
2124 | |||||||||
S001198 | Dan Sullivan | S001198 | 412665 | 41500 | Dan Sullivan (U.S. senator) | Q5218668 | kg:/m/07s4r4q | Dan | Sullivan | 1964-11-13 | M | Daniel S. Sullivan | 02290 | 1023262 | 114964 | S383 | Dan Sullivan | N00035774 | [ "S4AK00214" ] |
2121 | |||||||||
S001197 | Benjamin Sasse | S001197 | 412671 | 41503 | Ben Sasse | Q16192221 | kg:/m/0j5wk_6 | Benjamin | Sasse | 1972-02-22 | M | Eric | Ben | Ben Sasse | 02289 | 77429 | 150182 | S382 | Ben Sasse | N00035544 | [ "S4NE00090" ] |
2127 | |||||||
R000605 | Mike Rounds | R000605 | 412669 | 41505 | Mike Rounds | Q722503 | kg:/m/020z2p | Mike | Rounds | 1954-10-24 | M | Mike Rounds | 02288 | 78317 | 7455 | S381 | Mike Rounds | N00035187 | [ "S4SD00049" ] |
2125 | |||||||||
P000595 | Gary Peters | P000595 | 412305 | 20923 | Gary Peters | Q1494930 | kg:/m/02x0lnt | Gary | Peters | 1958-12-01 | M | 20028 | C. | Gary Peters | 01929 | 50199 | 8749 | S380 | Gary C. Peters | N00029277 | [ "H8MI09068", "S4MI00355" ] |
787 | |||||||
P000612 | David Perdue | P000612 | 412666 | 41501 | David Perdue | Q17402717 | kg:/m/03wp8v4 | David | Perdue | 1949-12-10 | M | David Perdue | 02286 | 75920 | 151330 | S379 | David Perdue | N00035516 | [ "S4GA11285" ] |
2122 | |||||||||
L000575 | James Lankford | L000575 | 412464 | 21166 | James Lankford | Q45940 | kg:/m/0dgrrx6 | James | Lankford | 1968-03-04 | M | 17326 | James Lankford | 02050 | 1033847 | 124938 | S378 | James Lankford | N00031129 | [ "H0OK05114", "S4OK00232" ] |
1470 | ||||||||
G000562 | Cory Gardner | G000562 | 412406 | 21112 | Cory Gardner | Q1135774 | kg:/m/0czd33q | Cory | Gardner | 1974-08-22 | M | 14279 | Cory Gardner | 01998 | 623308 | 30004 | S377 | Cory Gardner | N00030780 | [ "H0CO04122", "S4CO00395" ] |
1418 | ||||||||
E000295 | Joni Ernst | E000295 | 412667 | 41502 | Joni Ernst | Q13475242 | kg:/m/0gg4wkg | Joni | Ernst | 1970-07-01 | F | 15032414877 | Joni Ernst | 02283 | 75342 | 128583 | S376 | Joni Ernst | N00035483 | [ "S4IA00129" ] |
2123 | [ { "title": "Senate Republican Conference Vice Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Republican Conference Vice Chair", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
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 | |||||||||
C001095 | Tom Cotton | C001095 | 412508 | 21301 | Tom Cotton | Q3090307 | kg:/m/02g3ds | Tom | Cotton | 1977-05-13 | M | Tom Cotton | 02098 | 63928 | 135651 | S374 | Tom Cotton | N00033363 | [ "H2AR04083", "S4AR00103" ] |
1732 | |||||||||
C001075 | Bill Cassidy | C001075 | 412269 | 20919 | Bill Cassidy | Q861999 | kg:/m/0286t7r | Bill | Cassidy | 1957-09-28 | M | 11811 | Bill Cassidy | 01925 | 1030546 | 69494 | S373 | Bill Cassidy | N00030245 | [ "H8LA00017", "S4LA00107" ] |
751 | ||||||||
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" } ] |
||||||
W000818 | John Walsh | W000818 | 412602 | John Walsh (Montana politician) | Q6262874 | kg:/m/0nbx8tv | John | Walsh | 1960-11-03 | M | E. | 02198 | 73846 | 111027 | S371 | John E. Walsh | N00035686 | [ "S4MT00118" ] |
2055 | ||||||||||
B001288 | Cory Booker | B001288 | 412598 | 41308 | Cory Booker | Q1135767 | kg:/m/06p430 | Cory | Booker | 1969-04-27 | M | Anthony | Cory Booker | 02194 | 84679 | 76151 | S370 | Cory A. Booker | N00035267 | [ "S4NJ00185" ] |
2051 | ||||||||
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 | ||||||
C001100 | Jeffrey Chiesa | C001100 | 412597 | Jeffrey Chiesa | Q13420124 | kg:/m/0j266jc | Jeffrey | Chiesa | 1965-06-22 | M | Scott | Jeff Chiesa | 02192 | 64996 | 144672 | S368 | Jeff Chiesa | 2048 | |||||||||||
C001099 | William Cowan | C001099 | 412586 | Mo Cowan | Q3915426 | kg:/m/0qftmjh | William | Cowan | 1969-04-04 | M | Mo | Mo Cowan | 02189 | 69395 | 144307 | S367 | William M. Cowan | N99999896 | 2044 | ||||||||||
W000817 | Elizabeth Warren | W000817 | 412542 | 41301 | Elizabeth Warren | Q434706 | kg:/m/01qh39 | Elizabeth | Warren | 1949-06-22 | F | 15032390639 | Elizabeth Warren | 02182 | 1023023 | 141272 | S366 | Elizabeth Warren | N00033492 | [ "S2MA00170" ] |
1766 | ||||||||
S001184 | Tim Scott | S001184 | 412471 | 21173 | Tim Scott | Q561315 | kg:/m/0c407g6 | Tim | Scott | 1965-09-19 | M | 22623 | Tim Scott | 02056 | 623506 | 11940 | S365 | Tim Scott | N00031782 | [ "H0SC01279", "S4SC00240" ] |
1476 | ||||||||
M001169 | Christopher Murphy | M001169 | 412194 | 20707 | Chris Murphy | Q1077594 | kg:/m/0cy_dh | Christopher | Murphy | 1973-08-03 | M | 18809 | S. | Christopher S. Murphy | 01837 | 1021270 | 17189 | S364 | Christopher Murphy | N00027566 | [ "H6CT05124", "S2CT00132" ] |
681 | |||||||
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 | |||||||
K000384 | Timothy Kaine | K000384 | 412582 | 41305 | Tim Kaine | Q359888 | kg:/m/053f8h | Timothy | Kaine | 1958-02-26 | M | Tim | Tim Kaine | 02176 | 49219 | 50772 | S362 | Tim Kaine | N00033177 | [ "S2VA00142" ] |
1806 | ||||||||
H001042 | Mazie Hirono | H001042 | 412200 | 20713 | Mazie Hirono | Q16476 | kg:/m/0357cd | Mazie | Hirono | 1947-11-03 | F | 15580 | K. | Mazie K. Hirono | 01844 | 91216 | 1677 | S361 | Mazie K. Hirono | N00028139 | [ "H6HI02251", "S2HI00106" ] |
687 | |||||||
H001069 | Heidi Heitkamp | H001069 | 412554 | 41303 | Heidi Heitkamp | Q50597 | kg:/m/02f501 | Heidi | Heitkamp | 1955-10-30 | F | 15032390641 | Heidi Heitkamp | 02174 | 95414 | 41716 | S360 | Heidi Heitkamp | N00033782 | [ "S2ND00099" ] |
1778 | ||||||||
H001046 | Martin Heinrich | H001046 | 412281 | 20930 | Martin Heinrich | Q565374 | kg:/m/02qkv0r | Martin | Heinrich | 1971-10-17 | M | 15588 | Martin Heinrich | 01937 | 1030686 | 74517 | S359 | Martin Heinrich | N00029835 | [ "H8NM01224", "S2NM00088" ] |
763 | ||||||||
F000444 | Jeff Flake | F000444 | 400134 | 20100 | Jeff Flake | Q929581 | kg:/m/024p7j | Jeff | Flake | 1962-12-31 | M | 13537 | Jeff Flake | 01633 | 87582 | 28128 | S358 | Jeff Flake | N00009573 | [ "H0AZ01184", "S2AZ00141" ] |
245 | ||||||||
F000463 | Deb Fischer | F000463 | 412556 | 41302 | Deb Fischer | Q2580649 | kg:/m/0c4cp0 | Deb | Fischer | 1951-03-01 | F | 15032390640 | Deb Fischer | 02179 | 1034067 | 41963 | S357 | Deb Fischer | N00033443 | [ "S2NE00094" ] |
1780 | ||||||||
D000607 | Joe Donnelly | D000607 | 412205 | 20717 | Joe Donnelly | Q1691395 | kg:/m/0gmx64 | Joe | Donnelly | 1955-09-28 | M | 12588 | Joe Donnelly | 01850 | 1012000 | 34212 | S356 | Joe Donnelly | N00026586 | [ "H4IN02101", "S2IN00091" ] |
691 | ||||||||
C001098 | Ted Cruz | C001098 | 412573 | 41304 | Ted Cruz | Q2036942 | kg:/m/07j6ty | Ted | Cruz | 1970-12-22 | M | Ted Cruz | 02175 | 1019953 | 135705 | S355 | Ted Cruz | N00033085 | [ "S2TX00312" ] |
1797 | |||||||||
B001230 | Tammy Baldwin | B001230 | 400013 | 29940 | Tammy Baldwin | Q40628 | kg:/m/024v02 | Tammy | Baldwin | 1962-02-11 | F | 10361 | Tammy Baldwin | 01558 | 57884 | 3470 | S354 | Tammy Baldwin | N00004367 | [ "H8WI00018", "S2WI00219" ] |
136 | [ { "title": "Senate Democratic Caucus Secretary", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
S001194 | Brian Schatz | S001194 | 412507 | 41112 | Brian Schatz | Q1827902 | kg:/m/0dd109 | Brian | Schatz | 1972-10-20 | M | Emanuel | Brian E. Schatz | 02173 | 87784 | 17852 | S353 | Brian Schatz | N00028138 | [ "S4HI00136", "H6HI02244" ] |
1728 | ||||||||
H001041 | Dean Heller | H001041 | 412218 | 20730 | Dean Heller | Q251763 | kg:/m/0g92xz | Dean | Heller | 1960-05-10 | M | 15578 | Dean Heller | 01863 | 1012368 | 2291 | S352 | Dean Heller | N00027522 | [ "H6NV02164", "S2NV00183" ] |
703 | ||||||||
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 | ||||||
R000595 | Marco Rubio | R000595 | 412491 | 41102 | Marco Rubio | Q324546 | kg:/m/0dpr5f | Marco | Rubio | 1971-05-28 | M | Marco Rubio | 02084 | 87599 | 1601 | S350 | Marco Rubio | N00030612 | [ "S0FL00338" ] |
1496 | |||||||||
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 | ||||||
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" } ] |
||||||||
M000934 | Jerry Moran | M000934 | 400284 | 29722 | Jerry Moran | Q1365787 | kg:/m/024s8t | Jerry | Moran | 1954-05-29 | M | 18505 | Jerry Moran | 01507 | 45469 | 542 | S347 | Jerry Moran | N00005282 | [ "H6KS01096", "S0KS00091" ] |
379 | ||||||||
L000577 | Mike Lee | L000577 | 412495 | 41110 | Mike Lee (American politician) | Q627098 | kg:/m/09v5q9x | Mike | Lee | 1971-06-04 | M | Mike Lee | 02080 | 9267977 | 66395 | S346 | Mike Lee | N00031696 | [ "S0UT00165" ] |
1500 | |||||||||
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 | |||||||||
H001061 | John Hoeven | H001061 | 412494 | 41107 | John Hoeven | Q374762 | kg:/m/01qb45 | John | Hoeven | 1957-03-13 | M | John Hoeven | 02079 | 85233 | 41788 | S344 | John Hoeven | N00031688 | [ "S0ND00093" ] |
1499 | |||||||||
B001236 | John Boozman | B001236 | 400040 | 20101 | John Boozman | Q1344707 | kg:/m/024s3v | John | Boozman | 1950-12-10 | M | 10372 | John Boozman | 01687 | 92069 | 27958 | S343 | John Boozman | N00013873 | [ "H2AR03176", "S0AR00150" ] |
159 | ||||||||
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" } ] |
|||||||
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 | |||||||||
A000368 | Kelly Ayotte | A000368 | 412493 | 41106 | Kelly Ayotte | Q22354 | kg:/m/0g9g4r | Kelly | Ayotte | 1968-06-27 | F | 8771 | Kelly A. Ayotte | 02075 | 95241 | 42352 | S340 | Kelly Ayotte | N00030980 | [ "S0NH00235" ] |
1498 | ||||||||
K000360 | Mark Kirk | K000360 | 400222 | 20115 | Mark Kirk | Q339046 | kg:/m/0256rr | Mark | Kirk | 1959-09-15 | M | 16544 | Steven | Mark Kirk | 01647 | 85221 | 33502 | S339 | Mark Kirk | N00012539 | [ "H0IL10120", "S0IL00261" ] |
323 | |||||||
M001183 | Joe Manchin | M001183 | 412391 | 40915 | Joe Manchin | Q538868 | kg:/m/04lc5t | Joe | Manchin | 1947-08-24 | M | Joe Manchin III | III | 01983 | 62864 | 7547 | S338 | Joe Manchin, III | N00032838 | [ "S0WV00090" ] |
1372 | ||||||||
C001088 | Christopher Coons | C001088 | 412390 | 40916 | Chris Coons | Q923242 | kg:/m/082d3d | Christopher | Coons | 1963-09-09 | M | Andrew | Chris Coons | 01984 | 9269028 | 122834 | S337 | Christopher A. Coons | N00031820 | [ "S0DE00092" ] |
1371 | ||||||||
G000561 | Carte Goodwin | G000561 | 412389 | 40914 | Carte Goodwin | Q1045798 | kg:/m/0cm9_gz | Carte | Goodwin | 1974-02-27 | M | P. | 01980 | 9266706 | 126202 | S336 | N00032762 | ||||||||||||
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" ] |
||||||||||
K000374 | Paul Kirk | K000374 | 412381 | 40912 | Paul G. Kirk | Q1363487 | kg:/m/0896g7 | Paul | Kirk | 1938-01-18 | M | G. | Jr. | 01972 | 116298 | S334 | N00031303 | ||||||||||||
L000572 | George LeMieux | L000572 | 412380 | 40911 | George LeMieux | Q978350 | kg:/m/04m_msl | George | LeMieux | 1969-05-21 | M | S. | 01971 | 46456 | 17431 | S333 | N00031304 | [ "S2FL00227" ] |
|||||||||||
F000457 | Alan Franken | F000457 | 412378 | 40904 | Al Franken | Q319084 | kg:/m/01lct6 | Alan | Franken | 1951-05-21 | M | Stuart | Al | Al Franken | 01969 | 23334 | 108924 | S332 | Al Franken | N00029016 | [ "S8MN00438" ] |
1189 | |||||||
G000555 | Kirsten Gillibrand | G000555 | 412223 | 20735 | Kirsten Gillibrand | Q22222 | kg:/m/0gnfc4 | Kirsten | Gillibrand | 1966-12-09 | F | 14269 | E. | Kirsten Gillibrand | 01866 | 1022862 | 65147 | S331 | Kirsten E. Gillibrand | N00027658 | [ "H6NY20167", "S0NY00410" ] |
708 | |||||||
B001267 | Michael Bennet | B001267 | 412330 | 40910 | Michael Bennet | Q554792 | kg:/m/05b60qf | Michael | Bennet | 1964-11-28 | M | F. | Michael Bennet | 01965 | 1031622 | 110942 | S330 | Michael F. Bennet | N00030608 | [ "S0CO00211" ] |
1092 | ||||||||
K000373 | Edward Kaufman | K000373 | 412329 | 40901 | Ted Kaufman | Q665919 | kg:/m/04y9vtn | Edward | Kaufman | 1939-03-15 | M | E. | 01964 | 1030984 | 110918 | S329 | N00030767 | ||||||||||||
B001266 | Roland Burris | B001266 | 412328 | 40903 | Roland Burris | Q609172 | kg:/m/09sztf | Roland | Burris | 1937-08-03 | M | 10429 | 01963 | 2462 | 18168 | S328 | N00015389 | [ "S4IL00057" ] |
|||||||||||
W000805 | Mark Warner | W000805 | 412321 | 40909 | Mark Warner | Q453893 | kg:/m/024mm1 | Mark | Warner | 1954-12-15 | M | R. | Mark Warner | 01897 | 7630 | 535 | S327 | Mark R. Warner | N00002097 | [ "S6VA00093", "P80003023" ] |
803 | ||||||||
U000039 | Tom Udall | U000039 | 400413 | 29924 | Tom Udall | Q957690 | kg:/m/033t35 | Tom | Udall | 1948-05-18 | M | 20879 | S. | Tom Udall | 01567 | 10075 | 22658 | S326 | Tom Udall | N00006561 | [ "H8NM03097", "S8NM00184" ] |
498 | [ { "name": "Stewart Lee Udall", "relation": "son" }, { "name": "Morris K. Udall", "relation": "nephew" }, { "name": "Mark Udall", "relation": "cousin" }, { "name": "Gordon H. Smith", "relation": "cousin" } ] |
||||||
U000038 | Mark Udall | U000038 | 400412 | 29906 | Mark Udall | Q631195 | kg:/m/024zbx | Mark | Udall | 1950-07-18 | M | 20877 | E. | Mark Udall | 01595 | 7634 | 12329 | S325 | Mark Udall | N00008051 | [ "H8CO02087", "S8CO00172" ] |
497 | [ { "name": "Morris K. Udall", "relation": "son" }, { "name": "Thomas Udall", "relation": "cousin" }, { "name": "Stewart Lee Udall", "relation": "nephew" }, { "name": "Gordon H. Smith", "relation": "cousin" } ] |
||||||
S001181 | Jeanne Shaheen | S001181 | 412323 | 40906 | Jeanne Shaheen | Q270316 | kg:/m/01rrm2 | Jeanne | Shaheen | 1947-01-28 | F | 22618 | Jeanne Shaheen | 01901 | 22850 | 1663 | S324 | Jeanne Shaheen | N00024790 | [ "S0NH00219" ] |
805 | ||||||||
R000584 | James Risch | R000584 | 412322 | 40902 | Jim Risch | Q721871 | kg:/m/06y9p0 | James | Risch | 1943-05-03 | M | E. | Jim Risch | 01896 | 1020034 | 2919 | S323 | James E. Risch | N00029441 | [ "S8ID00092" ] |
804 | ||||||||
M001176 | Jeff Merkley | M001176 | 412325 | 40908 | Jeff Merkley | Q1368405 | kg:/m/026k60f | Jeff | Merkley | 1956-10-24 | M | Jeff Merkley | 01900 | 1029842 | 23644 | S322 | Jeff Merkley | N00029303 | [ "S8OR00207" ] |
807 | |||||||||
J000291 | Mike Johanns | J000291 | 412320 | 40905 | Mike Johanns | Q448880 | kg:/m/02722_ | Mike | Johanns | 1950-06-18 | M | Mike Johanns | 01899 | 56552 | 21309 | S321 | Mike Johanns | N00029444 | [ "S8NE00117" ] |
802 | |||||||||
H001049 | Kay Hagan | H001049 | 412324 | 40907 | Kay Hagan | Q261003 | kg:/m/02b56f | Kay | Hagan | 1953-05-26 | F | 15594 | Kay Hagan | 01902 | 1028015 | 21082 | S320 | Kay R. Hagan | N00029617 | [ "S8NC00239" ] |
806 | [ { "name": "Lawton M. Chiles Jr.", "relation": "niece" } ] |
|||||||
B001265 | Mark Begich | B001265 | 412326 | 40900 | Mark Begich | Q454133 | kg:/m/05pqtr | Mark | Begich | 1962-03-30 | M | Mark Begich | 01898 | 1030732 | 79426 | S319 | Mark Begich | N00029901 | [ "S8AK00090" ] |
808 | [ { "name": "Nicholas J. Begich", "relation": "son" } ] |
||||||||
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 | |||||||
B001261 | John Barrasso | B001261 | 412251 | 40707 | John Barrasso | Q720521 | kg:/m/02rsm32 | John | Barrasso | 1952-07-21 | M | A. | John Barrasso | 01881 | 1024777 | 52662 | S317 | John Barrasso | N00006236 | [ "S6WY00068" ] |
732 | [ { "title": "Senate Republican Conference Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Republican Conference Chair", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
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 |
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);