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 district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16740 | 16740 | William Cullop C000975 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16883 | 16883 | Daniel McGillicuddy M000448 | rep | ME | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17025 | 17025 | Joseph Taggart T000011 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17058 | 17058 | Richard Austin A000341 | rep | TN | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17071 | 17071 | Samuel Beakes B000264 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17148 | 17148 | Martin Dies D000337 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17343 | 17343 | Charles Lobeck L000385 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17487 | 17487 | Joshua Talbott T000021 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17591 | 17591 | Charles Caldwell C000030 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17638 | 17638 | Stanley Dent D000256 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17658 | 17658 | Franklin Ellsworth E000145 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17778 | 17778 | Edward Holland H000716 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17825 | 17825 | James Mays M000290 | rep | UT | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18055 | 18055 | George Bowers B000690 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18331 | 18331 | James Mann M000104 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18464 | 18464 | William Rucker R000494 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18504 | 18504 | Walter Stiness S000927 | rep | RI | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18588 | 18588 | Frank Clark C000430 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18621 | 18621 | Henry Dupré D000561 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18676 | 18676 | Harry Hull H000941 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18715 | 18715 | Claude Kitchin K000250 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18800 | 18800 | Frank Park P000051 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18902 | 18902 | George Young Y000036 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18970 | 18970 | Frederick Gillett G000201 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19065 | 19065 | John Raker R000019 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19280 | 19280 | Porter Dale D000009 | rep | VT | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19448 | 19448 | William Oldfield O000062 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19481 | 19481 | Nicholas Sinnott S000450 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19825 | 19825 | David Kincheloe K000187 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19992 | 19992 | Hubert Stephens S000857 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
20378 | 20378 | Richard Freeman F000366 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20435 | 20435 | George Graham G000354 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20445 | 20445 | Lindley Hadley H000008 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20575 | 20575 | Royal Johnson J000173 | rep | SD | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20943 | 20943 | Charles Timberlake T000281 | rep | CO | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20985 | 20985 | Edward Wason W000185 | rep | NH | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
21306 | 21306 | William Hastings H000333 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
21629 | 21629 | Isaac Bacharach B000009 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
22079 | 22079 | James Byrnes B001215 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16675 | 16675 | Wyatt Aiken A000064 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17038 | 17038 | Emmett Wilson W000575 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17123 | 17123 | William Cox C000840 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17193 | 17193 | Joseph Flynn F000228 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17294 | 17294 | George Hood H000755 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17324 | 17324 | Edward Keating K000035 | rep | CO | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17339 | 17339 | Adam Littlepage L000358 | rep | WV | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17364 | 17364 | Patrick Norton N000156 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
17447 | 17447 | Dan Stephens S000856 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17536 | 17536 | Joshua Alexander A000098 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17625 | 17625 | Charles Coady C000541 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17710 | 17710 | Harry Gandy G000037 | rep | SD | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17714 | 17714 | Warren Gard G000048 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17843 | 17843 | John Moon M000884 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17851 | 17851 | Joseph Moore M000906 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
17923 | 17923 | Thomas Scully S000206 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18021 | 18021 | William Wilson W000624 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18028 | 18028 | James Young Y000040 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18089 | 18089 | Philip Campbell C000097 | rep | KS | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18273 | 18273 | Ambrose Kennedy K000100 | rep | RI | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18341 | 18341 | Clifton McArthur M000298 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18417 | 18417 | John Peters P000253 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18510 | 18510 | Burton Sweet S001106 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18613 | 18613 | Charles Davis D000093 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18687 | 18687 | Benjamin Humphreys H000960 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18794 | 18794 | Calvin Paige P000024 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18851 | 18851 | John Smith S000573 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18920 | 18920 | Charles Carter C000196 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
19125 | 19125 | Robert Thomas T000185 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
19504 | 19504 | John Tillman T000276 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
19638 | 19638 | Charles Curry C001000 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
19857 | 19857 | Whitmell Martin M000201 | rep | LA | 1915-12-06 | 1917-03-03 | Progressive | 3 | |||||||||||||
20262 | 20262 | Charles Crisp C000909 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
20565 | 20565 | Albert Johnson J000114 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
20751 | 20751 | John Nelson N000039 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
20934 | 20934 | John Tilson T000279 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
22317 | 22317 | Andrew Montague M000861 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
23687 | 23687 | Henry Steagall S000820 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
16778 | 16778 | Frank Guernsey G000517 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
16832 | 16832 | Joseph Johnson J000156 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16880 | 16880 | James McDermott M000405 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16897 | 16897 | Hunter Moss M001034 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
16903 | 16903 | William Murray M001118 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16953 | 16953 | Joshua Russell R000534 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17053 | 17053 | William Adamson A000051 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17102 | 17102 | William Cary C000218 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17130 | 17130 | Harry Dale D000008 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17158 | 17158 | Lincoln Dixon D000374 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17161 | 17161 | Dudley Doolittle D000427 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17282 | 17282 | Ebenezer Hill H000591 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17336 | 17336 | William La Follette L000006 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17568 | 17568 | Charles Booher B000626 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17759 | 17759 | Edward Hamilton H000108 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17869 | 17869 | Samuel Nicholls N000088 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17978 | 17978 | Carl Van Dyke V000034 | rep | MN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17989 | 17989 | John Watkins W000193 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17993 | 17993 | Walter Watson W000206 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18045 | 18045 | Fred Blackmon B000514 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18236 | 18236 | Elijah Hutchinson H001012 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
18479 | 18479 | Thomas Sisson S000456 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18703 | 18703 | Julius Kahn K000003 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 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);