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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
18440 | 18440 | Carl Riddick R000237 | rep | MT | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18441 | 18441 | Alice Robertson R000318 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18467 | 18467 | William Rucker R000494 | rep | MO | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18507 | 18507 | Walter Stiness S000927 | rep | RI | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18591 | 18591 | Frank Clark C000430 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18624 | 18624 | Henry Dupré D000561 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18679 | 18679 | Harry Hull H000941 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18718 | 18718 | Claude Kitchin K000250 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18733 | 18733 | Edward Little L000349 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18803 | 18803 | Frank Park P000051 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18874 | 18874 | John Tyson T000455 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18905 | 18905 | George Young Y000036 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18973 | 18973 | Frederick Gillett G000201 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19068 | 19068 | John Raker R000019 | rep | CA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19143 | 19143 | Edward Voigt V000110 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19283 | 19283 | Porter Dale D000009 | rep | VT | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19291 | 19291 | Joseph Deal D000169 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19374 | 19374 | John Kindred K000191 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19393 | 19393 | Bill Lowrey L000484 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19451 | 19451 | William Oldfield O000062 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19484 | 19484 | Nicholas Sinnott S000450 | rep | OR | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19494 | 19494 | Ambrose Stephens S000855 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19589 | 19589 | John Box B000710 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19828 | 19828 | David Kincheloe K000187 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19848 | 19848 | Elmer Leatherwood L000181 | rep | UT | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20194 | 20194 | Frank Clague C000401 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20381 | 20381 | Richard Freeman F000366 | rep | CT | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20438 | 20438 | George Graham G000354 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20448 | 20448 | Lindley Hadley H000008 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20578 | 20578 | Royal Johnson J000173 | rep | SD | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20862 | 20862 | Addison Smith S000511 | rep | ID | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20946 | 20946 | Charles Timberlake T000281 | rep | CO | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20988 | 20988 | Edward Wason W000185 | rep | NH | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
21632 | 21632 | Isaac Bacharach B000009 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
22082 | 22082 | James Byrnes B001215 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
22806 | 22806 | James Taylor T000083 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
23749 | 23749 | Wallace White W000396 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
24934 | 24934 | Earl Michener M000693 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18037 | 18037 | Theodore Appleby A000267 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18068 | 18068 | Samuel Brinson B000840 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18073 | 18073 | Joseph Brown B000935 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18092 | 18092 | Philip Campbell C000097 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18166 | 18166 | Robert Evans E000256 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18190 | 18190 | William Frankhauser F000341 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18276 | 18276 | Ambrose Kennedy K000100 | rep | RI | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18288 | 18288 | John Kissel K000245 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18303 | 18303 | Henry Lawrence L000135 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18344 | 18344 | Clifton McArthur M000298 | rep | OR | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18420 | 18420 | John Peters P000253 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18513 | 18513 | Burton Sweet S001106 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18616 | 18616 | Charles Davis D000093 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18690 | 18690 | Benjamin Humphreys H000960 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18797 | 18797 | Calvin Paige P000024 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18815 | 18815 | Stuart Reed R000127 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18854 | 18854 | John Smith S000573 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18923 | 18923 | Charles Carter C000196 | rep | OK | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18990 | 18990 | John Hill H000597 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19110 | 19110 | John Smithwick S000643 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19128 | 19128 | Robert Thomas T000185 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19507 | 19507 | John Tillman T000276 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19641 | 19641 | Charles Curry C001000 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19675 | 19675 | James Dunbar D000525 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19710 | 19710 | Roy Fitzgerald F000166 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19860 | 19860 | Whitmell Martin M000201 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19969 | 19969 | Elliott Sproul S000758 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20265 | 20265 | Charles Crisp C000909 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
20302 | 20302 | Frederick Dominick D000408 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
20469 | 20469 | Guy Hardy H000195 | rep | CO | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20568 | 20568 | Albert Johnson J000114 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20740 | 20740 | John Nelson N000038 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20753 | 20753 | John Nelson N000039 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20937 | 20937 | John Tilson T000279 | rep | CT | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
21014 | 21014 | William Williamson W000553 | rep | SD | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
21066 | 21066 | Charles Abernethy A000015 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
21544 | 21544 | James Sinclair S000442 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
21933 | 21933 | Harry Ransley R000061 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
22320 | 22320 | Andrew Montague M000861 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
22385 | 22385 | Morgan Sanders S000037 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
23690 | 23690 | Henry Steagall S000820 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18041 | 18041 | John Benham B000361 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18125 | 18125 | Wynne Clouse C000532 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18239 | 18239 | Elijah Hutchinson H001012 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18290 | 18290 | John Kleczka K000260 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18422 | 18422 | Joseph Pringey P000542 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18482 | 18482 | Thomas Sisson S000456 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18706 | 18706 | Julius Kahn K000003 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18807 | 18807 | John Rainey R000015 | rep | IL | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18893 | 18893 | Samuel Winslow W000639 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
19002 | 19002 | Ben Johnson J000118 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
19006 | 19006 | Oscar Keller K000057 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
19038 | 19038 | Melvin McLaughlin M000541 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
19174 | 19174 | Harry Woodyard W000737 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
19296 | 19296 | Charles Faust F000047 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
19352 | 19352 | Ira Hersey H000544 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 4 |
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);