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, trade_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 | fec_ids | thomas_id | lis_id | birthday | gender | terms_count | served_until | trade_count | speech_count | bills_sponsored | vote_count | fec_total_received | fec_ie_for | fec_ie_against |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| H000207 | Aaron | Harlan | Aaron Harlan | Republican | OH | House | 7 | 1853-12-05 | 1859-03-03 | 0 | [] | 1802-09-08 | M | 4 | 1859-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| P000241 | Aaron | Perry | Aaron Perry | Republican | OH | House | 1 | 1871-03-04 | 1873-03-03 | 0 | [] | 1815-01-01 | M | 2 | 1873-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000344 | Addison | McClure | Addison McClure | Republican | OH | House | 17 | 1881-12-05 | 1897-03-03 | 0 | [] | 1839-10-10 | M | 9 | 1897-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| J000113 | Adna | Johnson | Adna Johnson | Republican | OH | House | 10 | 1909-03-15 | 1911-03-03 | 0 | [] | 1860-12-14 | M | 2 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000151 | Adoniram | Warner | Adoniram Warner | Democrat | OH | House | 17 | 1879-03-18 | 1887-03-03 | 0 | [] | 1834-01-13 | M | 5 | 1887-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000245 | Albert | Baumhart | Albert Baumhart | Republican | OH | House | 13 | 1941-01-03 | 1961-01-03 | 0 | [] | 1908-06-15 | M | 11 | 1961-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000449 | Albert | Douglas | Albert Douglas | Republican | OH | House | 11 | 1907-12-02 | 1911-03-03 | 0 | [] | 1852-04-25 | M | 3 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| P000164 | Albert | Pearson | Albert Pearson | Democrat | OH | House | 16 | 1891-12-07 | 1895-03-03 | 0 | [] | 1846-05-20 | M | 3 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000238 | Albert | Riddle | Albert Riddle | Republican | OH | House | 19 | 1861-07-04 | 1863-03-03 | 0 | [] | 1816-05-28 | M | 2 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000191 | Albert | Thompson | Albert Thompson | Republican | OH | House | 11 | 1885-12-07 | 1891-03-03 | 0 | [] | 1842-01-23 | M | 4 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000076 | Alexander | Campbell | Alexander Campbell | Republican | OH | Senate | 1809-05-22 | 1813-03-03 | 0 | [] | M | 1 | 1813-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
| D000528 | Alexander | Duncan | Alexander Duncan | Democrat | OH | House | 1 | 1837-09-04 | 1845-03-03 | 0 | [] | M | 5 | 1845-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| H000219 | Alexander | Harper | Alexander Harper | Whig | OH | House | 14 | 1837-09-04 | 1853-03-03 | 0 | [] | 1786-02-05 | M | 9 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| L000410 | Alexander | Long | Alexander Long | Democrat | OH | House | 2 | 1863-12-07 | 1865-03-03 | 0 | [] | 1816-12-24 | M | 2 | 1865-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| A000111 | Alfred | Allen | Alfred Allen | Democrat | OH | House | 2 | 1911-04-04 | 1917-03-03 | 0 | [] | 1867-07-23 | M | 4 | 1917-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| E000045 | Alfred | Edgerton | Alfred Edgerton | Democrat | OH | House | 5 | 1851-12-01 | 1855-03-03 | 0 | [] | 1813-01-11 | M | 3 | 1855-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000952 | Alfred | Stone | Alfred Stone | Democrat | OH | House | 10 | 1843-12-04 | 1845-03-03 | 0 | [] | 1813-06-28 | M | 2 | 1845-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000251 | Allen | Thurman | Allen Thurman | Democrat | OH | Senate | 1845-12-01 | 1881-03-03 | 0 | [] | 1813-11-13 | M | 7 | 1881-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| H000282 | Alphonso | Hart | Alphonso Hart | Republican | OH | House | 12 | 1883-12-03 | 1885-03-03 | 0 | [] | 1830-07-04 | M | 2 | 1885-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000410 | Alvin | Donahey | Alvin Donahey | Democrat | OH | Senate | 1935-01-03 | 1941-01-03 | 0 | [] | 1873-07-07 | M | 2 | 1941-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| W000252 | Alvin | Weichel | Alvin Weichel | Republican | OH | House | 13 | 1943-01-06 | 1955-01-03 | 0 | [] | 1891-09-11 | M | 7 | 1955-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000855 | Ambrose | Stephens | Ambrose Stephens | Republican | OH | House | -1 | 1919-05-19 | 1929-03-03 | 0 | [] | 1862-06-03 | M | 6 | 1929-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000194 | Americus | Rice | Americus Rice | Democrat | OH | House | 5 | 1875-12-06 | 1879-03-03 | 0 | [] | 1835-11-18 | M | 3 | 1879-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| J000004 | Amos | Jackson | Amos Jackson | Republican | OH | House | 13 | 1903-11-09 | 1905-03-03 | 0 | [] | 1846-05-10 | M | 2 | 1905-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000328 | Amos | Townsend | Amos Townsend | Republican | OH | House | 20 | 1877-10-15 | 1883-03-03 | 0 | [] | M | 4 | 1883-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| W000233 | Amos | Webber | Amos Webber | Republican | OH | House | 14 | 1903-11-09 | 1907-03-03 | 0 | [] | 1852-01-21 | M | 3 | 1907-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000689 | Amos | Wood | Amos Wood | Democrat | OH | House | 6 | 1849-12-03 | 1851-03-03 | 0 | [] | 1810-01-02 | M | 2 | 1851-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| E000140 | Andrew | Ellison | Andrew Ellison | Democrat | OH | House | 6 | 1853-12-05 | 1855-03-03 | 0 | [] | M | 2 | 1855-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| L000436 | Andrew | Loomis | Andrew Loomis | Whig | OH | House | 17 | 1837-09-04 | 1839-03-03 | 0 | [] | 1797-06-27 | M | 2 | 1839-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S001031 | Andrew | Stuart | Andrew Stuart | Democrat | OH | House | 21 | 1853-12-05 | 1855-03-03 | 0 | [] | 1823-08-03 | M | 2 | 1855-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000091 | Ansel | Walling | Ansel Walling | Democrat | OH | House | 12 | 1875-12-06 | 1877-03-03 | 0 | [] | 1824-01-10 | M | 2 | 1877-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| F000195 | Anthony | Fleger | Anthony Fleger | Democrat | OH | House | 22 | 1937-01-05 | 1939-01-03 | 0 | [] | 1900-10-21 | M | 2 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| G000588 | Anthony | Gonzalez | Anthony Gonzalez | Republican | OH | House | 16 | 2019-01-03 | 2023-01-03 | 0 | ["H8OH16124"] | 1984-09-18 | M | 3 | 2023-01-03 | 13 | 51 | 36 | 1952 | 2246592 | 359942 | 27083 | |||
| L000523 | Archibald | Lybrand | Archibald Lybrand | Republican | OH | House | 8 | 1897-03-15 | 1901-03-03 | 0 | [] | 1840-05-23 | M | 3 | 1901-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| A000088 | Arthur | Aleshire | Arthur Aleshire | Democrat | OH | House | 7 | 1937-01-05 | 1939-01-03 | 0 | [] | 1900-02-15 | M | 2 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| L000040 | Arthur | Lamneck | Arthur Lamneck | Democrat | OH | House | 12 | 1931-12-07 | 1939-01-03 | 0 | [] | 1880-03-12 | M | 5 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| O000141 | Arthur | Overmyer | Arthur Overmyer | Democrat | OH | House | 13 | 1915-12-06 | 1919-03-03 | 0 | [] | 1879-05-31 | M | 3 | 1919-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| P000420 | Atlee | Pomerene | Atlee Pomerene | Democrat | OH | Senate | 1911-04-04 | 1923-03-03 | 0 | [] | 1863-12-06 | M | 3 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| P000240 | Augustus | Perrill | Augustus Perrill | Democrat | OH | House | 9 | 1845-12-01 | 1847-03-03 | 0 | [] | 1807-01-20 | M | 2 | 1847-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000971 | Bellamy | Storer | Bellamy Storer | Whig | OH | House | 1 | 1835-12-07 | 1837-03-03 | 0 | [] | 1796-03-26 | M | 2 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000970 | Bellamy | Storer | Bellamy Storer | Republican | OH | House | 1 | 1891-12-07 | 1895-03-03 | 0 | [] | 1847-08-28 | M | 3 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000146 | Beman | Dawes | Beman Dawes | Republican | OH | House | 15 | 1905-12-04 | 1909-03-03 | 0 | [] | 1870-01-14 | M | 3 | 1909-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B001200 | Benjamin | Butterworth | Benjamin Butterworth | Republican | OH | House | 1 | 1879-03-18 | 1891-03-03 | 0 | [] | 1837-10-22 | M | 7 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000821 | Benjamin | Cowen | Benjamin Cowen | Whig | OH | House | 11 | 1841-05-31 | 1843-03-03 | 0 | [] | 1793-09-27 | M | 2 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| E000090 | Benjamin | Eggleston | Benjamin Eggleston | Republican | OH | House | 1 | 1865-12-04 | 1869-03-03 | 0 | [] | 1816-01-03 | M | 3 | 1869-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| J000212 | Benjamin | Jones | Benjamin Jones | Jackson | OH | House | 18 | 1833-12-02 | 1837-03-03 | 0 | [] | 1787-04-13 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| L000159 | Benjamin | Le Fevre | Benjamin Le Fevre | Democrat | OH | House | 5 | 1879-03-18 | 1887-03-03 | 0 | [] | 1838-10-08 | M | 5 | 1887-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| L000236 | Benjamin | Leiter | Benjamin Leiter | Republican | OH | House | 18 | 1855-12-03 | 1859-03-03 | 0 | [] | 1813-10-13 | M | 3 | 1859-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M001089 | Benjamin | Murphy | Benjamin Murphy | Republican | OH | House | 18 | 1919-05-19 | 1933-03-03 | 0 | [] | 1867-12-24 | M | 8 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000500 | Benjamin | Ruggles | Benjamin Ruggles | Adams | OH | Senate | 1815-12-04 | 1833-03-03 | 0 | [] | 1783-02-21 | M | 4 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| S000801 | Benjamin | Stanton | Benjamin Stanton | Republican | OH | House | 8 | 1851-12-01 | 1861-03-03 | 0 | [] | 1809-06-04 | M | 6 | 1861-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000039 | Benjamin | Tappan | Benjamin Tappan | Democrat | OH | Senate | 1839-12-02 | 1845-03-03 | 0 | [] | 1773-05-25 | M | 2 | 1845-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| W000005 | Benjamin | Wade | Benjamin Wade | Republican | OH | Senate | 1851-12-01 | 1869-03-03 | 0 | [] | 1800-10-27 | M | 4 | 1869-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| W000291 | Benjamin | Welty | Benjamin Welty | Democrat | OH | House | 4 | 1917-04-02 | 1921-03-03 | 0 | [] | 1870-08-09 | M | 3 | 1921-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000474 | Beriah | Wilkins | Beriah Wilkins | Democrat | OH | House | 16 | 1883-12-03 | 1889-03-03 | 0 | [] | 1846-07-10 | M | 4 | 1889-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M001242 | Bernie | Moreno | Bernie Moreno | Republican | OH | Senate | 2025-01-03 | 2031-01-03 | 1 | ["S4OH00192"] | S434 | 1967-02-14 | M | 2 | 9 | 126 | 26 | 876 | 1320290 | 70090551 | 85644042 | ||||
| S001174 | Betty | Sutton | Betty Sutton | Democrat | OH | House | 13 | 2007-01-04 | 2013-01-03 | 0 | ["H6OH13133"] | 01870 | 1963-07-31 | F | 4 | 2013-01-03 | 0 | 239 | 57 | 5137 | 1947297 | 292299 | 4539823 | ||
| J000292 | Bill | Johnson | Bill Johnson | Republican | OH | House | 6 | 2011-01-05 | 2024-01-21 | 0 | ["H0OH06189"] | 02046 | 1954-11-10 | M | 7 | 2024-01-21 | 1 | 207 | 95 | 8040 | 6305035 | 116238 | 3449460 | ||
| G000563 | Bob | Gibbs | Bob Gibbs | Republican | OH | House | 7 | 2011-01-05 | 2023-01-03 | 0 | ["H0OH18077"] | 02049 | 1954-06-14 | M | 7 | 2023-01-03 | 139 | 135 | 55 | 7297 | 3925292 | 42772 | 1755447 | ||
| M000432 | Bob | McEwen | Bob McEwen | Republican | OH | House | 6 | 1981-01-05 | 1993-01-03 | 0 | [] | 00768 | 1950-01-12 | M | 7 | 1993-01-03 | 0 | 0 | 176 | 0 | 0 | 0 | 0 | ||
| W000815 | Brad | Wenstrup | Brad R. Wenstrup | Republican | OH | House | 2 | 2013-01-03 | 2025-01-03 | 0 | ["H2OH02085"] | 02152 | 1958-06-17 | M | 7 | 2025-01-03 | 0 | 294 | 107 | 6932 | 4164300 | 6261 | 861 | ||
| H000209 | Byron | Harlan | Byron Harlan | Democrat | OH | House | 3 | 1931-12-07 | 1939-01-03 | 0 | [] | 1886-10-22 | M | 5 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000272 | Byron | Ritchie | Byron Ritchie | Democrat | OH | House | 9 | 1893-08-07 | 1895-03-03 | 0 | [] | 1853-01-29 | M | 2 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000973 | Calvary | Morris | Calvary Morris | Whig | OH | House | 6 | 1837-09-04 | 1843-03-03 | 0 | [] | 1798-01-15 | M | 4 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000818 | Calvin | Brice | Calvin Brice | Democrat | OH | Senate | 1891-12-07 | 1897-03-03 | 0 | [] | 1845-09-17 | M | 2 | 1897-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| W000249 | Capell | Weems | Capell Weems | Republican | OH | House | 16 | 1903-11-09 | 1909-03-03 | 0 | [] | 1860-07-07 | M | 4 | 1909-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000371 | Carey | Trimble | Carey Trimble | Republican | OH | House | 10 | 1859-12-05 | 1863-03-03 | 0 | [] | 1813-09-13 | M | 3 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| A000182 | Carl | Anderson | Carl Anderson | Democrat | OH | House | 13 | 1909-03-15 | 1913-03-03 | 0 | [] | 1877-12-02 | M | 3 | 1913-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000206 | Carl | Rich | Carl Rich | Republican | OH | House | 1 | 1963-01-09 | 1965-01-03 | 0 | [] | 1898-09-12 | M | 2 | 1965-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000781 | Chalmers | Wylie | Chalmers Wylie | Republican | OH | House | 15 | 1967-01-10 | 1993-01-03 | 0 | [] | 01249 | 1920-11-23 | M | 14 | 1993-01-03 | 0 | 0 | 161 | 0 | 0 | 0 | 0 | ||
| A000078 | Charles | Albright | Charles Albright | Ind. Republican-Democrat | OH | House | 17 | 1855-12-03 | 1857-03-03 | 0 | [] | 1816-05-09 | M | 2 | 1857-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| A000185 | Charles | Anderson | Charles Anderson | Democrat | OH | House | 4 | 1885-12-07 | 1887-03-03 | 0 | [] | 1845-01-05 | M | 2 | 1887-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000766 | Charles | Brand | Charles Brand | Republican | OH | House | 7 | 1923-12-03 | 1933-03-03 | 0 | [] | 1871-11-01 | M | 6 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000907 | Charles | Brown | Charles Brown | Republican | OH | House | 2 | 1885-12-07 | 1889-03-03 | 0 | [] | 1834-07-04 | M | 3 | 1889-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000164 | Charles | Carney | Charles Carney | Democrat | OH | House | 19 | 1969-01-03 | 1979-01-03 | 0 | [] | 00177 | 1913-04-17 | M | 6 | 1979-01-03 | 0 | 0 | 217 | 0 | 0 | 0 | 0 | ||
| C000587 | Charles | Coffin | Charles Coffin | Whig | OH | House | 17 | 1837-09-04 | 1839-03-03 | 0 | [] | 1804-09-10 | M | 2 | 1839-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000302 | Charles | Dick | Charles Dick | Republican | OH | Senate | 1898-11-08 | 1911-03-03 | 0 | [] | 1858-11-03 | M | 3 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| E000160 | Charles | Elston | Charles Elston | Republican | OH | House | 1 | 1939-01-03 | 1953-01-03 | 0 | [] | 1891-08-01 | M | 8 | 1953-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| F000299 | Charles | Foster | Charles Foster | Republican | OH | House | 10 | 1871-03-04 | 1879-03-03 | 0 | [] | 1828-04-12 | M | 5 | 1879-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| G000497 | Charles | Grosvenor | Charles Grosvenor | Republican | OH | House | 11 | 1885-12-07 | 1907-03-03 | 0 | [] | 1833-09-20 | M | 12 | 1907-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000585 | Charles | Hildebrant | Charles Hildebrant | Republican | OH | House | 6 | 1901-12-02 | 1905-03-03 | 0 | [] | 1864-10-17 | M | 3 | 1905-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| K000033 | Charles | Kearns | Charles Kearns | Republican | OH | House | 6 | 1915-12-06 | 1931-03-03 | 0 | [] | 1869-02-11 | M | 9 | 1931-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| K000284 | Charles | Knight | Charles Knight | Republican | OH | House | 14 | 1921-04-11 | 1923-03-03 | 0 | [] | 1867-06-18 | M | 2 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| L000039 | Charles | Lamison | Charles Lamison | Democrat | OH | House | 5 | 1871-03-04 | 1875-03-03 | 0 | [] | M | 3 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| L000507 | Charles | Luken | Charles Luken | Democrat | OH | House | 1 | 1991-01-03 | 1993-01-03 | 0 | [] | 00714 | 1951-07-18 | M | 2 | 1993-01-03 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | ||
| M000171 | Charles | Martin | Charles Martin | Democrat | OH | House | 11 | 1859-12-05 | 1861-03-03 | 0 | [] | 1829-08-05 | M | 2 | 1861-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000339 | Charles | McClintock | Charles McClintock | Republican | OH | House | 16 | 1929-04-15 | 1933-03-03 | 0 | [] | 1886-05-25 | M | 3 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000887 | Charles | Mooney | Charles Mooney | Democrat | OH | House | 20 | 1919-05-19 | 1933-03-03 | 0 | [] | 1879-01-05 | M | 8 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000894 | Charles | Moore | Charles Moore | Republican | OH | House | 15 | 1919-05-19 | 1933-03-03 | 0 | [] | 1884-01-03 | M | 8 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M001031 | Charles | Mosher | Charles Mosher | Republican | OH | House | 13 | 1961-01-03 | 1977-01-03 | 0 | [] | 00837 | 1906-05-07 | M | 9 | 1977-01-03 | 0 | 0 | 43 | 0 | 0 | 0 | 0 | ||
| S001111 | Charles | Sweetser | Charles Sweetser | Democrat | OH | House | 10 | 1849-12-03 | 1853-03-03 | 0 | [] | 1808-01-22 | M | 3 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000007 | Charles | Taft | Charles Taft | Republican | OH | House | 1 | 1895-12-02 | 1897-03-03 | 0 | [] | 1843-12-21 | M | 2 | 1897-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000049 | Charles | Tatgenhorst | Charles Tatgenhorst | Republican | OH | House | 2 | 1927-12-05 | 1929-03-03 | 0 | [] | 1883-08-19 | M | 2 | 1929-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000194 | Charles | Thompson | Charles Thompson | Republican | OH | House | 5 | 1919-05-19 | 1931-03-03 | 0 | [] | 1862-01-24 | M | 7 | 1931-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000386 | Charles | Truax | Charles Truax | Democrat | OH | House | 0 | 1933-03-09 | 1935-08-09 | 0 | [] | 1887-02-01 | M | 2 | 1935-08-09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| V000047 | Charles | Vanik | Charles Vanik | Democrat | OH | House | 22 | 1955-01-05 | 1981-01-03 | 0 | [] | 01183 | 1913-04-07 | M | 14 | 1981-01-03 | 0 | 0 | 192 | 0 | 0 | 0 | 0 | ||
| W000301 | Charles | West | Charles West | Democrat | OH | House | 17 | 1931-12-07 | 1935-01-03 | 0 | [] | 1895-01-12 | M | 3 | 1935-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000317 | Charles | Whalen | Charles Whalen | Republican | OH | House | 3 | 1967-01-10 | 1979-01-03 | 0 | [] | 01217 | 1920-07-31 | M | 7 | 1979-01-03 | 0 | 0 | 203 | 0 | 0 | 0 | 0 | ||
| W000441 | Charles | Wickham | Charles Wickham | Republican | OH | House | 14 | 1887-12-05 | 1891-03-03 | 0 | [] | 1836-09-15 | M | 3 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000801 | Charles | Wilson | Charles Wilson | Democrat | OH | House | 6 | 2007-01-04 | 2011-01-03 | 0 | ["H6OH06095"] | 01869 | 1943-01-18 | M | 3 | 2011-01-03 | 0 | 97 | 17 | 3531 | 1179159 | 259490 | 4386851 |
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,
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, fec_ie_for INTEGER DEFAULT 0, fec_ie_against 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);