legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
492 rows where "start" is on date 1941-01-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26546 | 26546 | Joseph O’Hara O000056 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
26505 | 26505 | J. McGregor M000460 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
26483 | 26483 | Karl Le Compte L000157 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
26455 | 26455 | Augustine Kelley K000058 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 28 | |||||||||||||
26437 | 26437 | Robert Kean K000029 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 12 | |||||||||||||
26427 | 26427 | Thomas Jenkins J000088 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
26390 | 26390 | William Hill H000613 | rep | CO | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
26336 | 26336 | Noble Gregory G000447 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
26312 | 26312 | Herman Eberharter E000029 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 32 | |||||||||||||
26305 | 26305 | Martin Dies D000338 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
26274 | 26274 | Paul Cunningham C000993 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
26256 | 26256 | Jere Cooper C000755 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
26241 | 26241 | William Cole C000617 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 37 | |||||||||||||
26229 | 26229 | Cliff Clevenger C000515 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
26216 | 26216 | Francis Case C000221 | rep | SD | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
26192 | 26192 | Usher Burdick B001079 | rep | ND | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
26169 | 26169 | August Andresen A000239 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
26141 | 26141 | Jesse Wolcott W000668 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
26120 | 26120 | Dewey Short S000377 | rep | MO | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
26108 | 26108 | James Richards R000214 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
26096 | 26096 | Chauncey Reed R000111 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 11 | |||||||||||||
26085 | 26085 | James Priest P000536 | rep | TN | 1941-01-03 | 1943-01-03 | Ind. Democrat | 5 | |||||||||||||
26049 | 26049 | Thomas Martin M000199 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
26036 | 26036 | Arthur Klein K000261 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
26014 | 26014 | Clifford Hope H000768 | rep | KS | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
25995 | 25995 | John Hinshaw H000640 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 11 | |||||||||||||
25968 | 25968 | Ralph Gamble G000031 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 25 | |||||||||||||
25933 | 25933 | George Dondero D000411 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
25915 | 25915 | John Dingell D000354 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
25860 | 25860 | Joseph O’Mahoney O000088 | sen | WY | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
25848 | 25848 | George Bender B000356 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
25801 | 25801 | Paul Shafer S000277 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
25767 | 25767 | George O’Brien O000009 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
25743 | 25743 | William Langer L000070 | sen | ND | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
25737 | 25737 | Harley Kilgore K000176 | sen | WV | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
25717 | 25717 | Merlin Hull H000943 | rep | WI | 1941-01-03 | 1943-01-03 | Progressive | 9 | |||||||||||||
25699 | 25699 | Edward Hart H000284 | rep | NJ | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
25683 | 25683 | Louis Graham G000360 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 26 | |||||||||||||
25651 | 25651 | Robert Crosser C000932 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
25625 | 25625 | Albert Camp C000070 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
25621 | 25621 | Hugh Butler B001177 | sen | NE | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
25609 | 25609 | Joseph Bryson B000999 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
25594 | 25594 | Cecil Bishop B000486 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 25 | |||||||||||||
25578 | 25578 | Homer Angell A000257 | rep | OR | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
25563 | 25563 | Roy Woodruff W000718 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
25511 | 25511 | John Sullivan S001056 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
25495 | 25495 | Karl Stefan S000845 | rep | NE | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
25478 | 25478 | Lansdale Sasscer S000067 | rep | MD | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
25471 | 25471 | Adolph Sabath S000001 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
25443 | 25443 | John Rankin R000056 | rep | MS | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
25430 | 25430 | Robert Ramsay R000025 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
25415 | 25415 | Donald O’Toole O000133 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
25405 | 25405 | Reid Murray M001112 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
25396 | 25396 | John Murdock M001081 | rep | AZ | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
25357 | 25357 | John Kerr K000138 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
25342 | 25342 | John Kee K000039 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
25316 | 25316 | James Heffernan H000443 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
25300 | 25300 | Leonard Hall H000060 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
25293 | 25293 | Edwin Hall H000050 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 34 | |||||||||||||
25285 | 25285 | Walter Granger G000379 | rep | UT | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
25279 | 25279 | Ed Gossett G000338 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
25272 | 25272 | Wilson Gillette G000206 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
25256 | 25256 | Frank Fellows F000066 | rep | ME | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
25250 | 25250 | Charles Elston E000160 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
25243 | 25243 | Charles Eaton E000023 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
25228 | 25228 | Robert Doughton D000448 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
25206 | 25206 | Fred Crawford C000889 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
25197 | 25197 | Edward Cox C000831 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
25173 | 25173 | William Byrne B001214 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 28 | |||||||||||||
25166 | 25166 | John Butler B001179 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 42 | |||||||||||||
25140 | 25140 | William Blackney B000515 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
25132 | 25132 | Joseph Bates B000237 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
25121 | 25121 | John Anderson A000196 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
25114 | 25114 | Asa Allen A000114 | rep | LA | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
25101 | 25101 | Francis Worley W000744 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 18 | |||||||||||||
25093 | 25093 | William Whittington W000430 | rep | MS | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
25081 | 25081 | Compton White W000361 | rep | ID | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
25069 | 25069 | Richard Welch W000265 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
25054 | 25054 | James Wadsworth W000012 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 39 | |||||||||||||
25043 | 25043 | John Thomas T000175 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
25035 | 25035 | Andrew Somers S000676 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
25022 | 25022 | Frederick Smith S000536 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
25007 | 25007 | Robert Rich R000209 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 16 | |||||||||||||
24996 | 24996 | Charles Plumley P000395 | rep | VT | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
24984 | 24984 | Joseph Pfeifer P000285 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
24976 | 24976 | James Peterson P000261 | rep | FL | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
24967 | 24967 | Stephen Pace P000002 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
24959 | 24959 | Mary Norton N000153 | rep | NJ | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
24943 | 24943 | Earl Michener M000693 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
24919 | 24919 | Burnet Maybank M000279 | sen | SC | 1941-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
24913 | 24913 | Vito Marcantonio M000122 | rep | NY | 1941-01-03 | 1943-01-03 | American Labor | 20 | |||||||||||||
24904 | 24904 | Walter Lynch L000537 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 22 | |||||||||||||
24893 | 24893 | John Lesinski L000251 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 16 | |||||||||||||
24870 | 24870 | Frank Keefe K000041 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
24860 | 24860 | John Jennings J000096 | rep | TN | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
24849 | 24849 | Samuel Hobbs H000663 | rep | AL | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
24825 | 24825 | Albert Engel E000178 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
24798 | 24798 | Virgil Chapman C000317 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
24784 | 24784 | Alfred Bulwinkle B001056 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 10 | |||||||||||||
24768 | 24768 | Sol Bloom B000565 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 19 |
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);