legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
291 rows where "start" is on date 1871-03-04 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15102 | 15102 | William Frye F000398 | rep | ME | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
14743 | 14743 | John Ketcham K000152 | rep | NY | 1871-03-04 | 1873-03-03 | Republican | 12 | |||||||||||||
14686 | 14686 | Eugene Hale H000029 | rep | ME | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
14002 | 14002 | George Hoar H000654 | rep | MA | 1871-03-04 | 1873-03-03 | Republican | 8 | |||||||||||||
13699 | 13699 | Joseph Hawley H000377 | rep | CT | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
13685 | 13685 | Alfred Harmer H000215 | rep | PA | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
13339 | 13339 | William Holman H000732 | rep | IN | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
13078 | 13078 | Richard McCormick M000371 | rep | AZ | 1871-03-04 | 1873-03-03 | Unionist | 0 | |||||||||||||
12349 | 12349 | Daniel Voorhees V000116 | rep | IN | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
12022 | 12022 | Washington Whitthorne W000429 | rep | TN | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
11916 | 11916 | Samuel Randall R000039 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
11789 | 11789 | William Kelley K000062 | rep | PA | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
11740 | 11740 | Mark Dunnell D000555 | rep | MN | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
11696 | 11696 | Samuel Cox C000839 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
11601 | 11601 | James Beck B000289 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
11581 | 11581 | Nathaniel Banks B000116 | rep | MA | 1871-03-04 | 1873-03-03 | Republican | 6 | |||||||||||||
11501 | 11501 | Philetus Sawyer S000091 | rep | WI | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
11461 | 11461 | Thomas Norwood N000160 | sen | GA | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
11363 | 11363 | Charles Farwell F000037 | rep | IL | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
11343 | 11343 | Henry Dawes D000148 | rep | MA | 1871-03-04 | 1873-03-03 | Republican | 10 | |||||||||||||
11314 | 11314 | Roderick Butler B001188 | rep | TN | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
11308 | 11308 | Frank Bunnell B001064 | rep | PA | 1871-03-04 | 1873-03-03 | Republican | 13 | |||||||||||||
11210 | 11210 | John Storm S000975 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 11 | |||||||||||||
11182 | 11182 | Walter Sessions S000251 | rep | NY | 1871-03-04 | 1873-03-03 | Republican | 31 | |||||||||||||
11147 | 11147 | James Negley N000024 | rep | PA | 1871-03-04 | 1873-03-03 | Republican | 22 | |||||||||||||
11114 | 11114 | John Logan L000403 | sen | IL | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10893 | 10893 | Henry Slocum S000496 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
10874 | 10874 | Eli Saulsbury S000072 | sen | DE | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
10842 | 10842 | Luke Poland P000406 | rep | VT | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
10731 | 10731 | John Hancock H000150 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
10626 | 10626 | Henry Anthony A000262 | sen | RI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10610 | 10610 | Fernando Wood W000694 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 9 | |||||||||||||
10385 | 10385 | John Hill H000596 | rep | NJ | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
10323 | 10323 | Chester Darrall D000062 | rep | LA | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
10300 | 10300 | Omar Conger C000678 | rep | MI | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
10245 | 10245 | William Windom W000629 | sen | MN | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10234 | 10234 | James Garfield G000063 | rep | OH | 1871-03-04 | 1873-03-03 | Republican | 19 | |||||||||||||
10214 | 10214 | Erastus Wells W000282 | rep | MO | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
10191 | 10191 | James Slater S000476 | rep | OR | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
10147 | 10147 | James Monroe M000857 | rep | OH | 1871-03-04 | 1873-03-03 | Republican | 14 | |||||||||||||
10124 | 10124 | John Killinger K000179 | rep | PA | 1871-03-04 | 1873-03-03 | Republican | 10 | |||||||||||||
10093 | 10093 | John Harris H000247 | rep | VA | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
10019 | 10019 | John Bright B000836 | rep | TN | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9965 | 9965 | Alfred Waddell W000002 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9948 | 9948 | Thomas Swann S001092 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9906 | 9906 | Joseph Rainey R000016 | rep | SC | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9899 | 9899 | Clarkson Potter P000461 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 10 | |||||||||||||
9846 | 9846 | Frank Hereford H000527 | rep | WV | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9822 | 9822 | De Giddings G000166 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9808 | 9808 | Charles Foster F000299 | rep | OH | 1871-03-04 | 1873-03-03 | Republican | 9 | |||||||||||||
9805 | 9805 | Thomas Ferry F000095 | sen | MI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9792 | 9792 | Benjamin Eames E000005 | rep | RI | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9782 | 9782 | Henry Davis D000103 | sen | WV | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9760 | 9760 | Benjamin Butler B001174 | rep | MA | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
9753 | 9753 | Horatio Burchard B001070 | rep | IL | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
9723 | 9723 | Jerome Chaffee C000271 | rep | CO | 1871-03-04 | 1873-03-03 | Republican | -1 | |||||||||||||
9718 | 9718 | James Blaine B000519 | rep | ME | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
9711 | 9711 | William Barnum B000166 | rep | CT | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9692 | 9692 | William Wheeler W000341 | rep | NY | 1871-03-04 | 1873-03-03 | Republican | 17 | |||||||||||||
9680 | 9680 | Josiah Walls W000093 | rep | FL | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9673 | 9673 | Alexander Wallace W000074 | rep | SC | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
9668 | 9668 | Henry Waldron W000041 | rep | MI | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9660 | 9660 | Washington Townsend T000337 | rep | PA | 1871-03-04 | 1873-03-03 | Republican | 7 | |||||||||||||
9651 | 9651 | William Terry T000136 | rep | VA | 1871-03-04 | 1873-03-03 | Democrat | 8 | |||||||||||||
9646 | 9646 | William Stowell S000985 | rep | VA | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
9639 | 9639 | Henry Starkweather S000815 | rep | CT | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
9625 | 9625 | Jeremiah Rusk R000517 | rep | WI | 1871-03-04 | 1873-03-03 | Republican | 6 | |||||||||||||
9602 | 9602 | John Packer P000008 | rep | PA | 1871-03-04 | 1873-03-03 | Republican | 14 | |||||||||||||
9591 | 9591 | Frank Morey M000942 | rep | LA | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
9578 | 9578 | George McCrary M000379 | rep | IA | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9556 | 9556 | Michael Kerr K000143 | rep | IN | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
9526 | 9526 | Charles Hays H000402 | rep | AL | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
9497 | 9497 | Smith Ely E000167 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
9467 | 9467 | James Buffinton B001040 | rep | MA | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9449 | 9449 | Samuel Bell B000346 | rep | NH | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
9438 | 9438 | William Washburn W000174 | rep | MA | 1871-03-04 | 1873-03-03 | Republican | 9 | |||||||||||||
9430 | 9430 | Pierce Young Y000048 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
9422 | 9422 | Jeremiah Wilson W000596 | rep | IN | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
9419 | 9419 | William Williams W000545 | rep | IN | 1871-03-04 | 1873-03-03 | Republican | 10 | |||||||||||||
9414 | 9414 | Charles Willard W000478 | rep | VT | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9410 | 9410 | Richard Whiteley W000408 | rep | GA | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9401 | 9401 | James Tyner T000452 | rep | IN | 1871-03-04 | 1873-03-03 | Republican | 8 | |||||||||||||
9394 | 9394 | Charles Thomas T000158 | rep | NC | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9391 | 9391 | Jacob Sypher S001140 | rep | LA | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9383 | 9383 | Charles St. John S000765 | rep | NY | 1871-03-04 | 1873-03-03 | Republican | 11 | |||||||||||||
9381 | 9381 | William Sprague S000748 | rep | OH | 1871-03-04 | 1873-03-03 | Republican | 15 | |||||||||||||
9377 | 9377 | Robert Speer S000713 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 17 | |||||||||||||
9375 | 9375 | Oliver Snyder S000671 | rep | AR | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9370 | 9370 | Horace Smith S000552 | rep | NY | 1871-03-04 | 1873-03-03 | Republican | 27 | |||||||||||||
9365 | 9365 | Joseph Sloss S000498 | rep | AL | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9362 | 9362 | Lazarus Shoemaker S000375 | rep | PA | 1871-03-04 | 1873-03-03 | Republican | 12 | |||||||||||||
9359 | 9359 | Lionel Sheldon S000322 | rep | LA | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9355 | 9355 | John Shanks S000284 | rep | IN | 1871-03-04 | 1873-03-03 | Republican | 9 | |||||||||||||
9347 | 9347 | Glenni Scofield S000164 | rep | PA | 1871-03-04 | 1873-03-03 | Republican | 19 | |||||||||||||
9339 | 9339 | Aaron Sargent S000065 | rep | CA | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9334 | 9334 | James Robinson R000336 | rep | IL | 1871-03-04 | 1873-03-03 | Democrat | 8 | |||||||||||||
9329 | 9329 | William Roberts R000316 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
9327 | 9327 | Ellis Roberts R000310 | rep | NY | 1871-03-04 | 1873-03-03 | Republican | 21 | |||||||||||||
9323 | 9323 | William Read R000094 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9317 | 9317 | James Platt P000380 | rep | VA | 1871-03-04 | 1873-03-03 | Republican | 2 |
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);