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 state
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class
start (date) 7 ✖
- 1919-05-19 466
- 1915-12-06 24
- 1918-01-01 4
- 1916-01-01 2
- 1918-01-12 1
- 1918-01-22 1
- 1920-03-05 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17742 | 17742 | George Grigsby G000474 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
17971 | 17971 | Charles Sulzer S001064 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
21006 | 21006 | James Wickersham W000438 | rep | AK | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
17558 | 17558 | John Bankhead B000110 | sen | AL | 1919-05-19 | 1921-03-03 | 2 | Democrat | |||||||||||||
17590 | 17590 | John Burnett B001121 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17640 | 17640 | Stanley Dent D000256 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18031 | 18031 | Braxton Comer C000657 | sen | AL | 1920-03-05 | 1921-03-03 | 2 | Democrat | appointment | ||||||||||||
18047 | 18047 | Fred Blackmon B000514 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18425 | 18425 | Lilius Rainey R000017 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18534 | 18534 | Oscar Underwood U000013 | sen | AL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
19229 | 19229 | William Bowling B000702 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
21082 | 21082 | Edward Almon A000162 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21820 | 21820 | George Huddleston H000903 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
21863 | 21863 | John McDuffie M000427 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
21902 | 21902 | William Oliver O000077 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
22489 | 22489 | William Bankhead B000113 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
23689 | 23689 | Henry Steagall S000820 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17042 | 17042 | William Kirby K000233 | sen | AR | 1916-01-01 | 1921-03-03 | 3 | Democrat | |||||||||||||
17741 | 17741 | William Goodwin G000304 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18247 | 18247 | Henderson Jacoway J000041 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
18519 | 18519 | Samuel Taylor T000100 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
19259 | 19259 | Thaddeus Caraway C000139 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19450 | 19450 | William Oldfield O000062 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19506 | 19506 | John Tillman T000276 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20053 | 20053 | Otis Wingo W000635 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
16979 | 16979 | Marcus Smith S000589 | sen | AZ | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
27847 | 27847 | Carl Hayden H000385 | rep | AZ | 1919-05-19 | 1921-03-03 | Democrat | 0 | |||||||||||||
16930 | 16930 | James Phelan P000290 | sen | CA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17774 | 17774 | Hugh Hersman H000546 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17803 | 17803 | William Kettner K000155 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
17898 | 17898 | Charles Randall R000036 | rep | CA | 1919-05-19 | 1921-03-03 | Prohibitionist | 9 | |||||||||||||
18162 | 18162 | John Elston E000161 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18380 | 18380 | John Nolan N000124 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18705 | 18705 | Julius Kahn K000003 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18790 | 18790 | Henry Osborne O000112 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
19067 | 19067 | John Raker R000019 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19640 | 19640 | Charles Curry C001000 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
20113 | 20113 | Henry Barbour B000126 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
24536 | 24536 | Clarence Lea L000163 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17029 | 17029 | Charles Thomas T000160 | sen | CO | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
19513 | 19513 | William Vaile V000004 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20468 | 20468 | Guy Hardy H000195 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
20945 | 20945 | Charles Timberlake T000281 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
23275 | 23275 | Edward Taylor T000072 | rep | CO | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18064 | 18064 | Frank Brandegee B000769 | sen | CT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19727 | 19727 | James Glynn G000246 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
20380 | 20380 | Richard Freeman F000366 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20936 | 20936 | John Tilson T000279 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
21381 | 21381 | Augustine Lonergan L000409 | rep | CT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
21881 | 21881 | Schuyler Merritt M000663 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18304 | 18304 | Caleb Layton L000151 | rep | DE | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
18590 | 18590 | Frank Clark C000430 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19109 | 19109 | John Smithwick S000643 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20312 | 20312 | Herbert Drane D000486 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
21260 | 21260 | Duncan Fletcher F000200 | sen | FL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
21962 | 21962 | William Sears S000211 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
16965 | 16965 | Hoke Smith S000551 | sen | GA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18388 | 18388 | James Overstreet O000143 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18802 | 18802 | Frank Park P000051 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18897 | 18897 | James Wise W000650 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
19027 | 19027 | Gordon Lee L000194 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19137 | 19137 | William Upshaw U000026 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19581 | 19581 | Thomas Bell B000348 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
20264 | 20264 | Charles Crisp C000909 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20629 | 20629 | William Lankford L000082 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
20637 | 20637 | William Larsen L000103 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
21032 | 21032 | William Wright W000773 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21134 | 21134 | Charles Brand B000767 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
28206 | 28206 | Carl Vinson V000105 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
18265 | 18265 | Jonah Kalanianaole K000004 | rep | HI | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
17796 | 17796 | Charles Kennedy K000104 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18143 | 18143 | Albert Cummins C000988 | sen | IA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18199 | 18199 | James Good G000275 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18512 | 18512 | Burton Sweet S001106 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18678 | 18678 | Harry Hull H000941 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18871 | 18871 | Horace Towner T000325 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
19222 | 19222 | William Boies B000597 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
19337 | 19337 | William Green G000422 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
20293 | 20293 | Lester Dickinson D000323 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
20490 | 20490 | Gilbert Haugen H000350 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
20800 | 20800 | Christian Ramseyer R000031 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
22573 | 22573 | Cassius Dowell D000468 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
17529 | 17529 | John Nugent N000169 | sen | ID | 1918-01-22 | 1921-03-03 | 3 | Democrat | appointment | ||||||||||||
20393 | 20393 | Burton French F000375 | rep | ID | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20861 | 20861 | Addison Smith S000511 | rep | ID | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
16955 | 16955 | Lawrence Sherman S000348 | sen | IL | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
17709 | 17709 | Thomas Gallagher G000018 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17789 | 17789 | Niels Juul J000282 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
18023 | 18023 | William Wilson W000624 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18071 | 18071 | Edwin Brooks B000877 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 23 | |||||||||||||
18114 | 18114 | Joseph Cannon C000121 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 18 | |||||||||||||
18132 | 18132 | Ira Copley C000770 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
18241 | 18241 | Clifford Ireland I000030 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 16 | |||||||||||||
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 | |||||||||||||
18352 | 18352 | William McKinley M000521 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 19 | |||||||||||||
18450 | 18450 | William Rodenberg R000371 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 22 | |||||||||||||
18657 | 18657 | William Graham G000364 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
18753 | 18753 | John McKenzie M000506 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
18806 | 18806 | John Rainey R000015 | rep | IL | 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);