legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
492 rows where "start" is on date 1921-04-11 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18065 | 18065 | Frank Brandegee B000769 | sen | CT | 1921-04-11 | 1924-10-14 | 3 | Republican | |||||||||||||
18079 | 18079 | Holm Bursum B001144 | sen | NM | 1921-04-11 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
18082 | 18082 | Ralph Cameron C000066 | sen | AZ | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18144 | 18144 | Albert Cummins C000988 | sen | IA | 1921-04-11 | 1926-07-30 | 3 | Republican | |||||||||||||
18152 | 18152 | William Dillingham D000347 | sen | VT | 1921-04-11 | 1923-12-31 | 3 | Republican | |||||||||||||
18164 | 18164 | Richard Ernst E000206 | sen | KY | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18216 | 18216 | John Harreld H000227 | sen | OK | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18302 | 18302 | Edwin Ladd L000012 | sen | ND | 1921-04-11 | 1925-12-31 | 3 | Republican | |||||||||||||
18312 | 18312 | Irvine Lenroot L000241 | sen | WI | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18353 | 18353 | William McKinley M000521 | sen | IL | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18376 | 18376 | Samuel Nicholson N000101 | sen | CO | 1921-04-11 | 1923-12-31 | 3 | Republican | |||||||||||||
18492 | 18492 | Selden Spencer S000730 | sen | MO | 1921-04-11 | 1925-12-31 | 3 | Republican | |||||||||||||
18493 | 18493 | Robert Stanfield S000791 | sen | OR | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18535 | 18535 | Oscar Underwood U000013 | sen | AL | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
18553 | 18553 | Thomas Watson W000205 | sen | GA | 1921-04-11 | 1923-03-03 | 3 | Democrat | |||||||||||||
18554 | 18554 | Ovington Weller W000276 | sen | MD | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19237 | 19237 | Edwin Broussard B000895 | sen | LA | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19260 | 19260 | Thaddeus Caraway C000139 | sen | AR | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19278 | 19278 | Charles Curtis C001008 | sen | KS | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19331 | 19331 | Frank Gooding G000288 | sen | ID | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19369 | 19369 | Wesley Jones J000257 | sen | WA | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19440 | 19440 | George Moses M001028 | sen | NH | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19443 | 19443 | Tasker Oddie O000035 | sen | NV | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19458 | 19458 | Lee Overman O000140 | sen | NC | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19478 | 19478 | Samuel Shortridge S000380 | sen | CA | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19491 | 19491 | Reed Smoot S000644 | sen | UT | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19537 | 19537 | James Watson W000203 | sen | IN | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19547 | 19547 | Frank Willis W000561 | sen | OH | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
21261 | 21261 | Duncan Fletcher F000200 | sen | FL | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
21449 | 21449 | Peter Norbeck N000132 | sen | SD | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
22787 | 22787 | Ellison Smith S000530 | sen | SC | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
25049 | 25049 | James Wadsworth W000012 | sen | NY | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18039 | 18039 | Henry Baldwin B000088 | rep | HI | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18048 | 18048 | Fred Blackmon B000514 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | -1 | |||||||||||||
18075 | 18075 | William Burke B001101 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18139 | 18139 | Thomas Crago C000853 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18229 | 18229 | Winnifred Huck H000900 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18266 | 18266 | Jonah Kalanianaole K000004 | rep | HI | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18340 | 18340 | William Mason M000228 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18355 | 18355 | Joseph McLaughlin M000540 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
19148 | 19148 | Anderson Walters W000109 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
21052 | 21052 | Richard Yates Y000011 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18147 | 18147 | Jaime De Veyra D000276 | rep | PI | 1921-04-11 | 1923-03-03 | 0 | ||||||||||||||
18305 | 18305 | Caleb Layton L000151 | rep | DE | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
18371 | 18371 | Franklin Mondell M000852 | rep | WY | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
19719 | 19719 | Isauro Gabaldon G000001 | rep | PI | 1921-04-11 | 1923-03-03 | 0 | ||||||||||||||
20002 | 20002 | Daniel Sutherland S001079 | rep | AK | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
20093 | 20093 | Samuel Arentz A000277 | rep | NV | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
20332 | 20332 | Félix Dávila D000090 | rep | PR | 1921-04-11 | 1923-03-03 | Unionist | 0 | |||||||||||||
27848 | 27848 | Carl Hayden H000385 | rep | AZ | 1921-04-11 | 1923-03-03 | Democrat | 0 | |||||||||||||
18078 | 18078 | Sherman Burroughs B001138 | rep | NH | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18117 | 18117 | Thomas Chandler C000295 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18126 | 18126 | George Codd C000579 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18224 | 18224 | Frederick Hicks H000564 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18320 | 18320 | Oscar Luhring L000505 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18345 | 18345 | Washington McCormick M000373 | rep | MT | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18358 | 18358 | Frank Millspaugh M000781 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18372 | 18372 | Néstor Montoya M000877 | rep | NM | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18389 | 18389 | James Overstreet O000143 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18430 | 18430 | Charles Reavis R000101 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18523 | 18523 | Roy Thorpe T000245 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18569 | 18569 | Sydney Anderson A000233 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18744 | 18744 | William Logan L000406 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18831 | 18831 | Benjamin Rosenbloom R000441 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18881 | 18881 | Hallett Ward W000132 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
19051 | 19051 | Francis Patterson P000114 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19194 | 19194 | Daniel Anthony A000261 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19217 | 19217 | Eugene Black B000495 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
19414 | 19414 | Martin Madden M000038 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19514 | 19514 | William Vaile V000004 | rep | CO | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19523 | 19523 | William Vare V000071 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19691 | 19691 | Edward Fenn F000072 | rep | CT | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19738 | 19738 | Frank Greene G000425 | rep | VT | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19881 | 19881 | John Miller M000739 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19914 | 19914 | James O’Connor O000028 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
20138 | 20138 | Clark Burdick B001075 | rep | RI | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20144 | 20144 | Olger Burtness B001146 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20188 | 20188 | Charles Christopherson C000384 | rep | SD | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20222 | 20222 | Don Colton C000652 | rep | UT | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20244 | 20244 | Henry Cooper C000752 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20313 | 20313 | Herbert Drane D000486 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
20394 | 20394 | Burton French F000375 | rep | ID | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20504 | 20504 | Willis Hawley H000379 | rep | OR | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20608 | 20608 | William Kopp K000314 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20672 | 20672 | Nicholas Longworth L000433 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
21112 | 21112 | Carroll Beedy B000307 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
21864 | 21864 | John McDuffie M000427 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
22117 | 22117 | William Driver D000503 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
22613 | 22613 | Thomas Goldsborough G000265 | rep | MD | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
23715 | 23715 | Allen Treadway T000358 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
24537 | 24537 | Clarence Lea L000163 | rep | CA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
24744 | 24744 | Schuyler Bland B000545 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
25433 | 25433 | John Rankin R000056 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
25871 | 25871 | Alben Barkley B000145 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
27459 | 27459 | Brazilla Reece R000108 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18050 | 18050 | Albert Blakeney B000535 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18053 | 18053 | Oscar Bland B000542 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18058 | 18058 | George Bowers B000690 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18252 | 18252 | Albert Jefferis J000067 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18334 | 18334 | James Mann M000104 | rep | IL | 1921-04-11 | 1923-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);