legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by name_first
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
S000664 | Adam Snyder | S000664 | 410137 | 8731 | Adam W. Snyder | Q4120846 | kg:/m/02rk8sg | Adam | Snyder | 1799-10-06 | M | 21956 | Wilson | ||||||||||||||||
S001150 | Adam Schiff | S001150 | 400361 | 20104 | Adam Schiff | Q350843 | kg:/m/024tls | Adam | Schiff | 1960-06-22 | M | 22560 | B. | Adam Schiff | 01635 | 90167 | 9489 | Adam B. Schiff | N00009585 | [ "H0CA27085" ] |
453 | ||||||||
W000776 | Adam Wyant | W000776 | 411925 | 10404 | Adam Martin Wyant | Q4679453 | kg:/m/0fsctg | Adam | Wyant | 1869-09-15 | M | 24145 | Martin | ||||||||||||||||
T000036 | Adamson Tannehill | T000036 | 410625 | 9175 | Adamson Tannehill | Q4680505 | kg:/m/027gbs7 | Adamson | Tannehill | 1750-05-23 | M | 22677 | |||||||||||||||||
F000298 | Addison Foster | F000298 | 404247 | 3300 | Addison G. Foster | Q353127 | kg:/m/0cvhcy | Addison | Foster | 1837-01-28 | M | Gardner | |||||||||||||||||
J000043 | Addison James | J000043 | 405948 | 4878 | Addison James | Q353132 | kg:/m/02qrc2z | Addison | James | 1850-02-27 | M | 15745 | Davis | ||||||||||||||||
L000017 | Addison Laflin | L000017 | 406527 | 5399 | Addison H. Laflin | Q4681252 | kg:/m/026gsrv | Addison | Laflin | 1823-10-24 | M | 16597 | Henry | ||||||||||||||||
M000344 | Addison McClure | M000344 | 407353 | 6161 | Addison S. McClure | Q24217 | kg:/m/02rlzlf | Addison | McClure | 1839-10-10 | M | 17754 | S. | ||||||||||||||||
S000511 | Addison Smith | S000511 | 409996 | 8598 | Addison T. Smith | Q353150 | kg:/m/0d5bgw | Addison | Smith | 1862-09-05 | M | 21775 | Taylor | ||||||||||||||||
W000350 | Addison White | W000350 | 411512 | 10004 | Addison White | Q353166 | kg:/m/026_sm0 | Addison | White | 1824-05-01 | M | 23632 | |||||||||||||||||
A000172 | Adelbert Ames | A000172 | 400827 | 152 | Adelbert Ames | Q354194 | kg:/m/01g287 | Adelbert | Ames | 1835-10-31 | M | ||||||||||||||||||
C000135 | Adin Capron | C000135 | 402285 | 1495 | Adin B. Capron | Q357297 | kg:/m/02rgtzb | Adin | Capron | 1841-01-09 | M | 10618 | Ballou | ||||||||||||||||
S000889 | Adlai Stevenson | S000889 | 410350 | 8918 | Adlai Stevenson I | Q310839 | kg:/m/0myqt | Adlai | Stevenson | 1835-10-23 | M | 22239 | Ewing | ||||||||||||||||
S000890 | Adlai Stevenson | S000890 | 410351 | 13102 | Adlai Stevenson III | Q122841 | kg:/m/036nl4 | Adlai | Stevenson | 1930-10-10 | M | Ewing | III | 01441 | |||||||||||||||
J000113 | Adna Johnson | J000113 | 406014 | 4938 | Adna R. Johnson | Q4683838 | kg:/m/02rlzls | Adna | Johnson | 1860-12-14 | M | 15834 | Romulus | ||||||||||||||||
M000679 | Adolph Meyer | M000679 | 407664 | 6448 | Adolph Meyer | Q365466 | kg:/m/0dd3ld | Adolph | Meyer | 1842-10-19 | M | 18175 | |||||||||||||||||
S000001 | Adolph Sabath | S000001 | 409522 | 8163 | Adolph J. Sabath | Q365407 | kg:/m/07y5bd | Adolph | Sabath | 1866-04-04 | M | 21133 | Joachim | ||||||||||||||||
N000029 | Adolphus Nelson | N000029 | 408120 | 6861 | Adolphus Peter Nelson | Q366015 | kg:/m/02z4ntm | Adolphus | Nelson | 1872-03-28 | M | 18871 | Peter | ||||||||||||||||
T000037 | Adolphus Tanner | T000037 | 410626 | 9176 | Adolphus H. Tanner | Q3090719 | kg:/m/02rklx8 | Adolphus | Tanner | 1833-05-23 | M | 22678 | Hitchcock | ||||||||||||||||
W000261 | Adonijah Welch | W000261 | 411429 | 9924 | Adonijah Welch | Q366106 | kg:/m/08ys9_ | Adonijah | Welch | 1821-04-12 | M | Strong | |||||||||||||||||
H000733 | Adoniram Holmes | H000733 | 405584 | 4530 | Adoniram J. Holmes | Q366115 | kg:/m/02rk713 | Adoniram | Holmes | 1842-03-02 | M | 15189 | Judson | ||||||||||||||||
W000151 | Adoniram Warner | W000151 | 411325 | 9830 | Adoniram J. Warner | Q4684523 | kg:/m/02rlzm3 | Adoniram | Warner | 1834-01-13 | M | 23389 | Judson | ||||||||||||||||
S001172 | Adrian Smith | S001172 | 412217 | 20729 | Adrian Smith (politician) | Q373443 | kg:/m/0c505n | Adrian | Smith | 1970-12-19 | M | 22600 | Adrian Smith | 01860 | 1022845 | 21284 | Adrian Smith | N00027623 | [ "H6NE03115" ] |
702 | |||||||||
E000297 | Adriano Espaillat | E000297 | 412718 | 21715 | Adriano Espaillat | Q4685569 | kg:/m/06nfs2 | Adriano | Espaillat | 1954-09-27 | M | Adriano Espaillat | 68413 | 14379 | Adriano Espaillat | N00034549 | [ "H2NY13096" ] |
2230 | |||||||||||
B001086 | Aedanus Burke | B001086 | 402032 | 1260 | Aedanus Burke | Q380504 | kg:/m/03yccv | Aedanus | Burke | 1743-06-16 | M | 10177 | |||||||||||||||||
M000790 | Ahiman Miner | M000790 | 407768 | 6543 | Ahiman Louis Miner | Q400248 | kg:/m/02rgtzp | Ahiman | Miner | 1804-09-23 | M | 18317 | Louis | ||||||||||||||||
F000255 | Aime Forand | F000255 | 404209 | 3264 | Aime Forand | Q405520 | kg:/m/027n6p4 | Aime | Forand | 1895-05-23 | M | 13294 | Joseph | ||||||||||||||||
G000553 | Al Green | G000553 | 400653 | 20529 | Al Green (politician) | Q749039 | kg:/m/02kn0_ | Al | Green | 1947-09-01 | M | 14265 | Al Green | 01803 | 1012969 | 49680 | Al Green | N00026686 | [ "H4TX09095" ] |
658 | |||||||||
L000586 | Al Lawson | L000586 | 412693 | 21732 | Al Lawson | Q4723052 | kg:/m/03cg0sv | Al | Lawson | 1948-09-23 | M | Alfred Lawson | Jr. | 90480 | 24263 | Al Lawson, Jr. | N00030642 | [ "H0FL02086" ] |
2205 | ||||||||||
B000436 | Alan Bible | B000436 | 401422 | 688 | Alan Bible | Q2636641 | kg:/m/03swfg | Alan | Bible | 1909-11-20 | M | Harvey | 01283 | ||||||||||||||||
C000877 | Alan Cranston | C000877 | 402990 | 12103 | Alan Cranston | Q1994957 | kg:/m/02rbm2 | Alan | Cranston | 1914-06-19 | M | 01311 | S023 | ||||||||||||||||
D000366 | Alan Dixon | D000366 | 403483 | 14902 | Alan J. Dixon | Q1886056 | kg:/m/049q6m | Alan | Dixon | 1927-07-07 | M | John | 01317 | S149 | |||||||||||||||
F000457 | Alan Franken | F000457 | 412378 | 40904 | Al Franken | Q319084 | kg:/m/01lct6 | Alan | Franken | 1951-05-21 | M | Stuart | Al | Al Franken | 01969 | 23334 | 108924 | S332 | Al Franken | N00029016 | [ "S8MN00438" ] |
1189 | |||||||
G000556 | Alan Grayson | G000556 | 412276 | 20908 | Alan Grayson | Q1281084 | kg:/m/04gtp5n | Alan | Grayson | 1958-03-13 | M | 14271 | Alan Grayson | 01914 | 1013409 | 68184 | Alan Grayson | N00028418 | [ "H6FL08213" ] |
758 | |||||||||
L000579 | Alan Lowenthal | L000579 | 412521 | 21313 | Alan Lowenthal | Q3740782 | kg:/m/027jz0m | Alan | Lowenthal | 1941-03-08 | M | S. | Alan Lowenthal | 02111 | 93815 | 16469 | Alan S. Lowenthal | N00033274 | [ "H2CA00104" ] |
1745 | |||||||||
M000844 | Alan Mollohan | M000844 | 400281 | 15083 | Alan Mollohan | Q1234572 | kg:/m/024zfh | Alan | Mollohan | 1943-05-14 | M | 18391 | B. | 00824 | 8577 | 27130 | N00002214 | [ "H2WV01029" ] |
|||||||||||
N000186 | Alan Nunnelee | N000186 | 412442 | 21147 | Alan Nunnelee | Q24043 | kg:/m/05zrc_g | Alan | Nunnelee | 1958-10-09 | M | 19068 | Alan Nunnelee | 02034 | 95058 | 8326 | Alan Nunnelee | N00031006 | [ "H0MS01043" ] |
1452 | |||||||||
S000429 | Alan Simpson | S000429 | 409923 | 14710 | Alan Simpson (American politician) | Q2636748 | kg:/m/03f_3t | Alan | Simpson | 1931-09-02 | M | Kooi | 01435 | 378 | S142 | ||||||||||||||
S000841 | Alan Steelman | S000841 | 410305 | 14054 | Alan Steelman | Q2636853 | kg:/m/0c2r63 | Alan | Steelman | 1942-03-15 | M | 22179 | Watson | 01106 | |||||||||||||||
W000326 | Alan Wheat | W000326 | 411488 | 15076 | Alan Wheat | Q548596 | kg:/m/03tdlw | Alan | Wheat | 1951-10-16 | M | 23604 | Dupree | 01218 | |||||||||||||||
W000688 | Alan Wood | W000688 | 411840 | 10318 | Alan Wood Jr. | Q4708090 | kg:/m/0ksyx0 | Alan | Wood | 1834-07-06 | M | 24036 | Jr. | ||||||||||||||||
H000813 | Alanson Houghton | H000813 | 405661 | 4602 | Alanson B. Houghton | Q821304 | kg:/m/0fyxmp | Alanson | Houghton | 1863-10-10 | M | 15288 | Bigelow | ||||||||||||||||
K000182 | Alanson Kimball | K000182 | 406344 | 5244 | Alanson M. Kimball | Q921198 | kg:/m/026s0n7 | Alanson | Kimball | 1827-03-12 | M | 16305 | Mellen | ||||||||||||||||
B000145 | Alben Barkley | B000145 | 401146 | 437 | Alben W. Barkley | Q273549 | kg:/m/0myyb | Alben | Barkley | 1877-11-24 | M | 8958 | William | ||||||||||||||||
A000180 | Albert Anderson | A000180 | 400835 | 159 | Albert R. Anderson | Q225943 | kg:/m/02rk72h | Albert | Anderson | 1837-11-08 | M | 8508 | Raney | ||||||||||||||||
A000339 | Albert Austin | A000339 | 400989 | 293 | Albert E. Austin | Q116257 | kg:/m/02rgt_0 | Albert | Austin | 1877-11-15 | M | 8728 | Elmer | ||||||||||||||||
B000245 | Albert Baumhart | B000245 | 401239 | 521 | Albert David Baumhart Jr. | Q4710010 | kg:/m/027m6z7 | Albert | Baumhart | 1908-06-15 | M | 9096 | David | Jr. | |||||||||||||||
B000414 | Albert Berry | B000414 | 401401 | 670 | Albert S. Berry | Q700005 | kg:/m/02rgv0r | Albert | Berry | 1836-05-13 | M | 9314 | Seaton | ||||||||||||||||
B000429 | Albert Beveridge | B000429 | 401415 | 683 | Albert J. Beveridge | Q982853 | kg:/m/04sjby | Albert | Beveridge | 1862-10-06 | M | Jeremiah | |||||||||||||||||
B000535 | Albert Blakeney | B000535 | 401510 | 776 | Albert Blakeney | Q759154 | kg:/m/09166n | Albert | Blakeney | 1850-09-28 | M | 9464 | Alexander | ||||||||||||||||
B000646 | Albert Bosch | B000646 | 401610 | 868 | Albert H. Bosch | Q868566 | kg:/m/0kt22l | Albert | Bosch | 1908-10-30 | M | 9620 | Henry | ||||||||||||||||
B000900 | Albert Brown | B000900 | 401857 | 1095 | Albert G. Brown | Q880583 | kg:/m/0464h2 | Albert | Brown | 1813-05-31 | M | 9945 | Gallatin | ||||||||||||||||
B001110 | Albert Burleson | B001110 | 402055 | 1281 | Albert S. Burleson | Q724135 | kg:/m/02t3g3 | Albert | Burleson | 1863-06-07 | M | 10207 | Sidney | ||||||||||||||||
B001134 | Albert Burr | B001134 | 402078 | 1303 | Albert G. Burr | Q4710255 | kg:/m/02pvqkk | Albert | Burr | 1829-11-08 | M | 10234 | George | ||||||||||||||||
B001172 | Albert Bustamante | B001172 | 402114 | 15089 | Albert Bustamante | Q2637741 | kg:/m/027hzz4 | Albert | Bustamante | 1935-04-08 | M | 10284 | Garza | 00158 | |||||||||||||||
C000070 | Albert Camp | C000070 | 402228 | 1439 | Albert Sidney Camp | Q2638829 | kg:/m/0gr_pl | Albert | Camp | 1892-07-26 | M | 10532 | Sidney | ||||||||||||||||
C000074 | Albert Campbell | C000074 | 402231 | 1441 | Albert J. Campbell | Q1723385 | kg:/m/02rgv01 | Albert | Campbell | 1857-12-12 | M | 10538 | James | ||||||||||||||||
C000162 | Albert Carnahan | C000162 | 402310 | 1517 | A. S. J. Carnahan | Q279153 | kg:/m/03ycb1 | Albert | Carnahan | 1897-01-09 | M | 10657 | Sidney Johnson | ||||||||||||||||
C000195 | Albert Carter | C000195 | 402341 | 1545 | Albert E. Carter | Q1485451 | kg:/m/0dfqw_ | Albert | Carter | 1881-07-05 | M | 10697 | Edward | ||||||||||||||||
C000290 | Albert Chandler | C000290 | 402432 | 1634 | Happy Chandler | Q573029 | kg:/m/01s8l0 | Albert | Chandler | 1898-07-14 | M | Benjamin | Happy | ||||||||||||||||
C000606 | Albert Cole | C000606 | 402735 | 1920 | Albert M. Cole | Q1431467 | kg:/m/02rm9cn | Albert | Cole | 1901-10-13 | M | 11208 | McDonald | ||||||||||||||||
C000708 | Albert Constable | C000708 | 402832 | 2008 | Albert Constable | Q1726968 | kg:/m/02qw3s6 | Albert | Constable | 1805-06-03 | M | 11340 | |||||||||||||||||
C000905 | Albert Cretella | C000905 | 403017 | 2174 | Albert W. Cretella | Q2638987 | kg:/m/02rgv1f | Albert | Cretella | 1897-04-22 | M | 11588 | William | ||||||||||||||||
C000988 | Albert Cummins | C000988 | 403096 | 2252 | Albert B. Cummins | Q377161 | kg:/m/037fr0 | Albert | Cummins | 1850-02-15 | M | Baird | |||||||||||||||||
D000150 | Albert Dawson | D000150 | 403283 | 2425 | Albert F. Dawson | Q2637869 | kg:/m/02rk71t | Albert | Dawson | 1872-01-26 | M | 12018 | Foster | ||||||||||||||||
D000449 | Albert Douglas | D000449 | 403559 | 2685 | Albert Douglas | Q4710044 | kg:/m/02rlzmt | Albert | Douglas | 1852-04-25 | M | 12392 | |||||||||||||||||
E000087 | Albert Egbert | E000087 | 403780 | 2879 | Albert Gallatin Egbert | Q4710276 | kg:/m/0kt1n6 | Albert | Egbert | 1828-04-13 | M | 12705 | Gallatin | ||||||||||||||||
E000178 | Albert Engel | E000178 | 403868 | 2963 | Albert J. Engel | Q2638222 | kg:/m/027jzq8 | Albert | Engel | 1888-01-01 | M | 12813 | Joseph | ||||||||||||||||
E000218 | Albert Espy | E000218 | 403904 | 15411 | Mike Espy | Q1400332 | kg:/m/03br4v | Albert | Espy | 1953-11-30 | M | 12872 | Michael | Mike Espy | 00356 | ||||||||||||||
E000224 | Albert Estopinal | E000224 | 403910 | 2996 | Albert Estopinal | Q1404345 | kg:/m/0c3w42 | Albert | Estopinal | 1845-01-30 | M | 12878 | |||||||||||||||||
F000011 | Albert Fall | F000011 | 403973 | 3053 | Albert B. Fall | Q1397640 | kg:/m/02qbq6 | Albert | Fall | 1861-11-26 | M | Bacon | |||||||||||||||||
F000285 | Albert Forsythe | F000285 | 404235 | 3288 | Albert P. Forsythe | Q4710941 | kg:/m/02rk8st | Albert | Forsythe | 1830-05-24 | M | 13332 | Palaska | ||||||||||||||||
G000020 | Albert Gallatin | G000020 | 404397 | 3437 | Albert Gallatin | Q500046 | kg:/m/01p369 | Albert | Gallatin | 1761-01-29 | M | 13588 | |||||||||||||||||
G000028 | Albert Gallup | G000028 | 404404 | 3443 | Albert Gallup | Q1659364 | kg:/m/02rkly9 | Albert | Gallup | 1796-01-30 | M | 13599 | |||||||||||||||||
G000305 | Albert Goodwyn | G000305 | 404664 | 3690 | Albert Taylor Goodwyn | Q1326598 | kg:/m/02rk19x | Albert | Goodwyn | 1842-12-17 | M | 13949 | Taylor | ||||||||||||||||
G000320 | Albert Gore | G000320 | 404678 | 3704 | Albert Gore Sr. | Q577160 | kg:/m/025wp3 | Albert | Gore | 1907-12-26 | M | 13968 | Arnold | ||||||||||||||||
G000321 | Albert Gore | G000321 | 404679 | 14423 | Al Gore | Q19673 | kg:/m/0d05fv | Albert | Gore | 1948-03-31 | M | 13970 | Arnold | Al Gore | Jr. | 00449 | S170 | ||||||||||||
G000424 | Albert Greene | G000424 | 404771 | 3788 | Albert C. Greene | Q2622636 | kg:/m/0d2l_x | Albert | Greene | 1792-04-15 | M | Collins | |||||||||||||||||
H000042 | Albert Hall | H000042 | 404927 | 3930 | Albert R. Hall (Indiana politician) | Q2638611 | kg:/m/02rkdrn | Albert | Hall | 1884-08-27 | M | 14339 | Richardson | ||||||||||||||||
H000261 | Albert Harrison | H000261 | 405138 | 4122 | Albert Galliton Harrison | Q996927 | kg:/m/02rz5d9 | Albert | Harrison | 1800-06-26 | M | 14607 | Galliton | ||||||||||||||||
H000360 | Albert Hawes | H000360 | 405229 | 4205 | Albert Gallatin Hawes | Q2638001 | kg:/m/02vl9f4 | Albert | Hawes | 1804-04-01 | M | 14724 | Gallatin | ||||||||||||||||
H000365 | Albert Hawkes | H000365 | 405234 | 4210 | Albert W. Hawkes | Q1675301 | kg:/m/0csxvw | Albert | Hawkes | 1878-11-20 | M | Wahl | |||||||||||||||||
H000530 | Albert Herlong | H000530 | 405392 | 4354 | Syd Herlong | Q2638906 | kg:/m/02rgvx8 | Albert | Herlong | 1909-02-14 | M | 14941 | Sydney | Jr. | |||||||||||||||
H000769 | Albert Hopkins | H000769 | 405619 | 4563 | Albert Cole Hopkins | Q4709953 | kg:/m/0ksflw | Albert | Hopkins | 1837-09-15 | M | 15237 | Cole | ||||||||||||||||
H000770 | Albert Hopkins | H000770 | 405620 | 4564 | Albert J. Hopkins | Q436348 | kg:/m/08568c | Albert | Hopkins | 1846-08-15 | M | 15239 | Jarvis | ||||||||||||||||
H000850 | Albert Howe | H000850 | 405697 | 4637 | Albert R. Howe | Q1679207 | kg:/m/02rtnk1 | Albert | Howe | 1840-01-01 | M | 15337 | Richards | ||||||||||||||||
J000067 | Albert Jefferis | J000067 | 405972 | 4901 | Albert W. Jefferis | Q132424 | kg:/m/0b7553 | Albert | Jefferis | 1868-12-07 | M | 15777 | Webb | ||||||||||||||||
J000081 | Albert Jenkins | J000081 | 405984 | 4912 | Albert G. Jenkins | Q2484581 | kg:/m/0d9wfj | Albert | Jenkins | 1830-11-10 | M | 15796 | Gallatin | ||||||||||||||||
J000114 | Albert Johnson | J000114 | 406015 | 4939 | Albert Johnson (congressman) | Q477245 | kg:/m/02rqbw5 | Albert | Johnson | 1869-03-05 | M | 15836 | |||||||||||||||||
J000115 | Albert Johnson | J000115 | 406016 | 10598 | Albert W. Johnson | Q4711410 | kg:/m/0dxttk | Albert | Johnson | 1906-04-17 | M | 15838 | Walter | 00597 | |||||||||||||||
M000123 | Albert Marchand | M000123 | 407147 | 5975 | Albert Gallatin Marchand | Q4710278 | kg:/m/026tc94 | Albert | Marchand | 1811-02-27 | M | 17481 | Gallatin | ||||||||||||||||
M000935 | Albert Morano | M000935 | 407904 | 6664 | Albert P. Morano | Q2638558 | kg:/m/02rgv0d | Albert | Morano | 1908-01-18 | M | 18506 | Paul | ||||||||||||||||
P000164 | Albert Pearson | P000164 | 408569 | 7285 | Albert J. Pearson | Q4710544 | kg:/m/02rlznh | Albert | Pearson | 1846-05-20 | M | 19481 | Jackson | ||||||||||||||||
P000407 | Albert Polk | P000407 | 408800 | 7505 | Albert F. Polk | Q2637870 | kg:/m/0gf24n | Albert | Polk | 1869-10-11 | M | 19784 | Fawcett | ||||||||||||||||
P000435 | Albert Porter | P000435 | 408826 | 7529 | Albert G. Porter | Q2638594 | kg:/m/0bvybp | Albert | Porter | 1824-04-20 | M | 19821 | Gallatin | ||||||||||||||||
Q000010 | Albert Quie | Q000010 | 408973 | 7671 | Al Quie | Q888927 | kg:/m/01jf7h | Albert | Quie | 1923-09-18 | M | 20055 | Harold | 00936 | |||||||||||||||
R000018 | Albert Rains | R000018 | 409000 | 7695 | Albert Rains | Q534486 | kg:/m/02rk19k | Albert | Rains | 1902-03-11 | M | 20097 | McKinley | ||||||||||||||||
R000137 | Albert Reeves | R000137 | 409116 | 7803 | Albert L. Reeves Jr. | Q1668288 | kg:/m/02rz5dn | Albert | Reeves | 1906-05-31 | M | 20250 | Lee | Jr. | |||||||||||||||
R000238 | Albert Riddle | R000238 | 409214 | 7891 | Albert G. Riddle | Q1418938 | kg:/m/02rlzn4 | Albert | Riddle | 1816-05-28 | M | 20378 | Gallatin | ||||||||||||||||
R000457 | Albert Rossdale | R000457 | 409421 | 8079 | Albert B. Rossdale | Q4709674 | kg:/m/02rklxz | Albert | Rossdale | 1878-10-23 | M | 20647 | Berger |
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);