congress_members
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
This data as json, CSV (advanced)
Suggested facets: nickname, district, opensecrets_id, fec_ids, ballotpedia_id, gender, terms_count, trade_count, speech_count, bills_sponsored, 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
state 1
- KY · 382 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| H000187 | Aaron | Harding | Aaron Harding | Democrat | KY | House | 4 | 1861-07-04 | 1867-03-03 | 0 | [] | 405068 | Aaron Harding | 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 | [] | 405948 | Addison James | 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 | [] | 411512 | Addison White | 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 | [] | 401146 | Alben W. Barkley | 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 | [] | 401401 | Albert S. Berry | 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 | [] | 402432 | Happy Chandler | 1898-07-14 | M | 2 | 1945-12-31 | 1 | 0 | 0 | 0 | 0 | ||||||
| H000360 | Albert | Hawes | Albert Hawes | Jackson | KY | House | 2 | 1831-12-05 | 1837-03-03 | 0 | [] | 405229 | Albert Gallatin Hawes | 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 | [] | 410610 | Albert G. Talbott | 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 | [] | 411713 | Albert S. Willis | 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 | [] | 407172 | Alexander Keith Marshall | 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 | [] | 407836 | Alexander B. Montgomery | 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 | [] | 408358 | Alexander D. Orr | 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 | [] | 407536 | Alney McLean | 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 | [] | 403229 | Amos Davis | 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 | [] | 401594 | Andrew Boone | 1831-04-04 | M | 3 | 1879-03-03 | 4 | 0 | 0 | 0 | 0 | ||||||
| K000234 | Andrew | Kirk | Andrew Kirk | Republican | KY | House | 10 | 1925-12-07 | 1927-03-04 | 0 | [] | 406393 | Andrew Jackson Kirk | 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 | [] | 407290 | Andrew J. May | 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 | [] | 410957 | Andrew Trumbo | 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 | [] | 411301 | Andrew H. Ward | 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 | N00031233 | ["H0KY06104"] | 412541 | 02131 | 117290 | Andy Barr (American politician) | Andy Barr | 1973-07-24 | M | 8 | 30 | 523 | 202 | 6825 | 16547296 | ||
| N000143 | Anne | Northup | Anne Northup | Republican | KY | House | 3 | 1997-01-07 | 2007-01-03 | 0 | N00003392 | ["H6KY03090"] | 400294 | 01508 | Anne Northup | 1948-01-22 | F | 6 | 2007-01-03 | 0 | 168 | 3 | 2428 | -6500 | ||||
| N000058 | Anthony | New | Anthony New | Republican | KY | House | 5 | 1793-12-02 | 1823-03-03 | 0 | [] | 408146 | Anthony New | 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 | [] | 403484 | Archibald Dixon | 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 | [] | 409427 | Arthur B. Rouse | 1874-06-20 | M | 9 | 1927-03-04 | 1 | 0 | 0 | 0 | 0 | ||||||
| G000503 | Asa | Grover | Asa Grover | Democrat | KY | House | 5 | 1867-03-04 | 1869-03-03 | 0 | [] | 404848 | Asa Grover | 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 | [] | 402354 | Asher G. Caruth | 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 | [] | 410262 | Augustus Owsley Stanley | 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 | [] | 401982 | Aylette Buckner | 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 | N00026591 | ["H4KY06072"] | 400442 | 01759 | 1891 | Ben Chandler | 1959-09-12 | M | 5 | 2013-01-03 | 5 | 85 | 23 | 6788 | 4421595 | |||
| J000118 | Ben | Johnson | Ben Johnson | Democrat | KY | House | 4 | 1907-12-02 | 1927-03-04 | 0 | [] | 406019 | Ben Johnson (politician) | 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 | [] | 411706 | Ben M. Williamson | 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 | [] | 412046 | Benjamin E. Grey | 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 | [] | 405065 | Benjamin Hardin | 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 | [] | 405681 | Benjamin Howard (Missouri politician) | 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 | [] | 402596 | Beverly L. Clarke | 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 | [] | 411155 | Beverly M. Vincent | 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 | [] | 411782 | Boyd Winchester | 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 | [] | 410187 | Brent Spence | 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 | N00029675 | ["H8KY02031"] | 412278 | 01922 | 18829 | Brett Guthrie | Brett Guthrie | 1964-02-18 | M | 10 | 21 | 498 | 133 | 10085 | 13539361 | |||
| C000479 | Brutus | Clay | Brutus Clay | Unionist | KY | House | 7 | 1863-12-07 | 1865-03-03 | 0 | [] | 402617 | Brutus J. Clay | 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 | [] | 408412 | Bryan Owsley | 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 | [] | 411964 | Bryan Young (politician) | 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 | [] | 410827 | Buckner Thruston | 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 | [] | 409250 | Burwell C. Ritter | 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 | [] | 408872 | Caleb Powers | 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 | [] | 402290 | Cap R. Carden | 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 | [] | 408633 | 00908 | Carl D. Perkins | 1912-10-15 | M | 19 | 1985-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| P000229 | Carl | Perkins | Carl Perkins | Democrat | KY | House | 7 | 1983-01-03 | 1993-01-03 | 0 | [] | 408632 | 00909 | Chris Perkins (politician) | 1954-08-06 | M | 6 | 1993-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| H000878 | Carroll | Hubbard | Carroll Hubbard | Democrat | KY | House | 1 | 1975-01-14 | 1993-01-03 | 0 | [] | 405724 | 00567 | Carroll Hubbard | 1937-07-07 | M | 10 | 1993-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| F000023 | Charles | Farnsley | Charles Farnsley | Democrat | KY | House | 3 | 1965-01-04 | 1967-01-03 | 0 | [] | 403985 | Charles R. Farnsley | 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 | [] | 404085 | Charles Finley (politician) | 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 | [] | 407746 | Charles W. Milliken | 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 | [] | 407905 | Charles S. Morehead | 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 | [] | 408325 | Charles F. Ogden | 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 | [] | 409267 | Charles W. Roark | 1877-01-22 | M | 2 | 1931-03-03 | 3 | 0 | 0 | 0 | 0 | ||||||
| W000331 | Charles | Wheeler | Charles Wheeler | Democrat | KY | House | 1 | 1897-03-15 | 1903-03-03 | 0 | [] | 411493 | Charles K. Wheeler | 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 | [] | 411600 | Charles A. Wickliffe | 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 | [] | 402328 | Chester O. Carrier | 1897-05-05 | M | 2 | 1945-01-03 | 1 | 0 | 0 | 0 | 0 | ||||||
| A000108 | Chilton | Allan | Chilton Allan | Whig | KY | House | 10 | 1831-12-05 | 1837-03-03 | 0 | [] | 400766 | Chilton Allan | 1786-04-06 | M | 4 | 1837-03-03 | 2 | 0 | 0 | 0 | 0 | ||||||
| L000541 | Chittenden | Lyon | Chittenden Lyon | Jackson | KY | House | 1 | 1827-12-03 | 1835-03-03 | 0 | [] | 407025 | Chittenden Lyon | 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 | [] | 404782 | Christopher Greenup | 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 | [] | 410877 | Christopher Tompkins | 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 | [] | 405451 | Clement S. Hill | 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 | [] | 401740 | Daniel Breck | 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 | [] | 404635 | Daniel Linn Gooch | 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 | [] | 402777 | David G. Colson | 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 | [] | 406349 | David Hayes Kincheloe | 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 | [] | 407636 | David Meriwether (Kentucky politician) | 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 | [] | 410008 | David Highbaugh Smith | 1854-12-19 | M | 6 | 1907-03-03 | 2 | 0 | 0 | 0 | 0 | ||||||
| T000372 | David | Trimble | David Trimble | Adams | KY | House | 1 | 1817-12-01 | 1827-03-03 | 0 | [] | 410941 | David Trimble (congressman) | 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 | [] | 412114 | David Walker (Kentucky politician) | 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 | [] | 411525 | David White (U.S. politician) | 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 | [] | 403758 | Don C. Edwards | 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 | [] | 402642 | Earle Clements | 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 | N00003467 | ["H4KY01040"] | 400431 | 01222 | 21873 | Ed Whitfield | Ed Whitfield | 1943-05-25 | M | 11 | 2016-09-07 | 129 | 468 | 85 | 9874 | 3612789 | ||
| C000898 | Edward | Creal | Edward Creal | Democrat | KY | House | 4 | 1935-01-03 | 1945-01-03 | 0 | [] | 403010 | Edward W. Creal | 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 | [] | 403045 | Edward Crossland | 1827-06-30 | M | 3 | 1875-03-03 | 1 | 0 | 0 | 0 | 0 | ||||||
| P000087 | Edward | Parsons | Edward Parsons | Democrat | KY | House | 5 | 1875-12-06 | 1877-03-03 | 0 | [] | 408497 | Edward Y. Parsons | 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 | [] | 409466 | Edward Rumsey | 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 | [] | 405499 | Elijah Hise | 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 | [] | 408717 | Elijah Phister | 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 | [] | 410256 | Elisha Standiford | 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 | [] | 406259 | Elva R. Kendall | 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 | [] | 408298 | Emmet O'Neal (Kentucky politician) | 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 | N00003430 | ["H6KY06085"] | 400135 | 01563 | 115 | Ernie Fletcher | Ernie Fletcher | 1952-11-12 | M | 3 | 2003-12-08 | 0 | 146 | 3 | 676 | 0 | |
| S000408 | Eugene | Siler | Eugene Siler | Republican | KY | House | 5 | 1955-01-05 | 1965-01-03 | 0 | [] | 409902 | Eugene Siler | 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 | [] | 409753 | Evan E. Settle | 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 | [] | 407538 | Finis McLean | 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 | [] | 404991 | Finley Hamilton | 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 | [] | 401799 | Francis Bristow | 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 | [] | 405623 | Francis A. Hopkins | 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 | [] | 406028 | Francis Johnson (congressman) | 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 | [] | 402036 | Frank W. Burke | 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 | [] | 402482 | Frank Chelf | 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 | [] | 410493 | 01119 | Frank Stubblefield | 1907-04-05 | M | 9 | 1975-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| W000681 | Frank | Wolford | Frank Wolford | Democrat | KY | House | 11 | 1883-12-03 | 1887-03-03 | 0 | [] | 411833 | Frank Lane Wolford | 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 | [] | 409526 | Frederic M. Sackett | 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 | [] | 411161 | Fred M. Vinson | Frederick Vinson | 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 | [] | 403235 | Garrett Davis | 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 | [] | 411811 | Garrett Withers | 1884-06-21 | M | 3 | 1953-04-30 | 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);