legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
494 rows where "end" is on date 1915-03-03 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17242 | 17242 | Charles Hamilton H000104 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 43 | |||||||||||||
16751 | 16751 | Daniel Driscoll D000500 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 42 | |||||||||||||
17439 | 17439 | Charles Smith S000520 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 41 | |||||||||||||
16371 | 16371 | Robert Gittins G000228 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 40 | |||||||||||||
16742 | 16742 | Henry Danforth D000029 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 39 | |||||||||||||
18153 | 18153 | Thomas Dunn D000553 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 38 | |||||||||||||
16624 | 16624 | Edwin Underhill U000007 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 37 | |||||||||||||
16523 | 16523 | Sereno Payne P000153 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 36 | |||||||||||||
16327 | 16327 | John Clancy C000411 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 35 | |||||||||||||
17170 | 17170 | George Fairchild F000005 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 34 | |||||||||||||
16601 | 16601 | Charles Talcott T000023 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 33 | |||||||||||||
16685 | 16685 | Andrew Barchfeld B000133 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 32 | |||||||||||||
18773 | 18773 | Luther Mott M001041 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 32 | |||||||||||||
16308 | 16308 | James Burke B001093 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 31 | |||||||||||||
16486 | 16486 | Edwin Merritt M000660 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 31 | |||||||||||||
16628 | 16628 | Samuel Wallin W000090 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 30 | |||||||||||||
21350 | 21350 | Melville Kelly K000076 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 30 | |||||||||||||
19925 | 19925 | Stephen Porter P000447 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 29 | |||||||||||||
21464 | 21464 | James Parker P000062 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 29 | |||||||||||||
17781 | 17781 | Willis Hulings H000939 | rep | PA | 1913-04-07 | 1915-03-03 | Progressive | 28 | |||||||||||||
18521 | 18521 | Peter Ten Eyck T000126 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 28 | |||||||||||||
16442 | 16442 | Jonathan Langham L000071 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 27 | |||||||||||||
16476 | 16476 | George McClellan M000330 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 27 | |||||||||||||
16506 | 16506 | Alexander Palmer P000035 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 26 | |||||||||||||
17886 | 17886 | Edmund Platt P000379 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 26 | |||||||||||||
16602 | 16602 | Benjamin Taylor T000066 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 25 | |||||||||||||
20845 | 20845 | Milton Shreve S000387 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 25 | |||||||||||||
22232 | 22232 | Robert Hill H000606 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 25 | |||||||||||||
16364 | 16364 | Hiram Fowler F000321 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 24 | |||||||||||||
16914 | 16914 | Woodson Oglesby O000049 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 24 | |||||||||||||
20916 | 20916 | Henry Temple T000119 | rep | PA | 1913-04-07 | 1915-03-03 | Progressive | 24 | |||||||||||||
16326 | 16326 | Wooda Carr C000180 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 23 | |||||||||||||
16767 | 16767 | Joseph Goulden G000344 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 23 | |||||||||||||
17209 | 17209 | Martin Foster F000309 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 23 | |||||||||||||
16261 | 16261 | William Baltz B000107 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 22 | |||||||||||||
16833 | 16833 | Abraham Keister K000052 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 22 | |||||||||||||
17085 | 17085 | Henry Bruckner B000974 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 22 | |||||||||||||
16368 | 16368 | Henry George G000126 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 21 | |||||||||||||
16382 | 16382 | James Graham G000357 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 21 | |||||||||||||
16508 | 16508 | Charles Patton P000136 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 21 | |||||||||||||
21175 | 21175 | Robert Bulkley B001045 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 21 | |||||||||||||
16325 | 16325 | Jacob Cantor C000125 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
16396 | 16396 | Francis Harrison H000268 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
17083 | 17083 | Andrew Brodbeck B000855 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
17224 | 17224 | William Gordon G000317 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
21516 | 21516 | Henry Rainey R000014 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
16291 | 16291 | Charles Borchers B000635 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 19 | |||||||||||||
16679 | 16679 | Warren Bailey B000050 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 19 | |||||||||||||
17068 | 17068 | Elsworth Bathrick B000240 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 19 | |||||||||||||
18118 | 18118 | Walter Chandler C000297 | rep | NY | 1913-04-07 | 1915-03-03 | Progressive | 19 | |||||||||||||
16502 | 16502 | Frank O’Hair O000052 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 18 | |||||||||||||
16638 | 16638 | John Whitacre W000347 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 18 | |||||||||||||
16924 | 16924 | Thomas Patten P000109 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 18 | |||||||||||||
18297 | 18297 | Aaron Kreider K000327 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 18 | |||||||||||||
16344 | 16344 | Franklin Dershem D000268 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
16357 | 16357 | Louis Fitzhenry F000172 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
19607 | 19607 | John Carew C000142 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
22479 | 22479 | William Ashbrook A000306 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
16366 | 16366 | William Francis F000337 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
16612 | 16612 | Thomas Thacher T000140 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
16985 | 16985 | William Smith S000636 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
17013 | 17013 | Claudius Stone S000954 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
17647 | 17647 | Peter Dooling D000426 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
17804 | 17804 | John Lesher L000250 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
19471 | 19471 | Thomas Rubey R000491 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
16404 | 16404 | Stephen Hoxworth H000873 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
17114 | 17114 | Michael Conry C000707 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
17141 | 17141 | Perl Decker D000184 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
17502 | 17502 | George White W000370 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
18668 | 18668 | William Greene G000430 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 15 | |||||||||||||
19816 | 19816 | Edgar Kiess K000168 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 15 | |||||||||||||
21286 | 21286 | John Garner G000074 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
16250 | 16250 | William Ainey A000065 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 14 | |||||||||||||
16370 | 16370 | Edward Gilmore G000221 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
16453 | 16453 | Jefferson Levy L000268 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
16567 | 16567 | William Sharp S000296 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
17026 | 17026 | Clyde Tavenner T000059 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
17399 | 17399 | Joseph Russell R000533 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
17435 | 17435 | James Slayden S000482 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
16489 | 16489 | John Mitchell M000820 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16555 | 16555 | John Rothermel R000461 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16599 | 16599 | Timothy Sullivan S001061 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16865 | 16865 | George Loft L000399 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
17007 | 17007 | John Stephens S000858 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
17064 | 17064 | Henry Barnhart B000164 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
17270 | 17270 | Walter Hensley H000522 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
17328 | 17328 | John Key K000157 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
18750 | 18750 | John McKenzie M000506 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 13 | |||||||||||||
16369 | 16369 | Michael Gill G000190 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
16398 | 16398 | William Hinebaugh H000633 | rep | IL | 1913-04-07 | 1915-03-03 | Progressive | 12 | |||||||||||||
16444 | 16444 | Robert Lee L000202 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
16457 | 16457 | William MacDonald M000006 | rep | MI | 1913-04-07 | 1915-03-03 | Progressive | 12 | |||||||||||||
16651 | 16651 | Horace Young Y000038 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 12 | |||||||||||||
16724 | 16724 | Oscar Callaway C000056 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
16734 | 16734 | Cyrus Cline C000521 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
16814 | 16814 | Dudley Hughes H000920 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
17576 | 17576 | Clement Brumbaugh B000975 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
17733 | 17733 | Henry Goldfogle G000260 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
17746 | 17746 | James Hamill H000099 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
19308 | 19308 | James Gallivan G000024 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 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);