legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1915-12-06 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, end (date)
end 4 ✖
- 1917-03-03 451
- 1921-03-03 24
- 1919-03-03 4
- 1917-12-31 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21004 | 21004 | James Wickersham W000438 | rep | AK | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
16663 | 16663 | John Abercrombie A000013 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
17229 | 17229 | Oscar Gray G000401 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17588 | 17588 | John Burnett B001121 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17638 | 17638 | Stanley Dent D000256 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18045 | 18045 | Fred Blackmon B000514 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18534 | 18534 | Oscar Underwood U000013 | sen | AL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18985 | 18985 | James Heflin H000446 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
21080 | 21080 | Edward Almon A000162 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
21818 | 21818 | George Huddleston H000903 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
21900 | 21900 | William Oliver O000077 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
23687 | 23687 | Henry Steagall S000820 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
16731 | 16731 | James Clarke C000463 | sen | AR | 1915-12-06 | 1917-03-03 | 3 | Democrat | |||||||||||||
17739 | 17739 | William Goodwin G000304 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
18245 | 18245 | Henderson Jacoway J000041 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
18517 | 18517 | Samuel Taylor T000100 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
19257 | 19257 | Thaddeus Caraway C000139 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
19448 | 19448 | William Oldfield O000062 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19504 | 19504 | John Tillman T000276 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
20051 | 20051 | Otis Wingo W000635 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16979 | 16979 | Marcus Smith S000589 | sen | AZ | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
27845 | 27845 | Carl Hayden H000385 | rep | AZ | 1915-12-06 | 1917-03-03 | Democrat | 0 | |||||||||||||
16689 | 16689 | Henry Benedict B000359 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
16837 | 16837 | William Kent K000127 | rep | CA | 1915-12-06 | 1917-03-03 | Independent | 1 | |||||||||||||
16930 | 16930 | James Phelan P000290 | sen | CA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17011 | 17011 | William Stephens S000861 | rep | CA | 1915-12-06 | 1917-03-03 | Progressive | 10 | |||||||||||||
17257 | 17257 | Everis Hayes H000389 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
17801 | 17801 | William Kettner K000155 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
17896 | 17896 | Charles Randall R000036 | rep | CA | 1915-12-06 | 1917-03-03 | Prohibitionist | 9 | |||||||||||||
18160 | 18160 | John Elston E000161 | rep | CA | 1915-12-06 | 1917-03-03 | Progressive | 6 | |||||||||||||
18378 | 18378 | John Nolan N000124 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
18703 | 18703 | Julius Kahn K000003 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
19065 | 19065 | John Raker R000019 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19638 | 19638 | Charles Curry C001000 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
21196 | 21196 | Denver Church C000387 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17029 | 17029 | Charles Thomas T000160 | sen | CO | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17284 | 17284 | Benjamin Hilliard H000620 | rep | CO | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17324 | 17324 | Edward Keating K000035 | rep | CO | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
20943 | 20943 | Charles Timberlake T000281 | rep | CO | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
23273 | 23273 | Edward Taylor T000072 | rep | CO | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16913 | 16913 | Peter Oakey O000002 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17282 | 17282 | Ebenezer Hill H000591 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
18064 | 18064 | Frank Brandegee B000769 | sen | CT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19725 | 19725 | James Glynn G000246 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
20378 | 20378 | Richard Freeman F000366 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20934 | 20934 | John Tilson T000279 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
16887 | 16887 | Thomas Miller M000758 | rep | DE | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
16997 | 16997 | Stephen Sparkman S000702 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17038 | 17038 | Emmett Wilson W000575 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18588 | 18588 | Frank Clark C000430 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
21260 | 21260 | Duncan Fletcher F000200 | sen | FL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
21960 | 21960 | William Sears S000211 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16815 | 16815 | Dudley Hughes H000920 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
16952 | 16952 | Tinsley Rucker R000493 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
16965 | 16965 | Hoke Smith S000551 | sen | GA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17032 | 17032 | Samuel Tribble T000366 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17053 | 17053 | William Adamson A000051 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17305 | 17305 | William Howard H000849 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17498 | 17498 | John Walker W000060 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
18800 | 18800 | Frank Park P000051 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18895 | 18895 | James Wise W000650 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
19025 | 19025 | Gordon Lee L000194 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19579 | 19579 | Thomas Bell B000348 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
20262 | 20262 | Charles Crisp C000909 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
20344 | 20344 | Charles Edwards E000062 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
28204 | 28204 | Carl Vinson V000105 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
18263 | 18263 | Jonah Kalanianaole K000004 | rep | HI | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
16998 | 16998 | Thomas Steele S000837 | rep | IA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
17518 | 17518 | Frank Woods W000721 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17794 | 17794 | Charles Kennedy K000104 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
18143 | 18143 | Albert Cummins C000988 | sen | IA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18197 | 18197 | James Good G000275 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
18510 | 18510 | Burton Sweet S001106 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18676 | 18676 | Harry Hull H000941 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18869 | 18869 | Horace Towner T000325 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
19335 | 19335 | William Green G000422 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
20488 | 20488 | Gilbert Haugen H000350 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
20798 | 20798 | Christian Ramseyer R000031 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
22571 | 22571 | Cassius Dowell D000468 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
16695 | 16695 | James Brady B000753 | sen | ID | 1915-12-06 | 1919-03-03 | 3 | Republican | |||||||||||||
16875 | 16875 | Robert McCracken M000378 | rep | ID | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
20859 | 20859 | Addison Smith S000511 | rep | ID | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
16711 | 16711 | Frank Buchanan B001001 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
16880 | 16880 | James McDermott M000405 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16955 | 16955 | Lawrence Sherman S000348 | sen | IL | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
17014 | 17014 | Claudius Stone S000954 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
17027 | 17027 | Clyde Tavenner T000059 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17036 | 17036 | William Williams W000548 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
17204 | 17204 | George Foss F000295 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17210 | 17210 | Martin Foster F000309 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 23 | |||||||||||||
17455 | 17455 | John Sterling S000870 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 17 | |||||||||||||
17707 | 17707 | Thomas Gallagher G000018 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
18021 | 18021 | William Wilson W000624 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18112 | 18112 | Joseph Cannon C000121 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 18 | |||||||||||||
18130 | 18130 | Ira Copley C000770 | rep | IL | 1915-12-06 | 1917-03-03 | Progressive | 11 | |||||||||||||
18331 | 18331 | James Mann M000104 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18350 | 18350 | William McKinley M000521 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 19 | |||||||||||||
18448 | 18448 | William Rodenberg R000371 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 22 | |||||||||||||
18751 | 18751 | John McKenzie M000506 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
18950 | 18950 | Charles Fuller F000407 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 12 |
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);