legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
383 rows where "end" is on date 1893-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: start, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11299 | 11299 | Rufus Blodgett B000562 | sen | NJ | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
11347 | 11347 | Henry Dawes D000148 | sen | MA | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
11401 | 11401 | Frank Hiscock H000643 | sen | NY | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
11465 | 11465 | Algernon Paddock P000010 | sen | NE | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
11504 | 11504 | Philetus Sawyer S000091 | sen | WI | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
11562 | 11562 | John Allen A000130 | sen | WA | 1889-11-19 | 1893-03-03 | 1 | Republican | |||||||||||||
11588 | 11588 | John Barbour B000129 | sen | VA | 1889-12-02 | 1893-03-03 | 2 | Democrat | |||||||||||||
11656 | 11656 | Lyman Casey C000227 | sen | ND | 1889-12-02 | 1893-03-03 | 1 | Republican | |||||||||||||
11769 | 11769 | Randall Gibson G000165 | sen | LA | 1889-12-02 | 1893-03-03 | 2 | Democrat | |||||||||||||
12065 | 12065 | Wilbur Sanders S000039 | sen | MT | 1890-01-01 | 1893-03-03 | 1 | Republican | |||||||||||||
12066 | 12066 | Lemuel Amerman A000171 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 11 | |||||||||||||
12068 | 12068 | John Andrew A000242 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12069 | 12069 | Edwin Antony A000264 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12074 | 12074 | Louis Atkinson A000331 | rep | PA | 1891-12-07 | 1893-03-03 | Republican | 18 | |||||||||||||
12075 | 12075 | Clinton Babbitt B000001 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12078 | 12078 | Henry Bacon B000016 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 15 | |||||||||||||
12080 | 12080 | Horace Bartine B000197 | rep | NV | 1891-12-07 | 1893-03-03 | Republican | 0 | |||||||||||||
12081 | 12081 | Joseph Beeman B000309 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12083 | 12083 | Charles Belknap B000328 | rep | MI | 1891-12-07 | 1893-03-03 | Republican | 5 | |||||||||||||
12084 | 12084 | Henry Bentley B000393 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 23 | |||||||||||||
12086 | 12086 | Christopher Bergen B000404 | rep | NJ | 1891-12-07 | 1893-03-03 | Republican | 1 | |||||||||||||
12096 | 12096 | James Blount B000568 | rep | GA | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12097 | 12097 | David Boody B000625 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12098 | 12098 | Thomas Bowman B000706 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12100 | 12100 | John Brown B000930 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12102 | 12102 | David Brunner B000980 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12106 | 12106 | James Buchanan B001004 | rep | NJ | 1891-12-07 | 1893-03-03 | Republican | 2 | |||||||||||||
12108 | 12108 | John Buchanan B001007 | rep | VA | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12110 | 12110 | Robert Bullock B001052 | rep | FL | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12111 | 12111 | Thomas Bunting B001067 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 33 | |||||||||||||
12112 | 12112 | Samuel Busey B001164 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 15 | |||||||||||||
12113 | 12113 | Allen Bushnell B001170 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12114 | 12114 | Walter Butler B001193 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12115 | 12115 | Samuel Byrns B001219 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 10 | |||||||||||||
12116 | 12116 | Benjamin Cable C000006 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 11 | |||||||||||||
12122 | 12122 | John Caine C000023 | rep | UT | 1891-12-07 | 1893-03-03 | Democrat | -1 | |||||||||||||
12130 | 12130 | James Castle C000242 | rep | MN | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12132 | 12132 | William Cate C000249 | rep | AR | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12133 | 12133 | Alfred Chapin C000304 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12135 | 12135 | Henry Cheatham C000340 | rep | NC | 1891-12-07 | 1893-03-03 | Republican | 2 | |||||||||||||
12136 | 12136 | Benjamin Clover C000533 | rep | KS | 1891-12-07 | 1893-03-03 | Populist | 3 | |||||||||||||
12137 | 12137 | Frank Coburn C000557 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12138 | 12138 | Frederick Coolidge C000739 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 11 | |||||||||||||
12142 | 12142 | William Cowles C000829 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12143 | 12143 | Isaac Cox C000832 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 17 | |||||||||||||
12144 | 12144 | Alexander Craig C000854 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 24 | |||||||||||||
12145 | 12145 | John Crosby C000929 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 12 | |||||||||||||
12146 | 12146 | John Cutting C001030 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 4 | |||||||||||||
12147 | 12147 | Warren Daniell D000039 | rep | NH | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12149 | 12149 | W. Dickerson D000310 | rep | KY | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12150 | 12150 | William Dixon D000378 | rep | MT | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12151 | 12151 | Robert Doan D000379 | rep | OH | 1891-12-07 | 1893-03-03 | Republican | 10 | |||||||||||||
12152 | 12152 | James Dungan D000539 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 13 | |||||||||||||
12153 | 12153 | Robert Everett E000267 | rep | GA | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12156 | 12156 | Charles Felton F000068 | sen | CA | 1891-12-07 | 1893-03-03 | 1 | Republican | |||||||||||||
12158 | 12158 | James Flick F000206 | rep | IA | 1891-12-07 | 1893-03-03 | Republican | 8 | |||||||||||||
12161 | 12161 | Roswell Flower F000217 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 12 | |||||||||||||
12163 | 12163 | Melbourne Ford F000265 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12172 | 12172 | William Forney F000280 | rep | AL | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12174 | 12174 | Samuel Fowler F000326 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12175 | 12175 | John Gamble G000030 | rep | SD | 1891-12-07 | 1893-03-03 | Republican | -1 | |||||||||||||
12176 | 12176 | Martin Gantz G000043 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12181 | 12181 | Eugene Gillespie G000195 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 25 | |||||||||||||
12186 | 12186 | Halbert Greenleaf G000432 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 30 | |||||||||||||
12187 | 12187 | Edwin Hallowell H000084 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12188 | 12188 | Kittel Halvorson H000094 | rep | MN | 1891-12-07 | 1893-03-03 | Populist | 5 | |||||||||||||
12189 | 12189 | John Hamilton H000113 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12190 | 12190 | William Harries H000228 | rep | MN | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12192 | 12192 | David Harvey H000305 | rep | OK | 1891-12-07 | 1893-03-03 | Republican | -1 | |||||||||||||
12194 | 12194 | William Haynes H000401 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12199 | 12199 | John Hemphill H000469 | rep | SC | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12207 | 12207 | Hilary Herbert H000524 | rep | AL | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12208 | 12208 | Sherman Hoar H000657 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12215 | 12215 | Leonidas Houk H000818 | rep | TN | 1891-12-07 | 1893-03-03 | Republican | 2 | |||||||||||||
12217 | 12217 | George Johnstone J000202 | rep | SC | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12218 | 12218 | John Jolley J000203 | rep | SD | 1891-12-07 | 1893-03-03 | Republican | -1 | |||||||||||||
12219 | 12219 | John Kendall K000092 | rep | KY | 1891-12-07 | 1893-03-03 | Democrat | 10 | |||||||||||||
12221 | 12221 | Matthew Lagan L000019 | rep | LA | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12222 | 12222 | John Lawson L000145 | rep | VA | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12225 | 12225 | William Lee L000208 | rep | VA | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12227 | 12227 | Posey Lester L000254 | rep | VA | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12229 | 12229 | Clarke Lewis L000276 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12230 | 12230 | Joseph Little L000353 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 12 | |||||||||||||
12231 | 12231 | John Long L000422 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12234 | 12234 | Charles Mansur M000115 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12236 | 12236 | Charles McClellan M000329 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 12 | |||||||||||||
12237 | 12237 | Edward McDonald M000409 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12241 | 12241 | Joseph McKenna M000500 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 3 | |||||||||||||
12243 | 12243 | Luther McKinney M000526 | rep | NH | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12244 | 12244 | Lucas Miller M000746 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12247 | 12247 | Littleton Moore M000908 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12248 | 12248 | Walter Newberry N000063 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12250 | 12250 | Richard Norton N000157 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12254 | 12254 | James O’Donnell O000039 | rep | MI | 1891-12-07 | 1893-03-03 | Republican | 3 | |||||||||||||
12255 | 12255 | Lewis Ohliger O000057 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 16 | |||||||||||||
12256 | 12256 | John Otis O000129 | rep | KS | 1891-12-07 | 1893-03-03 | Populist | 4 | |||||||||||||
12258 | 12258 | James Owens O000158 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 14 | |||||||||||||
12259 | 12259 | Henry Page P000016 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12262 | 12262 | William Parrett P000078 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12263 | 12263 | John Pattison P000135 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 11 |
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);