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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23345 | 23345 | Joseph Ball B000099 | sen | MN | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23496 | 23496 | Richard Gale G000014 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23592 | 23592 | Melvin Maas M000001 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24039 | 24039 | William Pittenger P000371 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
24527 | 24527 | Harold Knutson K000301 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
25690 | 25690 | Harold Hagen H000014 | rep | MN | 1943-01-06 | 1945-01-03 | Farmer-Labor | 9 | |||||||||||||
26170 | 26170 | August Andresen A000239 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
26547 | 26547 | Joseph O’Hara O000056 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
27077 | 27077 | Herman Andersen A000179 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
27258 | 27258 | Walter Judd J000278 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
23440 | 23440 | William Elmer E000157 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
23618 | 23618 | Louis Miller M000745 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
23812 | 23812 | John Cochran C000565 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
24096 | 24096 | Roger Slaughter S000481 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24261 | 24261 | Samuel Arnold A000296 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24269 | 24269 | Charles Bell B000332 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24272 | 24272 | Marion Bennett B000379 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24628 | 24628 | Walter Ploeser P000387 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 12 | |||||||||||||
24672 | 24672 | Max Schwabe S000156 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24725 | 24725 | Orville Zimmerman Z000009 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
25634 | 25634 | William Cole C000614 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26121 | 26121 | Dewey Short S000377 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
27689 | 27689 | Clarence Cannon C000117 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
23987 | 23987 | Daniel McGehee M000446 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
25094 | 25094 | William Whittington W000430 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25444 | 25444 | John Rankin R000056 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
28283 | 28283 | William Winstead W000641 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
29524 | 29524 | Thomas Abernethy A000016 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
29701 | 29701 | William Colmer C000645 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
30338 | 30338 | James Eastland E000018 | sen | MS | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
35643 | 35643 | Jamie Whitten W000428 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24009 | 24009 | James O’Connor O000029 | rep | MT | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
26060 | 26060 | James Murray M001108 | sen | MT | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
29902 | 29902 | Michael Mansfield M000113 | rep | MT | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23343 | 23343 | Josiah Bailey B000046 | sen | NC | 1943-01-06 | 1947-01-03 | 2 | Democrat | |||||||||||||
23625 | 23625 | Cameron Morrison M000993 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
23795 | 23795 | William Burgin B001084 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
24198 | 24198 | Zebulon Weaver W000230 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
24301 | 24301 | Jerome Clark C000439 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24392 | 24392 | John Folger F000241 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24785 | 24785 | Alfred Bulwinkle B001056 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
25229 | 25229 | Robert Doughton D000448 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
25358 | 25358 | John Kerr K000138 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
26712 | 26712 | Graham Barden B000139 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
26828 | 26828 | Carl Durham D000571 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
28331 | 28331 | Herbert Bonner B000621 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
28378 | 28378 | Harold Cooley C000736 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24885 | 24885 | William Lemke L000238 | rep | ND | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
26193 | 26193 | Usher Burdick B001079 | rep | ND | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
25074 | 25074 | Kenneth Wherry W000344 | sen | NE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
25159 | 25159 | Howard Buffett B001039 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
25496 | 25496 | Karl Stefan S000845 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26519 | 26519 | Arthur Miller M000715 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
30266 | 30266 | Carl Curtis C001006 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23704 | 23704 | Foster Stearns S000823 | rep | NH | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
25881 | 25881 | Henry Bridges B000823 | sen | NH | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
27370 | 27370 | Chester Merrow M000664 | rep | NH | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23551 | 23551 | Albert Hawkes H000365 | sen | NJ | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23603 | 23603 | Donald McLean M000545 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
23738 | 23738 | Elmer Wene W000294 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24047 | 24047 | David Powers P000488 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24467 | 24467 | Fred Hartley H000298 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
24689 | 24689 | Frank Sundstrom S001076 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
24960 | 24960 | Mary Norton N000153 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
25044 | 25044 | John Thomas T000175 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
25244 | 25244 | Charles Eaton E000023 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
25526 | 25526 | Harry Towe T000320 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
25700 | 25700 | Edward Hart H000284 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
26438 | 26438 | Robert Kean K000029 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 12 | |||||||||||||
26683 | 26683 | Charles Wolverton W000683 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
26783 | 26783 | Gordon Canfield C000113 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
27608 | 27608 | James Auchincloss A000227 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23550 | 23550 | Carl Hatch H000334 | sen | NM | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
25953 | 25953 | Antonio Fernández F000085 | rep | NM | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
28758 | 28758 | Clinton Anderson A000186 | rep | NM | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23707 | 23707 | Maurice Sullivan S001058 | rep | NV | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23352 | 23352 | Thomas Burchill B001072 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
23355 | 23355 | Louis Capozzoli C000132 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
23393 | 23393 | Francis Culkin C000968 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 | |||||||||||||
23406 | 23406 | Thomas Cullen C000970 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23434 | 23434 | Fred Douglas D000453 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 33 | |||||||||||||
23452 | 23452 | James Fay F000051 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
23465 | 23465 | Hamilton Fish F000142 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 26 | |||||||||||||
23474 | 23474 | James Fitzpatrick F000175 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 24 | |||||||||||||
23504 | 23504 | Joseph Gavagan G000101 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
23563 | 23563 | Martin Kennedy K000111 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 18 | |||||||||||||
23617 | 23617 | Matthew Merritt M000661 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23626 | 23626 | Joseph Mruk M001058 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 41 | |||||||||||||
23635 | 23635 | Joseph O’Brien O000014 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 38 | |||||||||||||
23642 | 23642 | James O’Leary O000065 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
23681 | 23681 | Winifred Stanley S000798 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23768 | 23768 | Joseph Baldwin B000093 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
23774 | 23774 | William Barry B000191 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23836 | 23836 | Samuel Dickstein D000335 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
23863 | 23863 | Clarence Hancock H000146 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 35 | |||||||||||||
24164 | 24164 | James Torrens T000315 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
24258 | 24258 | Walter Andrews A000250 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 40 | |||||||||||||
24287 | 24287 | Ellsworth Buck B001016 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
24346 | 24346 | John Delaney D000212 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24396 | 24396 | Hadwen Fuller F000404 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 |
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);