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 party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17826 | 17826 | James Mays M000290 | rep | UT | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17844 | 17844 | John Moon M000884 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17870 | 17870 | Samuel Nicholls N000088 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
17892 | 17892 | James Ragsdale R000010 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17902 | 17902 | Leonidas Robinson R000348 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17908 | 17908 | Jared Sanders S000035 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
18007 | 18007 | Benjamin Welty W000291 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18011 | 18011 | Richard Whaley W000319 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18013 | 18013 | James Wilson W000593 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
18029 | 18029 | James Young Y000040 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18046 | 18046 | Fred Blackmon B000514 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18175 | 18175 | Henry Flood F000210 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
18212 | 18212 | Rufus Hardy H000198 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18246 | 18246 | Henderson Jacoway J000041 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
18387 | 18387 | James Overstreet O000143 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18398 | 18398 | Lemuel Padgett P000012 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18465 | 18465 | William Rucker R000494 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18480 | 18480 | Thomas Sisson S000456 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18518 | 18518 | Samuel Taylor T000100 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18555 | 18555 | James Woods W000723 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18579 | 18579 | James Cantrill C000126 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18589 | 18589 | Frank Clark C000430 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18622 | 18622 | Henry Dupré D000561 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18628 | 18628 | John Eagan E000001 | rep | NJ | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
18644 | 18644 | William Fields F000113 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
18688 | 18688 | Benjamin Humphreys H000960 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18693 | 18693 | Andrieus Jones J000210 | sen | NM | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18716 | 18716 | Claude Kitchin K000250 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18801 | 18801 | Frank Park P000051 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18805 | 18805 | John Rainey R000015 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18811 | 18811 | James Reed R000118 | sen | MO | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18825 | 18825 | Daniel Riordan R000264 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
18845 | 18845 | Isaac Sherwood S000355 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
18863 | 18863 | Peter Tague T000014 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
18896 | 18896 | James Wise W000650 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18921 | 18921 | Charles Carter C000196 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18927 | 18927 | William Cleary C000500 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
18986 | 18986 | James Heflin H000446 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
19000 | 19000 | Ben Johnson J000118 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
19026 | 19026 | Gordon Lee L000194 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19066 | 19066 | John Raker R000019 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19091 | 19091 | Arthur Rouse R000466 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
19126 | 19126 | Robert Thomas T000185 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
19215 | 19215 | Eugene Black B000495 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19258 | 19258 | Thaddeus Caraway C000139 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19286 | 19286 | Martin Davey D000080 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
19310 | 19310 | James Gallivan G000024 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
19325 | 19325 | Finis Garrett G000082 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
19343 | 19343 | Thomas Harrison H000277 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19387 | 19387 | Ladislas Lazaro L000153 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19449 | 19449 | William Oldfield O000062 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19473 | 19473 | Thomas Rubey R000491 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 16 | |||||||||||||
19505 | 19505 | John Tillman T000276 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
19580 | 19580 | Thomas Bell B000348 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
19609 | 19609 | John Carew C000142 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 17 | |||||||||||||
19666 | 19666 | Clarence Dill D000345 | rep | WA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
19703 | 19703 | Hubert Fisher F000149 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
19811 | 19811 | John Kendrick K000098 | sen | WY | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
19826 | 19826 | David Kincheloe K000187 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19981 | 19981 | Charles Stedman S000827 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
19993 | 19993 | Hubert Stephens S000857 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
20016 | 20016 | Claude Swanson S001094 | sen | VA | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
20052 | 20052 | Otis Wingo W000635 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
20100 | 20100 | James Aswell A000321 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
20159 | 20159 | Guy Campbell C000084 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 32 | |||||||||||||
20214 | 20214 | James Collier C000630 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
20263 | 20263 | Charles Crisp C000909 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
20300 | 20300 | Frederick Dominick D000408 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
20311 | 20311 | Herbert Drane D000486 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
20361 | 20361 | John Evans E000247 | rep | MT | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
20409 | 20409 | Daniel Garrett G000081 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
20544 | 20544 | Cordell Hull H000940 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
20636 | 20636 | William Larsen L000103 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
20656 | 20656 | John Linthicum L000340 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
20790 | 20790 | Percy Quin Q000014 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
20882 | 20882 | William Stevenson S000895 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
21031 | 21031 | William Wright W000773 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21081 | 21081 | Edward Almon A000162 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21097 | 21097 | William Ayres A000354 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21133 | 21133 | Charles Brand B000767 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21197 | 21197 | Denver Church C000387 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
21227 | 21227 | Clement Dickinson D000316 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
21288 | 21288 | John Garner G000074 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 15 | |||||||||||||
21307 | 21307 | William Hastings H000333 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
21380 | 21380 | Augustine Lonergan L000409 | rep | CT | 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);