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 url
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17424 | 17424 | Joseph Sherley S000343 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17426 | 17426 | Jouett Shouse S000384 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17437 | 17437 | James Slayden S000482 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
17441 | 17441 | Charles Smith S000520 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 41 | |||||||||||||
17444 | 17444 | John Snook S000657 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17448 | 17448 | Dan Stephens S000856 | rep | NE | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17449 | 17449 | Bruce Sterling S000869 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 23 | |||||||||||||
17456 | 17456 | John Sterling S000870 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 17 | |||||||||||||
17467 | 17467 | Cyrus Sulloway S001063 | rep | NH | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17470 | 17470 | Howard Sutherland S001081 | sen | WV | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17472 | 17472 | Oscar Swift S001118 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
17476 | 17476 | Robert Switzer S001124 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17488 | 17488 | Joshua Talbott T000021 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17489 | 17489 | Thomas Templeton T000121 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
17495 | 17495 | Charles Townsend T000330 | sen | MI | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17496 | 17496 | William Waldow W000039 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 42 | |||||||||||||
17499 | 17499 | John Walker W000060 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
17500 | 17500 | William Walton W000117 | rep | NM | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17503 | 17503 | George White W000370 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 15 | |||||||||||||
17513 | 17513 | John Williams W000521 | sen | MS | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17514 | 17514 | Josiah Wolcott W000669 | sen | DE | 1917-04-02 | 1921-12-31 | 1 | Democrat | |||||||||||||
17519 | 17519 | Frank Woods W000721 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17537 | 17537 | Joshua Alexander A000098 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17541 | 17541 | John Baer B000027 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17560 | 17560 | Carville Benson B000387 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17569 | 17569 | Charles Booher B000626 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17574 | 17574 | William Browning B000961 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17578 | 17578 | Clement Brumbaugh B000975 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
17589 | 17589 | John Burnett B001121 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17592 | 17592 | Charles Caldwell C000030 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17602 | 17602 | Ezekiel Candler C000110 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17609 | 17609 | Charles Carlin C000151 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17622 | 17622 | James Clark C000437 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
17626 | 17626 | Charles Coady C000541 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17631 | 17631 | Peter Costello C000796 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17633 | 17633 | Gilbert Currie C000998 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17639 | 17639 | Stanley Dent D000256 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17642 | 17642 | Arthur Dewalt D000288 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 13 | |||||||||||||
17645 | 17645 | Jerome Donovan D000423 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 21 | |||||||||||||
17649 | 17649 | Peter Dooling D000426 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 16 | |||||||||||||
17654 | 17654 | Frank Doremus D000431 | rep | MI | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17659 | 17659 | Franklin Ellsworth E000145 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17662 | 17662 | Henry Emerson E000171 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 22 | |||||||||||||
17673 | 17673 | John Esch E000212 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
17680 | 17680 | Albert Estopinal E000224 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17689 | 17689 | John Farr F000029 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17696 | 17696 | Scott Ferris F000091 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17702 | 17702 | Alvan Fuller F000405 | rep | MA | 1917-04-02 | 1919-03-03 | Ind. Republican | 9 | |||||||||||||
17708 | 17708 | Thomas Gallagher G000018 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17711 | 17711 | Harry Gandy G000037 | rep | SD | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17715 | 17715 | Warren Gard G000048 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17718 | 17718 | Mahlon Garland G000068 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17725 | 17725 | Hannibal Godwin G000250 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17735 | 17735 | Louis Goodall G000276 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17740 | 17740 | William Goodwin G000304 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17748 | 17748 | James Hamill H000099 | rep | NJ | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
17760 | 17760 | Edward Hamilton H000108 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17763 | 17763 | Reuben Haskell H000319 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17770 | 17770 | Harvey Helm H000461 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17779 | 17779 | Edward Holland H000716 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17785 | 17785 | William Igoe I000005 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
17788 | 17788 | Niels Juul J000282 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
17795 | 17795 | Charles Kennedy K000104 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17802 | 17802 | William Kettner K000155 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
17806 | 17806 | John Lesher L000250 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 16 | |||||||||||||
17816 | 17816 | Asbury Lever L000259 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17822 | 17822 | James Maher M000063 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17826 | 17826 | James Mays M000290 | rep | UT | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17828 | 17828 | Joseph McCormick M000369 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17844 | 17844 | John Moon M000884 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17852 | 17852 | Joseph Moore M000906 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
17858 | 17858 | Dick Morgan M000947 | rep | OK | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17870 | 17870 | Samuel Nicholls N000088 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17873 | 17873 | Charles Nichols N000090 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 13 | |||||||||||||
17876 | 17876 | Richard Olney O000080 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
17884 | 17884 | Michael Phelan P000291 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17888 | 17888 | Edmund Platt P000379 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 26 | |||||||||||||
17892 | 17892 | James Ragsdale R000010 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17894 | 17894 | John Ramsey R000027 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17897 | 17897 | Charles Randall R000036 | rep | CA | 1917-04-02 | 1919-03-03 | Prohibitionist | 9 | |||||||||||||
17901 | 17901 | Edward Robbins R000298 | rep | PA | 1917-04-02 | 1919-01-25 | Republican | 22 | |||||||||||||
17902 | 17902 | Leonidas Robinson R000348 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17906 | 17906 | Frederick Rowe R000476 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17908 | 17908 | Jared Sanders S000035 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17911 | 17911 | Rollin Sanford S000053 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 28 | |||||||||||||
17919 | 17919 | Edward Saunders S000077 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17924 | 17924 | Thomas Scully S000206 | rep | NJ | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17929 | 17929 | Sam Sells S000235 | rep | TN | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17943 | 17943 | Thetus Sims S000441 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17954 | 17954 | John Small S000500 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17956 | 17956 | Thomas Smith S000619 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 15 | |||||||||||||
17966 | 17966 | Henry Steele S000831 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 26 | |||||||||||||
17970 | 17970 | Charles Sulzer S001064 | rep | AK | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
17976 | 17976 | Joseph Thompson T000210 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17979 | 17979 | Carl Van Dyke V000034 | rep | MN | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17982 | 17982 | William Venable V000086 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17990 | 17990 | John Watkins W000193 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17994 | 17994 | Walter Watson W000206 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18003 | 18003 | Edwin Webb W000231 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
18005 | 18005 | Milton Welling W000278 | rep | UT | 1917-04-02 | 1919-03-03 | Democrat | 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);