legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1917-03-03 sorted by start
This data as json, copyable, CSV (advanced)
Suggested facets: party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15887 | 15887 | Nathan Bryan B000992 | sen | FL | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
15889 | 15889 | William Chilton C000360 | sen | WV | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
15892 | 15892 | Moses Clapp C000414 | sen | MN | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
15898 | 15898 | Clarence Clark C000425 | sen | WY | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16018 | 16018 | Charles Johnson J000124 | sen | ME | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16021 | 16021 | John Kern K000132 | sen | IN | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16044 | 16044 | Luke Lea L000165 | sen | TN | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16054 | 16054 | Henry Lippitt L000343 | sen | RI | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16077 | 16077 | James Martine M000205 | sen | NJ | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16133 | 16133 | James O’Gorman O000050 | sen | NY | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16135 | 16135 | George Oliver O000073 | sen | PA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16206 | 16206 | George Sutherland S001080 | sen | UT | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16239 | 16239 | John Works W000743 | sen | CA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16242 | 16242 | Henry du Pont D000559 | sen | DE | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17127 | 17127 | Charles Culberson C000963 | sen | TX | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17289 | 17289 | Gilbert Hitchcock H000645 | sen | NE | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17349 | 17349 | Porter McCumber M000397 | sen | ND | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17360 | 17360 | Henry Myers M001129 | sen | MT | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17374 | 17374 | Carroll Page P000014 | sen | VT | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17377 | 17377 | Miles Poindexter P000403 | sen | WA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17380 | 17380 | Atlee Pomerene P000420 | sen | OH | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17494 | 17494 | Charles Townsend T000330 | sen | MI | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17512 | 17512 | John Williams W000521 | sen | MS | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
18724 | 18724 | Robert La Follette L000004 | sen | WI | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18741 | 18741 | Henry Lodge L000393 | sen | MA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18756 | 18756 | George McLean M000547 | sen | CT | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18810 | 18810 | James Reed R000118 | sen | MO | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
20015 | 20015 | Claude Swanson S001094 | sen | VA | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16244 | 16244 | Thomas Catron C000253 | sen | NM | 1912-01-01 | 1917-03-03 | 1 | Republican | |||||||||||||
21622 | 21622 | Henry Ashurst A000319 | sen | AZ | 1912-03-27 | 1917-03-03 | 1 | Democrat | |||||||||||||
16316 | 16316 | Edwin Burleigh B001105 | sen | ME | 1913-04-07 | 1917-03-03 | 2 | Republican | |||||||||||||
21927 | 21927 | Key Pittman P000372 | sen | NV | 1913-04-07 | 1917-03-03 | 1 | Democrat | |||||||||||||
16659 | 16659 | Blair Lee L000189 | sen | MD | 1914-01-01 | 1917-03-03 | 1 | Democrat | |||||||||||||
16663 | 16663 | John Abercrombie A000013 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
16668 | 16668 | John Adair A000027 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
16675 | 16675 | Wyatt Aiken A000064 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
16678 | 16678 | Alfred Allen A000111 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16680 | 16680 | Warren Bailey B000050 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 19 | |||||||||||||
16686 | 16686 | Andrew Barchfeld B000133 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 32 | |||||||||||||
16687 | 16687 | Cyrus Beales B000269 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 20 | |||||||||||||
16689 | 16689 | Henry Benedict B000359 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
16693 | 16693 | William Bennet B000370 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 23 | |||||||||||||
16708 | 16708 | William Brown B000949 | rep | WV | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16711 | 16711 | Frank Buchanan B001001 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
16719 | 16719 | George Burgess B001083 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
16722 | 16722 | Michael Burke B001095 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16725 | 16725 | Oscar Callaway C000056 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
16728 | 16728 | William Charles C000323 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 30 | |||||||||||||
16731 | 16731 | James Clarke C000463 | sen | AR | 1915-12-06 | 1917-03-03 | 3 | Democrat | |||||||||||||
16735 | 16735 | Cyrus Cline C000521 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
16736 | 16736 | William Coleman C000622 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 30 | |||||||||||||
16740 | 16740 | William Cullop C000975 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16743 | 16743 | Henry Danforth D000029 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 39 | |||||||||||||
16747 | 16747 | James Davenport D000074 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
16748 | 16748 | James Davis D000110 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
16752 | 16752 | Daniel Driscoll D000500 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 42 | |||||||||||||
16754 | 16754 | Manuel Earnshaw E000015 | rep | PI | 1915-12-06 | 1917-03-03 | 0 | ||||||||||||||
16755 | 16755 | Michael Farley F000021 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
16768 | 16768 | Joseph Goulden G000344 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 23 | |||||||||||||
16778 | 16778 | Frank Guernsey G000517 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
16780 | 16780 | Archibald Hart H000283 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
16790 | 16790 | James Hay H000382 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
16800 | 16800 | Robert Henry H000516 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
16803 | 16803 | Asher Hinds H000630 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
16804 | 16804 | Robert Hopwood H000785 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 23 | |||||||||||||
16811 | 16811 | Joseph Howell H000866 | rep | UT | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
16815 | 16815 | Dudley Hughes H000920 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
16822 | 16822 | William Humphrey H000958 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
16832 | 16832 | Joseph Johnson J000156 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16834 | 16834 | Abraham Keister K000052 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 22 | |||||||||||||
16837 | 16837 | William Kent K000127 | rep | CA | 1915-12-06 | 1917-03-03 | Independent | 1 | |||||||||||||
16840 | 16840 | Thomas Konop K000310 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
16846 | 16846 | Daniel Lafean L000014 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
16848 | 16848 | Charles Lieb L000302 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
16849 | 16849 | Michael Liebel L000303 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 25 | |||||||||||||
16854 | 16854 | Charles Lindbergh L000320 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
16864 | 16864 | James Lloyd L000380 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
16866 | 16866 | George Loft L000399 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
16872 | 16872 | George Loud L000449 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
16873 | 16873 | Nelson Matthews M000254 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
16874 | 16874 | Paul McCorkle M000363 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
16875 | 16875 | Robert McCracken M000378 | rep | ID | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
16880 | 16880 | James McDermott M000405 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16883 | 16883 | Daniel McGillicuddy M000448 | rep | ME | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16886 | 16886 | Samuel Miller M000753 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 28 | |||||||||||||
16887 | 16887 | Thomas Miller M000758 | rep | DE | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
16888 | 16888 | William Mooney M000888 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
16891 | 16891 | Lewis Morgan M000955 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
16895 | 16895 | Martin Morrison M000998 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
16897 | 16897 | Hunter Moss M001034 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
16901 | 16901 | Ralph Moss M001037 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
16903 | 16903 | William Murray M001118 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16912 | 16912 | Solomon North N000141 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 27 | |||||||||||||
16913 | 16913 | Peter Oakey O000002 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
16915 | 16915 | Woodson Oglesby O000049 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 24 | |||||||||||||
16922 | 16922 | Robert Page P000022 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
16925 | 16925 | Thomas Patten P000109 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 18 | |||||||||||||
16934 | 16934 | Manuel Quezon Q000009 | rep | PI | 1915-12-06 | 1917-03-03 | 0 | ||||||||||||||
16939 | 16939 | George Rauch R000070 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
16942 | 16942 | Luis Rivera R000279 | rep | PR | 1915-12-06 | 1917-03-03 | Unionist | 0 |
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);