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 address
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
18031 | 18031 | Braxton Comer C000657 | sen | AL | 1920-03-05 | 1921-03-03 | 2 | Democrat | appointment | ||||||||||||
18032 | 18032 | Warren Harding H000192 | sen | OH | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
18064 | 18064 | Frank Brandegee B000769 | sen | CT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
18143 | 18143 | Albert Cummins C000988 | sen | IA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18146 | 18146 | Jaime De Veyra D000276 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
18151 | 18151 | William Dillingham D000347 | sen | VT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
18311 | 18311 | Irvine Lenroot L000241 | sen | WI | 1918-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
18419 | 18419 | John Peters P000253 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18423 | 18423 | Amos Radcliffe R000005 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
18425 | 18425 | Lilius Rainey R000017 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18429 | 18429 | Charles Reavis R000101 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18431 | 18431 | John Reber R000102 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
18434 | 18434 | Marion Rhodes R000190 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
18437 | 18437 | Edwin Ricketts R000236 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
18439 | 18439 | Carl Riddick R000237 | rep | MT | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18450 | 18450 | William Rodenberg R000371 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 22 | |||||||||||||
18453 | 18453 | John Rose R000437 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 19 | |||||||||||||
18466 | 18466 | William Rucker R000494 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 2 |
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);