legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_icpsr 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D000601 | Elizabeth Dole | D000601 | 300035 | 40303 | Elizabeth Dole | Q239571 | kg:/m/01f0yh | Elizabeth | Dole | 1936-07-29 | F | 12577 | H. | 01698 | 41533 | S292 | N00008071 | [ "S2NC00083" ] |
|||||||||||
C001057 | Norm Coleman | C001057 | 300024 | 40302 | Norm Coleman | Q706661 | kg:/m/01jhtj | Norm | Coleman | 1949-08-17 | M | 01697 | 20239 | S291 | N00013870 | [ "S2MN00126" ] |
|||||||||||||
P000590 | Mark Pryor | P000590 | 300080 | 40301 | Mark Pryor | Q470755 | kg:/m/01gb3p | Mark | Pryor | 1963-01-10 | M | Mark Pryor | 01701 | 1002201 | 35 | S295 | Mark L. Pryor | N00013823 | [ "S0AR00028" ] |
599 | [ { "name": "David H. Pryor", "relation": "son" } ] |
||||||||
M001153 | Lisa Murkowski | M001153 | 300075 | 40300 | Lisa Murkowski | Q22360 | kg:/m/0202kt | Lisa | Murkowski | 1957-05-22 | F | 18778 | A. | Lisa Murkowski | 01694 | 1004138 | 15841 | S288 | Lisa Murkowski | N00026050 | [ "S4AK00099" ] |
595 | [ { "name": "Frank Hughes Murkowski", "relation": "daughter" } ] |
||||||
B001237 | Dean Barkley | B001237 | 401147 | 40106 | Dean Barkley | Q362480 | kg:/m/0126_6 | Dean | Barkley | 1950-08-31 | M | 01690 | S285 | ||||||||||||||||
C001041 | Hillary Clinton | C001041 | 300022 | 40105 | Hillary Clinton | Q6294 | kg:/m/0d06m5 | Hillary | Clinton | 1947-10-26 | F | 11751 | Rodham | Hillary Clinton | 01631 | 55463 | S278 | N00000019 | [ "S0NY00188" ] |
||||||||||
C001042 | Jon Corzine | C001042 | 300028 | 40104 | Jon Corzine | Q380570 | kg:/m/01xcrz | Jon | Corzine | 1947-01-01 | M | Stevens | 01630 | S279 | N00009945 | ||||||||||||||
N000180 | Ben Nelson | N000180 | 300077 | 40103 | Ben Nelson | Q718542 | kg:/m/01_pcc | Ben | Nelson | 1941-05-17 | M | E. | 01627 | 16991 | 21744 | S283 | Ben Nelson | N00005329 | [ "S6NE00095" ] |
||||||||||
C001043 | Jean Carnahan | C001043 | 300153 | 40102 | Jean Carnahan | Q448619 | kg:/m/026wyq | Jean | Carnahan | 1933-12-20 | F | 11754 | 01680 | S276 | |||||||||||||||
D000596 | Mark Dayton | D000596 | 300032 | 40101 | Mark Dayton | Q513091 | kg:/m/01l42w | Mark | Dayton | 1947-01-26 | M | 01629 | S280 | N00013291 | |||||||||||||||
S000106 | Joe Scarborough | S000106 | 400608 | 39508 | Joe Scarborough | Q1280288 | kg:/m/0226wy | Joe | Scarborough | 1963-04-09 | M | 21265 | 01025 | ||||||||||||||||
M000472 | John McHugh | M000472 | 400264 | 39316 | John M. McHugh | Q457729 | kg:/m/03txk7 | John | McHugh | 1948-09-29 | M | 17916 | M. | 00773 | 26986 | N00001276 | [ "H2NY24036" ] |
||||||||||||
B000177 | Thomas Barrett | B000177 | 400553 | 39315 | Tom Barrett (Wisconsin politician) | Q955542 | kg:/m/04qktl | Thomas | Barrett | 1953-12-08 | M | 9001 | M. | 00058 | |||||||||||||||
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 | |||||||||||||
K000328 | Myron Kreidler | K000328 | 406482 | 39313 | Mike Kreidler | Q684548 | kg:/m/04l7p1 | Myron | Kreidler | 1943-09-28 | M | 16494 | Bradford | Mike | 00652 | ||||||||||||||
D000549 | Jennifer Dunn | D000549 | 400117 | 39312 | Jennifer Dunn (politician) | Q518997 | kg:/m/024zp4 | Jennifer | Dunn | 1941-07-29 | F | 12510 | B. | 00324 | N00007823 | ||||||||||||||
C000127 | Maria Cantwell | C000127 | 300018 | 39310 | Maria Cantwell | Q22250 | kg:/m/01x68t | Maria | Cantwell | 1958-10-13 | F | 10608 | Maria Cantwell | 00172 | 26137 | 27122 | S275 | Maria Cantwell | N00007836 | [ "S8WA00194", "H2WA01054" ] |
544 | ||||||||
B001213 | Leslie Byrne | B001213 | 402152 | 39309 | Leslie Byrne | Q727598 | kg:/m/06fc_b | Leslie | Byrne | 1946-10-27 | F | 10336 | Larkin | 00161 | |||||||||||||||
G000289 | Bob Goodlatte | G000289 | 400154 | 39308 | Bob Goodlatte | Q887952 | kg:/m/0284s7 | Bob | Goodlatte | 1952-09-22 | M | 13929 | W. | Bob Goodlatte | 00446 | 27025 | 27116 | Bob Goodlatte | N00009154 | [ "H2VA06115" ] |
262 | ||||||||
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 | |||||||
S000332 | Karen Shepherd | S000332 | 409829 | 39306 | Karen Shepherd | Q525093 | kg:/m/0ksnlz | Karen | Shepherd | 1940-07-05 | F | 21550 | 01050 | ||||||||||||||||
J000126 | Eddie Johnson | J000126 | 400204 | 39305 | Eddie Bernice Johnson | Q461526 | kg:/m/03tn1w | Eddie | Johnson | 1935-12-03 | F | 15852 | Bernice | Eddie Bernice Johnson | 00599 | 23352 | 27098 | Eddie Bernice Johnson | N00008122 | [ "H2TX00015" ] |
308 | ||||||||
G000410 | Gene Green | G000410 | 400160 | 39304 | Gene Green | Q539587 | kg:/m/03v12k | Gene | Green | 1947-10-17 | M | 14085 | Eugene | 00462 | 26156 | 27100 | Gene Green | N00005870 | [ "H2TX29030" ] |
266 | |||||||||
T000113 | Frank Tejeda | T000113 | 410695 | 39303 | Frank Tejeda | Q737918 | kg:/m/09v83j | Frank | Tejeda | 1945-10-02 | M | 22773 | Mariano | 01147 | |||||||||||||||
B000617 | Henry Bonilla | B000617 | 400037 | 39302 | Henry Bonilla | Q1424754 | kg:/m/03tfr_ | Henry | Bonilla | 1954-01-02 | M | 9580 | 00107 | N00005985 | |||||||||||||||
C000537 | James Clyburn | C000537 | 400075 | 39301 | Jim Clyburn | Q1289889 | kg:/m/03c469 | James | Clyburn | 1940-07-21 | M | 11119 | E. | Jim | James E. Clyburn | 00208 | 21607 | 27066 | James E. Clyburn | N00002408 | [ "H2SC02042" ] |
192 | [ { "title": "House Majority Whip", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Majority Whip", "chamber": "house", "start": "2021-01-03" } ] |
[ { "name": "George Washington Murray", "relation": "relative" } ] |
|||||
I000023 | Bob Inglis | I000023 | 400649 | 39300 | Bob Inglis | Q888008 | kg:/m/04dvtm | Bob | Inglis | 1959-10-11 | M | 15643 | 00582 | 26441 | 27064 | N00002460 | [ "H2SC04022" ] |
||||||||||||
P000604 | Donald Payne | P000604 | 412506 | 31103 | Donald Payne Jr. | Q1240224 | kg:/m/0jwr2v8 | Donald | Payne | 1958-12-17 | M | M. | Donald Payne Jr. | Jr. | 02097 | 65639 | 90668 | Donald M. Payne, Jr. | N00034639 | [ "H2NJ10154" ] |
1687 | [ { "name": "Donald Milford Payne", "relation": "son" } ] |
|||||||
M001184 | Thomas Massie | M001184 | 412503 | 31102 | Thomas Massie | Q2426031 | kg:/m/0h_cb6v | Thomas | Massie | 1971-01-13 | M | Thomas Massie | 02094 | 79951 | 132068 | Thomas Massie | N00034041 | [ "H2KY04121" ] |
1684 | ||||||||||
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 | ||||||||
C001089 | David Curson | C001089 | 412504 | 31100 | David Curson | Q1174126 | kg:/m/0nd2pq0 | David | Curson | 1948-11-04 | M | Alan | 02095 | 143373 | David Alan Curson | N00034982 | [ "H2MI11190" ] |
||||||||||||
G000544 | Charles Gonzalez | G000544 | 400152 | 29943 | Charlie Gonzalez | Q539459 | kg:/m/03jsbn | Charles | Gonzalez | 1945-05-05 | M | 14247 | A. | Charlie | 01555 | 25445 | Charles A. Gonzalez | N00005960 | [ "H8TX20077" ] |
||||||||||
B001234 | Joe Baca | B001234 | 400009 | 29942 | Joe Baca | Q539549 | kg:/m/024xk0 | Joe | Baca | 1947-01-23 | M | 10368 | 01614 | 81682 | 8039 | Joe Baca | N00007089 | [ "H6CA42099" ] |
|||||||||||
G000545 | Mark Green | G000545 | 400159 | 29941 | Mark Andrew Green | Q1602312 | kg:/m/024slr | Mark | Green | 1960-06-01 | M | 14249 | A. | 01559 | N00004391 | ||||||||||||||
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" } ] |
|||||||
R000570 | Paul Ryan | R000570 | 400351 | 29939 | Paul Ryan | Q203966 | kg:/m/024v2j | Paul | Ryan | 1970-01-29 | M | 20785 | D. | Paul Ryan | 01560 | 57970 | 26344 | Paul D. Ryan | N00004357 | [ "H8WI01024" ] |
445 | [ { "title": "Speaker of the House", "chamber": "house", "start": "2015-10-28", "end": "2017-01-03" }, { "title": "Speaker of the House", "chamber": "house", "start": "2017-01-03", "end": "2019-01-03" } ] |
|||||||
B001229 | Brian Baird | B001229 | 400011 | 29938 | Brian Baird | Q503548 | kg:/m/02593n | Brian | Baird | 1956-03-07 | M | 10359 | N. | 01557 | 45981 | 837 | N00007936 | [ "H6WA03135" ] |
|||||||||||
I000026 | Jay Inslee | I000026 | 400193 | 29937 | Jay Inslee | Q1100710 | kg:/m/025bdx | Jay | Inslee | 1951-02-09 | M | 15649 | Jay Inslee | 00584 | 26139 | 27125 | N00001725 | [ "H2WA04090" ] |
|||||||||||
D000595 | Jim DeMint | D000595 | 400105 | 29936 | Jim DeMint | Q22201 | kg:/m/02v30g | Jim | DeMint | 1951-09-02 | M | 12566 | W. | Jim DeMint | 01605 | 57895 | 25026 | S302 | Jim DeMint | N00002472 | [ "S4SC00083" ] |
||||||||
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 | ||||||
H001031 | Joseph Hoeffel | H001031 | 400181 | 29934 | Joe Hoeffel | Q6210357 | kg:/m/026w9r | Joseph | Hoeffel | 1950-09-03 | M | 15558 | M. | 01579 | N00001529 | ||||||||||||||
S001146 | Donald Sherwood | S001146 | 400372 | 29933 | Don Sherwood | Q5293513 | kg:/m/03v3b8 | Donald | Sherwood | 1941-03-05 | M | 22552 | L. | Don | 01589 | N00001510 | |||||||||||||
W000791 | Greg Walden | W000791 | 400419 | 29932 | Greg Walden | Q1397359 | kg:/m/033tx_ | Greg | Walden | 1957-01-10 | M | 24165 | P. | Greg Walden | 01596 | 57892 | 2979 | Greg Walden | N00007690 | [ "H6OR02116" ] |
504 | ||||||||
W000793 | David Wu | W000793 | 400437 | 29931 | David Wu | Q130079 | kg:/m/033tm3 | David | Wu | 1955-04-08 | M | 24169 | 01598 | 57882 | 23797 | N00009824 | [ "H8OR01072" ] |
||||||||||||
J000284 | Stephanie Jones | J000284 | 400208 | 29930 | Stephanie Tubbs Jones | Q461489 | kg:/m/034lzc | Stephanie | Jones | 1949-09-10 | F | 16057 | Tubbs | 01581 | 23325 | N00003561 | [ "H8OH11067" ] |
||||||||||||
H001029 | Robin Hayes | H001029 | 400172 | 29929 | Robin Hayes | Q2159790 | kg:/m/0263j2 | Robin | Hayes | 1945-08-14 | M | 15554 | C. | 01600 | 1641 | N00002315 | [ "H8NC08042" ] |
||||||||||||
R000569 | Thomas Reynolds | R000569 | 400338 | 29928 | Thomas M. Reynolds | Q6069522 | kg:/m/03tvy7 | Thomas | Reynolds | 1950-09-03 | M | 20783 | M. | 01587 | 4384 | N00001295 | [ "H8NY27077" ] |
||||||||||||
S001149 | John Sweeney | S001149 | 400393 | 29927 | John E. Sweeney | Q6199983 | kg:/m/03twbt | John | Sweeney | 1955-08-09 | M | 22558 | E. | 01591 | N00009821 | ||||||||||||||
W000792 | Anthony Weiner | W000792 | 400426 | 29926 | Anthony Weiner | Q557810 | kg:/m/03tvfr | Anthony | Weiner | 1964-09-04 | M | 24167 | David | 01597 | 23162 | N00001110 | [ "H8NY09091" ] |
||||||||||||
C001038 | Joseph Crowley | C001038 | 400087 | 29925 | Joe Crowley | Q971318 | kg:/m/03v10s | Joseph | Crowley | 1962-03-16 | M | 11748 | Joe | Joseph Crowley | 01604 | 57880 | 4295 | Joseph Crowley | N00001127 | [ "H8NY07046" ] |
201 | ||||||||
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" } ] |
||||||
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" } ] |
||||||||
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" ] |
||||||||||||
T000459 | Lee Terry | T000459 | 400400 | 29921 | Lee Terry | Q585249 | kg:/m/0bb1l8 | Lee | Terry | 1962-01-29 | M | 23198 | R. | Lee Terry | 01566 | 57891 | 21276 | Lee Terry | N00005321 | [ "H8NE02139" ] |
487 | ||||||||
S001147 | Ronnie Shows | S001147 | 400530 | 29920 | Ronnie Shows | Q2166034 | kg:/m/0df514 | Ronnie | Shows | 1947-01-26 | M | 22554 | 01565 | ||||||||||||||||
C001037 | Michael Capuano | C001037 | 400063 | 29919 | Mike Capuano | Q551578 | kg:/m/028vsm | Michael | Capuano | 1952-01-09 | M | 11746 | E. | Michael Capuano | 01564 | 56760 | 18883 | Michael E. Capuano | N00000267 | [ "H8MA08071", "S0MA00117" ] |
181 | ||||||||
V000127 | David Vitter | V000127 | 400418 | 29918 | David Vitter | Q519780 | kg:/m/025jr2 | David | Vitter | 1961-05-03 | M | 21030 | David Vitter | 01609 | 60672 | 4615 | S299 | David Vitter | N00009659 | [ "S4LA00057", "H0LA01079" ] |
503 | ||||||||
F000441 | Ernest Fletcher | F000441 | 400135 | 29917 | Ernie Fletcher | Q881233 | kg:/m/026fb9 | Ernest | Fletcher | 1952-11-12 | M | 13532 | Lee | Ernie | 01563 | 115 | N00003430 | ||||||||||||
L000558 | Kenneth Lucas | L000558 | 400248 | 29916 | Ken Lucas | Q1404866 | kg:/m/025jlr | Kenneth | Lucas | 1933-08-22 | M | 17294 | R. | Ken | 01562 | N00003444 | |||||||||||||
M001140 | Dennis Moore | M001140 | 400282 | 29915 | Dennis Moore (politician) | Q954893 | kg:/m/024s71 | Dennis | Moore | 1945-11-08 | M | 18753 | 01561 | 57965 | 18662 | N00005233 | [ "H8KS03049" ] |
||||||||||||
H001030 | Baron Hill | H001030 | 400177 | 29914 | Baron Hill (politician) | Q595948 | kg:/m/022rbw | Baron | Hill | 1953-06-23 | M | 15556 | P. | 01578 | 12259 | 18466 | N00003875 | [ "H8IN09032" ] |
|||||||||||
P000584 | David Phelps | P000584 | 400519 | 29913 | David D. Phelps | Q3018617 | kg:/m/0ddc1r | David | Phelps | 1947-10-26 | M | 20007 | 01586 | ||||||||||||||||
B001232 | Judy Biggert | B001232 | 400027 | 29912 | Judy Biggert | Q461123 | kg:/m/0256wq | Judy | Biggert | 1937-08-15 | F | 10365 | 01577 | 57890 | 6298 | Judy Biggert | N00004762 | [ "H8IL13069" ] |
|||||||||||
S001145 | Janice Schakowsky | S001145 | 400360 | 29911 | Jan Schakowsky | Q440885 | kg:/m/0256nw | Janice | Schakowsky | 1944-05-26 | F | 22550 | D. | Jan | Jan Schakowsky | 01588 | 57874 | 6387 | Janice D. Schakowsky | N00004724 | [ "H8IL09067" ] |
452 | |||||||
S001148 | Michael Simpson | S001148 | 400376 | 29910 | Mike Simpson | Q549521 | kg:/m/0255tn | Michael | Simpson | 1950-09-08 | M | 22556 | K. | Mike | Michael K. Simpson | 01590 | 57889 | 2917 | Michael K. Simpson | N00006263 | [ "H8ID02064" ] |
466 | |||||||
I000055 | John Isakson | I000055 | 400194 | 29909 | Johnny Isakson | Q130024 | kg:/m/02556q | John | Isakson | 1944-12-28 | M | 15687 | H. | Johnny | Johnny Isakson | 01608 | 59135 | 1721 | S305 | Johnny Isakson | N00002593 | [ "S6GA00119", "H8GA06146" ] |
298 | ||||||
L000557 | John Larson | L000557 | 400233 | 29908 | John B. Larson | Q357832 | kg:/m/024zl9 | John | Larson | 1948-07-22 | M | 17292 | B. | John B. Larson | 01583 | 36596 | 17188 | John B. Larson | N00000575 | [ "H8CT01046" ] |
334 | ||||||||
T000458 | Thomas Tancredo | T000458 | 400394 | 29907 | Tom Tancredo | Q159720 | kg:/m/024zgw | Thomas | Tancredo | 1945-12-20 | M | 23196 | G. | Tom | 01592 | 17030 | N00006103 | [ "H8CO06054" ] |
|||||||||||
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" } ] |
||||||
M001139 | Gary Miller | M001139 | 400277 | 29905 | Gary Miller | Q781113 | kg:/m/024xfr | Gary | Miller | 1948-10-16 | M | 18751 | G. | 01584 | 57888 | 8346 | Gary G. Miller | N00006954 | [ "H8CA41063" ] |
373 | |||||||||
K000357 | Steven Kuykendall | K000357 | 400592 | 29904 | Steven T. Kuykendall | Q682552 | kg:/m/06x7n8 | Steven | Kuykendall | 1947-01-27 | M | 16538 | T. | 01582 | |||||||||||||||
N000179 | Grace Napolitano | N000179 | 400290 | 29903 | Grace Napolitano | Q469139 | kg:/m/024v0s | Grace | Napolitano | 1936-12-04 | F | 19055 | F. | Grace Napolitano | 01602 | 57873 | 8393 | Grace F. Napolitano | N00006789 | [ "H8CA34068" ] |
386 | ||||||||
O000164 | Doug Ose | O000164 | 400304 | 29902 | Doug Ose | Q1251831 | kg:/m/024sfp | Doug | Ose | 1955-06-27 | M | 19270 | 01585 | 16472 | N00007581 | ||||||||||||||
T000460 | Mike Thompson | T000460 | 400403 | 29901 | Mike Thompson (California politician) | Q1323196 | kg:/m/024sdl | Mike | Thompson | 1951-01-24 | M | 23200 | Michael | Mike Thompson (California) | 01593 | 57872 | 3564 | Mike Thompson | N00007419 | [ "H8CA01109" ] |
489 | ||||||||
W000789 | Heather Wilson | W000789 | 400434 | 29779 | Heather Wilson | Q459712 | kg:/m/024vql | Heather | Wilson | 1960-12-30 | F | 24163 | A. | 01539 | 22687 | N00006546 | [ "H8NM01174" ] |
||||||||||||
L000551 | Barbara Lee | L000551 | 400237 | 29778 | Barbara Lee | Q289317 | kg:/m/024sjy | Barbara | Lee | 1946-07-16 | F | 17282 | Barbara Lee (California) | 01501 | 54579 | 8315 | Barbara Lee | N00008046 | [ "H8CA09060" ] |
337 | |||||||||
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 | ||||||||
M001137 | Gregory Meeks | M001137 | 400271 | 29776 | Gregory Meeks | Q1545391 | kg:/m/024_3b | Gregory | Meeks | 1953-09-25 | M | 18747 | W. | Gregory Meeks | 01506 | 53469 | 4360 | Gregory W. Meeks | N00001171 | [ "H8NY06048" ] |
367 | ||||||||
B001228 | Mary Bono Mack | B001228 | 400039 | 29775 | Mary Bono | Q459753 | kg:/m/024xmf | Mary | Bono Mack | 1961-10-24 | F | 10357 | Whitaker | [ { "last": "Bono", "end": "2007-12-17" } ] |
01465 | 1434 | Mary Bono Mack | N00007068 | [ "H8CA44034" ] |
||||||||||
C001036 | Lois Capps | C001036 | 400062 | 29774 | Lois Capps | Q459693 | kg:/m/024tfg | Lois | Capps | 1938-01-10 | F | 11744 | 01471 | 54075 | 16886 | Lois Capps | N00007232 | [ "H8CA22089" ] |
180 | [ { "name": "Walter Capps", "relation": "wife" } ] |
|||||||||
F000440 | Vito Fossella | F000440 | 400139 | 29773 | Vito Fossella | Q5738335 | kg:/m/03tt8k | Vito | Fossella | 1965-03-09 | M | 13530 | J. | Jr. | 01484 | 16455 | N00000983 | [ "H8NY13028" ] |
|||||||||||
R000567 | William Redmond | R000567 | 409087 | 29772 | William T. Redmond | Q2580709 | kg:/m/0gxqf0 | William | Redmond | 1955-01-28 | M | 20779 | Thomas | 01515 | |||||||||||||||
R000568 | Ciro Rodriguez | R000568 | 400339 | 29771 | Ciro Rodriguez | Q546932 | kg:/m/03tvkv | Ciro | Rodriguez | 1946-12-09 | M | 20781 | D. | 01518 | 48779 | 16389 | N00009828 | [ "H8TX28013" ] |
|||||||||||
J000149 | Jay Johnson | J000149 | 406047 | 29770 | Jay W. Johnson | Q1684374 | kg:/m/0gxr0b | Jay | Johnson | 1943-09-30 | M | 15880 | W. | 01496 | |||||||||||||||
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 | ||||||||
S000510 | Adam Smith | S000510 | 400379 | 29768 | Adam Smith (politician) | Q350916 | kg:/m/024zj_ | Adam | Smith | 1965-06-15 | M | 21774 | Adam Smith | 01528 | 44329 | 845 | Adam Smith | N00007833 | [ "H6WA09025" ] |
471 | |||||||||
C000116 | Christopher Cannon | C000116 | 400059 | 29766 | Chris Cannon | Q166928 | kg:/m/02xgqp | Christopher | Cannon | 1950-10-20 | M | 10592 | B. | Chris | 01470 | 393 | N00006349 | [ "H6UT03042" ] |
|||||||||||
C000722 | Merrill Cook | C000722 | 400577 | 29765 | Merrill Cook | Q1922023 | kg:/m/0gldk2 | Merrill | Cook | 1946-05-06 | M | 11357 | 01475 | ||||||||||||||||
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" ] |
|||||||||||
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 | ||||||||
G000377 | Kay Granger | G000377 | 400157 | 29762 | Kay Granger | Q468807 | kg:/m/03tndx | Kay | Granger | 1943-01-18 | F | 14039 | Kay Granger | 01487 | 45709 | 334 | Kay Granger | N00008799 | [ "H6TX12060" ] |
264 | |||||||||
L000043 | Nicholas Lampson | L000043 | 400229 | 29761 | Nick Lampson | Q551506 | kg:/m/03fmdr | Nicholas | Lampson | 1945-02-14 | M | 16636 | V. | Nick | 01500 | 285 | N00005928 | [ "H6TX09033" ] |
|||||||||||
B000755 | Kevin Brady | B000755 | 400046 | 29760 | Kevin Brady | Q472241 | kg:/m/03tq00 | Kevin | Brady | 1955-04-11 | M | 9754 | P. | Kevin Brady (Texas) | 01468 | 45749 | 361 | Kevin Brady | N00005883 | [ "H6TX08100" ] |
166 | ||||||||
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 | ||||||||
T000424 | James Turner | T000424 | 400410 | 29758 | Jim Turner (politician) | Q1638994 | kg:/m/03l9vs | James | Turner | 1946-02-06 | M | 23153 | Jim | 01536 | N00005731 | ||||||||||||||
S000044 | Max Sandlin | S000044 | 400358 | 29757 | Max Sandlin | Q1118577 | kg:/m/029fvv | Max | Sandlin | 1952-09-29 | M | 21186 | A. | Jr. | 01523 | N00005724 | |||||||||||||
F000262 | Harold Ford | F000262 | 400138 | 29756 | Harold Ford Jr. | Q1289901 | kg:/m/02637k | Harold | Ford | 1970-05-11 | M | 13305 | E. | Jr. | 01483 | 1003 | N00003218 | ||||||||||||
J000082 | William Jenkins | J000082 | 400202 | 29755 | Bill Jenkins (politician) | Q1322331 | kg:/m/03tm5l | William | Jenkins | 1936-11-29 | M | 15798 | Lewis | Bill | 01494 | N00003202 | |||||||||||||
T000250 | John Thune | T000250 | 400546 | 29754 | John Thune | Q462981 | kg:/m/03ybyn | John | Thune | 1961-01-07 | M | 22937 | John Thune | 01534 | 45552 | 398 | S303 | John Thune | N00004572 | [ "S2SD00068", "H6SD00085" ] |
621 | [ { "title": "Assistant Senate Majority Leader", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Majority Whip", "chamber": "senate", "start": "2021-01-03", "end": "2021-01-20" }, { "title": "Senate Minority Whip", "chamber": "senate", "start": "2021-01-20" } ] |
|||||||
W000315 | Robert Weygand | W000315 | 400613 | 29753 | Robert Weygand | Q2159188 | kg:/m/0g26mn | Robert | Weygand | 1948-05-10 | M | 23593 | A. | 01538 |
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);