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 party descending
This data as json, copyable, CSV (advanced)
Suggested facets: party, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20331 | 20331 | Félix Dávila D000090 | rep | PR | 1919-05-19 | 1921-03-03 | Unionist | 0 | |||||||||||||
19262 | 19262 | William Carss C000194 | rep | MN | 1919-05-19 | 1921-03-03 | Union Labor | 8 | |||||||||||||
19208 | 19208 | Victor Berger B000407 | rep | WI | 1919-05-19 | 1921-03-03 | Socialist | -1 | |||||||||||||
16773 | 16773 | Asle Gronna G000491 | sen | ND | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
16929 | 16929 | Boies Penrose P000217 | sen | PA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
16955 | 16955 | Lawrence Sherman S000348 | sen | IL | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
17539 | 17539 | William Andrews A000253 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17542 | 17542 | John Baer B000027 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17575 | 17575 | William Browning B000961 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17632 | 17632 | Peter Costello C000796 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
17634 | 17634 | Gilbert Currie C000998 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17660 | 17660 | Franklin Ellsworth E000145 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
17663 | 17663 | Henry Emerson E000171 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 22 | |||||||||||||
17674 | 17674 | John Esch E000212 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
17690 | 17690 | John Farr F000029 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17703 | 17703 | Alvan Fuller F000405 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
17719 | 17719 | Mahlon Garland G000068 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
17736 | 17736 | Louis Goodall G000276 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17761 | 17761 | Edward Hamilton H000108 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
17764 | 17764 | Reuben Haskell H000319 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17773 | 17773 | Benigno Hernández H000532 | rep | NM | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17775 | 17775 | William Hill H000610 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 34 | |||||||||||||
17782 | 17782 | Willis Hulings H000939 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 28 | |||||||||||||
17789 | 17789 | Niels Juul J000282 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
17796 | 17796 | Charles Kennedy K000104 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
17853 | 17853 | Joseph Moore M000906 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17859 | 17859 | Dick Morgan M000947 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17874 | 17874 | Charles Nichols N000090 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
17889 | 17889 | Edmund Platt P000379 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 26 | |||||||||||||
17895 | 17895 | John Ramsey R000027 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
17899 | 17899 | Clifford Randall R000038 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17907 | 17907 | Frederick Rowe R000476 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
17912 | 17912 | Rollin Sanford S000053 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 28 | |||||||||||||
17930 | 17930 | Sam Sells S000235 | rep | TN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
18023 | 18023 | William Wilson W000624 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
18251 | 18251 | Albert Jefferis J000067 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 |
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);