legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1921-03-03 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18466 | 18466 | William Rucker R000494 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18481 | 18481 | Thomas Sisson S000456 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18508 | 18508 | Philip Stoll S000951 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18519 | 18519 | Samuel Taylor T000100 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18534 | 18534 | Oscar Underwood U000013 | sen | AL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18556 | 18556 | James Woods W000723 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18580 | 18580 | James Cantrill C000126 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18590 | 18590 | Frank Clark C000430 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18623 | 18623 | Henry Dupré D000561 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18629 | 18629 | John Eagan E000001 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
18645 | 18645 | William Fields F000113 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18652 | 18652 | James Ganly G000038 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 24 | |||||||||||||
18689 | 18689 | Benjamin Humphreys H000960 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18717 | 18717 | Claude Kitchin K000250 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18761 | 18761 | Daniel Minahan M000789 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18802 | 18802 | Frank Park P000051 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18806 | 18806 | John Rainey R000015 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18826 | 18826 | Daniel Riordan R000264 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
18846 | 18846 | Isaac Sherwood S000355 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18864 | 18864 | Peter Tague T000014 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
18897 | 18897 | James Wise W000650 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18922 | 18922 | Charles Carter C000196 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18928 | 18928 | William Cleary C000500 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
19001 | 19001 | Ben Johnson J000118 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
19027 | 19027 | Gordon Lee L000194 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19067 | 19067 | John Raker R000019 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19092 | 19092 | Arthur Rouse R000466 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
19109 | 19109 | John Smithwick S000643 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19127 | 19127 | Robert Thomas T000185 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19137 | 19137 | William Upshaw U000026 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19216 | 19216 | Eugene Black B000495 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19229 | 19229 | William Bowling B000702 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19259 | 19259 | Thaddeus Caraway C000139 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19287 | 19287 | Martin Davey D000080 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
19311 | 19311 | James Gallivan G000024 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
19326 | 19326 | Finis Garrett G000082 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
19344 | 19344 | Thomas Harrison H000277 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19356 | 19356 | Everette Howard H000837 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19388 | 19388 | Ladislas Lazaro L000153 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19450 | 19450 | William Oldfield O000062 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19457 | 19457 | Lee Overman O000140 | sen | NC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
19474 | 19474 | Thomas Rubey R000491 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
19506 | 19506 | John Tillman T000276 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19581 | 19581 | Thomas Bell B000348 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
19588 | 19588 | John Box B000710 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19610 | 19610 | John Carew C000142 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 18 | |||||||||||||
19618 | 19618 | John Casey C000223 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
19704 | 19704 | Hubert Fisher F000149 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
19778 | 19778 | Claude Hudspeth H000910 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
19827 | 19827 | David Kincheloe K000187 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19859 | 19859 | Whitmell Martin M000201 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19886 | 19886 | Robert Moore M000915 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
19904 | 19904 | David O’Connell O000022 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
19913 | 19913 | James O’Connor O000028 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19982 | 19982 | Charles Stedman S000827 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19994 | 19994 | Hubert Stephens S000857 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
20053 | 20053 | Otis Wingo W000635 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
20101 | 20101 | James Aswell A000321 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
20160 | 20160 | Guy Campbell C000084 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 32 | |||||||||||||
20215 | 20215 | James Collier C000630 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
20264 | 20264 | Charles Crisp C000909 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20285 | 20285 | Ewin Davis D000098 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
20301 | 20301 | Frederick Dominick D000408 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20312 | 20312 | Herbert Drane D000486 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
20362 | 20362 | John Evans E000247 | rep | MT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
20432 | 20432 | Thomas Gore G000323 | sen | OK | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
20545 | 20545 | Cordell Hull H000940 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
20629 | 20629 | William Lankford L000082 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
20637 | 20637 | William Larsen L000103 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
20657 | 20657 | John Linthicum L000340 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
20685 | 20685 | Samuel Major M000074 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
20714 | 20714 | Charles Mooney M000887 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 20 | |||||||||||||
20791 | 20791 | Percy Quin Q000014 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
20883 | 20883 | William Stevenson S000895 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
21032 | 21032 | William Wright W000773 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21082 | 21082 | Edward Almon A000162 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21098 | 21098 | William Ayres A000354 | rep | KS | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21134 | 21134 | Charles Brand B000767 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21142 | 21142 | Clay Briggs B000826 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
21228 | 21228 | Clement Dickinson D000316 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
21260 | 21260 | Duncan Fletcher F000200 | sen | FL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
21289 | 21289 | John Garner G000074 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 15 | |||||||||||||
21308 | 21308 | William Hastings H000333 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
21381 | 21381 | Augustine Lonergan L000409 | rep | CT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
21401 | 21401 | James McClintic M000338 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
21424 | 21424 | Thomas McKeown M000511 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21431 | 21431 | Jacob Milligan M000766 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
21491 | 21491 | Edward Pou P000474 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21519 | 21519 | Henry Rainey R000014 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 20 | |||||||||||||
21644 | 21644 | Thomas Blanton B000549 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
21675 | 21675 | Joseph Byrns B001217 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
21755 | 21755 | Joe Eagle E000003 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21781 | 21781 | Anthony Griffin G000457 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
21820 | 21820 | George Huddleston H000903 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
21863 | 21863 | John McDuffie M000427 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
21902 | 21902 | William Oliver O000077 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
21962 | 21962 | William Sears S000211 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21999 | 21999 | Riley Wilson W000608 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
22065 | 22065 | James Buchanan B001006 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
22081 | 22081 | James Byrnes B001215 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 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);