legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
496 rows where "start" is on date 1917-04-02 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20061 | 20061 | Frederick Zihlman Z000007 | rep | MD | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
18029 | 18029 | James Young Y000040 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18903 | 18903 | George Young Y000036 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18024 | 18024 | Teodoro Yangco Y000004 | rep | PI | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
21031 | 21031 | William Wright W000773 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
19172 | 19172 | Harry Woodyard W000737 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
18555 | 18555 | James Woods W000723 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17519 | 17519 | Frank Woods W000721 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
21023 | 21023 | William Wood W000706 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17514 | 17514 | Josiah Wolcott W000669 | sen | DE | 1917-04-02 | 1921-12-31 | 1 | Democrat | |||||||||||||
18896 | 18896 | James Wise W000650 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18891 | 18891 | Samuel Winslow W000639 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
20052 | 20052 | Otis Wingo W000635 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18022 | 18022 | William Wilson W000624 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
21998 | 21998 | Riley Wilson W000608 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
18013 | 18013 | James Wilson W000593 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
20043 | 20043 | Thomas Williams W000542 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 24 | |||||||||||||
17513 | 17513 | John Williams W000521 | sen | MS | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21005 | 21005 | James Wickersham W000438 | rep | AK | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
23747 | 23747 | Wallace White W000396 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17503 | 17503 | George White W000370 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 15 | |||||||||||||
19160 | 19160 | Loren Wheeler W000339 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 21 | |||||||||||||
18011 | 18011 | Richard Whaley W000319 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18007 | 18007 | Benjamin Welty W000291 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18005 | 18005 | Milton Welling W000278 | rep | UT | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18003 | 18003 | Edwin Webb W000231 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
24186 | 24186 | Zebulon Weaver W000230 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
17994 | 17994 | Walter Watson W000206 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21588 | 21588 | Henry Watson W000201 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17990 | 17990 | John Watkins W000193 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
20986 | 20986 | Edward Wason W000185 | rep | NH | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18877 | 18877 | Charles Ward W000129 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 27 | |||||||||||||
17500 | 17500 | William Walton W000117 | rep | NM | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18549 | 18549 | Joseph Walsh W000101 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 16 | |||||||||||||
17499 | 17499 | John Walker W000060 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
17496 | 17496 | William Waldow W000039 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 42 | |||||||||||||
18545 | 18545 | Andrew Volstead V000114 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
19141 | 19141 | Edward Voigt V000110 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
28205 | 28205 | Carl Vinson V000105 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
20968 | 20968 | Albert Vestal V000092 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17982 | 17982 | William Venable V000086 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
19521 | 19521 | William Vare V000071 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17979 | 17979 | Carl Van Dyke V000034 | rep | MN | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
23713 | 23713 | Allen Treadway T000358 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
21977 | 21977 | Park Trammell T000353 | sen | FL | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17495 | 17495 | Charles Townsend T000330 | sen | MI | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18870 | 18870 | Horace Towner T000325 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
23297 | 23297 | George Tinkham T000283 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
20944 | 20944 | Charles Timberlake T000281 | rep | CO | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20935 | 20935 | John Tilson T000279 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
19505 | 19505 | John Tillman T000276 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17976 | 17976 | Joseph Thompson T000210 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
19126 | 19126 | Robert Thomas T000185 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17489 | 17489 | Thomas Templeton T000121 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
20918 | 20918 | Henry Temple T000119 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 24 | |||||||||||||
18518 | 18518 | Samuel Taylor T000100 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
23274 | 23274 | Edward Taylor T000072 | rep | CO | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17488 | 17488 | Joshua Talbott T000021 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18863 | 18863 | Peter Tague T000014 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
17476 | 17476 | Robert Switzer S001124 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17472 | 17472 | Oscar Swift S001118 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
18511 | 18511 | Burton Sweet S001106 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
20016 | 20016 | Claude Swanson S001094 | sen | VA | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17470 | 17470 | Howard Sutherland S001081 | sen | WV | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
24115 | 24115 | Hatton Sumners S001072 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17970 | 17970 | Charles Sulzer S001064 | rep | AK | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
17467 | 17467 | Cyrus Sulloway S001063 | rep | NH | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
22792 | 22792 | Christopher Sullivan S001051 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 13 | |||||||||||||
21561 | 21561 | Nathan Strong S001015 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 27 | |||||||||||||
18505 | 18505 | Walter Stiness S000927 | rep | RI | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20882 | 20882 | William Stevenson S000895 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17456 | 17456 | John Sterling S000870 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 17 | |||||||||||||
17449 | 17449 | Bruce Sterling S000869 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 23 | |||||||||||||
19993 | 19993 | Hubert Stephens S000857 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17448 | 17448 | Dan Stephens S000856 | rep | NE | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18501 | 18501 | Halvor Steenerson S000842 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
17966 | 17966 | Henry Steele S000831 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 26 | |||||||||||||
19981 | 19981 | Charles Stedman S000827 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
23688 | 23688 | Henry Steagall S000820 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
20878 | 20878 | William Stafford S000777 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
18857 | 18857 | Homer Snyder S000666 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 33 | |||||||||||||
17444 | 17444 | John Snook S000657 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
22417 | 22417 | Bertrand Snell S000652 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 31 | |||||||||||||
17956 | 17956 | Thomas Smith S000619 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 15 | |||||||||||||
18852 | 18852 | John Smith S000573 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
17441 | 17441 | Charles Smith S000520 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 41 | |||||||||||||
20860 | 20860 | Addison Smith S000511 | rep | ID | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17954 | 17954 | John Small S000500 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19958 | 19958 | Charles Sloan S000491 | rep | NE | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
18488 | 18488 | Campbell Slemp S000486 | rep | VA | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
17437 | 17437 | James Slayden S000482 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
18480 | 18480 | Thomas Sisson S000456 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
19482 | 19482 | Nicholas Sinnott S000450 | rep | OR | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17943 | 17943 | Thetus Sims S000441 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
18473 | 18473 | Isaac Siegel S000404 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 20 | |||||||||||||
17426 | 17426 | Jouett Shouse S000384 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18845 | 18845 | Isaac Sherwood S000355 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
17424 | 17424 | Joseph Sherley S000343 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
21535 | 21535 | Ashton Shallenberger S000280 | rep | NE | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17416 | 17416 | Dorsey Shackleford S000274 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 8 |
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);