legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
496 rows where "start" is on date 1917-04-02 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17970 | 17970 | Charles Sulzer S001064 | rep | AK | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
21005 | 21005 | James Wickersham W000438 | rep | AK | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
17230 | 17230 | Oscar Gray G000401 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17589 | 17589 | John Burnett B001121 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17639 | 17639 | Stanley Dent D000256 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18046 | 18046 | Fred Blackmon B000514 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18986 | 18986 | James Heflin H000446 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
21081 | 21081 | Edward Almon A000162 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21819 | 21819 | George Huddleston H000903 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
21901 | 21901 | William Oliver O000077 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
22488 | 22488 | William Bankhead B000113 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
23688 | 23688 | Henry Steagall S000820 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17740 | 17740 | William Goodwin G000304 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18246 | 18246 | Henderson Jacoway J000041 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
18518 | 18518 | Samuel Taylor T000100 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
19258 | 19258 | Thaddeus Caraway C000139 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19449 | 19449 | William Oldfield O000062 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19505 | 19505 | John Tillman T000276 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
20052 | 20052 | Otis Wingo W000635 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21623 | 21623 | Henry Ashurst A000319 | sen | AZ | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
27846 | 27846 | Carl Hayden H000385 | rep | AZ | 1917-04-02 | 1919-03-03 | Democrat | 0 | |||||||||||||
17258 | 17258 | Everis Hayes H000389 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17802 | 17802 | William Kettner K000155 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
17897 | 17897 | Charles Randall R000036 | rep | CA | 1917-04-02 | 1919-03-03 | Prohibitionist | 9 | |||||||||||||
18161 | 18161 | John Elston E000161 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
18379 | 18379 | John Nolan N000124 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
18704 | 18704 | Julius Kahn K000003 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
18789 | 18789 | Henry Osborne O000112 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
19066 | 19066 | John Raker R000019 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19639 | 19639 | Charles Curry C001000 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
21197 | 21197 | Denver Church C000387 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
23072 | 23072 | Hiram Johnson J000140 | sen | CA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
24535 | 24535 | Clarence Lea L000163 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17285 | 17285 | Benjamin Hilliard H000620 | rep | CO | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17325 | 17325 | Edward Keating K000035 | rep | CO | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
20944 | 20944 | Charles Timberlake T000281 | rep | CO | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
23274 | 23274 | Edward Taylor T000072 | rep | CO | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17283 | 17283 | Ebenezer Hill H000591 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
18757 | 18757 | George McLean M000547 | sen | CT | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
19726 | 19726 | James Glynn G000246 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
20379 | 20379 | Richard Freeman F000366 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20935 | 20935 | John Tilson T000279 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
21380 | 21380 | Augustine Lonergan L000409 | rep | CT | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
21880 | 21880 | Schuyler Merritt M000663 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17379 | 17379 | Albert Polk P000407 | rep | DE | 1917-04-02 | 1919-03-03 | Democrat | 0 | |||||||||||||
17514 | 17514 | Josiah Wolcott W000669 | sen | DE | 1917-04-02 | 1921-12-31 | 1 | Democrat | |||||||||||||
17326 | 17326 | James Kehoe K000046 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18589 | 18589 | Frank Clark C000430 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
20311 | 20311 | Herbert Drane D000486 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
21961 | 21961 | William Sears S000211 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21977 | 21977 | Park Trammell T000353 | sen | FL | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17054 | 17054 | William Adamson A000051 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17306 | 17306 | William Howard H000849 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17499 | 17499 | John Walker W000060 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
18387 | 18387 | James Overstreet O000143 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18801 | 18801 | Frank Park P000051 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18896 | 18896 | James Wise W000650 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
19026 | 19026 | Gordon Lee L000194 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19580 | 19580 | Thomas Bell B000348 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
20263 | 20263 | Charles Crisp C000909 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
20636 | 20636 | William Larsen L000103 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
21031 | 21031 | William Wright W000773 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21133 | 21133 | Charles Brand B000767 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
28205 | 28205 | Carl Vinson V000105 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
18264 | 18264 | Jonah Kalanianaole K000004 | rep | HI | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17404 | 17404 | George Scott S000170 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
17519 | 17519 | Frank Woods W000721 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17795 | 17795 | Charles Kennedy K000104 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18198 | 18198 | James Good G000275 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
18511 | 18511 | Burton Sweet S001106 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18677 | 18677 | Harry Hull H000941 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18870 | 18870 | Horace Towner T000325 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
19336 | 19336 | William Green G000422 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
20489 | 20489 | Gilbert Haugen H000350 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
20799 | 20799 | Christian Ramseyer R000031 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
22572 | 22572 | Cassius Dowell D000468 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
20392 | 20392 | Burton French F000375 | rep | ID | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
20860 | 20860 | Addison Smith S000511 | rep | ID | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17205 | 17205 | George Foss F000295 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17211 | 17211 | Martin Foster F000309 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 23 | |||||||||||||
17346 | 17346 | Charles Martin M000170 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17456 | 17456 | John Sterling S000870 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 17 | |||||||||||||
17708 | 17708 | Thomas Gallagher G000018 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17788 | 17788 | Niels Juul J000282 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
17828 | 17828 | Joseph McCormick M000369 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18022 | 18022 | William Wilson W000624 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18113 | 18113 | Joseph Cannon C000121 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 18 | |||||||||||||
18131 | 18131 | Ira Copley C000770 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
18240 | 18240 | Clifford Ireland I000030 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 16 | |||||||||||||
18332 | 18332 | James Mann M000104 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18338 | 18338 | William Mason M000228 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18351 | 18351 | William McKinley M000521 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 19 | |||||||||||||
18449 | 18449 | William Rodenberg R000371 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 22 | |||||||||||||
18656 | 18656 | William Graham G000364 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 14 | |||||||||||||
18752 | 18752 | John McKenzie M000506 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 13 | |||||||||||||
18805 | 18805 | John Rainey R000015 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18951 | 18951 | Charles Fuller F000407 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
19160 | 19160 | Loren Wheeler W000339 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 21 | |||||||||||||
19379 | 19379 | Edward King K000200 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 15 | |||||||||||||
19412 | 19412 | Martin Madden M000038 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 1 |
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);