legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_google_entity_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
M000794 | Norman Mineta | M000794 | 407772 | 14257 | Norman Mineta | Q553502 | kg:/m/013y3t | Norman | Mineta | 1931-11-12 | M | 18323 | Yoshio | 00812 | |||||||||||||||
L000393 | Henry Lodge | L000393 | 406885 | 5738 | Henry Cabot Lodge | Q174037 | kg:/m/013zjl | Henry | Lodge | 1850-05-12 | M | 17082 | Cabot | ||||||||||||||||
L000394 | Henry Lodge | L000394 | 406886 | 5739 | Henry Cabot Lodge Jr. | Q450984 | kg:/m/013zk9 | Henry | Lodge | 1902-07-05 | M | Cabot | Jr. | ||||||||||||||||
L000447 | Trent Lott | L000447 | 300069 | 14031 | Trent Lott | Q50608 | kg:/m/014sn2 | Trent | Lott | 1941-10-09 | M | 17151 | 00707 | 1886 | 53311 | S203 | N00003329 | [ "S8MS00162" ] |
|||||||||||
F000439 | William Frist | F000439 | 300045 | 49502 | Bill Frist | Q31112 | kg:/m/0154r3 | William | Frist | 1952-02-22 | M | H. | Bill | 01336 | S241 | N00003147 | |||||||||||||
Q000009 | Manuel Quezon | Q000009 | 408972 | Manuel L. Quezon | Q1503 | kg:/m/015865 | Manuel | Quezon | 1878-08-19 | M | 20053 | Luis | |||||||||||||||||
H000163 | Marcus Hanna | H000163 | 405045 | 4039 | Mark Hanna | Q509441 | kg:/m/015jv7 | Marcus | Hanna | 1837-09-24 | M | Alonzo | |||||||||||||||||
P000354 | Charles Pinckney | P000354 | 408751 | 7455 | Charles Pinckney (governor) | Q662054 | kg:/m/015q74 | Charles | Pinckney | 1757-10-26 | M | 19719 | |||||||||||||||||
M000157 | John Marshall | M000157 | 407179 | 6003 | John Marshall | Q310829 | kg:/m/015rgm | John | Marshall | 1755-09-24 | M | 17518 | John Marshall (Supreme Court) | ||||||||||||||||
G000132 | Richard Gephardt | G000132 | 400146 | 14421 | Dick Gephardt | Q1209677 | kg:/m/0163l9 | Richard | Gephardt | 1941-01-31 | M | 13727 | Andrew | Dick | 00433 | N00005037 | |||||||||||||
E000286 | John Edwards | E000286 | 300039 | 49902 | John Edwards | Q217314 | kg:/m/01651q | John | Edwards | 1953-06-10 | M | Reid | 01573 | 21107 | S267 | N00002283 | |||||||||||||
F000437 | Duncan Faircloth | F000437 | 403968 | 49304 | Lauch Faircloth | Q1406773 | kg:/m/01658l | Duncan | Faircloth | 1928-01-14 | M | McLauchlin | Lauch | 01329 | S227 | ||||||||||||||
M000311 | Eugene McCarthy | M000311 | 407324 | 6134 | Eugene McCarthy | Q380550 | kg:/m/01692s | Eugene | McCarthy | 1916-03-29 | M | 17709 | Joseph | ||||||||||||||||
G000365 | Phil Gramm | G000365 | 300159 | 14628 | Phil Gramm | Q2613704 | kg:/m/016l53 | Phil | Gramm | 1942-07-08 | M | 14023 | 00453 | S171 | |||||||||||||||
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" ] |
|||||||||
H000338 | Orrin Hatch | H000338 | 300052 | 14503 | Orrin Hatch | Q381157 | kg:/m/016mj4 | Orrin | Hatch | 1934-03-22 | M | G. | Orrin Hatch | 01351 | 189 | 53352 | S118 | Orrin G. Hatch | N00009869 | [ "S6UT00063", "P00003806" ] |
574 | ||||||||
L000030 | Lucius Lamar | L000030 | 406540 | 5416 | Lucius Quintus Cincinnatus Lamar | Q1549250 | kg:/m/016trm | Lucius | Lamar | 1825-09-17 | M | 16613 | Quintus Cincinnatus | ||||||||||||||||
S000793 | Leland Stanford | S000793 | 410259 | 8836 | Leland Stanford | Q382109 | kg:/m/016ycj | Leland | Stanford | 1824-03-09 | M | ||||||||||||||||||
D000457 | Stephen Douglas | D000457 | 403567 | 2692 | Stephen A. Douglas | Q433174 | kg:/m/0170hg | Stephen | Douglas | 1813-04-23 | M | 12404 | Arnold | ||||||||||||||||
B001130 | Ambrose Burnside | B001130 | 402074 | 1299 | Ambrose Burnside | Q355444 | kg:/m/0170j5 | Ambrose | Burnside | 1824-05-23 | M | Everett | |||||||||||||||||
G000405 | Horace Greeley | G000405 | 404755 | 3773 | Horace Greeley | Q436790 | kg:/m/0170ll | Horace | Greeley | 1811-02-03 | M | 14077 | |||||||||||||||||
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" ] |
|||||||||||
W000338 | Joseph Wheeler | W000338 | 411500 | 9992 | Joseph Wheeler | Q1708240 | kg:/m/01720p | Joseph | Wheeler | 1836-09-10 | M | 23619 | |||||||||||||||||
L000497 | Clare Luce | L000497 | 406984 | 5827 | Clare Boothe Luce | Q456413 | kg:/m/0177y3 | Clare | Luce | 1903-03-10 | F | 17213 | Boothe | ||||||||||||||||
W000779 | Ron Wyden | W000779 | 300100 | 14871 | Ron Wyden | Q529344 | kg:/m/0178p9 | Ron | Wyden | 1949-05-03 | M | 24150 | Ron Wyden | 01247 | 1962 | 27036 | S247 | Ron Wyden | N00007724 | [ "S6OR00110", "H0OR03026" ] |
619 | ||||||||
P000203 | George Pendleton | P000203 | 408606 | 7319 | George H. Pendleton | Q552459 | kg:/m/017j9x | George | Pendleton | 1825-07-19 | M | 19527 | Hunt | ||||||||||||||||
B001167 | Prescott Bush | B001167 | 402109 | 1329 | Prescott Bush | Q324742 | kg:/m/017jh1 | Prescott | Bush | 1895-05-15 | M | Sheldon | |||||||||||||||||
J000140 | Hiram Johnson | J000140 | 406039 | 4962 | Hiram Johnson | Q143644 | kg:/m/017n7f | Hiram | Johnson | 1866-09-02 | M | Warren | |||||||||||||||||
M000102 | Horace Mann | M000102 | 407126 | 5957 | Horace Mann | Q1151173 | kg:/m/0182p8 | Horace | Mann | 1796-05-04 | M | 17457 | |||||||||||||||||
B000787 | John Breckinridge | B000787 | 401744 | 994 | John Breckinridge (U.S. Attorney General) | Q959976 | kg:/m/0184mx | John | Breckinridge | 1760-12-02 | M | ||||||||||||||||||
L000403 | John Logan | L000403 | 406894 | 5746 | John A. Logan | Q954410 | kg:/m/018cdz | John | Logan | 1826-02-09 | M | 17094 | Alexander | ||||||||||||||||
G000225 | Newton Gingrich | G000225 | 404587 | 14627 | Newt Gingrich | Q182788 | kg:/m/018fzs | Newton | Gingrich | 1943-06-17 | M | 13850 | Leroy | Newt Gingrich | 00441 | 26821 | N00008333 | ||||||||||||
M001111 | Patty Murray | M001111 | 300076 | 49308 | Patty Murray | Q258825 | kg:/m/018qx5 | Patty | Murray | 1950-10-11 | F | 18715 | Patty Murray | 01409 | 25277 | 53358 | S229 | Patty Murray | N00007876 | [ "S2WA00189" ] |
596 | [ { "title": "Assistant Senate Minority Leader", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Assistant Senate Minority Leader", "chamber": "senate", "start": "2021-01-03", "end": "2021-01-20" }, { "title": "Assistant Senate Majority Leader", "chamber": "senate", "start": "2021-01-20" } ] |
|||||||
S000888 | Ted Stevens | S000888 | 300094 | 12109 | Ted Stevens | Q50599 | kg:/m/018r3g | Ted | Stevens | 1923-11-18 | M | F. | 01440 | 53268 | S090 | N00007997 | [ "S2AK00010" ] |
||||||||||||
Y000028 | Andrew Young | Y000028 | 411962 | 14063 | Andrew Young | Q959635 | kg:/m/018t4c | Andrew | Young | 1932-03-12 | M | 21064 | Jackson | Jr. | 01254 | ||||||||||||||
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" ] |
|||||||||||
P000568 | Joseph Pulitzer | P000568 | 408951 | 7651 | Joseph Pulitzer | Q173417 | kg:/m/019541 | Joseph | Pulitzer | 1847-04-10 | M | 19987 | |||||||||||||||||
M001025 | Carol Moseley Braun | M001025 | 407992 | 49303 | Carol Moseley Braun | Q289396 | kg:/m/019k2w | Carol | Moseley Braun | 1947-08-16 | F | 18611 | 01405 | S226 | |||||||||||||||
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" ] |
|||||||||||
L000550 | Mary Landrieu | L000550 | 300063 | 49702 | Mary Landrieu | Q22338 | kg:/m/019tyn | Mary | Landrieu | 1955-11-23 | F | 17280 | L. | Mary Landrieu | 01546 | 22357 | 661 | S258 | Mary L. Landrieu | N00005395 | [ "S6LA00227", "P00003483" ] |
584 | |||||||
C000332 | Salmon Chase | C000332 | 402473 | 1672 | Salmon P. Chase | Q433051 | kg:/m/019vz0 | Salmon | Chase | 1808-01-13 | M | Portland | Salmon Portland Chase | ||||||||||||||||
H000618 | James Hillhouse | H000618 | 405477 | 4433 | James Hillhouse | Q373534 | kg:/m/01_03n | James | Hillhouse | 1754-10-20 | M | 15049 | |||||||||||||||||
T000009 | Robert Taft | T000009 | 410599 | 9152 | Robert A. Taft | Q519730 | kg:/m/01_5y1 | Robert | Taft | 1889-09-08 | M | Alphonso | |||||||||||||||||
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" ] |
||||||||||
M000755 | Stephen Miller | M000755 | 407733 | 6509 | Stephen Decatur Miller | Q883777 | kg:/m/01_b06 | Stephen | Miller | 1787-05-08 | M | 18273 | Decatur | ||||||||||||||||
W000376 | Hugh White | W000376 | 411537 | 10029 | Hugh Lawson White | Q1634433 | kg:/m/01_ftb | Hugh | White | 1773-10-30 | M | Lawson | |||||||||||||||||
S000033 | Bernard Sanders | S000033 | 400357 | 29147 | Bernie Sanders | Q359442 | kg:/m/01_gbv | Bernard | Sanders | 1941-09-08 | M | 21173 | Bernie | Bernie Sanders | 01010 | 994 | 27110 | S313 | Bernard Sanders | N00000528 | [ "H8VT01016", "S4VT00033" ] |
450 | |||||||
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" ] |
||||||||||
S000487 | John Slidell | S000487 | 409975 | 8575 | John Slidell | Q3182472 | kg:/m/01_nrx | John | Slidell | M | 21747 | ||||||||||||||||||
N000032 | Bill Nelson | N000032 | 300078 | 14651 | Bill Nelson | Q358437 | kg:/m/01_pb_ | Bill | Nelson | 1942-09-29 | M | 18875 | Bill Nelson (Florida) | 00859 | 1931 | 1606 | S282 | Bill Nelson | N00009926 | [ "S8FL00166" ] |
598 | ||||||||
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" ] |
||||||||||
H001028 | Charles Hagel | H001028 | 300050 | 49704 | Chuck Hagel | Q381670 | kg:/m/01_pcr | Charles | Hagel | 1946-10-04 | M | T. | Chuck | 01545 | 231 | S255 | N00005301 | [ "S6NE00087" ] |
|||||||||||
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 | |||||||
R000307 | Pat Roberts | R000307 | 300083 | 14852 | Pat Roberts | Q538375 | kg:/m/01_pdv | Pat | Roberts | 1936-04-20 | M | 20465 | Pat Roberts | 00968 | 16354 | 26866 | S260 | Pat Roberts | N00005285 | [ "S6KS00080", "H0KS01016" ] |
602 | ||||||||
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 | ||||||||||||
V000126 | George Voinovich | V000126 | 300098 | 49903 | George Voinovich | Q529873 | kg:/m/01_pgn | George | Voinovich | 1936-07-15 | M | V. | 01575 | 1783 | 21745 | S271 | N00003583 | [ "S8OH00011" ] |
|||||||||||
W000570 | Charles Wilson | W000570 | 411725 | 14062 | Charlie Wilson (Texas politician) | Q333430 | kg:/m/01_rx2 | Charles | Wilson | 1933-06-01 | M | 23891 | 01232 | ||||||||||||||||
F000251 | Henry Foote | F000251 | 404204 | 3259 | Henry S. Foote | Q365808 | kg:/m/01_x3d | Henry | Foote | 1804-02-28 | M | Stuart | |||||||||||||||||
S000887 | Thaddeus Stevens | S000887 | 410349 | 8917 | Thaddeus Stevens | Q1353767 | kg:/m/01_ymw | Thaddeus | Stevens | 1792-04-04 | M | 22236 | |||||||||||||||||
O000035 | Tasker Oddie | O000035 | 408320 | 7023 | Tasker Oddie | Q164438 | kg:/m/01b00d | Tasker | Oddie | 1870-10-20 | M | Lowndes | |||||||||||||||||
H000548 | Christian Herter | H000548 | 405410 | 4371 | Christian Herter | Q240274 | kg:/m/01b0fq | Christian | Herter | 1895-03-28 | M | 14962 | Archibald | ||||||||||||||||
G000352 | Bob Graham | G000352 | 300046 | 15503 | Bob Graham | Q578102 | kg:/m/01b2yl | Bob | Graham | 1936-11-09 | M | 01342 | S199 | N00002742 | |||||||||||||||
H000263 | Benjamin Harrison | H000263 | 405139 | 4124 | Benjamin Harrison | Q35678 | kg:/m/01b61 | Benjamin | Harrison | 1833-08-20 | M | ||||||||||||||||||
T000086 | John Taylor | T000086 | 410668 | 9215 | John Taylor of Caroline | Q6205057 | kg:/m/01bfkt | John | Taylor | 1753-12-19 | M | ||||||||||||||||||
H001035 | Katherine Harris | H001035 | 400167 | 20314 | Katherine Harris | Q272787 | kg:/m/01bkwl | Katherine | Harris | 1957-04-05 | F | 15566 | 01714 | N00024882 | |||||||||||||||
F000142 | Hamilton Fish | F000142 | 404096 | 3162 | Hamilton Fish III | Q1573501 | kg:/m/01bq5d | Hamilton | Fish | 1888-12-07 | M | 13150 | |||||||||||||||||
L000366 | Edward Livingston | L000366 | 406858 | 5715 | Edward Livingston | Q544396 | kg:/m/01bxb3 | Edward | Livingston | 1764-05-28 | M | 17050 | |||||||||||||||||
O000146 | John Overton | O000146 | 408397 | 7126 | John H. Overton | Q504589 | kg:/m/01bz05 | John | Overton | 1875-09-17 | M | 19247 | Holmes | ||||||||||||||||
B000884 | Overton Brooks | B000884 | 401841 | 1081 | Overton Brooks | Q2042456 | kg:/m/01bz3m | Overton | Brooks | 1897-12-21 | M | 9922 | |||||||||||||||||
B000711 | Barbara Boxer | B000711 | 300011 | 15011 | Barbara Boxer | Q237560 | kg:/m/01c1n5 | Barbara | Boxer | 1940-11-11 | F | 9704 | Barbara Boxer | 00116 | 2470 | 53274 | S223 | Barbara Boxer | N00006692 | [ "S2CA00286", "H2CA06028", "P80003247" ] |
539 | ||||||||
O000077 | William Oliver | O000077 | 408350 | 7064 | William Bacon Oliver | Q2577941 | kg:/m/01c3zp | William | Oliver | 1867-05-23 | M | 19161 | Bacon | ||||||||||||||||
H000287 | Gary Hart | H000287 | 405161 | 14305 | Gary Hart | Q919448 | kg:/m/01cg_2 | Gary | Hart | 1936-11-28 | M | Warren | 01347 | ||||||||||||||||
T000274 | Benjamin Tillman | T000274 | 410847 | 9386 | Benjamin Tillman | Q736903 | kg:/m/01chqh | Benjamin | Tillman | 1847-08-11 | M | Ryan | |||||||||||||||||
M001054 | Daniel Moynihan | M001054 | 400563 | 14508 | Daniel Patrick Moynihan | Q713505 | kg:/m/01cny9 | Daniel | Moynihan | 1927-03-16 | M | Patrick | 01407 | S113 | |||||||||||||||
M001063 | Frederick Muhlenberg | M001063 | 408029 | 6781 | Frederick Muhlenberg | Q724629 | kg:/m/01d0wm | Frederick | Muhlenberg | 1750-01-01 | M | 18657 | Augustus Conrad | ||||||||||||||||
L000504 | Richard Lugar | L000504 | 300070 | 14506 | Richard Lugar | Q363079 | kg:/m/01d_bx | Richard | Lugar | 1932-04-04 | M | G. | 01387 | 255 | 53292 | S105 | Richard G. Lugar | N00001764 | [ "S4IN00014" ] |
||||||||||
R000243 | Thomas Ridge | R000243 | 409219 | 15056 | Tom Ridge | Q559822 | kg:/m/01d_c9 | Thomas | Ridge | 1945-08-26 | M | 20385 | Joseph | 00960 | |||||||||||||||
C000607 | Cornelius Cole | C000607 | 402736 | 1921 | Cornelius Cole | Q432348 | kg:/m/01dgv5 | Cornelius | Cole | 1822-09-17 | M | 11210 | |||||||||||||||||
N000033 | Gaylord Nelson | N000033 | 408123 | 10816 | Gaylord Nelson | Q886966 | kg:/m/01dpb_ | Gaylord | Nelson | 1916-06-04 | M | Anton | 01411 | ||||||||||||||||
H000457 | John Heiskell | H000457 | 405322 | 4287 | John N. Heiskell | Q1027673 | kg:/m/01drxb | John | Heiskell | 1872-11-02 | M | Netherland | |||||||||||||||||
S000595 | Nathaniel Smith | S000595 | 410075 | 8671 | Nathaniel Smith | Q1966804 | kg:/m/01dzj8 | Nathaniel | Smith | 1762-01-06 | M | 21870 | |||||||||||||||||
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" ] |
|||||||||||
B000594 | Thomas Boggs | B000594 | 401562 | 824 | Hale Boggs | Q1567156 | kg:/m/01f9y8 | Thomas | Boggs | 1914-02-15 | M | 9547 | Hale | Sr. | |||||||||||||||
B000169 | Bob Barr | B000169 | 400514 | 29511 | Bob Barr | Q540544 | kg:/m/01fdg8 | Bob | Barr | 1948-11-05 | M | 8990 | 00056 | 22028 | N00002526 | ||||||||||||||
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 | ||||||||||
C000567 | Thad Cochran | C000567 | 300023 | 14009 | Thad Cochran | Q723896 | kg:/m/01fmcd | Thad | Cochran | 1937-12-07 | M | 11160 | Thad Cochran | 00213 | 1200 | 53312 | S136 | Thad Cochran | N00003328 | [ "S8MS00055" ] |
549 | ||||||||
D000217 | Thomas DeLay | D000217 | 400104 | 15094 | Tom DeLay | Q180390 | kg:/m/01fnd0 | Thomas | DeLay | 1947-04-08 | M | 12103 | Dale | Tom | 00282 | N00005892 | |||||||||||||
D000558 | Pierre du Pont | D000558 | 403617 | 13014 | Pete du Pont | Q163957 | kg:/m/01fnfc | Pierre | du Pont | 1935-01-22 | M | 12521 | Samuel, IV | 00319 | |||||||||||||||
B001243 | Marsha Blackburn | B001243 | 400032 | 20351 | Marsha Blackburn | Q458971 | kg:/m/01fnkt | Marsha | Blackburn | 1952-06-06 | F | 10385 | W. | Marsha Blackburn | 01748 | 31226 | 25186 | S396 | Marsha Blackburn | N00003105 | [ "H2TN06030", "S8TN00337" ] |
151 | |||||||
B000365 | Judah Benjamin | B000365 | 401357 | 627 | Judah P. Benjamin | Q466115 | kg:/m/01fptq | Judah | Benjamin | 1811-08-06 | M | Philip | |||||||||||||||||
A000079 | James Alcorn | A000079 | 400738 | 67 | James L. Alcorn | Q886035 | kg:/m/01fszc | James | Alcorn | 1816-11-04 | M | Lusk | |||||||||||||||||
S000151 | Carl Schurz | S000151 | 409658 | 8279 | Carl Schurz | Q127437 | kg:/m/01ftf7 | Carl | Schurz | 1829-03-02 | M | ||||||||||||||||||
H000735 | David Holmes | H000735 | 405586 | 4532 | David Holmes (politician) | Q375788 | kg:/m/01fvcx | David | Holmes | 1769-03-10 | M | 15192 | |||||||||||||||||
T000085 | John Taylor | T000085 | 410669 | 9216 | John Taylor (South Carolina governor) | Q883164 | kg:/m/01fwhh | John | Taylor | 1770-05-04 | M | 22740 | |||||||||||||||||
S000852 | John Stennis | S000852 | 410315 | 8883 | John C. Stennis | Q1699509 | kg:/m/01fyp6 | John | Stennis | 1901-08-03 | M | Cornelius | 01439 | ||||||||||||||||
A000172 | Adelbert Ames | A000172 | 400827 | 152 | Adelbert Ames | Q354194 | kg:/m/01g287 | Adelbert | Ames | 1835-10-31 | M | ||||||||||||||||||
B000699 | Chester Bowles | B000699 | 401661 | 913 | Chester Bowles | Q880817 | kg:/m/01g7jw | Chester | Bowles | 1901-04-05 | M | 9690 | Bliss | ||||||||||||||||
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" } ] |
||||||||
B000460 | Theodore Bilbo | B000460 | 401445 | 710 | Theodore G. Bilbo | Q725728 | kg:/m/01gb8j | Theodore | Bilbo | 1877-10-13 | M | Gilmore | |||||||||||||||||
F000092 | Woodbridge Ferris | F000092 | 404049 | 3120 | Woodbridge Nathan Ferris | Q880349 | kg:/m/01gc2c | Woodbridge | Ferris | 1853-01-06 | M | Nathan |
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);