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 federal cross-reference IDs (FEC, Library of Congress THOMAS/LIS).

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

382 rows where state = "KY" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

party 15

  • Democrat 170
  • Republican 109
  • Whig 43
  • Jackson 17
  • Unionist 9
  • American 7
  • - 5
  • Anti Jacksonian 5
  • Adams 4
  • Ind. Republican-Democrat 4
  • Unconditional Unionist 4
  • Federalist 2
  • Anti Jackson 1
  • Anti-Administration 1
  • Ind. Democrat 1

is_current 2

  • 0 374
  • 1 8

chamber 2

  • House 322
  • Senate 60

state 1

  • KY · 382 ✖
bioguide_id first_name last_name full_name ▼ nickname party state chamber district first_served last_served is_current fec_ids thomas_id lis_id birthday gender terms_count served_until trade_count speech_count bills_sponsored vote_count fec_total_received
H000187 Aaron Harding Aaron Harding   Democrat KY House 4 1861-07-04 1867-03-03 0 []     1805-02-20 M 4 1867-03-03 0 0 0 0 0
J000043 Addison James Addison James   Republican KY House 3 1907-12-02 1909-03-03 0 []     1849-02-27 M 2 1909-03-03 0 0 0 0 0
W000350 Addison White Addison White   Whig KY House 6 1851-12-01 1853-03-03 0 []     1824-05-01 M 2 1853-03-03 0 0 0 0 0
B000145 Alben Barkley Alben Barkley   Democrat KY Senate   1913-04-07 1956-04-30 0 []     1877-11-24 M 8 1956-04-30 0 0 0 0 0
B000414 Albert Berry Albert Berry   Democrat KY House 6 1893-08-07 1901-03-03 0 []     1836-05-13 M 5 1901-03-03 0 0 0 0 0
C000290 Albert Chandler Albert Chandler Happy Democrat KY Senate   1939-10-10 1945-12-31 0 []     1898-07-14 M 2 1945-12-31 0 0 0 0 0
H000360 Albert Hawes Albert Hawes   Jackson KY House 2 1831-12-05 1837-03-03 0 []     1804-04-01 M 4 1837-03-03 0 0 0 0 0
T000020 Albert Talbott Albert Talbott   Democrat KY House 4 1855-12-03 1859-03-03 0 []     1808-04-04 M 3 1859-03-03 0 0 0 0 0
W000557 Albert Willis Albert Willis   Democrat KY House 5 1877-10-15 1887-03-03 0 []     1843-01-22 M 6 1887-03-03 0 0 0 0 0
M000149 Alexander Marshall Alexander Marshall   American KY House 8 1855-12-03 1857-03-03 0 []     1808-02-11 M 2 1857-03-03 0 0 0 0 0
M000863 Alexander Montgomery Alexander Montgomery   Democrat KY House 4 1887-12-05 1895-03-03 0 []     1837-12-11 M 5 1895-03-03 0 0 0 0 0
O000101 Alexander Orr Alexander Orr   Republican KY House 2 1791-10-24 1797-03-03 0 []     1761-11-06 M 4 1797-03-03 0 0 0 0 0
M000544 Alney McLean Alney McLean   Republican KY House 5 1815-12-04 1821-03-03 0 []     1779-06-10 M 4 1821-03-03 0 0 0 0 0
D000092 Amos Davis Amos Davis   Anti Jacksonian KY House 11 1833-12-02 1835-03-03 0 []     1794-08-15 M 2 1835-03-03 0 0 0 0 0
B000629 Andrew Boone Andrew Boone   Democrat KY House 1 1875-12-06 1879-03-03 0 []     1831-04-04 M 3 1879-03-03 0 0 0 0 0
K000234 Andrew Kirk Andrew Kirk   Republican KY House 10 1925-12-07 1927-03-04 0 []     1866-03-19 M 2 1927-03-04 0 0 0 0 0
M000272 Andrew May Andrew May   Democrat KY House 7 1931-12-07 1947-01-03 0 []     1875-06-24 M 9 1947-01-03 0 0 0 0 0
T000388 Andrew Trumbo Andrew Trumbo   Whig KY House 9 1845-12-01 1847-03-03 0 []     1797-09-15 M 2 1847-03-03 0 0 0 0 0
W000126 Andrew Ward Andrew Ward   Democrat KY House 6 1865-12-04 1867-03-03 0 []     1815-01-03 M 2 1867-03-03 0 0 0 0 0
B001282 Garland Barr Andy Barr Andy Republican KY House 6 2013-01-03 2027-01-03 1 ["H0KY06104"] 02131   1973-07-24 M 8   0 523 207 6933 16547296
N000143 Anne Northup Anne Northup   Republican KY House 3 1997-01-07 2007-01-03 0 ["H6KY03090"] 01508   1948-01-22 F 6 2007-01-03 0 168 11 2428 -6500
N000058 Anthony New Anthony New   Republican KY House 5 1793-12-02 1823-03-03 0 []       M 16 1823-03-03 0 0 0 0 0
D000367 Archibald Dixon Archibald Dixon   Whig KY Senate   1852-01-01 1855-03-03 0 []     1802-04-02 M 1 1855-03-03 0 0 0 0 0
R000466 Arthur Rouse Arthur Rouse   Democrat KY House 6 1911-04-04 1927-03-04 0 []     1874-06-20 M 9 1927-03-04 0 0 0 0 0
G000503 Asa Grover Asa Grover   Democrat KY House 5 1867-03-04 1869-03-03 0 []     1819-02-18 M 2 1869-03-03 0 0 0 0 0
C000208 Asher Caruth Asher Caruth   Democrat KY House 5 1887-12-05 1895-03-03 0 []     1844-02-07 M 5 1895-03-03 0 0 0 0 0
S000796 Augustus Stanley Augustus Stanley   Democrat KY Senate   1903-11-09 1925-03-03 0 []     1867-05-21 M 4 1925-03-03 0 0 0 0 0
B001032 Aylette Buckner Aylette Buckner   Whig KY House 4 1847-12-06 1849-03-03 0 []     1806-07-21 M 2 1849-03-03 0 0 0 0 0
C001058 Ben Chandler Ben Chandler   Democrat KY House 6 2004-02-17 2013-01-03 0 ["H4KY06072"] 01759   1959-09-12 M 5 2013-01-03 0 85 23 6788 4421595
J000118 Ben Johnson Ben Johnson   Democrat KY House 4 1907-12-02 1927-03-04 0 []     1858-05-20 M 11 1927-03-04 0 0 0 0 0
W000550 Ben Williamson Ben Williamson   Democrat KY Senate   1930-01-01 1931-03-03 0 []     1864-10-16 M 1 1931-03-03 0 0 0 0 0
G000453 Benjamin Grey Benjamin Grey   Whig KY House 2 1851-12-01 1855-03-03 0 []       M 3 1855-03-03 0 0 0 0 0
H000184 Benjamin Hardin Benjamin Hardin   Whig KY House 7 1815-12-04 1837-03-03 0 []     1784-02-29 M 12 1837-03-03 0 0 0 0 0
H000834 Benjamin Howard Benjamin Howard   Republican KY House 5 1807-10-26 1811-03-03 0 []       M 3 1811-03-03 0 0 0 0 0
C000458 Beverly Clarke Beverly Clarke   Democrat KY House 2 1847-12-06 1849-03-03 0 []     1809-02-11 M 2 1849-03-03 0 0 0 0 0
V000100 Beverly Vincent Beverly Vincent   Democrat KY House 2 1937-01-05 1945-01-03 0 []     1890-03-28 M 5 1945-01-03 0 0 0 0 0
W000628 Boyd Winchester Boyd Winchester   Democrat KY House 5 1869-03-04 1873-03-03 0 []     1836-09-23 M 3 1873-03-03 0 0 0 0 0
S000717 Brent Spence Brent Spence   Democrat KY House 5 1931-12-07 1963-01-03 0 []     1874-12-24 M 17 1963-01-03 0 0 0 0 0
G000558 Brett Guthrie Brett Guthrie   Republican KY House 2 2009-01-06 2027-01-03 1 ["H8KY02031"] 01922   1964-02-18 M 10   0 498 137 10193 13539361
C000479 Brutus Clay Brutus Clay   Unionist KY House 7 1863-12-07 1865-03-03 0 []     1808-07-01 M 2 1865-03-03 0 0 0 0 0
O000162 Bryan Owsley Bryan Owsley   Whig KY House 4 1841-05-31 1843-03-03 0 []     1798-08-19 M 2 1843-03-03 0 0 0 0 0
Y000030 Bryan Young Bryan Young   Whig KY House 5 1845-12-01 1847-03-03 0 []     1800-01-14 M 2 1847-03-03 0 0 0 0 0
T000249 Buckner Thruston Buckner Thruston   Republican KY Senate   1805-12-02 1809-12-31 0 []     1763-02-09 M 1 1809-12-31 0 0 0 0 0
R000276 Burwell Ritter Burwell Ritter   Democrat KY House 2 1865-12-04 1867-03-03 0 []     1810-01-06 M 2 1867-03-03 0 0 0 0 0
P000487 Caleb Powers Caleb Powers   Republican KY House 11 1911-04-04 1919-03-03 0 []     1869-02-01 M 5 1919-03-03 0 0 0 0 0
C000140 Cap Carden Cap Carden   Democrat KY House 4 1931-12-07 1937-01-03 0 []     1866-12-17 M 4 1937-01-03 0 0 0 0 0
P000230 Carl Perkins Carl Perkins   Democrat KY House 7 1949-01-03 1985-01-03 0 [] 00908   1912-10-15 M 19 1985-01-03 0 0 391 0 0
P000229 Carl Perkins Carl Perkins   Democrat KY House 7 1983-01-03 1993-01-03 0 [] 00909   1954-08-06 M 6 1993-01-03 0 0 26 0 0
H000878 Carroll Hubbard Carroll Hubbard   Democrat KY House 1 1975-01-14 1993-01-03 0 [] 00567   1937-07-07 M 10 1993-01-03 0 0 74 0 0
F000023 Charles Farnsley Charles Farnsley   Democrat KY House 3 1965-01-04 1967-01-03 0 []     1907-03-28 M 2 1967-01-03 0 0 0 0 0
F000130 Charles Finley Charles Finley   Republican KY House 11 1929-04-15 1933-03-03 0 []     1865-03-26 M 3 1933-03-03 0 0 0 0 0
M000768 Charles Milliken Charles Milliken   Democrat KY House 3 1873-12-01 1877-03-03 0 []     1827-08-15 M 3 1877-03-03 0 0 0 0 0
M000936 Charles Morehead Charles Morehead   Whig KY House 8 1847-12-06 1851-03-03 0 []     1802-07-07 M 3 1851-03-03 0 0 0 0 0
O000042 Charles Ogden Charles Ogden   Republican KY House 5 1919-05-19 1923-03-03 0 []     1873-02-04 M 3 1923-03-03 0 0 0 0 0
R000294 Charles Roark Charles Roark   Republican KY House -1 1929-04-15 1931-03-03 0 []     1877-01-22 M 2 1931-03-03 0 0 0 0 0
W000331 Charles Wheeler Charles Wheeler   Democrat KY House 1 1897-03-15 1903-03-03 0 []     1863-04-18 M 4 1903-03-03 0 0 0 0 0
W000442 Charles Wickliffe Charles Wickliffe   Unionist KY House 5 1823-12-01 1863-03-03 0 []     1788-06-08 M 21 1863-03-03 0 0 0 0 0
C000181 Chester Carrier Chester Carrier   Republican KY House 4 1943-01-06 1945-01-03 0 []     1897-05-05 M 2 1945-01-03 0 0 0 0 0
A000108 Chilton Allan Chilton Allan   Whig KY House 10 1831-12-05 1837-03-03 0 []     1786-04-06 M 4 1837-03-03 0 0 0 0 0
L000541 Chittenden Lyon Chittenden Lyon   Jackson KY House 1 1827-12-03 1835-03-03 0 []     1787-02-22 M 5 1835-03-03 0 0 0 0 0
G000434 Christopher Greenup Christopher Greenup   Republican KY House 1 1791-10-24 1797-03-03 0 []       M 4 1797-03-03 0 0 0 0 0
T000304 Christopher Tompkins Christopher Tompkins   Anti Jacksonian KY House 3 1831-12-05 1835-03-03 0 []     1780-03-24 M 3 1835-03-03 0 0 0 0 0
H000589 Clement Hill Clement Hill   Whig KY House 5 1853-12-05 1855-03-03 0 []     1813-02-13 M 2 1855-03-03 0 0 0 0 0
B000782 Daniel Breck Daniel Breck   Whig KY House 6 1849-12-03 1851-03-03 0 []     1788-02-12 M 2 1851-03-03 0 0 0 0 0
G000273 Daniel Gooch Daniel Gooch   Democrat KY House 6 1901-12-02 1905-03-03 0 []     1853-10-28 M 3 1905-03-03 0 0 0 0 0
C000649 David Colson David Colson   Republican KY House 11 1895-12-02 1899-03-03 0 []     1861-04-01 M 3 1899-03-03 0 0 0 0 0
K000187 David Kincheloe David Kincheloe   Democrat KY House 2 1915-12-06 1931-03-03 0 []     1877-04-09 M 9 1931-03-03 0 0 0 0 0
M000650 David Meriwether David Meriwether   Democrat KY Senate   1852-01-01 1853-03-03 0 []     1800-10-30 M 1 1853-03-03 0 0 0 0 0
S000525 David Smith David Smith   Democrat KY House 4 1897-03-15 1907-03-03 0 []     1854-12-19 M 6 1907-03-03 0 0 0 0 0
T000372 David Trimble David Trimble   Adams KY House 1 1817-12-01 1827-03-03 0 []       M 6 1827-03-03 0 0 0 0 0
W000048 David Walker David Walker   Republican KY House 6 1817-12-01 1821-03-03 0 []       M 3 1821-03-03 0 0 0 0 0
W000363 David White David White     KY House 6 1823-12-01 1825-03-03 0 []       M 2 1825-03-03 0 0 0 0 0
E000065 Don Edwards Don Edwards   Republican KY House 11 1905-12-04 1911-03-03 0 []     1861-07-13 M 4 1911-03-03 0 0 0 0 0
C000506 Earle Clements Earle Clements   Democrat KY Senate   1945-01-03 1957-01-03 0 []     1896-10-22 M 3 1957-01-03 0 0 0 0 0
W000413 Ed Whitfield Ed Whitfield   Republican KY House 1 1995-01-04 2016-09-07 0 ["H4KY01040"] 01222   1943-05-25 M 11 2016-09-07 100 468 119 9874 3612789
C000898 Edward Creal Edward Creal   Democrat KY House 4 1935-01-03 1945-01-03 0 []     1883-11-20 M 6 1945-01-03 0 0 0 0 0
C000933 Edward Crossland Edward Crossland   Democrat KY House 1 1871-03-04 1875-03-03 0 []     1827-06-30 M 3 1875-03-03 0 0 0 0 0
P000087 Edward Parsons Edward Parsons   Democrat KY House 5 1875-12-06 1877-03-03 0 []     1842-12-12 M 2 1877-03-03 0 0 0 0 0
R000507 Edward Rumsey Edward Rumsey   Whig KY House 2 1837-09-04 1839-03-03 0 []     1796-11-05 M 2 1839-03-03 0 0 0 0 0
H000644 Elijah Hise Elijah Hise   Democrat KY House 3 1865-12-04 1869-03-03 0 []     1802-07-04 M 3 1869-03-03 0 0 0 0 0
P000318 Elijah Phister Elijah Phister   Democrat KY House 10 1879-03-18 1883-03-03 0 []     1822-10-08 M 3 1883-03-03 0 0 0 0 0
S000790 Elisha Standiford Elisha Standiford   Democrat KY House 5 1873-12-01 1875-03-03 0 []     1831-12-28 M 2 1875-03-03 0 0 0 0 0
K000091 Elva Kendall Elva Kendall   Republican KY House 9 1929-04-15 1931-03-03 0 []     1893-02-14 M 2 1931-03-03 0 0 0 0 0
O000089 Emmet O’Neal Emmet O’Neal   Democrat KY House 3 1935-01-03 1947-01-03 0 []     1887-04-14 M 7 1947-01-03 0 0 0 0 0
F000441 Ernest Fletcher Ernest Fletcher Ernie Republican KY House 6 1999-01-06 2003-12-08 0 ["H6KY06085"] 01563   1952-11-12 M 3 2003-12-08 0 146 23 676 0
S000408 Eugene Siler Eugene Siler   Republican KY House 5 1955-01-05 1965-01-03 0 []     1900-06-26 M 6 1965-01-03 0 0 0 0 0
S000252 Evan Settle Evan Settle   Democrat KY House 7 1897-03-15 1901-03-03 0 []     1848-12-01 M 3 1901-03-03 0 0 0 0 0
M000546 Finis McLean Finis McLean   Whig KY House 3 1849-12-03 1851-03-03 0 []     1806-02-19 M 2 1851-03-03 0 0 0 0 0
H000109 Finley Hamilton Finley Hamilton   Democrat KY House 0 1933-03-09 1935-01-03 0 []     1886-06-19 M 2 1935-01-03 0 0 0 0 0
B000842 Francis Bristow Francis Bristow   Ind. Republican-Democrat KY House 3 1853-12-05 1861-03-03 0 []     1804-08-11 M 5 1861-03-03 0 0 0 0 0
H000773 Francis Hopkins Francis Hopkins   Democrat KY House 10 1903-11-09 1907-03-03 0 []     1853-05-27 M 3 1907-03-03 0 0 0 0 0
J000129 Francis Johnson Francis Johnson   Adams KY House 10 1819-12-06 1827-03-03 0 []     1776-06-19 M 5 1827-03-03 0 0 0 0 0
B001090 Frank Burke Frank Burke   Democrat KY House 3 1959-01-07 1963-01-03 0 []     1920-06-01 M 3 1963-01-03 0 0 0 0 0
C000342 Frank Chelf Frank Chelf   Democrat KY House 4 1945-01-03 1967-01-03 0 []     1907-09-22 M 12 1967-01-03 0 0 0 0 0
S001037 Frank Stubblefield Frank Stubblefield   Democrat KY House 1 1959-01-07 1975-01-03 0 [] 01119   1907-04-05 M 9 1975-01-03 0 0 19 0 0
W000681 Frank Wolford Frank Wolford   Democrat KY House 11 1883-12-03 1887-03-03 0 []     1817-09-02 M 3 1887-03-03 0 0 0 0 0
S000006 Frederic Sackett Frederic Sackett   Republican KY Senate   1925-12-07 1931-03-03 0 []     1868-12-17 M 2 1931-03-03 0 0 0 0 0
V000106 Frederick Vinson Frederick Vinson   Democrat KY House 8 1923-12-03 1939-01-03 0 []     1890-01-22 M 9 1939-01-03 0 0 0 0 0
D000099 Garrett Davis Garrett Davis   Democrat KY Senate   1839-12-02 1873-03-03 0 []     1801-09-10 M 6 1873-03-03 0 0 0 0 0
W000658 Garrett Withers Garrett Withers   Democrat KY House 2 1949-01-20 1953-04-30 0 []     1884-06-21 M 3 1953-04-30 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,
    fec_ids TEXT,
    thomas_id TEXT,
    lis_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 428.288ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API