legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
152 rows where "end" is on date 1881-03-03 and party = "Republican"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9452 | 9452 | Newton Booth B000630 | sen | CA | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
9461 | 9461 | Blanche Bruce B000968 | sen | MS | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
9473 | 9473 | Ambrose Burnside B001130 | sen | RI | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
9520 | 9520 | Hannibal Hamlin H000121 | sen | ME | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
9633 | 9633 | William Sharon S000292 | sen | NV | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
9996 | 9996 | John Bailey B000042 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 16 | |||||||||||||
9999 | 9999 | John Baker B000068 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 13 | |||||||||||||
10000 | 10000 | Henry Baldwin B000089 | sen | MI | 1879-03-18 | 1881-03-03 | 1 | Republican | |||||||||||||
10003 | 10003 | Latimer Ballou B000106 | rep | RI | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10004 | 10004 | Hiram Barber B000120 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10010 | 10010 | Granville Bennett B000374 | rep | DK | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10013 | 10013 | John Blake B000532 | rep | NJ | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
10017 | 10017 | Thomas Boyd B000721 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10018 | 10018 | Lewis Brigham B000834 | rep | NJ | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10034 | 10034 | Simeon Chittenden C000373 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10036 | 10036 | William Claflin C000398 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
10040 | 10040 | Rush Clark C000450 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10055 | 10055 | Calvin Cowgill C000824 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 11 | |||||||||||||
10056 | 10056 | Rollin Daggett D000003 | rep | NV | 1879-03-18 | 1881-03-03 | Republican | 0 | |||||||||||||
10058 | 10058 | Horace Davis D000105 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10063 | 10063 | Samuel Dick D000305 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 26 | |||||||||||||
10066 | 10066 | Stephen Downey D000470 | rep | WY | 1879-03-18 | 1881-03-03 | Republican | 0 | |||||||||||||
10067 | 10067 | Edwin Einstein E000097 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10073 | 10073 | Evarts Farr F000028 | rep | NH | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10077 | 10077 | John Ferdon F000079 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 14 | |||||||||||||
10079 | 10079 | Walbridge Field F000108 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10086 | 10086 | Greenbury Fort F000288 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
10099 | 10099 | Philip Hayes H000391 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10119 | 10119 | Amaziah James J000044 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 19 | |||||||||||||
10127 | 10127 | John Killinger K000179 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 14 | |||||||||||||
10135 | 10135 | George Loring L000445 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
10138 | 10138 | Thomas Majors M000075 | rep | NE | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10141 | 10141 | Joseph Martin M000190 | rep | NC | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10143 | 10143 | Jonas McGowan M000453 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10151 | 10151 | James Monroe M000857 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 17 | |||||||||||||
10155 | 10155 | John Newberry N000061 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10158 | 10158 | James Osmer O000119 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 27 | |||||||||||||
10159 | 10159 | Mariano Otero O000124 | rep | NM | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10161 | 10161 | Edward Overton O000145 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 15 | |||||||||||||
10170 | 10170 | Ray Pierce P000336 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 32 | |||||||||||||
10176 | 10176 | Hiram Price P000525 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10183 | 10183 | William Sapp S000060 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
10201 | 10201 | John Starin S000808 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 20 | |||||||||||||
10207 | 10207 | John Stone S000959 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10210 | 10210 | Charles Voorhis V000117 | rep | NJ | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10219 | 10219 | Harry White W000373 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 25 | |||||||||||||
10238 | 10238 | James Garfield G000063 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 19 | |||||||||||||
10251 | 10251 | William Aldrich A000086 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10270 | 10270 | Selwyn Bowman B000705 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10273 | 10273 | James Briggs B000831 | rep | NH | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10279 | 10279 | Angus Cameron C000064 | sen | WI | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10282 | 10282 | John Camp C000072 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 26 | |||||||||||||
10287 | 10287 | George Cannon C000119 | rep | UT | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10289 | 10289 | Cyrus Carpenter C000166 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10304 | 10304 | Omar Conger C000678 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10315 | 10315 | William Crapo C000881 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10320 | 10320 | Richard Crowley C000945 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 31 | |||||||||||||
10331 | 10331 | Nathaniel Deering D000188 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
10337 | 10337 | Jeremiah Dwight D000580 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 28 | |||||||||||||
10341 | 10341 | Russell Errett E000207 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 22 | |||||||||||||
10348 | 10348 | Horatio Fisher F000148 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 18 | |||||||||||||
10355 | 10355 | William Godshalk G000249 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10362 | 10362 | Joshua Hall H000057 | rep | NH | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10364 | 10364 | John Hammond H000129 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 18 | |||||||||||||
10372 | 10372 | Benjamin Harris H000233 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10375 | 10375 | Robert Hawk H000364 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10379 | 10379 | George Hazelton H000418 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10381 | 10381 | William Heilman H000451 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10395 | 10395 | Jay Hubbell H000894 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10399 | 10399 | Herman Humphrey H000952 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10410 | 10410 | Joseph Jorgensen J000271 | rep | VA | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
10414 | 10414 | Charles Joyce J000275 | rep | VT | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10428 | 10428 | Elbridge Lapham L000092 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 27 | |||||||||||||
10433 | 10433 | Stephen Lindsey L000328 | rep | ME | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10444 | 10444 | Joseph Mason M000222 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 24 | |||||||||||||
10449 | 10449 | Anson McCook M000358 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
10462 | 10462 | Samuel McMillan M000570 | sen | MN | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10465 | 10465 | Warner Miller M000760 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 22 | |||||||||||||
10468 | 10468 | John Mitchell M000819 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 16 | |||||||||||||
10471 | 10471 | Levi Morton M001018 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 11 | |||||||||||||
10477 | 10477 | Henry Neal N000012 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 12 | |||||||||||||
10481 | 10481 | Amasa Norcross N000134 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 10 | |||||||||||||
10490 | 10490 | Godlove Orth O000106 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10493 | 10493 | Romualdo Pacheco P000003 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
10498 | 10498 | Horace Page P000017 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10508 | 10508 | Thaddeus Pound P000476 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
10510 | 10510 | Cyrus Prescott P000512 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 23 | |||||||||||||
10515 | 10515 | David Richardson R000219 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 29 | |||||||||||||
10520 | 10520 | George Robeson R000330 | rep | NJ | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10531 | 10531 | William Shallenberger S000281 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 24 | |||||||||||||
10533 | 10533 | John Sherwin S000353 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
10562 | 10562 | William Thompson T000224 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10565 | 10565 | Amos Townsend T000328 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 20 | |||||||||||||
10567 | 10567 | James Tyler T000449 | rep | VT | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10569 | 10569 | Jonathan Updegraff U000018 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 18 | |||||||||||||
10573 | 10573 | Milton Urner U000033 | rep | MD | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
10577 | 10577 | Henry Van Aernam V000010 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 33 | |||||||||||||
10586 | 10586 | William Ward W000143 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
10592 | 10592 | Charles Williams W000492 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10595 | 10595 | Edwin Willits W000564 | rep | MI | 1879-03-18 | 1881-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);