legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
409 rows where "end" is on date 1903-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13289 | 13289 | William Deboe D000182 | sen | KY | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
13318 | 13318 | William Harris H000258 | sen | KS | 1897-03-15 | 1903-03-03 | 3 | Populist | |||||||||||||
13322 | 13322 | Henry Heitfeld H000458 | sen | ID | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13366 | 13366 | James Jones J000231 | sen | AR | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13371 | 13371 | John Jones J000237 | sen | NV | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
13401 | 13401 | John McLaurin M000543 | sen | SC | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13455 | 13455 | Jeter Pritchard P000545 | sen | NC | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
13460 | 13460 | Joseph Rawlins R000073 | sen | UT | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13508 | 13508 | George Turner T000420 | sen | WA | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13518 | 13518 | George Vest V000091 | sen | MO | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13529 | 13529 | George Wellington W000279 | sen | MD | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
13542 | 13542 | Joseph Simon S000422 | sen | OR | 1898-01-01 | 1903-03-03 | 3 | Republican | |||||||||||||
13844 | 13844 | Henry Allen A000125 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
13845 | 13845 | Henry Aplin A000265 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
13849 | 13849 | Samuel Barney B000163 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
13854 | 13854 | John Bell B000341 | rep | CO | 1901-12-02 | 1903-03-03 | Populist | 2 | |||||||||||||
13856 | 13856 | John Bellamy B000349 | rep | NC | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
13857 | 13857 | Oliver Belmont B000352 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 13 | |||||||||||||
13862 | 13862 | Alexander Billmeyer B000465 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
13880 | 13880 | Charles Boutelle B000673 | rep | ME | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
13881 | 13881 | Henry Bristow B000843 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
13886 | 13886 | Jacob Bromwell B000866 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
13893 | 13893 | Marriott Brosius B000892 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
13897 | 13897 | Melville Bull B001048 | rep | RI | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
13900 | 13900 | Robert Burke B001097 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
13907 | 13907 | Joseph Conry C000706 | rep | MA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
13908 | 13908 | Frank Coombs C000741 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
13911 | 13911 | James Cooney C000744 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
13915 | 13915 | John Corliss C000779 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
13917 | 13917 | Thomas Creamer C000899 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
13921 | 13921 | Rousseau Crump C000957 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
13929 | 13929 | Amos Cummings C000983 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
13931 | 13931 | Herman Dahle D000005 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
13934 | 13934 | Reese De Graffenreid D000194 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
13943 | 13943 | Frank Eddy E000038 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
13944 | 13944 | Caldwell Edwards E000061 | rep | MT | 1901-12-02 | 1903-03-03 | Populist | 1 | |||||||||||||
13951 | 13951 | William Elliott E000129 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
13953 | 13953 | Louis Emerson E000173 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 23 | |||||||||||||
13954 | 13954 | John Feely F000058 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
13955 | 13955 | De Flanagan F000185 | rep | NJ | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
13958 | 13958 | William Fleming F000198 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
13962 | 13962 | Dennis Flynn F000226 | rep | OK | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
13965 | 13965 | Andrew Fox F000330 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
13967 | 13967 | Thomas Glenn G000239 | rep | ID | 1901-12-02 | 1903-03-03 | Populist | 1 | |||||||||||||
13969 | 13969 | Robert Gordon G000314 | rep | OH | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
13971 | 13971 | Henry Green G000411 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
13982 | 13982 | Galusha Grow G000507 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
13984 | 13984 | James Hall H000054 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 28 | |||||||||||||
13985 | 13985 | Harry Hanbury H000143 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 4 | |||||||||||||
13989 | 13989 | Joel Heatwole H000434 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
13999 | 13999 | David Henderson H000478 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14000 | 14000 | Patrick Henry H000513 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14018 | 14018 | Charles Hooker H000758 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14019 | 14019 | Harvey Irwin I000041 | rep | KY | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
14021 | 14021 | Summers Jack J000001 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 21 | |||||||||||||
14022 | 14022 | Alfred Jackson J000003 | rep | KS | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14025 | 14025 | Thomas Jett J000102 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 18 | |||||||||||||
14030 | 14030 | Charles Joy J000274 | rep | MO | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14032 | 14032 | Frederick Kern K000131 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 21 | |||||||||||||
14036 | 14036 | Rudolph Kleberg K000258 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 11 | |||||||||||||
14040 | 14040 | William Knox K000299 | rep | MA | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
14048 | 14048 | Samuel Lanham L000078 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
14049 | 14049 | Montague Lessler L000253 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
14050 | 14050 | Robert Lewis L000292 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 19 | |||||||||||||
14056 | 14056 | Eugene Loud L000448 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
14061 | 14061 | Philip McCulloch M000391 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14064 | 14064 | James McMillan M000567 | sen | MI | 1901-12-02 | 1903-03-03 | 2 | Republican | |||||||||||||
14073 | 14073 | Thomas McRae M000597 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14078 | 14078 | David Mercer M000643 | rep | NE | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14079 | 14079 | J. Mickey M000694 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 15 | |||||||||||||
14085 | 14085 | James Moody M000880 | rep | NC | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
14087 | 14087 | Malcolm Moody M000882 | rep | OR | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14091 | 14091 | William Moody M000883 | rep | MA | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
14099 | 14099 | Robert Morris M000986 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
14100 | 14100 | John Moss M001036 | rep | KY | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14106 | 14106 | Nicholas Muller M001071 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14108 | 14108 | Howard Mutchler M001124 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
14110 | 14110 | Henry Naphen N000004 | rep | MA | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
14112 | 14112 | William Neville N000056 | rep | NE | 1901-12-02 | 1903-03-03 | Populist | 6 | |||||||||||||
14115 | 14115 | James Norton N000150 | rep | OH | 1901-12-02 | 1903-03-03 | Democrat | 13 | |||||||||||||
14124 | 14124 | Rufus Polk P000410 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
14125 | 14125 | Cornelius Pugsley P000565 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 16 | |||||||||||||
14135 | 14135 | George Ray R000076 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 26 | |||||||||||||
14139 | 14139 | Walter Reeves R000139 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14141 | 14141 | William Rhea R000183 | rep | VA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
14143 | 14143 | John Robinson R000345 | rep | NE | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14144 | 14144 | John Rumple R000504 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14152 | 14152 | Charles Russell R000521 | rep | CT | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14154 | 14154 | Joshua Salmon S000017 | rep | NJ | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14155 | 14155 | Charles Schirm S000127 | rep | MD | 1901-12-02 | 1903-03-03 | Republican | 4 | |||||||||||||
14156 | 14156 | Thomas Selby S000231 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 16 | |||||||||||||
14159 | 14159 | William Shattuc S000300 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14161 | 14161 | Albert Shaw S000302 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
14164 | 14164 | Carlos Shelden S000321 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 12 | |||||||||||||
14166 | 14166 | John Sheppard S000336 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14169 | 14169 | Joseph Showalter S000385 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 25 | |||||||||||||
14171 | 14171 | Henry Smith S000547 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14173 | 14173 | Charles Snodgrass S000654 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14176 | 14176 | William Stark S000811 | rep | NE | 1901-12-02 | 1903-03-03 | Populist | 4 | |||||||||||||
14184 | 14184 | George Steele S000830 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 11 |
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);