legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by name_nickname descending
This data as json, copyable, CSV (advanced)
Suggested facets: name_suffix, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B000339 | John Bell | B000339 | 401332 | 605 | John Bell (Ohio politician) | Q11774450 | kg:/m/02rm4pr | John | Bell | 1796-06-19 | M | 9215 | of Ohio | ||||||||||||||||
A000123 | Heman Allen | A000123 | 400779 | 106 | Heman Allen (of Milton) | Q1604686 | kg:/m/02rldzl | Heman | Allen | 1777-06-14 | M | 8432 | of Milton | ||||||||||||||||
A000122 | Heman Allen | A000122 | 400778 | 107 | Heman Allen (of Colchester) | Q251718 | kg:/m/02rldz7 | Heman | Allen | 1779-02-23 | M | 8431 | of Colchester | ||||||||||||||||
C000185 | Charles Carroll | C000185 | 402332 | 1536 | Charles Carroll of Carrollton | Q466009 | kg:/m/01jtw2 | Charles | Carroll | 1737-09-19 | M | 10684 | of Carrollton | ||||||||||||||||
S001173 | Zachary Space | S001173 | 412229 | 20741 | Zack Space | Q139887 | kg:/m/0bfzwz | Zachary | Space | 1961-01-27 | M | 22602 | T. | Zack | 01871 | 1022842 | 56847 | N00027902 | [ "H6OH18157" ] |
||||||||||
D000310 | W. Dickerson | D000310 | 403431 | 2563 | William Worth Dickerson | Q2581121 | kg:/m/02rk0gr | W. | Dickerson | 1851-11-29 | M | 12212 | W. | William Worth | |||||||||||||||
A000296 | Samuel Arnold | A000296 | 400938 | 248 | Samuel W. Arnold | Q183164 | kg:/m/02rz87g | Samuel | Arnold | 1879-09-21 | M | 8671 | Washington | Wat | |||||||||||||||
H000786 | Walter Horan | H000786 | 405636 | 4579 | Walt Horan | Q2543308 | kg:/m/0kt484 | Walter | Horan | 1898-10-15 | M | 15256 | Franklin | Walt | |||||||||||||||
H000528 | Walter Herger | H000528 | 400176 | 15420 | Wally Herger | Q1368417 | kg:/m/024sfb | Walter | Herger | 1945-05-20 | M | 14939 | Wally | 00533 | 12557 | 26728 | Wally Herger | N00007584 | [ "H6CA02010" ] |
||||||||||
M000833 | Wilmer Mizell | M000833 | 407808 | 12026 | Wilmer Mizell | Q2545200 | kg:/m/060lgw | Wilmer | Mizell | 1930-08-13 | M | 18377 | David | Vinegar Bend | 00819 | ||||||||||||||
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" ] |
||||||||||
M000111 | Vannoy Manning | M000111 | 407135 | 5965 | Van. H. Manning | Q1308709 | kg:/m/02ry2fq | Vannoy | Manning | 1839-07-26 | M | 17467 | Hartrog | Van | |||||||||||||||
A000277 | Samuel Arentz | A000277 | 400917 | 228 | Samuel S. Arentz | Q225580 | kg:/m/02730nt | Samuel | Arentz | 1879-01-08 | M | 8650 | Shaw | Ulysses | |||||||||||||||
G000594 | Ernest Gonzales | G000594 | 456849 | kg:/g/11fs52clcr | Ernest | Gonzales | 1980-10-10 | M | Anthony | Tony | Tony Gonzales | N00044592 | [ "H0TX35015" ] |
||||||||||||||||
C000684 | Thomas Connally | C000684 | 402810 | 1986 | Tom Connally | Q912806 | kg:/m/089hd7 | Thomas | Connally | 1877-08-19 | M | 11312 | Terry | Tom | |||||||||||||||
D000064 | Thomas Daschle | D000064 | 300031 | 14617 | Tom Daschle | Q443640 | kg:/m/07lv9 | Thomas | Daschle | 1947-12-09 | M | 11910 | A. | Tom | 00267 | S185 | N00004583 | ||||||||||||
D000217 | Thomas DeLay | D000217 | 400104 | 15094 | Tom DeLay | Q180390 | kg:/m/01fnd0 | Thomas | DeLay | 1947-04-08 | M | 12103 | Dale | Tom | 00282 | N00005892 | |||||||||||||
O000165 | Thomas Osborne | O000165 | 400303 | 20126 | Tom Osborne | Q2439945 | kg:/m/022j57 | Thomas | Osborne | 1937-02-23 | M | 19272 | William | Tom | 01658 | N00012970 | |||||||||||||
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" ] |
|||||||||||
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" ] |
||||||||||
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" ] |
|||||||||||
H000206 | Thomas Harkin | H000206 | 300051 | 14230 | Tom Harkin | Q465617 | kg:/m/020ynq | Thomas | Harkin | 1939-11-19 | M | 14542 | Tom | Tom Harkin | 00501 | 2005 | 53294 | S172 | Tom Harkin | N00004207 | [ "S4IA00020", "P20000741" ] |
573 | |||||||
P000265 | Thomas Petri | P000265 | 400318 | 14675 | Tom Petri | Q969776 | kg:/m/024tmj | Thomas | Petri | 1940-05-28 | M | 19606 | E. | Tom | Tom Petri | 00912 | 3190 | 27139 | Thomas E. Petri | N00004426 | [ "H0WI06061" ] |
412 | |||||||
M000839 | Anthony Moffett | M000839 | 407813 | 14258 | Toby Moffett | Q2438226 | kg:/m/0kr__c | Anthony | Moffett | 1944-08-18 | M | 18384 | John | Toby | Jr. | 00821 | |||||||||||||
O000098 | Thomas O’Neill | O000098 | 408307 | 7081 | Tip O'Neill | Q2094491 | kg:/m/01ncrk | Thomas | O’Neill | 1912-12-09 | M | 19187 | Phillip | Tip | Jr. | 00874 | |||||||||||||
V000006 | Itimous Valentine | V000006 | 411065 | 15073 | Tim Valentine | Q2434337 | kg:/m/04fbm0 | Itimous | Valentine | 1926-03-15 | M | 20886 | Thaddeus, Jr., | Tim | 01178 | ||||||||||||||
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 | ||||||||
M001147 | Thaddeus McCotter | M001147 | 400260 | 20332 | Thaddeus McCotter | Q977920 | kg:/m/03tkzz | Thaddeus | McCotter | 1965-08-22 | M | 18766 | G. | Thad | 01732 | 19847 | N00013808 | [ "H2MI00037" ] |
|||||||||||
K000105 | Edward Kennedy | K000105 | 300059 | 10808 | Ted Kennedy | Q134549 | kg:/m/0194xc | Edward | Kennedy | 1932-02-22 | M | M. | Ted | 01377 | 53305 | S055 | N00000308 | [ "S6MA00015" ] |
|||||||||||
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 | |||||||
B000823 | Henry Bridges | B000823 | 401780 | 1027 | Styles Bridges | Q434228 | kg:/m/03tgz3 | Henry | Bridges | 1898-09-09 | M | Styles | Styles | ||||||||||||||||
S001136 | William Symington | S001136 | 410586 | 9141 | Stuart Symington | Q962660 | kg:/m/03fj2d | William | Symington | 1901-06-26 | M | Stuart | Stuart | 01444 | |||||||||||||||
B000204 | Harry Bartlett | B000204 | 401203 | 15002 | Steve Bartlett | Q185480 | kg:/m/02fhlw | Harry | Bartlett | 1947-09-19 | M | 9037 | Stephen | Steve | 00061 | ||||||||||||||
B001203 | Stephen Buyer | B001203 | 400056 | 29350 | Steve Buyer | Q465824 | kg:/m/02578l | Stephen | Buyer | 1958-11-26 | M | 10322 | E. | Steve | 00160 | 26475 | 26854 | N00003924 | [ "H2IN05025" ] |
||||||||||
P000588 | Stevan Pearce | P000588 | 400313 | 20337 | Steve Pearce (politician) | Q947168 | kg:/m/033t2h | Stevan | Pearce | 1947-08-24 | M | 20015 | E. | Steve | Steve Pearce | 01738 | 12063 | 10655 | Stevan Pearce | N00012672 | [ "H2NM02126", "S0NM00041" ] |
407 | |||||||
M000865 | Gillespie Montgomery | M000865 | 407838 | 11035 | Sonny Montgomery | Q2302283 | kg:/m/06lzqq | Gillespie | Montgomery | 1920-08-05 | M | 18421 | V. | Sonny | 00827 | ||||||||||||||
B000029 | Louis Bafalis | B000029 | 401034 | 14003 | Skip Bafalis | Q1350106 | kg:/m/02pz0hx | Louis | Bafalis | 1929-09-28 | M | 8812 | Arthur | Skip | 00042 | ||||||||||||||
B000586 | Sherwood Boehlert | B000586 | 400035 | 15007 | Sherwood Boehlert | Q7495500 | kg:/m/03dghb | Sherwood | Boehlert | 1936-09-28 | M | 9534 | L. | Sherry | 00101 | N00001267 | |||||||||||||
B000028 | Henry Baesler | B000028 | 401033 | 29353 | Scotty Baesler | Q2261433 | kg:/m/05byc4 | Henry | Baesler | 1941-07-09 | M | 8811 | Scott | Scotty | 00041 | ||||||||||||||
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 | ||||||||
J000013 | Henry Jackson | J000013 | 405920 | 4851 | Henry M. Jackson | Q1345201 | kg:/m/01lm31 | Henry | Jackson | 1912-05-31 | M | 15709 | Martin | Scoop | 01370 | ||||||||||||||
B000953 | Samuel Brownback | B000953 | 300013 | 29523 | Sam Brownback | Q317618 | kg:/m/0202ny | Samuel | Brownback | 1956-09-12 | M | 10006 | D. | Sam | 00137 | 21952 | S249 | N00005244 | [ "S6KS00122" ] |
||||||||||
B000486 | Cecil Bishop | B000486 | 401467 | 731 | C. W. Bishop | Q5006940 | kg:/m/02rl0x8 | Cecil | Bishop | 1890-06-29 | M | 9406 | William | Runt | |||||||||||||||
B000647 | Rudolph Boschwitz | B000647 | 401611 | 14701 | Rudy Boschwitz | Q216174 | kg:/m/01jhz_ | Rudolph | Boschwitz | 1930-11-07 | M | Eli | Rudy | 01288 | S135 | ||||||||||||||
A000024 | Edwin Adair | A000024 | 400685 | 18 | E. Ross Adair | Q1273564 | kg:/m/02rkfks | Edwin | Adair | 1907-12-14 | M | 8287 | Ross | ||||||||||||||||
P000583 | Ronald Paul | P000583 | 400311 | 14290 | Ron Paul | Q15257 | kg:/m/016lh0 | Ronald | Paul | 1935-08-20 | M | 20005 | E. | Ron | 00900 | 45747 | 296 | Ron Paul | N00005906 | [ "H6TX22101" ] |
|||||||||
T000034 | Robert Tallon | T000034 | 410623 | 15068 | Robin Tallon | Q2159908 | kg:/m/0265rfm | Robert | Tallon | 1946-08-08 | M | 22675 | Mooneyhan | Robin | Jr. | 01136 | |||||||||||||
S001152 | Robert Simmons | S001152 | 400375 | 20109 | Rob Simmons | Q2603131 | kg:/m/024zmb | Robert | Simmons | 1943-02-11 | M | 22564 | Ruhl | Rob | 01642 | N00009608 | |||||||||||||
A000210 | Robert Andrews | A000210 | 400008 | 29132 | Rob Andrews | Q980649 | kg:/m/032mpy | Robert | Andrews | 1957-08-04 | M | 8551 | E. | Rob | 00021 | 19670 | 26949 | Robert E. Andrews | N00000826 | [ "H0NJ01066", "S8NJ00392" ] |
131 | ||||||||
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 | ||||||
W000391 | Richard White | W000391 | 411550 | 29577 | Rick White (politician) | Q1575054 | kg:/m/03drww | Richard | White | 1953-11-06 | M | 23679 | Alan | Rick | 01220 | ||||||||||||||
S000059 | Richard Santorum | S000059 | 300085 | 29141 | Rick Santorum | Q155985 | kg:/m/01fgd3 | Richard | Santorum | 1958-05-10 | M | 21206 | J. | Rick | Rick Santorum | 01015 | 27054 | S244 | N00001380 | ||||||||||
B000657 | Frederick Boucher | B000657 | 400043 | 15010 | Rick Boucher | Q2151547 | kg:/m/01_k5m | Frederick | Boucher | 1946-08-01 | M | 9636 | C. | Rick | 00113 | 6736 | 27119 | N00002171 | [ "H2VA09010" ] |
||||||||||
C001087 | Eric Crawford | C001087 | 412400 | 21106 | Rick Crawford (politician) | Q2151554 | kg:/m/0czb3pp | Eric | Crawford | 1966-01-22 | M | 11831 | A. | Rick | Rick Crawford | 01989 | 623259 | 119208 | Eric A. "Rick" Crawford | N00030770 | [ "H0AR01083" ] |
1414 | |||||||
T000243 | Raymond Thornton | T000243 | 410821 | 14058 | Ray Thornton | Q2133994 | kg:/m/026j600 | Raymond | Thornton | 1928-07-16 | M | 22928 | Hoyt | Ray | Jr. | 01156 | |||||||||||||
K000364 | John Kuhl | K000364 | 400642 | 20520 | Randy Kuhl | Q5925486 | kg:/m/04cvlt | John | Kuhl | 1943-04-19 | M | 16552 | R. | Randy | Jr. | 01795 | 4233 | N00026087 | [ "H4NY29080" ] |
||||||||||
C001082 | Francisco Canseco | C001082 | 412481 | 21183 | Quico Canseco | Q1427943 | kg:/m/06_vlk1 | Francisco | Canseco | 1949-07-30 | M | 11824 | Quico | 02066 | 50146 | Francisco "Quico" Canseco | N00026722 | [ "H4TX28046" ] |
|||||||||||
C000873 | Philip Crane | C000873 | 400085 | 12041 | Phil Crane | Q325960 | kg:/m/0256nh | Philip | Crane | 1930-11-03 | M | 11548 | M. | Phil | 00249 | N00004698 | |||||||||||||
E000187 | Philip English | E000187 | 400123 | 29563 | Phil English | Q5712486 | kg:/m/03tt58 | Philip | English | 1956-06-20 | M | 12828 | Phil | 00347 | 21865 | N00001427 | [ "H4PA21051" ] |
||||||||||||
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 | |||||||
J000058 | Peterson Jarman | J000058 | 405963 | 4892 | Pete Jarman | Q2073263 | kg:/m/02rk25r | Peterson | Jarman | 1892-10-31 | M | 15764 | Bryant | Pete | |||||||||||||||
M000343 | Paul McCloskey | M000343 | 407352 | 11063 | Pete McCloskey | Q2073295 | kg:/m/04539r | Paul | McCloskey | 1927-09-29 | M | 17752 | Norton | Pete | Jr. | 00759 | |||||||||||||
G000134 | Preston Geren | G000134 | 404503 | 15636 | Pete Geren | Q1170156 | kg:/m/06smz8 | Preston | Geren | 1952-01-29 | M | 13730 | M. | Pete | 00434 | ||||||||||||||
P000259 | Douglas Peterson | P000259 | 408661 | 29111 | Pete Peterson | Q532342 | kg:/m/0ksdx | Douglas | Peterson | 1935-06-26 | M | 19597 | Brian | Pete | 00911 | ||||||||||||||
H000676 | Peter Hoekstra | H000676 | 400182 | 29361 | Pete Hoekstra | Q535254 | kg:/m/02d43z | Peter | Hoekstra | 1953-10-30 | M | 15121 | Pete | 00547 | 26490 | 26910 | N00004155 | [ "H2MI02066" ] |
|||||||||||
S000810 | Fortney Stark | S000810 | 400387 | 14053 | Pete Stark | Q965768 | kg:/m/024t66 | Fortney | Stark | 1931-11-11 | M | 22142 | H. | Pete | 01101 | 6747 | 26736 | Fortney Pete Stark | N00007397 | [ "H6CA09023" ] |
|||||||||
K000210 | Peter King | K000210 | 400219 | 29375 | Peter T. King | Q953554 | kg:/m/03tk4w | Peter | King | 1944-04-05 | M | 16338 | T. | Pete | Peter T. King | 00635 | 26487 | 26968 | Peter T. King | N00001193 | [ "H2NY03089" ] |
321 | |||||||
H000265 | Byron Harrison | H000265 | 405142 | 4126 | Pat Harrison | Q369437 | kg:/m/01gjb4 | Byron | Harrison | 1881-08-29 | M | 14613 | Patton | Pat | |||||||||||||||
C000115 | Arthur Cannon | C000115 | 402267 | 1478 | Pat Cannon | Q2056444 | kg:/m/02q6mh9 | Arthur | Cannon | 1904-05-22 | M | 10590 | Patrick | Pat | |||||||||||||||
M000308 | Patrick McCarran | M000308 | 407322 | 6132 | Pat McCarran | Q3269382 | kg:/m/02vl8t | Patrick | McCarran | 1876-08-08 | M | Anthony | Pat | ||||||||||||||||
K000030 | Bernard Kearney | K000030 | 406201 | 5110 | Bernard W. Kearney | Q4893725 | kg:/m/0kt24g | Bernard | Kearney | 1889-05-23 | M | 16113 | William | Pat | |||||||||||||||
T000462 | Patrick Tiberi | T000462 | 400406 | 20130 | Pat Tiberi | Q603467 | kg:/m/02zfh_ | Patrick | Tiberi | 1962-10-21 | M | 23204 | J. | Pat | Patrick J. Tiberi | 01664 | 88155 | 8404 | Patrick J. Tiberi | N00009699 | [ "H0OH12062" ] |
493 | |||||||
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 | ||||||
F000246 | Patrick Fallon | F000246 | 456845 | Pat Fallon | Q16196923 | kg:/m/0100nvdw | Patrick | Fallon | 1967-12-19 | M | Edward | Pat | Pat Fallon | N00047264 | [ "H0TX04219" ] |
||||||||||||||
O000034 | Wilbert O’Daniel | O000034 | 408281 | 7021 | W. Lee O'Daniel | Q676664 | kg:/m/02wv_6 | Wilbert | O’Daniel | 1890-03-11 | M | Lee | Pappy | ||||||||||||||||
M001132 | Michael Myers | M001132 | 408094 | 14442 | Michael Myers (politician) | Q535502 | kg:/m/05ykp_ | Michael | Myers | 1943-05-04 | M | 18742 | Joseph | Ozzie | 00848 | ||||||||||||||
D000327 | Norman Dicks | D000327 | 400109 | 14413 | Norm Dicks | Q970246 | kg:/m/0256md | Norman | Dicks | 1940-12-16 | M | 12235 | D. | Norm | 00297 | 8131 | 27127 | Norman D. Dicks | N00007918 | [ "H6WA06021" ] |
|||||||||
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" ] |
|||||||||||
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 | ||||||||||
M000113 | Michael Mansfield | M000113 | 407137 | 5967 | Mike Mansfield | Q1889152 | kg:/m/0ksc3 | Michael | Mansfield | 1903-03-16 | M | 17470 | Joseph | Mike | 01389 | ||||||||||||||
M000513 | James McKevitt | M000513 | 407507 | 13028 | Mike McKevitt | Q1933336 | kg:/m/02rjxbc | James | McKevitt | 1928-10-26 | M | 17968 | Douglas | Mike | |||||||||||||||
G000388 | Maurice Gravel | G000388 | 404738 | 12105 | Mike Gravel | Q352422 | kg:/m/01qxhs | Maurice | Gravel | 1930-05-13 | M | Robert | Mike | 01343 | |||||||||||||||
K000328 | Myron Kreidler | K000328 | 406482 | 39313 | Mike Kreidler | Q684548 | kg:/m/04l7p1 | Myron | Kreidler | 1943-09-28 | M | 16494 | Bradford | Mike | 00652 | ||||||||||||||
P000066 | Michael Parker | P000066 | 408476 | 15617 | Michael Parker (politician) | Q1928830 | kg:/m/0bmcp7t | Michael | Parker | 1949-10-31 | M | 19356 | Mike | 00889 | |||||||||||||||
D000294 | Michael DeWine | D000294 | 300033 | 15020 | Mike DeWine | Q1363468 | kg:/m/01_pg8 | Michael | DeWine | 1947-01-05 | M | 12191 | Mike | Mike DeWine | 00293 | S240 | N00003709 | ||||||||||||
F000443 | Michael Ferguson | F000443 | 400132 | 20127 | Mike Ferguson (New Jersey politician) | Q543078 | kg:/m/033fgd | Michael | Ferguson | 1970-06-22 | M | 13535 | Mike | 01659 | 22521 | N00000766 | [ "H8NJ06118" ] |
||||||||||||
H001034 | Michael Honda | H001034 | 400185 | 20103 | Mike Honda | Q399621 | kg:/m/021yd1 | Michael | Honda | 1941-06-27 | M | 15564 | M. | Mike | 01634 | 85565 | 9674 | Michael M. Honda | N00012611 | [ "H0CA15148" ] |
290 | ||||||||
C000880 | Michael Crapo | C000880 | 300030 | 29345 | Mike Crapo | Q734319 | kg:/m/021pgp | Michael | Crapo | 1951-05-20 | M | 11556 | D. | Mike | Mike Crapo | 00250 | 26440 | 26830 | S266 | Mike Crapo | N00006267 | [ "S8ID00027", "H2ID02034" ] |
556 | ||||||
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 | |||||||
L000237 | George Leland | L000237 | 406740 | 14643 | Mickey Leland | Q561325 | kg:/m/0217qk | George | Leland | 1944-11-27 | M | 16887 | Thomas | Mickey | 00681 | ||||||||||||||
E000077 | Marvin Edwards | E000077 | 403769 | 14415 | Mickey Edwards | Q1931352 | kg:/m/0687_3 | Marvin | Edwards | 1937-07-12 | M | 12694 | Henry | Mickey | 00338 | 2453 | |||||||||||||
H000151 | Melton Hancock | H000151 | 405033 | 15606 | Mel Hancock | Q473287 | kg:/m/026nxdc | Melton | Hancock | 1929-09-14 | M | 14471 | D. | Mel | 00492 | ||||||||||||||
W000207 | Melvin Watt | W000207 | 400424 | 29383 | Mel Watt | Q983446 | kg:/m/025kl3 | Melvin | Watt | 1945-08-26 | M | 23463 | L. | Mel | Melvin L. Watt | 01207 | 25889 | 26997 | Melvin L. Watt | N00002328 | [ "H2NC12021" ] |
509 | |||||||
C001090 | Matthew Cartwright | C001090 | 412571 | 21358 | Matt Cartwright | Q4111531 | kg:/m/0j_6b9d | Matthew | Cartwright | 1961-05-01 | M | A. | Matt | Matt Cartwright | 02159 | 79865 | 136236 | Matt Cartwright | N00034128 | [ "H2PA17079" ] |
1795 | ||||||||
M000627 | Martin Meehan | M000627 | 400269 | 29358 | Marty Meehan | Q357709 | kg:/m/028vnz | Martin | Meehan | 1956-12-30 | M | 18108 | T. | Marty | 00788 | N00000205 | [ "H2MA05054" ] |
||||||||||||
F000392 | Jonas Frost | F000392 | 400143 | 14626 | Martin Frost | Q1903813 | kg:/m/03g_ym | Jonas | Frost | 1942-01-01 | M | 13465 | Martin | III | 00419 | N00005677 | |||||||||||||
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 | ||||||||
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" ] |
||||||||||
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 | ||||||||
S001101 | David Sweeney | S001101 | 410553 | 15119 | Mac Sweeney | Q1882489 | kg:/m/02x3_wv | David | Sweeney | 1955-09-15 | M | 22498 | McCann | Mac | 01127 |
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);