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 party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
403 | 403 | William McMillan M000571 | rep | OH | 1799-12-02 | 1801-03-03 | -1 | ||||||||||||||
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 | ||||||||||||||
2482 | 2482 | Thomas Ross R000456 | rep | OH | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2794 | 2794 | Philemon Beecher B000306 | rep | OH | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2900 | 2900 | William McLean M000552 | rep | OH | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2954 | 2954 | John Sloane S000494 | rep | OH | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2998 | 2998 | William Wilson W000619 | rep | OH | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
3000 | 3000 | William Wilson W000619 | rep | OH | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
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 | ||||||||||||||
3047 | 3047 | Mordecai Bartley B000210 | rep | OH | 1823-12-01 | 1825-03-03 | 14 | ||||||||||||||
3050 | 3050 | Mordecai Bartley B000210 | rep | OH | 1829-12-07 | 1831-03-03 | 14 | ||||||||||||||
4649 | 4649 | William Harrison H000279 | rep | OH | 1799-12-02 | 1801-03-03 | -1 | ||||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2999 | 2999 | William Wilson W000619 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 8 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
3356 | 3356 | William Creighton C000902 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 6 | |||||||||||||
4376 | 4376 | Elisha Whittlesey W000431 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 13 | |||||||||||||
4377 | 4377 | Elisha Whittlesey W000431 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 13 | |||||||||||||
4652 | 4652 | William Harrison H000279 | sen | OH | 1825-12-05 | 1829-03-03 | 3 | Adams | |||||||||||||
5557 | 5557 | Joseph Vance V000017 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 4 | |||||||||||||
5558 | 5558 | Joseph Vance V000017 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 4 | |||||||||||||
6156 | 6156 | Samuel Vinton V000107 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 7 | |||||||||||||
6157 | 6157 | Samuel Vinton V000107 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 7 | |||||||||||||
3349 | 3349 | Eleutheros Cooke C000732 | rep | OH | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 14 | |||||||||||||
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 | |||||||||||||
5556 | 5556 | Joseph Vance V000017 | rep | OH | 1823-12-01 | 1825-03-03 | Anti Jacksonian | 4 | |||||||||||||
5559 | 5559 | Joseph Vance V000017 | rep | OH | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 4 | |||||||||||||
5560 | 5560 | Joseph Vance V000017 | rep | OH | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 4 | |||||||||||||
5561 | 5561 | Joseph Vance V000017 | rep | OH | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 10 | |||||||||||||
4065 | 4065 | Jonathan Sloane S000495 | rep | OH | 1833-12-02 | 1835-03-03 | Anti Masonic | 15 | |||||||||||||
4066 | 4066 | Jonathan Sloane S000495 | rep | OH | 1835-12-07 | 1837-03-03 | Anti Masonic | 15 | |||||||||||||
4380 | 4380 | Elisha Whittlesey W000431 | rep | OH | 1833-12-02 | 1835-03-03 | Anti Masonic | 16 | |||||||||||||
6186 | 6186 | Thomas Ewing E000281 | sen | OH | 1831-12-05 | 1837-03-03 | 3 | Anti-Jacksonian | |||||||||||||
3762 | 3762 | Thomas Morris M000989 | sen | OH | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4167 | 4167 | John Chaney C000300 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 9 | |||||||||||||
4223 | 4223 | Thomas Hamer H000097 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4244 | 4244 | William Hunter H000993 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 14 | |||||||||||||
4251 | 4251 | Daniel Kilgore K000174 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4343 | 4343 | Matthias Shepler S000333 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 18 | |||||||||||||
4372 | 4372 | Taylor Webster W000241 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4534 | 4534 | Daniel Leadbetter L000172 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
4535 | 4535 | Daniel Leadbetter L000172 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4620 | 4620 | Henry Swearingen S001099 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4621 | 4621 | Henry Swearingen S001099 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4624 | 4624 | Benjamin Tappan T000039 | sen | OH | 1839-12-02 | 1845-03-03 | 1 | Democrat | |||||||||||||
4625 | 4625 | Jonathan Taylor T000092 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 12 | |||||||||||||
4763 | 4763 | William Doan D000380 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4764 | 4764 | William Doan D000380 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
4824 | 4824 | John Hastings H000328 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4825 | 4825 | John Hastings H000328 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 17 | |||||||||||||
4899 | 4899 | William Medill M000624 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
4900 | 4900 | William Medill M000624 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 9 | |||||||||||||
5018 | 5018 | George Sweeny S001105 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
5019 | 5019 | George Sweeny S001105 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
5143 | 5143 | Henry Brinkerhoff B000837 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 21 | |||||||||||||
5187 | 5187 | Ezra Dean D000171 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 18 | |||||||||||||
5188 | 5188 | Ezra Dean D000171 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 18 | |||||||||||||
5193 | 5193 | Alexander Duncan D000528 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
5194 | 5194 | Alexander Duncan D000528 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5195 | 5195 | Alexander Duncan D000528 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5250 | 5250 | James Mathews M000237 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 13 | |||||||||||||
5251 | 5251 | James Mathews M000237 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 16 | |||||||||||||
5252 | 5252 | William McCauslen M000323 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 17 | |||||||||||||
5254 | 5254 | Heman Moore M000899 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5307 | 5307 | Alfred Stone S000952 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5364 | 5364 | Jacob Brinkerhoff B000838 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 11 | |||||||||||||
5365 | 5365 | Jacob Brinkerhoff B000838 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 11 | |||||||||||||
5395 | 5395 | Francis Cunningham C000990 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5479 | 5479 | Joseph McDowell M000425 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5480 | 5480 | Joseph McDowell M000425 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5483 | 5483 | Joseph Morris M000980 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 15 | |||||||||||||
5484 | 5484 | Joseph Morris M000980 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 15 | |||||||||||||
5492 | 5492 | Isaac Parrish P000082 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 11 | |||||||||||||
5493 | 5493 | Isaac Parrish P000082 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 13 | |||||||||||||
5499 | 5499 | Augustus Perrill P000240 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 9 |
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);