legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A000314 | James Ashley | A000314 | 400958 | 266 | James Mitchell Ashley | Q1680840 | kg:/m/0b75yq | James | Ashley | 1824-11-14 | M | 8695 | Mitchell | ||||||||||||||||
A000315 | William Ashley | A000315 | 400960 | 268 | William Henry Ashley | Q1345876 | kg:/m/05m0q2 | William | Ashley | M | 8696 | Henry | |||||||||||||||||
A000316 | John Ashmore | A000316 | 400961 | 269 | John D. Ashmore | Q1699717 | kg:/m/02rtqq6 | John | Ashmore | 1819-08-18 | M | 8698 | Durant | ||||||||||||||||
A000317 | Eli Ashmun | A000317 | 400963 | 271 | Eli P. Ashmun | Q1328837 | kg:/m/0b4g10 | Eli | Ashmun | 1770-06-24 | M | Porter | |||||||||||||||||
A000318 | George Ashmun | A000318 | 400964 | 272 | George Ashmun | Q1506885 | kg:/m/0289jyh | George | Ashmun | 1804-12-25 | M | 8699 | |||||||||||||||||
A000319 | Henry Ashurst | A000319 | 400965 | 273 | Henry F. Ashurst | Q539092 | kg:/m/07s4f1 | Henry | Ashurst | 1874-09-13 | M | Fountain | |||||||||||||||||
A000320 | Joel Asper | A000320 | 400966 | 274 | Joel Funk Asper | Q1691715 | kg:/m/02rz72p | Joel | Asper | 1822-04-20 | M | 8701 | Funk | ||||||||||||||||
A000321 | James Aswell | A000321 | 400969 | 276 | James Benjamin Aswell | Q1680029 | kg:/m/0ds83b | James | Aswell | 1869-12-23 | M | 8703 | Benjamin | ||||||||||||||||
A000322 | David Atchison | A000322 | 400970 | 277 | David Rice Atchison | Q1176322 | kg:/m/02dn7 | David | Atchison | 1807-08-11 | M | Rice | |||||||||||||||||
A000323 | Charles Atherton | A000323 | 400971 | 278 | Charles G. Atherton | Q5077912 | kg:/m/09k_xb | Charles | Atherton | 1804-07-04 | M | 8706 | Gordon | ||||||||||||||||
A000324 | Charles Atherton | A000324 | 400972 | 279 | Charles Humphrey Atherton | Q1064921 | kg:/m/09l0f6 | Charles | Atherton | 1773-08-14 | M | 8707 | Humphrey | ||||||||||||||||
A000325 | Gibson Atherton | A000325 | 400973 | 280 | Gibson Atherton | Q5559289 | kg:/m/02rm0tz | Gibson | Atherton | 1831-01-19 | M | 8709 | |||||||||||||||||
A000326 | William Atkeson | A000326 | 400974 | 281 | William O. Atkeson | Q913913 | kg:/m/02rx9rl | William | Atkeson | 1854-08-24 | M | 8711 | Oscar | ||||||||||||||||
A000327 | John Atkins | A000327 | 400976 | 282 | John DeWitt Clinton Atkins | Q1699785 | kg:/m/0dm6c6 | John | Atkins | 1825-06-04 | M | 8713 | DeWitt Clinton | ||||||||||||||||
A000328 | Archibald Atkinson | A000328 | 400977 | 283 | Archibald Atkinson | Q633055 | kg:/m/02rgwr2 | Archibald | Atkinson | 1792-09-15 | M | 8714 | |||||||||||||||||
A000329 | Eugene Atkinson | A000329 | 400978 | 14602 | Eugene Atkinson | Q1373045 | kg:/m/062zc9 | Eugene | Atkinson | 1927-04-05 | M | 8715 | Vincent | 00035 | |||||||||||||||
A000330 | George Atkinson | A000330 | 400979 | 284 | George W. Atkinson | Q746279 | kg:/m/026r9jt | George | Atkinson | 1845-06-29 | M | 8716 | Wesley | ||||||||||||||||
A000331 | Louis Atkinson | A000331 | 400980 | 285 | Louis E. Atkinson | Q6687078 | kg:/m/0ksl6f | Louis | Atkinson | 1841-04-16 | M | 8717 | Evans | ||||||||||||||||
A000332 | Richard Atkinson | A000332 | 400981 | 286 | Richard Merrill Atkinson | Q2150207 | kg:/m/02rkzzr | Richard | Atkinson | 1894-02-06 | M | 8718 | Merrill | ||||||||||||||||
A000334 | John Atwater | A000334 | 400983 | 288 | John Wilbur Atwater | Q1118694 | kg:/m/04wkds | John | Atwater | 1840-12-27 | M | 8720 | Wilbur | ||||||||||||||||
A000335 | David Atwood | A000335 | 400984 | 289 | David Atwood | Q1173603 | kg:/m/02r4ff3 | David | Atwood | 1815-12-15 | M | 8722 | |||||||||||||||||
A000336 | Harrison Atwood | A000336 | 400985 | 290 | Harrison Henry Atwood | Q1586269 | kg:/m/02rhh51 | Harrison | Atwood | 1863-08-26 | M | 8724 | Henry | ||||||||||||||||
A000337 | Les AuCoin | A000337 | 400987 | 14201 | Les AuCoin | Q1798732 | kg:/m/08g68c | Les | AuCoin | 1942-10-21 | M | 8726 | 00036 | ||||||||||||||||
A000338 | Oscar Auf Der Heide | A000338 | 400988 | 292 | Oscar L. Auf der Heide | Q2032804 | kg:/m/02vlwzm | Oscar | Auf Der Heide | 1874-12-08 | M | 8727 | Louis | ||||||||||||||||
A000339 | Albert Austin | A000339 | 400989 | 293 | Albert E. Austin | Q116257 | kg:/m/02rgt_0 | Albert | Austin | 1877-11-15 | M | 8728 | Elmer | ||||||||||||||||
A000340 | Archibald Austin | A000340 | 400990 | 294 | Archibald Austin | Q129440 | kg:/m/02qnrf2 | Archibald | Austin | 1772-08-11 | M | 8729 | |||||||||||||||||
A000341 | Richard Austin | A000341 | 400991 | 295 | Richard W. Austin | Q2150818 | kg:/m/0dllm6 | Richard | Austin | 1857-08-26 | M | 8731 | Wilson | ||||||||||||||||
A000342 | Warren Austin | A000342 | 400992 | 296 | Warren Austin | Q953916 | kg:/m/01zkyp | Warren | Austin | 1877-11-12 | M | Robinson | |||||||||||||||||
A000343 | Thomas Averett | A000343 | 400993 | 297 | Thomas H. Averett | Q2424433 | kg:/m/02rjzrq | Thomas | Averett | 1800-07-10 | M | 8733 | Hamlet | ||||||||||||||||
A000344 | John Averill | A000344 | 400994 | 298 | John T. Averill | Q960453 | kg:/m/0dqmhj | John | Averill | 1825-03-01 | M | 8734 | Thomas | ||||||||||||||||
A000345 | Daniel Avery | A000345 | 400995 | 299 | Daniel Avery (politician) | Q2654862 | kg:/m/026psvq | Daniel | Avery | 1766-09-18 | M | 8735 | |||||||||||||||||
A000346 | John Avery | A000346 | 400996 | 300 | John Avery (politician) | Q1699192 | kg:/m/09cfx9 | John | Avery | 1824-02-29 | M | 8737 | |||||||||||||||||
A000347 | William Avery | A000347 | 400998 | 302 | William Tecumsah Avery | Q2580731 | kg:/m/0ddl59 | William | Avery | 1819-11-11 | M | 8738 | Tecumsah | ||||||||||||||||
A000348 | Samuel Avis | A000348 | 400999 | 303 | Samuel B. Avis | Q1470036 | kg:/m/03bzf4k | Samuel | Avis | 1872-02-19 | M | 8739 | Brashear | ||||||||||||||||
A000349 | Samuel Axtell | A000349 | 401000 | 304 | Samuel Beach Axtell | Q1620363 | kg:/m/05qsl7 | Samuel | Axtell | 1819-10-14 | M | 8740 | Beach | ||||||||||||||||
A000350 | John Aycrigg | A000350 | 401001 | 305 | John Bancker Aycrigg | Q1699248 | kg:/m/02z8_rb | John | Aycrigg | 1798-07-09 | M | 8741 | Bancker | ||||||||||||||||
A000351 | Richard Ayer | A000351 | 401002 | 306 | Richard S. Ayer | Q2150495 | kg:/m/02rjyg3 | Richard | Ayer | 1829-10-09 | M | 8743 | Small | ||||||||||||||||
A000352 | Roy Ayers | A000352 | 401003 | 307 | Roy E. Ayers | Q370646 | kg:/m/027y7zg | Roy | Ayers | 1882-11-09 | M | 8744 | Elmer | ||||||||||||||||
A000353 | Steven Ayres | A000353 | 401004 | 308 | Steven Beckwith Ayres | Q4068624 | kg:/m/02rldsd | Steven | Ayres | 1861-10-27 | M | 8745 | Beckwith | ||||||||||||||||
A000354 | William Ayres | A000354 | 401005 | 309 | William Augustus Ayres | Q2577898 | kg:/m/027m7fc | William | Ayres | 1867-04-19 | M | 8747 | Augustus | ||||||||||||||||
A000355 | Spencer Abraham | A000355 | 400555 | 49500 | Spencer Abraham | Q1285613 | kg:/m/01jtx9 | Spencer | Abraham | 1952-06-12 | M | 01269 | S238 | ||||||||||||||||
A000356 | John Ashcroft | A000356 | 400556 | 49501 | John Ashcroft | Q311141 | kg:/m/046c6 | John | Ashcroft | 1942-05-09 | M | 01274 | S239 | ||||||||||||||||
A000357 | Thomas Allen | A000357 | 400007 | 29728 | Tom Allen (Maine politician) | Q1855866 | kg:/m/025k1c | Thomas | Allen | 1945-04-16 | M | 8751 | H. | Tom | 01461 | 380 | N00000469 | [ "H6ME01157" ] |
|||||||||||
A000358 | W. Akin | A000358 | 400005 | 20123 | Todd Akin | Q772086 | kg:/m/025xzm | W. | Akin | 1947-07-05 | M | 8753 | Todd | 01655 | 87412 | 9301 | W. Todd Akin | N00009677 | [ "H0MO02148" ] |
||||||||||
A000359 | Aníbal Acevedo-Vilá | A000359 | 400002 | Aníbal Acevedo Vilá | Q615126 | kg:/m/0337g0 | Aníbal | Acevedo-Vilá | 1962-02-13 | M | 8754 | 01679 | N00009825 | ||||||||||||||||
A000360 | Lamar Alexander | A000360 | 300002 | 40304 | Lamar Alexander | Q419976 | kg:/m/01rbs3 | Lamar | Alexander | 1940-07-03 | M | Lamar Alexander | 01695 | 5 | 15691 | S289 | Lamar Alexander | N00009888 | [ "S2TN00058", "P60003225" ] |
530 | |||||||||
A000361 | Rodney Alexander | A000361 | 400006 | 90327 | Rodney Alexander | Q504508 | kg:/m/025jxc | Rodney | Alexander | 1946-12-05 | M | 8757 | M. | Rodney Alexander | 01727 | 1004256 | 4545 | Rodney Alexander | N00025464 | [ "H2LA05084" ] |
129 | ||||||||
A000362 | Jason Altmire | A000362 | 412231 | 20743 | Jason Altmire | Q606309 | kg:/m/0dzy2v | Jason | Altmire | 1968-03-07 | M | 8759 | 01873 | 1022872 | 59999 | Jason Altmire | N00027664 | [ "H6PA04110" ] |
|||||||||||
A000363 | Michael Arcuri | A000363 | 412224 | 20736 | Mike Arcuri | Q256130 | kg:/m/0g826p | Michael | Arcuri | 1959-06-11 | M | 8761 | A. | 01867 | 1021495 | 67657 | N00027890 | [ "H6NY24128" ] |
|||||||||||
A000364 | John Adler | A000364 | 412264 | 20928 | John Adler | Q976160 | kg:/m/05jzss | John | Adler | 1959-08-23 | M | 8763 | H. | 01935 | 1030767 | 4171 | N00000812 | [ "H8NJ03156" ] |
|||||||||||
A000365 | Steve Austria | A000365 | 412265 | 20940 | Steve Austria | Q144226 | kg:/m/04l4w1 | Steve | Austria | 1958-10-12 | M | 8765 | 01947 | 1031355 | 23398 | Steve Austria | N00029412 | [ "H8OH07065" ] |
|||||||||||
A000366 | Sandy Adams | A000366 | 412414 | 21120 | Sandy Adams | Q513789 | kg:/m/057njwc | Sandy | Adams | 1956-12-14 | F | 8767 | 02006 | 31041 | Sandy Adams | N00030926 | [ "H0FL24049" ] |
||||||||||||
A000367 | Justin Amash | A000367 | 412438 | 21143 | Justin Amash | Q1714165 | kg:/m/0c00p_n | Justin | Amash | 1980-04-18 | M | 8769 | Justin Amash | 02029 | 1033767 | 105566 | Justin Amash | N00031938 | [ "H0MI03126" ] |
1449 | |||||||||
A000368 | Kelly Ayotte | A000368 | 412493 | 41106 | Kelly Ayotte | Q22354 | kg:/m/0g9g4r | Kelly | Ayotte | 1968-06-27 | F | 8771 | Kelly A. Ayotte | 02075 | 95241 | 42352 | S340 | Kelly Ayotte | N00030980 | [ "S0NH00235" ] |
1498 | ||||||||
A000369 | Mark Amodei | A000369 | 412500 | 21196 | Mark Amodei | Q23944 | kg:/m/03bzdkn | Mark | Amodei | 1958-06-12 | M | 8772 | E. | Mark Amodei | 02090 | 62817 | 12537 | Mark E. Amodei | N00031177 | [ "H2NV02395", "H1NV02017", "S0NV00237" ] |
1680 | ||||||||
A000370 | Alma Adams | A000370 | 412607 | 21545 | Alma Adams | Q4733597 | kg:/m/02b45d | Alma | Adams | 1946-05-27 | F | 15032409256 | S. | Alma Adams | 02201 | 76386 | 5935 | Alma S. Adams | N00035451 | [ "H4NC12100" ] |
2063 | ||||||||
A000371 | Pete Aguilar | A000371 | 412615 | 21506 | Pete Aguilar | Q7171821 | kg:/m/0jwv0xf | Pete | Aguilar | 1979-06-19 | M | Pete Aguilar | 02229 | 79994 | 70114 | Pete Aguilar | N00033997 | [ "H2CA31125" ] |
2071 | [ { "title": "House Democratic Caucus Vice Chair", "chamber": "house", "start": "2021-01-03" } ] |
|||||||||
A000372 | Rick Allen | A000372 | 412625 | 21516 | Rick W. Allen | Q18683976 | kg:/m/0127y9dk | Rick | Allen | 1951-11-07 | M | W. | Rick Allen | 02239 | 62545 | 136062 | Rick W. Allen | N00033720 | [ "H2GA12121" ] |
2081 | |||||||||
A000373 | Brad Ashford | A000373 | 412642 | Brad Ashford | Q4953782 | kg:/m/02pys5v | Brad | Ashford | 1949-11-10 | M | 02257 | 56766 | Brad Ashford | N00005293 | [ "H4NE02054" ] |
2098 | |||||||||||||
A000374 | Ralph Abraham | A000374 | 412630 | 21522 | Ralph Abraham (politician) | Q18683775 | kg:/m/012dwd7_ | Ralph | Abraham | 1954-09-16 | M | Ralph Abraham | 02244 | 76236 | 155414 | Ralph Lee Abraham | N00036633 | [ "H4LA05221" ] |
2086 | ||||||||||
A000375 | Jodey Arrington | A000375 | 412726 | 21700 | Jodey Arrington | Q6207815 | kg:/m/0g9_f_1 | Jodey | Arrington | 1972-03-09 | M | C. | Jodey Arrington | 1016482 | 155685 | Jodey C. Arrington | N00038285 | [ "H6TX19099" ] |
2238 | ||||||||||
A000376 | Colin Allred | A000376 | 412828 | 21900 | Colin Allred | Q5144845 | Colin | Allred | 1983-04-15 | M | Z. | Colin Allred | 177357 | Colin Z. Allred | N00040989 | [ "H8TX32098" ] |
|||||||||||||
A000377 | Kelly Armstrong | A000377 | 412794 | 21901 | Kelly Armstrong | Q50362353 | kg:/g/11hcszksh3 | Kelly | Armstrong | 1976-10-08 | M | Kelly Armstrong | 139338 | Kelly Armstrong | N00042868 | [ "H8ND00096" ] |
|||||||||||||
A000378 | Cynthia Axne | A000378 | 412772 | 21902 | Cindy Axne | Q58324150 | kg:/g/11fgktcgcb | Cynthia | Axne | 1965-04-20 | F | Cindy Axne | 179226 | Cynthia Axne | N00041104 | [ "H8IA03124" ] |
|||||||||||||
B000001 | Clinton Babbitt | B000001 | 401007 | 311 | Clinton Babbitt | Q1101655 | kg:/m/02vrpxj | Clinton | Babbitt | 1831-11-16 | M | 8774 | |||||||||||||||||
B000002 | Elijah Babbitt | B000002 | 401008 | 312 | Elijah Babbitt | Q5360882 | kg:/m/0ktbz_ | Elijah | Babbitt | 1795-07-29 | M | 8775 | |||||||||||||||||
B000003 | Alfred Babcock | B000003 | 401009 | 313 | Alfred Babcock | Q4722270 | kg:/m/02rkl_q | Alfred | Babcock | 1805-04-15 | M | 8776 | |||||||||||||||||
B000004 | Joseph Babcock | B000004 | 401010 | 314 | Joseph W. Babcock | Q1708153 | kg:/m/02q7c52 | Joseph | Babcock | 1850-03-06 | M | 8778 | Weeks | ||||||||||||||||
B000005 | Leander Babcock | B000005 | 401011 | 315 | Leander Babcock | Q6509509 | kg:/m/0dc1t9 | Leander | Babcock | 1811-03-01 | M | 8779 | |||||||||||||||||
B000006 | William Babcock | B000006 | 401012 | 316 | William Babcock (politician) | Q8004895 | kg:/m/02rkxvb | William | Babcock | M | 8780 | ||||||||||||||||||
B000007 | John Babka | B000007 | 401013 | 317 | John J. Babka | Q1700563 | kg:/m/02rm1p3 | John | Babka | 1884-03-16 | M | 8782 | Joseph | ||||||||||||||||
B000008 | James Bacchus | B000008 | 401014 | 29112 | Jim Bacchus | Q1689028 | kg:/m/05pytj | James | Bacchus | 1949-06-21 | M | 8783 | 00037 | ||||||||||||||||
B000009 | Isaac Bacharach | B000009 | 401015 | 318 | Isaac Bacharach | Q1673360 | kg:/m/02vn_7h | Isaac | Bacharach | 1870-01-05 | M | 8784 | |||||||||||||||||
B000010 | Nathan Bachman | B000010 | 401016 | 319 | Nathan L. Bachman | Q1768884 | kg:/m/0433yl | Nathan | Bachman | 1878-08-02 | M | Lynn | |||||||||||||||||
B000011 | Reuben Bachman | B000011 | 401017 | 320 | Reuben Knecht Bachman | Q7317480 | kg:/m/0kt0hv | Reuben | Bachman | 1834-08-06 | M | 8786 | Knecht | ||||||||||||||||
B000012 | Carl Bachmann | B000012 | 401018 | 321 | Carl G. Bachmann | Q1038201 | kg:/m/04j_wz | Carl | Bachmann | 1890-05-14 | M | 8787 | George | ||||||||||||||||
B000013 | Spencer Bachus | B000013 | 400010 | 29301 | Spencer Bachus | Q1368315 | kg:/m/024p0v | Spencer | Bachus | 1947-12-28 | M | 8789 | Thomas | Spencer Bachus | III | 00038 | 26397 | 26715 | Spencer Bachus | N00008091 | [ "H2AL06035" ] |
133 | |||||||
B000014 | Augustus Bacon | B000014 | 401019 | 322 | Augustus Octavius Bacon | Q4821512 | kg:/m/053z8b | Augustus | Bacon | 1839-10-20 | M | Octavius | |||||||||||||||||
B000015 | Ezekiel Bacon | B000015 | 401020 | 323 | Ezekiel Bacon | Q1385984 | kg:/m/0d7yf_ | Ezekiel | Bacon | 1776-09-01 | M | 8791 | |||||||||||||||||
B000016 | Henry Bacon | B000016 | 401021 | 324 | Henry Bacon (New York politician) | Q3182005 | kg:/m/02rkqb4 | Henry | Bacon | 1846-03-14 | M | 8793 | |||||||||||||||||
B000017 | John Bacon | B000017 | 401022 | 325 | John Bacon (Massachusetts politician) | Q1244688 | kg:/m/02pnldz | John | Bacon | 1738-04-05 | M | 8794 | |||||||||||||||||
B000018 | Mark Bacon | B000018 | 401023 | 326 | Mark R. Bacon | Q281229 | kg:/m/03y489 | Mark | Bacon | 1852-02-29 | M | 8795 | Reeves | ||||||||||||||||
B000019 | Robert Bacon | B000019 | 401024 | 327 | Robert L. Bacon | Q111588 | kg:/m/0d9c2f | Robert | Bacon | 1884-07-23 | M | 8797 | Low | ||||||||||||||||
B000020 | William Bacon | B000020 | 401025 | 328 | William J. Bacon | Q8013134 | kg:/m/02rky49 | William | Bacon | 1803-02-18 | M | 8798 | Johnson | ||||||||||||||||
B000021 | De Badger | B000021 | 401026 | 329 | De Witt C. Badger | Q5244858 | kg:/m/02rl_jc | De | Badger | 1858-08-07 | M | 8800 | Witt Clinton | ||||||||||||||||
B000022 | George Badger | B000022 | 401027 | 330 | George Edmund Badger | Q925084 | kg:/m/02kl7n | George | Badger | 1795-04-17 | M | Edmund | |||||||||||||||||
B000023 | Luther Badger | B000023 | 401028 | 331 | Luther Badger | Q6705487 | kg:/m/02rktkw | Luther | Badger | 1785-04-10 | M | 8802 | |||||||||||||||||
B000024 | Robert Badham | B000024 | 401029 | 14403 | Robert Badham | Q1428544 | kg:/m/09yq83 | Robert | Badham | 1929-06-09 | M | 8804 | Edward | 00039 | |||||||||||||||
B000025 | Herman Badillo | B000025 | 401030 | 13004 | Herman Badillo | Q11862397 | kg:/m/03y5l8 | Herman | Badillo | 1929-08-21 | M | 8806 | 00040 | ||||||||||||||||
B000026 | George Baer | B000026 | 401031 | 332 | George Baer Jr. | Q1203647 | kg:/m/09jkw8 | George | Baer | M | 8807 | Jr. | |||||||||||||||||
B000027 | John Baer | B000027 | 401032 | 333 | John Miller Baer | Q1701102 | kg:/m/02rhkf9 | John | Baer | 1886-03-29 | M | 8809 | Miller | ||||||||||||||||
B000028 | Henry Baesler | B000028 | 401033 | 29353 | Scotty Baesler | Q2261433 | kg:/m/05byc4 | Henry | Baesler | 1941-07-09 | M | 8811 | Scott | Scotty | 00041 | ||||||||||||||
B000029 | Louis Bafalis | B000029 | 401034 | 14003 | Skip Bafalis | Q1350106 | kg:/m/02pz0hx | Louis | Bafalis | 1929-09-28 | M | 8812 | Arthur | Skip | 00042 | ||||||||||||||
B000030 | Arthur Bagby | B000030 | 401035 | 334 | Arthur P. Bagby | Q710906 | kg:/m/03g2_t | Arthur | Bagby | M | Pendleton | ||||||||||||||||||
B000031 | John Bagby | B000031 | 401036 | 335 | John C. Bagby | Q6224273 | kg:/m/02rkbk5 | John | Bagby | 1819-01-24 | M | 8815 | Courts | ||||||||||||||||
B000032 | George Bagley | B000032 | 401037 | 336 | George A. Bagley | Q5535918 | kg:/m/026gsfw | George | Bagley | 1826-07-22 | M | 8816 | Augustus | ||||||||||||||||
B000033 | John Bagley | B000033 | 401038 | 337 | John H. Bagley Jr. | Q3090731 | kg:/m/026gsj8 | John | Bagley | 1832-11-26 | M | 8817 | Holroyd | Jr. | |||||||||||||||
B000034 | Alexander Bailey | B000034 | 401039 | 338 | Alexander H. Bailey | Q4719026 | kg:/m/02qpy73 | Alexander | Bailey | 1817-08-14 | M | 8818 | Hamilton | ||||||||||||||||
B000035 | Cleveland Bailey | B000035 | 401040 | 339 | Cleveland M. Bailey | Q1100770 | kg:/m/02rz8z4 | Cleveland | Bailey | 1886-07-15 | M | 8820 | Monroe | ||||||||||||||||
B000036 | David Bailey | B000036 | 401041 | 340 | David Jackson Bailey | Q1174847 | kg:/m/027cn3t | David | Bailey | 1812-03-11 | M | 8821 | Jackson |
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);