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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B000592 | Corinne Boggs | B000592 | 401560 | 14067 | Lindy Boggs | Q458322 | kg:/m/03b7yq | Corinne | Boggs | 1916-03-13 | F | 9543 | Claiborne | Lindy | 00103 | ||||||||||||||
G000415 | Robert Green | G000415 | 404763 | 3781 | Robert A. Green | Q984102 | kg:/m/02rjyhh | Robert | Green | 1892-02-10 | M | 14093 | Alexis | Lex | |||||||||||||||
F000437 | Duncan Faircloth | F000437 | 403968 | 49304 | Lauch Faircloth | Q1406773 | kg:/m/01658l | Duncan | Faircloth | 1928-01-14 | M | McLauchlin | Lauch | 01329 | S227 | ||||||||||||||
W000636 | Edward Winn | W000636 | 411790 | 11057 | Larry Winn | Q1689332 | kg:/m/027n4yt | Edward | Winn | 1919-08-22 | M | 23973 | Lawrence | Larry | Jr. | 01235 | |||||||||||||
P000199 | Lafayette Pence | P000199 | 408602 | 7315 | Lafe Pence | Q1800169 | kg:/m/02rjwqf | Lafayette | Pence | 1857-12-23 | M | 19521 | Lafe | ||||||||||||||||
B000611 | Christopher Bond | B000611 | 300010 | 15501 | Kit Bond | Q560427 | kg:/m/01_6h2 | Christopher | Bond | 1939-03-06 | M | S. | Kit | 01286 | 2360 | 53313 | S200 | N00005178 | [ "S6MO00289" ] |
||||||||||
D000203 | Eligio de la Garza | D000203 | 403308 | 10716 | Kika de la Garza | Q1741192 | kg:/m/07kjdt | Eligio | de la Garza | 1927-09-22 | M | 12083 | II | Kika | 00276 | ||||||||||||||
L000558 | Kenneth Lucas | L000558 | 400248 | 29916 | Ken Lucas | Q1404866 | kg:/m/025jlr | Kenneth | Lucas | 1933-08-22 | M | 17294 | R. | Ken | 01562 | N00003444 | |||||||||||||
C001039 | Katherine Cammack | C001039 | 456806 | Kat Cammack | Q98523243 | kg:/g/11fsp_lppx | Katherine | Cammack | 1988-02-16 | F | Kat | Kat Cammack | N00045978 | [ "H0FL03175" ] |
|||||||||||||||
H001089 | Joshua Hawley | H001089 | 412840 | 41901 | Josh Hawley | Q23020745 | kg:/g/11bwy_95zy | Joshua | Hawley | 1979-12-31 | M | Josh | Josh Hawley | 169716 | S399 | Josh Hawley | N00041620 | [ "S8MO00160" ] |
|||||||||||
A000005 | Jo Abbott | A000005 | 400667 | 4 | Joseph Abbott (Texas politician) | Q1706400 | kg:/m/0f6jdp | Jo | Abbott | 1840-01-15 | M | 8253 | Joseph | ||||||||||||||||
C001079 | Anh Cao | C001079 | 412268 | 20917 | Joseph Cao | Q336324 | kg:/m/04yfg9l | Anh | Cao | 1967-03-13 | M | Joseph | 01923 | 1031344 | 93967 | N00030339 | [ "H8LA02112" ] |
||||||||||||
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 | ||||||
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 | ||||||||
K000288 | Joseph Knollenberg | K000288 | 400225 | 29365 | Joe Knollenberg | Q120455 | kg:/m/03tl85 | Joseph | Knollenberg | 1933-11-28 | M | 16441 | K. | Joe | 00642 | 26919 | N00004045 | [ "H2MI11042" ] |
|||||||||||
S001161 | John Schwarz | S001161 | 400637 | 20515 | Joe Schwarz | Q1691592 | kg:/m/04cn1r | John | Schwarz | 1937-11-15 | M | 22580 | J.H. | Joe | 01788 | N00004128 | |||||||||||||
D000533 | John Duncan | D000533 | 400116 | 15455 | Jimmy Duncan (politician) | Q653994 | kg:/m/0450rl | John | Duncan | 1947-07-21 | M | 12493 | J. | Jimmy | Jr. | 00322 | 6114 | 27069 | John J. Duncan, Jr. | N00003209 | [ "H8TN02069" ] |
228 | [ { "name": "John James Duncan", "relation": "son" } ] |
||||||
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" } ] |
|||||
D000114 | James Davis | D000114 | 400094 | 29714 | Jim Davis (Florida politician) | Q519908 | kg:/m/0252mn | James | Davis | 1957-10-11 | M | 11972 | Jim | 01478 | N00002926 | ||||||||||||||
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 | |||||||||||||
G000439 | James Greenwood | G000439 | 400161 | 29397 | James C. Greenwood | Q6130715 | kg:/m/03ttg5 | James | Greenwood | 1951-05-04 | M | 14121 | C. | Jim | 00465 | N00001519 | |||||||||||||
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 | |||||||
I000024 | James Inhofe | I000024 | 300055 | 15424 | Jim Inhofe | Q723134 | kg:/m/021kpl | James | Inhofe | 1934-11-17 | M | 15645 | M. | Jim | Jim Inhofe | 00583 | 5619 | 27027 | S236 | James M. Inhofe | N00005582 | [ "S4OK00083", "H6OK01102" ] |
576 | ||||||
J000072 | James Jeffords | J000072 | 300057 | 94240 | Jim Jeffords | Q1386836 | kg:/m/01vcjw | James | Jeffords | 1934-05-11 | M | 15786 | M. | Jim | 00593 | S204 | N00000534 | ||||||||||||
J000148 | James Johnson | J000148 | 406046 | 14025 | James Paul Johnson | Q222118 | kg:/m/02rhjd_ | James | Johnson | 1930-06-02 | M | 15878 | Paul | Jim | 00601 | ||||||||||||||
K000306 | James Kolbe | K000306 | 400226 | 15105 | Jim Kolbe | Q284704 | kg:/m/024p7w | James | Kolbe | 1942-06-28 | M | 16465 | T. | Jim | 00645 | N00006486 | |||||||||||||
L000169 | James Leach | L000169 | 400236 | 14432 | Jim Leach | Q1689138 | kg:/m/0dzxp0 | James | Leach | 1942-10-15 | M | 16810 | A. | Jim | 00672 | N00004280 | |||||||||||||
L000559 | James Langevin | L000559 | 400230 | 20136 | James Langevin | Q1397290 | kg:/m/02tvqy | James | Langevin | 1964-04-22 | M | 17296 | R. | Jim | Jim Langevin | 01668 | 86608 | 55787 | James R. Langevin | N00009724 | [ "H0RI02139" ] |
331 | |||||||
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 | |||||||
M000388 | James McCrery | M000388 | 400261 | 15451 | Jim McCrery | Q1689150 | kg:/m/025jwp | James | McCrery | 1949-09-18 | M | 17809 | O. | Jim | III | 00763 | 26881 | N00005414 | [ "H8LA04134" ] |
||||||||||
M000933 | James Moran | M000933 | 400283 | 29149 | Jim Moran | Q1337736 | kg:/m/025bgj | James | Moran | 1945-05-16 | M | 18503 | P. | Jim | Jim Moran | Jr. | 00832 | 4269 | 27118 | James P. Moran | N00002083 | [ "H0VA08040" ] |
380 | ||||||
M001146 | James Marshall | M001146 | 400254 | 20317 | Jim Marshall (Georgia politician) | Q1680110 | kg:/m/02554x | James | Marshall | 1948-03-31 | M | 18764 | Jim | 01718 | 1003563 | 31916 | N00009635 | [ "H0GA08032" ] |
|||||||||||
N000172 | James Nussle | N000172 | 400298 | 29118 | Jim Nussle | Q513802 | kg:/m/025b5l | James | Nussle | 1960-06-27 | M | 19047 | Allen | Jim | 00871 | N00004255 | |||||||||||||
R000033 | James Ramstad | R000033 | 400332 | 29126 | Jim Ramstad | Q473061 | kg:/m/02h1wy | James | Ramstad | 1946-05-06 | M | 20117 | M. | Jim | 00942 | 26921 | N00004484 | [ "H0MN00013" ] |
|||||||||||
S000097 | H. Saxton | S000097 | 400359 | 15112 | Jim Saxton | Q1335684 | kg:/m/025yb7 | H. | Saxton | 1943-01-22 | M | 21254 | James | Jim | 01023 | 26953 | N00000834 | [ "H4NJ13022" ] |
|||||||||||
T000024 | James Talent | T000024 | 300096 | 29369 | Jim Talent | Q1689229 | kg:/m/0gj1dy | James | Talent | 1956-10-18 | M | 22662 | M. | Jim | 01135 | S286 | N00005004 | ||||||||||||
T000424 | James Turner | T000424 | 400410 | 29758 | Jim Turner (politician) | Q1638994 | kg:/m/03l9vs | James | Turner | 1946-02-06 | M | 23153 | Jim | 01536 | N00005731 | ||||||||||||||
W000099 | James Walsh | W000099 | 400420 | 15630 | James T. Walsh | Q6143987 | kg:/m/03tvmx | James | Walsh | 1947-06-19 | M | 23332 | T. | Jim | 01197 | 26990 | N00001261 | [ "H8NY27036" ] |
|||||||||||
K000259 | Gerald Kleczka | K000259 | 400223 | 15082 | Jerry Kleczka | Q1687846 | kg:/m/024twd | Gerald | Kleczka | 1943-11-26 | M | 16401 | D. | Jerry | 00637 | N00004330 | |||||||||||||
S000432 | Jeremiah Simpson | S000432 | 409926 | 8529 | Jerry Simpson | Q1687867 | kg:/m/0d2x52 | Jeremiah | Simpson | 1842-03-31 | M | 21677 | Jerry | ||||||||||||||||
V000118 | Horace Voorhis | V000118 | 411172 | 9687 | Jerry Voorhis | Q344100 | kg:/m/09czrt | Horace | Voorhis | 1901-04-06 | M | 21018 | Jeremiah | Jerry | |||||||||||||||
W000273 | Gerald Weller | W000273 | 400429 | 29516 | Jerry Weller | Q740636 | kg:/m/0256sk | Gerald | Weller | 1957-07-07 | M | 23546 | C. | Jerry | 01216 | 21696 | N00004745 | [ "H4IL11096" ] |
|||||||||||
S001141 | Jefferson Sessions | S001141 | 300088 | 49700 | Jeff Sessions | Q358443 | kg:/m/020yjg | Jefferson | Sessions | 1946-12-24 | M | B. | Jeff | Jeff Sessions | 01548 | 44441 | 443 | S261 | Jeff Sessions | N00003062 | [ "S6AL00195" ] |
607 | |||||||
R000361 | John Rockefeller | R000361 | 300084 | 14922 | Jay Rockefeller | Q285102 | kg:/m/01xmnh | John | Rockefeller | 1937-06-18 | M | D. | Jay | Jay Rockefeller | IV | 01424 | 1238 | 53360 | S176 | John D. Rockefeller, IV | N00001685 | [ "S4WV00027" ] |
603 | [ { "name": "Nelson Aldrich Rockefeller", "relation": "nephew" }, { "name": "Nelson Aldrich", "relation": "great grandson" }, { "name": "Charles Harting Percy", "relation": "son in law" } ] |
|||||
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 | |||||||
G000072 | Edwin Garn | G000072 | 404444 | 14303 | Jake Garn | Q519256 | kg:/m/02ptw3 | Edwin | Garn | 1932-10-12 | M | Jacob | Jake | 01338 | S034 | ||||||||||||||
L000266 | Jacob LaTurner | L000266 | 456824 | Jake LaTurner | Q16731273 | kg:/m/0w32xrn | Jacob | LaTurner | 1988-02-17 | M | Jake | Jake LaTurner | N00044232 | [ "H0KS02188" ] |
|||||||||||||||
P000328 | James Pickle | P000328 | 408725 | 10614 | J. J. Pickle | Q1646263 | kg:/m/03qr5k | James | Pickle | 1913-10-11 | M | 19685 | Jarrell | Jake | 00917 | ||||||||||||||
B000270 | James Beall | B000270 | 401264 | 545 | James Andrew Beall | Q1679952 | kg:/m/03b_h06 | James | Beall | 1866-10-25 | M | 9124 | Andrew | Jack | |||||||||||||||
B001036 | John Buechner | B001036 | 401986 | 15405 | Jack Buechner | Q1534990 | kg:/m/09dyzq | John | Buechner | 1940-06-04 | M | 10112 | William | Jack | 00144 | ||||||||||||||
E000084 | William Edwards | E000084 | 403777 | 10721 | Jack Edwards (American politician) | Q1671317 | kg:/m/026qn6z | William | Edwards | 1928-09-20 | M | 12702 | Jackson | Jack | 00337 | ||||||||||||||
R000122 | John Reed | R000122 | 300081 | 29142 | Jack Reed (Rhode Island politician) | Q528979 | kg:/m/0202mc | John | Reed | 1949-11-12 | M | 20232 | F. | Jack | Jack Reed | 00949 | 24239 | 27060 | S259 | Jack Reed | N00000362 | [ "S6RI00163", "H0RI02071" ] |
600 | ||||||
W000310 | Alfred Westland | W000310 | 411474 | 9968 | Jack Westland | Q1712148 | kg:/m/03dzsh | Alfred | Westland | 1904-12-14 | M | 23586 | John | Jack | |||||||||||||||
H000413 | John Hayworth | H000413 | 400173 | 29502 | J. D. Hayworth | Q1676304 | kg:/m/024p75 | John | Hayworth | 1958-07-12 | M | 14791 | D. | J.D. | Jr. | 00520 | 22187 | N00006455 | |||||||||||
B001239 | James Barrett | B001239 | 400016 | 20347 | Gresham Barrett | Q800095 | kg:/m/03ksz0 | James | Barrett | 1961-02-14 | M | 10377 | Gresham | J. Gresham | 01745 | 1003613 | 14577 | N00013837 | [ "H2SC03057" ] |
||||||||||
K000305 | Herbert Kohl | K000305 | 300061 | 15703 | Herb Kohl | Q560447 | kg:/m/04fy4q | Herbert | Kohl | 1935-02-07 | M | H. | Herb | 01380 | 4030 | 53362 | S209 | Herb Kohl | N00004309 | [ "S6WI00061" ] |
|||||||||
S000157 | Henry Schwartz | S000157 | 409664 | 8285 | Henry H. Schwartz | Q367854 | kg:/m/08sqn_ | Henry | Schwartz | 1869-05-18 | M | Herman | Harry | ||||||||||||||||
C000290 | Albert Chandler | C000290 | 402432 | 1634 | Happy Chandler | Q573029 | kg:/m/01s8l0 | Albert | Chandler | 1898-07-14 | M | Benjamin | Happy | ||||||||||||||||
B000919 | George Brown | B000919 | 401874 | 14803 | Hank Brown | Q931345 | kg:/m/05byy0 | George | Brown | 1940-02-12 | M | 9967 | Hanks | Hank | 00135 | S214 | |||||||||||||
J000288 | Henry Johnson | J000288 | 412199 | 20712 | Hank Johnson | Q983537 | kg:/m/0flgyy | Henry | Johnson | 1954-10-02 | M | 16065 | C. | Hank | Henry C. Johnson, Jr. | Jr. | 01843 | 1020576 | 68070 | Henry C. "Hank" Johnson, Jr. | N00027848 | [ "H6GA04129" ] |
686 | ||||||
D000065 | Harold Daub | D000065 | 403203 | 14810 | Hal Daub | Q1570100 | kg:/m/0clcr6 | Harold | Daub | 1941-04-23 | M | 11911 | John, Jr., | Hal | 00268 | ||||||||||||||
R000395 | Harold Rogers | R000395 | 400340 | 14854 | Hal Rogers | Q547153 | kg:/m/025jnx | Harold | Rogers | 1937-12-31 | M | 20573 | Hal | Harold Rogers | 00977 | 6739 | 26875 | Harold Rogers | N00003473 | [ "H0KY05015" ] |
434 | ||||||||
H000367 | Augustus Hawkins | H000367 | 405236 | 10595 | Augustus Hawkins | Q561547 | kg:/m/029b6p | Augustus | Hawkins | 1907-08-31 | M | 14733 | Freeman | Gus | 00515 | ||||||||||||||
B001247 | Virginia Brown-Waite | B001247 | 400051 | 20313 | Ginny Brown-Waite | Q437199 | kg:/m/0251yt | Virginia | Brown-Waite | 1943-10-05 | F | 10393 | Ginny | 01713 | 1003557 | 8077 | N00024777 | [ "H2FL05127" ] |
|||||||||||
G000536 | Gilbert Gutknecht | G000536 | 400164 | 29532 | Gil Gutknecht | Q1523824 | kg:/m/02h1_c | Gilbert | Gutknecht | 1951-03-20 | M | 14237 | W. | Gil | 00479 | N00004527 | |||||||||||||
B001251 | George Butterfield | B001251 | 400616 | 20340 | G. K. Butterfield | Q983532 | kg:/m/03g_pq | George | Butterfield | 1947-04-27 | M | 10401 | Kenneth | G.K. | G.K. Butterfield | Jr. | 01761 | 1013540 | 41077 | G. K. Butterfield | N00027035 | [ "H4NC01046" ] |
624 | ||||||
H000725 | Ernest Hollings | H000725 | 300053 | 11204 | Fritz Hollings | Q596008 | kg:/m/0cm3v | Ernest | Hollings | 1922-01-01 | M | F. | Fritz | 01361 | S047 | N00002423 | |||||||||||||
W000368 | Francis White | W000368 | 411529 | 10021 | Francis S. White | Q1441721 | kg:/m/03glr9 | Francis | White | 1847-03-13 | M | Shelley | Frank | ||||||||||||||||
F000441 | Ernest Fletcher | F000441 | 400135 | 29917 | Ernie Fletcher | Q881233 | kg:/m/026fb9 | Ernest | Fletcher | 1952-11-12 | M | 13532 | Lee | Ernie | 01563 | 115 | N00003430 | ||||||||||||
J000083 | Edgar Jenkins | J000083 | 405985 | 14429 | Ed Jenkins (politician) | Q978380 | kg:/m/026jstk | Edgar | Jenkins | 1933-01-04 | M | 15799 | Lanier | Ed | 00595 | ||||||||||||||
M000133 | Edward Markey | M000133 | 400253 | 14435 | Ed Markey | Q1282411 | kg:/m/028vr4 | Edward | Markey | 1946-07-11 | M | 17493 | J. | Ed | Ed Markey | 00735 | 260 | 26900 | S369 | Edward J. Markey | N00000270 | [ "H6MA07101", "S4MA00028" ] |
351 | ||||||
R000487 | Edward Royce | R000487 | 400348 | 29321 | Ed Royce | Q1282477 | kg:/m/024xcy | Edward | Royce | 1951-10-12 | M | 20688 | R. | Ed | 00998 | 28461 | 26772 | Edward R. Royce | N00008264 | [ "H6CA39020" ] |
441 | ||||||||
S001151 | Edward Schrock | S001151 | 400362 | 20142 | Ed Schrock | Q1282486 | kg:/m/0292qs | Edward | Schrock | 1941-04-06 | M | 22562 | L. | Ed | 01673 | N00012656 | |||||||||||||
T000326 | Edolphus Towns | T000326 | 400409 | 15072 | Edolphus Towns | Q600005 | kg:/m/03jqnw | Edolphus | Towns | 1934-07-21 | M | 23035 | Ed | 01165 | 6807 | 26973 | Edolphus Towns | N00001082 | [ "H2NY11017" ] |
||||||||||
C000994 | Randall Cunningham | C000994 | 400091 | 29107 | Duke Cunningham | Q946106 | kg:/m/0576l8 | Randall | Cunningham | 1941-12-08 | M | 11696 | H. | Duke | 00258 | N00007050 | |||||||||||||
B000403 | Douglas Bereuter | B000403 | 400023 | 14605 | Doug Bereuter | Q1251707 | kg:/m/025t0y | Douglas | Bereuter | 1939-10-06 | M | 9299 | K. | Doug | 00080 | N00005331 | |||||||||||||
E000064 | William Edwards | E000064 | 403776 | 10583 | Don Edwards | Q1239102 | kg:/m/082xnd | William | Edwards | 1915-01-06 | M | 12679 | Donlon | Don | 00336 | ||||||||||||||
J000120 | Clete Johnson | J000120 | 406024 | 29343 | Don Johnson Jr. | Q1100647 | kg:/m/0gshtq | Clete | Johnson | 1948-01-30 | M | 15844 | Donald | Don | Jr. | 00598 | |||||||||||||
S001146 | Donald Sherwood | S001146 | 400372 | 29933 | Don Sherwood | Q5293513 | kg:/m/03v3b8 | Donald | Sherwood | 1941-03-05 | M | 22552 | L. | Don | 01589 | N00001510 | |||||||||||||
W000342 | William Wheeler | W000342 | 411504 | 9996 | William McDonald Wheeler | Q2579832 | kg:/m/02rk17h | William | Wheeler | 1915-07-11 | M | 23624 | McDonald | Don | |||||||||||||||
G000219 | William Gilmer | G000219 | 404581 | 3614 | Dixie Gilmer | Q1231705 | kg:/m/02rr6td | William | Gilmer | 1901-06-07 | M | 13843 | Franklin | Dixie | |||||||||||||||
C000448 | Richard Clark | C000448 | 402586 | 14102 | Dick Clark (senator) | Q2149196 | kg:/m/01zlfl | Richard | Clark | 1928-09-14 | M | Clarence | Dick | 01306 | |||||||||||||||
G000132 | Richard Gephardt | G000132 | 400146 | 14421 | Dick Gephardt | Q1209677 | kg:/m/0163l9 | Richard | Gephardt | 1941-01-31 | M | 13727 | Andrew | Dick | 00433 | N00005037 | |||||||||||||
S000383 | Richard Shoup | S000383 | 409877 | 13041 | Richard G. Shoup | Q2149547 | kg:/m/02rjy9n | Richard | Shoup | 1923-11-29 | M | 21613 | Gardner | Dick | 01052 | ||||||||||||||
S000962 | Richard Stone | S000962 | 410421 | 14309 | Richard Stone (politician) | Q2150705 | kg:/m/07qv5m | Richard | Stone | 1928-09-22 | M | Bernard | Dick | 01443 | |||||||||||||||
H000323 | J. Hastert | H000323 | 400169 | 15417 | Dennis Hastert | Q553626 | kg:/m/019sj8 | J. | Hastert | 1942-01-02 | M | 14681 | Dennis | Denny | 00510 | 26842 | N00004781 | [ "H6IL14095" ] |
|||||||||||
R000571 | Dennis Rehberg | R000571 | 400335 | 20125 | Denny Rehberg | Q1189686 | kg:/m/02d4rm | Dennis | Rehberg | 1955-10-05 | M | 20787 | Denny | 01657 | 404 | Denny Rehberg | N00004645 | [ "H0MT00033" ] |
|||||||||||
S000527 | Dennis Smith | S000527 | 410010 | 14864 | Denny Smith | Q1189683 | kg:/m/0ksz3j | Dennis | Smith | 1938-01-19 | M | 21792 | Alan | Denny | 01072 | ||||||||||||||
H000905 | Walter Huddleston | H000905 | 405751 | 14106 | Walter Dee Huddleston | Q4356720 | kg:/m/0529x4 | Walter | Huddleston | 1926-04-15 | M | Darlington | Dee | 01363 | |||||||||||||||
B001290 | David Brat | B001290 | 412605 | 21553 | Dave Brat | Q17160419 | kg:/m/010qykqw | David | Brat | 1964-07-27 | M | 15032409257 | Alan | Dave | David Brat | 02203 | 75248 | 152270 | Dave Brat | N00036013 | [ "H4VA07143" ] |
2061 | |||||||
H000666 | David Hobson | H000666 | 400180 | 29136 | Dave Hobson | Q5228974 | kg:/m/039rtp | David | Hobson | 1936-10-17 | M | 15108 | Lee | Dave | 00545 | 27014 | N00003725 | [ "H0OH07021" ] |
|||||||||||
O000007 | David Obey | O000007 | 400300 | 12036 | Dave Obey | Q434463 | kg:/m/024tlf | David | Obey | 1938-10-03 | M | 19079 | Ross | Dave | 00877 | 1621 | 27140 | N00004394 | [ "H6WI07033" ] |
||||||||||
W000267 | David Weldon | W000267 | 400427 | 29509 | Dave Weldon | Q672269 | kg:/m/0252yz | David | Weldon | 1953-08-31 | M | 23538 | J. | Dave | Jr. | 01215 | 22159 | N00002807 | [ "H4FL15114" ] |
||||||||||
D000038 | Wilbur Daniel | D000038 | 403178 | 12011 | Dan Daniel (politician) | Q1159044 | kg:/m/02vp0dm | Wilbur | Daniel | 1914-05-12 | M | 11876 | Clarence | Dan | 00261 | ||||||||||||||
Q000007 | James Quayle | Q000007 | 408970 | 14447 | Dan Quayle | Q49214 | kg:/m/041w4 | James | Quayle | 1947-02-04 | M | 20050 | Danforth | Dan | 00935 | ||||||||||||||
S000109 | Daniel Schaefer | S000109 | 409618 | 15058 | Daniel Schaefer | Q1162522 | kg:/m/0cp578 | Daniel | Schaefer | 1936-01-25 | M | 21269 | Dan | 01026 | |||||||||||||||
D000110 | James Davis | D000110 | 403246 | 2390 | James H. Davis (congressman) | Q1680535 | kg:/m/02w997f | James | Davis | 1853-12-24 | M | 11966 | Harvey | Cyclone | |||||||||||||||
C001102 | Curtis Clawson | C001102 | 412604 | Curt Clawson | Q16728087 | kg:/m/03wphq2 | Curtis | Clawson | 1959-09-28 | M | Curt | 02200 | 75516 | 148899 | Curt Clawson | N00035854 | [ "H4FL19074" ] |
2060 | |||||||||||
W000268 | W. Weldon | W000268 | 400428 | 15447 | Curt Weldon | Q1145362 | kg:/m/036j8q | W. | Weldon | 1947-07-22 | M | 23540 | Curtis | Curt | 01214 | N00001535 | |||||||||||||
C000296 | Walter Chandler | C000296 | 402438 | 1639 | Walter Chandler | Q2543888 | kg:/m/06t3xx | Walter | Chandler | 1887-10-05 | M | 10827 | Clift |
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);