legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
182 rows where party = "Republican" and "start" is on date 1941-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22854 | 22854 | Warren Austin A000342 | sen | VT | 1941-01-03 | 1946-08-02 | 1 | Republican | |||||||||||||
22858 | 22858 | William Barbour B000132 | sen | NJ | 1941-01-03 | 1943-12-31 | 1 | Republican | |||||||||||||
22871 | 22871 | Philip Bennett B000380 | rep | MO | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
22888 | 22888 | Stephen Bolles B000604 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
22898 | 22898 | Harold Burton B001150 | sen | OH | 1941-01-03 | 1945-12-31 | 1 | Republican | |||||||||||||
22919 | 22919 | Ernest Cluett C000535 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 29 | |||||||||||||
22944 | 22944 | Oren Copeland C000768 | rep | NE | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
22956 | 22956 | Frank Crowther C000948 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 30 | |||||||||||||
23005 | 23005 | Leland Ford F000264 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 16 | |||||||||||||
23060 | 23060 | Benjamin Jarrett J000060 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 20 | |||||||||||||
23063 | 23063 | Arthur Jenks J000090 | rep | NH | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23065 | 23065 | Joshua Johns J000111 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
23076 | 23076 | Hiram Johnson J000140 | sen | CA | 1941-01-03 | 1945-12-31 | 1 | Republican | |||||||||||||
23082 | 23082 | Samuel King K000214 | rep | HI | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
23155 | 23155 | Harry Narey N000006 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
23169 | 23169 | George Paddock P000011 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
23175 | 23175 | William Pheiffer P000288 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 16 | |||||||||||||
23185 | 23185 | Jeannette Rankin R000055 | rep | MT | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23188 | 23188 | Lewis Rockefeller R000362 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 27 | |||||||||||||
23209 | 23209 | Albert Rutherford R000546 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
23241 | 23241 | Henrik Shipstead S000369 | sen | MN | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
23242 | 23242 | Kenneth Simpson S000433 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23295 | 23295 | Lewis Thill T000153 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
23309 | 23309 | George Tinkham T000283 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
23312 | 23312 | Albert Vreeland V000121 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 11 | |||||||||||||
23329 | 23329 | Raymond Willis W000563 | sen | IN | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
23331 | 23331 | Oscar Youngdahl Y000059 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
23370 | 23370 | Albert Carter C000195 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
23392 | 23392 | Francis Culkin C000968 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 32 | |||||||||||||
23407 | 23407 | Stephen Day D000160 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
23409 | 23409 | Charles Dewey D000292 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
23429 | 23429 | John Ditter D000363 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23433 | 23433 | Fred Douglas D000453 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 33 | |||||||||||||
23449 | 23449 | Harry Englebright E000182 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
23464 | 23464 | Hamilton Fish F000142 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 26 | |||||||||||||
23495 | 23495 | Richard Gale G000014 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
23510 | 23510 | Fred Gilchrist G000181 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
23544 | 23544 | Ulysses Guyer G000538 | rep | KS | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
23554 | 23554 | William Johnson J000183 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 18 | |||||||||||||
23577 | 23577 | William Lambertson L000037 | rep | KS | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23591 | 23591 | Melvin Maas M000001 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
23602 | 23602 | Donald McLean M000545 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
23619 | 23619 | Thomas Miller M000756 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 12 | |||||||||||||
23634 | 23634 | Joseph O’Brien O000014 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 38 | |||||||||||||
23655 | 23655 | Thomas Rolph R000413 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
23703 | 23703 | Foster Stearns S000823 | rep | NH | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
23725 | 23725 | Allen Treadway T000358 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23740 | 23740 | William Wheat W000327 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 19 | |||||||||||||
23767 | 23767 | Joseph Baldwin B000093 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23862 | 23862 | Clarence Hancock H000146 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 35 | |||||||||||||
23875 | 23875 | James Heidinger H000450 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 24 | |||||||||||||
23887 | 23887 | Pehr Holmes H000741 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
23936 | 23936 | John Kinzer K000231 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
23997 | 23997 | James Mott M001040 | rep | OR | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
24038 | 24038 | William Pittenger P000371 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
24046 | 24046 | David Powers P000488 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
24071 | 24071 | Robert Rodgers R000373 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 29 | |||||||||||||
24110 | 24110 | Jessie Sumner S001071 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 18 | |||||||||||||
24130 | 24130 | Joseph Talbot T000018 | rep | CT | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
24204 | 24204 | Thomas Winter W000645 | rep | KS | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
24214 | 24214 | James Wolfenden W000678 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
24257 | 24257 | Walter Andrews A000250 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 40 | |||||||||||||
24276 | 24276 | Frederick Bradley B000742 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 11 | |||||||||||||
24284 | 24284 | Ralph Brewster B000816 | sen | ME | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
24306 | 24306 | Charles Clason C000473 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
24404 | 24404 | Bertrand Gearhart G000111 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
24409 | 24409 | Charles Gerlach G000135 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
24423 | 24423 | Charles Gifford G000169 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
24428 | 24428 | George Gillie G000207 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
24434 | 24434 | Robert Grant G000384 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
24448 | 24448 | John Gwynne G000543 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
24456 | 24456 | Forest Harness H000217 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
24466 | 24466 | Fred Hartley H000298 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
24476 | 24476 | George Howell H000863 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 21 | |||||||||||||
24489 | 24489 | Anton Johnson J000117 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 14 | |||||||||||||
24498 | 24498 | Noble Johnson J000165 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
24504 | 24504 | Robert Jones J000249 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
24509 | 24509 | Bartel Jonkman J000264 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
24526 | 24526 | Harold Knutson K000301 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
24531 | 24531 | Gerald Landis L000052 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
24627 | 24627 | Walter Ploeser P000387 | rep | MO | 1941-01-03 | 1943-01-03 | Republican | 12 | |||||||||||||
24643 | 24643 | Ross Rizley R000288 | rep | OK | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
24647 | 24647 | Charles Robertson R000319 | rep | ND | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
24660 | 24660 | John Robsion R000358 | rep | KY | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
24664 | 24664 | Robert Rockwell R000369 | rep | CO | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
24679 | 24679 | Raymond Springer S000755 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
24683 | 24683 | William Stevenson S000896 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
24687 | 24687 | William Stratton S000998 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
24702 | 24702 | Harve Tibbott T000263 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 27 | |||||||||||||
24710 | 24710 | Arthur Vandenberg V000025 | sen | MI | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
24734 | 24734 | George Bates B000232 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
24825 | 24825 | Albert Engel E000178 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
24860 | 24860 | John Jennings J000096 | rep | TN | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
24870 | 24870 | Frank Keefe K000041 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
24943 | 24943 | Earl Michener M000693 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
24996 | 24996 | Charles Plumley P000395 | rep | VT | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
25007 | 25007 | Robert Rich R000209 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 16 | |||||||||||||
25022 | 25022 | Frederick Smith S000536 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
25043 | 25043 | John Thomas T000175 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
25054 | 25054 | James Wadsworth W000012 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 39 |
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);