legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
346 rows where "start" is on date 1875-12-06 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18094 | 18094 | Joseph Cannon C000121 | rep | IL | 1875-12-06 | 1877-03-03 | Republican | 14 | |||||||||||||
15655 | 15655 | Charles Morgan M000944 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
15104 | 15104 | William Frye F000398 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
15094 | 15094 | Stephen Elkins E000110 | rep | NM | 1875-12-06 | 1877-03-03 | Republican | -1 | |||||||||||||
14960 | 14960 | William Whyte W000435 | sen | MD | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
14831 | 14831 | Hernando Money M000854 | rep | MS | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
14688 | 14688 | Eugene Hale H000029 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | 5 | |||||||||||||
14439 | 14439 | Thomas Platt P000383 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 28 | |||||||||||||
14120 | 14120 | Thomas Patterson P000130 | rep | CO | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
14010 | 14010 | Charles Hooker H000758 | rep | MS | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
14004 | 14004 | George Hoar H000654 | rep | MA | 1875-12-06 | 1877-03-03 | Republican | 9 | |||||||||||||
13863 | 13863 | Joseph Blackburn B000508 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
13629 | 13629 | Lorenzo Danford D000028 | rep | OH | 1875-12-06 | 1877-03-03 | Republican | 16 | |||||||||||||
13616 | 13616 | Francis Cockrell C000576 | sen | MO | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
13577 | 13577 | Richard Bland B000544 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
13341 | 13341 | William Holman H000732 | rep | IN | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
12980 | 12980 | David Culberson C000964 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
12796 | 12796 | William Springer S000757 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 12 | |||||||||||||
12762 | 12762 | James Reilly R000153 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 13 | |||||||||||||
12719 | 12719 | Charles O’Neill O000093 | rep | PA | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
12699 | 12699 | William Mutchler M001125 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
12623 | 12623 | Thomas Henderson H000489 | rep | IL | 1875-12-06 | 1877-03-03 | Republican | 6 | |||||||||||||
12413 | 12413 | Henry Blair B000524 | rep | NH | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
12378 | 12378 | Roger Mills M000777 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
12373 | 12373 | Eppa Hunton H000999 | rep | VA | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
12358 | 12358 | Scott Wike W000451 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 11 | |||||||||||||
12164 | 12164 | William Forney F000280 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
12088 | 12088 | James Blount B000568 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
12024 | 12024 | Washington Whitthorne W000429 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
11918 | 11918 | Samuel Randall R000039 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
11826 | 11826 | Levi Maish M000072 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 19 | |||||||||||||
11791 | 11791 | William Kelley K000062 | rep | PA | 1875-12-06 | 1877-03-03 | Republican | 4 | |||||||||||||
11764 | 11764 | Randall Gibson G000165 | rep | LA | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
11742 | 11742 | Mark Dunnell D000555 | rep | MN | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
11698 | 11698 | Samuel Cox C000839 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
11657 | 11657 | Lucien Caswell C000245 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
11582 | 11582 | Nathaniel Banks B000116 | rep | MA | 1875-12-06 | 1877-03-03 | Independent | 5 | |||||||||||||
11551 | 11551 | William Woodburn W000710 | rep | NV | 1875-12-06 | 1877-03-03 | Republican | 0 | |||||||||||||
11483 | 11483 | John Reagan R000098 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
11464 | 11464 | Algernon Paddock P000010 | sen | NE | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
11365 | 11365 | Charles Farwell F000037 | rep | IL | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
11360 | 11360 | George Edmunds E000056 | sen | VT | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
11345 | 11345 | Henry Dawes D000148 | sen | MA | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
11293 | 11293 | Archibald Bliss B000558 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
11244 | 11244 | John Wait W000025 | rep | CT | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
11232 | 11232 | John Tucker T000401 | rep | VA | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
11227 | 11227 | James Throckmorton T000246 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
11215 | 11215 | Horace Strait S000988 | rep | MN | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
11196 | 11196 | Robert Smalls S000502 | rep | SC | 1875-12-06 | 1877-03-03 | Republican | 5 | |||||||||||||
11190 | 11190 | Otho Singleton S000445 | rep | MS | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
11152 | 11152 | Henry Payne P000151 | rep | OH | 1875-12-06 | 1877-03-03 | Democrat | 20 | |||||||||||||
11136 | 11136 | William Morrison M001000 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 17 | |||||||||||||
11078 | 11078 | Abram Hewitt H000552 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
11071 | 11071 | Henry Harris H000239 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
11021 | 11021 | John Eden E000042 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 15 | |||||||||||||
10986 | 10986 | George Cabell C000004 | rep | VA | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
10945 | 10945 | Hiram Young Y000037 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
10937 | 10937 | James Wilson W000590 | rep | IA | 1875-12-06 | 1877-03-03 | Republican | 5 | |||||||||||||
10930 | 10930 | John White W000381 | rep | KY | 1875-12-06 | 1877-03-03 | Republican | 9 | |||||||||||||
10920 | 10920 | Robert Vance V000019 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
10896 | 10896 | Abraham Smith S000509 | rep | PA | 1875-12-06 | 1877-03-03 | Republican | 9 | |||||||||||||
10878 | 10878 | Alfred Scales S000103 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
10802 | 10802 | Martin Maginnis M000050 | rep | MT | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
10798 | 10798 | Edmund Mackey M000024 | rep | SC | 1875-12-06 | 1877-03-03 | Ind. Republican | 2 | |||||||||||||
10787 | 10787 | Lucius Lamar L000030 | rep | MS | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
10776 | 10776 | John Kasson K000018 | rep | IA | 1875-12-06 | 1877-03-03 | Republican | 7 | |||||||||||||
10764 | 10764 | Frank Hurd H001002 | rep | OH | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
10756 | 10756 | James Hopkins H000775 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 22 | |||||||||||||
10748 | 10748 | Goldsmith Hewitt H000553 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
10733 | 10733 | John Hancock H000150 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
10709 | 10709 | Ezekiel Ellis E000134 | rep | LA | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
10706 | 10706 | William Eaton E000028 | sen | CT | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10697 | 10697 | George Dibrell D000301 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
10656 | 10656 | Aylett Buckner B001031 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 13 | |||||||||||||
10633 | 10633 | James Belford B000326 | rep | CO | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
10629 | 10629 | John Bagley B000033 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 15 | |||||||||||||
10612 | 10612 | Fernando Wood W000694 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 9 | |||||||||||||
10597 | 10597 | Benjamin Wilson W000569 | rep | WV | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
10590 | 10590 | Charles Williams W000492 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
10558 | 10558 | Alexander Stephens S000854 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
10542 | 10542 | William Sparks S000704 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 16 | |||||||||||||
10522 | 10522 | Miles Ross R000452 | rep | NJ | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
10501 | 10501 | James Phelps P000295 | rep | CT | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
10496 | 10496 | Horace Page P000017 | rep | CA | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
10462 | 10462 | Samuel McMillan M000570 | sen | MN | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10452 | 10452 | James McDill M000407 | rep | IA | 1875-12-06 | 1877-03-03 | Republican | 8 | |||||||||||||
10446 | 10446 | Samuel Maxey M000265 | sen | TX | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10439 | 10439 | John Lynch L000533 | rep | MS | 1875-12-06 | 1877-03-03 | Republican | 6 | |||||||||||||
10426 | 10426 | Elbridge Lapham L000092 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 27 | |||||||||||||
10420 | 10420 | James Knott K000290 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
10412 | 10412 | Charles Joyce J000275 | rep | VT | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
10404 | 10404 | Charles Jones J000214 | sen | FL | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10393 | 10393 | Jay Hubbell H000894 | rep | MI | 1875-12-06 | 1877-03-03 | Republican | 9 | |||||||||||||
10388 | 10388 | John House H000819 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
10370 | 10370 | Benjamin Harris H000233 | rep | MA | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
10366 | 10366 | Augustus Hardenbergh H000183 | rep | NJ | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
10358 | 10358 | Thomas Gunter G000527 | rep | AR | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
10345 | 10345 | Jesse Finley F000134 | rep | FL | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
10325 | 10325 | Chester Darrall D000062 | rep | LA | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
10313 | 10313 | William Crapo C000881 | rep | MA | 1875-12-06 | 1877-03-03 | Republican | 1 |
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);