legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
2,257 rows where state = "OH"
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
403 | 403 | William McMillan M000571 | rep | OH | 1799-12-02 | 1801-03-03 | -1 | ||||||||||||||
472 | 472 | Paul Fearing F000054 | rep | OH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
618 | 618 | John Smith S000567 | sen | OH | 1803-10-17 | 1809-03-03 | 1 | Republican | |||||||||||||
903 | 903 | Edward Tiffin T000268 | sen | OH | 1807-10-26 | 1809-12-31 | 3 | Republican | |||||||||||||
931 | 931 | Return Meigs M000633 | sen | OH | 1808-12-12 | 1809-03-03 | 1 | Republican | |||||||||||||
932 | 932 | Return Meigs M000633 | sen | OH | 1809-03-04 | 1810-12-08 | 1 | Republican | |||||||||||||
952 | 952 | Alexander Campbell C000076 | sen | OH | 1809-05-22 | 1813-03-03 | 3 | Republican | |||||||||||||
975 | 975 | Stanley Griswold G000489 | sen | OH | 1809-05-22 | 1809-12-31 | 3 | Republican | |||||||||||||
1094 | 1094 | Thomas Worthington W000750 | sen | OH | 1803-10-17 | 1807-03-03 | 3 | Republican | |||||||||||||
1095 | 1095 | Thomas Worthington W000750 | sen | OH | 1810-01-01 | 1815-03-03 | 1 | Republican | |||||||||||||
1275 | 1275 | Reasin Beall B000273 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1436 | 1436 | Joseph Kerr K000141 | sen | OH | 1814-01-01 | 1815-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
1482 | 1482 | James Caldwell C000033 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1483 | 1483 | James Caldwell C000033 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1511 | 1511 | David Clendenin C000510 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1512 | 1512 | David Clendenin C000510 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1631 | 1631 | James Kilbourne K000169 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1632 | 1632 | James Kilbourne K000169 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
1664 | 1664 | John McLean M000549 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1665 | 1665 | John McLean M000549 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1858 | 1858 | Peter Hitchcock H000647 | rep | OH | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
1979 | 1979 | Henry Brush B000983 | rep | OH | 1819-12-06 | 1821-03-03 | Republican | 3 | |||||||||||||
2034 | 2034 | Samuel Herrick H000542 | rep | OH | 1817-12-01 | 1819-03-03 | Republican | 4 | |||||||||||||
2035 | 2035 | Samuel Herrick H000542 | rep | OH | 1819-12-06 | 1821-03-03 | Republican | 4 | |||||||||||||
2163 | 2163 | William Trimble T000377 | sen | OH | 1819-12-06 | 1821-12-31 | 3 | Republican | |||||||||||||
2191 | 2191 | Levi Barber B000124 | rep | OH | 1817-12-01 | 1819-03-03 | Republican | 3 | |||||||||||||
2192 | 2192 | Levi Barber B000124 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2219 | 2219 | David Chambers C000281 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2359 | 2359 | Ethan Brown B000914 | sen | OH | 1822-01-01 | 1825-03-03 | 3 | Republican | |||||||||||||
2420 | 2420 | James Gazlay G000109 | rep | OH | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2448 | 2448 | Duncan McArthur M000299 | rep | OH | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
2449 | 2449 | Duncan McArthur M000299 | rep | OH | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2456 | 2456 | John Patterson P000122 | rep | OH | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2480 | 2480 | Thomas Ross R000456 | rep | OH | 1819-12-06 | 1821-03-03 | Republican | 1 | |||||||||||||
2481 | 2481 | Thomas Ross R000456 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2482 | 2482 | Thomas Ross R000456 | rep | OH | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2565 | 2565 | John Campbell C000095 | rep | OH | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
2566 | 2566 | John Campbell C000095 | rep | OH | 1819-12-06 | 1821-03-03 | Republican | 2 | |||||||||||||
2567 | 2567 | John Campbell C000095 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2568 | 2568 | John Campbell C000095 | rep | OH | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
2569 | 2569 | John Campbell C000095 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 5 | |||||||||||||
2640 | 2640 | David Jennings J000095 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 10 | |||||||||||||
2720 | 2720 | Thomas Shannon S000289 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 10 | |||||||||||||
2792 | 2792 | Philemon Beecher B000306 | rep | OH | 1817-12-01 | 1819-03-03 | Republican | 5 | |||||||||||||
2793 | 2793 | Philemon Beecher B000306 | rep | OH | 1819-12-06 | 1821-03-03 | Republican | 5 | |||||||||||||
2794 | 2794 | Philemon Beecher B000306 | rep | OH | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2795 | 2795 | Philemon Beecher B000306 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 9 | |||||||||||||
2796 | 2796 | Philemon Beecher B000306 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 9 | |||||||||||||
2829 | 2829 | John Davenport D000076 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 10 | |||||||||||||
2900 | 2900 | William McLean M000552 | rep | OH | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2901 | 2901 | William McLean M000552 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 3 | |||||||||||||
2902 | 2902 | William McLean M000552 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 3 | |||||||||||||
2914 | 2914 | Francis Muhlenberg M001061 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 6 | |||||||||||||
2938 | 2938 | Benjamin Ruggles R000500 | sen | OH | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2939 | 2939 | Benjamin Ruggles R000500 | sen | OH | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2940 | 2940 | Benjamin Ruggles R000500 | sen | OH | 1827-12-03 | 1833-03-03 | 1 | Adams | |||||||||||||
2952 | 2952 | John Sloane S000494 | rep | OH | 1819-12-06 | 1821-03-03 | Republican | 6 | |||||||||||||
2953 | 2953 | John Sloane S000494 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2954 | 2954 | John Sloane S000494 | rep | OH | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2955 | 2955 | John Sloane S000494 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 12 | |||||||||||||
2956 | 2956 | John Sloane S000494 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 12 | |||||||||||||
2998 | 2998 | William Wilson W000619 | rep | OH | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
2999 | 2999 | William Wilson W000619 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 8 | |||||||||||||
3000 | 3000 | William Wilson W000619 | rep | OH | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
3009 | 3009 | John Woods W000724 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 2 | |||||||||||||
3010 | 3010 | John Woods W000724 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 2 | |||||||||||||
3011 | 3011 | John Wright W000764 | rep | OH | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
3012 | 3012 | John Wright W000764 | rep | OH | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
3013 | 3013 | John Wright W000764 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 11 | |||||||||||||
3014 | 3014 | John Wright W000764 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 11 | |||||||||||||
3017 | 3017 | Jacob Burnet B001117 | sen | OH | 1828-01-01 | 1831-03-03 | 3 | Adams | |||||||||||||
3047 | 3047 | Mordecai Bartley B000210 | rep | OH | 1823-12-01 | 1825-03-03 | 14 | ||||||||||||||
3048 | 3048 | Mordecai Bartley B000210 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 14 | |||||||||||||
3049 | 3049 | Mordecai Bartley B000210 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 14 | |||||||||||||
3050 | 3050 | Mordecai Bartley B000210 | rep | OH | 1829-12-07 | 1831-03-03 | 14 | ||||||||||||||
3107 | 3107 | John Goodenow G000283 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3203 | 3203 | James Shields S000361 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3349 | 3349 | Eleutheros Cooke C000732 | rep | OH | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 14 | |||||||||||||
3354 | 3354 | William Creighton C000902 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
3355 | 3355 | William Creighton C000902 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
3356 | 3356 | William Creighton C000902 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 6 | |||||||||||||
3357 | 3357 | William Creighton C000902 | rep | OH | 1829-12-07 | 1831-03-03 | Republican | 6 | |||||||||||||
3358 | 3358 | William Creighton C000902 | rep | OH | 1831-12-05 | 1833-03-03 | Republican | 6 | |||||||||||||
3376 | 3376 | James Findlay F000119 | rep | OH | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
3377 | 3377 | James Findlay F000119 | rep | OH | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3378 | 3378 | James Findlay F000119 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3379 | 3379 | James Findlay F000119 | rep | OH | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
3428 | 3428 | William Irvin I000034 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3429 | 3429 | William Irvin I000034 | rep | OH | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
3547 | 3547 | William Stanbery S000788 | rep | OH | 1827-12-03 | 1829-03-03 | Jackson | 8 | |||||||||||||
3548 | 3548 | William Stanbery S000788 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3549 | 3549 | William Stanbery S000788 | rep | OH | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 8 | |||||||||||||
3613 | 3613 | James Bell B000338 | rep | OH | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 11 | |||||||||||||
3720 | 3720 | Humphrey Leavitt L000183 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3721 | 3721 | Humphrey Leavitt L000183 | rep | OH | 1831-12-05 | 1833-03-03 | Jackson | 11 | |||||||||||||
3722 | 3722 | Humphrey Leavitt L000183 | rep | OH | 1833-12-02 | 1835-03-03 | Jackson | 19 | |||||||||||||
3734 | 3734 | Robert Lytle L000546 | rep | OH | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3757 | 3757 | Robert Mitchell M000827 | rep | OH | 1833-12-02 | 1835-03-03 | Jackson | 12 |
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);