legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
451 rows where "start" is on date 1911-04-04 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15887 | 15887 | Nathan Bryan B000992 | sen | FL | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
15889 | 15889 | William Chilton C000360 | sen | WV | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
15892 | 15892 | Moses Clapp C000414 | sen | MN | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
15898 | 15898 | Clarence Clark C000425 | sen | WY | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
15982 | 15982 | Obadiah Gardner G000060 | sen | ME | 1911-04-04 | 1913-03-03 | 2 | Democrat | |||||||||||||
16018 | 16018 | Charles Johnson J000124 | sen | ME | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16021 | 16021 | John Kern K000132 | sen | IN | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16044 | 16044 | Luke Lea L000165 | sen | TN | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16054 | 16054 | Henry Lippitt L000343 | sen | RI | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16077 | 16077 | James Martine M000205 | sen | NJ | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16129 | 16129 | George Nixon N000114 | sen | NV | 1911-04-04 | 1913-03-03 | 1 | Republican | |||||||||||||
16133 | 16133 | James O’Gorman O000050 | sen | NY | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16135 | 16135 | George Oliver O000073 | sen | PA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16174 | 16174 | Isidor Rayner R000086 | sen | MD | 1911-04-04 | 1913-03-03 | 1 | Democrat | |||||||||||||
16206 | 16206 | George Sutherland S001080 | sen | UT | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16227 | 16227 | Clarence Watson W000198 | sen | WV | 1911-04-04 | 1913-03-03 | 2 | Democrat | |||||||||||||
16239 | 16239 | John Works W000743 | sen | CA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16242 | 16242 | Henry du Pont D000559 | sen | DE | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16772 | 16772 | Asle Gronna G000491 | sen | ND | 1911-04-04 | 1915-03-03 | 3 | Republican | |||||||||||||
16964 | 16964 | Hoke Smith S000551 | sen | GA | 1911-04-04 | 1915-03-03 | 3 | Democrat | |||||||||||||
17127 | 17127 | Charles Culberson C000963 | sen | TX | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17289 | 17289 | Gilbert Hitchcock H000645 | sen | NE | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17349 | 17349 | Porter McCumber M000397 | sen | ND | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17360 | 17360 | Henry Myers M001129 | sen | MT | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17374 | 17374 | Carroll Page P000014 | sen | VT | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17377 | 17377 | Miles Poindexter P000403 | sen | WA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17380 | 17380 | Atlee Pomerene P000420 | sen | OH | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17494 | 17494 | Charles Townsend T000330 | sen | MI | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17512 | 17512 | John Williams W000521 | sen | MS | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17656 | 17656 | Davis Elkins E000109 | sen | WV | 1911-04-04 | 1911-12-31 | 2 | Republican | |||||||||||||
17797 | 17797 | William Kenyon K000129 | sen | IA | 1911-04-04 | 1913-03-03 | 2 | Republican | |||||||||||||
18724 | 18724 | Robert La Follette L000004 | sen | WI | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18741 | 18741 | Henry Lodge L000393 | sen | MA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18756 | 18756 | George McLean M000547 | sen | CT | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18810 | 18810 | James Reed R000118 | sen | MO | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
20015 | 20015 | Claude Swanson S001094 | sen | VA | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
15842 | 15842 | William Andrews A000252 | rep | NM | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
15916 | 15916 | George Curry C001002 | rep | NM | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
15992 | 15992 | Louis Hanna H000162 | rep | ND | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
16302 | 16302 | Charles Burke B001087 | rep | SD | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
16355 | 16355 | Harvey Fergusson F000083 | rep | NM | 1911-04-04 | 1913-03-03 | Democrat | -1 | |||||||||||||
16468 | 16468 | Eben Martin M000176 | rep | SD | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
17262 | 17262 | Henry Helgesen H000459 | rep | ND | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
18261 | 18261 | Jonah Kalanianaole K000004 | rep | HI | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
20933 | 20933 | John Tilson T000279 | rep | CT | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
23271 | 23271 | Edward Taylor T000072 | rep | CO | 1911-04-04 | 1913-03-03 | Democrat | -1 | |||||||||||||
15996 | 15996 | William Heald H000422 | rep | DE | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
16047 | 16047 | Benito Legarda Y Tuason L000218 | rep | PI | 1911-04-04 | 1913-03-03 | 0 | ||||||||||||||
16932 | 16932 | Manuel Quezon Q000009 | rep | PI | 1911-04-04 | 1913-03-03 | 0 | ||||||||||||||
16940 | 16940 | Luis Rivera R000279 | rep | PR | 1911-04-04 | 1913-03-03 | Unionist | 0 | |||||||||||||
17391 | 17391 | Edwin Roberts R000309 | rep | NV | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
18081 | 18081 | Ralph Cameron C000066 | rep | AZ | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
18366 | 18366 | Franklin Mondell M000852 | rep | WY | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
21002 | 21002 | James Wickersham W000438 | rep | AK | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
27843 | 27843 | Carl Hayden H000385 | rep | AZ | 1911-04-04 | 1913-03-03 | Democrat | 0 | |||||||||||||
15870 | 15870 | Henry Bingham B000469 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
15872 | 15872 | John Boehne B000587 | rep | IN | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
15971 | 15971 | David Foster F000300 | rep | VT | 1911-04-04 | 1912-03-21 | Republican | 1 | |||||||||||||
16005 | 16005 | Edward Henry H000505 | rep | CT | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16043 | 16043 | George Lawrence L000133 | rep | MA | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16055 | 16055 | Martin Littleton L000359 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16065 | 16065 | Henry Loudenslager L000450 | rep | NJ | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16070 | 16070 | Robert Macon M000035 | rep | AR | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16149 | 16149 | Charles Pray P000508 | rep | MT | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16179 | 16179 | Atterson Rucker R000492 | rep | CO | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16339 | 16339 | James Covington C000816 | rep | MD | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16341 | 16341 | John Davis D000121 | rep | WV | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16414 | 16414 | Ollie James J000051 | rep | KY | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16449 | 16449 | George Legaré L000219 | rep | SC | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16459 | 16459 | John Maguire M000060 | rep | NE | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16483 | 16483 | Bird McGuire M000464 | rep | OK | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16610 | 16610 | George Taylor T000078 | rep | AL | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16801 | 16801 | Asher Hinds H000630 | rep | ME | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16809 | 16809 | Joseph Howell H000866 | rep | UT | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16820 | 16820 | William Humphrey H000958 | rep | WA | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16862 | 16862 | James Lloyd L000380 | rep | MO | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16995 | 16995 | Stephen Sparkman S000702 | rep | FL | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
17319 | 17319 | William Jones J000259 | rep | VA | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
17366 | 17366 | George O’Shaunessy O000117 | rep | RI | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
17465 | 17465 | Cyrus Sulloway S001063 | rep | NH | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
17571 | 17571 | William Browning B000961 | rep | NJ | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
17599 | 17599 | Ezekiel Candler C000110 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
17651 | 17651 | Frank Doremus D000431 | rep | MI | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
17677 | 17677 | Albert Estopinal E000224 | rep | LA | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
17792 | 17792 | Charles Kennedy K000104 | rep | IA | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
17926 | 17926 | Sam Sells S000235 | rep | TN | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
17951 | 17951 | John Small S000500 | rep | NC | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
18564 | 18564 | Sydney Anderson A000233 | rep | MN | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
19063 | 19063 | John Raker R000019 | rep | CA | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
19189 | 19189 | Daniel Anthony A000261 | rep | KS | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
19409 | 19409 | Martin Madden M000038 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
19518 | 19518 | William Vare V000071 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
20240 | 20240 | Henry Cooper C000752 | rep | WI | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
20342 | 20342 | Charles Edwards E000062 | rep | GA | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
20390 | 20390 | Burton French F000375 | rep | ID | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
20499 | 20499 | Willis Hawley H000379 | rep | OR | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
20668 | 20668 | Nicholas Longworth L000433 | rep | OH | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
22408 | 22408 | Morris Sheppard S000337 | rep | TX | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
15915 | 15915 | Frank Currier C000999 | rep | NH | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
15981 | 15981 | John Gardner G000057 | rep | NJ | 1911-04-04 | 1913-03-03 | Republican | 2 |
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);