legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
805 rows where party = "Democrat" and state = "OH"
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, url, phone, fax, contact_form, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
5529 | 5529 | Henry St. John S000767 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5530 | 5530 | Henry St. John S000767 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5531 | 5531 | David Starkweather S000813 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 18 | |||||||||||||
5532 | 5532 | David Starkweather S000813 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 18 | |||||||||||||
5660 | 5660 | John Cummins C000989 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 16 | |||||||||||||
5661 | 5661 | John Cummins C000989 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 16 | |||||||||||||
5688 | 5688 | James Faran F000014 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5689 | 5689 | James Faran F000014 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
5698 | 5698 | George Fries F000386 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 17 | |||||||||||||
5699 | 5699 | George Fries F000386 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 17 | |||||||||||||
5751 | 5751 | William Kennon K000122 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 15 | |||||||||||||
5752 | 5752 | Samuel Lahm L000021 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 18 | |||||||||||||
5813 | 5813 | William Sawyer S000095 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5814 | 5814 | William Sawyer S000095 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
5966 | 5966 | Rodolphus Dickinson D000325 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
5967 | 5967 | Rodolphus Dickinson D000325 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6006 | 6006 | Moses Hoagland H000651 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 16 | |||||||||||||
6064 | 6064 | John Miller M000742 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 11 | |||||||||||||
6065 | 6065 | John Miller M000742 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 11 | |||||||||||||
6068 | 6068 | Jonathan Morris M000979 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
6069 | 6069 | Jonathan Morris M000979 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6094 | 6094 | Emery Potter P000464 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
6095 | 6095 | Emery Potter P000464 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6174 | 6174 | William Whittlesey W000434 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 13 | |||||||||||||
6177 | 6177 | Amos Wood W000689 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6241 | 6241 | George Busby B001162 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 11 | |||||||||||||
6246 | 6246 | Joseph Cable C000008 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 17 | |||||||||||||
6247 | 6247 | Joseph Cable C000008 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 17 | |||||||||||||
6251 | 6251 | David Cartter C000206 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 18 | |||||||||||||
6252 | 6252 | David Cartter C000206 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 18 | |||||||||||||
6302 | 6302 | James Gaylord G000108 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 13 | |||||||||||||
6431 | 6431 | Charles Sweetser S001111 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6432 | 6432 | Charles Sweetser S001111 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 10 | |||||||||||||
6436 | 6436 | Norton Townshend T000338 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 21 | |||||||||||||
6479 | 6479 | John Weller W000274 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
6480 | 6480 | John Weller W000274 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
6481 | 6481 | John Weller W000274 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
6566 | 6566 | David Disney D000361 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6567 | 6567 | David Disney D000361 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6568 | 6568 | David Disney D000361 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6577 | 6577 | Alfred Edgerton E000045 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6578 | 6578 | Alfred Edgerton E000045 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
6580 | 6580 | Andrew Ellison E000140 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
6598 | 6598 | Frederick Green G000409 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6599 | 6599 | Frederick Green G000409 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 9 | |||||||||||||
6626 | 6626 | Harvey Johnson J000136 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 14 | |||||||||||||
6642 | 6642 | William Lindsley L000330 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 13 | |||||||||||||
6659 | 6659 | Edson Olds O000063 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 9 | |||||||||||||
6660 | 6660 | Edson Olds O000063 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
6661 | 6661 | Edson Olds O000063 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 12 | |||||||||||||
6680 | 6680 | Thomas Ritchey R000271 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 13 | |||||||||||||
6681 | 6681 | Thomas Ritchey R000271 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 11 | |||||||||||||
6688 | 6688 | Wilson Shannon S000291 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 17 | |||||||||||||
6709 | 6709 | Andrew Stuart S001031 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 21 | |||||||||||||
6903 | 6903 | George Pugh P000560 | sen | OH | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
6999 | 6999 | Joseph Burns B001128 | rep | OH | 1857-12-07 | 1859-03-03 | Democrat | 15 |
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);