legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
487 rows where "start" is on date 1943-01-06 sorted by state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24490 | 24490 | Anton Johnson J000117 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 14 | |||||||||||||
24807 | 24807 | Ralph Church C000390 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
24838 | 24838 | Martin Gorski G000332 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24922 | 24922 | Rolla McMillen M000574 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 19 | |||||||||||||
25472 | 25472 | Adolph Sabath S000001 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25595 | 25595 | Cecil Bishop B000486 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 25 | |||||||||||||
25617 | 25617 | Fred Busbey B001161 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26097 | 26097 | Chauncey Reed R000111 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
26326 | 26326 | Thomas Gordon G000316 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
26603 | 26603 | Sidney Simpson S000437 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 20 | |||||||||||||
26643 | 26643 | Charles Vursell V000125 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
26697 | 26697 | Leo Allen A000138 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 13 | |||||||||||||
27144 | 27144 | Robert Chiperfield C000365 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 15 | |||||||||||||
27346 | 27346 | Noah Mason M000224 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 12 | |||||||||||||
27747 | 27747 | Everett Dirksen D000360 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 16 | |||||||||||||
28056 | 28056 | Thomas O’Brien O000016 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
29204 | 29204 | William Dawson D000158 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
30142 | 30142 | Leslie Arends A000216 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
23944 | 23944 | Charles La Follette L000003 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
24429 | 24429 | George Gillie G000207 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24435 | 24435 | Robert Grant G000384 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24457 | 24457 | Forest Harness H000217 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24499 | 24499 | Noble Johnson J000165 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24532 | 24532 | Gerald Landis L000052 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
24567 | 24567 | Louis Ludlow L000501 | rep | IN | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24680 | 24680 | Raymond Springer S000755 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
28273 | 28273 | Earl Wilson W000572 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
28864 | 28864 | Charles Halleck H000081 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
31143 | 31143 | Ray Madden M000039 | rep | IN | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23360 | 23360 | Arthur Capper C000133 | sen | KS | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23545 | 23545 | Ulysses Guyer G000538 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23578 | 23578 | William Lambertson L000037 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24205 | 24205 | Thomas Winter W000645 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26015 | 26015 | Clifford Hope H000768 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
26579 | 26579 | Errett Scrivner S000194 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26974 | 26974 | Edward Rees R000132 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
27704 | 27704 | Frank Carlson C000154 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
23361 | 23361 | Chester Carrier C000181 | rep | KY | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23373 | 23373 | Albert Chandler C000290 | sen | KY | 1943-01-06 | 1945-12-31 | 2 | Democrat | |||||||||||||
23384 | 23384 | Edward Creal C000898 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23731 | 23731 | Beverly Vincent V000100 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23981 | 23981 | Andrew May M000272 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24015 | 24015 | Emmet O’Neal O000089 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24661 | 24661 | John Robsion R000358 | rep | KY | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24799 | 24799 | Virgil Chapman C000317 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
25133 | 25133 | Joseph Bates B000237 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
26337 | 26337 | Noble Gregory G000447 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27539 | 27539 | Brent Spence S000717 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23972 | 23972 | Paul Maloney M000091 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23990 | 23990 | Charles McKenzie M000504 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24351 | 24351 | James Domengeaux D000406 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25115 | 25115 | Asa Allen A000114 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25363 | 25363 | Henry Larcade L000095 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
27130 | 27130 | Overton Brooks B000884 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
28574 | 28574 | James Morrison M000995 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
28817 | 28817 | Allen Ellender E000112 | sen | LA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
31036 | 31036 | Felix Hébert H000437 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23726 | 23726 | Allen Treadway T000358 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23821 | 23821 | James Curley C000996 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
23888 | 23888 | Pehr Holmes H000741 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24307 | 24307 | Charles Clason C000473 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24424 | 24424 | Charles Gifford G000169 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24557 | 24557 | Henry Lodge L000394 | sen | MA | 1943-01-06 | 1945-01-03 | 2 | Republican | |||||||||||||
24735 | 24735 | George Bates B000232 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
25322 | 25322 | Christian Herter H000548 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
25676 | 25676 | Angier Goodwin G000297 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
26659 | 26659 | Richard Wigglesworth W000450 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 13 | |||||||||||||
26992 | 26992 | Edith Rogers R000392 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
27305 | 27305 | Thomas Lane L000065 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
28538 | 28538 | Joseph Martin M000191 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 14 | |||||||||||||
29372 | 29372 | John McCormack M000364 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
29406 | 29406 | Philip Philbin P000303 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23439 | 23439 | Daniel Ellison E000141 | rep | MD | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23735 | 23735 | David Ward W000130 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23765 | 23765 | Harry Baldwin B000086 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24336 | 24336 | Thomas D’Alesandro D000007 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25479 | 25479 | Lansdale Sasscer S000067 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
26726 | 26726 | James Beall B000271 | rep | MD | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
23756 | 23756 | Wallace White W000396 | sen | ME | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
25257 | 25257 | Frank Fellows F000066 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26352 | 26352 | Robert Hale H000036 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
29042 | 29042 | Margaret Smith S000590 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24277 | 24277 | Frederick Bradley B000742 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
24510 | 24510 | Bartel Jonkman J000264 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24826 | 24826 | Albert Engel E000178 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24830 | 24830 | Homer Ferguson F000081 | sen | MI | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24894 | 24894 | John Lesinski L000251 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
24944 | 24944 | Earl Michener M000693 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
25014 | 25014 | George Sadowski S000011 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25141 | 25141 | William Blackney B000515 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
25207 | 25207 | Fred Crawford C000889 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
25564 | 25564 | Roy Woodruff W000718 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
25768 | 25768 | George O’Brien O000009 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
25802 | 25802 | Paul Shafer S000277 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25916 | 25916 | John Dingell D000354 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
25934 | 25934 | George Dondero D000411 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
26142 | 26142 | Jesse Wolcott W000668 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
27235 | 27235 | Clare Hoffman H000683 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
27420 | 27420 | Louis Rabaut R000001 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
27643 | 27643 | John Bennett B000377 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 12 |
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);