legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by name_middle descending
This data as json, copyable, CSV (advanced)
Suggested facets: bio_gender, name_suffix, id_fec (array)
bio_birthday (date) >30 ✖
- 1802-06-12 4
- 1818-10-08 4
- 1898-04-12 4
- 1786-12-25 3
- 1789-10-20 3
- 1807-02-17 3
- 1808-02-11 3
- 1808-06-18 3
- 1808-09-21 3
- 1811-01-06 3
- 1811-11-11 3
- 1813-10-13 3
- 1813-12-25 3
- 1815-01-18 3
- 1817-04-22 3
- 1819-01-22 3
- 1821-04-12 3
- 1825-04-17 3
- 1826-10-08 3
- 1828-12-16 3
- 1829-03-02 3
- 1829-08-07 3
- 1836-11-15 3
- 1840-01-01 3
- 1841-04-08 3
- 1844-08-01 3
- 1847-09-10 3
- 1848-10-04 3
- 1850-08-25 3
- 1851-02-07 3
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
M000965 | Edward Morrell | M000965 | 407933 | 6692 | Edward de Veaux Morrell | Q5346049 | kg:/m/0g7sw3 | Edward | Morrell | 1863-08-07 | M | 18539 | de Veaux | ||||||||||||||||
M000634 | George Meiklejohn | M000634 | 407621 | 6409 | George de Rue Meiklejohn | Q1508683 | kg:/m/0b0td4 | George | Meiklejohn | 1857-08-26 | M | 18117 | de Rue | ||||||||||||||||
P000493 | Julien Poydras | P000493 | 408878 | Julien de Lallande Poydras | Q1712278 | kg:/m/01t00g | Julien | Poydras | 1740-04-03 | M | 19890 | de Lallande | |||||||||||||||||
P000193 | Claiborne Pell | P000193 | 408597 | 10818 | Claiborne Pell | Q1094716 | kg:/m/01s7lb | Claiborne | Pell | 1918-11-22 | M | de Borda | 01417 | S078 | |||||||||||||||
A000196 | John Anderson | A000196 | 400851 | 173 | Jack Z. Anderson | Q1253601 | kg:/m/02rl0n0 | John | Anderson | 1904-03-22 | M | 8529 | Zuinglius | ||||||||||||||||
M000319 | Andrew McCarty | M000319 | 407330 | 6138 | Andrew Z. McCarty | Q4759005 | kg:/m/02rkm7z | Andrew | McCarty | 1808-07-14 | M | 17721 | Zimmerman | ||||||||||||||||
B000649 | Reva Bosone | B000649 | 401613 | 869 | Reva Beck Bosone | Q2146738 | kg:/m/02rm4zb | Reva | Bosone | 1895-04-02 | F | 9625 | Zilpha Beck | ||||||||||||||||
L000048 | Silas Landes | L000048 | 406557 | 5431 | Silas Z. Landes | Q7514251 | kg:/m/02rkcyj | Silas | Landes | 1842-05-15 | M | 16643 | Zephaniah | ||||||||||||||||
O000112 | Henry Osborne | O000112 | 408368 | 7093 | Henry Z. Osborne | Q1607444 | kg:/m/027y46r | Henry | Osborne | 1848-10-04 | M | 19205 | Zenas | ||||||||||||||||
B000705 | Selwyn Bowman | B000705 | 401667 | 919 | Selwyn Z. Bowman | Q2268797 | kg:/m/02rjz9m | Selwyn | Bowman | 1840-05-11 | M | 9696 | Zadock | ||||||||||||||||
G000295 | John Goodrich | G000295 | 404654 | 3680 | John Z. Goodrich | Q1543164 | kg:/m/0gl_1w | John | Goodrich | 1804-09-27 | M | 13938 | Zacheus | ||||||||||||||||
S000708 | James Spearing | S000708 | 410179 | 8771 | James Z. Spearing | Q1681331 | kg:/m/02rv9br | James | Spearing | 1864-04-23 | M | 22012 | Zacharie | ||||||||||||||||
G000127 | James George | G000127 | 404497 | 3532 | James Z. George | Q5755975 | kg:/m/0348sm | James | George | 1826-10-20 | M | Zachariah | |||||||||||||||||
L000339 | Romulus Linney | L000339 | 406832 | 5690 | Romulus Zachariah Linney | Q2165350 | kg:/m/04gm13 | Romulus | Linney | 1841-12-26 | M | 17014 | Zachariah | ||||||||||||||||
B001245 | Madeleine Bordallo | B001245 | 400041 | Madeleine Bordallo | Q292988 | kg:/m/01s_xp | Madeleine | Bordallo | 1933-05-31 | F | 10389 | Z. | 01723 | 1003568 | 1751 | Madeleine Z. Bordallo | N00024866 | [ "H2GU00033" ] |
160 | ||||||||||
A000376 | Colin Allred | A000376 | 412828 | 21900 | Colin Allred | Q5144845 | Colin | Allred | 1983-04-15 | M | Z. | Colin Allred | 177357 | Colin Z. Allred | N00040989 | [ "H8TX32098" ] |
|||||||||||||
S000550 | Hiram Smith | S000550 | 410032 | 8632 | Hiram Y. Smith | Q1264554 | kg:/m/02rd7db | Hiram | Smith | 1843-03-22 | M | 21817 | Ypsilanti | ||||||||||||||||
H000398 | Robert Hayne | H000398 | 405265 | 4237 | Robert Y. Hayne | Q883789 | kg:/m/04gpb9 | Robert | Hayne | 1791-11-10 | M | Young | |||||||||||||||||
M000220 | John Mason | M000220 | 407238 | 6057 | John Y. Mason | Q1258123 | kg:/m/0389n1 | John | Mason | 1799-04-18 | M | 17594 | Young | ||||||||||||||||
J000015 | Jabez Jackson | J000015 | 405922 | 4853 | Jabez Young Jackson | Q1416900 | kg:/m/0264q6k | Jabez | Jackson | M | 15711 | Young | |||||||||||||||||
O000162 | Bryan Owsley | O000162 | 408412 | 7140 | Bryan Owsley | Q995078 | kg:/m/02qhbt4 | Bryan | Owsley | 1798-08-19 | M | 19266 | Young | ||||||||||||||||
C000878 | Henry Cranston | C000878 | 402991 | 2149 | Henry Y. Cranston | Q203152 | kg:/m/02rhhjd | Henry | Cranston | 1789-10-09 | M | 11553 | Young | ||||||||||||||||
R000197 | Edward Rice | R000197 | 409173 | 7853 | Edward Y. Rice | Q5346014 | kg:/m/02rkyv9 | Edward | Rice | 1820-02-08 | M | 20329 | Young | ||||||||||||||||
B000933 | John Brown | B000933 | 401887 | 1123 | John Y. Brown (politician, born 1835) | Q680902 | kg:/m/0c_fmm | John | Brown | 1835-06-28 | M | 9983 | Young | ||||||||||||||||
P000087 | Edward Parsons | P000087 | 408497 | 7219 | Edward Y. Parsons | Q1294163 | kg:/m/02rhfs0 | Edward | Parsons | 1842-12-12 | M | 19379 | Young | ||||||||||||||||
F000177 | Thomas Fitzpatrick | F000177 | 404132 | 3195 | Thomas Y. Fitzpatrick | Q2428309 | kg:/m/02rk0b8 | Thomas | Fitzpatrick | 1850-09-20 | M | 13193 | Young | ||||||||||||||||
S000035 | Jared Sanders | S000035 | 409552 | 8197 | Jared Y. Sanders Sr. | Q433026 | kg:/m/0kt9wr | Jared | Sanders | 1869-01-29 | M | 21176 | Young | ||||||||||||||||
T000185 | Robert Thomas | T000185 | 410766 | 9309 | Robert Y. Thomas Jr. | Q2159247 | kg:/m/02rjyx6 | Robert | Thomas | 1855-07-13 | M | 22858 | Young | Jr. | |||||||||||||||
B000934 | John Brown | B000934 | 401888 | 1124 | John Y. Brown Sr. | Q1702236 | kg:/m/07fx7_ | John | Brown | 1900-02-01 | M | 9984 | Young | ||||||||||||||||
S000036 | Jared Sanders | S000036 | 409553 | 8198 | Jared Y. Sanders Jr. | Q1683484 | kg:/m/0ktb8_ | Jared | Sanders | 1892-04-20 | M | 21177 | Young | Jr. | |||||||||||||||
M000794 | Norman Mineta | M000794 | 407772 | 14257 | Norman Mineta | Q553502 | kg:/m/013y3t | Norman | Mineta | 1931-11-12 | M | 18323 | Yoshio | 00812 | |||||||||||||||
M000349 | John McCollister | M000349 | 407358 | 13025 | John Y. McCollister | Q1492410 | kg:/m/0bf67w | John | McCollister | 1921-06-10 | M | 17761 | Yetter | 00760 | |||||||||||||||
H000964 | William Humphreys | H000964 | 405808 | 4738 | William Y. Humphreys | Q1347573 | kg:/m/02rv9wl | William | Humphreys | 1890-09-09 | M | 15473 | Yerger | ||||||||||||||||
L000086 | Gerrit Lansing | L000086 | 406595 | 5468 | Gerrit Y. Lansing | Q1659394 | kg:/m/02rkpz3 | Gerrit | Lansing | 1783-08-04 | M | 16699 | Yates | ||||||||||||||||
W000105 | Thomas Walsh | W000105 | 411283 | 9789 | Thomas Yates Walsh | Q1385209 | kg:/m/02rk0bm | Thomas | Walsh | M | 23338 | Yates | |||||||||||||||||
S000348 | Lawrence Sherman | S000348 | 409844 | 8456 | Lawrence Yates Sherman | Q436363 | kg:/m/06p3ll | Lawrence | Sherman | 1858-11-08 | M | Yates | |||||||||||||||||
W000231 | Edwin Webb | W000231 | 411399 | 9898 | Edwin Y. Webb | Q144310 | kg:/m/05k40n | Edwin | Webb | 1872-05-23 | M | 23494 | Yates | ||||||||||||||||
B000416 | Ellis Berry | B000416 | 401403 | 672 | Ellis Yarnal Berry | Q1332462 | kg:/m/0f6s4f | Ellis | Berry | 1902-10-06 | M | 9317 | Yarnal | ||||||||||||||||
T000161 | Christopher Thomas | T000161 | 410743 | 9289 | Christopher Thomas | Q1087070 | kg:/m/02pnxyc | Christopher | Thomas | 1818-03-24 | M | 22825 | Yancy | ||||||||||||||||
C000053 | James Callahan | C000053 | 402212 | James Yancy Callahan | Q1681329 | kg:/m/0bjphs | James | Callahan | 1852-12-19 | M | 10508 | Yancy | |||||||||||||||||
R000240 | Haywood Riddle | R000240 | 409216 | 7893 | Haywood Yancey Riddle | Q1477692 | kg:/m/0dj16y | Haywood | Riddle | 1834-06-20 | M | 20381 | Yancey | ||||||||||||||||
R000164 | Joseph Resnick | R000164 | 409141 | 10764 | Joseph Y. Resnick | Q6288094 | kg:/m/0ksv76 | Joseph | Resnick | 1924-07-13 | M | 20287 | Yale | ||||||||||||||||
H000855 | Thomas Howe | H000855 | 405702 | 4641 | Thomas Y. Howe Jr. | Q7795367 | kg:/m/02rkxdk | Thomas | Howe | M | 15343 | Y. | Jr. | ||||||||||||||||
S001162 | Allyson Schwartz | S001162 | 400647 | 20525 | Allyson Schwartz | Q202495 | kg:/m/04bbm6 | Allyson | Schwartz | 1948-10-03 | F | 22582 | Y. | Allyson Schwartz | 01798 | 57332 | 5239 | Allyson Y. Schwartz | N00001579 | [ "H4PA13124", "S8PA00163" ] |
653 | ||||||||
M000534 | James McLanahan | M000534 | 407526 | 6322 | James Xavier McLanahan | Q6145884 | kg:/m/026fswp | James | McLanahan | M | 17995 | Xavier | |||||||||||||||||
M000342 | Francis McCloskey | M000342 | 407351 | 15041 | Frank McCloskey | Q1443758 | kg:/m/09r9rl | Francis | McCloskey | 1939-06-12 | M | 17751 | Xavier | 00758 | |||||||||||||||
P000053 | Abraham Parker | P000053 | 408463 | 7187 | Abraham X. Parker | Q4669238 | kg:/m/02rklvk | Abraham | Parker | 1831-11-14 | M | 19342 | X. | ||||||||||||||||
M001195 | Alexander Mooney | M001195 | 412662 | 21557 | Alex Mooney | Q4718026 | kg:/m/02qqy78 | Alexander | Mooney | 1971-06-05 | M | X. | Alexander Mooney | 02277 | 76588 | 145943 | Alexander Mooney | N00033814 | [ "H4WV02080" ] |
2118 | |||||||||
T000417 | Clarence Turner | T000417 | 410986 | 9512 | Clarence W. Turner | Q1095525 | kg:/m/0dpqyv | Clarence | Turner | 1866-10-22 | M | 23145 | Wyly | ||||||||||||||||
H000003 | Richard Habersham | H000003 | 404889 | 3893 | Richard W. Habersham | Q2150827 | kg:/m/04dzvq | Richard | Habersham | M | 14294 | Wylly | |||||||||||||||||
H000913 | James Huffman | H000913 | 405759 | 4692 | James W. Huffman | Q1681250 | kg:/m/0355ft | James | Huffman | 1894-09-13 | M | Wylie | |||||||||||||||||
M000300 | George McBride | M000300 | 407315 | 6126 | George W. McBride | Q1508448 | kg:/m/0d8gd1 | George | McBride | 1854-03-13 | M | Wycliffe | |||||||||||||||||
D000132 | Robert Davis | D000132 | 403267 | 2408 | Robert Wyche Davis | Q2159240 | kg:/m/02rjywj | Robert | Davis | 1849-03-15 | M | 11997 | Wyche | ||||||||||||||||
B000434 | William Bibb | B000434 | 401420 | 686 | William Wyatt Bibb | Q729018 | kg:/m/03g3k7 | William | Bibb | 1781-10-02 | M | 9339 | Wyatt | ||||||||||||||||
A000061 | David Aiken | A000061 | 400721 | 51 | D. Wyatt Aiken | Q1151450 | kg:/m/0fd373 | David | Aiken | 1828-03-17 | M | 8340 | Wyatt | ||||||||||||||||
C000138 | Hattie Caraway | C000138 | 402288 | 1497 | Hattie Wyatt Caraway | Q1027455 | kg:/m/01rgnt | Hattie | Caraway | 1878-02-01 | F | 44589 | Wyatt | ||||||||||||||||
H000921 | George Hughes | H000921 | 405766 | 4700 | George Wurtz Hughes | Q2386140 | kg:/m/09jwtt | George | Hughes | 1806-09-30 | M | 15421 | Wurtz | ||||||||||||||||
M000128 | Samuel Mardis | M000128 | 407152 | 5980 | Samuel Wright Mardis | Q2218989 | kg:/m/0f800c | Samuel | Mardis | 1800-06-12 | M | 17486 | Wright | ||||||||||||||||
S000690 | William Southgate | S000690 | 410161 | 8753 | William Wright Southgate | Q2581122 | kg:/m/0fcm42 | William | Southgate | 1800-11-27 | M | 21990 | Wright | ||||||||||||||||
C000468 | Reader Clarke | C000468 | 402606 | 1798 | Reader W. Clarke | Q7300432 | kg:/m/02rm2sx | Reader | Clarke | 1812-05-18 | M | 11033 | Wright | ||||||||||||||||
H000420 | John Hazelton | H000420 | 405286 | 4258 | John W. Hazelton | Q1702054 | kg:/m/02x5gd4 | John | Hazelton | 1814-12-10 | M | 14798 | Wright | ||||||||||||||||
K000067 | Stephen Kellogg | K000067 | 406237 | 5145 | Stephen Wright Kellogg | Q657191 | kg:/m/0bznwl | Stephen | Kellogg | 1822-04-05 | M | 16163 | Wright | ||||||||||||||||
N000174 | Newton Nutting | N000174 | 408254 | 6989 | Newton W. Nutting | Q7020459 | kg:/m/02rkt_4 | Newton | Nutting | 1840-10-22 | M | 19049 | Wright | ||||||||||||||||
M001041 | Luther Mott | M001041 | 408008 | 6762 | Luther W. Mott | Q6705653 | kg:/m/026_x1h | Luther | Mott | 1874-11-30 | M | 18630 | Wright | ||||||||||||||||
A000300 | William Arnold | A000300 | 400942 | 252 | William W. Arnold | Q8019755 | kg:/m/02rkdnk | William | Arnold | 1877-10-14 | M | 8678 | Wright | ||||||||||||||||
M000071 | Verner Main | M000071 | 407099 | 5930 | Verner Main | Q1557258 | kg:/m/02844j9 | Verner | Main | 1885-12-16 | M | 17417 | Wright | ||||||||||||||||
G000471 | Martha Griffiths | G000471 | 404816 | 3830 | Martha Griffiths | Q529775 | kg:/m/01p9r1 | Martha | Griffiths | 1912-01-29 | F | 14160 | Wright | 00467 | |||||||||||||||
C000158 | Gregory Carman | C000158 | 402307 | 14804 | Gregory W. Carman | Q1545423 | kg:/m/0gkrl0 | Gregory | Carman | 1937-01-31 | M | 10652 | Wright | 00176 | |||||||||||||||
H000273 | John Hickenlooper | H000273 | 456797 | John Hickenlooper | Q430518 | kg:/m/04g_1z | John | Hickenlooper | 1952-02-07 | M | Wright | John Hickenlooper | S408 | John W. Hickenlooper | N00044206 | [ "S0CO00575" ] |
|||||||||||||
H000843 | Milford Howard | H000843 | 405690 | 4630 | Milford W. Howard | Q1934724 | kg:/m/0dlv5r | Milford | Howard | 1862-12-18 | M | 15329 | Wriarson | ||||||||||||||||
W000509 | James Williams | W000509 | 411666 | 10154 | James Wray Williams | Q983225 | kg:/m/02rhjl4 | James | Williams | 1792-10-08 | M | 23820 | Wray | ||||||||||||||||
W000384 | Joseph White | W000384 | 411544 | 10037 | Joseph W. White | Q13219504 | kg:/m/02rm27c | Joseph | White | 1822-10-02 | M | 23670 | Worthington | ||||||||||||||||
T000080 | Herbert Taylor | T000080 | 410664 | 9211 | Herbert W. Taylor | Q1609249 | kg:/m/02vvth8 | Herbert | Taylor | 1869-02-19 | M | 22734 | Worthington | ||||||||||||||||
P000134 | Edward Pattison | P000134 | 408540 | 14267 | Edward W. Pattison | Q5345753 | kg:/m/0gmf03 | Edward | Pattison | 1932-04-29 | M | 19442 | Worthington | 00899 | |||||||||||||||
K000132 | John Kern | K000132 | 406298 | 5201 | John W. Kern | Q454957 | kg:/m/03wckz | John | Kern | 1849-12-20 | M | Worth | |||||||||||||||||
V000075 | Horace Vaughan | V000075 | 411132 | 9651 | Horace Worth Vaughan | Q1577301 | kg:/m/0c_hnf | Horace | Vaughan | 1867-12-02 | M | 20965 | Worth | ||||||||||||||||
B000050 | Warren Bailey | B000050 | 401055 | 352 | Warren Worth Bailey | Q7970610 | kg:/m/0g6w3j | Warren | Bailey | 1855-01-08 | M | 8838 | Worth | ||||||||||||||||
C000428 | David Clark | C000428 | 402566 | 1760 | David Worth Clark | Q1177266 | kg:/m/06bmjb | David | Clark | 1902-04-02 | M | 10988 | Worth | ||||||||||||||||
S000554 | Howard Smith | S000554 | 410036 | 8636 | Howard W. Smith | Q1631939 | kg:/m/09p7y6 | Howard | Smith | 1883-02-02 | M | 21821 | Worth | ||||||||||||||||
D000241 | David Dennis | D000241 | 403379 | 12012 | David W. Dennis | Q1177015 | kg:/m/0d9xzt | David | Dennis | 1912-06-07 | M | 12130 | Worth | 00287 | |||||||||||||||
F000028 | Evarts Farr | F000028 | 403990 | 3067 | Evarts Worcester Farr | Q1381558 | kg:/m/02rhg19 | Evarts | Farr | 1840-10-10 | M | 12997 | Worcester | ||||||||||||||||
A000305 | Michael Ash | A000305 | 400947 | 257 | Michael Woolston Ash | Q6835447 | kg:/m/0273xf0 | Michael | Ash | 1789-03-05 | M | 8683 | Woolston | ||||||||||||||||
T000261 | John Tibbatts | T000261 | 410835 | 9375 | John W. Tibbatts | Q1702078 | kg:/m/02qw16b | John | Tibbatts | 1802-06-12 | M | 22951 | Wooleston | ||||||||||||||||
B000168 | Robert Barnwell | B000168 | 401170 | 457 | Robert Woodward Barnwell | Q357725 | kg:/m/029063 | Robert | Barnwell | 1801-08-10 | M | 8988 | Woodward | ||||||||||||||||
G000426 | George Greene | G000426 | 404774 | 3790 | George Woodward Greene | Q2114715 | kg:/m/02rkpwq | George | Greene | 1831-07-04 | M | 14106 | Woodward | ||||||||||||||||
D000078 | Stanley Davenport | D000078 | 403216 | 2360 | Stanley Woodward Davenport | Q7600056 | kg:/m/0gh569 | Stanley | Davenport | 1861-07-21 | M | 11927 | Woodward | ||||||||||||||||
B000235 | James Bates | B000235 | 401230 | James Woodson Bates | Q692671 | kg:/m/0723j9 | James | Bates | 1788-08-25 | M | 9079 | Woodson | |||||||||||||||||
B001037 | Alexander Buel | B001037 | 401987 | 1216 | Alexander W. Buel | Q2643211 | kg:/m/03wwf9 | Alexander | Buel | 1813-12-13 | M | 10113 | Woodruff | ||||||||||||||||
S000266 | Edward Seymour | S000266 | 409767 | 8383 | Edward Woodruff Seymour | Q1294151 | kg:/m/02rhfrp | Edward | Seymour | 1832-08-30 | M | 21465 | Woodruff | ||||||||||||||||
S000395 | Abner Sibal | S000395 | 409889 | 10560 | Abner W. Sibal | Q322548 | kg:/m/02rgty_ | Abner | Sibal | 1921-04-11 | M | 21630 | Woodruff | ||||||||||||||||
L000260 | Robert Levering | L000260 | 406763 | 5625 | Robert W. Levering | Q7350694 | kg:/m/02rjyw5 | Robert | Levering | 1914-10-03 | M | 16917 | Woodrow | ||||||||||||||||
M000758 | Thomas Miller | M000758 | 407736 | 6512 | Thomas W. Miller | Q2427942 | kg:/m/0h2c3d | Thomas | Miller | 1886-06-26 | M | 18277 | Woodnutt | ||||||||||||||||
M000719 | Clement Miller | M000719 | 407701 | 6477 | Clement Woodnutt Miller | Q949671 | kg:/m/02rhdsr | Clement | Miller | 1916-10-28 | M | 18231 | Woodnutt | ||||||||||||||||
C000907 | John Crisfield | C000907 | 403019 | 2176 | John W. Crisfield | Q336887 | kg:/m/08qsp9 | John | Crisfield | 1806-11-08 | M | 11590 | Woodland | ||||||||||||||||
H000867 | Nathaniel Howell | H000867 | 405714 | 4653 | Nathaniel W. Howell | Q6969903 | kg:/m/026tdc5 | Nathaniel | Howell | 1770-01-01 | M | 15358 | Woodhull | ||||||||||||||||
S000466 | William Skiles | S000466 | 409956 | 8558 | William W. Skiles | Q8019833 | kg:/m/02rm3x9 | William | Skiles | 1849-12-11 | M | 21721 | Woodburn | ||||||||||||||||
E000173 | Louis Emerson | E000173 | 403863 | 2960 | Louis W. Emerson | Q6688346 | kg:/m/02rktjv | Louis | Emerson | 1857-07-25 | M | 12805 | Woodard | ||||||||||||||||
B000662 | James Bouldin | B000662 | 401624 | 879 | James Bouldin | Q1680056 | kg:/m/03c2_dt | James | Bouldin | M | 9641 | Wood | |||||||||||||||||
R000237 | Carl Riddick | R000237 | 409213 | 7890 | Carl W. Riddick | Q1040939 | kg:/m/02qcxq5 | Carl | Riddick | 1872-02-25 | M | 20376 | Wood | ||||||||||||||||
F000143 | John Fishburne | F000143 | 404098 | 3163 | John W. Fishburne | Q1702046 | kg:/m/0267dlv | John | Fishburne | 1868-03-08 | M | 13151 | Wood |
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);