legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
496 rows where "start" is on date 1917-04-02 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20656 | 20656 | John Linthicum L000340 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
20636 | 20636 | William Larsen L000103 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
20620 | 20620 | Fiorello La Guardia L000007 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 14 | |||||||||||||
20576 | 20576 | Royal Johnson J000173 | rep | SD | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20566 | 20566 | Albert Johnson J000114 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
20544 | 20544 | Cordell Hull H000940 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
20502 | 20502 | Willis Hawley H000379 | rep | OR | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
20489 | 20489 | Gilbert Haugen H000350 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
20446 | 20446 | Lindley Hadley H000008 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20436 | 20436 | George Graham G000354 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20409 | 20409 | Daniel Garrett G000081 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
20392 | 20392 | Burton French F000375 | rep | ID | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
20379 | 20379 | Richard Freeman F000366 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20361 | 20361 | John Evans E000247 | rep | MT | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
20330 | 20330 | Félix Dávila D000090 | rep | PR | 1917-04-02 | 1919-03-03 | Unionist | 0 | |||||||||||||
20322 | 20322 | Leonidas Dyer D000591 | rep | MO | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
20311 | 20311 | Herbert Drane D000486 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
20300 | 20300 | Frederick Dominick D000408 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
20273 | 20273 | Frederick Dallinger D000012 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
20263 | 20263 | Charles Crisp C000909 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
20243 | 20243 | Henry Cooper C000752 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
20214 | 20214 | James Collier C000630 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
20159 | 20159 | Guy Campbell C000084 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 32 | |||||||||||||
20100 | 20100 | James Aswell A000321 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
20061 | 20061 | Frederick Zihlman Z000007 | rep | MD | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
20052 | 20052 | Otis Wingo W000635 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
20043 | 20043 | Thomas Williams W000542 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 24 | |||||||||||||
20016 | 20016 | Claude Swanson S001094 | sen | VA | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
19993 | 19993 | Hubert Stephens S000857 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19981 | 19981 | Charles Stedman S000827 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
19958 | 19958 | Charles Sloan S000491 | rep | NE | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
19927 | 19927 | Stephen Porter P000447 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 29 | |||||||||||||
19879 | 19879 | John Miller M000739 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19868 | 19868 | Roscoe McCulloch M000392 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 16 | |||||||||||||
19858 | 19858 | Whitmell Martin M000201 | rep | LA | 1917-04-02 | 1919-03-03 | Progressive | 3 | |||||||||||||
19839 | 19839 | Florian Lampert L000041 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
19826 | 19826 | David Kincheloe K000187 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19818 | 19818 | Edgar Kiess K000168 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 15 | |||||||||||||
19811 | 19811 | John Kendrick K000098 | sen | WY | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
19803 | 19803 | Charles Kearns K000033 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
19745 | 19745 | William Griest G000456 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
19736 | 19736 | Frank Greene G000425 | rep | VT | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19726 | 19726 | James Glynn G000246 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
19703 | 19703 | Hubert Fisher F000149 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
19698 | 19698 | Simeon Fess F000096 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
19677 | 19677 | Richard Elliott E000127 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
19666 | 19666 | Clarence Dill D000345 | rep | WA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
19658 | 19658 | Edward Denison D000237 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 25 | |||||||||||||
19650 | 19650 | Stephen Dempsey D000229 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 40 | |||||||||||||
19639 | 19639 | Charles Curry C001000 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
19630 | 19630 | Louis Cramton C000870 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
19609 | 19609 | John Carew C000142 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 17 | |||||||||||||
19600 | 19600 | Edward Browne B000955 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
19580 | 19580 | Thomas Bell B000348 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
19521 | 19521 | William Vare V000071 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19505 | 19505 | John Tillman T000276 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
19482 | 19482 | Nicholas Sinnott S000450 | rep | OR | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
19473 | 19473 | Thomas Rubey R000491 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 16 | |||||||||||||
19449 | 19449 | William Oldfield O000062 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19430 | 19430 | John Morin M000961 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 31 | |||||||||||||
19419 | 19419 | Walter Magee M000049 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 35 | |||||||||||||
19412 | 19412 | Martin Madden M000038 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19387 | 19387 | Ladislas Lazaro L000153 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19379 | 19379 | Edward King K000200 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 15 | |||||||||||||
19350 | 19350 | Ira Hersey H000544 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
19343 | 19343 | Thomas Harrison H000277 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19336 | 19336 | William Green G000422 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
19325 | 19325 | Finis Garrett G000082 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
19310 | 19310 | James Gallivan G000024 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
19286 | 19286 | Martin Davey D000080 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
19281 | 19281 | Porter Dale D000009 | rep | VT | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
19258 | 19258 | Thaddeus Caraway C000139 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19250 | 19250 | Thomas Butler B001192 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
19215 | 19215 | Eugene Black B000495 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19192 | 19192 | Daniel Anthony A000261 | rep | KS | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19172 | 19172 | Harry Woodyard W000737 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
19160 | 19160 | Loren Wheeler W000339 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 21 | |||||||||||||
19141 | 19141 | Edward Voigt V000110 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
19126 | 19126 | Robert Thomas T000185 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
19098 | 19098 | Frank Scott S000169 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
19091 | 19091 | Arthur Rouse R000466 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
19083 | 19083 | John Rogers R000400 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
19066 | 19066 | John Raker R000019 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19026 | 19026 | Gordon Lee L000194 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19015 | 19015 | John Langley L000072 | rep | KY | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
19000 | 19000 | Ben Johnson J000118 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18986 | 18986 | James Heflin H000446 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
18971 | 18971 | Frederick Gillett G000201 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18951 | 18951 | Charles Fuller F000407 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
18935 | 18935 | Benjamin Fairchild F000004 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 24 | |||||||||||||
18927 | 18927 | William Cleary C000500 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
18921 | 18921 | Charles Carter C000196 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18903 | 18903 | George Young Y000036 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18896 | 18896 | James Wise W000650 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18891 | 18891 | Samuel Winslow W000639 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
18877 | 18877 | Charles Ward W000129 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 27 | |||||||||||||
18870 | 18870 | Horace Towner T000325 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
18863 | 18863 | Peter Tague T000014 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
18857 | 18857 | Homer Snyder S000666 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 33 | |||||||||||||
18852 | 18852 | John Smith S000573 | rep | MI | 1917-04-02 | 1919-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);