congress_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1,964 rows where chamber = "Senate" sorted by full_name
This data as json, CSV (advanced)
Suggested facets: gender, terms_count, first_served (date), last_served (date), birthday (date), served_until (date), fec_ids (array)
state >30
party 27
- Republican 848
- Democrat 834
- Whig 64
- Federalist 63
- Jackson 44
- Adams 21
- Pro-Administration 12
- Independent 10
- - 8
- Anti-Administration 8
- Anti-Jacksonian 8
- Ind. Republican-Democrat 6
- Liberal Republican 5
- Unionist 5
- Democratic Republican 4
- Populist 4
- American 3
- Silver Republican 3
- Farmer-Labor 2
- Free Soil 2
- Nullifier 2
- Unconditional Unionist 2
- Unknown 2
- Conservative 1
- Law and Order 1
- Liberty 1
- Progressive 1
chamber 1
- Senate · 1,964 ✖
| bioguide_id | first_name | last_name | full_name ▼ | nickname | party | state | chamber | district | first_served | last_served | is_current | opensecrets_id | fec_ids | govtrack_id | thomas_id | votesmart_id | lis_id | wikipedia_id | ballotpedia_id | birthday | gender | terms_count | served_until | trade_count | speech_count | bills_sponsored | vote_count | fec_total_received |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B001133 | Aaron | Burr | Aaron Burr | Republican | NY | Senate | 1791-10-24 | 1797-03-03 | 0 | [] | 402077 | Aaron Burr | 1756-02-06 | M | 2 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| C000852 | Aaron | Cragin | Aaron Cragin | Republican | NH | Senate | 1855-12-03 | 1877-03-03 | 0 | [] | 402968 | Aaron H. Cragin | 1821-02-03 | M | 4 | 1877-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| K000246 | Aaron | Kitchell | Aaron Kitchell | Republican | NJ | Senate | 1791-10-24 | 1809-12-31 | 0 | [] | 406405 | Aaron Kitchell | 1744-07-10 | M | 4 | 1809-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| O000041 | Aaron | Ogden | Aaron Ogden | Federalist | NJ | Senate | 1801-12-07 | 1803-03-03 | 0 | [] | 408324 | Aaron Ogden | 1756-12-03 | M | 1 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| S000065 | Aaron | Sargent | Aaron Sargent | Republican | CA | Senate | 1861-07-04 | 1879-03-03 | 0 | [] | 409577 | Aaron A. Sargent | 1827-09-28 | M | 4 | 1879-03-03 | 2 | 0 | 0 | 0 | 0 | |||||||
| G000171 | Abijah | Gilbert | Abijah Gilbert | Republican | FL | Senate | 1849-12-03 | 1875-03-03 | 0 | [] | 404538 | Abijah Gilbert | 1806-06-18 | M | 5 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| L000011 | Abner | Lacock | Abner Lacock | Republican | PA | Senate | 1811-11-04 | 1819-03-03 | 0 | [] | 406521 | Abner Lacock | 1770-07-09 | M | 2 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000084 | Abraham | Baldwin | Abraham Baldwin | Republican | GA | Senate | 1789-03-04 | 1807-03-04 | 0 | [] | 401086 | Abraham Baldwin | 1754-11-22 | M | 4 | 1807-03-04 | 0 | 0 | 0 | 0 | 0 | |||||||
| R000191 | Abraham | Ribicoff | Abraham Ribicoff | Democrat | CT | Senate | 1949-01-03 | 1981-01-03 | 0 | [] | 409167 | 01422 | Abraham Ribicoff | 1910-04-09 | M | 6 | 1981-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| V000083 | Abraham | Venable | Abraham Venable | Republican | VA | Senate | 1791-10-24 | 1805-03-03 | 0 | [] | 411139 | Abraham B. Venable | 1758-11-20 | M | 3 | 1805-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| W000486 | Abram | Williams | Abram Williams | Republican | CA | Senate | 1886-01-01 | 1887-03-03 | 0 | [] | 411643 | Abram Williams | 1832-02-03 | M | 1 | 1887-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| R000317 | Absalom | Robertson | Absalom Robertson | Democrat | VA | Senate | 1933-03-09 | 1967-01-03 | 0 | [] | 409288 | A. Willis Robertson | 1887-05-27 | M | 6 | 1967-01-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| S001150 | Adam | Schiff | Adam B. Schiff | Democrat | CA | Senate | 2001-01-03 | 2031-01-03 | 1 | N00009585 | ["H0CA27085", "S4CA00555"] | 400361 | 01635 | 9489 | S427 | Adam Schiff | Adam Schiff | 1960-06-22 | M | 6 | 63 | 1550 | 312 | 14572 | 4888475 | |||
| F000298 | Addison | Foster | Addison Foster | Republican | WA | Senate | 1899-12-04 | 1905-03-03 | 0 | [] | 404247 | Addison G. Foster | 1837-01-28 | M | 2 | 1905-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| A000172 | Adelbert | Ames | Adelbert Ames | Republican | MS | Senate | 1870-01-01 | 1875-03-03 | 0 | [] | 400827 | Adelbert Ames | 1835-10-31 | M | 1 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| S000890 | Adlai | Stevenson | Adlai Stevenson | Democrat | IL | Senate | 1970-01-01 | 1981-01-03 | 0 | [] | 410351 | 01441 | Adlai Stevenson III | 1930-10-10 | M | 2 | 1981-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000261 | Adonijah | Welch | Adonijah Welch | Republican | FL | Senate | 1868-01-01 | 1869-03-03 | 0 | [] | 411429 | Adonijah Welch | 1821-04-12 | M | 1 | 1869-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| F000457 | Alan | Franken | Al Franken | Al | Democrat | MN | Senate | 2009-07-07 | 2018-01-02 | 0 | N00029016 | ["S8MN00438"] | 412378 | 01969 | 108924 | S332 | Al Franken | Al Franken | 1951-05-21 | M | 2 | 2018-01-02 | 0 | 517 | 162 | 2449 | 3293865 | |
| B000436 | Alan | Bible | Alan Bible | Democrat | NV | Senate | 1954-12-02 | 1974-12-17 | 0 | [] | 401422 | 01283 | Alan Bible | 1909-11-20 | M | 4 | 1974-12-17 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000877 | Alan | Cranston | Alan Cranston | Democrat | CA | Senate | 1969-01-03 | 1993-01-03 | 0 | [] | 402990 | 01311 | S023 | Alan Cranston | 1914-06-19 | M | 5 | 1993-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| D000366 | Alan | Dixon | Alan Dixon | Democrat | IL | Senate | 1981-01-05 | 1993-01-03 | 0 | [] | 403483 | 01317 | S149 | Alan J. Dixon | 1927-07-07 | M | 3 | 1993-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| S000429 | Alan | Simpson | Alan Simpson | Republican | WY | Senate | 1979-01-15 | 1997-01-03 | 0 | [] | 409923 | 01435 | S142 | Alan Simpson (American politician) | 1931-09-02 | M | 4 | 1997-01-03 | 0 | 374 | 0 | 0 | 0 | |||||
| B000145 | Alben | Barkley | Alben Barkley | Democrat | KY | Senate | 1913-04-07 | 1956-04-30 | 0 | [] | 401146 | Alben W. Barkley | 1877-11-24 | M | 8 | 1956-04-30 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000429 | Albert | Beveridge | Albert Beveridge | Republican | IN | Senate | 1899-12-04 | 1911-03-03 | 0 | [] | 401415 | Albert J. Beveridge | 1862-10-06 | M | 3 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000900 | Albert | Brown | Albert Brown | Democrat | MS | Senate | 1839-12-02 | 1861-12-31 | 0 | [] | 401857 | Albert G. Brown | 1813-05-31 | M | 4 | 1861-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| C000290 | Albert | Chandler | Albert Chandler | Happy | Democrat | KY | Senate | 1939-10-10 | 1945-12-31 | 0 | [] | 402432 | Happy Chandler | 1898-07-14 | M | 2 | 1945-12-31 | 1 | 0 | 0 | 0 | 0 | ||||||
| C000988 | Albert | Cummins | Albert Cummins | Republican | IA | Senate | 1908-11-24 | 1926-07-30 | 0 | [] | 403096 | Albert B. Cummins | 1850-02-15 | M | 4 | 1926-07-30 | 0 | 0 | 0 | 0 | 0 | |||||||
| F000011 | Albert | Fall | Albert Fall | Republican | NM | Senate | 1912-03-27 | 1921-03-04 | 0 | [] | 403973 | Albert B. Fall | 1861-11-26 | M | 2 | 1921-03-04 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000320 | Albert | Gore | Albert Gore | Democrat | TN | Senate | 1939-01-03 | 1971-01-03 | 0 | [] | 404678 | Albert Gore Sr. | 1907-12-26 | M | 6 | 1971-01-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000321 | Albert | Gore | Albert Gore | Democrat | TN | Senate | 1977-01-04 | 1993-01-02 | 0 | [] | 404679 | 00449 | S170 | Al Gore | Al Gore | 1948-03-31 | M | 3 | 1993-01-02 | 0 | 0 | 0 | 0 | 0 | ||||
| G000424 | Albert | Greene | Albert Greene | Whig | RI | Senate | 1845-12-01 | 1851-03-03 | 0 | [] | 404771 | Albert C. Greene | 1792-04-15 | M | 2 | 1851-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000365 | Albert | Hawkes | Albert Hawkes | Republican | NJ | Senate | 1943-01-06 | 1949-01-03 | 0 | [] | 405234 | Albert W. Hawkes | 1878-11-20 | M | 2 | 1949-01-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000770 | Albert | Hopkins | Albert Hopkins | Republican | IL | Senate | 1885-12-07 | 1909-03-03 | 0 | [] | 405620 | Albert J. Hopkins | 1846-08-15 | M | 5 | 1909-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| P000079 | Albion | Parris | Albion Parris | Jackson | ME | Senate | 1815-12-04 | 1829-03-03 | 0 | [] | 408489 | Albion Parris | 1788-01-19 | M | 3 | 1829-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| P000145 | Alejandro | Padilla | Alex Padilla | Alex | Democrat | CA | Senate | 2021-01-20 | 2029-01-03 | 1 | N00047888 | ["S2CA00955"] | 456856 | 59742 | S413 | Alex Padilla | Alex Padilla | 1973-03-22 | M | 2 | 1 | 843 | 248 | 2343 | 2811407 | |||
| A000181 | Alexander | Anderson | Alexander Anderson | Democrat | TN | Senate | 1840-01-01 | 1841-03-03 | 0 | [] | 400836 | Alexander O. Anderson | 1794-11-10 | M | 1 | 1841-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000183 | Alexander | Barrow | Alexander Barrow | Whig | LA | Senate | 1841-05-31 | 1847-03-03 | 0 | [] | 401182 | Alexander Barrow | 1801-03-27 | M | 2 | 1847-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000187 | Alexander | Barry | Alexander Barry | Republican | OR | Senate | 1938-01-01 | 1939-01-03 | 0 | [] | 401186 | Alexander G. Barry | 1892-08-23 | M | 1 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B001030 | Alexander | Buckner | Alexander Buckner | Jackson | MO | Senate | 1831-12-05 | 1833-12-31 | 0 | [] | 401980 | Alexander Buckner | M | 1 | 1833-12-31 | 0 | 0 | 0 | 0 | 0 | ||||||||
| C000027 | Alexander | Caldwell | Alexander Caldwell | Republican | KS | Senate | 1871-03-04 | 1873-12-31 | 0 | [] | 402188 | Alexander Caldwell | 1830-03-01 | M | 1 | 1873-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| C000076 | Alexander | Campbell | Alexander Campbell | Republican | OH | Senate | 1809-05-22 | 1813-03-03 | 0 | [] | 402232 | Alexander Campbell (Ohio politician) | M | 1 | 1813-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| C000254 | Alexander | Cattell | Alexander Cattell | Republican | NJ | Senate | 1866-01-01 | 1871-03-03 | 0 | [] | 402398 | Alexander G. Cattell | 1816-02-12 | M | 1 | 1871-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| C000478 | Alexander | Clay | Alexander Clay | Democrat | GA | Senate | 1897-03-15 | 1911-03-03 | 0 | [] | 402616 | Alexander S. Clay | 1853-09-25 | M | 3 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000176 | Alexander | Hanson | Alexander Hanson | Federalist | MD | Senate | 1813-05-24 | 1819-04-23 | 0 | [] | 405057 | Alexander C. Hanson | 1786-02-27 | M | 2 | 1819-04-23 | 16 | 0 | 0 | 0 | 0 | |||||||
| M000166 | Alexander | Martin | Alexander Martin | Republican | NC | Senate | 1793-12-02 | 1799-03-03 | 0 | [] | 407188 | Alexander Martin | M | 2 | 1799-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| M000408 | Alexander | McDonald | Alexander McDonald | Republican | AR | Senate | 1868-01-01 | 1871-03-03 | 0 | [] | 407408 | Alexander McDonald (American politician) | 1832-04-10 | M | 1 | 1871-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| M001050 | Alexander | Mouton | Alexander Mouton | Democrat | LA | Senate | 1837-09-04 | 1843-03-03 | 0 | [] | 408017 | Alexandre Mouton | 1804-11-19 | M | 2 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| P000436 | Alexander | Porter | Alexander Porter | Anti-Jacksonian | LA | Senate | 1833-12-02 | 1837-03-03 | 0 | [] | 408827 | Alexander Porter | 1785-06-24 | M | 1 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| R000026 | Alexander | Ramsey | Alexander Ramsey | Republican | MN | Senate | 1843-12-04 | 1875-03-03 | 0 | [] | 409007 | Alexander Ramsey | 1815-09-08 | M | 6 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| W000465 | Alexander | Wiley | Alexander Wiley | Republican | WI | Senate | 1939-01-03 | 1963-01-03 | 0 | [] | 411622 | Alexander Wiley | 1884-05-26 | M | 5 | 1963-01-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| D000018 | Alfonse | D’Amato | Alfonse D’Amato | Republican | NY | Senate | 1981-01-05 | 1999-01-03 | 0 | [] | 403142 | 01313 | S147 | Al D'Amato | 1937-08-01 | M | 4 | 1999-01-03 | 0 | 777 | 0 | 0 | 0 | |||||
| B000386 | Alfred | Benson | Alfred Benson | Republican | KS | Senate | 1906-06-11 | 1907-01-23 | 0 | [] | 401377 | Alfred W. Benson | 1843-07-15 | M | 1 | 1907-01-23 | 0 | 0 | 0 | 0 | 0 | |||||||
| C000647 | Alfred | Colquitt | Alfred Colquitt | Democrat | GA | Senate | 1853-12-05 | 1895-03-03 | 0 | [] | 402775 | Alfred H. Colquitt | 1824-04-20 | M | 8 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| C001023 | Alfred | Cuthbert | Alfred Cuthbert | Democrat | GA | Senate | 1813-05-24 | 1843-03-03 | 0 | [] | 403130 | Alfred Cuthbert | 1785-12-23 | M | 6 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| I000049 | Alfred | Iverson | Alfred Iverson | Democrat | GA | Senate | 1847-12-06 | 1861-03-03 | 0 | [] | 405904 | Alfred Iverson Sr. | 1798-12-03 | M | 3 | 1861-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| K000255 | Alfred | Kittredge | Alfred Kittredge | Republican | SD | Senate | 1901-12-02 | 1909-03-03 | 0 | [] | 406414 | Alfred B. Kittredge | 1861-03-28 | M | 2 | 1909-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| N000096 | Alfred | Nicholson | Alfred Nicholson | Democrat | TN | Senate | 1840-01-01 | 1861-12-31 | 0 | [] | 408181 | Alfred O. P. Nicholson | 1808-08-31 | M | 4 | 1861-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| R000099 | Alfred | Reames | Alfred Reames | Democrat | OR | Senate | 1938-02-01 | 1939-01-03 | 0 | [] | 409079 | Alfred E. Reames | 1870-02-05 | M | 1 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| P000010 | Algernon | Paddock | Algernon Paddock | Republican | NE | Senate | 1875-12-06 | 1893-03-03 | 0 | [] | 408421 | Algernon Paddock | 1830-11-09 | M | 4 | 1893-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| M000056 | Allan | Magruder | Allan Magruder | Republican | LA | Senate | 1812-01-01 | 1813-03-03 | 0 | [] | 407084 | Allan B. Magruder | M | 1 | 1813-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| C000130 | Allen | Caperton | Allen Caperton | Democrat | WV | Senate | 1875-12-06 | 1877-03-03 | 0 | [] | 402280 | Allen T. Caperton | 1810-11-21 | M | 1 | 1877-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| E000112 | Allen | Ellender | Allen Ellender | Democrat | LA | Senate | 1937-01-05 | 1972-07-27 | 0 | [] | 403803 | Allen J. Ellender | 1890-09-24 | M | 6 | 1972-07-27 | 0 | 0 | 0 | 0 | 0 | |||||||
| T000251 | Allen | Thurman | Allen Thurman | Democrat | OH | Senate | 1845-12-01 | 1881-03-03 | 0 | [] | 410828 | Allen G. Thurman | 1813-11-13 | M | 7 | 1881-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| M000859 | Almer | Monroney | Almer Monroney | Democrat | OK | Senate | 1939-01-03 | 1969-01-03 | 0 | [] | 407832 | Mike Monroney | 1902-03-02 | M | 6 | 1969-01-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| E000046 | Alonzo | Edgerton | Alonzo Edgerton | Republican | MN | Senate | 1881-12-05 | 1881-12-31 | 0 | [] | 403741 | Alonzo J. Edgerton | 1827-06-07 | M | 1 | 1881-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| F000063 | Alpheus | Felch | Alpheus Felch | Democrat | MI | Senate | 1847-12-06 | 1853-03-03 | 0 | [] | 404021 | Alpheus Felch | 1804-09-28 | M | 2 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| A000028 | Alva | Adams | Alva Adams | Democrat | CO | Senate | 1923-12-03 | 1941-12-31 | 0 | [] | 400689 | Alva B. Adams | 1875-10-29 | M | 4 | 1941-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| L000510 | Alva | Lumpkin | Alva Lumpkin | Democrat | SC | Senate | 1941-07-17 | 1941-12-31 | 0 | [] | 406996 | Alva M. Lumpkin | 1886-11-13 | M | 1 | 1941-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| D000410 | Alvin | Donahey | Alvin Donahey | Democrat | OH | Senate | 1935-01-03 | 1941-01-03 | 0 | [] | 403523 | Vic Donahey | 1873-07-07 | M | 2 | 1941-01-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| S000076 | Alvin | Saunders | Alvin Saunders | Republican | NE | Senate | 1877-10-15 | 1883-03-03 | 0 | [] | 409588 | Alvin Saunders | 1817-07-12 | M | 2 | 1883-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B001130 | Ambrose | Burnside | Ambrose Burnside | Republican | RI | Senate | 1875-12-06 | 1881-03-03 | 0 | [] | 402074 | Ambrose Burnside | 1824-05-23 | M | 2 | 1881-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| S000256 | Ambrose | Sevier | Ambrose Sevier | Democrat | AR | Senate | 1828-02-23 | 1848-03-15 | 0 | [] | 409757 | Ambrose H. Sevier | 1801-11-04 | M | 4 | 1848-03-15 | 0 | 0 | 0 | 0 | 0 | |||||||
| N000162 | Amos | Nourse | Amos Nourse | Republican | ME | Senate | 1857-12-07 | 1857-12-31 | 0 | [] | 408243 | Amos Nourse | 1794-12-17 | M | 1 | 1857-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| K000367 | Amy | Klobuchar | Amy Klobuchar | Democrat | MN | Senate | 2007-01-04 | 2031-01-03 | 1 | N00027500 | ["S6MN00267"] | 412242 | 01826 | 65092 | S311 | Amy Klobuchar | Amy Klobuchar | 1960-05-25 | F | 5 | 0 | 1574 | 973 | 6662 | 6467562 | |||
| B001173 | Andrew | Butler | Andrew Butler | Democrat | SC | Senate | 1846-01-01 | 1857-12-31 | 0 | [] | 402115 | Andrew Butler | 1796-11-18 | M | 2 | 1857-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000442 | Andrew | Gregg | Andrew Gregg | Republican | PA | Senate | 1791-10-24 | 1813-03-03 | 0 | [] | 404789 | Andrew Gregg | 1755-06-10 | M | 4 | 1813-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000821 | Andrew | Houston | Andrew Houston | Democrat | TX | Senate | 1941-04-21 | 1941-12-31 | 0 | [] | 405668 | Andrew Jackson Houston | 1854-06-21 | M | 1 | 1941-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| J000005 | Andrew | Jackson | Andrew Jackson | Democratic Republican | TN | Senate | 1795-12-07 | 1825-12-31 | 0 | [] | 405913 | Andrew Jackson | Andrew Jackson (U.S. President) | 1767-03-15 | M | 6 | 1825-12-31 | 0 | 0 | 0 | 0 | 0 | ||||||
| J000116 | Andrew | Johnson | Andrew Johnson | Democrat | TN | Senate | 1843-12-04 | 1875-12-31 | 0 | [] | 406017 | Andrew Johnson | Andrew Johnson (U.S. president) | 1808-12-29 | M | 6 | 1875-12-31 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000891 | Andrew | Moore | Andrew Moore | Republican | VA | Senate | 1789-03-04 | 1809-03-03 | 0 | [] | 407863 | Andrew Moore (politician) | M | 4 | 1809-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| S000138 | Andrew | Schoeppel | Andrew Schoeppel | Republican | KS | Senate | 1949-01-03 | 1962-01-21 | 0 | [] | 409646 | Andrew Frank Schoeppel | 1894-11-23 | M | 3 | 1962-01-21 | 0 | 0 | 0 | 0 | 0 | |||||||
| J000210 | Andrieus | Jones | Andrieus Jones | Democrat | NM | Senate | 1917-04-02 | 1927-12-20 | 0 | [] | 406105 | Andrieus A. Jones | 1862-05-16 | M | 2 | 1927-12-20 | 0 | 0 | 0 | 0 | 0 | |||||||
| K000394 | Andy | Kim | Andy Kim | Democrat | NJ | Senate | 2019-01-03 | 2031-01-03 | 1 | N00041370 | ["H8NJ03206", "S4NJ00466"] | 412797 | 179640 | S426 | Andy Kim (politician) | Andrew Kim (New Jersey) | 1982-07-12 | M | 3 | 15 | 218 | 107 | 3345 | 12597254 | ||||
| A000382 | Angela | Alsobrooks | Angela D. Alsobrooks | Democrat | MD | Senate | 2025-01-03 | 2031-01-03 | 1 | N00053033 | ["S4MD00327"] | 456965 | S428 | Angela Alsobrooks | 1971-02-23 | F | 2 | 0 | 50 | 23 | 705 | 34339278 | ||||||
| C000064 | Angus | Cameron | Angus Cameron | Republican | WI | Senate | 1875-12-06 | 1885-03-03 | 0 | [] | 402222 | Angus Cameron (American politician) | 1826-07-04 | M | 2 | 1885-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| K000383 | Angus | King | Angus S. King, Jr. | Independent | ME | Senate | 2013-01-03 | 2031-01-03 | 1 | N00034580 | ["S2ME00109"] | 412545 | 02185 | 22381 | S363 | Angus King | Angus King | 1944-03-31 | M | 4 | 116 | 665 | 231 | 4823 | 9000844 | |||
| M000542 | Anselm | McLaurin | Anselm McLaurin | Democrat | MS | Senate | 1894-01-01 | 1909-12-22 | 0 | [] | 407534 | Anselm J. McLaurin | 1848-03-26 | M | 3 | 1909-12-22 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000577 | Anthony | Higgins | Anthony Higgins | Republican | DE | Senate | 1889-12-02 | 1895-03-03 | 0 | [] | 405439 | Anthony Higgins (politician) | 1840-10-01 | M | 2 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| K000103 | Anthony | Kennedy | Anthony Kennedy | Unionist | MD | Senate | 1857-12-07 | 1863-03-03 | 0 | [] | 406271 | Anthony Kennedy (Maryland politician) | 1810-12-21 | M | 2 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| D000367 | Archibald | Dixon | Archibald Dixon | Whig | KY | Senate | 1852-01-01 | 1855-03-03 | 0 | [] | 403484 | Archibald Dixon | 1802-04-02 | M | 1 | 1855-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| S000709 | Arlen | Specter | Arlen Specter | Democrat | PA | Senate | 1981-01-05 | 2011-01-03 | 0 | N00001604 | ["S6PA00100"] | 300092 | 01437 | 53340 | S161 | Arlen Specter | 1930-02-12 | M | 6 | 2011-01-03 | 0 | 2725 | 323 | 3978 | 2492417 | |||
| M000213 | Armistead | Mason | Armistead Mason | Republican | VA | Senate | 1816-01-01 | 1817-03-03 | 0 | [] | 407231 | Armistead Thomson Mason | 1787-08-04 | M | 1 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| N000010 | Arnold | Naudain | Arnold Naudain | DE | Senate | 1830-01-01 | 1837-03-03 | 0 | [] | 408104 | Arnold Naudain | 1790-01-06 | M | 2 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| B000030 | Arthur | Bagby | Arthur Bagby | Democrat | AL | Senate | 1841-05-31 | 1849-03-03 | 0 | [] | 401035 | Arthur P. Bagby | M | 2 | 1849-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| B000638 | Arthur | Boreman | Arthur Boreman | Republican | WV | Senate | 1869-03-04 | 1875-03-03 | 0 | [] | 401603 | Arthur I. Boreman | 1823-07-24 | M | 2 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000902 | Arthur | Brown | Arthur Brown | Republican | UT | Senate | 1896-01-01 | 1897-03-03 | 0 | [] | 401859 | Arthur Brown (American politician) | 1843-03-08 | M | 1 | 1897-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| C000133 | Arthur | Capper | Arthur Capper | Republican | KS | Senate | 1919-05-19 | 1949-01-03 | 0 | [] | 402283 | Arthur Capper | 1865-07-14 | M | 6 | 1949-01-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000326 | Arthur | Gorman | Arthur Gorman | Democrat | MD | Senate | 1881-12-05 | 1907-03-03 | 0 | [] | 404684 | Arthur P. Gorman | 1839-03-11 | M | 5 | 1907-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000340 | Arthur | Gould | Arthur Gould | Republican | ME | Senate | 1926-11-30 | 1931-03-03 | 0 | [] | 404696 | Arthur R. Gould | 1857-03-16 | M | 1 | 1931-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000397 | Arthur | Hayne | Arthur Hayne | Democrat | SC | Senate | 1858-01-01 | 1859-03-03 | 0 | [] | 412127 | Arthur P. Hayne | 1788-03-12 | M | 1 | 1859-03-03 | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE congress_members (
bioguide_id TEXT PRIMARY KEY,
first_name TEXT,
last_name TEXT,
full_name TEXT,
nickname TEXT,
party TEXT,
state TEXT,
chamber TEXT,
district INTEGER,
first_served TEXT,
last_served TEXT,
is_current INTEGER,
opensecrets_id TEXT,
fec_ids TEXT,
govtrack_id INTEGER,
thomas_id TEXT,
votesmart_id INTEGER,
lis_id TEXT,
wikipedia_id TEXT,
ballotpedia_id TEXT,
birthday TEXT,
gender TEXT,
terms_count INTEGER,
served_until TEXT
, trade_count INTEGER DEFAULT 0, speech_count INTEGER DEFAULT 0, bills_sponsored INTEGER DEFAULT 0, vote_count INTEGER DEFAULT 0, fec_total_received INTEGER DEFAULT 0);
CREATE INDEX idx_cm_name ON congress_members(last_name, first_name);
CREATE INDEX idx_cm_party ON congress_members(party);
CREATE INDEX idx_cm_state ON congress_members(state);
CREATE INDEX idx_cm_chamber ON congress_members(chamber);
CREATE INDEX idx_cm_current ON congress_members(is_current);
CREATE INDEX idx_cm_current_trades ON congress_members(is_current DESC, trade_count DESC);