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 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8619 | 8619 | William Hamilton H000118 | sen | MD | 1869-03-04 | 1875-03-03 | 1 | Democrat | |||||||||||||
8732 | 8732 | John Stockton S000939 | sen | NJ | 1869-03-04 | 1875-03-03 | 1 | Democrat | |||||||||||||
9070 | 9070 | George Adams A000035 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9076 | 9076 | Stevenson Archer A000274 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9078 | 9078 | Moses Armstrong A000283 | rep | DK | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9080 | 9080 | William Arthur A000304 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9090 | 9090 | John Berry B000419 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 14 | |||||||||||||
9098 | 9098 | Rees Bowen B000685 | rep | VA | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9107 | 9107 | James Brooks B000881 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9132 | 9132 | Abram Comingo C000658 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
9141 | 9141 | Edward Crossland C000933 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9147 | 9147 | Alexander Davis D000091 | rep | VA | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9150 | 9150 | David De Witt D000285 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 14 | |||||||||||||
9164 | 9164 | Charles Eldredge E000103 | rep | WI | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9173 | 9173 | William Finck F000118 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 12 | |||||||||||||
9185 | 9185 | John Hager H000016 | sen | CA | 1873-12-01 | 1875-03-03 | 1 | Democrat | |||||||||||||
9199 | 9199 | William Herndon H000535 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9217 | 9217 | Hugh Jewett J000105 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 12 | |||||||||||||
9222 | 9222 | Charles Kendall K000090 | rep | NV | 1873-12-01 | 1875-03-03 | Democrat | 0 | |||||||||||||
9224 | 9224 | Charles Lamison L000039 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9230 | 9230 | Effingham Lawrence L000132 | rep | LA | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9234 | 9234 | James Leach L000170 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9243 | 9243 | John Magee M000048 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 15 | |||||||||||||
9250 | 9250 | Samuel Marshall M000160 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 19 | |||||||||||||
9263 | 9263 | Obadiah McFadden M000435 | rep | WA | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9270 | 9270 | William McLean M000553 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9277 | 9277 | Alexander Mitchell M000802 | rep | WI | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
9306 | 9306 | Hosea Parker P000057 | rep | NH | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9315 | 9315 | Eli Perry P000242 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 15 | |||||||||||||
9321 | 9321 | Morgan Rawls R000074 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9324 | 9324 | William Read R000094 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
9342 | 9342 | Richard Schell S000114 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9366 | 9366 | Joseph Sloss S000498 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9378 | 9378 | Robert Speer S000713 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 17 | |||||||||||||
9386 | 9386 | Elisha Standiford S000790 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9408 | 9408 | Thomas Whitehead W000401 | rep | VA | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9421 | 9421 | Asa Willie W000555 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9425 | 9425 | Simeon Wolfe W000677 | rep | IN | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
9444 | 9444 | Thomas Ashe A000309 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9458 | 9458 | John Brown B000933 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9475 | 9475 | John Caldwell C000035 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9483 | 9483 | Bernard Caulfield C000255 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9512 | 9512 | Robert Hamilton H000117 | rep | NJ | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9588 | 9588 | Charles Milliken M000768 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9595 | 9595 | Lawrence Neal N000014 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9598 | 9598 | William O’Brien O000017 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9630 | 9630 | John Schumaker S000147 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9642 | 9642 | William Steele S000840 | rep | WY | 1873-12-01 | 1875-03-03 | Democrat | 0 | |||||||||||||
9644 | 9644 | William Stone S000967 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9657 | 9657 | Allen Thurman T000251 | sen | OH | 1869-03-04 | 1875-03-03 | 1 | Democrat | |||||||||||||
9695 | 9695 | John Whitehouse W000405 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 13 | |||||||||||||
9712 | 9712 | William Barnum B000166 | rep | CT | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9741 | 9741 | Hiram Bell B000336 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9776 | 9776 | Thomas Crittenden C000913 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9789 | 9789 | Milton Durham D000572 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
9823 | 9823 | De Giddings G000166 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9825 | 9825 | John Glover G000245 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 12 | |||||||||||||
9840 | 9840 | Robert Hatcher H000341 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9847 | 9847 | Frank Hereford H000527 | rep | WV | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9871 | 9871 | Robert Knapp K000281 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
9878 | 9878 | John Luttrell L000522 | rep | CA | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9900 | 9900 | Clarkson Potter P000461 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
9917 | 9917 | William Robbins R000302 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9932 | 9932 | Milton Sayler S000101 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9938 | 9938 | Milton Southard S000688 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 13 | |||||||||||||
9949 | 9949 | Thomas Swann S001092 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9966 | 9966 | Alfred Waddell W000002 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
10020 | 10020 | John Bright B000836 | rep | TN | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
10042 | 10042 | Hiester Clymer C000539 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
10094 | 10094 | John Harris H000247 | rep | VA | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
10215 | 10215 | Erastus Wells W000282 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
10259 | 10259 | John Atkins A000327 | rep | TN | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
10264 | 10264 | Thomas Bayard B000253 | sen | DE | 1869-03-04 | 1875-03-03 | 1 | Democrat | |||||||||||||
10292 | 10292 | John Clark C000442 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
10306 | 10306 | Philip Cook C000724 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
10357 | 10357 | Thomas Gunter G000527 | rep | AR | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
10557 | 10557 | Alexander Stephens S000854 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
10611 | 10611 | Fernando Wood W000694 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 10 | |||||||||||||
10655 | 10655 | Aylett Buckner B001031 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 13 | |||||||||||||
10732 | 10732 | John Hancock H000150 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
10786 | 10786 | Lucius Lamar L000030 | rep | MS | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
10801 | 10801 | Martin Maginnis M000050 | rep | MT | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
10919 | 10919 | Robert Vance V000019 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
11020 | 11020 | John Eden E000042 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 15 | |||||||||||||
11056 | 11056 | John Hailey H000023 | rep | ID | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
11070 | 11070 | Henry Harris H000239 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
11135 | 11135 | William Morrison M001000 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 17 | |||||||||||||
11211 | 11211 | John Storm S000975 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
11273 | 11273 | Ephraim Wilson W000577 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
11602 | 11602 | James Beck B000289 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
11697 | 11697 | Samuel Cox C000839 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
11917 | 11917 | Samuel Randall R000039 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
12023 | 12023 | Washington Whitthorne W000429 | rep | TN | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
12087 | 12087 | James Blount B000568 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 6 |
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);