legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "start" is on date 1919-05-19 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: end, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28206 | 28206 | Carl Vinson V000105 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
27847 | 27847 | Carl Hayden H000385 | rep | AZ | 1919-05-19 | 1921-03-03 | Democrat | 0 | |||||||||||||
27437 | 27437 | Samuel Rayburn R000082 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
26950 | 26950 | Daniel Reed R000113 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 43 | |||||||||||||
26066 | 26066 | Matthew Neely N000023 | rep | WV | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
25870 | 25870 | Alben Barkley B000145 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
25460 | 25460 | Adolph Sabath S000001 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
25327 | 25327 | Clyde Hoey H000679 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
25217 | 25217 | Robert Doughton D000448 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
24933 | 24933 | Earl Michener M000693 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
24743 | 24743 | Schuyler Bland B000545 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
24650 | 24650 | John Robsion R000358 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
24578 | 24578 | Joseph Mansfield M000112 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
24536 | 24536 | Clarence Lea L000163 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
24515 | 24515 | Harold Knutson K000301 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
24354 | 24354 | Patrick Drewry D000496 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
24314 | 24314 | Thomas Connally C000684 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
24187 | 24187 | Zebulon Weaver W000230 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
24116 | 24116 | Hatton Sumners S001072 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
23946 | 23946 | Fritz Lanham L000076 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
23748 | 23748 | Wallace White W000396 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
23714 | 23714 | Allen Treadway T000358 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
23689 | 23689 | Henry Steagall S000820 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
23607 | 23607 | Charles McNary M000583 | sen | OR | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
23453 | 23453 | Hamilton Fish F000142 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 26 | |||||||||||||
23394 | 23394 | Thomas Cullen C000970 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
23356 | 23356 | Arthur Capper C000133 | sen | KS | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
23313 | 23313 | David Walsh W000097 | sen | MA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
23298 | 23298 | George Tinkham T000283 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
23275 | 23275 | Edward Taylor T000072 | rep | CO | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
23195 | 23195 | Milton Romjue R000418 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
23156 | 23156 | William Nelson N000046 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
23128 | 23128 | James Mead M000615 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 42 | |||||||||||||
22945 | 22945 | Frank Crowther C000948 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 30 | |||||||||||||
22805 | 22805 | James Taylor T000083 | rep | TN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
22793 | 22793 | Christopher Sullivan S001051 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
22705 | 22705 | Clarence McLeod M000557 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
22701 | 22701 | James McAndrews M000296 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
22677 | 22677 | Carl Mapes M000119 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
22664 | 22664 | Robert Luce L000498 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
22638 | 22638 | John Jones J000236 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 18 | |||||||||||||
22573 | 22573 | Cassius Dowell D000468 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
22551 | 22551 | George Darrow D000063 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
22489 | 22489 | William Bankhead B000113 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
22482 | 22482 | William Ashbrook A000306 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
22418 | 22418 | Bertrand Snell S000652 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 31 | |||||||||||||
22410 | 22410 | Morris Sheppard S000337 | sen | TX | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22336 | 22336 | George Norris N000139 | sen | NE | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
22319 | 22319 | Andrew Montague M000861 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
22222 | 22222 | Byron Harrison H000265 | sen | MS | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22148 | 22148 | Benjamin Focht F000230 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 17 | |||||||||||||
22081 | 22081 | James Byrnes B001215 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
22065 | 22065 | James Buchanan B001006 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
22049 | 22049 | William Borah B000634 | sen | ID | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
21999 | 21999 | Riley Wilson W000608 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
21962 | 21962 | William Sears S000211 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21932 | 21932 | Harry Ransley R000061 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
21902 | 21902 | William Oliver O000077 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
21881 | 21881 | Schuyler Merritt M000663 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
21863 | 21863 | John McDuffie M000427 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
21848 | 21848 | Frederick Lehlbach L000222 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
21820 | 21820 | George Huddleston H000903 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
21781 | 21781 | Anthony Griffin G000457 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
21755 | 21755 | Joe Eagle E000003 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21712 | 21712 | John Cooper C000757 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 19 | |||||||||||||
21675 | 21675 | Joseph Byrns B001217 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
21644 | 21644 | Thomas Blanton B000549 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
21631 | 21631 | Isaac Bacharach B000009 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
21589 | 21589 | Henry Watson W000201 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
21562 | 21562 | Nathan Strong S001015 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 27 | |||||||||||||
21543 | 21543 | James Sinclair S000442 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
21519 | 21519 | Henry Rainey R000014 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 20 | |||||||||||||
21491 | 21491 | Edward Pou P000474 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21467 | 21467 | James Parker P000062 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 29 | |||||||||||||
21431 | 21431 | Jacob Milligan M000766 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
21424 | 21424 | Thomas McKeown M000511 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21411 | 21411 | Louis McFadden M000434 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
21401 | 21401 | James McClintic M000338 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
21381 | 21381 | Augustine Lonergan L000409 | rep | CT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
21352 | 21352 | Melville Kelly K000076 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 30 | |||||||||||||
21333 | 21333 | William James J000053 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
21308 | 21308 | William Hastings H000333 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
21289 | 21289 | John Garner G000074 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 15 | |||||||||||||
21273 | 21273 | James Frear F000355 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
21246 | 21246 | George Edmonds E000053 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
21228 | 21228 | Clement Dickinson D000316 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
21153 | 21153 | Frederick Britten B000847 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
21142 | 21142 | Clay Briggs B000826 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
21134 | 21134 | Charles Brand B000767 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21098 | 21098 | William Ayres A000354 | rep | KS | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21082 | 21082 | Edward Almon A000162 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21051 | 21051 | Richard Yates Y000011 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
21032 | 21032 | William Wright W000773 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21024 | 21024 | William Wood W000706 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
21006 | 21006 | James Wickersham W000438 | rep | AK | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
20987 | 20987 | Edward Wason W000185 | rep | NH | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20982 | 20982 | Thomas Walsh W000104 | sen | MT | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20969 | 20969 | Albert Vestal V000092 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
20945 | 20945 | Charles Timberlake T000281 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20936 | 20936 | John Tilson T000279 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 3 |
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);