legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
345 rows where "end" is on date 1875-03-03
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9263 | 9263 | Obadiah McFadden M000435 | rep | WA | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9265 | 9265 | Ebenezer McJunkin M000487 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 23 | |||||||||||||
9269 | 9269 | George McKee M000494 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9270 | 9270 | William McLean M000553 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9271 | 9271 | John McNulta M000587 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 13 | |||||||||||||
9272 | 9272 | David Mellish M000637 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9274 | 9274 | Clinton Merriam M000653 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 21 | |||||||||||||
9277 | 9277 | Alexander Mitchell M000802 | rep | WI | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9278 | 9278 | William Moore M000925 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 24 | |||||||||||||
9286 | 9286 | Leonard Myers M001131 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9288 | 9288 | James Nesmith N000050 | rep | OR | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9295 | 9295 | William Niblack N000083 | rep | IN | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9296 | 9296 | Jason Niles N000107 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9298 | 9298 | David Nunn N000170 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9301 | 9301 | Jackson Orr O000103 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9304 | 9304 | Jasper Packard P000004 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 11 | |||||||||||||
9306 | 9306 | Hosea Parker P000057 | rep | NH | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9308 | 9308 | Isaac Parker P000059 | rep | MO | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9309 | 9309 | Richard Parsons P000089 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 20 | |||||||||||||
9311 | 9311 | Charles Pelham P000192 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9313 | 9313 | James Pendleton P000204 | rep | RI | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9315 | 9315 | Eli Perry P000242 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 15 | |||||||||||||
9318 | 9318 | James Platt P000380 | rep | VA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9319 | 9319 | Alonzo Ransier R000060 | rep | SC | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9320 | 9320 | James Rapier R000064 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9321 | 9321 | Morgan Rawls R000074 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9322 | 9322 | William Ray R000081 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 10 | |||||||||||||
9324 | 9324 | William Read R000094 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9325 | 9325 | John Rice R000200 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9326 | 9326 | Hiram Richmond R000233 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 20 | |||||||||||||
9328 | 9328 | Ellis Roberts R000310 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 22 | |||||||||||||
9330 | 9330 | William Roberts R000316 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9335 | 9335 | James Robinson R000336 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 12 | |||||||||||||
9336 | 9336 | James Robinson R000340 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9341 | 9341 | Henry Sayler S000100 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 10 | |||||||||||||
9342 | 9342 | Richard Schell S000114 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9348 | 9348 | Glenni Scofield S000164 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9349 | 9349 | Henry Scudder S000197 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9350 | 9350 | Isaac Scudder S000199 | rep | NJ | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
9351 | 9351 | James Sener S000240 | rep | VA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9356 | 9356 | John Shanks S000284 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9357 | 9357 | Charles Sheats S000314 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9360 | 9360 | Lionel Sheldon S000322 | rep | LA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9361 | 9361 | George Sheridan S000341 | rep | LA | 1873-12-01 | 1875-03-03 | Liberal Republican | -1 | |||||||||||||
9363 | 9363 | Lazarus Shoemaker S000375 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 12 | |||||||||||||
9364 | 9364 | Andrew Sloan S000489 | rep | GA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9366 | 9366 | Joseph Sloss S000498 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9367 | 9367 | William Small S000501 | rep | NH | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9368 | 9368 | James Smart S000504 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 16 | |||||||||||||
9369 | 9369 | George Smith S000539 | rep | LA | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9371 | 9371 | Horace Smith S000552 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 28 | |||||||||||||
9372 | 9372 | John Smith S000568 | rep | VA | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9373 | 9373 | John Smith S000574 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9374 | 9374 | William Smith S000630 | rep | NC | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9376 | 9376 | Oliver Snyder S000671 | rep | AR | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9378 | 9378 | Robert Speer S000713 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 17 | |||||||||||||
9382 | 9382 | William Sprague S000748 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 15 | |||||||||||||
9384 | 9384 | Charles St. John S000765 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 12 | |||||||||||||
9385 | 9385 | Edwin Stanard S000787 | rep | MO | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9386 | 9386 | Elisha Standiford S000790 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9387 | 9387 | Charles Stevens S000877 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 10 | |||||||||||||
9388 | 9388 | James Strawbridge S001001 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 13 | |||||||||||||
9392 | 9392 | Jacob Sypher S001140 | rep | LA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9393 | 9393 | Alexander Taylor T000063 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 21 | |||||||||||||
9395 | 9395 | Charles Thomas T000158 | rep | NC | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9396 | 9396 | Christopher Thomas T000161 | rep | VA | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9398 | 9398 | Lemuel Todd T000293 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9399 | 9399 | Lyman Tremain T000364 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9402 | 9402 | James Tyner T000452 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9404 | 9404 | Jasper Ward W000135 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9405 | 9405 | Marcus Ward W000137 | rep | NJ | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9407 | 9407 | Alexander White W000353 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9408 | 9408 | Thomas Whitehead W000401 | rep | VA | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9411 | 9411 | Richard Whiteley W000408 | rep | GA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9412 | 9412 | William Whiting W000417 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9415 | 9415 | Charles Willard W000478 | rep | VT | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9416 | 9416 | John Williams W000519 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9420 | 9420 | William Williams W000545 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9421 | 9421 | Asa Willie W000555 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9423 | 9423 | Jeremiah Wilson W000596 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9424 | 9424 | Joseph Wilson W000605 | rep | OR | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9425 | 9425 | Simeon Wolfe W000677 | rep | IN | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9426 | 9426 | Stewart Woodford W000713 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9427 | 9427 | John Young Y000044 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 10 | |||||||||||||
9431 | 9431 | Pierce Young Y000048 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9433 | 9433 | Henry Pease P000172 | sen | MS | 1874-01-01 | 1875-03-03 | 1 | Republican | |||||||||||||
9439 | 9439 | William Washburn W000174 | sen | MA | 1874-01-01 | 1875-03-03 | 1 | Republican | |||||||||||||
9444 | 9444 | Thomas Ashe A000309 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9447 | 9447 | Lyman Bass B000221 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 31 | |||||||||||||
9454 | 9454 | Nathan Bradley B000744 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9458 | 9458 | John Brown B000933 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9468 | 9468 | James Buffinton B001040 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9471 | 9471 | John Burleigh B001107 | rep | ME | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9475 | 9475 | John Caldwell C000035 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9480 | 9480 | Thomas Cason C000232 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
9483 | 9483 | Bernard Caulfield C000255 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9489 | 9489 | Lorenzo Crounse C000935 | rep | NE | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9493 | 9493 | Samuel Dobbins D000383 | rep | NJ | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9512 | 9512 | Robert Hamilton H000117 | rep | NJ | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9519 | 9519 | Hannibal Hamlin H000121 | sen | ME | 1869-03-04 | 1875-03-03 | 1 | Republican |
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);