legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
451 rows where "start" is on date 1911-04-04 sorted by end
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17656 | 17656 | Davis Elkins E000109 | sen | WV | 1911-04-04 | 1911-12-31 | 2 | Republican | |||||||||||||
15971 | 15971 | David Foster F000300 | rep | VT | 1911-04-04 | 1912-03-21 | Republican | 1 | |||||||||||||
15831 | 15831 | Theron Akin A000071 | rep | NY | 1911-04-04 | 1913-03-03 | Progressive Republican | 25 | |||||||||||||
15836 | 15836 | Butler Ames A000173 | rep | MA | 1911-04-04 | 1913-03-03 | Republican | 5 | |||||||||||||
15838 | 15838 | Carl Anderson A000182 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 13 | |||||||||||||
15842 | 15842 | William Andrews A000252 | rep | NM | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
15846 | 15846 | John Andrus A000254 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 19 | |||||||||||||
15847 | 15847 | Steven Ayres A000353 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 18 | |||||||||||||
15853 | 15853 | Arthur Bates B000230 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 25 | |||||||||||||
15870 | 15870 | Henry Bingham B000469 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
15872 | 15872 | John Boehne B000587 | rep | IN | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
15873 | 15873 | Charles Bowman B000703 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 11 | |||||||||||||
15878 | 15878 | Thomas Bradley B000747 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 20 | |||||||||||||
15886 | 15886 | William Brantley B000770 | rep | GA | 1911-04-04 | 1913-03-03 | Democrat | 11 | |||||||||||||
15888 | 15888 | Theron Catlin C000252 | rep | MO | 1911-04-04 | 1913-03-03 | Republican | 11 | |||||||||||||
15899 | 15899 | Richard Connell C000686 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 21 | |||||||||||||
15901 | 15901 | James Cox C000835 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
15909 | 15909 | Edgar Crumpacker C000958 | rep | IN | 1911-04-04 | 1913-03-03 | Republican | 10 | |||||||||||||
15915 | 15915 | Frank Currier C000999 | rep | NH | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
15916 | 15916 | George Curry C001002 | rep | NM | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
15929 | 15929 | John Dalzell D000016 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 30 | |||||||||||||
15930 | 15930 | James Daugherty D000066 | rep | MO | 1911-04-04 | 1913-03-03 | Democrat | 15 | |||||||||||||
15931 | 15931 | Henry De Forest D000189 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 23 | |||||||||||||
15934 | 15934 | Matthew Denver D000262 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
15936 | 15936 | William Dickson D000334 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
15938 | 15938 | Francis Dodds D000392 | rep | MI | 1911-04-04 | 1913-03-03 | Republican | 11 | |||||||||||||
15944 | 15944 | William Draper D000489 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 22 | |||||||||||||
15951 | 15951 | Michael Driscoll D000502 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 29 | |||||||||||||
15957 | 15957 | John Dwight D000581 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 30 | |||||||||||||
15961 | 15961 | James Ellerbe E000113 | rep | SC | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
15962 | 15962 | Lynden Evans E000252 | rep | IL | 1911-04-04 | 1913-03-03 | Democrat | 9 | |||||||||||||
15965 | 15965 | Charles Fornes F000277 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 11 | |||||||||||||
15981 | 15981 | John Gardner G000057 | rep | NJ | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
15982 | 15982 | Obadiah Gardner G000060 | sen | ME | 1911-04-04 | 1913-03-03 | 2 | Democrat | |||||||||||||
15984 | 15984 | Patrick Gill G000191 | rep | MO | 1911-04-04 | 1913-03-03 | Democrat | 11 | |||||||||||||
15987 | 15987 | George Gordon G000310 | rep | TN | 1911-04-04 | 1913-03-03 | Democrat | 10 | |||||||||||||
15988 | 15988 | Samuel Gould G000343 | rep | ME | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
15989 | 15989 | Curtis Gregg G000443 | rep | PA | 1911-04-04 | 1913-03-03 | Democrat | 22 | |||||||||||||
15990 | 15990 | John Hamilton H000112 | rep | WV | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
15992 | 15992 | Louis Hanna H000162 | rep | ND | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
15993 | 15993 | Robert Harris H000251 | rep | MA | 1911-04-04 | 1913-03-03 | Republican | 14 | |||||||||||||
15994 | 15994 | Jesse Hartman H000301 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 19 | |||||||||||||
15996 | 15996 | William Heald H000422 | rep | DE | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
16005 | 16005 | Edward Henry H000505 | rep | CT | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16009 | 16009 | Edwin Higgins H000578 | rep | CT | 1911-04-04 | 1913-03-03 | Republican | 3 | |||||||||||||
16012 | 16012 | Leonard Howland H000871 | rep | OH | 1911-04-04 | 1913-03-03 | Republican | 20 | |||||||||||||
16016 | 16016 | Elbert Hubbard H000882 | rep | IA | 1911-04-04 | 1913-03-03 | Republican | 11 | |||||||||||||
16017 | 16017 | Fred Jackson J000011 | rep | KS | 1911-04-04 | 1913-03-03 | Republican | 4 | |||||||||||||
16020 | 16020 | Nathan Kendall K000096 | rep | IA | 1911-04-04 | 1913-03-03 | Republican | 6 | |||||||||||||
16023 | 16023 | George Kipp K000232 | rep | PA | 1911-04-04 | 1913-03-03 | Democrat | 14 | |||||||||||||
16025 | 16025 | Arthur Kopp K000313 | rep | WI | 1911-04-04 | 1913-03-03 | Republican | 3 | |||||||||||||
16033 | 16033 | John Lamb L000033 | rep | VA | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
16035 | 16035 | James Latta L000117 | rep | NE | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
16043 | 16043 | George Lawrence L000133 | rep | MA | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16047 | 16047 | Benito Legarda Y Tuason L000218 | rep | PI | 1911-04-04 | 1913-03-03 | 0 | ||||||||||||||
16053 | 16053 | George Lindsay L000324 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
16055 | 16055 | Martin Littleton L000359 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16065 | 16065 | Henry Loudenslager L000450 | rep | NJ | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16070 | 16070 | Robert Macon M000035 | rep | AR | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16073 | 16073 | Edmond Madison M000042 | rep | KS | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
16076 | 16076 | George Malby M000077 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 26 | |||||||||||||
16078 | 16078 | Charles Matthews M000252 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 24 | |||||||||||||
16080 | 16080 | Dannite Mays M000289 | rep | FL | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
16090 | 16090 | Samuel McCall M000305 | rep | MA | 1911-04-04 | 1913-03-03 | Republican | 8 | |||||||||||||
16095 | 16095 | George McCreary M000381 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 6 | |||||||||||||
16098 | 16098 | John McHenry M000470 | rep | PA | 1911-04-04 | 1913-03-03 | Democrat | 16 | |||||||||||||
16102 | 16102 | James McKinney M000524 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 14 | |||||||||||||
16107 | 16107 | Henry McMorran M000576 | rep | MI | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
16108 | 16108 | Alexander Mitchell M000803 | rep | KS | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
16113 | 16113 | Reuben Moon M000886 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 4 | |||||||||||||
16117 | 16117 | John Moore M000904 | rep | TX | 1911-04-04 | 1913-03-03 | Democrat | 8 | |||||||||||||
16120 | 16120 | Elmer Morse M001008 | rep | WI | 1911-04-04 | 1913-03-03 | Republican | 10 | |||||||||||||
16127 | 16127 | James Needham N000021 | rep | CA | 1911-04-04 | 1913-03-03 | Republican | 6 | |||||||||||||
16129 | 16129 | George Nixon N000114 | sen | NV | 1911-04-04 | 1913-03-03 | 1 | Republican | |||||||||||||
16132 | 16132 | Frank Nye N000175 | rep | MN | 1911-04-04 | 1913-03-03 | Republican | 5 | |||||||||||||
16143 | 16143 | Marlin Olmsted O000079 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 18 | |||||||||||||
16144 | 16144 | Thomas Parran P000077 | rep | MD | 1911-04-04 | 1913-03-03 | Republican | 5 | |||||||||||||
16146 | 16146 | Charles Pickett P000325 | rep | IA | 1911-04-04 | 1913-03-03 | Republican | 3 | |||||||||||||
16149 | 16149 | Charles Pray P000508 | rep | MT | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16158 | 16158 | George Prince P000538 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 15 | |||||||||||||
16163 | 16163 | Arsène Pujo P000567 | rep | LA | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16169 | 16169 | Choice Randell R000042 | rep | TX | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
16174 | 16174 | Isidor Rayner R000086 | sen | MD | 1911-04-04 | 1913-03-03 | 1 | Democrat | |||||||||||||
16175 | 16175 | William Redfield R000105 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
16176 | 16176 | Rollin Rees R000133 | rep | KS | 1911-04-04 | 1913-03-03 | Republican | 5 | |||||||||||||
16177 | 16177 | William Reyburn R000169 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
16179 | 16179 | Atterson Rucker R000492 | rep | CO | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16181 | 16181 | James Simmons S000418 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 34 | |||||||||||||
16185 | 16185 | Sylvester Smith S000614 | rep | CA | 1911-04-04 | 1913-03-03 | Republican | 8 | |||||||||||||
16192 | 16192 | Walter Smith S000623 | rep | IA | 1911-04-04 | 1913-03-03 | Republican | 9 | |||||||||||||
16193 | 16193 | Peter Speer S000712 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 28 | |||||||||||||
16194 | 16194 | Edmund Stack S000771 | rep | IL | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
16203 | 16203 | William Sulzer S001065 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 10 | |||||||||||||
16207 | 16207 | Edwin Sweet S001107 | rep | MI | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
16211 | 16211 | Edward Taylor T000071 | rep | OH | 1911-04-04 | 1913-03-03 | Republican | 12 | |||||||||||||
16212 | 16212 | John Thayer T000147 | rep | MA | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
16215 | 16215 | Napoleon Thistlewood T000154 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 25 | |||||||||||||
16217 | 16217 | Robert Turnbull T000413 | rep | VA | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
16218 | 16218 | George Utter U000035 | rep | RI | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
16225 | 16225 | Edward Vreeland V000122 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 37 |
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);