legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
415 rows where "end" is on date 1895-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20954 | 20954 | Henry Tucker T000399 | rep | VA | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
20231 | 20231 | Henry Cooper C000752 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
20007 | 20007 | Claude Swanson S001094 | rep | VA | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
19269 | 19269 | Charles Curtis C001008 | rep | KS | 1893-08-07 | 1895-03-03 | Republican | 4 | |||||||||||||
18959 | 18959 | Frederick Gillett G000201 | rep | MA | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
18595 | 18595 | William Cockran C000575 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
18102 | 18102 | Joseph Cannon C000121 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 15 | |||||||||||||
17611 | 17611 | James Clark C000437 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
17549 | 17549 | John Bankhead B000110 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
17504 | 17504 | John Williams W000521 | rep | MS | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
17480 | 17480 | Joshua Talbott T000021 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
17310 | 17310 | William Jones J000259 | rep | VA | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
16973 | 16973 | Marcus Smith S000589 | rep | AZ | 1893-08-07 | 1895-03-03 | Democrat | 0 | |||||||||||||
16904 | 16904 | Francis Newlands N000069 | rep | NV | 1893-08-07 | 1895-03-03 | Democrat | 0 | |||||||||||||
16513 | 16513 | Sereno Payne P000153 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 28 | |||||||||||||
16262 | 16262 | Richard Bartholdt B000196 | rep | MO | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
16172 | 16172 | Isidor Rayner R000086 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
16081 | 16081 | Samuel McCall M000305 | rep | MA | 1893-08-07 | 1895-03-03 | Republican | 8 | |||||||||||||
16056 | 16056 | Henry Loudenslager L000450 | rep | NJ | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
15972 | 15972 | John Gardner G000057 | rep | NJ | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
15920 | 15920 | John Dalzell D000016 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 22 | |||||||||||||
15861 | 15861 | Henry Bingham B000469 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
15802 | 15802 | Irving Wanger W000122 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
15770 | 15770 | James Tawney T000060 | rep | MN | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
15658 | 15658 | Charles Morgan M000944 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 15 | |||||||||||||
15601 | 15601 | Leonidas Livingston L000368 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
15559 | 15559 | Martin Johnson J000162 | rep | ND | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
15547 | 15547 | John Hull H000942 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
15441 | 15441 | William Ellis E000138 | rep | OR | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
15420 | 15420 | David De Armond D000167 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
15291 | 15291 | George Smith S000541 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 20 | |||||||||||||
15278 | 15278 | James Sherman S000345 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 25 | |||||||||||||
15260 | 15260 | John Reyburn R000168 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 4 | |||||||||||||
15247 | 15247 | Thomas Paynter P000156 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
15226 | 15226 | Adolph Meyer M000679 | rep | LA | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
15221 | 15221 | Anselm McLaurin M000542 | sen | MS | 1894-01-01 | 1895-03-03 | 2 | Democrat | |||||||||||||
15145 | 15145 | William Hepburn H000523 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 8 | |||||||||||||
15109 | 15109 | William Frye F000398 | sen | ME | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
15083 | 15083 | Jonathan Dolliver D000404 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
15068 | 15068 | Robert Davey D000081 | rep | LA | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
15060 | 15060 | Shelby Cullom C000973 | sen | IL | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
15053 | 15053 | William Crawford C000896 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
15042 | 15042 | Robert Cousins C000811 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
15035 | 15035 | Samuel Cooper C000761 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
14970 | 14970 | Joseph Bailey B000044 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
14935 | 14935 | James Wadsworth W000011 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 30 | |||||||||||||
14891 | 14891 | Joseph Sibley S000398 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 26 | |||||||||||||
14874 | 14874 | Samuel Robertson R000324 | rep | LA | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
14836 | 14836 | Hernando Money M000854 | rep | MS | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
14811 | 14811 | James McCleary M000326 | rep | MN | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
14803 | 14803 | Benjamin Marsh M000145 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
14793 | 14793 | Thaddeus Mahon M000066 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 18 | |||||||||||||
14786 | 14786 | John Little L000352 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
14773 | 14773 | Rufus Lester L000255 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
14761 | 14761 | John Lacey L000010 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 6 | |||||||||||||
14721 | 14721 | Robert Hitt H000649 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 6 | |||||||||||||
14711 | 14711 | Binger Hermann H000531 | rep | OR | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
14678 | 14678 | Charles Grosvenor G000497 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
14656 | 14656 | Loren Fletcher F000202 | rep | MN | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
14610 | 14610 | Julius Burrows B001142 | rep | MI | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
14563 | 14563 | Joseph Babcock B000004 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
14548 | 14548 | Robert Adams A000044 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
14530 | 14530 | James Williams W000508 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 19 | |||||||||||||
14510 | 14510 | Henry Van Voorhis V000062 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 15 | |||||||||||||
14486 | 14486 | Farish Tate T000046 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
14454 | 14454 | James Richardson R000222 | rep | TN | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
14410 | 14410 | James McCreary M000382 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
14398 | 14398 | Stephen Mallory M000085 | rep | FL | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
14389 | 14389 | John Maddox M000040 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
14373 | 14373 | Asbury Latimer L000114 | rep | SC | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
14351 | 14351 | Albert Hopkins H000770 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
14325 | 14325 | Charles Gillet G000199 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 29 | |||||||||||||
14292 | 14292 | Hugh Dinsmore D000358 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
14197 | 14197 | William Talbert T000016 | rep | SC | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
14148 | 14148 | Charles Russell R000521 | rep | CT | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
14131 | 14131 | George Ray R000076 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 26 | |||||||||||||
14107 | 14107 | Howard Mutchler M001124 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
14094 | 14094 | John Morgan M000954 | sen | AL | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
14074 | 14074 | David Mercer M000643 | rep | NE | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
14069 | 14069 | Thomas McRae M000597 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
14062 | 14062 | James McMillan M000567 | sen | MI | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
14057 | 14057 | Philip McCulloch M000391 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
14052 | 14052 | Eugene Loud L000448 | rep | CA | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
14026 | 14026 | Charles Joy J000274 | rep | MO | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
14017 | 14017 | Charles Hooker H000758 | rep | MS | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
14007 | 14007 | George Hoar H000654 | sen | MA | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13995 | 13995 | David Henderson H000478 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
13978 | 13978 | Galusha Grow G000507 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | -1 | |||||||||||||
13959 | 13959 | Dennis Flynn F000226 | rep | OK | 1893-08-07 | 1895-03-03 | Republican | -1 | |||||||||||||
13925 | 13925 | Amos Cummings C000983 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 11 | |||||||||||||
13889 | 13889 | Marriott Brosius B000892 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
13882 | 13882 | Jacob Bromwell B000866 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
13876 | 13876 | Charles Boutelle B000673 | rep | ME | 1893-08-07 | 1895-03-03 | Republican | 4 | |||||||||||||
13859 | 13859 | James Berry B000418 | sen | AR | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
13850 | 13850 | John Bell B000341 | rep | CO | 1893-08-07 | 1895-03-03 | Populist | 2 | |||||||||||||
13826 | 13826 | Joseph Wheeler W000338 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
13809 | 13809 | William Terry T000137 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
13794 | 13794 | Jesse Stallings S000784 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
13785 | 13785 | Gaston Robbins R000299 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
13779 | 13779 | Thomas Reed R000128 | rep | ME | 1893-08-07 | 1895-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);