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 district
This data as json, copyable, CSV (advanced)
Suggested facets: party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23343 | 23343 | Josiah Bailey B000046 | sen | NC | 1943-01-06 | 1947-01-03 | 2 | Democrat | |||||||||||||
23345 | 23345 | Joseph Ball B000099 | sen | MN | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23348 | 23348 | John Bankhead B000111 | sen | AL | 1943-01-06 | 1947-01-03 | 2 | Democrat | |||||||||||||
23350 | 23350 | Charles Brooks B000874 | sen | IL | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23351 | 23351 | Clayton Buck B001013 | sen | DE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23353 | 23353 | Harlan Bushfield B001168 | sen | SD | 1943-01-06 | 1948-09-27 | 2 | Republican | |||||||||||||
23360 | 23360 | Arthur Capper C000133 | sen | KS | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23373 | 23373 | Albert Chandler C000290 | sen | KY | 1943-01-06 | 1945-12-31 | 2 | Democrat | |||||||||||||
23525 | 23525 | Carter Glass G000232 | sen | VA | 1943-01-06 | 1946-05-28 | 2 | Democrat | |||||||||||||
23550 | 23550 | Carl Hatch H000334 | sen | NM | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
23551 | 23551 | Albert Hawkes H000365 | sen | NJ | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23611 | 23611 | Charles McNary M000583 | sen | OR | 1943-01-06 | 1944-02-25 | 2 | Republican | |||||||||||||
23623 | 23623 | Edward Moore M000895 | sen | OK | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23637 | 23637 | Wilbert O’Daniel O000034 | sen | TX | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
23653 | 23653 | Edward Robertson R000320 | sen | WY | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23706 | 23706 | Arthur Stewart S000901 | sen | TN | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
23710 | 23710 | John Thomas T000172 | sen | ID | 1943-01-06 | 1945-12-31 | 2 | Republican | |||||||||||||
23756 | 23756 | Wallace White W000396 | sen | ME | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23758 | 23758 | George Wilson W000581 | sen | IA | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24557 | 24557 | Henry Lodge L000394 | sen | MA | 1943-01-06 | 1945-01-03 | 2 | Republican | |||||||||||||
24830 | 24830 | Homer Ferguson F000081 | sen | MI | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24866 | 24866 | Edwin Johnson J000127 | sen | CO | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24920 | 24920 | Burnet Maybank M000279 | sen | SC | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
25074 | 25074 | Kenneth Wherry W000344 | sen | NE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
25881 | 25881 | Henry Bridges B000823 | sen | NH | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
25984 | 25984 | Theodore Green G000418 | sen | RI | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
26060 | 26060 | James Murray M001108 | sen | MT | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
26153 | 26153 | William Revercomb R000167 | sen | WV | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
28817 | 28817 | Allen Ellender E000112 | sen | LA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
29026 | 29026 | Richard Russell R000536 | sen | GA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
30338 | 30338 | James Eastland E000018 | sen | MS | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
30565 | 30565 | John McClellan M000332 | sen | AR | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
23535 | 23535 | Robert Green G000415 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | -1 | |||||||||||||
23408 | 23408 | Stephen Day D000160 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23417 | 23417 | Anthony Dimond D000353 | rep | AK | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23438 | 23438 | Joaquin Elizalde E000108 | rep | PI | 1943-01-06 | 1945-01-03 | 0 | ||||||||||||||
23617 | 23617 | Matthew Merritt M000661 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23622 | 23622 | Boleslaus Monkiewicz M000855 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23645 | 23645 | Bolívar Pagán P000013 | rep | PR | 1943-01-06 | 1945-01-03 | Coalitionist | 0 | |||||||||||||
23681 | 23681 | Winifred Stanley S000798 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23707 | 23707 | Maurice Sullivan S001058 | rep | NV | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23727 | 23727 | William Troutman T000384 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23757 | 23757 | Earle Willey W000483 | rep | DE | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
24077 | 24077 | Carlos Romulo R000419 | rep | PI | 1943-01-06 | 1945-01-03 | 0 | ||||||||||||||
24452 | 24452 | Richard Harless H000212 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
24885 | 24885 | William Lemke L000238 | rep | ND | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
24997 | 24997 | Charles Plumley P000395 | rep | VT | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
25397 | 25397 | John Murdock M001081 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
25585 | 25585 | Frank Barrett B000176 | rep | WY | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
25664 | 25664 | Joseph Farrington F000034 | rep | HI | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
25849 | 25849 | George Bender B000356 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
25953 | 25953 | Antonio Fernández F000085 | rep | NM | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
26193 | 26193 | Usher Burdick B001079 | rep | ND | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
28758 | 28758 | Clinton Anderson A000186 | rep | NM | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23424 | 23424 | Wesley Disney D000362 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23578 | 23578 | William Lambertson L000037 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23584 | 23584 | Lawrence Lewis L000291 | rep | CO | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23665 | 23665 | Andrew Schiffler S000126 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23726 | 23726 | Allen Treadway T000358 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23735 | 23735 | David Ward W000130 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23850 | 23850 | Dean Gillespie G000194 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23998 | 23998 | James Mott M001040 | rep | OR | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24032 | 24032 | Hugh Peterson P000260 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24261 | 24261 | Samuel Arnold A000296 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24399 | 24399 | James Gallagher G000017 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24548 | 24548 | Clarence Lea L000163 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24617 | 24617 | William Miller M000764 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24755 | 24755 | Schuyler Bland B000545 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24977 | 24977 | James Peterson P000261 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25014 | 25014 | George Sadowski S000011 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25082 | 25082 | Compton White W000361 | rep | ID | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25251 | 25251 | Charles Elston E000160 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25286 | 25286 | Walter Granger G000379 | rep | UT | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25301 | 25301 | Leonard Hall H000060 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25444 | 25444 | John Rankin R000056 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
26050 | 26050 | Thomas Martin M000199 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
26170 | 26170 | August Andresen A000239 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
26337 | 26337 | Noble Gregory G000447 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
26352 | 26352 | Robert Hale H000036 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
26612 | 26612 | Lawrence Smith S000585 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
26683 | 26683 | Charles Wolverton W000683 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
26851 | 26851 | Aime Forand F000255 | rep | RI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27114 | 27114 | Frank Boykin B000725 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27370 | 27370 | Chester Merrow M000664 | rep | NH | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
27469 | 27469 | Brazilla Reece R000108 | rep | TN | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
28331 | 28331 | Herbert Bonner B000621 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
28847 | 28847 | Ezekiel Gathings G000098 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
28990 | 28990 | Karl Mundt M001078 | rep | SD | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
29204 | 29204 | William Dawson D000158 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
29444 | 29444 | Lucius Rivers R000280 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
29902 | 29902 | Michael Mansfield M000113 | rep | MT | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
30266 | 30266 | Carl Curtis C001006 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
31036 | 31036 | Felix Hébert H000437 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
31143 | 31143 | Ray Madden M000039 | rep | IN | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
31259 | 31259 | John Patman P000103 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23450 | 23450 | Harry Englebright E000182 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23492 | 23492 | Hampton Fulmer F000417 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23493 | 23493 | Willa Fulmer F000418 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23545 | 23545 | Ulysses Guyer G000538 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23547 | 23547 | Winder Harris H000260 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 2 |
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);