legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_cspan 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||
G000583 | Josh Gottheimer | G000583 | 412714 | 21723 | Josh Gottheimer | Q6288908 | kg:/g/120x5twv | Josh | Gottheimer | 1975-03-08 | M | Josh Gottheimer | 9275683 | 169202 | Josh Gottheimer | N00036944 | [ "H6NJ05171" ] |
2226 | |||||||||||
G000577 | Garret Graves | G000577 | 412631 | 21523 | Garret Graves | Q18686454 | kg:/m/012bxlbr | Garret | Graves | 1972-01-31 | M | Garret Graves | 02245 | 9274609 | 155424 | Garret Graves | N00036135 | [ "H4LA06153" ] |
2087 | ||||||||||
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 | ||||||||
M001180 | David McKinley | M001180 | 412487 | 21188 | David McKinley | Q1175610 | kg:/m/0crj8tf | David | McKinley | 1947-03-28 | M | 18830 | B. | David McKinley | 02074 | 9269013 | 117396 | David B. McKinley | N00031681 | [ "H0WV01072" ] |
1492 | ||||||||
H001064 | Denny Heck | H001064 | 412584 | 21369 | Denny Heck | Q4068793 | kg:/m/075stz | Denny | Heck | 1952-07-29 | M | Denny Heck | 02170 | 9269006 | 126058 | Denny Heck | N00031557 | [ "H0WA03161" ] |
1808 | ||||||||||
R000589 | Edward Rigell | R000589 | 412483 | 21185 | Scott Rigell | Q2800221 | kg:/m/0bx_0mz | Edward | Rigell | 1960-05-28 | M | 20818 | Scott | Scott | 02068 | 9268996 | 121807 | E. Scott Rigell | N00030962 | [ "H0VA02084" ] |
1488 | ||||||||
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 | |||||||||
B001273 | Diane Black | B001273 | 412478 | 21180 | Diane Black | Q515935 | kg:/m/0cyvxl | Diane | Black | 1951-01-16 | F | 10436 | 02063 | 9268964 | 25292 | Diane Black | N00031539 | [ "H0TN06257" ] |
1483 | ||||||||||
G000566 | Trey Gowdy | G000566 | 412473 | 21175 | Trey Gowdy | Q1822266 | kg:/m/0c3x3rz | Trey | Gowdy | 1964-08-22 | M | 14284 | Trey Gowdy | 02058 | 9268950 | 121782 | Trey Gowdy | N00030880 | [ "H0SC04257" ] |
1478 | |||||||||
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 | |||||||||
D000611 | Charles Djou | D000611 | 412387 | 20961 | Charles Djou | Q974192 | kg:/m/0d66z8 | Charles | Djou | 1970-08-09 | M | 12595 | 01978 | 9267955 | 17827 | N00029460 | [ "H0HI01157" ] |
||||||||||||
C001081 | Mark Critz | C001081 | 412386 | 20960 | Mark Critz | Q1900000 | kg:/m/0bwkvjd | Mark | Critz | 1962-01-05 | M | 11822 | S. | 01977 | 9267898 | 119481 | Mark S. Critz | N00032014 | [ "H0PA12132" ] |
||||||||||
S001188 | Marlin Stutzman | S001188 | 412392 | 21100 | Marlin Stutzman | Q1902106 | kg:/m/06zk1_1 | Marlin | Stutzman | 1976-08-31 | M | 22629 | A. | Marlin Stutzman | 01981 | 9267685 | 34230 | Marlin A. Stutzman | N00030891 | [ "H0IN03198", "S0IN00095" ] |
1373 | ||||||||
D000610 | Theodore Deutch | D000610 | 412385 | 20959 | Ted Deutch | Q245724 | kg:/m/03cg3qs | Theodore | Deutch | 1966-05-07 | M | 12594 | E. | Ted | Theodore E. Deutch | 01976 | 9267613 | 67151 | Theodore E. Deutch | N00031317 | [ "H0FL19080" ] |
1365 | |||||||
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 | |||||||||||
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" ] |
||||||||||
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 | ||||||||||
O000169 | William Owens | O000169 | 412383 | 20957 | Bill Owens (New York politician) | Q862349 | kg:/m/076tjbk | William | Owens | 1949-01-20 | M | 19280 | L. | 01974 | 9265845 | 116354 | William L. Owens | N00031011 | [ "H0NY23081" ] |
1210 | |||||||||
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" } ] |
||||||||
H001072 | J. Hill | H001072 | 412609 | 21503 | French Hill (politician) | Q18631366 | kg:/m/0127p1zk | J. | Hill | 1956-12-05 | M | French | French Hill | 02223 | 9265172 | 146290 | J. Hill | N00035792 | [ "H4AR02141" ] |
2065 | |||||||||
M001178 | Scott Murphy | M001178 | 412332 | 20956 | Scott Murphy | Q290602 | kg:/m/05f44mf | Scott | Murphy | 1970-01-26 | M | 18826 | 01968 | 9263721 | 110967 | N00030682 | [ "H0NY20079" ] |
||||||||||||
Q000023 | Mike Quigley | Q000023 | 412331 | 20954 | Mike Quigley (politician) | Q465767 | kg:/m/0fccwh | Mike | Quigley | 1958-10-17 | M | 20072 | Michael Quigley | 01967 | 9263344 | 83310 | Mike Quigley | N00030581 | [ "H0IL05096" ] |
1186 | |||||||||
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 | ||||||||
M001190 | Markwayne Mullin | M001190 | 412568 | 21355 | Markwayne Mullin | Q3448772 | kg:/m/0lq78pn | Markwayne | Mullin | 1977-07-26 | M | Markwayne Mullin | 02156 | 1034045 | 135898 | Markwayne Mullin | N00033410 | [ "H2OK02083" ] |
1792 | ||||||||||
W000815 | Brad Wenstrup | W000815 | 412564 | 21351 | Brad Wenstrup | Q892413 | kg:/m/0j63b7n | Brad | Wenstrup | 1958-06-17 | M | R. | Brad Wenstrup | 02152 | 1034044 | 135326 | Brad R. Wenstrup | N00033310 | [ "H2OH02085" ] |
1788 | |||||||||
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 | |||||||||
D000617 | Suzan DelBene | D000617 | 412505 | 31101 | Suzan DelBene | Q2091892 | kg:/m/05p0dnk | Suzan | DelBene | 1962-02-17 | F | 15032387032 | K. | Suzan DelBene | 02096 | 1033929 | 126272 | Suzan K. DelBene | N00030693 | [ "H0WA08046" ] |
1686 | ||||||||
C001084 | David Cicilline | C001084 | 412470 | 21172 | David Cicilline | Q938498 | kg:/m/04t97v | David | Cicilline | 1961-07-15 | M | 11826 | N. | David N. Cicilline | 02055 | 1033865 | 7349 | David N. Cicilline | N00032019 | [ "H0RI01073" ] |
1475 | ||||||||
M001181 | Patrick Meehan | M001181 | 412466 | 21168 | Pat Meehan | Q2056533 | kg:/m/03m4jty | Patrick | Meehan | 1955-10-20 | M | 18832 | Patrick Meehan | 02052 | 1033856 | 119474 | Patrick Meehan | N00031134 | [ "H0PA07082" ] |
1472 | |||||||||
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 | ||||||||
G000563 | Bob Gibbs | G000563 | 412463 | 21165 | Bob Gibbs | Q887945 | kg:/m/07qwv4 | Bob | Gibbs | 1954-06-14 | M | 14280 | Bob Gibbs | 02049 | 1033844 | 45466 | Bob Gibbs | N00031128 | [ "H0OH18077" ] |
1469 | |||||||||
G000564 | Christopher Gibson | G000564 | 412453 | 21156 | Chris Gibson (New York politician) | Q32722 | kg:/m/0dddh8h | Christopher | Gibson | 1964-05-13 | M | 14281 | P. | 02043 | 1033827 | 127042 | Christopher P. Gibson | N00031998 | [ "H0NY20095" ] |
1461 | |||||||||
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 | ||||||||
A000367 | Justin Amash | A000367 | 412438 | 21143 | Justin Amash | Q1714165 | kg:/m/0c00p_n | Justin | Amash | 1980-04-18 | M | 8769 | Justin Amash | 02029 | 1033767 | 105566 | Justin Amash | N00031938 | [ "H0MI03126" ] |
1449 | |||||||||
H001058 | Bill Huizenga | H001058 | 412437 | 21142 | Bill Huizenga | Q862199 | kg:/m/05b0j1w | Bill | Huizenga | 1969-01-31 | M | 15610 | Bill Huizenga | 02028 | 1033765 | 38351 | Bill Huizenga | N00030673 | [ "H0MI02094" ] |
1448 | |||||||||
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 | |||||||
N000185 | Richard Nugent | N000185 | 412409 | 21115 | Rich Nugent | Q2148853 | kg:/m/0czc10m | Richard | Nugent | 1951-05-26 | M | 19066 | B. | 02001 | 1033683 | 124333 | Richard B. Nugent | N00032441 | [ "H0FL05139" ] |
1421 | |||||||||
B001287 | Ami Bera | B001287 | 412512 | 21304 | Ami Bera | Q3389105 | kg:/m/0dgqnts | Ami | Bera | 1965-03-02 | M | Ami Bera | 02102 | 1033636 | 120030 | Ami Bera | N00030717 | [ "H0CA03078" ] |
1736 | ||||||||||
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 | |||||||||
H001052 | Andy Harris | H001052 | 412434 | 21139 | Andy Harris (politician) | Q506639 | kg:/m/02852wc | Andy | Harris | 1957-01-25 | M | 15599 | Andrew Harris | 02026 | 1033464 | 19157 | Andy Harris | N00029147 | [ "H8MD01094" ] |
1445 | |||||||||
H001048 | Duncan Hunter | H001048 | 412283 | 20963 | Duncan D. Hunter | Q540521 | kg:/m/047tpf2 | Duncan | Hunter | 1976-12-07 | M | 15592 | D. | Duncan Hunter | 01909 | 1032398 | 104308 | Duncan Hunter | N00029258 | [ "H8CA52052" ] |
765 | [ { "name": "Duncan Lee Hunter", "relation": "son" } ] |
|||||||
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 | ||||||||
S001177 | Gregorio Sablan | S001177 | 412312 | Gregorio Sablan | Q3116336 | kg:/m/04ycmvy | Gregorio | Sablan | 1955-01-19 | M | 22610 | Kilili Camacho | 01962 | 1031366 | 110903 | Gregorio Kilili Camacho Sablan | N00030418 | [ "H8MP00041" ] |
794 | ||||||||||
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 | |||||||
P000600 | Thomas Perriello | P000600 | 412304 | 20951 | Tom Perriello | Q1628398 | kg:/m/03crz_4 | Thomas | Perriello | 1974-10-09 | M | 20038 | S. P. | 01958 | 1031364 | 109344 | N00029339 | [ "H8VA05106" ] |
|||||||||||
N000183 | Glenn Nye | N000183 | 412301 | 20950 | Glenn Nye | Q919254 | kg:/m/04p_ygb | Glenn | Nye | 1974-09-09 | M | 19062 | C. | 01957 | 1031363 | 109342 | N00029784 | [ "H8VA02046" ] |
|||||||||||
C001076 | Jason Chaffetz | C001076 | 412270 | 20949 | Jason Chaffetz | Q1683881 | kg:/m/047blr4 | Jason | Chaffetz | 1967-03-26 | M | 11813 | Jason Chaffetz | 01956 | 1031362 | 103482 | Jason Chaffetz | N00028958 | [ "H8UT03089" ] |
752 | |||||||||
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 | |||||||||
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 | |||||||
T000467 | Glenn Thompson | T000467 | 412317 | 20946 | Glenn Thompson (politician) | Q1531120 | kg:/m/0409b0_ | Glenn | Thompson | 1959-07-27 | M | 23213 | Glenn Thompson (Pennsylvania) | 01952 | 1031359 | 24046 | Glenn Thompson | N00029736 | [ "H8PA05071" ] |
799 | |||||||||
S001180 | Kurt Schrader | S001180 | 412315 | 20944 | Kurt Schrader | Q1387868 | kg:/m/0412ntl | Kurt | Schrader | 1951-10-19 | M | 22616 | Kurt Schrader | 01950 | 1031358 | 10813 | Kurt Schrader | N00030071 | [ "H8OR05107" ] |
797 | |||||||||
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" ] |
|||||||||||
K000369 | Larry Kissell | K000369 | 412287 | 20938 | Larry Kissell | Q1806078 | kg:/m/0cgp2r | Larry | Kissell | 1951-01-31 | M | 16562 | 01934 | 1031354 | 57769 | Larry Kissell | N00028859 | [ "H6NC08111" ] |
|||||||||||
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 | |||||||||
M001174 | Michael McMahon | M001174 | 412296 | 20933 | Michael McMahon | Q1928589 | kg:/m/08c67w | Michael | McMahon | 1957-09-12 | M | 18819 | E. | 01941 | 1031352 | 44728 | N00030267 | [ "H8NY13077" ] |
|||||||||||
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" } ] |
||||||
L000567 | Leonard Lance | L000567 | 412290 | 20929 | Leonard Lance | Q1819021 | kg:/m/077cs4 | Leonard | Lance | 1952-06-25 | M | 17311 | 01936 | 1031349 | 4443 | Leonard Lance | N00000898 | [ "H6NJ12136", "H8NJ07124" ] |
772 | ||||||||||
L000569 | Blaine Luetkemeyer | L000569 | 412292 | 20926 | Blaine Luetkemeyer | Q522181 | kg:/m/04ycpq1 | Blaine | Luetkemeyer | 1952-05-07 | M | 17315 | Blaine Luetkemeyer | 01931 | 1031348 | 20400 | Blaine Luetkemeyer | N00030026 | [ "H8MO09153" ] |
774 | |||||||||
H001045 | Gregg Harper | H001045 | 412280 | 20925 | Gregg Harper | Q1545023 | kg:/m/0406s7r | Gregg | Harper | 1956-06-01 | M | 15586 | 01933 | 1031347 | 101985 | Gregg Harper | N00029632 | [ "H8MS03067" ] |
762 | ||||||||||
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" ] |
|||||||||||
F000456 | John Fleming | F000456 | 412275 | 20918 | John Fleming (American politician) | Q1699486 | kg:/m/04z_dt3 | John | Fleming | 1951-07-05 | M | 13559 | John Fleming (Louisiana) | 01924 | 1031345 | 108811 | John Fleming | N00029679 | [ "H8LA04225" ] |
757 | [ { "name": "Henry Clay", "relation": "relative" }, { "name": "James Brown Clay", "relation": "relative" } ] |
||||||||
C001079 | Anh Cao | C001079 | 412268 | 20917 | Joseph Cao | Q336324 | kg:/m/04yfg9l | Anh | Cao | 1967-03-13 | M | Joseph | 01923 | 1031344 | 93967 | N00030339 | [ "H8LA02112" ] |
||||||||||||
G000558 | Brett Guthrie | G000558 | 412278 | 20916 | Brett Guthrie | Q910794 | kg:/m/0411qqt | Brett | Guthrie | 1964-02-18 | M | 14275 | Brett Guthrie | 01922 | 1031343 | 18829 | Brett Guthrie | N00029675 | [ "H8KY02031" ] |
760 | |||||||||
H001044 | Deborah Halvorson | H001044 | 412279 | 20913 | Debbie Halvorson | Q3020814 | kg:/m/02qgvlk | Deborah | Halvorson | 1958-03-01 | F | 15584 | L. | Debbie Halvorson | 01919 | 1031342 | 9531 | N00029377 | [ "H8IL11113" ] |
||||||||||
H001047 | James Himes | H001047 | 412282 | 20907 | Jim Himes | Q1689111 | kg:/m/03w9x9v | James | Himes | 1966-07-05 | M | 15590 | A. | Jim | Jim Himes | 01913 | 1031341 | 106744 | James A. Himes | N00029070 | [ "H8CT04172" ] |
764 | |||||||
C001077 | Mike Coffman | C001077 | 412271 | 20906 | Mike Coffman | Q547218 | kg:/m/03gy95d | Mike | Coffman | 1955-03-19 | M | 11815 | Mike Coffman | 01912 | 1031340 | 1535 | Mike Coffman | N00024753 | [ "H8CO06138", "H2CO00019" ] |
753 | |||||||||
G000557 | Parker Griffith | G000557 | 412277 | Parker Griffith | Q936720 | kg:/m/026mndp | Parker | Griffith | 1942-08-06 | M | 14273 | 01906 | 1031339 | 60357 | N00029917 | [ "H8AL05109" ] |
|||||||||||||
K000368 | Ann Kirkpatrick | K000368 | 412286 | 20902 | Ann Kirkpatrick | Q558460 | kg:/m/02qtczp | Ann | Kirkpatrick | 1950-03-24 | F | 16560 | Ann Kirkpatrick | 01907 | 1031338 | 28425 | Ann Kirkpatrick | N00029260 | [ "H8AZ01104" ] |
768 | |||||||||
P000596 | Pedro Pierluisi | P000596 | 412306 | Pedro Pierluisi | Q2277878 | kg:/m/02r7csl | Pedro | Pierluisi | 1959-04-26 | M | 20030 | R. | 01953 | 1031305 | 110894 | Pedro R. Pierluisi | N00029168 | [ "H8PR00062" ] |
788 | ||||||||||
L000568 | Christopher Lee | L000568 | 412291 | 20936 | Chris Lee (New York politician) | Q1077474 | kg:/m/043jq2n | Christopher | Lee | 1964-04-01 | M | 17313 | John | 01944 | 1031304 | 110348 | N00030198 | [ "H8NY26095" ] |
|||||||||||
P000598 | Jared Polis | P000598 | 412308 | 20904 | Jared Polis | Q935734 | kg:/m/02qckk4 | Jared | Polis | 1975-05-12 | M | 20034 | Jared Polis | 01910 | 1031300 | 106220 | Jared Polis | N00029127 | [ "H8CO02137" ] |
790 | |||||||||
K000373 | Edward Kaufman | K000373 | 412329 | 40901 | Ted Kaufman | Q665919 | kg:/m/04y9vtn | Edward | Kaufman | 1939-03-15 | M | E. | 01964 | 1030984 | 110918 | S329 | N00030767 | ||||||||||||
F000455 | Marcia Fudge | F000455 | 412327 | 20941 | Marcia Fudge | Q461746 | kg:/m/04n11v9 | Marcia | Fudge | 1952-10-29 | F | 13557 | L. | Marcia L. Fudge | 01895 | 1030928 | 110640 | Marcia L. Fudge | N00030490 | [ "H8OH11141" ] |
809 | ||||||||
A000364 | John Adler | A000364 | 412264 | 20928 | John Adler | Q976160 | kg:/m/05jzss | John | Adler | 1959-08-23 | M | 8763 | H. | 01935 | 1030767 | 4171 | N00000812 | [ "H8NJ03156" ] |
|||||||||||
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" } ] |
||||||||
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 | ||||||||
K000370 | Suzanne Kosmas | K000370 | 412288 | 20911 | Suzanne Kosmas | Q434947 | kg:/m/04ctf9n | Suzanne | Kosmas | 1944-02-25 | F | 16564 | M. | 01917 | 1030644 | 12851 | N00029370 | [ "H8FL24026" ] |
|||||||||||
D000609 | Steve Driehaus | D000609 | 412274 | 20939 | Steve Driehaus | Q2346930 | kg:/m/0fwvqw | Steve | Driehaus | 1966-06-24 | M | 12592 | 01946 | 1030610 | 45110 | N00029211 | [ "H8OH01068" ] |
||||||||||||
D000608 | Kathleen Dahlkemper | D000608 | 412273 | 20945 | Kathy Dahlkemper | Q3813932 | kg:/m/04y5j6j | Kathleen | Dahlkemper | 1957-12-10 | F | 12590 | A. | 01951 | 1030596 | 102423 | N00029414 | [ "H8PA03084" ] |
|||||||||||
J000290 | Lynn Jenkins | J000290 | 412284 | 20915 | Lynn Jenkins | Q456217 | kg:/m/02qdzmy | Lynn | Jenkins | 1963-06-10 | F | 16069 | Lynn Jenkins | 01921 | 1030550 | 18594 | Lynn Jenkins | N00029077 | [ "H8KS02090" ] |
766 | |||||||||
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 | ||||||||
R000583 | Thomas Rooney | R000583 | 412311 | 20910 | Tom Rooney (Florida politician) | Q506110 | kg:/m/04jl2j4 | Thomas | Rooney | 1970-11-21 | M | 20809 | J. | Thomas J. Rooney | 01916 | 1030486 | 107800 | Thomas J. Rooney | N00029018 | [ "H8FL16022" ] |
793 | ||||||||
T000466 | Harry Teague | T000466 | 412316 | 20931 | Harry Teague | Q1586830 | kg:/m/04y921x | Harry | Teague | 1949-06-29 | M | 23211 | Harry Teague | 01938 | 1030431 | 102408 | N00029556 | [ "H8NM02032" ] |
|||||||||||
M001172 | Betsy Markey | M001172 | 412298 | 20905 | Betsy Markey | Q526808 | kg:/m/02rrw6k | Betsy | Markey | 1956-04-27 | F | 18815 | 01911 | 1030430 | 106225 | N00029128 | [ "H8CO04067" ] |
||||||||||||
S001179 | Aaron Schock | S001179 | 412314 | 20914 | Aaron Schock | Q302659 | kg:/m/0h6xzk | Aaron | Schock | 1981-05-28 | M | 22614 | Aaron Schock | 01920 | 1030003 | 33428 | Aaron Schock | N00029273 | [ "H8IL18043" ] |
796 | |||||||||
P000594 | Erik Paulsen | P000594 | 412303 | 20924 | Erik Paulsen | Q466085 | kg:/m/0407tc8 | Erik | Paulsen | 1965-05-14 | M | 20026 | Erik Paulsen | 01930 | 1030000 | 3833 | Erik Paulsen | N00029391 | [ "H8MN03077" ] |
785 | |||||||||
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 | |||||||||
B001304 | Anthony Brown | B001304 | 412707 | 21707 | Anthony G. Brown | Q4772558 | kg:/m/09v6fg | Anthony | Brown | 1961-11-21 | M | G. | Anthony Brown (Maryland) | 1029537 | 19344 | Anthony G. Brown | N00036999 | [ "H6MD04209" ] |
2219 | ||||||||||
B001263 | John Boccieri | B001263 | 412266 | 20943 | John Boccieri | Q6222319 | kg:/m/02qpsy1 | John | Boccieri | 1969-10-05 | M | 10424 | A. | 01949 | 1028316 | 45694 | N00029161 | [ "H8OH16058" ] |
|||||||||||
C001074 | Travis Childers | C001074 | 412262 | 20761 | Travis Childers | Q452865 | kg:/m/0403tyv | Travis | Childers | 1958-03-29 | M | 11809 | W. | 01893 | 1028265 | 101982 | N00029692 | [ "H8MS01061" ] |
|||||||||||
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 | ||||||||
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" } ] |
|||||||
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" } ] |
|||||||
S001175 | Jackie Speier | S001175 | 412259 | 20762 | Jackie Speier | Q218544 | kg:/m/06k27l | Jackie | Speier | 1950-05-14 | F | 22606 | Jackie Speier | 01890 | 1027627 | 8425 | Jackie Speier | N00029649 | [ "H8CA12171" ] |
740 | |||||||||
C001072 | André Carson | C001072 | 412258 | 20757 | André Carson | Q517649 | kg:/m/03qcvz1 | André | Carson | 1974-10-16 | M | 11806 | Andre Carson | 01889 | 1027364 | 84917 | André Carson | N00029513 | [ "H8IN07184" ] |
739 | [ { "name": "Julia Carson", "relation": "grandson" } ] |
||||||||
F000454 | Bill Foster | F000454 | 412257 | 20749 | Bill Foster (politician) | Q2903389 | kg:/m/02rq8nc | Bill | Foster | 1955-10-07 | M | 13555 | Bill Foster | 01888 | 1027346 | 101632 | Bill Foster | N00029139 | [ "H8IL14067", "H2IL11124" ] |
738 | |||||||||
H001078 | Karen Handel | H001078 | 412737 | Karen Handel | Q6369678 | kg:/m/0g838b | Karen | Handel | 1962-04-18 | F | 15032448993 | Karen Handel | 1026745 | 69553 | Karen C. Handel | N00035477 | [ "H8GA06286" ] |
2249 | |||||||||||
R000581 | Laura Richardson | R000581 | 412253 | 20752 | Laura Richardson | Q461610 | kg:/m/027mfb3 | Laura | Richardson | 1962-04-14 | F | 20805 | 01883 | 1025575 | 69508 | Laura Richardson | N00029112 | [ "H8CA37137" ] |
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);