legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
347 rows where "start" is on date 1881-12-05 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10437 | 10437 | William Lowe L000474 | rep | AL | 1881-12-05 | 1883-03-03 | National Greenbacker | 8 | |||||||||||||
10746 | 10746 | Thomas Herndon H000534 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10750 | 10750 | Goldsmith Hewitt H000553 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
10887 | 10887 | Charles Shelley S000326 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
10934 | 10934 | Thomas Williams W000537 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 5 | |||||||||||||
12167 | 12167 | William Forney F000280 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 7 | |||||||||||||
12202 | 12202 | Hilary Herbert H000524 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
12734 | 12734 | William Oates O000005 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
13821 | 13821 | Joseph Wheeler W000338 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 8 | |||||||||||||
10319 | 10319 | Jordan Cravens C000885 | rep | AR | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
10361 | 10361 | Thomas Gunter G000527 | rep | AR | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
11354 | 11354 | Poindexter Dunn D000552 | rep | AR | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
13362 | 13362 | James Jones J000231 | rep | AR | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
10828 | 10828 | Granville Oury O000135 | rep | AZ | 1881-12-05 | 1883-03-03 | Democrat | 0 | |||||||||||||
10268 | 10268 | Campbell Berry B000415 | rep | CA | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
10464 | 10464 | John Miller M000740 | sen | CA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10494 | 10494 | Romualdo Pacheco P000003 | rep | CA | 1881-12-05 | 1883-03-03 | Republican | 4 | |||||||||||||
10499 | 10499 | Horace Page P000017 | rep | CA | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
10868 | 10868 | William Rosecrans R000440 | rep | CA | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10636 | 10636 | James Belford B000326 | rep | CO | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
10504 | 10504 | James Phelps P000295 | rep | CT | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
10982 | 10982 | John Buck B001018 | rep | CT | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
11247 | 11247 | John Wait W000025 | rep | CT | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
11854 | 11854 | Frederick Miles M000704 | rep | CT | 1881-12-05 | 1883-03-03 | Republican | 4 | |||||||||||||
13702 | 13702 | Joseph Hawley H000377 | sen | CT | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10266 | 10266 | Thomas Bayard B000253 | sen | DE | 1881-12-05 | 1885-12-31 | 1 | Democrat | |||||||||||||
10443 | 10443 | Edward Martin M000178 | rep | DE | 1881-12-05 | 1883-03-03 | Democrat | 0 | |||||||||||||
13117 | 13117 | Richard Pettigrew P000271 | rep | DK | 1881-12-05 | 1883-03-03 | Republican | -1 | |||||||||||||
10347 | 10347 | Jesse Finley F000134 | rep | FL | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
10405 | 10405 | Charles Jones J000214 | sen | FL | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
10640 | 10640 | Horatio Bisbee B000485 | rep | FL | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
11720 | 11720 | Robert Davidson D000085 | rep | FL | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10269 | 10269 | George Black B000497 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10310 | 10310 | Philip Cook C000724 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
10548 | 10548 | Emory Speer S000711 | rep | GA | 1881-12-05 | 1883-03-03 | Ind. Democrat | 9 | |||||||||||||
10561 | 10561 | Alexander Stephens S000854 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 8 | |||||||||||||
10653 | 10653 | Hugh Buchanan B001003 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
11063 | 11063 | Nathaniel Hammond H000130 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 5 | |||||||||||||
11167 | 11167 | Seaborn Reese R000136 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 8 | |||||||||||||
11668 | 11668 | Judson Clements C000508 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 7 | |||||||||||||
12091 | 12091 | James Blount B000568 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
13183 | 13183 | Henry Turner T000421 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
10290 | 10290 | Cyrus Carpenter C000166 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 9 | |||||||||||||
10332 | 10332 | Nathaniel Deering D000188 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 4 | |||||||||||||
10344 | 10344 | Sewall Farwell F000039 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
10453 | 10453 | James McDill M000407 | sen | IA | 1881-12-05 | 1883-03-03 | 2 | Republican | |||||||||||||
10563 | 10563 | William Thompson T000224 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 5 | |||||||||||||
10677 | 10677 | John Cook C000719 | rep | IA | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
10686 | 10686 | Marsena Cutts C001032 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 6 | |||||||||||||
10777 | 10777 | John Kasson K000018 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 7 | |||||||||||||
10814 | 10814 | Moses McCoid M000348 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
13510 | 13510 | Thomas Updegraff U000019 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
15142 | 15142 | William Hepburn H000523 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 8 | |||||||||||||
10249 | 10249 | George Ainslie A000066 | rep | ID | 1881-12-05 | 1883-03-03 | Democrat | -1 | |||||||||||||
10252 | 10252 | William Aldrich A000086 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
10376 | 10376 | Robert Hawk H000364 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 5 | |||||||||||||
10431 | 10431 | John Lewis L000286 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 9 | |||||||||||||
10534 | 10534 | John Sherwin S000353 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 4 | |||||||||||||
10539 | 10539 | James Singleton S000444 | rep | IL | 1881-12-05 | 1883-03-03 | Democrat | 11 | |||||||||||||
10540 | 10540 | Dietrich Smith S000528 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 13 | |||||||||||||
10545 | 10545 | William Sparks S000704 | rep | IL | 1881-12-05 | 1883-03-03 | Democrat | 16 | |||||||||||||
10684 | 10684 | William Cullen C000971 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 7 | |||||||||||||
10689 | 10689 | George Davis D000100 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
10818 | 10818 | Samuel Moulton M001047 | rep | IL | 1881-12-05 | 1883-03-03 | Democrat | 15 | |||||||||||||
11139 | 11139 | William Morrison M001000 | rep | IL | 1881-12-05 | 1883-03-03 | Democrat | 17 | |||||||||||||
11366 | 11366 | Charles Farwell F000037 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
11524 | 11524 | John Thomas T000176 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 18 | |||||||||||||
11887 | 11887 | Lewis Payson P000157 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 8 | |||||||||||||
11989 | 11989 | Richard Townshend T000339 | rep | IL | 1881-12-05 | 1883-03-03 | Democrat | 19 | |||||||||||||
12626 | 12626 | Thomas Henderson H000489 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 6 | |||||||||||||
12799 | 12799 | William Springer S000757 | rep | IL | 1881-12-05 | 1883-03-03 | Democrat | 12 | |||||||||||||
14715 | 14715 | Robert Hitt H000649 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 5 | |||||||||||||
14802 | 14802 | Benjamin Marsh M000145 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 10 | |||||||||||||
18097 | 18097 | Joseph Cannon C000121 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 14 | |||||||||||||
10298 | 10298 | Walpole Colerick C000623 | rep | IN | 1881-12-05 | 1883-03-03 | Democrat | 12 | |||||||||||||
10329 | 10329 | Mark De Motte D000224 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 10 | |||||||||||||
10334 | 10334 | Charles Doxey D000479 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 9 | |||||||||||||
10382 | 10382 | William Heilman H000451 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
10491 | 10491 | Godlove Orth O000106 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 9 | |||||||||||||
10500 | 10500 | Robert Peirce P000191 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 8 | |||||||||||||
10664 | 10664 | William Calkins C000048 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 13 | |||||||||||||
10835 | 10835 | Stanton Peelle P000185 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 7 | |||||||||||||
10903 | 10903 | Strother Stockslager S000938 | rep | IN | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
11005 | 11005 | Thomas Cobb C000552 | rep | IN | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
11442 | 11442 | Courtland Matson M000248 | rep | IN | 1881-12-05 | 1883-03-03 | Democrat | 5 | |||||||||||||
11554 | 11554 | Benjamin Harrison H000263 | sen | IN | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11624 | 11624 | Thomas Browne B000958 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 6 | |||||||||||||
13342 | 13342 | William Holman H000732 | rep | IN | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
14177 | 14177 | George Steele S000830 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 11 | |||||||||||||
10742 | 10742 | Dudley Haskell H000316 | rep | KS | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
11566 | 11566 | John Anderson A000194 | rep | KS | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
11948 | 11948 | Thomas Ryan R000559 | rep | KS | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
10278 | 10278 | John Caldwell C000036 | rep | KY | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
10423 | 10423 | James Knott K000290 | rep | KY | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
10456 | 10456 | James McKenzie M000505 | rep | KY | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
10506 | 10506 | Elijah Phister P000318 | rep | KY | 1881-12-05 | 1883-03-03 | Democrat | 10 | |||||||||||||
10909 | 10909 | Philip Thompson T000212 | rep | KY | 1881-12-05 | 1883-03-03 | Democrat | 8 | |||||||||||||
10913 | 10913 | Oscar Turner T000425 | rep | KY | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10931 | 10931 | John White W000381 | rep | KY | 1881-12-05 | 1883-03-03 | Republican | 9 | |||||||||||||
11270 | 11270 | Albert Willis W000557 | rep | KY | 1881-12-05 | 1883-03-03 | Democrat | 5 |
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);