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 party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17343 | 17343 | Charles Lobeck L000385 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17351 | 17351 | Atkins McLemore M000554 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
17368 | 17368 | George O’Shaunessy O000117 | rep | RI | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17371 | 17371 | Arthur Overmyer O000141 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17389 | 17389 | Jesse Price P000527 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17400 | 17400 | Joseph Russell R000533 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17415 | 17415 | Dorsey Shackleford S000274 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17423 | 17423 | Joseph Sherley S000343 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17425 | 17425 | Jouett Shouse S000384 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17436 | 17436 | James Slayden S000482 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17440 | 17440 | Charles Smith S000520 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 41 | |||||||||||||
17447 | 17447 | Dan Stephens S000856 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17487 | 17487 | Joshua Talbott T000021 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17498 | 17498 | John Walker W000060 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
17536 | 17536 | Joshua Alexander A000098 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17568 | 17568 | Charles Booher B000626 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17577 | 17577 | Clement Brumbaugh B000975 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
17588 | 17588 | John Burnett B001121 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17591 | 17591 | Charles Caldwell C000030 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17601 | 17601 | Ezekiel Candler C000110 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17608 | 17608 | Charles Carlin C000151 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17621 | 17621 | James Clark C000437 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
17625 | 17625 | Charles Coady C000541 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17638 | 17638 | Stanley Dent D000256 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17641 | 17641 | Arthur Dewalt D000288 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17648 | 17648 | Peter Dooling D000426 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
17653 | 17653 | Frank Doremus D000431 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17679 | 17679 | Albert Estopinal E000224 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
17769 | 17769 | Harvey Helm H000461 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
17869 | 17869 | Samuel Nicholls N000088 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
17891 | 17891 | James Ragsdale R000010 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
18028 | 18028 | James Young Y000040 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18045 | 18045 | Fred Blackmon B000514 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18174 | 18174 | Henry Flood F000210 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
18211 | 18211 | Rufus Hardy H000198 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
18245 | 18245 | Henderson Jacoway J000041 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
18397 | 18397 | Lemuel Padgett P000012 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
18464 | 18464 | William Rucker R000494 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18479 | 18479 | Thomas Sisson S000456 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
18578 | 18578 | James Cantrill C000126 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
18627 | 18627 | John Eagan E000001 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
18643 | 18643 | William Fields F000113 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
18687 | 18687 | Benjamin Humphreys H000960 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
18824 | 18824 | Daniel Riordan R000264 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
18844 | 18844 | Isaac Sherwood S000355 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
18862 | 18862 | Peter Tague T000014 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
18895 | 18895 | James Wise W000650 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
18920 | 18920 | Charles Carter C000196 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18985 | 18985 | James Heflin H000446 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
18999 | 18999 | Ben Johnson J000118 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
19025 | 19025 | Gordon Lee L000194 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19065 | 19065 | John Raker R000019 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19090 | 19090 | Arthur Rouse R000466 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
19125 | 19125 | Robert Thomas T000185 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
19214 | 19214 | Eugene Black B000495 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
19257 | 19257 | Thaddeus Caraway C000139 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
19309 | 19309 | James Gallivan G000024 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
19324 | 19324 | Finis Garrett G000082 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
19342 | 19342 | Thomas Harrison H000277 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19386 | 19386 | Ladislas Lazaro L000153 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19448 | 19448 | William Oldfield O000062 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19457 | 19457 | Lee Overman O000140 | sen | NC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
19472 | 19472 | Thomas Rubey R000491 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
19504 | 19504 | John Tillman T000276 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
19579 | 19579 | Thomas Bell B000348 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 9 |
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);