home / openregs

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

1,964 rows where chamber = "Senate" sorted by full_name

✎ View and edit SQL

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

  • NJ 64
  • GA 63
  • NH 62
  • KY 60
  • TN 59
  • NY 57
  • OH 57
  • MD 56
  • SC 55
  • PA 54
  • CT 53
  • NC 53
  • DE 52
  • VA 51
  • IL 48
  • LA 48
  • MA 48
  • CA 47
  • IN 47
  • RI 47
  • MO 46
  • MS 44
  • AL 43
  • MI 39
  • NE 39
  • VT 39
  • CO 37
  • ME 37
  • MN 36
  • OR 36
  • …

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

is_current 2

  • 0 1,864
  • 1 100

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

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);
Powered by Datasette · Queries took 438.58ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API