congress_members

All current and historical members of Congress (12,700+) from the congress-legislators project. Includes bioguide_id (universal key), party, state, chamber, and cross-reference IDs for OpenSecrets, FEC, GovTrack, and more.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

834 rows where chamber = "Senate" and party = "Democrat" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: nickname, gender, terms_count, trade_count, first_served (date), last_served (date), birthday (date), served_until (date), fec_ids (array)

state >30

is_current 2

  • 0 789
  • 1 45

party 1

  • Democrat · 834 ✖

chamber 1

  • Senate · 834 ✖
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
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 233 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   3 1550 312 14572 4888475
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 148 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 33 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 942 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 184 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
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 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 222 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   0 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
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
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
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
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
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
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
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
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
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
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
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   0 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
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
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 893 3978 2492417
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
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
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
M000878 Arthur Moody Arthur Moody   Democrat MI Senate   1951-04-23 1953-01-03 0   [] 407850       Blair Moody   1902-02-13 M 1 1953-01-03 0 0 0 0 0
M000893 Arthur Moore Arthur Moore   Democrat NJ Senate   1935-01-03 1939-01-03 0   [] 407865       A. Harry Moore   1877-07-03 M 1 1939-01-03 0 0 0 0 0
S000901 Arthur Stewart Arthur Stewart   Democrat TN Senate   1939-01-03 1949-01-03 0   [] 410362       Tom Stewart (politician)   1892-01-11 M 2 1949-01-03 0 0 0 0 0
W000096 Arthur Walsh Arthur Walsh   Democrat NJ Senate   1943-11-26 1945-01-03 0   [] 411275       Arthur Walsh (U.S. senator)   1896-02-26 M 1 1945-01-03 0 0 0 0 0
B000456 Asa Biggs Asa Biggs   Democrat NC Senate   1845-12-01 1859-03-03 0   [] 401441       Asa Biggs   1811-02-04 M 3 1859-03-03 0 0 0 0 0
L000114 Asbury Latimer Asbury Latimer   Democrat SC Senate   1893-08-07 1909-03-03 0   [] 406620       Asbury Latimer   1851-07-31 M 3 1909-03-03 0 0 0 0 0
P000420 Atlee Pomerene Atlee Pomerene   Democrat OH Senate   1911-04-04 1923-03-03 0   [] 408812       Atlee Pomerene   1863-12-06 M 3 1923-03-03 0 0 0 0 0
L000409 Augustine Lonergan Augustine Lonergan   Democrat CT Senate   1913-04-07 1939-01-03 0   [] 406900       Augustine Lonergan   1874-05-20 M 5 1939-01-03 0 0 0 0 0
B000014 Augustus Bacon Augustus Bacon   Democrat GA Senate   1895-12-02 1915-03-03 0   [] 401019       Augustus O. Bacon   1839-10-20 M 4 1915-03-03 0 0 0 0 0
D000394 Augustus Dodge Augustus Dodge   Democrat IA Senate   1840-12-28 1855-02-22 0   [] 403509       Augustus C. Dodge   1812-01-02 M 3 1855-02-22 0 0 0 0 0
G000065 Augustus Garland Augustus Garland   Democrat AR Senate   1877-10-15 1885-12-31 0   [] 404438       Augustus H. Garland   1832-06-11 M 2 1885-12-31 0 0 0 0 0
M000659 Augustus Merrimon Augustus Merrimon   Democrat NC Senate   1873-12-01 1879-03-03 0   [] 407645       Augustus Summerfield Merrimon   1830-09-15 M 2 1879-03-03 0 0 0 0 0
S000796 Augustus Stanley Augustus Stanley   Democrat KY Senate   1903-11-09 1925-03-03 0   [] 410262       Augustus Owsley Stanley   1867-05-21 M 4 1925-03-03 0 0 0 0 0
O000167 Barack Obama Barack Obama   Democrat IL Senate   2005-01-04 2008-11-16 0 N00009638 ["S4IL00180"] 400629 01763 9490 S298 Barack Obama Barack Obama 1961-08-04 M 1 2008-11-16 0 534 137 1300 -2000
M000702 Barbara Mikulski Barbara A. Mikulski   Democrat MD Senate   1977-01-04 2017-01-03 0 N00001945 ["S6MD00140"] 300073 00802 53304 S182 Barbara Mikulski Barbara Mikulski 1936-07-20 F 7 2017-01-03 0 1793 404 5623 2169651
B000711 Barbara Boxer Barbara Boxer   Democrat CA Senate   1983-01-03 2017-01-03 0 N00006692 ["S2CA00286", "H2CA06028", "P80003247"] 300011 00116 53274 S223 Barbara Boxer Barbara Boxer 1940-11-11 F 6 2017-01-03 0 3877 767 5623 13538038
B000903 Bedford Brown Bedford Brown   Democrat NC Senate   1829-12-07 1841-03-03 0   [] 401860       Bedford Brown   1795-06-06 M 3 1841-03-03 0 0 0 0 0
N000180 Ben Nelson Ben Nelson   Democrat NE Senate   2001-01-03 2013-01-03 0 N00005329 ["S6NE00095"] 300077 01627 21744 S283 Ben Nelson Ben Nelson 1941-05-17 M 3 2013-01-03 0 594 136 3792 2275766
L000570 Ben Luján Ben Ray Luján   Democrat NM Senate   2009-01-06 2027-01-03 1 N00029562 ["H8NM03196", "S0NM00058"] 412293 01939 102842 S409 Ben Ray Luján Ben Ray Luján 1972-06-07 M 4   0 398 341 10295 9337078
W000550 Ben Williamson Ben Williamson   Democrat KY Senate   1930-01-01 1931-03-03 0   [] 411706       Ben M. Williamson   1864-10-16 M 1 1931-03-03 0 0 0 0 0
F000174 Benjamin Fitzpatrick Benjamin Fitzpatrick   Democrat AL Senate   1848-01-01 1861-03-03 0   [] 404129       Benjamin Fitzpatrick   1802-06-30 M 3 1861-03-03 0 0 0 0 0
H000189 Benjamin Harding Benjamin Harding   Democrat OR Senate   1862-01-01 1865-03-03 0   [] 405070       Benjamin F. Harding   1823-01-04 M 1 1865-03-03 0 0 0 0 0
H000587 Benjamin Hill Benjamin Hill   Democrat GA Senate   1875-12-06 1883-03-03 0   [] 405449       Benjamin Harvey Hill   1823-09-14 M 2 1883-03-03 0 0 0 0 0
J000204 Benjamin Jonas Benjamin Jonas   Democrat LA Senate   1879-03-18 1885-03-03 0   [] 406099       Benjamin F. Jonas   1834-07-19 M 2 1885-03-03 0 0 0 0 0
J000267 Benjamin Jordan Benjamin Jordan   Democrat NC Senate   1958-04-19 1973-01-03 0   [] 406159       B. Everett Jordan   1896-09-08 M 3 1973-01-03 0 0 0 0 0
C000141 Benjamin Cardin Benjamin L. Cardin   Democrat MD Senate   1987-01-06 2025-01-03 0 N00001955 ["H6MD03177", "S6MD03177"] 400064 00174 26888 S308 Ben Cardin Ben Cardin 1943-10-05 M 7 2025-01-03 15 3753 769 8385 4872450
S000371 Benjamin Shively Benjamin Shively   Democrat IN Senate   1883-12-03 1917-03-03 0   [] 409865       Benjamin F. Shively   1857-03-20 M 6 1917-03-03 0 0 0 0 0
S000517 Benjamin Smith Benjamin Smith   Democrat MA Senate   1960-12-27 1963-01-03 0   [] 410001       Benjamin A. Smith II   1916-03-26 M 1 1963-01-03 0 0 0 0 0
S000809 Benjamin Stark Benjamin Stark   Democrat OR Senate   1861-07-04 1863-03-03 0   [] 410275       Benjamin Stark   1820-06-26 M 1 1863-03-03 0 0 0 0 0
T000039 Benjamin Tappan Benjamin Tappan   Democrat OH Senate   1839-12-02 1845-03-03 0   [] 410627       Benjamin Tappan   1773-05-25 M 2 1845-03-03 0 0 0 0 0
T000274 Benjamin Tillman Benjamin Tillman   Democrat SC Senate   1895-12-02 1919-03-03 0   [] 410847       Benjamin Tillman   1847-08-11 M 5 1919-03-03 0 0 0 0 0
J000094 Benning Jenness Benning Jenness   Democrat NH Senate   1845-12-01 1847-03-03 0   [] 405996       Benning W. Jenness   1806-07-14 M 1 1847-03-03 0 0 0 0 0
M000716 Bert Miller Bert Miller   Democrat ID Senate   1949-01-03 1949-12-31 0   [] 407698       Bert H. Miller   1876-12-15 M 1 1949-12-31 0 0 0 0 0
N000032 Bill Nelson Bill Nelson   Democrat FL Senate   1979-01-15 2019-01-03 0 N00009926 ["S8FL00166"] 300078 00859 1606 S282 Bill Nelson Bill Nelson (Florida) 1942-09-29 M 7 2019-01-03 0 2204 452 5550 72758053
B000254 Birch Bayh Birch Bayh   Democrat IN Senate   1963-01-09 1981-01-03 0   [] 401248 01277     Birch Bayh   1928-01-22 M 4 1981-01-03 0 0 223 0 0
L000189 Blair Lee Blair Lee   Democrat MD Senate   1914-01-28 1917-03-03 0   [] 406692       Blair Lee I   1857-08-09 M 1 1917-03-03 0 0 0 0 0
L000035 Blanche Lincoln Blanche Lincoln   Democrat AR Senate   1993-01-05 2011-01-03 0 N00008092 ["S8AR00112", "H2AR01022"] 300068 01570 26723 S269 Blanche Lincoln   1960-09-30 F 4 2011-01-03 0 1029 248 3978 8837799
G000352 Bob Graham Bob Graham   Democrat FL Senate   1987-01-06 2005-01-03 0 N00002742 ["S6FL00020"] 300046 01342   S199 Bob Graham   1936-11-09 M 4 2005-01-03 0 1154 314 1980 1000
C000657 Braxton Comer Braxton Comer   Democrat AL Senate   1920-03-05 1921-03-03 0   [] 402784       B. B. Comer   1848-11-07 M 1 1921-03-03 0 0 0 0 0
S001194 Brian Schatz Brian Schatz   Democrat HI Senate   2012-12-27 2029-01-03 1 N00028138 ["S4HI00136", "H6HI02244"] 412507 02173 17852 S353 Brian Schatz Brian E. Schatz 1972-10-20 M 3   0 896 375 4843 5899723
M000559 Brien McMahon Brien McMahon   Democrat CT Senate   1945-01-03 1953-01-03 0   [] 407551       Brien McMahon   1903-10-06 M 2 1953-01-03 0 0 0 0 0
A000031 Brockman Adams Brockman Adams Brock Democrat WA Senate   1965-01-04 1993-01-03 0   [] 400692 00005   S180 Brock Adams   1927-01-13 M 5 1993-01-03 0 0 136 0 0
M000279 Burnet Maybank Burnet Maybank   Democrat SC Senate   1941-01-03 1955-01-03 0   [] 407296       Burnet R. Maybank   1899-03-07 M 3 1955-01-03 0 0 0 0 0
W000330 Burton Wheeler Burton Wheeler   Democrat MT Senate   1923-12-03 1947-01-03 0   [] 411492       Burton K. Wheeler   1882-02-27 M 5 1947-01-03 0 0 0 0 0
D000432 Byron Dorgan Byron Dorgan   Democrat ND Senate   1981-01-05 2011-01-03 0 N00004615 ["S2ND00040"] 300037 00308 53332 S222 Byron Dorgan   1942-05-14 M 6 2011-01-03 0 3880 503 3978 812678
H000265 Byron Harrison Byron Harrison Pat Democrat MS Senate   1911-04-04 1941-12-31 0   [] 405142       Pat Harrison   1881-08-29 M 6 1941-12-31 0 0 0 0 0
B000818 Calvin Brice Calvin Brice   Democrat OH Senate   1891-12-07 1897-03-03 0   [] 401775       Calvin S. Brice   1845-09-17 M 2 1897-03-03 0 0 0 0 0
K000044 Carey Kefauver Carey Kefauver   Democrat TN Senate   1939-01-03 1963-12-31 0   [] 406214       Estes Kefauver   1903-07-26 M 5 1963-12-31 0 0 0 0 0
H000334 Carl Hatch Carl Hatch   Democrat NM Senate   1933-10-10 1949-01-03 0   [] 405204       Carl Hatch   1889-11-27 M 3 1949-01-03 0 0 0 0 0
H000385 Carl Hayden Carl Hayden   Democrat AZ Senate   1911-04-04 1969-01-03 0   [] 405253       Carl Hayden   1877-10-02 M 10 1969-01-03 0 0 0 0 0
L000261 Carl Levin Carl Levin   Democrat MI Senate   1979-01-15 2015-01-03 0 N00001691 ["S8MI00158"] 300066 01384 53307 S131 Carl Levin Carl Levin 1934-06-28 M 7 2015-01-03 0 3965 672 5121 32324
M001025 Carol Moseley Braun Carol Moseley Braun   Democrat IL Senate   1993-01-05 1999-01-03 0   [] 407992 01405   S226 Carol Moseley Braun   1947-08-16 F 2 1999-01-03 0 475 59 0 0
G000561 Carte Goodwin Carte Goodwin   Democrat WV Senate   2010-07-20 2010-11-14 0 N00032762 [] 412389 01980 126202 S336 Carte Goodwin Carte Goodwin 1974-02-27 M 1 2010-11-14 0 14 1 40 0
G000232 Carter Glass Carter Glass   Democrat VA Senate   1902-11-04 1946-05-28 0   [] 404594       Carter Glass   1858-01-04 M 8 1946-05-28 0 0 0 0 0
C001113 Catherine Cortez Masto Catherine Cortez Masto   Democrat NV Senate   2017-01-03 2029-01-03 1 N00037161 ["S6NV00200"] 412681   69579 S385 Catherine Cortez Masto Catherine Cortez Masto 1964-03-29 F 3   0 582 408 3664 121744661
A000244 Charles Andrews Charles Andrews   Democrat FL Senate   1936-11-03 1946-09-18 0   [] 400874       Charles O. Andrews   1877-03-07 M 2 1946-09-18 0 0 0 0 0
A000323 Charles Atherton Charles Atherton   Democrat NH Senate   1837-09-04 1853-12-31 0   [] 400971       Charles G. Atherton   1804-07-04 M 3 1853-12-31 0 0 0 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);