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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
P000373 | Joseph Pitts | P000373 | 400320 | 29752 | Joe Pitts | Q1674465 | kg:/m/03twrl | Joseph | Pitts | 1939-10-10 | M | 19742 | R. | Joseph R. Pitts | 01514 | 11706 | 265 | Joseph R. Pitts | N00001633 | [ "H6PA16197" ] |
414 | ||||||||
P000263 | John Peterson | P000263 | 400317 | 29751 | John E. Peterson | Q6045035 | kg:/m/03tvz8 | John | Peterson | 1938-12-25 | M | 19603 | E. | 01512 | 251 | N00001422 | [ "H6PA05091" ] |
||||||||||||
H000762 | Darlene Hooley | H000762 | 400186 | 29750 | Darlene Hooley | Q459718 | kg:/m/033tsd | Darlene | Hooley | 1939-04-04 | F | 15228 | 01491 | 429 | N00007700 | [ "H6OR05069" ] |
|||||||||||||
K000336 | Dennis Kucinich | K000336 | 400227 | 29748 | Dennis Kucinich | Q310588 | kg:/m/01l4vj | Dennis | Kucinich | 1946-10-08 | M | 16506 | J. | 01499 | 45684 | 318 | Dennis J. Kucinich | N00003572 | [ "H6OH23033" ] |
||||||||||
S001004 | Ted Strickland | S001004 | 400390 | 29747 | Ted Strickland | Q465295 | kg:/m/039rqy | Ted | Strickland | 1941-08-04 | M | 22381 | 01118 | N00003730 | |||||||||||||||
M000485 | Mike McIntyre | M000485 | 400266 | 29746 | Mike McIntyre | Q976487 | kg:/m/03g_v8 | Mike | McIntyre | 1956-08-06 | M | 17932 | Mike McIntyre | 01505 | 45960 | 153 | Mike McIntyre | N00002356 | [ "H8NC07044" ] |
362 | |||||||||
E000226 | Bob Etheridge | E000226 | 400125 | 29745 | Bob Etheridge | Q141670 | kg:/m/028s47 | Bob | Etheridge | 1941-08-07 | M | 12881 | R. | 01482 | 45577 | 118 | N00002269 | [ "H6NC02080" ] |
|||||||||||
M000309 | Carolyn McCarthy | M000309 | 400257 | 29744 | Carolyn McCarthy | Q458416 | kg:/m/024__d | Carolyn | McCarthy | 1944-01-05 | F | 17705 | 01503 | 45040 | 693 | Carolyn McCarthy | N00001148 | [ "H6NY04112" ] |
355 | ||||||||||
P000049 | Michael Pappas | P000049 | 408459 | 29743 | Michael James Pappas | Q1927997 | kg:/m/08st04 | Michael | Pappas | 1960-12-29 | M | 19338 | James | 01509 | |||||||||||||||
R000462 | Steven Rothman | R000462 | 400346 | 29742 | Steve Rothman | Q1286695 | kg:/m/02dvt1 | Steven | Rothman | 1952-10-14 | M | 20655 | R. | 01520 | 45112 | 481 | Steven R. Rothman | N00008619 | [ "H6NJ09165" ] |
||||||||||
P000096 | Bill Pascrell | P000096 | 400309 | 29741 | Bill Pascrell | Q529090 | kg:/m/03txs_ | Bill | Pascrell | 1937-01-25 | M | 19391 | J. | Bill Pascrell | Jr. | 01510 | 45543 | 478 | Bill Pascrell, Jr. | N00000751 | [ "H6NJ08118" ] |
403 | |||||||
S001078 | John Sununu | S001078 | 300095 | 29740 | John E. Sununu | Q1699908 | kg:/m/0170zz | John | Sununu | 1964-09-10 | M | 22472 | E. | 01532 | 617 | S296 | N00000397 | [ "S0NH00201" ] |
|||||||||||
G000152 | James Gibbons | G000152 | 400148 | 29739 | Jim Gibbons (American politician) | Q639207 | kg:/m/025hg8 | James | Gibbons | 1944-12-16 | M | 13754 | A. | Jim | 01485 | N00006652 | |||||||||||||
H000605 | Rick Hill | H000605 | 400587 | 29738 | Rick Hill | Q443029 | kg:/m/0gl9r0 | Rick | Hill | 1946-12-30 | M | 15034 | 01489 | N00004644 | |||||||||||||||
H000948 | Kenny Hulshof | H000948 | 400190 | 29737 | Kenny Hulshof | Q534222 | kg:/m/03tnl1 | Kenny | Hulshof | 1958-05-22 | M | 15455 | C. | 01492 | 423 | N00008032 | [ "H4MO09046" ] |
||||||||||||
E000172 | Jo Ann Emerson | E000172 | 400121 | 29736 | Jo Ann Emerson | Q437667 | kg:/m/03tnqk | Jo Ann | Emerson | 1950-09-16 | F | 12803 | H. | 01481 | 46627 | 903 | Jo Ann Emerson | N00005090 | [ "H6MO08084" ] |
232 | |||||||||
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" } ] |
|||||||
P000323 | Charles Pickering | P000323 | 400319 | 29734 | Chip Pickering | Q452392 | kg:/m/033trc | Charles | Pickering | 1963-08-10 | M | 19675 | W. | Chip | Jr. | 01513 | 279 | N00003341 | [ "H6MS03046" ] |
||||||||||
K000180 | Carolyn Kilpatrick | K000180 | 400217 | 29733 | Carolyn Cheeks Kilpatrick | Q461626 | kg:/m/03l91q | Carolyn | Kilpatrick | 1945-06-25 | F | 16302 | Cheeks | 01497 | 522 | N00004005 | [ "H6MI15127" ] |
||||||||||||
S000770 | Debbie Stabenow | S000770 | 300093 | 29732 | Debbie Stabenow | Q241092 | kg:/m/01xh64 | Debbie | Stabenow | 1950-04-29 | F | 22090 | Ann | Debbie Stabenow | 01531 | 45451 | 515 | S284 | Debbie Stabenow | N00004118 | [ "S8MI00281", "H6MI08163" ] |
612 | [ { "title": "Senate Democratic Policy & Communications Committee Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Democratic Policy & Communications Committee Chair", "chamber": "senate", "start": "2021-01-03" } ] |
||||||
D000210 | William Delahunt | D000210 | 400102 | 29731 | Bill Delahunt | Q862056 | kg:/m/028vt9 | William | Delahunt | 1941-07-18 | M | 12094 | D. | Bill | 01480 | 46620 | 1017 | N00000280 | [ "H2MA11060" ] |
||||||||||
T000266 | John Tierney | T000266 | 400407 | 29730 | John F. Tierney | Q1700027 | kg:/m/02d4pj | John | Tierney | 1951-09-18 | M | 22957 | F. | 01535 | 37546 | 553 | John F. Tierney | N00000226 | [ "H4MA06033" ] |
494 | |||||||||
M000312 | James McGovern | M000312 | 400263 | 29729 | Jim McGovern (American politician) | Q1337459 | kg:/m/028vn7 | James | McGovern | 1959-11-20 | M | 17711 | P. | Jim | Jim McGovern (Massachusetts) | 01504 | 45976 | 552 | James P. McGovern | N00000179 | [ "H4MA03022" ] |
360 | |||||||
A000357 | Thomas Allen | A000357 | 400007 | 29728 | Tom Allen (Maine politician) | Q1855866 | kg:/m/025k1c | Thomas | Allen | 1945-04-16 | M | 8751 | H. | Tom | 01461 | 380 | N00000469 | [ "H6ME01157" ] |
|||||||||||
J000110 | Christopher John | J000110 | 400203 | 29727 | Chris John | Q1077380 | kg:/m/025j_4 | Christopher | John | 1960-01-05 | M | 15831 | Chris | 01495 | N00008038 | ||||||||||||||
C000735 | John Cooksey | C000735 | 400522 | 29726 | John Cooksey | Q1699656 | kg:/m/0df2m0 | John | Cooksey | 1941-08-20 | M | 11373 | 01476 | ||||||||||||||||
N000143 | Anne Northup | N000143 | 400294 | 29725 | Anne Northup | Q511389 | kg:/m/025jg9 | Anne | Northup | 1948-01-22 | F | 19010 | Meagher | 01508 | N00003392 | ||||||||||||||
S000662 | Vincent Snowbarger | S000662 | 410136 | 29724 | Vince Snowbarger | Q456213 | kg:/m/0f1ts0 | Vincent | Snowbarger | 1949-09-16 | M | 21953 | K. | 01529 | |||||||||||||||
R000566 | Jim Ryun | R000566 | 400353 | 29723 | Jim Ryun | Q1345537 | kg:/m/0m6p3 | Jim | Ryun | 1947-04-29 | M | 20778 | R. | 01521 | N00005218 | ||||||||||||||
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 | ||||||||
B000652 | Leonard Boswell | B000652 | 400042 | 29721 | Leonard Boswell | Q1610417 | kg:/m/025b6f | Leonard | Boswell | 1934-01-10 | M | 9629 | L. | 01466 | 45520 | 384 | Leonard L. Boswell | N00004208 | [ "H6IA03144" ] |
||||||||||
C000191 | Julia Carson | C000191 | 400067 | 29720 | Julia Carson | Q461754 | kg:/m/0257f6 | Julia | Carson | 1938-07-08 | F | 10693 | M. | 01473 | 359 | N00003758 | [ "H6IN10141" ] |
||||||||||||
P000171 | Edward Pease | P000171 | 400602 | 29719 | Edward A. Pease | Q1291489 | kg:/m/0d5kjj | Edward | Pease | 1951-05-22 | M | 19490 | A. | 01511 | |||||||||||||||
S000364 | John Shimkus | S000364 | 400373 | 29718 | John Shimkus | Q1701747 | kg:/m/02573y | John | Shimkus | 1958-02-21 | M | 21589 | M. | John M. Shimkus | 01527 | 30623 | 246 | John Shimkus | N00004961 | [ "H2IL20042" ] |
464 | ||||||||
D000096 | Danny Davis | D000096 | 400093 | 29717 | Danny K. Davis | Q1164657 | kg:/m/0256k7 | Danny | Davis | 1941-09-06 | M | 11949 | K. | Danny K. Davis | 01477 | 44325 | 233 | Danny K. Davis | N00004884 | [ "H4IL07037" ] |
209 | ||||||||
B000518 | Rod Blagojevich | B000518 | 400518 | 29716 | Rod Blagojevich | Q151891 | kg:/m/0264ht | Rod | Blagojevich | 1956-12-10 | M | 9443 | 01463 | N00004816 | |||||||||||||||
W000314 | Robert Wexler | W000314 | 400430 | 29715 | Robert Wexler | Q983116 | kg:/m/02530r | Robert | Wexler | 1961-01-02 | M | 23591 | 01537 | 882 | N00002905 | [ "H6FL19038" ] |
|||||||||||||
D000114 | James Davis | D000114 | 400094 | 29714 | Jim Davis (Florida politician) | Q519908 | kg:/m/0252mn | James | Davis | 1957-10-11 | M | 11972 | Jim | 01478 | N00002926 | ||||||||||||||
B000716 | Allen Boyd | B000716 | 400044 | 29713 | Allen Boyd | Q2600908 | kg:/m/0251w9 | Allen | Boyd | 1945-06-06 | M | 9711 | Jr. | 01467 | 46164 | 729 | N00002743 | [ "H6FL00046" ] |
|||||||||||
M000090 | James Maloney | M000090 | 400508 | 29712 | James H. Maloney | Q1680494 | kg:/m/0ddbbq | James | Maloney | 1948-09-17 | M | 17442 | 01502 | ||||||||||||||||
S000112 | Bob Schaffer | S000112 | 400507 | 29711 | Bob Schaffer | Q657837 | kg:/m/06kjf3 | Bob | Schaffer | 1962-07-24 | M | 21274 | 01524 | 568 | N00006182 | ||||||||||||||
D000197 | Diana DeGette | D000197 | 400101 | 29710 | Diana DeGette | Q437159 | kg:/m/024z95 | Diana | DeGette | 1957-07-29 | F | 12076 | L. | Diana DeGette | 01479 | 90293 | 561 | Diana DeGette | N00006134 | [ "H6CO01141" ] |
214 | ||||||||
S000030 | Loretta Sanchez | S000030 | 400356 | 29709 | Loretta Sanchez | Q469094 | kg:/m/0jbty | Loretta | Sanchez | 1960-01-07 | F | 21168 | B. | 01522 | 45639 | 203 | Loretta Sanchez | N00008274 | [ "H6CA46033" ] |
449 | [ { "name": "Linda Sanchez", "relation": "sister" } ] |
||||||||
R000386 | James Rogan | R000386 | 400605 | 29708 | James E. Rogan | Q1517351 | kg:/m/03gq7vs | James | Rogan | 1957-08-21 | M | 20562 | E. | 01519 | |||||||||||||||
S000344 | Brad Sherman | S000344 | 400371 | 29707 | Brad Sherman | Q672919 | kg:/m/024tkr | Brad | Sherman | 1954-10-24 | M | 21565 | J. | Brad Sherman | 01526 | 45124 | 142 | Brad Sherman | N00006897 | [ "H6CA24113" ] |
462 | ||||||||
C000134 | Walter Capps | C000134 | 402284 | 29706 | Walter Capps | Q1717689 | kg:/m/07s4xf | Walter | Capps | 1934-05-05 | M | 10617 | Holden | 01472 | |||||||||||||||
T000057 | Ellen Tauscher | T000057 | 400396 | 29705 | Ellen Tauscher | Q459624 | kg:/m/024skq | Ellen | Tauscher | 1951-11-15 | F | 22703 | O. | 01533 | 94 | N00007422 | [ "H6CA10088" ] |
||||||||||||
H001014 | Asa Hutchinson | H001014 | 400588 | 29704 | Asa Hutchinson | Q720121 | kg:/m/04fbt1 | Asa | Hutchinson | 1950-12-03 | M | 15533 | Asa Hutchinson | 01493 | |||||||||||||||
S000672 | Victor Snyder | S000672 | 400383 | 29703 | Vic Snyder | Q715355 | kg:/m/01xb5_ | Victor | Snyder | 1947-09-27 | M | 21968 | F. | Vic | 01530 | 45722 | 434 | N00008188 | [ "H6AR02203" ] |
||||||||||
B000420 | Robert Berry | B000420 | 400026 | 29702 | Robert Marion Berry | Q715399 | kg:/m/024s3g | Robert | Berry | 1942-08-27 | M | 9322 | Marion | Marion | 01462 | 45115 | 430 | N00005455 | [ "H6AR01072" ] |
||||||||||
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 | ||||||||
R000258 | Bob Riley | R000258 | 400501 | 29700 | Bob Riley | Q438010 | kg:/m/020z3g | Bob | Riley | 1944-10-03 | M | 20405 | 01517 | ||||||||||||||||
B000574 | Earl Blumenauer | B000574 | 400033 | 29588 | Earl Blumenauer | Q748066 | kg:/m/033tw8 | Earl | Blumenauer | 1948-08-16 | M | 9518 | Earl Blumenauer | 00099 | 43809 | 367 | Earl Blumenauer | N00007727 | [ "H6OR03064" ] |
152 | |||||||||
C000984 | Elijah Cummings | C000984 | 400090 | 29587 | Elijah Cummings | Q934898 | kg:/m/025k9h | Elijah | Cummings | 1951-01-18 | M | 11684 | E. | Elijah Cummings | 00256 | 43300 | 345 | Elijah E. Cummings | N00001971 | [ "H6MD07160" ] |
204 | ||||||||
M000714 | Juanita Millender-McDonald | M000714 | 400275 | 29586 | Juanita Millender-McDonald | Q461974 | kg:/m/024t_d | Juanita | Millender-McDonald | 1938-09-07 | F | 18225 | 00805 | N00006811 | [ "H6CA37222" ] |
||||||||||||||
J000283 | Jesse Jackson | J000283 | 400198 | 29585 | Jesse Jackson Jr. | Q609189 | kg:/m/0255y7 | Jesse | Jackson | 1965-03-11 | M | 16055 | Louis | Jr. | 00587 | 39073 | 72 | Jesse L. Jackson Jr. | N00012457 | [ "H6IL02124" ] |
|||||||||
C000962 | Barbara Cubin | C000962 | 400088 | 29584 | Barbara Cubin | Q449713 | kg:/m/024p3f | Barbara | Cubin | 1946-11-30 | F | 11656 | L. | 00254 | 22044 | N00006242 | [ "H4WY00055" ] |
||||||||||||
N000054 | Mark Neumann | N000054 | 408142 | 29583 | Mark Neumann | Q1900315 | kg:/m/03tzvg | Mark | Neumann | 1954-02-27 | M | 18903 | W. | 00861 | 29135 | N00009160 | |||||||||||||
T000048 | Randy Tate | T000048 | 410636 | 29582 | Randy Tate | Q2130820 | kg:/m/027l921 | Randy | Tate | 1965-11-23 | M | 22693 | J. | 01138 | |||||||||||||||
N000051 | George Nethercutt | N000051 | 400292 | 29581 | George Nethercutt | Q164014 | kg:/m/025912 | George | Nethercutt | 1944-10-07 | M | 18898 | R. | Jr. | 00860 | N00008166 | |||||||||||||
H000329 | Doc Hastings | H000329 | 400171 | 29580 | Doc Hastings | Q5793043 | kg:/m/02592l | Doc | Hastings | 1941-02-07 | M | 14689 | 00512 | 31324 | 22318 | Doc Hastings | N00009157 | [ "H2WA04041" ] |
277 | ||||||||||
M000669 | Jack Metcalf | M000669 | 400598 | 29578 | Jack Metcalf | Q1350330 | kg:/m/03dzkb | Jack | Metcalf | 1927-11-30 | M | 18160 | 00792 | ||||||||||||||||
W000391 | Richard White | W000391 | 411550 | 29577 | Rick White (politician) | Q1575054 | kg:/m/03drww | Richard | White | 1953-11-06 | M | 23679 | Alan | Rick | 01220 | ||||||||||||||
D000136 | Thomas Davis | D000136 | 400098 | 29576 | Tom Davis (Virginia politician) | Q2425943 | kg:/m/05bh59 | Thomas | Davis | 1949-01-05 | M | 12002 | M. | Tom | III | 00274 | 21935 | N00002045 | [ "H4VA11020" ] |
||||||||||
G000408 | Enid Greene Waldholtz | G000408 | 411214 | 29575 | Enid Greene Mickelsen | Q525308 | kg:/m/03t806 | Enid | Greene Waldholtz | 1958-06-05 | F | 14082 | [ "W000790" ] |
01192 | Enid Greene Waldholtz | ||||||||||||||
B000400 | Ken Bentsen | B000400 | 400550 | 29574 | Ken Bentsen Jr. | Q1738577 | kg:/m/085bsl | Ken | Bentsen | 1959-06-03 | M | 9294 | 00079 | ||||||||||||||||
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 | |||||||||
T000238 | Mac Thornberry | T000238 | 400404 | 29572 | Mac Thornberry | Q539444 | kg:/m/03dnvd | Mac | Thornberry | 1958-07-15 | M | 22922 | M. | Mac Thornberry | 01155 | 36814 | 21706 | Mac Thornberry | N00006052 | [ "H4TX13014" ] |
491 | ||||||||
D000399 | Lloyd Doggett | D000399 | 400111 | 29571 | Lloyd Doggett | Q363817 | kg:/m/03flzn | Lloyd | Doggett | 1946-10-06 | M | 12328 | A. | Lloyd Doggett | 00303 | 36810 | 21689 | Lloyd Doggett | N00006023 | [ "H4TX10028" ] |
224 | ||||||||
S000937 | Steve Stockman | S000937 | 410396 | 29570 | Steve Stockman | Q1605321 | kg:/m/03s7kz | Steve | Stockman | 1956-11-14 | M | 22297 | Steve Stockman | 01114 | 3626 | 21703 | Steve Stockman | N00005918 | [ "H6TX22143", "H0TX09077" ] |
1731 | |||||||||
B000996 | Ed Bryant | B000996 | 400549 | 29569 | Ed Bryant | Q1282293 | kg:/m/025gt0 | Ed | Bryant | 1948-09-07 | M | 10062 | 00141 | ||||||||||||||||
H000615 | Van Hilleary | H000615 | 400547 | 29568 | Van Hilleary | Q521779 | kg:/m/0451c8 | Van | Hilleary | 1959-06-20 | M | 15045 | 00538 | ||||||||||||||||
W000119 | Zach Wamp | W000119 | 400421 | 29567 | Zach Wamp | Q139389 | kg:/m/03tlrz | Zach | Wamp | 1957-10-28 | M | 23354 | 01199 | 36792 | 21995 | N00003159 | [ "H2TN03052" ] |
||||||||||||
G000359 | Lindsey Graham | G000359 | 300047 | 29566 | Lindsey Graham | Q22212 | kg:/m/01_pdg | Lindsey | Graham | 1955-07-09 | M | 14015 | O. | Lindsey Graham | 00452 | 36782 | 21992 | S293 | Lindsey Graham | N00009975 | [ "S0SC00149", "H4SC03087" ] |
569 | |||||||
S000051 | Marshall Sanford | S000051 | 400607 | 29565 | Mark Sanford | Q11669 | kg:/m/02c6ck | Marshall | Sanford | 1960-05-28 | M | 21195 | Mark | Mark Sanford | 01012 | 6513 | 21991 | Mark Sanford | N00002424 | [ "H4SC01073" ] |
2046 | ||||||||
K000113 | Patrick Kennedy | K000113 | 400215 | 29564 | Patrick J. Kennedy | Q948920 | kg:/m/0202g7 | Patrick | Kennedy | 1967-07-14 | M | 16218 | Joseph | 00627 | 17987 | 22207 | N00000360 | [ "H4RI01034" ] |
|||||||||||
E000187 | Philip English | E000187 | 400123 | 29563 | Phil English | Q5712486 | kg:/m/03tt58 | Philip | English | 1956-06-20 | M | 12828 | Phil | 00347 | 21865 | N00001427 | [ "H4PA21051" ] |
||||||||||||
M000212 | Frank Mascara | M000212 | 400545 | 29562 | Frank Mascara | Q959210 | kg:/m/09mxzc | Frank | Mascara | 1930-01-19 | M | 17585 | 00745 | ||||||||||||||||
D000482 | Michael Doyle | D000482 | 400114 | 29561 | Mike Doyle (American politician) | Q1344200 | kg:/m/03tqjg | Michael | Doyle | 1953-08-05 | M | 12436 | F. | Michael F. Doyle | 00316 | 36774 | 21853 | Michael F. Doyle | N00001373 | [ "H4PA18131" ] |
226 | ||||||||
F000332 | Jon Fox | F000332 | 404280 | 29560 | Jon D. Fox | Q6270560 | kg:/m/0dlxsf | Jon | Fox | 1947-04-22 | M | 13392 | D. | 00406 | |||||||||||||||
F000043 | Chaka Fattah | F000043 | 400130 | 29559 | Chaka Fattah | Q1059265 | kg:/m/03dsph | Chaka | Fattah | 1956-11-21 | M | 13018 | Chaka Fattah | 00371 | 36763 | 21850 | Chaka Fattah | N00001746 | [ "H2PA02055" ] |
241 | |||||||||
B001063 | Jim Bunn | B001063 | 402010 | 29558 | Jim Bunn | Q1689051 | kg:/m/0ksqwn | Jim | Bunn | 1956-12-12 | M | 10146 | 00145 | ||||||||||||||||
C000737 | Wes Cooley | C000737 | 402858 | 29557 | Wes Cooley | Q2563711 | kg:/m/03t07t | Wes | Cooley | 1932-03-28 | M | 11376 | 00230 | ||||||||||||||||
W000210 | J.C. Watts | W000210 | 400541 | 29556 | J. C. Watts | Q459176 | kg:/m/02k7d7 | J.C. | Watts | 1957-11-18 | M | 23468 | 01208 | N00005528 | |||||||||||||||
C000560 | Thomas Coburn | C000560 | 400576 | 29555 | Tom Coburn | Q509093 | kg:/m/03wnjr | Thomas | Coburn | 1948-03-14 | M | 11151 | A. | Tom Coburn | 00212 | 36751 | 22085 | S301 | Tom Coburn | N00005601 | [ "S4OK00174", "H4OK02048" ] |
623 | |||||||
L000096 | Steve Largent | L000096 | 400593 | 29554 | Steve Largent | Q332247 | kg:/m/01xyq6 | Steve | Largent | 1954-09-28 | M | 16714 | 00664 | ||||||||||||||||
L000553 | Steven LaTourette | L000553 | 400235 | 29553 | Steve LaTourette | Q973330 | kg:/m/034cg0 | Steven | LaTourette | 1954-07-22 | M | 17286 | C. | 00667 | 36748 | 21798 | Steven C. LaTourette | N00003545 | [ "H4OH19036" ] |
||||||||||
N000081 | Robert Ney | N000081 | 400293 | 29552 | Bob Ney | Q1385763 | kg:/m/039tvl | Robert | Ney | 1954-07-05 | M | 18935 | William | Bob | 00862 | N00003532 | |||||||||||||
C000903 | Frank Cremeans | C000903 | 403015 | 29551 | Frank Cremeans | Q5486027 | kg:/m/03lksw | Frank | Cremeans | 1943-04-05 | M | 11585 | 00251 | ||||||||||||||||
C000266 | Steve Chabot | C000266 | 400071 | 29550 | Steve Chabot | Q506694 | kg:/m/0343vk | Steve | Chabot | 1953-01-22 | M | 10791 | J. | Steve Chabot | 00186 | 36705 | 21790 | Steve Chabot | N00003689 | [ "H8OH01043" ] |
188 | ||||||||
M001134 | Sue Myrick | M001134 | 400288 | 29549 | Sue Myrick | Q367796 | kg:/m/03g_vm | Sue | Myrick | 1941-08-01 | F | 18745 | W. | 00849 | 1172 | 21789 | Sue Wilkins Myrick | N00002327 | [ "H4NC09106" ] |
||||||||||
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 | |||||||
H000452 | Fred Heineman | H000452 | 405317 | 29547 | Fred Heineman | Q1312401 | kg:/m/04fcrb | Fred | Heineman | 1929-12-28 | M | 14843 | 00527 | ||||||||||||||||
J000255 | Walter Jones | J000255 | 400209 | 29546 | Walter B. Jones Jr. | Q512537 | kg:/m/03g_r5 | Walter | Jones | 1943-02-10 | M | 16015 | B. | Walter B. Jones | Jr. | 00612 | 36693 | 21785 | Walter B. Jones | N00002299 | [ "H2NC01081" ] |
309 | [ { "name": "Walter Beaman Jones Sr.", "relation": "son" } ] |
||||||
F000426 | David Funderburk | F000426 | 404367 | 29545 | David Funderburk | Q1174484 | kg:/m/09v5nl | David | Funderburk | 1944-04-28 | M | 13511 | 00421 | ||||||||||||||||
K000078 | Sue Kelly | K000078 | 400213 | 29544 | Sue W. Kelly | Q275237 | kg:/m/0g9lfk | Sue | Kelly | 1936-09-26 | F | 16178 | W. | 00624 | N00001020 | ||||||||||||||
F000387 | Dan Frisa | F000387 | 404332 | 29543 | Dan Frisa | Q723209 | kg:/m/08ksdr | Dan | Frisa | 1955-04-27 | M | 13460 | 00417 | ||||||||||||||||
F000372 | Rodney Frelinghuysen | F000372 | 400142 | 29541 | Rodney Frelinghuysen | Q338190 | kg:/m/03bktp | Rodney | Frelinghuysen | 1946-04-29 | M | 13440 | P. | 00414 | 37781 | 22177 | Rodney P. Frelinghuysen | N00000684 | [ "H2NJ05014" ] |
252 | [ { "name": "Peter Hood Ballantine Frelinghuysen Jr.", "relation": "son" }, { "name": "Frederick Frelinghuysen", "relation": "great great grandson" }, { "name": "Theodore Frelinghuysen", "relation": "great great great nephew" } ] |
||||||||
M000207 | William Martini | M000207 | 407226 | 29540 | William J. Martini | Q1416536 | kg:/m/08st5c | William | Martini | 1947-02-10 | M | 17579 | J. | 00744 | |||||||||||||||
L000554 | Frank LoBiondo | L000554 | 400244 | 29539 | Frank LoBiondo | Q616850 | kg:/m/025y0c | Frank | LoBiondo | 1946-05-12 | M | 17288 | A. | Frank LoBiondo | 00699 | 30867 | 21890 | Frank A. LoBiondo | N00000851 | [ "H2NJ02037" ] |
344 |
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);