legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
494 rows where "end" is on date 1915-03-03 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17927 | 17927 | Sam Sells S000235 | rep | TN | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
17952 | 17952 | John Small S000500 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
18009 | 18009 | Richard Whaley W000319 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
18565 | 18565 | Sydney Anderson A000233 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
19190 | 19190 | Daniel Anthony A000261 | rep | KS | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
19256 | 19256 | Thaddeus Caraway C000139 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
19410 | 19410 | Martin Madden M000038 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
19519 | 19519 | William Vare V000071 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
19734 | 19734 | Frank Greene G000425 | rep | VT | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
20241 | 20241 | Henry Cooper C000752 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
20343 | 20343 | Charles Edwards E000062 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
20500 | 20500 | Willis Hawley H000379 | rep | OR | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
21379 | 21379 | Augustine Lonergan L000409 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
23711 | 23711 | Allen Treadway T000358 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
25867 | 25867 | Alben Barkley B000145 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
26063 | 26063 | Matthew Neely N000023 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16260 | 16260 | Jacob Baker B000065 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16303 | 16303 | Charles Burke B001087 | rep | SD | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
16390 | 16390 | Winfield Hammond H000135 | rep | MN | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16461 | 16461 | Bryan Mahan M000061 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16503 | 16503 | Denis O’Leary O000064 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16525 | 16525 | Irvin Pepper P000220 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16533 | 16533 | Frank Plumley P000396 | rep | VT | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
16551 | 16551 | Seaborn Roddenbery R000370 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16558 | 16558 | Harry Seldomridge S000234 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16595 | 16595 | Raymond Stevens S000885 | rep | NH | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16627 | 16627 | Henry Vollmer V000113 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16677 | 16677 | Alfred Allen A000111 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16707 | 16707 | William Brown B000949 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16721 | 16721 | Michael Burke B001095 | rep | WI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16739 | 16739 | William Cullop C000975 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16882 | 16882 | Daniel McGillicuddy M000448 | rep | ME | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17024 | 17024 | Joseph Taggart T000011 | rep | KS | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17057 | 17057 | Richard Austin A000341 | rep | TN | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
17070 | 17070 | Samuel Beakes B000264 | rep | MI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17147 | 17147 | Martin Dies D000337 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17342 | 17342 | Charles Lobeck L000385 | rep | NE | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17486 | 17486 | Joshua Talbott T000021 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17637 | 17637 | Stanley Dent D000256 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17777 | 17777 | Edward Holland H000716 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17856 | 17856 | Dick Morgan M000947 | rep | OK | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
17963 | 17963 | Augustus Stanley S000796 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18330 | 18330 | James Mann M000104 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
18463 | 18463 | William Rucker R000494 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18587 | 18587 | Frank Clark C000430 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18620 | 18620 | Henry Dupré D000561 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18714 | 18714 | Claude Kitchin K000250 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18799 | 18799 | Frank Park P000051 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18901 | 18901 | George Young Y000036 | rep | ND | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
18969 | 18969 | Frederick Gillett G000201 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
19064 | 19064 | John Raker R000019 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19447 | 19447 | William Oldfield O000062 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19480 | 19480 | Nicholas Sinnott S000450 | rep | OR | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
19991 | 19991 | Hubert Stephens S000857 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
20434 | 20434 | George Graham G000354 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
20564 | 20564 | Albert Johnson J000114 | rep | WA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
22078 | 22078 | James Byrnes B001215 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
23010 | 23010 | Peter Gerry G000141 | rep | RI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16255 | 16255 | Samuel Avis A000348 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
16336 | 16336 | Henry Clayton C000495 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16337 | 16337 | Maurice Connolly C000699 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16352 | 16352 | John Faison F000008 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16362 | 16362 | John Floyd F000222 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16378 | 16378 | Forrest Goodwin G000298 | rep | ME | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
16379 | 16379 | George Gorman G000327 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16432 | 16432 | George Konig K000308 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16438 | 16438 | Abraham Lafferty L000015 | rep | OR | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
16469 | 16469 | Eben Martin M000176 | rep | SD | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
16490 | 16490 | William Mulkey M001070 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16540 | 16540 | Thomas Reilly R000156 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16640 | 16640 | William Wilder W000462 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
16645 | 16645 | Frank Wilson W000580 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16674 | 16674 | Wyatt Aiken A000064 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16704 | 16704 | Robert Broussard B000896 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16746 | 16746 | James Davenport D000074 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17037 | 17037 | Emmett Wilson W000575 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17122 | 17122 | William Cox C000840 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17335 | 17335 | William La Follette L000006 | rep | WA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17363 | 17363 | Patrick Norton N000156 | rep | ND | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17446 | 17446 | Dan Stephens S000856 | rep | NE | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17535 | 17535 | Joshua Alexander A000098 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17624 | 17624 | Charles Coady C000541 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17713 | 17713 | Warren Gard G000048 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17842 | 17842 | John Moon M000884 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17850 | 17850 | Joseph Moore M000906 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17922 | 17922 | Thomas Scully S000206 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18027 | 18027 | James Young Y000040 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18088 | 18088 | Philip Campbell C000097 | rep | KS | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18272 | 18272 | Ambrose Kennedy K000100 | rep | RI | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18416 | 18416 | John Peters P000253 | rep | ME | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18612 | 18612 | Charles Davis D000093 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18686 | 18686 | Benjamin Humphreys H000960 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18793 | 18793 | Calvin Paige P000024 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18850 | 18850 | John Smith S000573 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
19124 | 19124 | Robert Thomas T000185 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
19637 | 19637 | Charles Curry C001000 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
20261 | 20261 | Charles Crisp C000909 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
20750 | 20750 | John Nelson N000039 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
22316 | 22316 | Andrew Montague M000861 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16349 | 16349 | Jeremiah Donovan D000422 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 4 |
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);