legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "end" is on date 1923-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
17799 | 17799 | William Kenyon K000129 | sen | IA | 1919-05-19 | 1923-03-03 | 2 | Republican | |||||||||||||
18140 | 18140 | William Crow C000938 | sen | PA | 1921-10-17 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
18553 | 18553 | Thomas Watson W000205 | sen | GA | 1921-04-11 | 1923-03-03 | 3 | Democrat | |||||||||||||
18558 | 18558 | Thomas Bayard B000252 | sen | DE | 1922-11-08 | 1923-03-03 | 1 | Democrat | |||||||||||||
18560 | 18560 | Rebecca Felton F000069 | sen | GA | 1922-10-03 | 1923-03-03 | 3 | Democrat | appointment | ||||||||||||
18562 | 18562 | Charles Rawson R000075 | sen | IA | 1922-02-24 | 1923-03-03 | 2 | Republican | appointment | ||||||||||||
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 | |||||||||||||
19176 | 19176 | Thomas du Pont D000560 | sen | DE | 1921-07-07 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
19811 | 19811 | John Kendrick K000098 | sen | WY | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
19940 | 19940 | David Reed R000114 | sen | PA | 1922-08-08 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
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 | |||||||||||||
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 |
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);