legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1915-12-06 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18028 | 18028 | James Young Y000040 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18902 | 18902 | George Young Y000036 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19171 | 19171 | Harry Woodyard W000737 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17518 | 17518 | Frank Woods W000721 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
21022 | 21022 | William Wood W000706 | rep | IN | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17041 | 17041 | Samuel Witherspoon W000662 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
18895 | 18895 | James Wise W000650 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
18890 | 18890 | Samuel Winslow W000639 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
20051 | 20051 | Otis Wingo W000635 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18021 | 18021 | William Wilson W000624 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
21997 | 21997 | Riley Wilson W000608 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17038 | 17038 | Emmett Wilson W000575 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17036 | 17036 | William Williams W000548 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
20042 | 20042 | Thomas Williams W000542 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 24 | |||||||||||||
17033 | 17033 | Seward Williams W000535 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 14 | |||||||||||||
21004 | 21004 | James Wickersham W000438 | rep | AK | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
19159 | 19159 | Loren Wheeler W000339 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 21 | |||||||||||||
18010 | 18010 | Richard Whaley W000319 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
18002 | 18002 | Edwin Webb W000231 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
17993 | 17993 | Walter Watson W000206 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
21587 | 21587 | Henry Watson W000201 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
17989 | 17989 | John Watkins W000193 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
20985 | 20985 | Edward Wason W000185 | rep | NH | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18876 | 18876 | Charles Ward W000129 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 27 | |||||||||||||
18548 | 18548 | Joseph Walsh W000101 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 16 | |||||||||||||
17498 | 17498 | John Walker W000060 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
25048 | 25048 | James Wadsworth W000012 | sen | NY | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18544 | 18544 | Andrew Volstead V000114 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
28204 | 28204 | Carl Vinson V000105 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
17981 | 17981 | William Venable V000086 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
19520 | 19520 | William Vare V000071 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17978 | 17978 | Carl Van Dyke V000034 | rep | MN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18534 | 18534 | Oscar Underwood U000013 | sen | AL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17032 | 17032 | Samuel Tribble T000366 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
23712 | 23712 | Allen Treadway T000358 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
18869 | 18869 | Horace Towner T000325 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
23296 | 23296 | George Tinkham T000283 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
20943 | 20943 | Charles Timberlake T000281 | rep | CO | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20934 | 20934 | John Tilson T000279 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
19504 | 19504 | John Tillman T000276 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17975 | 17975 | Joseph Thompson T000210 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
19125 | 19125 | Robert Thomas T000185 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17029 | 17029 | Charles Thomas T000160 | sen | CO | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
20917 | 20917 | Henry Temple T000119 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 24 | |||||||||||||
18517 | 18517 | Samuel Taylor T000100 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
23273 | 23273 | Edward Taylor T000072 | rep | CO | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17027 | 17027 | Clyde Tavenner T000059 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17487 | 17487 | Joshua Talbott T000021 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18862 | 18862 | Peter Tague T000014 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
17025 | 17025 | Joseph Taggart T000011 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17475 | 17475 | Robert Switzer S001124 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17471 | 17471 | Oscar Swift S001118 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
18510 | 18510 | Burton Sweet S001106 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
17469 | 17469 | Howard Sutherland S001081 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
24114 | 24114 | Hatton Sumners S001072 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17466 | 17466 | Cyrus Sulloway S001063 | rep | NH | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17022 | 17022 | Tom Stout S000982 | rep | MT | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
17020 | 17020 | William Stone S000968 | sen | MO | 1915-12-06 | 1919-03-03 | 3 | Democrat | |||||||||||||
17014 | 17014 | Claudius Stone S000954 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
18504 | 18504 | Walter Stiness S000927 | rep | RI | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17455 | 17455 | John Sterling S000870 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 17 | |||||||||||||
17011 | 17011 | William Stephens S000861 | rep | CA | 1915-12-06 | 1917-03-03 | Progressive | 10 | |||||||||||||
17008 | 17008 | John Stephens S000858 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
19992 | 19992 | Hubert Stephens S000857 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17447 | 17447 | Dan Stephens S000856 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18500 | 18500 | Halvor Steenerson S000842 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
16998 | 16998 | Thomas Steele S000837 | rep | IA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
17965 | 17965 | Henry Steele S000831 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 26 | |||||||||||||
19980 | 19980 | Charles Stedman S000827 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
23687 | 23687 | Henry Steagall S000820 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
20877 | 20877 | William Stafford S000777 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
16997 | 16997 | Stephen Sparkman S000702 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
18856 | 18856 | Homer Snyder S000666 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 33 | |||||||||||||
22416 | 22416 | Bertrand Snell S000652 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 31 | |||||||||||||
19490 | 19490 | Reed Smoot S000644 | sen | UT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
16986 | 16986 | William Smith S000636 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
16979 | 16979 | Marcus Smith S000589 | sen | AZ | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
16969 | 16969 | John Smith S000577 | sen | MD | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18851 | 18851 | John Smith S000573 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
16965 | 16965 | Hoke Smith S000551 | sen | GA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
16963 | 16963 | George Smith S000540 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
22786 | 22786 | Ellison Smith S000530 | sen | SC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17440 | 17440 | Charles Smith S000520 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 41 | |||||||||||||
20859 | 20859 | Addison Smith S000511 | rep | ID | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
17953 | 17953 | John Small S000500 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
19957 | 19957 | Charles Sloan S000491 | rep | NE | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
18487 | 18487 | Campbell Slemp S000486 | rep | VA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
17436 | 17436 | James Slayden S000482 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
18479 | 18479 | Thomas Sisson S000456 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
19481 | 19481 | Nicholas Sinnott S000450 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17942 | 17942 | Thetus Sims S000441 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
18472 | 18472 | Isaac Siegel S000404 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 20 | |||||||||||||
17425 | 17425 | Jouett Shouse S000384 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
16961 | 16961 | Benjamin Shively S000371 | sen | IN | 1915-12-06 | 1917-03-03 | 3 | Democrat | |||||||||||||
18844 | 18844 | Isaac Sherwood S000355 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
16955 | 16955 | Lawrence Sherman S000348 | sen | IL | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
17423 | 17423 | Joseph Sherley S000343 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
21534 | 21534 | Ashton Shallenberger S000280 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17415 | 17415 | Dorsey Shackleford S000274 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17928 | 17928 | Sam Sells S000235 | rep | TN | 1915-12-06 | 1917-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);