legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_wikidata 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
L000389 | Matthew Locke | L000389 | 406881 | 5734 | Matthew Locke (U.S. Congress) | Q974307 | kg:/m/04fd_f | Matthew | Locke | M | 17076 | ||||||||||||||||||
D000611 | Charles Djou | D000611 | 412387 | 20961 | Charles Djou | Q974192 | kg:/m/0d66z8 | Charles | Djou | 1970-08-09 | M | 12595 | 01978 | 9267955 | 17827 | N00029460 | [ "H0HI01157" ] |
||||||||||||
M000615 | James Mead | M000615 | 407604 | 6394 | James M. Mead | Q974157 | kg:/m/06f9g8 | James | Mead | 1885-12-27 | M | 18095 | Michael | ||||||||||||||||
F000098 | Thomas Fessenden | F000098 | 404055 | 3126 | T. A. D. Fessenden | Q974019 | kg:/m/038993 | Thomas | Fessenden | 1826-01-23 | M | 13096 | Amory Deblois | ||||||||||||||||
M001155 | Connie Mack | M001155 | 400622 | 20503 | Connie Mack IV | Q973774 | kg:/m/04ffv_ | Connie | Mack | 1967-08-12 | M | 18782 | IV | 01776 | 1013040 | 53996 | Connie Mack | N00026425 | [ "H4FL14059" ] |
||||||||||
C000754 | Jim Cooper | C000754 | 400081 | 15019 | Jim Cooper | Q973737 | kg:/m/03tm2p | Jim | Cooper | 1954-06-19 | M | 11401 | Jim Cooper | 00231 | 1201 | 48891 | Jim Cooper | N00003132 | [ "H2TN05131", "H2TN04027", "S4TN00096" ] |
196 | |||||||||
P000089 | Richard Parsons | P000089 | 408499 | 7221 | Richard C. Parsons | Q973588 | kg:/m/02rm2t7 | Richard | Parsons | 1826-10-10 | M | 19382 | Chappel | ||||||||||||||||
M000968 | Edmund Morrill | M000968 | 407936 | 6695 | Edmund Needham Morrill | Q973506 | kg:/m/0fnwrn | Edmund | Morrill | 1834-02-12 | M | 18542 | Needham | ||||||||||||||||
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" ] |
||||||||||
B001255 | Charles Boustany | B001255 | 400636 | 20514 | Charles Boustany | Q972735 | kg:/m/04wdx3 | Charles | Boustany | 1956-02-21 | M | 10409 | W. | Charles Boustany Jr. | Jr. | 01787 | 1013047 | 35514 | Charles W. Boustany Jr. | N00026595 | [ "H4LA07029" ] |
642 | |||||||
G000062 | Washington Gardner | G000062 | 404435 | 3472 | Washington Gardner | Q972686 | kg:/m/027z0py | Washington | Gardner | 1845-02-16 | M | 7705 | |||||||||||||||||
A000276 | Henry Arens | A000276 | 400916 | 227 | Henry M. Arens | Q972462 | kg:/m/0b8yyj | Henry | Arens | 1873-11-21 | M | 8648 | Martin | ||||||||||||||||
B001081 | Dempsey Burges | B001081 | 402027 | 1255 | Dempsey Burgess | Q972369 | kg:/m/04ft0_ | Dempsey | Burges | M | 10170 | ||||||||||||||||||
W000408 | Richard Whiteley | W000408 | 411568 | 10058 | Richard H. Whiteley | Q972171 | kg:/m/02rk13c | Richard | Whiteley | 1830-12-22 | M | 23698 | Henry | ||||||||||||||||
R000220 | George Richardson | R000220 | 409196 | 7875 | George F. Richardson | Q972047 | kg:/m/02ppxb0 | George | Richardson | 1850-07-01 | M | 20355 | Frederick | ||||||||||||||||
A000022 | Gary Ackerman | A000022 | 400003 | 15000 | Gary Ackerman | Q972029 | kg:/m/03rhdq | Gary | Ackerman | 1942-11-19 | M | 8283 | L. | 00004 | 1002061 | 26970 | Gary L. Ackerman | N00001143 | [ "H4NY07011" ] |
||||||||||
L000263 | Sander Levin | L000263 | 400238 | 15033 | Sander Levin | Q971943 | kg:/m/02n8p2 | Sander | Levin | 1931-09-06 | M | 16921 | M. | Sander Levin | 00683 | 251 | 26918 | Sander M. Levin | N00003950 | [ "H2MI17023" ] |
339 | [ { "name": "Carl Levin", "relation": "brother" } ] |
|||||||
L000412 | Chester Long | L000412 | 406903 | 5754 | Chester I. Long | Q971725 | kg:/m/0cvrzn | Chester | Long | 1860-10-12 | M | 17106 | Isaiah | ||||||||||||||||
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 | ||||||||
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 | ||||||
K000172 | Dale Kildee | K000172 | 400216 | 14430 | Dale Kildee | Q971199 | kg:/m/02d4bs | Dale | Kildee | 1929-09-16 | M | 16292 | E. | 00631 | 6743 | 26909 | Dale E. Kildee | N00004070 | [ "H6MI07108" ] |
||||||||||
M000614 | Cowles Mead | M000614 | 407603 | 6393 | Cowles Mead | Q970707 | kg:/m/0g3vv6 | Cowles | Mead | 1776-10-18 | M | 18093 | |||||||||||||||||
R000572 | Mike Rogers | R000572 | 400342 | 20120 | Mike Rogers (Michigan politician) | Q970515 | kg:/m/0258zm | Mike | Rogers | 1963-06-02 | M | 20789 | Mike Rogers (Michigan) | 01651 | 86133 | 8751 | Mike Rogers | N00009668 | [ "H0MI08042" ] |
435 | |||||||||
M001144 | Jeff Miller | M001144 | 400279 | 20110 | Jeff Miller (Florida politician) | Q970478 | kg:/m/0251vm | Jeff | Miller | 1959-06-27 | M | 18760 | Jeff Miller (Florida) | 01685 | 91615 | 17276 | Jeff Miller | N00013846 | [ "H2FL01100" ] |
375 | |||||||||
B001242 | Timothy Bishop | B001242 | 400031 | 20338 | Tim Bishop | Q970461 | kg:/m/03tq39 | Timothy | Bishop | 1950-06-01 | M | 10383 | H. | 01740 | 1003587 | 44518 | Timothy H. Bishop | N00025413 | [ "H2NY01067" ] |
149 | |||||||||
H000522 | Walter Hensley | H000522 | 405385 | 4347 | Walter Lewis Hensley | Q970438 | kg:/m/02rz8h0 | Walter | Hensley | 1871-09-03 | M | 14929 | Lewis | ||||||||||||||||
H000178 | Hugh Haralson | H000178 | 405059 | 4046 | Hugh A. Haralson | Q970375 | kg:/m/04kwmt | Hugh | Haralson | 1805-11-13 | M | 14505 | Anderson | ||||||||||||||||
J000293 | Ron Johnson | J000293 | 412496 | 41111 | Ron Johnson (Wisconsin politician) | Q970272 | kg:/m/0cmdpzc | Ron | Johnson | 1955-04-08 | M | Ron Johnson (Wisconsin) | 02086 | 62835 | 126217 | S345 | Ron Johnson | N00032546 | [ "S0WI00197" ] |
1501 | |||||||||
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" ] |
|||||||||
I000053 | Ralph Izard | I000053 | 412129 | 4837 | Ralph Izard | Q969896 | kg:/m/0376kk | Ralph | Izard | M | 15684 | ||||||||||||||||||
F000417 | Hampton Fulmer | F000417 | 404359 | 3404 | Hampton P. Fulmer | Q969884 | kg:/m/02qdbv3 | Hampton | Fulmer | 1875-06-23 | M | 13497 | Pitts | ||||||||||||||||
U000010 | John Underwood | U000010 | 411034 | 9557 | John William Henderson Underwood | Q969788 | kg:/m/0286b_6 | John | Underwood | 1816-11-20 | M | 20839 | William Henderson | ||||||||||||||||
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 | |||||||
B000780 | John Breaux | B000780 | 300012 | 13056 | John Breaux | Q969757 | kg:/m/01xctw | John | Breaux | 1944-03-01 | M | 9787 | B. | 00120 | S179 | N00005385 | |||||||||||||
K000107 | John Kennedy | K000107 | 406274 | 5180 | John F. Kennedy | Q9696 | kg:/m/0d3k14 | John | Kennedy | 1917-05-29 | M | 7707 | Fitzgerald | ||||||||||||||||
E000240 | Frank Evans | E000240 | 403924 | 10723 | Frank Evans (politician) | Q969538 | kg:/m/02rhg9k | Frank | Evans | 1923-09-06 | M | 12897 | Edward | 00360 | |||||||||||||||
R000549 | Samuel Rutherford | R000549 | 409505 | 8149 | Samuel Rutherford (Georgia politician) | Q969185 | kg:/m/0279f6m | Samuel | Rutherford | 1870-03-15 | M | 20757 | |||||||||||||||||
R000580 | Peter Roskam | R000580 | 412202 | 20715 | Peter Roskam | Q968214 | kg:/m/0gj190 | Peter | Roskam | 1961-09-13 | M | 20803 | J. | Peter Roskam | 01848 | 1021912 | 6382 | Peter J. Roskam | N00004719 | [ "H6IL06117", "H8IL13051" ] |
689 | ||||||||
B001107 | John Burleigh | B001107 | 402052 | 1278 | John H. Burleigh | Q968190 | kg:/m/02rt0tk | John | Burleigh | 1822-10-09 | M | 10203 | Holmes | ||||||||||||||||
G000277 | John Goode | G000277 | 404639 | 3666 | John Goode (Virginia politician) | Q968146 | kg:/m/07d7n9 | John | Goode | 1829-05-27 | M | 13913 | Jr. | ||||||||||||||||
F000099 | William Fessenden | F000099 | 404056 | 3127 | William P. Fessenden | Q968068 | kg:/m/02wtj4 | William | Fessenden | 1806-10-16 | M | 13098 | Pitt | ||||||||||||||||
W000464 | Isaac Wildrick | W000464 | 411621 | 10109 | Isaac Wildrick | Q968043 | kg:/m/02z4xxy | Isaac | Wildrick | 1803-03-03 | M | 23769 | |||||||||||||||||
S000094 | Thomas Sawyer | S000094 | 400539 | 15442 | Thomas C. Sawyer | Q967900 | kg:/m/039ttk | Thomas | Sawyer | 1945-08-15 | M | 21250 | C. | 01022 | |||||||||||||||
J000306 | Mondaire Jones | J000306 | 456840 | Mondaire Jones | Q96781248 | kg:/g/11fsfpp4wj | Mondaire | Jones | 1987-05-18 | M | Mondaire Jones | Mondaire Jones | N00044908 | [ "H0NY17174" ] |
|||||||||||||||
B000825 | Lauren Boebert | B000825 | 456805 | Lauren Boebert | Q96761544 | kg:/g/11j2v06x6p | Lauren | Boebert | 1986-12-15 | F | Opal | Lauren Boebert | Lauren Boebert | N00045974 | [ "H0CO03165" ] |
||||||||||||||
N000026 | Troy Nehls | N000026 | 456848 | Troy Nehls | Q96741441 | kg:/g/11c580_xf2 | Troy | Nehls | 1968-04-07 | M | E. | Troy Nehls | 188334 | Troy E. Nehls | N00046067 | [ "H0TX22302" ] |
|||||||||||||
H000829 | William Houston | H000829 | 405676 | 4617 | William C. Houston | Q967160 | kg:/m/0dk997 | William | Houston | 1852-03-17 | M | 15309 | Cannon | ||||||||||||||||
A000252 | William Andrews | A000252 | 400888 | William Henry Andrews | Q966483 | kg:/m/05yd23 | William | Andrews | 1846-01-14 | M | 8614 | Henry | |||||||||||||||||
M000725 | George Miller | M000725 | 400278 | 14256 | George Miller (California politician) | Q966352 | kg:/m/024sjl | George | Miller | 1945-05-17 | M | 18239 | George Miller | 00808 | 622 | 26734 | George Miller | N00007390 | [ "H6CA07043" ] |
374 | |||||||||
C001104 | Madison Cawthorn | C001104 | 456833 | Madison Cawthorn | Q96633736 | kg:/g/11jcrrfg9t | Madison | Cawthorn | 1995-08-01 | M | Madison Cawthorn | Madison Cawthorn | N00046252 | [ "H0NC11233" ] |
|||||||||||||||
H000067 | Ralph Hall | H000067 | 400165 | 14828 | Ralph Hall | Q966332 | kg:/m/026cww | Ralph | Hall | 1923-05-03 | M | 14371 | M. | Ralph Hall | 00484 | 7354 | 27080 | Ralph M. Hall | N00005645 | [ "H0TX04037" ] |
271 | ||||||||
B000213 | Joe Barton | B000213 | 400018 | 15085 | Joe Barton | Q966261 | kg:/m/03rspq | Joe | Barton | 1949-09-15 | M | 9049 | Linus | 00062 | 5248 | 27082 | Joe Barton | N00005656 | [ "H4TX06117", "S4TX00094" ] |
139 | |||||||||
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" ] |
|||||||||||
F000164 | John Fitzgerald | F000164 | 404119 | 3182 | John F. Fitzgerald | Q966182 | kg:/m/01qlh0 | John | Fitzgerald | 1863-02-11 | M | 13177 | Francis | ||||||||||||||||
B001259 | Bruce Braley | B001259 | 412208 | 20719 | Bruce Braley | Q966154 | kg:/m/07r9r0 | Bruce | Braley | 1957-10-30 | M | 10417 | L. | Bruce Braley | 01845 | 1020421 | 57382 | Bruce L. Braley | N00027464 | [ "H6IA01098", "S4IA00087" ] |
693 | ||||||||
H000764 | Joseph Hooper | H000764 | 405614 | 4558 | Joseph L. Hooper | Q965966 | kg:/m/02843yc | Joseph | Hooper | 1877-12-22 | M | 15230 | Lawrence | ||||||||||||||||
E000268 | Terry Everett | E000268 | 400127 | 29300 | Terry Everett | Q965794 | kg:/m/024n_f | Terry | Everett | 1937-02-15 | M | 12931 | 00364 | 26711 | N00003083 | [ "H2AL02067" ] |
|||||||||||||
L000111 | Tom Latham | L000111 | 400234 | 29522 | Tom Latham (politician) | Q965775 | kg:/m/025b6s | Tom | Latham | 1948-07-14 | M | 16735 | P. | Tom Latham | 00666 | 36609 | 22175 | Tom Latham | N00004227 | [ "H4IA05102" ] |
335 | ||||||||
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" ] |
|||||||||
J000252 | Seaborn Jones | J000252 | 406145 | 5062 | Seaborn Jones | Q965653 | kg:/m/0ghqw5 | Seaborn | Jones | 1788-02-01 | M | 16010 | |||||||||||||||||
P000034 | Frank Pallone | P000034 | 400308 | 15454 | Frank Pallone | Q965289 | kg:/m/0g6t5w | Frank | Pallone | 1951-10-30 | M | 19321 | J. | Frank Pallone | Jr. | 00887 | 6107 | 26951 | Frank Pallone, Jr. | N00000781 | [ "H8NJ03073", "S6NJ00263" ] |
402 | |||||||
B001217 | Joseph Byrns | B001217 | 402156 | 1372 | Jo Byrns | Q965009 | kg:/m/036699 | Joseph | Byrns | 1869-07-20 | M | 10343 | Wellington | ||||||||||||||||
D000407 | Pete Domenici | D000407 | 300036 | 14103 | Pete Domenici | Q964959 | kg:/m/01vjn1 | Pete | Domenici | 1932-05-07 | M | V. | 01319 | 53325 | S027 | N00006515 | [ "S8NM00010" ] |
||||||||||||
C000023 | John Caine | C000023 | 402184 | John Thomas Caine | Q964884 | kg:/m/02rhkmh | John | Caine | 1829-01-08 | M | 10471 | Thomas | |||||||||||||||||
G000113 | Thomas Geary | G000113 | 404485 | 3520 | Thomas J. Geary | Q964376 | kg:/m/02rjztf | Thomas | Geary | 1854-01-18 | M | 13702 | J. | ||||||||||||||||
B001223 | Jamaal Bowman | B001223 | 456839 | Jamaal Bowman | Q96419280 | kg:/g/11fsgvc0xx | Jamaal | Bowman | 1976-04-01 | M | Jamaal Bowman | Jamaal Bowman | N00044790 | [ "H0NY16143" ] |
|||||||||||||||
M001186 | Peter Meijer | M001186 | 456826 | Peter Meijer | Q96419165 | kg:/g/11dxq0fr9x | Peter | Meijer | 1988-01-10 | M | James | Peter Meijer | N00044884 | [ "H0MI03308" ] |
|||||||||||||||
J000160 | Lyndon Johnson | J000160 | 406058 | 4979 | Lyndon B. Johnson | Q9640 | kg:/m/0f7fy | Lyndon | Johnson | 1908-08-27 | M | 15895 | Baines | ||||||||||||||||
R000458 | Daniel Rostenkowski | R000458 | 409422 | 8080 | Dan Rostenkowski | Q963898 | kg:/m/030xg_ | Daniel | Rostenkowski | 1928-01-02 | M | 20648 | David | 00988 | |||||||||||||||
R000504 | John Rumple | R000504 | 409463 | 8111 | John N. W. Rumple | Q963665 | kg:/m/02rk7s4 | John | Rumple | 1841-03-04 | M | 20708 | Nicholas William | ||||||||||||||||
M000447 | George McGill | M000447 | 407446 | 6251 | George McGill | Q963581 | kg:/m/0c48w_ | George | McGill | 1879-02-12 | M | ||||||||||||||||||
B000280 | Robin Beard | B000280 | 401274 | 14004 | Robin Beard | Q963419 | kg:/m/03z10z | Robin | Beard | 1939-08-21 | M | 9139 | Leo | Jr. | 00069 | ||||||||||||||
H000385 | Carl Hayden | H000385 | 405253 | 4227 | Carl Hayden | Q963401 | kg:/m/02rzt9 | Carl | Hayden | 1877-10-02 | M | 14756 | Trumbull | ||||||||||||||||
D000178 | Henry Dearborn | D000178 | 403340 | 2451 | Henry Dearborn | Q963349 | kg:/m/01jv0s | Henry | Dearborn | 1751-02-23 | M | 12053 | |||||||||||||||||
B001077 | Quentin Burdick | B001077 | 402023 | 1252 | Quentin Burdick | Q963214 | kg:/m/04vllq | Quentin | Burdick | 1908-06-19 | M | 10165 | Northrup | 01297 | S015 | ||||||||||||||
B001235 | Henry Brown | B001235 | 400049 | 20137 | Henry E. Brown Jr. | Q962919 | kg:/m/03tpvc | Henry | Brown | 1935-12-20 | M | 10370 | E. | Jr. | 01669 | 1000221 | 3993 | N00002428 | [ "H0SC01071" ] |
||||||||||
M000781 | Frank Millspaugh | M000781 | 407759 | 6534 | Frank C. Millspaugh | Q962838 | kg:/m/02rz61p | Frank | Millspaugh | 1872-01-14 | M | 18308 | Crenshaw | ||||||||||||||||
S001136 | William Symington | S001136 | 410586 | 9141 | Stuart Symington | Q962660 | kg:/m/03fj2d | William | Symington | 1901-06-26 | M | Stuart | Stuart | 01444 | |||||||||||||||
D000232 | Edwin Denby | D000232 | 403370 | 2493 | Edwin Denby (politician) | Q962646 | kg:/m/032d7y | Edwin | Denby | 1870-02-18 | M | 12119 | |||||||||||||||||
M001005 | John Morrow | M001005 | 412080 | 6729 | John Morrow (Virginia politician) | Q962532 | kg:/m/03c2_zj | John | Morrow | M | 18585 | ||||||||||||||||||
N000062 | Truman Newberry | N000062 | 408150 | 6890 | Truman Handy Newberry | Q962189 | kg:/m/039gtd | Truman | Newberry | 1864-11-05 | M | Handy | |||||||||||||||||
S001218 | Melanie Stansbury | S001218 | 456861 | Melanie Stansbury | Q96184996 | Melanie | Stansbury | 1979-01-31 | F | Ann | Melanie Ann Stansbury | Melanie A. Stansbury | N00047871 | [ "H2NM01144" ] |
|||||||||||||||
T000141 | George Thatcher | T000141 | 410723 | 9268 | George Thatcher | Q961579 | kg:/m/06dfhc | George | Thatcher | 1754-04-12 | M | 22804 | |||||||||||||||||
C000037 | Joseph Caldwell | C000037 | 402198 | 1411 | Joseph Pearson Caldwell | Q961529 | kg:/m/0bmnms | Joseph | Caldwell | 1808-03-05 | M | 10488 | Pearson | ||||||||||||||||
G000525 | James Gunn | G000525 | 404871 | 3878 | James Gunn (congressman) | Q961524 | kg:/m/01vsjy | James | Gunn | 1843-03-06 | M | 14223 | |||||||||||||||||
C000171 | Matthew Carpenter | C000171 | 402319 | 1524 | Matthew H. Carpenter | Q961204 | kg:/m/02k43p | Matthew | Carpenter | 1824-12-22 | M | Hale | |||||||||||||||||
D000034 | John Daniel | D000034 | 403174 | 2324 | John Reeves Jones Daniel | Q960807 | kg:/m/0bmjt1 | John | Daniel | 1802-01-13 | M | 11871 | Reeves Jones | ||||||||||||||||
L000561 | Joseph LeFante | L000561 | 406715 | 14433 | Joseph A. LeFante | Q960792 | kg:/m/02rtnqx | Joseph | LeFante | 1928-09-08 | M | 17299 | Anthony | 00677 | |||||||||||||||
M001214 | Frank Mrvan | M001214 | 456821 | Frank J. Mrvan | Q96077897 | kg:/g/11gtz3tlbh | Frank | Mrvan | 1969-04-16 | M | John | Frank J. Mrvan | N00045905 | [ "H0IN01150" ] |
|||||||||||||||
B000113 | William Bankhead | B000113 | 401114 | 406 | William B. Bankhead | Q960737 | kg:/m/01ncsq | William | Bankhead | 1874-04-12 | M | 7674 | Brockman | ||||||||||||||||
L000273 | Teresa Leger Fernandez | L000273 | 456835 | Teresa Leger Fernandez | Q96054905 | kg:/g/11h_x7n8f5 | Teresa | Leger Fernandez | 1959-07-01 | F | Teresa Leger Fernandez | N00044559 | [ "H0NM03102" ] |
||||||||||||||||
A000344 | John Averill | A000344 | 400994 | 298 | John T. Averill | Q960453 | kg:/m/0dqmhj | John | Averill | 1825-03-01 | M | 8734 | Thomas | ||||||||||||||||
M000165 | Gilman Marston | M000165 | 407187 | 6011 | Gilman Marston | Q960133 | kg:/m/0d4xj4 | Gilman | Marston | 1811-08-20 | M | 17529 | |||||||||||||||||
B000787 | John Breckinridge | B000787 | 401744 | 994 | John Breckinridge (U.S. Attorney General) | Q959976 | kg:/m/0184mx | John | Breckinridge | 1760-12-02 | M | ||||||||||||||||||
Y000028 | Andrew Young | Y000028 | 411962 | 14063 | Andrew Young | Q959635 | kg:/m/018t4c | Andrew | Young | 1932-03-12 | M | 21064 | Jackson | Jr. | 01254 | ||||||||||||||
L000517 | Daniel Lungren | L000517 | 400617 | 14647 | Dan Lungren | Q959610 | kg:/m/04dfzd | Daniel | Lungren | 1946-09-22 | M | 17238 | E. | 00717 | 16730 | Daniel E. Lungren | N00011971 | [ "H6CA34112" ] |
|||||||||||
C001049 | Wm. Clay | C001049 | 400074 | 20147 | Lacy Clay | Q959455 | kg:/m/024vjr | Wm. | Clay | 1956-07-27 | M | 11766 | Lacy | William Lacy Clay | Jr. | 01654 | 88332 | 8967 | Wm. Lacy Clay | N00012460 | [ "H0MO01066" ] |
191 | [ { "name": "William Lacy Clay Sr.", "relation": "son" } ] |
||||||
H001043 | Paul Hodes | H001043 | 412220 | 20732 | Paul Hodes | Q959262 | kg:/m/0d1mb3 | Paul | Hodes | 1951-03-21 | M | 15582 | W. | 01862 | 1018918 | 42473 | N00027048 | [ "H4NH02175" ] |
|||||||||||
S000644 | Reed Smoot | S000644 | 410118 | 8713 | Reed Smoot | Q959249 | kg:/m/01sx8l | Reed | Smoot | 1862-01-10 | M | ||||||||||||||||||
M000212 | Frank Mascara | M000212 | 400545 | 29562 | Frank Mascara | Q959210 | kg:/m/09mxzc | Frank | Mascara | 1930-01-19 | M | 17585 | 00745 |
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);