congress_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
702 rows where state = "OH" sorted by full_name
This data as json, CSV (advanced)
Suggested facets: nickname, district, gender, terms_count, first_served (date), last_served (date), birthday (date), served_until (date), fec_ids (array)
party 15
- Republican 328
- Democrat 279
- Whig 44
- Adams 13
- Jackson 12
- Ind. Republican-Democrat 9
- - 7
- Anti Jacksonian 3
- Anti Masonic 1
- Federalist 1
- Free Soil 1
- Ind. Democrat 1
- Ind. Republican 1
- Independent 1
- Unionist 1
state 1
- OH · 702 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| H000207 | Aaron | Harlan | Aaron Harlan | Republican | OH | House | 7 | 1853-12-05 | 1859-03-03 | 0 | [] | 405086 | Aaron Harlan | 1802-09-08 | M | 4 | 1859-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000241 | Aaron | Perry | Aaron Perry | Republican | OH | House | 1 | 1871-03-04 | 1873-03-03 | 0 | [] | 408644 | Aaron F. Perry | 1815-01-01 | M | 2 | 1873-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000344 | Addison | McClure | Addison McClure | Republican | OH | House | 17 | 1881-12-05 | 1897-03-03 | 0 | [] | 407353 | Addison S. McClure | 1839-10-10 | M | 9 | 1897-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| J000113 | Adna | Johnson | Adna Johnson | Republican | OH | House | 10 | 1909-03-15 | 1911-03-03 | 0 | [] | 406014 | Adna R. Johnson | 1860-12-14 | M | 2 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000151 | Adoniram | Warner | Adoniram Warner | Democrat | OH | House | 17 | 1879-03-18 | 1887-03-03 | 0 | [] | 411325 | Adoniram J. Warner | 1834-01-13 | M | 5 | 1887-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000245 | Albert | Baumhart | Albert Baumhart | Republican | OH | House | 13 | 1941-01-03 | 1961-01-03 | 0 | [] | 401239 | Albert David Baumhart Jr. | 1908-06-15 | M | 11 | 1961-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| D000449 | Albert | Douglas | Albert Douglas | Republican | OH | House | 11 | 1907-12-02 | 1911-03-03 | 0 | [] | 403559 | Albert Douglas | 1852-04-25 | M | 3 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000164 | Albert | Pearson | Albert Pearson | Democrat | OH | House | 16 | 1891-12-07 | 1895-03-03 | 0 | [] | 408569 | Albert J. Pearson | 1846-05-20 | M | 3 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000238 | Albert | Riddle | Albert Riddle | Republican | OH | House | 19 | 1861-07-04 | 1863-03-03 | 0 | [] | 409214 | Albert G. Riddle | 1816-05-28 | M | 2 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000191 | Albert | Thompson | Albert Thompson | Republican | OH | House | 11 | 1885-12-07 | 1891-03-03 | 0 | [] | 410771 | Albert C. Thompson | 1842-01-23 | M | 4 | 1891-03-03 | 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 | ||||||||
| D000528 | Alexander | Duncan | Alexander Duncan | Democrat | OH | House | 1 | 1837-09-04 | 1845-03-03 | 0 | [] | 403637 | Alexander Duncan (politician) | M | 5 | 1845-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000219 | Alexander | Harper | Alexander Harper | Whig | OH | House | 14 | 1837-09-04 | 1853-03-03 | 0 | [] | 405097 | Alexander Harper (Ohio politician) | 1786-02-05 | M | 9 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000410 | Alexander | Long | Alexander Long | Democrat | OH | House | 2 | 1863-12-07 | 1865-03-03 | 0 | [] | 406901 | Alexander Long | 1816-12-24 | M | 2 | 1865-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| A000111 | Alfred | Allen | Alfred Allen | Democrat | OH | House | 2 | 1911-04-04 | 1917-03-03 | 0 | [] | 400768 | Alfred G. Allen | 1867-07-23 | M | 4 | 1917-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| E000045 | Alfred | Edgerton | Alfred Edgerton | Democrat | OH | House | 5 | 1851-12-01 | 1855-03-03 | 0 | [] | 403740 | Alfred Peck Edgerton | 1813-01-11 | M | 3 | 1855-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000952 | Alfred | Stone | Alfred Stone | Democrat | OH | House | 10 | 1843-12-04 | 1845-03-03 | 0 | [] | 410411 | Alfred P. Stone | 1813-06-28 | M | 2 | 1845-03-03 | 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 | |||||||
| H000282 | Alphonso | Hart | Alphonso Hart | Republican | OH | House | 12 | 1883-12-03 | 1885-03-03 | 0 | [] | 405156 | Alphonso Hart | 1830-07-04 | M | 2 | 1885-03-03 | 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 | |||||||
| W000252 | Alvin | Weichel | Alvin Weichel | Republican | OH | House | 13 | 1943-01-06 | 1955-01-03 | 0 | [] | 411420 | Alvin F. Weichel | 1891-09-11 | M | 7 | 1955-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000855 | Ambrose | Stephens | Ambrose Stephens | Republican | OH | House | -1 | 1919-05-19 | 1929-03-03 | 0 | [] | 410318 | Ambrose E. B. Stephens | 1862-06-03 | M | 6 | 1929-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000194 | Americus | Rice | Americus Rice | Democrat | OH | House | 5 | 1875-12-06 | 1879-03-03 | 0 | [] | 409170 | Americus V. Rice | 1835-11-18 | M | 3 | 1879-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| J000004 | Amos | Jackson | Amos Jackson | Republican | OH | House | 13 | 1903-11-09 | 1905-03-03 | 0 | [] | 405912 | Amos H. Jackson | 1846-05-10 | M | 2 | 1905-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000328 | Amos | Townsend | Amos Townsend | Republican | OH | House | 20 | 1877-10-15 | 1883-03-03 | 0 | [] | 410899 | Amos Townsend | M | 4 | 1883-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| W000233 | Amos | Webber | Amos Webber | Republican | OH | House | 14 | 1903-11-09 | 1907-03-03 | 0 | [] | 411401 | Amos R. Webber | 1852-01-21 | M | 3 | 1907-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000689 | Amos | Wood | Amos Wood | Democrat | OH | House | 6 | 1849-12-03 | 1851-03-03 | 0 | [] | 411841 | Amos E. Wood | 1810-01-02 | M | 2 | 1851-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| E000140 | Andrew | Ellison | Andrew Ellison | Democrat | OH | House | 6 | 1853-12-05 | 1855-03-03 | 0 | [] | 403831 | Andrew Ellison | M | 2 | 1855-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| L000436 | Andrew | Loomis | Andrew Loomis | Whig | OH | House | 17 | 1837-09-04 | 1839-03-03 | 0 | [] | 406927 | Andrew W. Loomis | 1797-06-27 | M | 2 | 1839-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S001031 | Andrew | Stuart | Andrew Stuart | Democrat | OH | House | 21 | 1853-12-05 | 1855-03-03 | 0 | [] | 410487 | Andrew Stuart (Ohio politician) | 1823-08-03 | M | 2 | 1855-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000091 | Ansel | Walling | Ansel Walling | Democrat | OH | House | 12 | 1875-12-06 | 1877-03-03 | 0 | [] | 411270 | Ansel T. Walling | 1824-01-10 | M | 2 | 1877-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| F000195 | Anthony | Fleger | Anthony Fleger | Democrat | OH | House | 22 | 1937-01-05 | 1939-01-03 | 0 | [] | 404150 | Anthony A. Fleger | 1900-10-21 | M | 2 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000588 | Anthony | Gonzalez | Anthony Gonzalez | Republican | OH | House | 16 | 2019-01-03 | 2023-01-03 | 0 | N00041690 | ["H8OH16124"] | 412807 | 178867 | Anthony Gonzalez (politician) | Anthony Gonzalez | 1984-09-18 | M | 3 | 2023-01-03 | 31 | 51 | 36 | 1401 | 2633805 | |||
| L000523 | Archibald | Lybrand | Archibald Lybrand | Republican | OH | House | 8 | 1897-03-15 | 1901-03-03 | 0 | [] | 407007 | Archibald Lybrand | 1840-05-23 | M | 3 | 1901-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| A000088 | Arthur | Aleshire | Arthur Aleshire | Democrat | OH | House | 7 | 1937-01-05 | 1939-01-03 | 0 | [] | 400747 | Arthur W. Aleshire | 1900-02-15 | M | 2 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000040 | Arthur | Lamneck | Arthur Lamneck | Democrat | OH | House | 12 | 1931-12-07 | 1939-01-03 | 0 | [] | 406550 | Arthur P. Lamneck | 1880-03-12 | M | 5 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| O000141 | Arthur | Overmyer | Arthur Overmyer | Democrat | OH | House | 13 | 1915-12-06 | 1919-03-03 | 0 | [] | 408392 | Arthur W. Overmyer | 1879-05-31 | M | 3 | 1919-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 | |||||||
| P000240 | Augustus | Perrill | Augustus Perrill | Democrat | OH | House | 9 | 1845-12-01 | 1847-03-03 | 0 | [] | 408643 | Augustus L. Perrill | 1807-01-20 | M | 2 | 1847-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000971 | Bellamy | Storer | Bellamy Storer | Whig | OH | House | 1 | 1835-12-07 | 1837-03-03 | 0 | [] | 410429 | Bellamy Storer (Ohio politician) | 1796-03-26 | M | 2 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000970 | Bellamy | Storer | Bellamy Storer | Republican | OH | House | 1 | 1891-12-07 | 1895-03-03 | 0 | [] | 410430 | Bellamy Storer (ambassador) | 1847-08-28 | M | 3 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| D000146 | Beman | Dawes | Beman Dawes | Republican | OH | House | 15 | 1905-12-04 | 1909-03-03 | 0 | [] | 403279 | Beman Gates Dawes | 1870-01-14 | M | 3 | 1909-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B001200 | Benjamin | Butterworth | Benjamin Butterworth | Republican | OH | House | 1 | 1879-03-18 | 1891-03-03 | 0 | [] | 402142 | Benjamin Butterworth | 1837-10-22 | M | 7 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000821 | Benjamin | Cowen | Benjamin Cowen | Whig | OH | House | 11 | 1841-05-31 | 1843-03-03 | 0 | [] | 402939 | Benjamin S. Cowen | 1793-09-27 | M | 2 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| E000090 | Benjamin | Eggleston | Benjamin Eggleston | Republican | OH | House | 1 | 1865-12-04 | 1869-03-03 | 0 | [] | 403783 | Benjamin Eggleston | 1816-01-03 | M | 3 | 1869-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| J000212 | Benjamin | Jones | Benjamin Jones | Jackson | OH | House | 18 | 1833-12-02 | 1837-03-03 | 0 | [] | 406107 | Benjamin Jones (congressman) | 1787-04-13 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000159 | Benjamin | Le Fevre | Benjamin Le Fevre | Democrat | OH | House | 5 | 1879-03-18 | 1887-03-03 | 0 | [] | 406663 | Benjamin Le Fevre | 1838-10-08 | M | 5 | 1887-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000236 | Benjamin | Leiter | Benjamin Leiter | Republican | OH | House | 18 | 1855-12-03 | 1859-03-03 | 0 | [] | 406739 | Benjamin F. Leiter | 1813-10-13 | M | 3 | 1859-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M001089 | Benjamin | Murphy | Benjamin Murphy | Republican | OH | House | 18 | 1919-05-19 | 1933-03-03 | 0 | [] | 408053 | B. Frank Murphy | 1867-12-24 | M | 8 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000500 | Benjamin | Ruggles | Benjamin Ruggles | Adams | OH | Senate | 1815-12-04 | 1833-03-03 | 0 | [] | 409459 | Benjamin Ruggles | 1783-02-21 | M | 4 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| S000801 | Benjamin | Stanton | Benjamin Stanton | Republican | OH | House | 8 | 1851-12-01 | 1861-03-03 | 0 | [] | 410267 | Benjamin Stanton | 1809-06-04 | M | 6 | 1861-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 | |||||||
| W000005 | Benjamin | Wade | Benjamin Wade | Republican | OH | Senate | 1851-12-01 | 1869-03-03 | 0 | [] | 411184 | Benjamin Wade | 1800-10-27 | M | 4 | 1869-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| W000291 | Benjamin | Welty | Benjamin Welty | Democrat | OH | House | 4 | 1917-04-02 | 1921-03-03 | 0 | [] | 411455 | Benjamin F. Welty | 1870-08-09 | M | 3 | 1921-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000474 | Beriah | Wilkins | Beriah Wilkins | Democrat | OH | House | 16 | 1883-12-03 | 1889-03-03 | 0 | [] | 411631 | Beriah Wilkins | 1846-07-10 | M | 4 | 1889-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M001242 | Bernie | Moreno | Bernie Moreno | Republican | OH | Senate | 2025-01-03 | 2031-01-03 | 1 | N00048437 | ["S4OH00192"] | 456967 | S434 | Bernie Moreno | 1967-02-14 | M | 2 | 10 | 87 | 22 | 705 | 158943992 | ||||||
| S001174 | Betty | Sutton | Betty Sutton | Democrat | OH | House | 13 | 2007-01-04 | 2013-01-03 | 0 | N00027901 | ["H6OH13133"] | 412228 | 01870 | 8394 | Betty Sutton | 1963-07-31 | F | 4 | 2013-01-03 | 6 | 239 | 57 | 5061 | 7066751 | |||
| J000292 | Bill | Johnson | Bill Johnson | Republican | OH | House | 6 | 2011-01-05 | 2024-01-21 | 0 | N00032088 | ["H0OH06189"] | 412460 | 02046 | 120649 | Bill Johnson (Ohio politician) | Bill Johnson (Ohio) | 1954-11-10 | M | 7 | 2024-01-21 | 19 | 207 | 95 | 7487 | 10009264 | ||
| G000563 | Bob | Gibbs | Bob Gibbs | Republican | OH | House | 7 | 2011-01-05 | 2023-01-03 | 0 | N00031128 | ["H0OH18077"] | 412463 | 02049 | 45466 | Bob Gibbs | Bob Gibbs | 1954-06-14 | M | 7 | 2023-01-03 | 177 | 135 | 55 | 6744 | 5858224 | ||
| M000432 | Bob | McEwen | Bob McEwen | Republican | OH | House | 6 | 1981-01-05 | 1993-01-03 | 0 | [] | 407432 | 00768 | Bob McEwen | 1950-01-12 | M | 7 | 1993-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| W000815 | Brad | Wenstrup | Brad R. Wenstrup | Republican | OH | House | 2 | 2013-01-03 | 2025-01-03 | 0 | N00033310 | ["H2OH02085"] | 412564 | 02152 | 135326 | Brad Wenstrup | Brad Wenstrup | 1958-06-17 | M | 7 | 2025-01-03 | 22 | 294 | 107 | 6380 | 4198882 | ||
| H000209 | Byron | Harlan | Byron Harlan | Democrat | OH | House | 3 | 1931-12-07 | 1939-01-03 | 0 | [] | 405088 | Byron B. Harlan | 1886-10-22 | M | 5 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000272 | Byron | Ritchie | Byron Ritchie | Democrat | OH | House | 9 | 1893-08-07 | 1895-03-03 | 0 | [] | 409246 | Byron F. Ritchie | 1853-01-29 | M | 2 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000973 | Calvary | Morris | Calvary Morris | Whig | OH | House | 6 | 1837-09-04 | 1843-03-03 | 0 | [] | 407941 | Calvary Morris | 1798-01-15 | M | 4 | 1843-03-03 | 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 | |||||||
| W000249 | Capell | Weems | Capell Weems | Republican | OH | House | 16 | 1903-11-09 | 1909-03-03 | 0 | [] | 411417 | Capell L. Weems | 1860-07-07 | M | 4 | 1909-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000371 | Carey | Trimble | Carey Trimble | Republican | OH | House | 10 | 1859-12-05 | 1863-03-03 | 0 | [] | 410940 | Carey A. Trimble | 1813-09-13 | M | 3 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| A000182 | Carl | Anderson | Carl Anderson | Democrat | OH | House | 13 | 1909-03-15 | 1913-03-03 | 0 | [] | 400837 | Carl C. Anderson | 1877-12-02 | M | 3 | 1913-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000206 | Carl | Rich | Carl Rich | Republican | OH | House | 1 | 1963-01-09 | 1965-01-03 | 0 | [] | 409182 | Carl West Rich | 1898-09-12 | M | 2 | 1965-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000781 | Chalmers | Wylie | Chalmers Wylie | Republican | OH | House | 15 | 1967-01-10 | 1993-01-03 | 0 | [] | 411929 | 01249 | Chalmers Wylie | 1920-11-23 | M | 14 | 1993-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| A000078 | Charles | Albright | Charles Albright | Ind. Republican-Democrat | OH | House | 17 | 1855-12-03 | 1857-03-03 | 0 | [] | 400737 | Charles J. Albright | 1816-05-09 | M | 2 | 1857-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| A000185 | Charles | Anderson | Charles Anderson | Democrat | OH | House | 4 | 1885-12-07 | 1887-03-03 | 0 | [] | 400840 | Charles Marley Anderson | 1845-01-05 | M | 2 | 1887-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000766 | Charles | Brand | Charles Brand | Republican | OH | House | 7 | 1923-12-03 | 1933-03-03 | 0 | [] | 401725 | Charles Brand (Ohio politician) | 1871-11-01 | M | 6 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000907 | Charles | Brown | Charles Brown | Republican | OH | House | 2 | 1885-12-07 | 1889-03-03 | 0 | [] | 401864 | Charles Elwood Brown | 1834-07-04 | M | 3 | 1889-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000164 | Charles | Carney | Charles Carney | Democrat | OH | House | 19 | 1969-01-03 | 1979-01-03 | 0 | [] | 402312 | 00177 | Charles J. Carney | 1913-04-17 | M | 6 | 1979-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| C000587 | Charles | Coffin | Charles Coffin | Whig | OH | House | 17 | 1837-09-04 | 1839-03-03 | 0 | [] | 402716 | Charles D. Coffin | 1804-09-10 | M | 2 | 1839-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| D000302 | Charles | Dick | Charles Dick | Republican | OH | Senate | 1898-11-08 | 1911-03-03 | 0 | [] | 403424 | Charles W. F. Dick | 1858-11-03 | M | 3 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| E000160 | Charles | Elston | Charles Elston | Republican | OH | House | 1 | 1939-01-03 | 1953-01-03 | 0 | [] | 403851 | Charles H. Elston | 1891-08-01 | M | 8 | 1953-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| F000299 | Charles | Foster | Charles Foster | Republican | OH | House | 10 | 1871-03-04 | 1879-03-03 | 0 | [] | 404248 | Charles Foster (Ohio politician) | 1828-04-12 | M | 5 | 1879-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000497 | Charles | Grosvenor | Charles Grosvenor | Republican | OH | House | 11 | 1885-12-07 | 1907-03-03 | 0 | [] | 404842 | Charles H. Grosvenor | 1833-09-20 | M | 12 | 1907-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000585 | Charles | Hildebrant | Charles Hildebrant | Republican | OH | House | 6 | 1901-12-02 | 1905-03-03 | 0 | [] | 405447 | Charles Q. Hildebrant | 1864-10-17 | M | 3 | 1905-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| K000033 | Charles | Kearns | Charles Kearns | Republican | OH | House | 6 | 1915-12-06 | 1931-03-03 | 0 | [] | 406203 | Charles Cyrus Kearns | 1869-02-11 | M | 9 | 1931-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| K000284 | Charles | Knight | Charles Knight | Republican | OH | House | 14 | 1921-04-11 | 1923-03-03 | 0 | [] | 406441 | C. L. Knight | 1867-06-18 | M | 2 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000039 | Charles | Lamison | Charles Lamison | Democrat | OH | House | 5 | 1871-03-04 | 1875-03-03 | 0 | [] | 406549 | Charles N. Lamison | M | 3 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| L000507 | Charles | Luken | Charles Luken | Democrat | OH | House | 1 | 1991-01-03 | 1993-01-03 | 0 | [] | 406993 | 00714 | Charlie Luken | 1951-07-18 | M | 2 | 1993-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| M000171 | Charles | Martin | Charles Martin | Democrat | OH | House | 11 | 1859-12-05 | 1861-03-03 | 0 | [] | 407193 | Charles D. Martin (politician) | 1829-08-05 | M | 2 | 1861-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000339 | Charles | McClintock | Charles McClintock | Republican | OH | House | 16 | 1929-04-15 | 1933-03-03 | 0 | [] | 407348 | Charles B. McClintock | 1886-05-25 | M | 3 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000887 | Charles | Mooney | Charles Mooney | Democrat | OH | House | 20 | 1919-05-19 | 1933-03-03 | 0 | [] | 407859 | Charles A. Mooney | 1879-01-05 | M | 8 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000894 | Charles | Moore | Charles Moore | Republican | OH | House | 15 | 1919-05-19 | 1933-03-03 | 0 | [] | 407866 | C. Ellis Moore | 1884-01-03 | M | 8 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M001031 | Charles | Mosher | Charles Mosher | Republican | OH | House | 13 | 1961-01-03 | 1977-01-03 | 0 | [] | 407998 | 00837 | Charles Adams Mosher | 1906-05-07 | M | 9 | 1977-01-03 | 1 | 0 | 0 | 0 | 0 | |||||
| S001111 | Charles | Sweetser | Charles Sweetser | Democrat | OH | House | 10 | 1849-12-03 | 1853-03-03 | 0 | [] | 410563 | Charles Sweetser | 1808-01-22 | M | 3 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000007 | Charles | Taft | Charles Taft | Republican | OH | House | 1 | 1895-12-02 | 1897-03-03 | 0 | [] | 410597 | Charles Phelps Taft | 1843-12-21 | M | 2 | 1897-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000049 | Charles | Tatgenhorst | Charles Tatgenhorst | Republican | OH | House | 2 | 1927-12-05 | 1929-03-03 | 0 | [] | 410637 | Charles Tatgenhorst Jr. | 1883-08-19 | M | 2 | 1929-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000194 | Charles | Thompson | Charles Thompson | Republican | OH | House | 5 | 1919-05-19 | 1931-03-03 | 0 | [] | 410773 | Charles J. Thompson | 1862-01-24 | M | 7 | 1931-03-03 | 1 | 0 | 0 | 0 | 0 | ||||||
| T000386 | Charles | Truax | Charles Truax | Democrat | OH | House | 0 | 1933-03-09 | 1935-08-09 | 0 | [] | 410955 | Charles V. Truax | 1887-02-01 | M | 2 | 1935-08-09 | 2 | 0 | 0 | 0 | 0 | ||||||
| V000047 | Charles | Vanik | Charles Vanik | Democrat | OH | House | 22 | 1955-01-05 | 1981-01-03 | 0 | [] | 411126 | 01183 | Charles Vanik | 1913-04-07 | M | 14 | 1981-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| W000301 | Charles | West | Charles West | Democrat | OH | House | 17 | 1931-12-07 | 1935-01-03 | 0 | [] | 411465 | Charles F. West (politician) | 1895-01-12 | M | 3 | 1935-01-03 | 2 | 0 | 0 | 0 | 0 | ||||||
| W000317 | Charles | Whalen | Charles Whalen | Republican | OH | House | 3 | 1967-01-10 | 1979-01-03 | 0 | [] | 411479 | 01217 | Charles W. Whalen Jr. | 1920-07-31 | M | 7 | 1979-01-03 | 8 | 0 | 0 | 0 | 0 | |||||
| W000441 | Charles | Wickham | Charles Wickham | Republican | OH | House | 14 | 1887-12-05 | 1891-03-03 | 0 | [] | 411599 | Charles Preston Wickham | 1836-09-15 | M | 3 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000801 | Charles | Wilson | Charles Wilson | Democrat | OH | House | 6 | 2007-01-04 | 2011-01-03 | 0 | N00003528 | ["H6OH06095"] | 412227 | 01869 | 10092 | Charlie Wilson (Ohio politician) | Charlie Wilson (Former Ohio congressman) | 1943-01-18 | M | 3 | 2011-01-03 | 6 | 97 | 17 | 3456 | 6040229 |
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);