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 state descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18368 | 18368 | Franklin Mondell M000852 | rep | WY | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
16708 | 16708 | William Brown B000949 | rep | WV | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16897 | 16897 | Hunter Moss M001034 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17117 | 17117 | Edward Cooper C000748 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17339 | 17339 | Adam Littlepage L000358 | rep | WV | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17469 | 17469 | Howard Sutherland S001081 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
18055 | 18055 | George Bowers B000690 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19171 | 19171 | Harry Woodyard W000737 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
26064 | 26064 | Matthew Neely N000023 | rep | WV | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
16722 | 16722 | Michael Burke B001095 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16823 | 16823 | Paul Husting H001006 | sen | WI | 1915-12-06 | 1917-12-31 | 3 | Democrat | |||||||||||||
16840 | 16840 | Thomas Konop K000310 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
17102 | 17102 | William Cary C000218 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17672 | 17672 | John Esch E000212 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
18310 | 18310 | Irvine Lenroot L000241 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
19599 | 19599 | Edward Browne B000955 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
20242 | 20242 | Henry Cooper C000752 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
20751 | 20751 | John Nelson N000039 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
20877 | 20877 | William Stafford S000777 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
21271 | 21271 | James Frear F000355 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
22377 | 22377 | Michael Reilly R000155 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
16822 | 16822 | William Humphrey H000958 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17336 | 17336 | William La Follette L000006 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
19368 | 19368 | Wesley Jones J000257 | sen | WA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19665 | 19665 | Clarence Dill D000345 | rep | WA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
20445 | 20445 | Lindley Hadley H000008 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20565 | 20565 | Albert Johnson J000114 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18151 | 18151 | William Dillingham D000347 | sen | VT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19280 | 19280 | Porter Dale D000009 | rep | VT | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19735 | 19735 | Frank Greene G000425 | rep | VT | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
16790 | 16790 | James Hay H000382 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17321 | 17321 | William Jones J000259 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17608 | 17608 | Charles Carlin C000151 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17778 | 17778 | Edward Holland H000716 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17918 | 17918 | Edward Saunders S000077 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17993 | 17993 | Walter Watson W000206 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18174 | 18174 | Henry Flood F000210 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
18487 | 18487 | Campbell Slemp S000486 | rep | VA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
19342 | 19342 | Thomas Harrison H000277 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
22317 | 22317 | Andrew Montague M000861 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
23519 | 23519 | Carter Glass G000232 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
16811 | 16811 | Joseph Howell H000866 | rep | UT | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17825 | 17825 | James Mays M000290 | rep | UT | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19490 | 19490 | Reed Smoot S000644 | sen | UT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
16719 | 16719 | George Burgess B001083 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
16725 | 16725 | Oscar Callaway C000056 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
16748 | 16748 | James Davis D000110 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
16800 | 16800 | Robert Henry H000516 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
16986 | 16986 | William Smith S000636 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
17008 | 17008 | John Stephens S000858 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17148 | 17148 | Martin Dies D000337 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17237 | 17237 | Alexander Gregg G000441 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17351 | 17351 | Atkins McLemore M000554 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
17436 | 17436 | James Slayden S000482 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
18028 | 18028 | James Young Y000040 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18211 | 18211 | Rufus Hardy H000198 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
19214 | 19214 | Eugene Black B000495 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
21287 | 21287 | John Garner G000074 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
21753 | 21753 | Joe Eagle E000003 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
22063 | 22063 | James Buchanan B001006 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
24114 | 24114 | Hatton Sumners S001072 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
27435 | 27435 | Samuel Rayburn R000082 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17058 | 17058 | Richard Austin A000341 | rep | TN | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17301 | 17301 | William Houston H000829 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17843 | 17843 | John Moon M000884 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17928 | 17928 | Sam Sells S000235 | rep | TN | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17942 | 17942 | Thetus Sims S000441 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
18397 | 18397 | Lemuel Padgett P000012 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19324 | 19324 | Finis Garrett G000082 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
20543 | 20543 | Cordell Hull H000940 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
21673 | 21673 | Joseph Byrns B001217 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
24606 | 24606 | Kenneth McKellar M000499 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
16824 | 16824 | Edwin Johnson J000128 | sen | SD | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17151 | 17151 | Charles Dillon D000348 | rep | SD | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17710 | 17710 | Harry Gandy G000037 | rep | SD | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
20575 | 20575 | Royal Johnson J000173 | rep | SD | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
16675 | 16675 | Wyatt Aiken A000064 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
16832 | 16832 | Joseph Johnson J000156 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16874 | 16874 | Paul McCorkle M000363 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17181 | 17181 | David Finley F000131 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17815 | 17815 | Asbury Lever L000259 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17869 | 17869 | Samuel Nicholls N000088 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17891 | 17891 | James Ragsdale R000010 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
18010 | 18010 | Richard Whaley W000319 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
22079 | 22079 | James Byrnes B001215 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
22786 | 22786 | Ellison Smith S000530 | sen | SC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17368 | 17368 | George O’Shaunessy O000117 | rep | RI | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
18273 | 18273 | Ambrose Kennedy K000100 | rep | RI | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18504 | 18504 | Walter Stiness S000927 | rep | RI | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
16942 | 16942 | Luis Rivera R000279 | rep | PR | 1915-12-06 | 1917-03-03 | Unionist | 0 | |||||||||||||
16754 | 16754 | Manuel Earnshaw E000015 | rep | PI | 1915-12-06 | 1917-03-03 | 0 | ||||||||||||||
16934 | 16934 | Manuel Quezon Q000009 | rep | PI | 1915-12-06 | 1917-03-03 | 0 | ||||||||||||||
16680 | 16680 | Warren Bailey B000050 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 19 | |||||||||||||
16686 | 16686 | Andrew Barchfeld B000133 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 32 | |||||||||||||
16687 | 16687 | Cyrus Beales B000269 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 20 | |||||||||||||
16736 | 16736 | William Coleman C000622 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 30 | |||||||||||||
16804 | 16804 | Robert Hopwood H000785 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 23 | |||||||||||||
16834 | 16834 | Abraham Keister K000052 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 22 | |||||||||||||
16846 | 16846 | Daniel Lafean L000014 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
16849 | 16849 | Michael Liebel L000303 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 25 |
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);