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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20846 | 20846 | Milton Shreve S000387 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 25 | |||||||||||||
20835 | 20835 | Thomas Schall S000113 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
20826 | 20826 | Archie Sanders S000032 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 39 | |||||||||||||
20800 | 20800 | Christian Ramseyer R000031 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
20791 | 20791 | Percy Quin Q000014 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
20781 | 20781 | Fred Purnell P000573 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
20733 | 20733 | Benjamin Murphy M001089 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 18 | |||||||||||||
20720 | 20720 | Charles Moore M000894 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
20714 | 20714 | Charles Mooney M000887 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 20 | |||||||||||||
20703 | 20703 | James McLaughlin M000539 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
20685 | 20685 | Samuel Major M000074 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
20671 | 20671 | Nicholas Longworth L000433 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20657 | 20657 | John Linthicum L000340 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
20637 | 20637 | William Larsen L000103 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
20629 | 20629 | William Lankford L000082 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
20621 | 20621 | Fiorello La Guardia L000007 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
20592 | 20592 | Samuel Kendall K000097 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 23 | |||||||||||||
20577 | 20577 | Royal Johnson J000173 | rep | SD | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20567 | 20567 | Albert Johnson J000114 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
20545 | 20545 | Cordell Hull H000940 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
20510 | 20510 | Homer Hoch H000669 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
20503 | 20503 | Willis Hawley H000379 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20490 | 20490 | Gilbert Haugen H000350 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
20468 | 20468 | Guy Hardy H000195 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
20447 | 20447 | Lindley Hadley H000008 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20437 | 20437 | George Graham G000354 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20432 | 20432 | Thomas Gore G000323 | sen | OK | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
20393 | 20393 | Burton French F000375 | rep | ID | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20380 | 20380 | Richard Freeman F000366 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20362 | 20362 | John Evans E000247 | rep | MT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
20331 | 20331 | Félix Dávila D000090 | rep | PR | 1919-05-19 | 1921-03-03 | Unionist | 0 | |||||||||||||
20323 | 20323 | Leonidas Dyer D000591 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
20312 | 20312 | Herbert Drane D000486 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
20301 | 20301 | Frederick Dominick D000408 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20293 | 20293 | Lester Dickinson D000323 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
20285 | 20285 | Ewin Davis D000098 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
20274 | 20274 | Frederick Dallinger D000012 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
20264 | 20264 | Charles Crisp C000909 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20215 | 20215 | James Collier C000630 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
20187 | 20187 | Charles Christopherson C000384 | rep | SD | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20175 | 20175 | Carl Chindblom C000361 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
20160 | 20160 | Guy Campbell C000084 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 32 | |||||||||||||
20137 | 20137 | Clark Burdick B001075 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20113 | 20113 | Henry Barbour B000126 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
20101 | 20101 | James Aswell A000321 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
20073 | 20073 | Ernest Ackerman A000021 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
20062 | 20062 | Frederick Zihlman Z000007 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
20053 | 20053 | Otis Wingo W000635 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
20044 | 20044 | Thomas Williams W000542 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 24 | |||||||||||||
20019 | 20019 | Charles Thompson T000194 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
19994 | 19994 | Hubert Stephens S000857 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19982 | 19982 | Charles Stedman S000827 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19928 | 19928 | Stephen Porter P000447 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 29 | |||||||||||||
19913 | 19913 | James O’Connor O000028 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19904 | 19904 | David O’Connell O000022 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
19898 | 19898 | Walter Newton N000079 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
19886 | 19886 | Robert Moore M000915 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
19880 | 19880 | John Miller M000739 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19869 | 19869 | Roscoe McCulloch M000392 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 16 | |||||||||||||
19859 | 19859 | Whitmell Martin M000201 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19840 | 19840 | Florian Lampert L000041 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
19827 | 19827 | David Kincheloe K000187 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19819 | 19819 | Edgar Kiess K000168 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
19804 | 19804 | Charles Kearns K000033 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
19778 | 19778 | Claude Hudspeth H000910 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
19764 | 19764 | Andrew Hickey H000560 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
19746 | 19746 | William Griest G000456 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
19737 | 19737 | Frank Greene G000425 | rep | VT | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19727 | 19727 | James Glynn G000246 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
19718 | 19718 | Isauro Gabaldon G000001 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
19704 | 19704 | Hubert Fisher F000149 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
19699 | 19699 | Simeon Fess F000096 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
19678 | 19678 | Richard Elliott E000127 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
19674 | 19674 | James Dunbar D000525 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
19659 | 19659 | Edward Denison D000237 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 25 | |||||||||||||
19651 | 19651 | Stephen Dempsey D000229 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 40 | |||||||||||||
19640 | 19640 | Charles Curry C001000 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
19631 | 19631 | Louis Cramton C000870 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
19618 | 19618 | John Casey C000223 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
19610 | 19610 | John Carew C000142 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 18 | |||||||||||||
19601 | 19601 | Edward Browne B000955 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
19588 | 19588 | John Box B000710 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19581 | 19581 | Thomas Bell B000348 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
19539 | 19539 | Hays White W000374 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
19536 | 19536 | James Watson W000203 | sen | IN | 1916-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
19522 | 19522 | William Vare V000071 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19513 | 19513 | William Vaile V000004 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19506 | 19506 | John Tillman T000276 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19493 | 19493 | Ambrose Stephens S000855 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19490 | 19490 | Reed Smoot S000644 | sen | UT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19483 | 19483 | Nicholas Sinnott S000450 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19474 | 19474 | Thomas Rubey R000491 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
19457 | 19457 | Lee Overman O000140 | sen | NC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
19450 | 19450 | William Oldfield O000062 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19439 | 19439 | George Moses M001028 | sen | NH | 1918-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
19431 | 19431 | John Morin M000961 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 31 | |||||||||||||
19420 | 19420 | Walter Magee M000049 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 35 | |||||||||||||
19413 | 19413 | Martin Madden M000038 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19401 | 19401 | Clarence MacGregor M000009 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 41 | |||||||||||||
19388 | 19388 | Ladislas Lazaro L000153 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 7 |
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);