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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28207 | 28207 | Carl Vinson V000105 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
27848 | 27848 | Carl Hayden H000385 | rep | AZ | 1921-04-11 | 1923-03-03 | Democrat | 0 | |||||||||||||
27459 | 27459 | Brazilla Reece R000108 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
27438 | 27438 | Samuel Rayburn R000082 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
26951 | 26951 | Daniel Reed R000113 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 43 | |||||||||||||
25871 | 25871 | Alben Barkley B000145 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
25553 | 25553 | Roy Woodruff W000718 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
25461 | 25461 | Adolph Sabath S000001 | rep | IL | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
25433 | 25433 | John Rankin R000056 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
25218 | 25218 | Robert Doughton D000448 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
24934 | 24934 | Earl Michener M000693 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
24775 | 24775 | Alfred Bulwinkle B001056 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
24744 | 24744 | Schuyler Bland B000545 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
24651 | 24651 | John Robsion R000358 | rep | KY | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
24607 | 24607 | Kenneth McKellar M000499 | sen | TN | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
24579 | 24579 | Joseph Mansfield M000112 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
24537 | 24537 | Clarence Lea L000163 | rep | CA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
24516 | 24516 | Harold Knutson K000301 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
24413 | 24413 | Charles Gifford G000169 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 16 | |||||||||||||
24355 | 24355 | Patrick Drewry D000496 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
24315 | 24315 | Thomas Connally C000684 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 11 | |||||||||||||
24188 | 24188 | Zebulon Weaver W000230 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
24117 | 24117 | Hatton Sumners S001072 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
23947 | 23947 | Fritz Lanham L000076 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 12 | |||||||||||||
23749 | 23749 | Wallace White W000396 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
23715 | 23715 | Allen Treadway T000358 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
23690 | 23690 | Henry Steagall S000820 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
23481 | 23481 | Hampton Fulmer F000417 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
23454 | 23454 | Hamilton Fish F000142 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 26 | |||||||||||||
23395 | 23395 | Thomas Cullen C000970 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
23299 | 23299 | George Tinkham T000283 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
23276 | 23276 | Edward Taylor T000072 | rep | CO | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
23129 | 23129 | James Mead M000615 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 42 | |||||||||||||
23072 | 23072 | Hiram Johnson J000140 | sen | CA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
23011 | 23011 | Peter Gerry G000141 | sen | RI | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
22946 | 22946 | Frank Crowther C000948 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 30 | |||||||||||||
22931 | 22931 | Ross Collins C000642 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
22817 | 22817 | Clarence Turner T000417 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
22806 | 22806 | James Taylor T000083 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
22794 | 22794 | Christopher Sullivan S001051 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 13 | |||||||||||||
22678 | 22678 | Carl Mapes M000119 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
22665 | 22665 | Robert Luce L000498 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 13 | |||||||||||||
22639 | 22639 | John Jones J000236 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 18 | |||||||||||||
22613 | 22613 | Thomas Goldsborough G000265 | rep | MD | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
22574 | 22574 | Cassius Dowell D000468 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
22552 | 22552 | George Darrow D000063 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
22490 | 22490 | William Bankhead B000113 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
22419 | 22419 | Bertrand Snell S000652 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 31 | |||||||||||||
22385 | 22385 | Morgan Sanders S000037 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
22320 | 22320 | Andrew Montague M000861 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
22149 | 22149 | Benjamin Focht F000230 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 17 | |||||||||||||
22117 | 22117 | William Driver D000503 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
22082 | 22082 | James Byrnes B001215 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
22066 | 22066 | James Buchanan B001006 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
22000 | 22000 | Riley Wilson W000608 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
21977 | 21977 | Park Trammell T000353 | sen | FL | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21963 | 21963 | William Sears S000211 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
21951 | 21951 | John Sandlin S000043 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
21933 | 21933 | Harry Ransley R000061 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
21928 | 21928 | Key Pittman P000372 | sen | NV | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21919 | 21919 | Randolph Perkins P000237 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
21911 | 21911 | Tilman Parks P000075 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
21903 | 21903 | William Oliver O000077 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
21882 | 21882 | Schuyler Merritt M000663 | rep | CT | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
21872 | 21872 | John McSwain M000604 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
21864 | 21864 | John McDuffie M000427 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
21849 | 21849 | Frederick Lehlbach L000222 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
21842 | 21842 | William King K000216 | sen | UT | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21821 | 21821 | George Huddleston H000903 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
21797 | 21797 | Frederick Hale H000031 | sen | ME | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
21782 | 21782 | Anthony Griffin G000457 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 22 | |||||||||||||
21713 | 21713 | John Cooper C000757 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 19 | |||||||||||||
21676 | 21676 | Joseph Byrns B001217 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
21645 | 21645 | Thomas Blanton B000549 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 17 | |||||||||||||
21632 | 21632 | Isaac Bacharach B000009 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
21623 | 21623 | Henry Ashurst A000319 | sen | AZ | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21607 | 21607 | Abram Andrew A000240 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
21590 | 21590 | Henry Watson W000201 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
21572 | 21572 | Fletcher Swank S001089 | rep | OK | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
21563 | 21563 | Nathan Strong S001015 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 27 | |||||||||||||
21544 | 21544 | James Sinclair S000442 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
21492 | 21492 | Edward Pou P000474 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
21468 | 21468 | James Parker P000062 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 29 | |||||||||||||
21412 | 21412 | Louis McFadden M000434 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 14 | |||||||||||||
21402 | 21402 | James McClintic M000338 | rep | OK | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
21353 | 21353 | Melville Kelly K000076 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 30 | |||||||||||||
21341 | 21341 | Lamar Jeffers J000068 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
21334 | 21334 | William James J000053 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 12 | |||||||||||||
21290 | 21290 | John Garner G000074 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 15 | |||||||||||||
21274 | 21274 | James Frear F000355 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
21247 | 21247 | George Edmonds E000053 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
21211 | 21211 | James Connolly C000698 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
21199 | 21199 | John Clarke C000465 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 34 | |||||||||||||
21154 | 21154 | Frederick Britten B000847 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
21143 | 21143 | Clay Briggs B000826 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
21135 | 21135 | Charles Brand B000767 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
21112 | 21112 | Carroll Beedy B000307 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
21083 | 21083 | Edward Almon A000162 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
21066 | 21066 | Charles Abernethy A000015 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
21052 | 21052 | Richard Yates Y000011 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | -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);