legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
496 rows where "start" is on date 1917-04-02 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17093 | 17093 | William Calder C000025 | sen | NY | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17128 | 17128 | Charles Culberson C000963 | sen | TX | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17212 | 17212 | Joseph France F000333 | sen | MD | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17214 | 17214 | Joseph Frelinghuysen F000370 | sen | NJ | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17290 | 17290 | Gilbert Hitchcock H000645 | sen | NE | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17327 | 17327 | Frank Kellogg K000065 | sen | MN | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17333 | 17333 | Philander Knox K000296 | sen | PA | 1917-04-02 | 1921-12-31 | 1 | Republican | |||||||||||||
17350 | 17350 | Porter McCumber M000397 | sen | ND | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17361 | 17361 | Henry Myers M001129 | sen | MT | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17362 | 17362 | Harry New N000059 | sen | IN | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17375 | 17375 | Carroll Page P000014 | sen | VT | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17378 | 17378 | Miles Poindexter P000403 | sen | WA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17381 | 17381 | Atlee Pomerene P000420 | sen | OH | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17470 | 17470 | Howard Sutherland S001081 | sen | WV | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17495 | 17495 | Charles Townsend T000330 | sen | MI | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17513 | 17513 | John Williams W000521 | sen | MS | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17514 | 17514 | Josiah Wolcott W000669 | sen | DE | 1917-04-02 | 1921-12-31 | 1 | Democrat | |||||||||||||
18693 | 18693 | Andrieus Jones J000210 | sen | NM | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18725 | 18725 | Robert La Follette L000004 | sen | WI | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18742 | 18742 | Henry Lodge L000393 | sen | MA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18757 | 18757 | George McLean M000547 | sen | CT | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18811 | 18811 | James Reed R000118 | sen | MO | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
19811 | 19811 | John Kendrick K000098 | sen | WY | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
20016 | 20016 | Claude Swanson S001094 | sen | VA | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21623 | 21623 | Henry Ashurst A000319 | sen | AZ | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21797 | 21797 | Frederick Hale H000031 | sen | ME | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
21842 | 21842 | William King K000216 | sen | UT | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21928 | 21928 | Key Pittman P000372 | sen | NV | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21977 | 21977 | Park Trammell T000353 | sen | FL | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
23011 | 23011 | Peter Gerry G000141 | sen | RI | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
23072 | 23072 | Hiram Johnson J000140 | sen | CA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
24607 | 24607 | Kenneth McKellar M000499 | sen | TN | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17116 | 17116 | Michael Conry C000707 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
17182 | 17182 | David Finley F000131 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
17352 | 17352 | Atkins McLemore M000554 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
17406 | 17406 | John Scott S000180 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17718 | 17718 | Mahlon Garland G000068 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17828 | 17828 | Joseph McCormick M000369 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18137 | 18137 | Thomas Crago C000853 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18264 | 18264 | Jonah Kalanianaole K000004 | rep | HI | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18338 | 18338 | William Mason M000228 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18354 | 18354 | Joseph McLaughlin M000540 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
20361 | 20361 | John Evans E000247 | rep | MT | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
20392 | 20392 | Burton French F000375 | rep | ID | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
20409 | 20409 | Daniel Garrett G000081 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
20860 | 20860 | Addison Smith S000511 | rep | ID | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
23184 | 23184 | Jeannette Rankin R000055 | rep | MT | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17379 | 17379 | Albert Polk P000407 | rep | DE | 1917-04-02 | 1919-03-03 | Democrat | 0 | |||||||||||||
17394 | 17394 | Edwin Roberts R000309 | rep | NV | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
17970 | 17970 | Charles Sulzer S001064 | rep | AK | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
18024 | 18024 | Teodoro Yangco Y000004 | rep | PI | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
18145 | 18145 | Jaime De Veyra D000276 | rep | PI | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
18369 | 18369 | Franklin Mondell M000852 | rep | WY | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
20330 | 20330 | Félix Dávila D000090 | rep | PR | 1917-04-02 | 1919-03-03 | Unionist | 0 | |||||||||||||
21005 | 21005 | James Wickersham W000438 | rep | AK | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
27846 | 27846 | Carl Hayden H000385 | rep | AZ | 1917-04-02 | 1919-03-03 | Democrat | 0 | |||||||||||||
17144 | 17144 | George Denton D000258 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17152 | 17152 | Charles Dillon D000348 | rep | SD | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17230 | 17230 | Oscar Gray G000401 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17265 | 17265 | Henry Helgesen H000459 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17285 | 17285 | Benjamin Hilliard H000620 | rep | CO | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17322 | 17322 | William Jones J000259 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17369 | 17369 | George O’Shaunessy O000117 | rep | RI | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17390 | 17390 | Jesse Price P000527 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17467 | 17467 | Cyrus Sulloway S001063 | rep | NH | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17500 | 17500 | William Walton W000117 | rep | NM | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17541 | 17541 | John Baer B000027 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17574 | 17574 | William Browning B000961 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17602 | 17602 | Ezekiel Candler C000110 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17654 | 17654 | Frank Doremus D000431 | rep | MI | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17680 | 17680 | Albert Estopinal E000224 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17735 | 17735 | Louis Goodall G000276 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17795 | 17795 | Charles Kennedy K000104 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17929 | 17929 | Sam Sells S000235 | rep | TN | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17954 | 17954 | John Small S000500 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18005 | 18005 | Milton Welling W000278 | rep | UT | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18011 | 18011 | Richard Whaley W000319 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18076 | 18076 | Sherman Burroughs B001138 | rep | NH | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18116 | 18116 | Thomas Chandler C000295 | rep | OK | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18222 | 18222 | Frederick Hicks H000564 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18387 | 18387 | James Overstreet O000143 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18428 | 18428 | Charles Reavis R000101 | rep | NE | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18567 | 18567 | Sydney Anderson A000233 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19192 | 19192 | Daniel Anthony A000261 | rep | KS | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19215 | 19215 | Eugene Black B000495 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19258 | 19258 | Thaddeus Caraway C000139 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19412 | 19412 | Martin Madden M000038 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19521 | 19521 | William Vare V000071 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19736 | 19736 | Frank Greene G000425 | rep | VT | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19879 | 19879 | John Miller M000739 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
20243 | 20243 | Henry Cooper C000752 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
20311 | 20311 | Herbert Drane D000486 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
20502 | 20502 | Willis Hawley H000379 | rep | OR | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
20670 | 20670 | Nicholas Longworth L000433 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
21380 | 21380 | Augustine Lonergan L000409 | rep | CT | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
23194 | 23194 | Milton Romjue R000418 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
23713 | 23713 | Allen Treadway T000358 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
24535 | 24535 | Clarence Lea L000163 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
24742 | 24742 | Schuyler Bland B000545 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
25869 | 25869 | Alben Barkley B000145 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 1 |
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);