legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,208 rows where party = "Republican" and state = "OH"
This data as json, copyable, CSV (advanced)
Suggested facets: class, start (date), end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2938 | 2938 | Benjamin Ruggles R000500 | sen | OH | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
4650 | 4650 | William Harrison H000279 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
4651 | 4651 | William Harrison H000279 | rep | OH | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
4912 | 4912 | Jeremiah Morrow M001003 | rep | OH | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
4913 | 4913 | Jeremiah Morrow M001003 | rep | OH | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
4914 | 4914 | Jeremiah Morrow M001003 | rep | OH | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
4915 | 4915 | Jeremiah Morrow M001003 | rep | OH | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
4916 | 4916 | Jeremiah Morrow M001003 | rep | OH | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
4917 | 4917 | Jeremiah Morrow M001003 | sen | OH | 1813-05-24 | 1819-03-03 | 3 | Republican | |||||||||||||
5555 | 5555 | Joseph Vance V000017 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
6985 | 6985 | Philemon Bliss B000560 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 14 | |||||||||||||
7058 | 7058 | Joshua Giddings G000167 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 20 | |||||||||||||
7083 | 7083 | Aaron Harlan H000207 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 7 | |||||||||||||
7132 | 7132 | Benjamin Leiter L000236 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 18 | |||||||||||||
7166 | 7166 | Richard Mott M001042 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 5 | |||||||||||||
7171 | 7171 | Matthias Nichols N000093 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 4 | |||||||||||||
7335 | 7335 | John Carey C000144 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 9 | |||||||||||||
7441 | 7441 | William Helmick H000462 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 15 | |||||||||||||
7576 | 7576 | Cyrus Spink S000735 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 14 | |||||||||||||
7584 | 7584 | Benjamin Stanton S000801 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 8 | |||||||||||||
7585 | 7585 | Benjamin Stanton S000801 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 8 | |||||||||||||
7603 | 7603 | Thomas Theaker T000151 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 17 | |||||||||||||
7607 | 7607 | Cydnor Tompkins T000305 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 16 | |||||||||||||
7608 | 7608 | Cydnor Tompkins T000305 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 16 | |||||||||||||
7618 | 7618 | Edward Wade W000006 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 19 | |||||||||||||
7619 | 7619 | Edward Wade W000006 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 19 | |||||||||||||
7669 | 7669 | Harrison Blake B000531 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 14 | |||||||||||||
7670 | 7670 | Harrison Blake B000531 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 14 | |||||||||||||
7693 | 7693 | Salmon Chase C000332 | sen | OH | 1861-07-04 | 1861-12-31 | 3 | Republican | |||||||||||||
7716 | 7716 | Thomas Corwin C000791 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 7 | |||||||||||||
7717 | 7717 | Thomas Corwin C000791 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 7 | |||||||||||||
7731 | 7731 | William Cutler C001027 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 16 | |||||||||||||
7742 | 7742 | Sidney Edgerton E000048 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 18 | |||||||||||||
7743 | 7743 | Sidney Edgerton E000048 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 18 | |||||||||||||
7758 | 7758 | John Gurley G000530 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7759 | 7759 | John Gurley G000530 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
7769 | 7769 | Valentine Horton H000800 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 11 | |||||||||||||
7770 | 7770 | Valentine Horton H000800 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 11 | |||||||||||||
7771 | 7771 | John Hutchins H001008 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 20 | |||||||||||||
7772 | 7772 | John Hutchins H001008 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 20 | |||||||||||||
7844 | 7844 | Albert Riddle R000238 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 19 | |||||||||||||
7863 | 7863 | Carey Trimble T000371 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 10 | |||||||||||||
7864 | 7864 | Carey Trimble T000371 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 10 | |||||||||||||
7893 | 7893 | Samuel Worcester W000741 | rep | OH | 1861-07-04 | 1863-03-03 | Republican | 13 | |||||||||||||
8053 | 8053 | Benjamin Wade W000005 | sen | OH | 1857-12-07 | 1863-03-03 | 1 | Republican | |||||||||||||
8054 | 8054 | Benjamin Wade W000005 | sen | OH | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8149 | 8149 | James Hubbell H000893 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
8276 | 8276 | Ralph Buckland B001022 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
8277 | 8277 | Ralph Buckland B001022 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8285 | 8285 | Reader Clarke C000468 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8286 | 8286 | Reader Clarke C000468 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8306 | 8306 | Columbus Delano D000214 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 13 |
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);