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 start
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17859 | 17859 | Dick Morgan M000947 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17871 | 17871 | Samuel Nicholls N000088 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17874 | 17874 | Charles Nichols N000090 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
17877 | 17877 | Richard Olney O000080 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
17881 | 17881 | Herbert Pell P000194 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
17885 | 17885 | Michael Phelan P000291 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17889 | 17889 | Edmund Platt P000379 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 26 | |||||||||||||
17893 | 17893 | James Ragsdale R000010 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17895 | 17895 | John Ramsey R000027 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
17898 | 17898 | Charles Randall R000036 | rep | CA | 1919-05-19 | 1921-03-03 | Prohibitionist | 9 | |||||||||||||
17899 | 17899 | Clifford Randall R000038 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17903 | 17903 | Leonidas Robinson R000348 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17904 | 17904 | Joseph Rowan R000472 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 19 | |||||||||||||
17907 | 17907 | Frederick Rowe R000476 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
17909 | 17909 | Jared Sanders S000035 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17912 | 17912 | Rollin Sanford S000053 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 28 | |||||||||||||
17920 | 17920 | Edward Saunders S000077 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17925 | 17925 | Thomas Scully S000206 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17930 | 17930 | Sam Sells S000235 | rep | TN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17944 | 17944 | Thetus Sims S000441 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17955 | 17955 | John Small S000500 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17957 | 17957 | Thomas Smith S000619 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
17967 | 17967 | Henry Steele S000831 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 26 | |||||||||||||
17971 | 17971 | Charles Sulzer S001064 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
17972 | 17972 | Charles Swindall S001121 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17973 | 17973 | King Swope S001129 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17977 | 17977 | Joseph Thompson T000210 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17980 | 17980 | Carl Van Dyke V000034 | rep | MN | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17983 | 17983 | William Venable V000086 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
18004 | 18004 | Edwin Webb W000231 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18006 | 18006 | Milton Welling W000278 | rep | UT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18008 | 18008 | Benjamin Welty W000291 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18012 | 18012 | Richard Whaley W000319 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18014 | 18014 | James Wilson W000593 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
18015 | 18015 | John Wilson W000600 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
18023 | 18023 | William Wilson W000624 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18025 | 18025 | Teodoro Yangco Y000004 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
18030 | 18030 | James Young Y000040 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18034 | 18034 | William Andrews A000251 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
18067 | 18067 | Samuel Brinson B000840 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18069 | 18069 | Edward Brooks B000876 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 20 | |||||||||||||
18071 | 18071 | Edwin Brooks B000877 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 23 | |||||||||||||
18074 | 18074 | William Burke B001101 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18077 | 18077 | Sherman Burroughs B001138 | rep | NH | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18091 | 18091 | Philip Campbell C000097 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18114 | 18114 | Joseph Cannon C000121 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 18 | |||||||||||||
18123 | 18123 | David Classon C000474 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
18132 | 18132 | Ira Copley C000770 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
18138 | 18138 | Thomas Crago C000853 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18146 | 18146 | Jaime De Veyra D000276 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
18156 | 18156 | Thomas Dunn D000553 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 38 | |||||||||||||
18158 | 18158 | Leonard Echols E000030 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18162 | 18162 | John Elston E000161 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18165 | 18165 | Robert Evans E000256 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18176 | 18176 | Henry Flood F000210 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
18188 | 18188 | Joseph Fordney F000271 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
18199 | 18199 | James Good G000275 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18201 | 18201 | Wells Goodykoontz G000308 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18205 | 18205 | Norman Gould G000342 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 36 | |||||||||||||
18213 | 18213 | Rufus Hardy H000198 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18215 | 18215 | John Harreld H000227 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18217 | 18217 | Edward Hays H000403 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
18223 | 18223 | Frederick Hicks H000564 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18227 | 18227 | Alanson Houghton H000813 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 37 | |||||||||||||
18234 | 18234 | James Husted H001005 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 25 | |||||||||||||
18238 | 18238 | Elijah Hutchinson H001012 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18241 | 18241 | Clifford Ireland I000030 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 16 | |||||||||||||
18247 | 18247 | Henderson Jacoway J000041 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
18249 | 18249 | Rorer James J000052 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
18251 | 18251 | Albert Jefferis J000067 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18253 | 18253 | Paul Johnson J000166 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18255 | 18255 | Evan Jones J000217 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 21 | |||||||||||||
18265 | 18265 | Jonah Kalanianaole K000004 | rep | HI | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18270 | 18270 | Patrick Kelley K000061 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18275 | 18275 | Ambrose Kennedy K000100 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18285 | 18285 | Moses Kinkaid K000221 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18289 | 18289 | John Kleczka K000260 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18295 | 18295 | Milton Kraus K000323 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
18300 | 18300 | Aaron Kreider K000327 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 18 | |||||||||||||
18304 | 18304 | Caleb Layton L000151 | rep | DE | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
18317 | 18317 | Willfred Lufkin L000503 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18319 | 18319 | Oscar Luhring L000505 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18333 | 18333 | James Mann M000104 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18339 | 18339 | William Mason M000228 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18343 | 18343 | Clifton McArthur M000298 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18352 | 18352 | William McKinley M000521 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 19 | |||||||||||||
18356 | 18356 | Isaac McPherson M000592 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
18370 | 18370 | Franklin Mondell M000852 | rep | WY | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
18374 | 18374 | Adolphus Nelson N000029 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
18380 | 18380 | John Nolan N000124 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18383 | 18383 | Charles Ogden O000042 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18388 | 18388 | James Overstreet O000143 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18399 | 18399 | Lemuel Padgett P000012 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18413 | 18413 | Lucian Parrish P000083 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 13 |
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);