legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
23 rows where "start" is on date 1897-03-15 and state = "OH"
This data as json, copyable, CSV (advanced)
Suggested facets: end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13248 | 13248 | Clifton Beach B000262 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 20 | |||||||||||||
13303 | 13303 | Lucien Fenton F000076 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
13389 | 13389 | George Marshall M000153 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13439 | 13439 | Stephen Northway N000144 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 19 | |||||||||||||
13591 | 13591 | John Brenner B000801 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13595 | 13595 | Seth Brown B000943 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
13632 | 13632 | Lorenzo Danford D000028 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 16 | |||||||||||||
13683 | 13683 | Marcus Hanna H000163 | sen | OH | 1897-03-15 | 1899-03-03 | 1 | Republican | |||||||||||||
13721 | 13721 | Winfield Kerr K000145 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 14 | |||||||||||||
13724 | 13724 | John Lentz L000244 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 12 | |||||||||||||
13729 | 13729 | Archibald Lybrand L000523 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
13741 | 13741 | John McDowell M000421 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 17 | |||||||||||||
13744 | 13744 | David Meekison M000630 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
13817 | 13817 | Walter Weaver W000229 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
13884 | 13884 | Jacob Bromwell B000866 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
14113 | 14113 | James Norton N000150 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 13 | |||||||||||||
14157 | 14157 | William Shattuc S000300 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
14203 | 14203 | Robert Tayler T000061 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 18 | |||||||||||||
14311 | 14311 | Joseph Foraker F000253 | sen | OH | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
14512 | 14512 | Henry Van Voorhis V000062 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 15 | |||||||||||||
14680 | 14680 | Charles Grosvenor G000497 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 11 | |||||||||||||
14909 | 14909 | James Southard S000687 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 9 | |||||||||||||
19557 | 19557 | Theodore Burton B001159 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 21 |
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);