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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17672 | 17672 | John Esch E000212 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
17679 | 17679 | Albert Estopinal E000224 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17688 | 17688 | John Farr F000029 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17695 | 17695 | Scott Ferris F000091 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17707 | 17707 | Thomas Gallagher G000018 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
17717 | 17717 | Mahlon Garland G000068 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
17724 | 17724 | Hannibal Godwin G000250 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17739 | 17739 | William Goodwin G000304 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17747 | 17747 | James Hamill H000099 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
17759 | 17759 | Edward Hamilton H000108 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17762 | 17762 | Reuben Haskell H000319 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17769 | 17769 | Harvey Helm H000461 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17772 | 17772 | Benigno Hernández H000532 | rep | NM | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17778 | 17778 | Edward Holland H000716 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17784 | 17784 | William Igoe I000005 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
17794 | 17794 | Charles Kennedy K000104 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17801 | 17801 | William Kettner K000155 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
17805 | 17805 | John Lesher L000250 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
17815 | 17815 | Asbury Lever L000259 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17821 | 17821 | James Maher M000063 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17825 | 17825 | James Mays M000290 | rep | UT | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
17857 | 17857 | Dick Morgan M000947 | rep | OK | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
17869 | 17869 | Samuel Nicholls N000088 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17872 | 17872 | Charles Nichols N000090 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
17875 | 17875 | Richard Olney O000080 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17883 | 17883 | Michael Phelan P000291 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17887 | 17887 | Edmund Platt P000379 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 26 | |||||||||||||
17891 | 17891 | James Ragsdale R000010 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17896 | 17896 | Charles Randall R000036 | rep | CA | 1915-12-06 | 1917-03-03 | Prohibitionist | 9 | |||||||||||||
17905 | 17905 | Frederick Rowe R000476 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
17910 | 17910 | Rollin Sanford S000053 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 28 | |||||||||||||
17918 | 17918 | Edward Saunders S000077 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17923 | 17923 | Thomas Scully S000206 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17928 | 17928 | Sam Sells S000235 | rep | TN | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17942 | 17942 | Thetus Sims S000441 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17953 | 17953 | John Small S000500 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17965 | 17965 | Henry Steele S000831 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 26 | |||||||||||||
17975 | 17975 | Joseph Thompson T000210 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17978 | 17978 | Carl Van Dyke V000034 | rep | MN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17981 | 17981 | William Venable V000086 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
18002 | 18002 | Edwin Webb W000231 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
18010 | 18010 | Richard Whaley W000319 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
18032 | 18032 | Warren Harding H000192 | sen | OH | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18045 | 18045 | Fred Blackmon B000514 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18055 | 18055 | George Bowers B000690 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18064 | 18064 | Frank Brandegee B000769 | sen | CT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18089 | 18089 | Philip Campbell C000097 | rep | KS | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18112 | 18112 | Joseph Cannon C000121 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 18 | |||||||||||||
18119 | 18119 | Walter Chandler C000297 | rep | NY | 1915-12-06 | 1917-03-03 | Progressive | 19 | |||||||||||||
18130 | 18130 | Ira Copley C000770 | rep | IL | 1915-12-06 | 1917-03-03 | Progressive | 11 | |||||||||||||
18136 | 18136 | Thomas Crago C000853 | rep | PA | 1915-12-06 | 1917-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 | |||||||||||||
18154 | 18154 | Thomas Dunn D000553 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 38 | |||||||||||||
18160 | 18160 | John Elston E000161 | rep | CA | 1915-12-06 | 1917-03-03 | Progressive | 6 | |||||||||||||
18174 | 18174 | Henry Flood F000210 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
18186 | 18186 | Joseph Fordney F000271 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
18197 | 18197 | James Good G000275 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
18203 | 18203 | Norman Gould G000342 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 36 | |||||||||||||
18211 | 18211 | Rufus Hardy H000198 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
18221 | 18221 | Frederick Hicks H000564 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
18232 | 18232 | James Husted H001005 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 25 | |||||||||||||
18236 | 18236 | Elijah Hutchinson H001012 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
18245 | 18245 | Henderson Jacoway J000041 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
18263 | 18263 | Jonah Kalanianaole K000004 | rep | HI | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
18268 | 18268 | Patrick Kelley K000061 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
18273 | 18273 | Ambrose Kennedy K000100 | rep | RI | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18283 | 18283 | Moses Kinkaid K000221 | rep | NE | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
18298 | 18298 | Aaron Kreider K000327 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 18 | |||||||||||||
18310 | 18310 | Irvine Lenroot L000241 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
18313 | 18313 | Meyer London L000408 | rep | NY | 1915-12-06 | 1917-03-03 | Socialist | 12 | |||||||||||||
18331 | 18331 | James Mann M000104 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18341 | 18341 | Clifton McArthur M000298 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18350 | 18350 | William McKinley M000521 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 19 | |||||||||||||
18368 | 18368 | Franklin Mondell M000852 | rep | WY | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
18378 | 18378 | John Nolan N000124 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
18397 | 18397 | Lemuel Padgett P000012 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
18410 | 18410 | Richard Parker P000070 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
18417 | 18417 | John Peters P000253 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18427 | 18427 | Charles Reavis R000101 | rep | NE | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
18436 | 18436 | Edwin Ricketts R000236 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
18448 | 18448 | William Rodenberg R000371 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 22 | |||||||||||||
18464 | 18464 | William Rucker R000494 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18472 | 18472 | Isaac Siegel S000404 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 20 | |||||||||||||
18479 | 18479 | Thomas Sisson S000456 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18487 | 18487 | Campbell Slemp S000486 | rep | VA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
18500 | 18500 | Halvor Steenerson S000842 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
18504 | 18504 | Walter Stiness S000927 | rep | RI | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18510 | 18510 | Burton Sweet S001106 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18517 | 18517 | Samuel Taylor T000100 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
18534 | 18534 | Oscar Underwood U000013 | sen | AL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18544 | 18544 | Andrew Volstead V000114 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 7 |
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);