legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1921-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26066 | 26066 | Matthew Neely N000023 | rep | WV | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17561 | 17561 | Carville Benson B000387 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17593 | 17593 | Charles Caldwell C000030 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17640 | 17640 | Stanley Dent D000256 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17660 | 17660 | Franklin Ellsworth E000145 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
17780 | 17780 | Edward Holland H000716 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17827 | 17827 | James Mays M000290 | rep | UT | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18052 | 18052 | Oscar Bland B000542 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18057 | 18057 | George Bowers B000690 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18251 | 18251 | Albert Jefferis J000067 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18333 | 18333 | James Mann M000104 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18439 | 18439 | Carl Riddick R000237 | rep | MT | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18466 | 18466 | William Rucker R000494 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18506 | 18506 | Walter Stiness S000927 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18590 | 18590 | Frank Clark C000430 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18623 | 18623 | Henry Dupré D000561 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18678 | 18678 | Harry Hull H000941 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18717 | 18717 | Claude Kitchin K000250 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18732 | 18732 | Edward Little L000349 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18802 | 18802 | Frank Park P000051 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18904 | 18904 | George Young Y000036 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18972 | 18972 | Frederick Gillett G000201 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19067 | 19067 | John Raker R000019 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19142 | 19142 | Edward Voigt V000110 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19282 | 19282 | Porter Dale D000009 | rep | VT | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19450 | 19450 | William Oldfield O000062 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19483 | 19483 | Nicholas Sinnott S000450 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19493 | 19493 | Ambrose Stephens S000855 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19588 | 19588 | John Box B000710 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19827 | 19827 | David Kincheloe K000187 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19994 | 19994 | Hubert Stephens S000857 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
20380 | 20380 | Richard Freeman F000366 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20437 | 20437 | George Graham G000354 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20447 | 20447 | Lindley Hadley H000008 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20577 | 20577 | Royal Johnson J000173 | rep | SD | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20861 | 20861 | Addison Smith S000511 | rep | ID | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20945 | 20945 | Charles Timberlake T000281 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20987 | 20987 | Edward Wason W000185 | rep | NH | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
21308 | 21308 | William Hastings H000333 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
21631 | 21631 | Isaac Bacharach B000009 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
22081 | 22081 | James Byrnes B001215 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
22805 | 22805 | James Taylor T000083 | rep | TN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
23748 | 23748 | Wallace White W000396 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
24933 | 24933 | Earl Michener M000693 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
17538 | 17538 | Joshua Alexander A000098 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17627 | 17627 | Charles Coady C000541 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17712 | 17712 | Harry Gandy G000037 | rep | SD | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17716 | 17716 | Warren Gard G000048 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17818 | 17818 | John MacCrate M000002 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17833 | 17833 | James Monahan M000849 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17845 | 17845 | John Moon M000884 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17853 | 17853 | Joseph Moore M000906 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17925 | 17925 | Thomas Scully S000206 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18023 | 18023 | William Wilson W000624 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18030 | 18030 | James Young Y000040 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18067 | 18067 | Samuel Brinson B000840 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18091 | 18091 | Philip Campbell C000097 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18165 | 18165 | Robert Evans E000256 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18275 | 18275 | Ambrose Kennedy K000100 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18343 | 18343 | Clifton McArthur M000298 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18419 | 18419 | John Peters P000253 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18512 | 18512 | Burton Sweet S001106 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18615 | 18615 | Charles Davis D000093 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18689 | 18689 | Benjamin Humphreys H000960 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18796 | 18796 | Calvin Paige P000024 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18814 | 18814 | Stuart Reed R000127 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18853 | 18853 | John Smith S000573 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18922 | 18922 | Charles Carter C000196 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19109 | 19109 | John Smithwick S000643 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19127 | 19127 | Robert Thomas T000185 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19506 | 19506 | John Tillman T000276 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19640 | 19640 | Charles Curry C001000 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
19674 | 19674 | James Dunbar D000525 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
19859 | 19859 | Whitmell Martin M000201 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20264 | 20264 | Charles Crisp C000909 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20301 | 20301 | Frederick Dominick D000408 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20468 | 20468 | Guy Hardy H000195 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
20567 | 20567 | Albert Johnson J000114 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
20936 | 20936 | John Tilson T000279 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
21431 | 21431 | Jacob Milligan M000766 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
21543 | 21543 | James Sinclair S000442 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
21932 | 21932 | Harry Ransley R000061 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
22319 | 22319 | Andrew Montague M000861 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
23689 | 23689 | Henry Steagall S000820 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17570 | 17570 | Charles Booher B000626 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17761 | 17761 | Edward Hamilton H000108 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
17871 | 17871 | Samuel Nicholls N000088 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17980 | 17980 | Carl Van Dyke V000034 | rep | MN | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17991 | 17991 | John Watkins W000193 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17995 | 17995 | Walter Watson W000206 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18008 | 18008 | Benjamin Welty W000291 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18040 | 18040 | John Benham B000361 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18047 | 18047 | Fred Blackmon B000514 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18238 | 18238 | Elijah Hutchinson H001012 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18289 | 18289 | John Kleczka K000260 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18481 | 18481 | Thomas Sisson S000456 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18705 | 18705 | Julius Kahn K000003 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18806 | 18806 | John Rainey R000015 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18892 | 18892 | Samuel Winslow W000639 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
19001 | 19001 | Ben Johnson J000118 | rep | KY | 1919-05-19 | 1921-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);