legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
497 rows where "start" is on date 1913-04-07 sorted by state descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18367 | 18367 | Franklin Mondell M000852 | rep | WY | 1913-04-07 | 1915-03-03 | Republican | 0 | |||||||||||||
19154 | 19154 | Francis Warren W000164 | sen | WY | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16255 | 16255 | Samuel Avis A000348 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
16342 | 16342 | John Davis D000121 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16377 | 16377 | Nathan Goff G000255 | sen | WV | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16707 | 16707 | William Brown B000949 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16896 | 16896 | Hunter Moss M001034 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
17468 | 17468 | Howard Sutherland S001081 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
19790 | 19790 | James Hughes H000924 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
26063 | 26063 | Matthew Neely N000023 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16721 | 16721 | Michael Burke B001095 | rep | WI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16839 | 16839 | Thomas Konop K000310 | rep | WI | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
17101 | 17101 | William Cary C000218 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
17671 | 17671 | John Esch E000212 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 7 | |||||||||||||
18309 | 18309 | Irvine Lenroot L000241 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 11 | |||||||||||||
19598 | 19598 | Edward Browne B000955 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
20241 | 20241 | Henry Cooper C000752 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
20750 | 20750 | John Nelson N000039 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
20876 | 20876 | William Stafford S000777 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
21270 | 21270 | James Frear F000355 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
22376 | 22376 | Michael Reilly R000155 | rep | WI | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16296 | 16296 | James Bryan B000987 | rep | WA | 1913-04-07 | 1915-03-03 | Progressive | -1 | |||||||||||||
16353 | 16353 | Jacob Falconer F000009 | rep | WA | 1913-04-07 | 1915-03-03 | Progressive | -1 | |||||||||||||
16821 | 16821 | William Humphrey H000958 | rep | WA | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
17335 | 17335 | William La Follette L000006 | rep | WA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
20564 | 20564 | Albert Johnson J000114 | rep | WA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
16533 | 16533 | Frank Plumley P000396 | rep | VT | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
19734 | 19734 | Frank Greene G000425 | rep | VT | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
16474 | 16474 | Thomas Martin M000200 | sen | VA | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16789 | 16789 | James Hay H000382 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
17320 | 17320 | William Jones J000259 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17607 | 17607 | Charles Carlin C000151 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
17777 | 17777 | Edward Holland H000716 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17917 | 17917 | Edward Saunders S000077 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17992 | 17992 | Walter Watson W000206 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
18173 | 18173 | Henry Flood F000210 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
18486 | 18486 | Campbell Slemp S000486 | rep | VA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
22316 | 22316 | Andrew Montague M000861 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
23518 | 23518 | Carter Glass G000232 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16416 | 16416 | Jacob Johnson J000141 | rep | UT | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
16810 | 16810 | Joseph Howell H000866 | rep | UT | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
16289 | 16289 | James Beall B000270 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16324 | 16324 | Albert Burleson B001110 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16417 | 16417 | Rienzi Johnston J000196 | sen | TX | 1913-04-07 | 1913-12-31 | 2 | Democrat | appointment | ||||||||||||
16626 | 16626 | Horace Vaughan V000075 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16718 | 16718 | George Burgess B001083 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
16724 | 16724 | Oscar Callaway C000056 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
16799 | 16799 | Robert Henry H000516 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
16985 | 16985 | William Smith S000636 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
17007 | 17007 | John Stephens S000858 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
17147 | 17147 | Martin Dies D000337 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17236 | 17236 | Alexander Gregg G000441 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
17435 | 17435 | James Slayden S000482 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
18027 | 18027 | James Young Y000040 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18210 | 18210 | Rufus Hardy H000198 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
20408 | 20408 | Daniel Garrett G000081 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
21286 | 21286 | John Garner G000074 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
21752 | 21752 | Joe Eagle E000003 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
22062 | 22062 | James Buchanan B001006 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
22409 | 22409 | Morris Sheppard S000337 | sen | TX | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
24113 | 24113 | Hatton Sumners S001072 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
27434 | 27434 | Samuel Rayburn R000082 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16631 | 16631 | William Webb W000232 | sen | TN | 1913-04-07 | 1913-12-31 | 2 | Democrat | |||||||||||||
17057 | 17057 | Richard Austin A000341 | rep | TN | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
17300 | 17300 | William Houston H000829 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17842 | 17842 | John Moon M000884 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17927 | 17927 | Sam Sells S000235 | rep | TN | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
17931 | 17931 | John Shields S000363 | sen | TN | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17941 | 17941 | Thetus Sims S000441 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
18396 | 18396 | Lemuel Padgett P000012 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
19323 | 19323 | Finis Garrett G000082 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
20542 | 20542 | Cordell Hull H000940 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
21672 | 21672 | Joseph Byrns B001217 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
24605 | 24605 | Kenneth McKellar M000499 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16303 | 16303 | Charles Burke B001087 | rep | SD | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
16469 | 16469 | Eben Martin M000176 | rep | SD | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17150 | 17150 | Charles Dillon D000348 | rep | SD | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
17968 | 17968 | Thomas Sterling S000872 | sen | SD | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16450 | 16450 | George Legaré L000219 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16618 | 16618 | Benjamin Tillman T000274 | sen | SC | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16674 | 16674 | Wyatt Aiken A000064 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16831 | 16831 | Joseph Johnson J000156 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17180 | 17180 | David Finley F000131 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17814 | 17814 | Asbury Lever L000259 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
17890 | 17890 | James Ragsdale R000010 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
18009 | 18009 | Richard Whaley W000319 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
22078 | 22078 | James Byrnes B001215 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17367 | 17367 | George O’Shaunessy O000117 | rep | RI | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17628 | 17628 | LeBaron Colt C000651 | sen | RI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
18272 | 18272 | Ambrose Kennedy K000100 | rep | RI | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
23010 | 23010 | Peter Gerry G000141 | rep | RI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16941 | 16941 | Luis Rivera R000279 | rep | PR | 1913-04-07 | 1915-03-03 | Unionist | 0 | |||||||||||||
16753 | 16753 | Manuel Earnshaw E000015 | rep | PI | 1913-04-07 | 1915-03-03 | 0 | ||||||||||||||
16933 | 16933 | Manuel Quezon Q000009 | rep | PI | 1913-04-07 | 1915-03-03 | 0 | ||||||||||||||
16250 | 16250 | William Ainey A000065 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 14 | |||||||||||||
16308 | 16308 | James Burke B001093 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 31 | |||||||||||||
16326 | 16326 | Wooda Carr C000180 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 23 | |||||||||||||
16344 | 16344 | Franklin Dershem D000268 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
16346 | 16346 | Robert Difenderfer D000343 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16348 | 16348 | Michael Donohoe D000418 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 5 |
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);