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 state descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18371 | 18371 | Franklin Mondell M000852 | rep | WY | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
19811 | 19811 | John Kendrick K000098 | sen | WY | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17470 | 17470 | Howard Sutherland S001081 | sen | WV | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18058 | 18058 | George Bowers B000690 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18159 | 18159 | Leonard Echols E000030 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18202 | 18202 | Wells Goodykoontz G000308 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18815 | 18815 | Stuart Reed R000127 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18831 | 18831 | Benjamin Rosenbloom R000441 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19174 | 19174 | Harry Woodyard W000737 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18124 | 18124 | David Classon C000474 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18290 | 18290 | John Kleczka K000260 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18375 | 18375 | Adolphus Nelson N000029 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18725 | 18725 | Robert La Follette L000004 | sen | WI | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
19143 | 19143 | Edward Voigt V000110 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19198 | 19198 | Joseph Beck B000291 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
19602 | 19602 | Edward Browne B000955 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
19841 | 19841 | Florian Lampert L000041 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
20244 | 20244 | Henry Cooper C000752 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20753 | 20753 | John Nelson N000039 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20879 | 20879 | William Stafford S000777 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
21274 | 21274 | James Frear F000355 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
17378 | 17378 | Miles Poindexter P000403 | sen | WA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18885 | 18885 | John Webster W000240 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
19881 | 19881 | John Miller M000739 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20448 | 20448 | Lindley Hadley H000008 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20568 | 20568 | Albert Johnson J000114 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20902 | 20902 | John Summers S001067 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
17375 | 17375 | Carroll Page P000014 | sen | VT | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
19283 | 19283 | Porter Dale D000009 | rep | VT | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19738 | 19738 | Frank Greene G000425 | rep | VT | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18177 | 18177 | Henry Flood F000210 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
18250 | 18250 | Rorer James J000052 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
18415 | 18415 | John Paul P000143 | rep | VA | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
18490 | 18490 | Campbell Slemp S000486 | rep | VA | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18557 | 18557 | James Woods W000723 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18674 | 18674 | James Hooker H000759 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
19291 | 19291 | Joseph Deal D000169 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19345 | 19345 | Thomas Harrison H000277 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
19887 | 19887 | Robert Moore M000915 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
20016 | 20016 | Claude Swanson S001094 | sen | VA | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
20956 | 20956 | Henry Tucker T000399 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
22320 | 22320 | Andrew Montague M000861 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
24355 | 24355 | Patrick Drewry D000496 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
24744 | 24744 | Schuyler Bland B000545 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
19848 | 19848 | Elmer Leatherwood L000181 | rep | UT | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20222 | 20222 | Don Colton C000652 | rep | UT | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
21842 | 21842 | William King K000216 | sen | UT | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17128 | 17128 | Charles Culberson C000963 | sen | TX | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18214 | 18214 | Rufus Hardy H000198 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18414 | 18414 | Lucian Parrish P000083 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 13 | |||||||||||||
19217 | 19217 | Eugene Black B000495 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
19589 | 19589 | John Box B000710 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19779 | 19779 | Claude Hudspeth H000910 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 16 | |||||||||||||
20410 | 20410 | Daniel Garrett G000081 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
21008 | 21008 | Guinn Williams W000501 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 13 | |||||||||||||
21039 | 21039 | Harry Wurzbach W000775 | rep | TX | 1921-04-11 | 1923-03-03 | Republican | 14 | |||||||||||||
21143 | 21143 | Clay Briggs B000826 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
21290 | 21290 | John Garner G000074 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 15 | |||||||||||||
21645 | 21645 | Thomas Blanton B000549 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 17 | |||||||||||||
22066 | 22066 | James Buchanan B001006 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
22385 | 22385 | Morgan Sanders S000037 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
22639 | 22639 | John Jones J000236 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 18 | |||||||||||||
23947 | 23947 | Fritz Lanham L000076 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 12 | |||||||||||||
24117 | 24117 | Hatton Sumners S001072 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
24315 | 24315 | Thomas Connally C000684 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 11 | |||||||||||||
24579 | 24579 | Joseph Mansfield M000112 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
27438 | 27438 | Samuel Rayburn R000082 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18073 | 18073 | Joseph Brown B000935 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18125 | 18125 | Wynne Clouse C000532 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18400 | 18400 | Lemuel Padgett P000012 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18469 | 18469 | Lon Scott S000181 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
19327 | 19327 | Finis Garrett G000082 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
19705 | 19705 | Hubert Fisher F000149 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
20286 | 20286 | Ewin Davis D000098 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
21676 | 21676 | Joseph Byrns B001217 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
22806 | 22806 | James Taylor T000083 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
22817 | 22817 | Clarence Turner T000417 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
24607 | 24607 | Kenneth McKellar M000499 | sen | TN | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
27459 | 27459 | Brazilla Reece R000108 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20188 | 20188 | Charles Christopherson C000384 | rep | SD | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20578 | 20578 | Royal Johnson J000173 | rep | SD | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
21014 | 21014 | William Williamson W000553 | rep | SD | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18509 | 18509 | Philip Stoll S000951 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18744 | 18744 | William Logan L000406 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
20302 | 20302 | Frederick Dominick D000408 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
20884 | 20884 | William Stevenson S000895 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
21872 | 21872 | John McSwain M000604 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
22082 | 22082 | James Byrnes B001215 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
23481 | 23481 | Hampton Fulmer F000417 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18276 | 18276 | Ambrose Kennedy K000100 | rep | RI | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18507 | 18507 | Walter Stiness S000927 | rep | RI | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20138 | 20138 | Clark Burdick B001075 | rep | RI | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
23011 | 23011 | Peter Gerry G000141 | sen | RI | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
20332 | 20332 | Félix Dávila D000090 | rep | PR | 1921-04-11 | 1923-03-03 | Unionist | 0 | |||||||||||||
18147 | 18147 | Jaime De Veyra D000276 | rep | PI | 1921-04-11 | 1923-03-03 | 0 | ||||||||||||||
19719 | 19719 | Isauro Gabaldon G000001 | rep | PI | 1921-04-11 | 1923-03-03 | 0 | ||||||||||||||
18070 | 18070 | Edward Brooks B000876 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 20 | |||||||||||||
18075 | 18075 | William Burke B001101 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18127 | 18127 | Charles Connell C000685 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
18134 | 18134 | Clarence Coughlin C000806 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 11 |
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);