legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
189 rows where party = "Republican" and "start" is on date 1939-01-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22548 | 22548 | John Danaher D000025 | sen | CT | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
22563 | 22563 | James Davis D000111 | sen | PA | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
22612 | 22612 | Ernest Gibson G000158 | sen | VT | 1939-01-03 | 1941-01-03 | 3 | Republican | |||||||||||||
22630 | 22630 | Rufus Holman H000731 | sen | OR | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
22737 | 22737 | Gerald Nye N000176 | sen | ND | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
23853 | 23853 | John Gurney G000532 | sen | SD | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
24060 | 24060 | Clyde Reed R000112 | sen | KS | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
25517 | 25517 | Robert Taft T000009 | sen | OH | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
25523 | 25523 | Charles Tobey T000289 | sen | NH | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
26667 | 26667 | Alexander Wiley W000465 | sen | WI | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
22631 | 22631 | Frank Horton H000798 | rep | WY | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
22688 | 22688 | Lycurgus Marshall M000159 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
22835 | 22835 | George Williams W000500 | rep | DE | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
23081 | 23081 | Samuel King K000214 | rep | HI | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
23621 | 23621 | Boleslaus Monkiewicz M000855 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
24884 | 24884 | William Lemke L000238 | rep | ND | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
24995 | 24995 | Charles Plumley P000395 | rep | VT | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
25847 | 25847 | George Bender B000356 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
26191 | 26191 | Usher Burdick B001079 | rep | ND | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
22629 | 22629 | George Heinke H000454 | rep | NE | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
22753 | 22753 | Charles Risk R000269 | rep | RI | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
22804 | 22804 | John Sweet S001108 | rep | NE | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
22816 | 22816 | Jacob Thorkelson T000236 | rep | MT | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
22887 | 22887 | Stephen Bolles B000604 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23062 | 23062 | Arthur Jenks J000090 | rep | NH | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23576 | 23576 | William Lambertson L000037 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23664 | 23664 | Andrew Schiffler S000126 | rep | WV | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23724 | 23724 | Allen Treadway T000358 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23996 | 23996 | James Mott M001040 | rep | OR | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
24616 | 24616 | William Miller M000764 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
25249 | 25249 | Charles Elston E000160 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
25299 | 25299 | Leonard Hall H000060 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
26048 | 26048 | Thomas Martin M000199 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
26168 | 26168 | August Andresen A000239 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
26681 | 26681 | Charles Wolverton W000683 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
26924 | 26924 | James Oliver O000074 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
27467 | 27467 | Brazilla Reece R000108 | rep | TN | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
28988 | 28988 | Karl Mundt M001078 | rep | SD | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
22487 | 22487 | Thomas Ball B000102 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22628 | 22628 | Charles Hawks H000375 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22636 | 22636 | Walter Jeffries J000075 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22758 | 22758 | Harry Sandager S000031 | rep | RI | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22784 | 22784 | Clyde Smith S000523 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22815 | 22815 | James Taylor T000083 | rep | TN | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23448 | 23448 | Harry Englebright E000182 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23543 | 23543 | Ulysses Guyer G000538 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23702 | 23702 | Foster Stearns S000823 | rep | NH | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
24305 | 24305 | Charles Clason C000473 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
24859 | 24859 | John Jennings J000096 | rep | TN | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
24942 | 24942 | Earl Michener M000693 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
26215 | 26215 | Francis Case C000221 | rep | SD | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
26871 | 26871 | William Hess H000550 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
27185 | 27185 | Henry Dworshak D000585 | rep | ID | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
28862 | 28862 | Charles Halleck H000081 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
29040 | 29040 | Margaret Smith S000590 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22471 | 22471 | John Alexander A000097 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
22626 | 22626 | Harry Griswold G000484 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
22754 | 22754 | Harry Routzohn R000470 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24203 | 24203 | Thomas Winter W000645 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24283 | 24283 | Ralph Brewster B000816 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24433 | 24433 | Robert Grant G000384 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24447 | 24447 | John Gwynne G000543 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
25494 | 25494 | Karl Stefan S000845 | rep | NE | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
25577 | 25577 | Homer Angell A000257 | rep | OR | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
25800 | 25800 | Paul Shafer S000277 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
22486 | 22486 | Albert Austin A000339 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
22764 | 22764 | John Schafer S000111 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
23590 | 23590 | Melvin Maas M000001 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
23886 | 23886 | Pehr Holmes H000741 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
24045 | 24045 | David Powers P000488 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
24427 | 24427 | George Gillie G000207 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
24503 | 24503 | Robert Jones J000249 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
26622 | 26622 | Henry Talle T000028 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
26972 | 26972 | Edward Rees R000132 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
27233 | 27233 | Clare Hoffman H000683 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
30264 | 30264 | Carl Curtis C001006 | rep | NE | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
22603 | 22603 | Fred Gartner G000087 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
22687 | 22687 | Carl Mapes M000119 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
23294 | 23294 | Lewis Thill T000153 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
23330 | 23330 | Oscar Youngdahl Y000059 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
24455 | 24455 | Forest Harness H000217 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
24508 | 24508 | Bartel Jonkman J000264 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
25068 | 25068 | Richard Welch W000265 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
25242 | 25242 | Charles Eaton E000023 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
26228 | 26228 | Cliff Clevenger C000515 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
26482 | 26482 | Karl Le Compte L000157 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
26990 | 26990 | Edith Rogers R000392 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
22582 | 22582 | Cassius Dowell D000468 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
22623 | 22623 | Robert Goodwin G000303 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
23369 | 23369 | Albert Carter C000195 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
23601 | 23601 | Donald McLean M000545 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
24497 | 24497 | Noble Johnson J000165 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
24525 | 24525 | Harold Knutson K000301 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
24733 | 24733 | George Bates B000232 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
24869 | 24869 | Frank Keefe K000041 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
25139 | 25139 | William Blackney B000515 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
27702 | 27702 | Frank Carlson C000154 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
22560 | 22560 | George Darrow D000063 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
24530 | 24530 | Gerald Landis L000052 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
25042 | 25042 | John Thomas T000175 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 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);