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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24484 | 24484 | Peterson Jarman J000058 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24490 | 24490 | Anton Johnson J000117 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 14 | |||||||||||||
24499 | 24499 | Noble Johnson J000165 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24505 | 24505 | Robert Jones J000249 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24510 | 24510 | Bartel Jonkman J000264 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24527 | 24527 | Harold Knutson K000301 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24532 | 24532 | Gerald Landis L000052 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
24548 | 24548 | Clarence Lea L000163 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24552 | 24552 | Earl Lewis L000279 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
24557 | 24557 | Henry Lodge L000394 | sen | MA | 1943-01-06 | 1945-01-03 | 2 | Republican | |||||||||||||
24567 | 24567 | Louis Ludlow L000501 | rep | IN | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24574 | 24574 | Carter Manasco M000094 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24590 | 24590 | Joseph Mansfield M000112 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
24595 | 24595 | Edward McCowen M000374 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24617 | 24617 | William Miller M000764 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24622 | 24622 | Fred Norman N000135 | rep | WA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24628 | 24628 | Walter Ploeser P000387 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 12 | |||||||||||||
24632 | 24632 | Emory Price P000524 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24637 | 24637 | Homer Ramey R000022 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24644 | 24644 | Ross Rizley R000288 | rep | OK | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
24661 | 24661 | John Robsion R000358 | rep | KY | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24665 | 24665 | Robert Rockwell R000369 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24668 | 24668 | Edward Rohrbough R000410 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24672 | 24672 | Max Schwabe S000156 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24680 | 24680 | Raymond Springer S000755 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
24684 | 24684 | William Stevenson S000896 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24689 | 24689 | Frank Sundstrom S001076 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
24698 | 24698 | Robert Thomason T000189 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
24703 | 24703 | Harve Tibbott T000263 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 27 | |||||||||||||
24717 | 24717 | Milton West W000304 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
24725 | 24725 | Orville Zimmerman Z000009 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
24735 | 24735 | George Bates B000232 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24755 | 24755 | Schuyler Bland B000545 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24769 | 24769 | Sol Bloom B000565 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
24785 | 24785 | Alfred Bulwinkle B001056 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24799 | 24799 | Virgil Chapman C000317 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24807 | 24807 | Ralph Church C000390 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
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 | |||||||||||||
24838 | 24838 | Martin Gorski G000332 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24850 | 24850 | Samuel Hobbs H000663 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24861 | 24861 | John Jennings J000096 | rep | TN | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24866 | 24866 | Edwin Johnson J000127 | sen | CO | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24871 | 24871 | Frank Keefe K000041 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24876 | 24876 | Jay Le Fevre L000161 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 27 | |||||||||||||
24885 | 24885 | William Lemke L000238 | rep | ND | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
24894 | 24894 | John Lesinski L000251 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
24905 | 24905 | Walter Lynch L000537 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 22 | |||||||||||||
24914 | 24914 | Vito Marcantonio M000122 | rep | NY | 1943-01-06 | 1945-01-03 | American Labor | 20 | |||||||||||||
24920 | 24920 | Burnet Maybank M000279 | sen | SC | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24922 | 24922 | Rolla McMillen M000574 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 19 | |||||||||||||
24944 | 24944 | Earl Michener M000693 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24960 | 24960 | Mary Norton N000153 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
24968 | 24968 | Stephen Pace P000002 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24977 | 24977 | James Peterson P000261 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24985 | 24985 | Joseph Pfeifer P000285 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24997 | 24997 | Charles Plumley P000395 | rep | VT | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
25014 | 25014 | George Sadowski S000011 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25023 | 25023 | Frederick Smith S000536 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
25036 | 25036 | Andrew Somers S000676 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
25044 | 25044 | John Thomas T000175 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
25055 | 25055 | James Wadsworth W000012 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 39 | |||||||||||||
25070 | 25070 | Richard Welch W000265 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
25074 | 25074 | Kenneth Wherry W000344 | sen | NE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
25082 | 25082 | Compton White W000361 | rep | ID | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25094 | 25094 | William Whittington W000430 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25102 | 25102 | Francis Worley W000744 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 18 | |||||||||||||
25115 | 25115 | Asa Allen A000114 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25122 | 25122 | John Anderson A000196 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
25133 | 25133 | Joseph Bates B000237 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25141 | 25141 | William Blackney B000515 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
25150 | 25150 | Walter Brehm B000794 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
25159 | 25159 | Howard Buffett B001039 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
25167 | 25167 | John Butler B001179 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 42 | |||||||||||||
25174 | 25174 | William Byrne B001214 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 28 | |||||||||||||
25198 | 25198 | Edward Cox C000831 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25207 | 25207 | Fred Crawford C000889 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
25229 | 25229 | Robert Doughton D000448 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
25244 | 25244 | Charles Eaton E000023 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
25251 | 25251 | Charles Elston E000160 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25257 | 25257 | Frank Fellows F000066 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25273 | 25273 | Wilson Gillette G000206 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 15 | |||||||||||||
25280 | 25280 | Ed Gossett G000338 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
25286 | 25286 | Walter Granger G000379 | rep | UT | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25294 | 25294 | Edwin Hall H000050 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 34 | |||||||||||||
25301 | 25301 | Leonard Hall H000060 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25317 | 25317 | James Heffernan H000443 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25322 | 25322 | Christian Herter H000548 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
25343 | 25343 | John Kee K000039 | rep | WV | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25358 | 25358 | John Kerr K000138 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25363 | 25363 | Henry Larcade L000095 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
25397 | 25397 | John Murdock M001081 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
25406 | 25406 | Reid Murray M001112 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
25416 | 25416 | Donald O’Toole O000133 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25444 | 25444 | John Rankin R000056 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25472 | 25472 | Adolph Sabath S000001 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25479 | 25479 | Lansdale Sasscer S000067 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25496 | 25496 | Karl Stefan S000845 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25501 | 25501 | William Stigler S000923 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25506 | 25506 | Lowell Stockman S000936 | rep | OR | 1943-01-06 | 1945-01-03 | Republican | 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);