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 end descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17545 | 17545 | Lewis Ball B000100 | sen | DE | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17644 | 17644 | Nathaniel Dial D000298 | sen | SC | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17657 | 17657 | Davis Elkins E000109 | sen | WV | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17829 | 17829 | Joseph McCormick M000369 | sen | IL | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17880 | 17880 | Robert Owen O000153 | sen | OK | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17932 | 17932 | John Shields S000363 | sen | TN | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17964 | 17964 | Augustus Stanley S000796 | sen | KY | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17969 | 17969 | Thomas Sterling S000872 | sen | SD | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18932 | 18932 | Walter Edge E000044 | sen | NJ | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18940 | 18940 | Bert Fernald F000084 | sen | ME | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
19060 | 19060 | Lawrence Phipps P000317 | sen | CO | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
19079 | 19079 | Joseph Ransdell R000059 | sen | LA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
19107 | 19107 | Furnifold Simmons S000415 | sen | NC | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
19155 | 19155 | Francis Warren W000164 | sen | WY | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
20475 | 20475 | William Harris H000259 | sen | GA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20605 | 20605 | Henry Keyes K000161 | sen | NH | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
20813 | 20813 | Joseph Robinson R000347 | sen | AR | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20982 | 20982 | Thomas Walsh W000104 | sen | MT | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22049 | 22049 | William Borah B000634 | sen | ID | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
22222 | 22222 | Byron Harrison H000265 | sen | MS | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22336 | 22336 | George Norris N000139 | sen | NE | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
22410 | 22410 | Morris Sheppard S000337 | sen | TX | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
23313 | 23313 | David Walsh W000097 | sen | MA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
23356 | 23356 | Arthur Capper C000133 | sen | KS | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
23607 | 23607 | Charles McNary M000583 | sen | OR | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17629 | 17629 | LeBaron Colt C000651 | sen | RI | 1919-05-19 | 1924-08-18 | 2 | Republican | |||||||||||||
17867 | 17867 | Knute Nelson N000040 | sen | MN | 1919-05-19 | 1923-12-31 | 2 | Republican | |||||||||||||
17799 | 17799 | William Kenyon K000129 | sen | IA | 1919-05-19 | 1923-03-03 | 2 | Republican | |||||||||||||
17868 | 17868 | Truman Newberry N000062 | sen | MI | 1919-05-19 | 1922-11-18 | 2 | Republican | |||||||||||||
17685 | 17685 | Albert Fall F000011 | sen | NM | 1919-05-19 | 1921-03-04 | 2 | Republican | |||||||||||||
17538 | 17538 | Joshua Alexander A000098 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17539 | 17539 | William Andrews A000253 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17540 | 17540 | John Babka B000007 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 21 | |||||||||||||
17542 | 17542 | John Baer B000027 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17558 | 17558 | John Bankhead B000110 | sen | AL | 1919-05-19 | 1921-03-03 | 2 | Democrat | |||||||||||||
17559 | 17559 | Carlos Bee B000303 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
17561 | 17561 | Carville Benson B000387 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17562 | 17562 | William Bland B000547 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17570 | 17570 | Charles Booher B000626 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17575 | 17575 | William Browning B000961 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17579 | 17579 | Clement Brumbaugh B000975 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
17590 | 17590 | John Burnett B001121 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17593 | 17593 | Charles Caldwell C000030 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17603 | 17603 | Ezekiel Candler C000110 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17610 | 17610 | Charles Carlin C000151 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | -1 | |||||||||||||
17623 | 17623 | James Clark C000437 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
17627 | 17627 | Charles Coady C000541 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17632 | 17632 | Peter Costello C000796 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
17634 | 17634 | Gilbert Currie C000998 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17640 | 17640 | Stanley Dent D000256 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17643 | 17643 | Arthur Dewalt D000288 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
17646 | 17646 | Jerome Donovan D000423 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 21 | |||||||||||||
17650 | 17650 | Peter Dooling D000426 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 15 | |||||||||||||
17655 | 17655 | Frank Doremus D000431 | rep | MI | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17660 | 17660 | Franklin Ellsworth E000145 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
17663 | 17663 | Henry Emerson E000171 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 22 | |||||||||||||
17674 | 17674 | John Esch E000212 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
17681 | 17681 | Albert Estopinal E000224 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17682 | 17682 | Charles Evans E000234 | rep | NV | 1919-05-19 | 1921-03-03 | Democrat | 0 | |||||||||||||
17690 | 17690 | John Farr F000029 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17697 | 17697 | Scott Ferris F000091 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17701 | 17701 | John Fitzgerald F000164 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
17703 | 17703 | Alvan Fuller F000405 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
17709 | 17709 | Thomas Gallagher G000018 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17712 | 17712 | Harry Gandy G000037 | rep | SD | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17716 | 17716 | Warren Gard G000048 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17719 | 17719 | Mahlon Garland G000068 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
17726 | 17726 | Hannibal Godwin G000250 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17734 | 17734 | Henry Goldfogle G000260 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
17736 | 17736 | Louis Goodall G000276 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17741 | 17741 | William Goodwin G000304 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17742 | 17742 | George Grigsby G000474 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
17749 | 17749 | James Hamill H000099 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
17761 | 17761 | Edward Hamilton H000108 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
17764 | 17764 | Reuben Haskell H000319 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17771 | 17771 | Harvey Helm H000461 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | -1 | |||||||||||||
17773 | 17773 | Benigno Hernández H000532 | rep | NM | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17774 | 17774 | Hugh Hersman H000546 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17775 | 17775 | William Hill H000610 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 34 | |||||||||||||
17780 | 17780 | Edward Holland H000716 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17782 | 17782 | Willis Hulings H000939 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 28 | |||||||||||||
17786 | 17786 | William Igoe I000005 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
17787 | 17787 | John Johnston J000190 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17789 | 17789 | Niels Juul J000282 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
17796 | 17796 | Charles Kennedy K000104 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17803 | 17803 | William Kettner K000155 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
17807 | 17807 | John Lesher L000250 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
17817 | 17817 | Asbury Lever L000259 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17818 | 17818 | John MacCrate M000002 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17823 | 17823 | James Maher M000063 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17824 | 17824 | Edward Mann M000101 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17827 | 17827 | James Mays M000290 | rep | UT | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17830 | 17830 | Cornelius McGlennon M000450 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17831 | 17831 | Richard McKiniry M000517 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 23 | |||||||||||||
17832 | 17832 | Patrick McLane M000536 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
17833 | 17833 | James Monahan M000849 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17845 | 17845 | John Moon M000884 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17853 | 17853 | Joseph Moore M000906 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17859 | 17859 | Dick Morgan M000947 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17871 | 17871 | Samuel Nicholls N000088 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 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);