legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
506 rows where "end" is on date 1919-03-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16377 | 16377 | Nathan Goff G000255 | sen | WV | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16403 | 16403 | Henry Hollis H000727 | sen | NH | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16409 | 16409 | William Hughes H000929 | sen | NJ | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16415 | 16415 | Ollie James J000051 | sen | KY | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16474 | 16474 | Thomas Martin M000200 | sen | VA | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16557 | 16557 | Willard Saulsbury S000073 | sen | DE | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16564 | 16564 | John Shafroth S000279 | sen | CO | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16585 | 16585 | William Smith S000629 | sen | MI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16613 | 16613 | William Thompson T000226 | sen | KS | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16618 | 16618 | Benjamin Tillman T000274 | sen | SC | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16625 | 16625 | James Vardaman V000070 | sen | MS | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16636 | 16636 | John Weeks W000246 | sen | MA | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16658 | 16658 | Thomas Hardwick H000193 | sen | GA | 1914-01-01 | 1919-03-03 | 2 | Democrat | |||||||||||||
16695 | 16695 | James Brady B000753 | sen | ID | 1915-12-06 | 1919-03-03 | 3 | Republican | |||||||||||||
16705 | 16705 | Robert Broussard B000896 | sen | LA | 1915-12-06 | 1919-03-03 | 3 | Democrat | |||||||||||||
16762 | 16762 | Jacob Gallinger G000023 | sen | NH | 1915-12-06 | 1919-03-03 | 3 | Republican | |||||||||||||
17020 | 17020 | William Stone S000968 | sen | MO | 1915-12-06 | 1919-03-03 | 3 | Democrat | |||||||||||||
17520 | 17520 | David Baird B000052 | sen | NJ | 1918-02-23 | 1919-03-03 | 2 | Republican | appointment | ||||||||||||
17521 | 17521 | Christie Benet B000360 | sen | SC | 1918-07-06 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
17522 | 17522 | Irving Drew D000495 | sen | NH | 1918-09-02 | 1919-03-03 | 3 | Republican | appointment | ||||||||||||
17524 | 17524 | Walter Guion G000522 | sen | LA | 1918-04-22 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
17526 | 17526 | George Martin M000181 | sen | KY | 1918-09-07 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
17528 | 17528 | Frederick Mulkey M001069 | sen | OR | 1918-01-01 | 1919-03-03 | 2 | Republican | |||||||||||||
17530 | 17530 | William Pollock P000417 | sen | SC | 1918-01-01 | 1919-03-03 | 2 | Democrat | |||||||||||||
17531 | 17531 | Xenophon Wilfley W000471 | sen | MO | 1918-04-30 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
17557 | 17557 | John Bankhead B000110 | sen | AL | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17628 | 17628 | LeBaron Colt C000651 | sen | RI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17684 | 17684 | Albert Fall F000011 | sen | NM | 1913-03-04 | 1919-03-03 | 2 | Republican | |||||||||||||
17798 | 17798 | William Kenyon K000129 | sen | IA | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17866 | 17866 | Knute Nelson N000040 | sen | MN | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17879 | 17879 | Robert Owen O000153 | sen | OK | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17931 | 17931 | John Shields S000363 | sen | TN | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17968 | 17968 | Thomas Sterling S000872 | sen | SD | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
18939 | 18939 | Bert Fernald F000084 | sen | ME | 1916-01-01 | 1919-03-03 | 2 | Republican | |||||||||||||
19078 | 19078 | Joseph Ransdell R000059 | sen | LA | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
19106 | 19106 | Furnifold Simmons S000415 | sen | NC | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
19154 | 19154 | Francis Warren W000164 | sen | WY | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
20812 | 20812 | Joseph Robinson R000347 | sen | AR | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
20981 | 20981 | Thomas Walsh W000104 | sen | MT | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
22048 | 22048 | William Borah B000634 | sen | ID | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
22276 | 22276 | James Lewis L000284 | sen | IL | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
22335 | 22335 | George Norris N000139 | sen | NE | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
22409 | 22409 | Morris Sheppard S000337 | sen | TX | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
23606 | 23606 | Charles McNary M000583 | sen | OR | 1918-12-18 | 1919-03-03 | 2 | Republican | appointment | ||||||||||||
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 |
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);