legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
2,257 rows where state = "OH" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, state_rank, start (date), end (date)
party >10 ✖
- Republican 1,208
- Democrat 805
- Whig 112
- Jackson 41
- Adams 29
- Ind. Republican-Democrat 22
- Anti Jacksonian 7
- Free Soil 6
- Anti Masonic 3
- Independent 2
- …
Link | rowid | legislator_id ▼ | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27602 | 27602 | Homer Abele A000011 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
22020 | 22020 | Walter Albaugh A000072 | rep | OH | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
6754 | 6754 | Charles Albright A000078 | rep | OH | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 17 | |||||||||||||
22021 | 22021 | Arthur Aleshire A000088 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
4125 | 4125 | James Alexander A000095 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
1448 | 1448 | John Alexander A000096 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1449 | 1449 | John Alexander A000096 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
16676 | 16676 | Alfred Allen A000111 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
16677 | 16677 | Alfred Allen A000111 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16678 | 16678 | Alfred Allen A000111 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
4391 | 4391 | John Allen A000135 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 15 | |||||||||||||
4392 | 4392 | John Allen A000135 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 15 | |||||||||||||
7652 | 7652 | William Allen A000149 | rep | OH | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7653 | 7653 | William Allen A000149 | rep | OH | 1861-07-04 | 1863-03-03 | Democrat | 4 | |||||||||||||
5112 | 5112 | William Allen A000150 | rep | OH | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
5113 | 5113 | William Allen A000150 | sen | OH | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5114 | 5114 | William Allen A000150 | sen | OH | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
8800 | 8800 | Jacob Ambler A000169 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 17 | |||||||||||||
8801 | 8801 | Jacob Ambler A000169 | rep | OH | 1871-03-04 | 1873-03-03 | Republican | 17 | |||||||||||||
15837 | 15837 | Carl Anderson A000182 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 13 | |||||||||||||
15838 | 15838 | Carl Anderson A000182 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 13 | |||||||||||||
10958 | 10958 | Charles Anderson A000185 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
35099 | 35099 | Douglas Applegate A000214 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
35100 | 35100 | Douglas Applegate A000214 | rep | OH | 1979-01-15 | 1981-01-03 | Democrat | 18 | |||||||||||||
35101 | 35101 | Douglas Applegate A000214 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 18 | |||||||||||||
35102 | 35102 | Douglas Applegate A000214 | rep | OH | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
35103 | 35103 | Douglas Applegate A000214 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 18 | |||||||||||||
35104 | 35104 | Douglas Applegate A000214 | rep | OH | 1987-01-06 | 1989-01-03 | Democrat | 18 | |||||||||||||
35105 | 35105 | Douglas Applegate A000214 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 18 | |||||||||||||
35106 | 35106 | Douglas Applegate A000214 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 18 | |||||||||||||
35107 | 35107 | Douglas Applegate A000214 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 18 | |||||||||||||
32445 | 32445 | Jean Ashbrook A000220 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 17 | |||||||||||||
32446 | 32446 | John Ashbrook A000221 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 17 | |||||||||||||
32447 | 32447 | John Ashbrook A000221 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 17 | |||||||||||||
32448 | 32448 | John Ashbrook A000221 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
32449 | 32449 | John Ashbrook A000221 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 17 | |||||||||||||
32450 | 32450 | John Ashbrook A000221 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 17 | |||||||||||||
32451 | 32451 | John Ashbrook A000221 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 17 | |||||||||||||
32452 | 32452 | John Ashbrook A000221 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 17 | |||||||||||||
32453 | 32453 | John Ashbrook A000221 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 17 | |||||||||||||
32454 | 32454 | John Ashbrook A000221 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 17 | |||||||||||||
32455 | 32455 | John Ashbrook A000221 | rep | OH | 1979-01-15 | 1981-01-03 | Republican | 17 | |||||||||||||
32456 | 32456 | John Ashbrook A000221 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 17 | |||||||||||||
31930 | 31930 | Thomas Ashley A000222 | rep | OH | 1955-01-05 | 1957-01-03 | Democrat | 9 | |||||||||||||
31931 | 31931 | Thomas Ashley A000222 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
31932 | 31932 | Thomas Ashley A000222 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
31933 | 31933 | Thomas Ashley A000222 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
31934 | 31934 | Thomas Ashley A000222 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
31935 | 31935 | Thomas Ashley A000222 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
31936 | 31936 | Thomas Ashley A000222 | rep | OH | 1967-01-10 | 1969-01-03 | Democrat | 9 | |||||||||||||
31937 | 31937 | Thomas Ashley A000222 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
31938 | 31938 | Thomas Ashley A000222 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31939 | 31939 | Thomas Ashley A000222 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
31940 | 31940 | Thomas Ashley A000222 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 9 | |||||||||||||
31941 | 31941 | Thomas Ashley A000222 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
31942 | 31942 | Thomas Ashley A000222 | rep | OH | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
29119 | 29119 | William Ayres A000229 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
29120 | 29120 | William Ayres A000229 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 14 | |||||||||||||
29121 | 29121 | William Ayres A000229 | rep | OH | 1955-01-05 | 1957-01-03 | Republican | 14 | |||||||||||||
29122 | 29122 | William Ayres A000229 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 14 | |||||||||||||
29123 | 29123 | William Ayres A000229 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 14 | |||||||||||||
29124 | 29124 | William Ayres A000229 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 14 | |||||||||||||
29125 | 29125 | William Ayres A000229 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 14 | |||||||||||||
29126 | 29126 | William Ayres A000229 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 14 | |||||||||||||
29127 | 29127 | William Ayres A000229 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 14 | |||||||||||||
29128 | 29128 | William Ayres A000229 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 14 | |||||||||||||
4664 | 4664 | Sherlock Andrews A000249 | rep | OH | 1841-05-31 | 1843-03-03 | Whig | 15 | |||||||||||||
16251 | 16251 | Timothy Ansberry A000259 | rep | OH | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
16252 | 16252 | Timothy Ansberry A000259 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
16253 | 16253 | Timothy Ansberry A000259 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
16254 | 16254 | Timothy Ansberry A000259 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
22476 | 22476 | William Ashbrook A000306 | rep | OH | 1907-12-02 | 1909-03-03 | Democrat | 17 | |||||||||||||
22477 | 22477 | William Ashbrook A000306 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 17 | |||||||||||||
22478 | 22478 | William Ashbrook A000306 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 17 | |||||||||||||
22479 | 22479 | William Ashbrook A000306 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
22480 | 22480 | William Ashbrook A000306 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 17 | |||||||||||||
22481 | 22481 | William Ashbrook A000306 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 17 | |||||||||||||
22482 | 22482 | William Ashbrook A000306 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
22483 | 22483 | William Ashbrook A000306 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22484 | 22484 | William Ashbrook A000306 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22485 | 22485 | William Ashbrook A000306 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
8252 | 8252 | James Ashley A000314 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
8253 | 8253 | James Ashley A000314 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 5 | |||||||||||||
8254 | 8254 | James Ashley A000314 | rep | OH | 1863-12-07 | 1865-03-03 | Republican | 10 | |||||||||||||
8255 | 8255 | James Ashley A000314 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 10 | |||||||||||||
8256 | 8256 | James Ashley A000314 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 10 | |||||||||||||
10256 | 10256 | Gibson Atherton A000325 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 14 | |||||||||||||
10257 | 10257 | Gibson Atherton A000325 | rep | OH | 1881-12-05 | 1883-03-03 | Democrat | 13 | |||||||||||||
39109 | 39109 | Steve Austria A000365 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 7 | http://austria.house.gov | ||||||||||||
39110 | 39110 | Steve Austria A000365 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 7 | http://austria.house.gov | 439 Cannon HOB; Washington DC 20515-3507 | 202-225-4324 | 202-225-1984 | https://forms.house.gov/austria/contact-form.shtml | 439 Cannon House Office Building | |||||||
17540 | 17540 | John Babka B000007 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 21 | |||||||||||||
14238 | 14238 | De Badger B000021 | rep | OH | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
19573 | 19573 | Joseph Baird B000054 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
6758 | 6758 | Edward Ball B000098 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 16 | |||||||||||||
6759 | 6759 | Edward Ball B000098 | rep | OH | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 16 | |||||||||||||
9736 | 9736 | Henry Banning B000117 | rep | OH | 1873-12-01 | 1875-03-03 | Liberal Republican | 2 | |||||||||||||
9737 | 9737 | Henry Banning B000117 | rep | OH | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9738 | 9738 | Henry Banning B000117 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
14976 | 14976 | Henry Bannon B000118 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
14977 | 14977 | Henry Bannon B000118 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 10 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);