legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "start" is on date 1919-05-19 sorted by district
This data as json, copyable, CSV (advanced)
end (date) 9 ✖
- 1921-03-03 466
- 1925-03-03 25
- 1919-11-12 1
- 1920-11-01 1
- 1921-03-04 1
- 1922-11-18 1
- 1923-03-03 1
- 1923-12-31 1
- 1924-08-18 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16475 | 16475 | Thomas Martin M000200 | sen | VA | 1919-05-19 | 1919-11-12 | 2 | Democrat | |||||||||||||
17545 | 17545 | Lewis Ball B000100 | sen | DE | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17558 | 17558 | John Bankhead B000110 | sen | AL | 1919-05-19 | 1921-03-03 | 2 | Democrat | |||||||||||||
17629 | 17629 | LeBaron Colt C000651 | sen | RI | 1919-05-19 | 1924-08-18 | 2 | Republican | |||||||||||||
17644 | 17644 | Nathaniel Dial D000298 | sen | SC | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17657 | 17657 | Davis Elkins E000109 | sen | WV | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17685 | 17685 | Albert Fall F000011 | sen | NM | 1919-05-19 | 1921-03-04 | 2 | Republican | |||||||||||||
17799 | 17799 | William Kenyon K000129 | sen | IA | 1919-05-19 | 1923-03-03 | 2 | Republican | |||||||||||||
17829 | 17829 | Joseph McCormick M000369 | sen | IL | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17867 | 17867 | Knute Nelson N000040 | sen | MN | 1919-05-19 | 1923-12-31 | 2 | Republican | |||||||||||||
17868 | 17868 | Truman Newberry N000062 | sen | MI | 1919-05-19 | 1922-11-18 | 2 | Republican | |||||||||||||
17880 | 17880 | Robert Owen O000153 | sen | OK | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17932 | 17932 | John Shields S000363 | sen | TN | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17964 | 17964 | Augustus Stanley S000796 | sen | KY | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17969 | 17969 | Thomas Sterling S000872 | sen | SD | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18932 | 18932 | Walter Edge E000044 | sen | NJ | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18940 | 18940 | Bert Fernald F000084 | sen | ME | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
19060 | 19060 | Lawrence Phipps P000317 | sen | CO | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
19079 | 19079 | Joseph Ransdell R000059 | sen | LA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
19107 | 19107 | Furnifold Simmons S000415 | sen | NC | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
19155 | 19155 | Francis Warren W000164 | sen | WY | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
20475 | 20475 | William Harris H000259 | sen | GA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20605 | 20605 | Henry Keyes K000161 | sen | NH | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
20813 | 20813 | Joseph Robinson R000347 | sen | AR | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20982 | 20982 | Thomas Walsh W000104 | sen | MT | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22049 | 22049 | William Borah B000634 | sen | ID | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
22222 | 22222 | Byron Harrison H000265 | sen | MS | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22336 | 22336 | George Norris N000139 | sen | NE | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
22410 | 22410 | Morris Sheppard S000337 | sen | TX | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
23313 | 23313 | David Walsh W000097 | sen | MA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
23356 | 23356 | Arthur Capper C000133 | sen | KS | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
23607 | 23607 | Charles McNary M000583 | sen | OR | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17610 | 17610 | Charles Carlin C000151 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | -1 | |||||||||||||
17719 | 17719 | Mahlon Garland G000068 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
17771 | 17771 | Harvey Helm H000461 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | -1 | |||||||||||||
18074 | 18074 | William Burke B001101 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18138 | 18138 | Thomas Crago C000853 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18265 | 18265 | Jonah Kalanianaole K000004 | rep | HI | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18339 | 18339 | William Mason M000228 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
19147 | 19147 | Anderson Walters W000109 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
19208 | 19208 | Victor Berger B000407 | rep | WI | 1919-05-19 | 1921-03-03 | Socialist | -1 | |||||||||||||
21051 | 21051 | Richard Yates Y000011 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
17682 | 17682 | Charles Evans E000234 | rep | NV | 1919-05-19 | 1921-03-03 | Democrat | 0 | |||||||||||||
17742 | 17742 | George Grigsby G000474 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
17971 | 17971 | Charles Sulzer S001064 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
18025 | 18025 | Teodoro Yangco Y000004 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
18146 | 18146 | Jaime De Veyra D000276 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
18304 | 18304 | Caleb Layton L000151 | rep | DE | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
18370 | 18370 | Franklin Mondell M000852 | rep | WY | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
19718 | 19718 | Isauro Gabaldon G000001 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
20331 | 20331 | Félix Dávila D000090 | rep | PR | 1919-05-19 | 1921-03-03 | Unionist | 0 | |||||||||||||
21006 | 21006 | James Wickersham W000438 | rep | AK | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
27847 | 27847 | Carl Hayden H000385 | rep | AZ | 1919-05-19 | 1921-03-03 | Democrat | 0 | |||||||||||||
17539 | 17539 | William Andrews A000253 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17542 | 17542 | John Baer B000027 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17575 | 17575 | William Browning B000961 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17603 | 17603 | Ezekiel Candler C000110 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17655 | 17655 | Frank Doremus D000431 | rep | MI | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17681 | 17681 | Albert Estopinal E000224 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17736 | 17736 | Louis Goodall G000276 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17773 | 17773 | Benigno Hernández H000532 | rep | NM | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17796 | 17796 | Charles Kennedy K000104 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17899 | 17899 | Clifford Randall R000038 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17930 | 17930 | Sam Sells S000235 | rep | TN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17955 | 17955 | John Small S000500 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18006 | 18006 | Milton Welling W000278 | rep | UT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18012 | 18012 | Richard Whaley W000319 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18077 | 18077 | Sherman Burroughs B001138 | rep | NH | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18223 | 18223 | Frederick Hicks H000564 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18319 | 18319 | Oscar Luhring L000505 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18388 | 18388 | James Overstreet O000143 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18429 | 18429 | Charles Reavis R000101 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18568 | 18568 | Sydney Anderson A000233 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19050 | 19050 | Francis Patterson P000114 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19193 | 19193 | Daniel Anthony A000261 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19216 | 19216 | Eugene Black B000495 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19259 | 19259 | Thaddeus Caraway C000139 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19356 | 19356 | Everette Howard H000837 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19413 | 19413 | Martin Madden M000038 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19513 | 19513 | William Vaile V000004 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19522 | 19522 | William Vare V000071 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19737 | 19737 | Frank Greene G000425 | rep | VT | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19880 | 19880 | John Miller M000739 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19913 | 19913 | James O’Connor O000028 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
20137 | 20137 | Clark Burdick B001075 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20187 | 20187 | Charles Christopherson C000384 | rep | SD | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20312 | 20312 | Herbert Drane D000486 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
20362 | 20362 | John Evans E000247 | rep | MT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
20393 | 20393 | Burton French F000375 | rep | ID | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20503 | 20503 | Willis Hawley H000379 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20671 | 20671 | Nicholas Longworth L000433 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
21381 | 21381 | Augustine Lonergan L000409 | rep | CT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
21863 | 21863 | John McDuffie M000427 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
23195 | 23195 | Milton Romjue R000418 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
23714 | 23714 | Allen Treadway T000358 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
24536 | 24536 | Clarence Lea L000163 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
24743 | 24743 | Schuyler Bland B000545 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
25870 | 25870 | Alben Barkley B000145 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
26066 | 26066 | Matthew Neely N000023 | rep | WV | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17561 | 17561 | Carville Benson B000387 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 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);