legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "end" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25994 | 25994 | John Hinshaw H000640 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 11 | |||||||||||||
25967 | 25967 | Ralph Gamble G000031 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 25 | |||||||||||||
25932 | 25932 | George Dondero D000411 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 17 | |||||||||||||
25914 | 25914 | John Dingell D000354 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
25859 | 25859 | Joseph O’Mahoney O000088 | sen | WY | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
25847 | 25847 | George Bender B000356 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
25800 | 25800 | Paul Shafer S000277 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
25716 | 25716 | Merlin Hull H000943 | rep | WI | 1939-01-03 | 1941-01-03 | Progressive | 9 | |||||||||||||
25698 | 25698 | Edward Hart H000284 | rep | NJ | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
25682 | 25682 | Louis Graham G000360 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 26 | |||||||||||||
25650 | 25650 | Robert Crosser C000932 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
25624 | 25624 | Albert Camp C000070 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
25608 | 25608 | Joseph Bryson B000999 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
25577 | 25577 | Homer Angell A000257 | rep | OR | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
25562 | 25562 | Roy Woodruff W000718 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
25494 | 25494 | Karl Stefan S000845 | rep | NE | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
25477 | 25477 | Lansdale Sasscer S000067 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
25470 | 25470 | Adolph Sabath S000001 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
25442 | 25442 | John Rankin R000056 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
25414 | 25414 | Donald O’Toole O000133 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
25404 | 25404 | Reid Murray M001112 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
25395 | 25395 | John Murdock M001081 | rep | AZ | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
25356 | 25356 | John Kerr K000138 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
25341 | 25341 | John Kee K000039 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
25307 | 25307 | Franck Havenner H000356 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
25299 | 25299 | Leonard Hall H000060 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
25292 | 25292 | Edwin Hall H000050 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 34 | |||||||||||||
25278 | 25278 | Ed Gossett G000338 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
25249 | 25249 | Charles Elston E000160 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
25242 | 25242 | Charles Eaton E000023 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
25227 | 25227 | Robert Doughton D000448 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
25205 | 25205 | Fred Crawford C000889 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
25196 | 25196 | Edward Cox C000831 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
25172 | 25172 | William Byrne B001214 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 28 | |||||||||||||
25139 | 25139 | William Blackney B000515 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
25131 | 25131 | Joseph Bates B000237 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
25120 | 25120 | John Anderson A000196 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
25113 | 25113 | Asa Allen A000114 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
25092 | 25092 | William Whittington W000430 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
25080 | 25080 | Compton White W000361 | rep | ID | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
25068 | 25068 | Richard Welch W000265 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
25053 | 25053 | James Wadsworth W000012 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 39 | |||||||||||||
25042 | 25042 | John Thomas T000175 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
25034 | 25034 | Andrew Somers S000676 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
25021 | 25021 | Frederick Smith S000536 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
25006 | 25006 | Robert Rich R000209 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
24995 | 24995 | Charles Plumley P000395 | rep | VT | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
24983 | 24983 | Joseph Pfeifer P000285 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24975 | 24975 | James Peterson P000261 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
24966 | 24966 | Stephen Pace P000002 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24958 | 24958 | Mary Norton N000153 | rep | NJ | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
24942 | 24942 | Earl Michener M000693 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
24912 | 24912 | Vito Marcantonio M000122 | rep | NY | 1939-01-03 | 1941-01-03 | American Labor | 20 | |||||||||||||
24903 | 24903 | Walter Lynch L000537 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 22 | |||||||||||||
24892 | 24892 | John Lesinski L000251 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
24884 | 24884 | William Lemke L000238 | rep | ND | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
24869 | 24869 | Frank Keefe K000041 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
24859 | 24859 | John Jennings J000096 | rep | TN | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
24848 | 24848 | Samuel Hobbs H000663 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24824 | 24824 | Albert Engel E000178 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
24806 | 24806 | Ralph Church C000390 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
24797 | 24797 | Virgil Chapman C000317 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
24783 | 24783 | Alfred Bulwinkle B001056 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
24767 | 24767 | Sol Bloom B000565 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
24753 | 24753 | Schuyler Bland B000545 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
24733 | 24733 | George Bates B000232 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
24723 | 24723 | Orville Zimmerman Z000009 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
24715 | 24715 | Milton West W000304 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
24709 | 24709 | Arthur Vandenberg V000025 | sen | MI | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
24701 | 24701 | Harve Tibbott T000263 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 27 | |||||||||||||
24696 | 24696 | Robert Thomason T000189 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
24678 | 24678 | Raymond Springer S000755 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
24659 | 24659 | John Robsion R000358 | rep | KY | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
24616 | 24616 | William Miller M000764 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
24610 | 24610 | Kenneth McKellar M000499 | sen | TN | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
24598 | 24598 | John McDowell M000422 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 31 | |||||||||||||
24588 | 24588 | Joseph Mansfield M000112 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
24565 | 24565 | Louis Ludlow L000501 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
24551 | 24551 | Earl Lewis L000279 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
24546 | 24546 | Clarence Lea L000163 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
24530 | 24530 | Gerald Landis L000052 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
24525 | 24525 | Harold Knutson K000301 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
24508 | 24508 | Bartel Jonkman J000264 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
24503 | 24503 | Robert Jones J000249 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
24497 | 24497 | Noble Johnson J000165 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
24488 | 24488 | Anton Johnson J000117 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 14 | |||||||||||||
24482 | 24482 | Peterson Jarman J000058 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
24471 | 24471 | Joseph Hendricks H000492 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24465 | 24465 | Fred Hartley H000298 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
24455 | 24455 | Forest Harness H000217 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
24447 | 24447 | John Gwynne G000543 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24441 | 24441 | Chester Gross G000493 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 22 | |||||||||||||
24433 | 24433 | Robert Grant G000384 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24427 | 24427 | George Gillie G000207 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
24422 | 24422 | Charles Gifford G000169 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 15 | |||||||||||||
24408 | 24408 | Charles Gerlach G000135 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
24403 | 24403 | Bertrand Gearhart G000111 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
24385 | 24385 | John Flannagan F000191 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
24371 | 24371 | Alfred Elliott E000119 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
24364 | 24364 | Patrick Drewry D000496 | rep | VA | 1939-01-03 | 1941-01-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);