legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
22 rows where "end" is on date 1887-03-03 and state = "OH"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10958 | 10958 | Charles Anderson A000185 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11026 | 11026 | William Ellsberry E000143 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 11 | |||||||||||||
11047 | 11047 | George Geddes G000115 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 16 | |||||||||||||
11085 | 11085 | William Hill H000609 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11105 | 11105 | Benjamin Le Fevre L000159 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11109 | 11109 | John Little L000351 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
11223 | 11223 | Isaac Taylor T000081 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 18 | |||||||||||||
11258 | 11258 | Adoniram Warner W000151 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 17 | |||||||||||||
11304 | 11304 | Charles Brown B000907 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11318 | 11318 | James Campbell C000087 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11371 | 11371 | Martin Foran F000254 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 21 | |||||||||||||
11495 | 11495 | Jacob Romeis R000415 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 10 | |||||||||||||
11548 | 11548 | Beriah Wilkins W000474 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 15 | |||||||||||||
11641 | 11641 | Benjamin Butterworth B001200 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11686 | 11686 | William Cooper C000765 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 9 | |||||||||||||
11957 | 11957 | George Seney S000241 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
11983 | 11983 | Albert Thompson T000191 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 12 | |||||||||||||
12319 | 12319 | Ezra Taylor T000073 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 19 | |||||||||||||
12741 | 12741 | Joseph Outhwaite O000136 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 13 | |||||||||||||
12782 | 12782 | John Sherman S000346 | sen | OH | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
13233 | 13233 | William McKinley M000522 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 20 | |||||||||||||
14675 | 14675 | Charles Grosvenor G000497 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 14 |
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);