legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
506 rows where "end" is on date 1919-03-03 sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18369 | 18369 | Franklin Mondell M000852 | rep | WY | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
19154 | 19154 | Francis Warren W000164 | sen | WY | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16377 | 16377 | Nathan Goff G000255 | sen | WV | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17118 | 17118 | Edward Cooper C000748 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17340 | 17340 | Adam Littlepage L000358 | rep | WV | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18056 | 18056 | George Bowers B000690 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18813 | 18813 | Stuart Reed R000127 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
19172 | 19172 | Harry Woodyard W000737 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
26065 | 26065 | Matthew Neely N000023 | rep | WV | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17103 | 17103 | William Cary C000218 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17140 | 17140 | James Davidson D000084 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17673 | 17673 | John Esch E000212 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
18122 | 18122 | David Classon C000474 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
18373 | 18373 | Adolphus Nelson N000029 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
19141 | 19141 | Edward Voigt V000110 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
19600 | 19600 | Edward Browne B000955 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
19839 | 19839 | Florian Lampert L000041 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
20243 | 20243 | Henry Cooper C000752 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
20752 | 20752 | John Nelson N000039 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
20878 | 20878 | William Stafford S000777 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
21272 | 21272 | James Frear F000355 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17337 | 17337 | William La Follette L000006 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
19666 | 19666 | Clarence Dill D000345 | rep | WA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
19879 | 19879 | John Miller M000739 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
20446 | 20446 | Lindley Hadley H000008 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20566 | 20566 | Albert Johnson J000114 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
19281 | 19281 | Porter Dale D000009 | rep | VT | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
19736 | 19736 | Frank Greene G000425 | rep | VT | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
16474 | 16474 | Thomas Martin M000200 | sen | VA | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17322 | 17322 | William Jones J000259 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17609 | 17609 | Charles Carlin C000151 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17779 | 17779 | Edward Holland H000716 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17919 | 17919 | Edward Saunders S000077 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17994 | 17994 | Walter Watson W000206 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18175 | 18175 | Henry Flood F000210 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
18488 | 18488 | Campbell Slemp S000486 | rep | VA | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
18555 | 18555 | James Woods W000723 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
19343 | 19343 | Thomas Harrison H000277 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
22318 | 22318 | Andrew Montague M000861 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
24742 | 24742 | Schuyler Bland B000545 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17826 | 17826 | James Mays M000290 | rep | UT | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18005 | 18005 | Milton Welling W000278 | rep | UT | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17149 | 17149 | Martin Dies D000337 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17238 | 17238 | Alexander Gregg G000441 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17352 | 17352 | Atkins McLemore M000554 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
17437 | 17437 | James Slayden S000482 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
18212 | 18212 | Rufus Hardy H000198 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
19215 | 19215 | Eugene Black B000495 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
20409 | 20409 | Daniel Garrett G000081 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
21288 | 21288 | John Garner G000074 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 15 | |||||||||||||
21643 | 21643 | Thomas Blanton B000549 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 16 | |||||||||||||
21754 | 21754 | Joe Eagle E000003 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
22064 | 22064 | James Buchanan B001006 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
22409 | 22409 | Morris Sheppard S000337 | sen | TX | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
22637 | 22637 | John Jones J000236 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 13 | |||||||||||||
24115 | 24115 | Hatton Sumners S001072 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
24313 | 24313 | Thomas Connally C000684 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
24577 | 24577 | Joseph Mansfield M000112 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
27436 | 27436 | Samuel Rayburn R000082 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17059 | 17059 | Richard Austin A000341 | rep | TN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17302 | 17302 | William Houston H000829 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17844 | 17844 | John Moon M000884 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17929 | 17929 | Sam Sells S000235 | rep | TN | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17931 | 17931 | John Shields S000363 | sen | TN | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17943 | 17943 | Thetus Sims S000441 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
18398 | 18398 | Lemuel Padgett P000012 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19325 | 19325 | Finis Garrett G000082 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
19703 | 19703 | Hubert Fisher F000149 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
20544 | 20544 | Cordell Hull H000940 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21674 | 21674 | Joseph Byrns B001217 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17152 | 17152 | Charles Dillon D000348 | rep | SD | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17711 | 17711 | Harry Gandy G000037 | rep | SD | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17968 | 17968 | Thomas Sterling S000872 | sen | SD | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
20576 | 20576 | Royal Johnson J000173 | rep | SD | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
16618 | 16618 | Benjamin Tillman T000274 | sen | SC | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17182 | 17182 | David Finley F000131 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
17521 | 17521 | Christie Benet B000360 | sen | SC | 1918-07-06 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
17530 | 17530 | William Pollock P000417 | sen | SC | 1918-01-01 | 1919-03-03 | 2 | Democrat | |||||||||||||
17816 | 17816 | Asbury Lever L000259 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17870 | 17870 | Samuel Nicholls N000088 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17892 | 17892 | James Ragsdale R000010 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18011 | 18011 | Richard Whaley W000319 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
20300 | 20300 | Frederick Dominick D000408 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
20882 | 20882 | William Stevenson S000895 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
22080 | 22080 | James Byrnes B001215 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17369 | 17369 | George O’Shaunessy O000117 | rep | RI | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17628 | 17628 | LeBaron Colt C000651 | sen | RI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
18274 | 18274 | Ambrose Kennedy K000100 | rep | RI | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18505 | 18505 | Walter Stiness S000927 | rep | RI | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20330 | 20330 | Félix Dávila D000090 | rep | PR | 1917-04-02 | 1919-03-03 | Unionist | 0 | |||||||||||||
18024 | 18024 | Teodoro Yangco Y000004 | rep | PI | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
18145 | 18145 | Jaime De Veyra D000276 | rep | PI | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
17073 | 17073 | Earl Beshlin B000421 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 28 | |||||||||||||
17075 | 17075 | Orrin Bleakley B000552 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 28 | |||||||||||||
17084 | 17084 | Andrew Brodbeck B000855 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 20 | |||||||||||||
17104 | 17104 | Henry Clark C000433 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 25 | |||||||||||||
17260 | 17260 | Robert Heaton H000433 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
17396 | 17396 | Charles Rowland R000480 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 21 |
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);