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 descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17243 | 17243 | Charles Hamilton H000104 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 43 | |||||||||||||
16752 | 16752 | Daniel Driscoll D000500 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 42 | |||||||||||||
17440 | 17440 | Charles Smith S000520 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 41 | |||||||||||||
19649 | 19649 | Stephen Dempsey D000229 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 40 | |||||||||||||
16743 | 16743 | Henry Danforth D000029 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 39 | |||||||||||||
18154 | 18154 | Thomas Dunn D000553 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 38 | |||||||||||||
17386 | 17386 | Harry Pratt P000500 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 37 | |||||||||||||
18203 | 18203 | Norman Gould G000342 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 36 | |||||||||||||
19418 | 19418 | Walter Magee M000049 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 35 | |||||||||||||
17171 | 17171 | George Fairchild F000005 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 34 | |||||||||||||
18856 | 18856 | Homer Snyder S000666 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 33 | |||||||||||||
16686 | 16686 | Andrew Barchfeld B000133 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 32 | |||||||||||||
18774 | 18774 | Luther Mott M001041 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 32 | |||||||||||||
19429 | 19429 | John Morin M000961 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 31 | |||||||||||||
22416 | 22416 | Bertrand Snell S000652 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 31 | |||||||||||||
16728 | 16728 | William Charles C000323 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 30 | |||||||||||||
16736 | 16736 | William Coleman C000622 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 30 | |||||||||||||
19926 | 19926 | Stephen Porter P000447 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 29 | |||||||||||||
21465 | 21465 | James Parker P000062 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 29 | |||||||||||||
16886 | 16886 | Samuel Miller M000753 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 28 | |||||||||||||
17910 | 17910 | Rollin Sanford S000053 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 28 | |||||||||||||
16912 | 16912 | Solomon North N000141 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 27 | |||||||||||||
18876 | 18876 | Charles Ward W000129 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 27 | |||||||||||||
17887 | 17887 | Edmund Platt P000379 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 26 | |||||||||||||
17965 | 17965 | Henry Steele S000831 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 26 | |||||||||||||
16849 | 16849 | Michael Liebel L000303 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 25 | |||||||||||||
18232 | 18232 | James Husted H001005 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 25 | |||||||||||||
19657 | 19657 | Edward Denison D000237 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 25 | |||||||||||||
16915 | 16915 | Woodson Oglesby O000049 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 24 | |||||||||||||
20042 | 20042 | Thomas Williams W000542 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 24 | |||||||||||||
20917 | 20917 | Henry Temple T000119 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 24 | |||||||||||||
16693 | 16693 | William Bennet B000370 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 23 | |||||||||||||
16768 | 16768 | Joseph Goulden G000344 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 23 | |||||||||||||
16804 | 16804 | Robert Hopwood H000785 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 23 | |||||||||||||
17210 | 17210 | Martin Foster F000309 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 23 | |||||||||||||
16834 | 16834 | Abraham Keister K000052 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 22 | |||||||||||||
17086 | 17086 | Henry Bruckner B000974 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 22 | |||||||||||||
17661 | 17661 | Henry Emerson E000171 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 22 | |||||||||||||
18448 | 18448 | William Rodenberg R000371 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 22 | |||||||||||||
17307 | 17307 | George Hulbert H000934 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 21 | |||||||||||||
17395 | 17395 | Charles Rowland R000480 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 21 | |||||||||||||
19159 | 19159 | Loren Wheeler W000339 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 21 | |||||||||||||
25640 | 25640 | Robert Crosser C000932 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 21 | |||||||||||||
16687 | 16687 | Cyrus Beales B000269 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 20 | |||||||||||||
17225 | 17225 | William Gordon G000317 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 20 | |||||||||||||
18472 | 18472 | Isaac Siegel S000404 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 20 | |||||||||||||
21517 | 21517 | Henry Rainey R000014 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 20 | |||||||||||||
16680 | 16680 | Warren Bailey B000050 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 19 | |||||||||||||
18119 | 18119 | Walter Chandler C000297 | rep | NY | 1915-12-06 | 1917-03-03 | Progressive | 19 | |||||||||||||
18350 | 18350 | William McKinley M000521 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 19 | |||||||||||||
21710 | 21710 | John Cooper C000757 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 19 | |||||||||||||
16925 | 16925 | Thomas Patten P000109 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 18 | |||||||||||||
17292 | 17292 | David Hollingsworth H000726 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 18 | |||||||||||||
18112 | 18112 | Joseph Cannon C000121 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 18 | |||||||||||||
18298 | 18298 | Aaron Kreider K000327 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 18 | |||||||||||||
17455 | 17455 | John Sterling S000870 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 17 | |||||||||||||
19608 | 19608 | John Carew C000142 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 17 | |||||||||||||
22146 | 22146 | Benjamin Focht F000230 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 17 | |||||||||||||
22480 | 22480 | William Ashbrook A000306 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 17 | |||||||||||||
16986 | 16986 | William Smith S000636 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
17014 | 17014 | Claudius Stone S000954 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
17648 | 17648 | Peter Dooling D000426 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
17805 | 17805 | John Lesher L000250 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
18548 | 18548 | Joseph Walsh W000101 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 16 | |||||||||||||
19472 | 19472 | Thomas Rubey R000491 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
19867 | 19867 | Roscoe McCulloch M000392 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 16 | |||||||||||||
16888 | 16888 | William Mooney M000888 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
17115 | 17115 | Michael Conry C000707 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
17142 | 17142 | Perl Decker D000184 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
18669 | 18669 | William Greene G000430 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
19378 | 19378 | Edward King K000200 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
19817 | 19817 | Edgar Kiess K000168 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
21287 | 21287 | John Garner G000074 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
16755 | 16755 | Michael Farley F000021 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17027 | 17027 | Clyde Tavenner T000059 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17033 | 17033 | Seward Williams W000535 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 14 | |||||||||||||
17400 | 17400 | Joseph Russell R000533 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17436 | 17436 | James Slayden S000482 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
17875 | 17875 | Richard Olney O000080 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 14 | |||||||||||||
21409 | 21409 | Louis McFadden M000434 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 14 | |||||||||||||
16866 | 16866 | George Loft L000399 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17008 | 17008 | John Stephens S000858 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17065 | 17065 | Henry Barnhart B000164 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17096 | 17096 | William Carter C000205 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
17271 | 17271 | Walter Hensley H000522 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17371 | 17371 | Arthur Overmyer O000141 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17641 | 17641 | Arthur Dewalt D000288 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17872 | 17872 | Charles Nichols N000090 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
18751 | 18751 | John McKenzie M000506 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
16725 | 16725 | Oscar Callaway C000056 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
16735 | 16735 | Cyrus Cline C000521 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
16815 | 16815 | Dudley Hughes H000920 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
17259 | 17259 | Robert Heaton H000433 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
17577 | 17577 | Clement Brumbaugh B000975 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
17747 | 17747 | James Hamill H000099 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
18313 | 18313 | Meyer London L000408 | rep | NY | 1915-12-06 | 1917-03-03 | Socialist | 12 | |||||||||||||
18950 | 18950 | Charles Fuller F000407 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
19309 | 19309 | James Gallivan G000024 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
20321 | 20321 | Leonidas Dyer D000591 | rep | MO | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
21331 | 21331 | William James J000053 | rep | MI | 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);