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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18474 | 18474 | Isaac Siegel S000404 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 20 | |||||||||||||
18481 | 18481 | Thomas Sisson S000456 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18489 | 18489 | Campbell Slemp S000486 | rep | VA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
18491 | 18491 | Selden Spencer S000730 | sen | MO | 1918-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
18502 | 18502 | Halvor Steenerson S000842 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
18506 | 18506 | Walter Stiness S000927 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18508 | 18508 | Philip Stoll S000951 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18512 | 18512 | Burton Sweet S001106 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
18536 | 18536 | Lester Volk V000111 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
18546 | 18546 | Andrew Volstead V000114 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
18550 | 18550 | Joseph Walsh W000101 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 16 | |||||||||||||
18556 | 18556 | James Woods W000723 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18568 | 18568 | Sydney Anderson A000233 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
18601 | 18601 | Raymond Cole C000613 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
18615 | 18615 | Charles Davis D000093 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
18634 | 18634 | Louis Fairfield F000007 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
18645 | 18645 | William Fields F000113 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18649 | 18649 | Israel Foster F000306 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
18652 | 18652 | James Ganly G000038 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 24 | |||||||||||||
18657 | 18657 | William Graham G000364 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
18671 | 18671 | William Greene G000430 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
18678 | 18678 | Harry Hull H000941 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18689 | 18689 | Benjamin Humphreys H000960 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18705 | 18705 | Julius Kahn K000003 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18717 | 18717 | Claude Kitchin K000250 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18732 | 18732 | Edward Little L000349 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18753 | 18753 | John McKenzie M000506 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
18761 | 18761 | Daniel Minahan M000789 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18768 | 18768 | Merrill Moores M000928 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
18776 | 18776 | Luther Mott M001041 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 32 | |||||||||||||
18781 | 18781 | Sydney Mudd M001060 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18790 | 18790 | Henry Osborne O000112 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
18796 | 18796 | Calvin Paige P000024 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
18814 | 18814 | Stuart Reed R000127 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18826 | 18826 | Daniel Riordan R000264 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
18835 | 18835 | Everett Sanders S000034 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18846 | 18846 | Isaac Sherwood S000355 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18853 | 18853 | John Smith S000573 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18858 | 18858 | Homer Snyder S000666 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 33 | |||||||||||||
18864 | 18864 | Peter Tague T000014 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
18871 | 18871 | Horace Towner T000325 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
18878 | 18878 | Charles Ward W000129 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 27 | |||||||||||||
18884 | 18884 | John Webster W000240 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18892 | 18892 | Samuel Winslow W000639 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18897 | 18897 | James Wise W000650 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18904 | 18904 | George Young Y000036 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
18952 | 18952 | Charles Fuller F000407 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
18972 | 18972 | Frederick Gillett G000201 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19001 | 19001 | Ben Johnson J000118 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
19005 | 19005 | Oscar Keller K000057 | rep | MN | 1919-05-19 | 1921-03-03 | Ind. Republican | 4 | |||||||||||||
19016 | 19016 | John Langley L000072 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
19027 | 19027 | Gordon Lee L000194 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19037 | 19037 | Melvin McLaughlin M000541 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
19046 | 19046 | Cleveland Newton N000075 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
19050 | 19050 | Francis Patterson P000114 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19054 | 19054 | Nathan Perlman P000239 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
19067 | 19067 | John Raker R000019 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19084 | 19084 | John Rogers R000400 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
19092 | 19092 | Arthur Rouse R000466 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
19099 | 19099 | Frank Scott S000169 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
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 | |||||||||||||
19131 | 19131 | Jasper Tincher T000282 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
19137 | 19137 | William Upshaw U000026 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19142 | 19142 | Edward Voigt V000110 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19147 | 19147 | Anderson Walters W000109 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
19161 | 19161 | Loren Wheeler W000339 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 21 | |||||||||||||
19173 | 19173 | Harry Woodyard W000737 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
19184 | 19184 | Frank Smith S000534 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 17 | |||||||||||||
19193 | 19193 | Daniel Anthony A000261 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19202 | 19202 | James Begg B000314 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
19208 | 19208 | Victor Berger B000407 | rep | WI | 1919-05-19 | 1921-03-03 | Socialist | -1 | |||||||||||||
19216 | 19216 | Eugene Black B000495 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19222 | 19222 | William Boies B000597 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
19229 | 19229 | William Bowling B000702 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19251 | 19251 | Thomas Butler B001192 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
19259 | 19259 | Thaddeus Caraway C000139 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19262 | 19262 | William Carss C000194 | rep | MN | 1919-05-19 | 1921-03-03 | Union Labor | 8 | |||||||||||||
19277 | 19277 | Charles Curtis C001008 | sen | KS | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19282 | 19282 | Porter Dale D000009 | rep | VT | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
19337 | 19337 | William Green G000422 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
19344 | 19344 | Thomas Harrison H000277 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19351 | 19351 | Ira Hersey H000544 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
19356 | 19356 | Everette Howard H000837 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19368 | 19368 | Wesley Jones J000257 | sen | WA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19380 | 19380 | Edward King K000200 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
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);