legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1921-03-03 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16688 | 16688 | John Beckham B000293 | sen | KY | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
16727 | 16727 | George Chamberlain C000277 | sen | OR | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
16773 | 16773 | Asle Gronna G000491 | sen | ND | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
16824 | 16824 | Edwin Johnson J000128 | sen | SD | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
16929 | 16929 | Boies Penrose P000217 | sen | PA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
16930 | 16930 | James Phelan P000290 | sen | CA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
16955 | 16955 | Lawrence Sherman S000348 | sen | IL | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
16965 | 16965 | Hoke Smith S000551 | sen | GA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
16969 | 16969 | John Smith S000577 | sen | MD | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
16979 | 16979 | Marcus Smith S000589 | sen | AZ | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17029 | 17029 | Charles Thomas T000160 | sen | CO | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17042 | 17042 | William Kirby K000233 | sen | AR | 1916-01-01 | 1921-03-03 | 3 | Democrat | |||||||||||||
17523 | 17523 | Edward Gay G000104 | sen | LA | 1918-01-01 | 1921-03-03 | 3 | Democrat | |||||||||||||
17525 | 17525 | Charles Henderson H000477 | sen | NV | 1918-01-12 | 1921-03-03 | 3 | Democrat | appointment | ||||||||||||
17529 | 17529 | John Nugent N000169 | sen | ID | 1918-01-22 | 1921-03-03 | 3 | Democrat | appointment | ||||||||||||
17558 | 17558 | John Bankhead B000110 | sen | AL | 1919-05-19 | 1921-03-03 | 2 | Democrat | |||||||||||||
18031 | 18031 | Braxton Comer C000657 | sen | AL | 1920-03-05 | 1921-03-03 | 2 | Democrat | appointment | ||||||||||||
18032 | 18032 | Warren Harding H000192 | sen | OH | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18064 | 18064 | Frank Brandegee B000769 | sen | CT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18143 | 18143 | Albert Cummins C000988 | sen | IA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18151 | 18151 | William Dillingham D000347 | sen | VT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18311 | 18311 | Irvine Lenroot L000241 | sen | WI | 1918-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
18491 | 18491 | Selden Spencer S000730 | sen | MO | 1918-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
18534 | 18534 | Oscar Underwood U000013 | sen | AL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
19277 | 19277 | Charles Curtis C001008 | sen | KS | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19368 | 19368 | Wesley Jones J000257 | sen | WA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19439 | 19439 | George Moses M001028 | sen | NH | 1918-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
19457 | 19457 | Lee Overman O000140 | sen | NC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
19490 | 19490 | Reed Smoot S000644 | sen | UT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19536 | 19536 | James Watson W000203 | sen | IN | 1916-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
20432 | 20432 | Thomas Gore G000323 | sen | OK | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
21260 | 21260 | Duncan Fletcher F000200 | sen | FL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
22786 | 22786 | Ellison Smith S000530 | sen | SC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
25048 | 25048 | James Wadsworth W000012 | sen | NY | 1915-12-06 | 1921-03-03 | 3 | 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 |
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);