legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
495 rows where "start" is on date 1939-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, end (date)
party 6 ✖
- Democrat 299
- Republican 189
- Coalitionist 2
- Progressive 2
- American Labor 1
- Farmer-Labor 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34047 | 34047 | Claude Pepper P000218 | sen | FL | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
32244 | 32244 | Jennings Randolph R000046 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
31719 | 31719 | William Poage P000398 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
31623 | 31623 | George Mahon M000065 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
31257 | 31257 | John Patman P000103 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
31181 | 31181 | Wilbur Mills M000778 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
31161 | 31161 | Warren Magnuson M000053 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
30695 | 30695 | John Sparkman S000701 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
30264 | 30264 | Carl Curtis C001006 | rep | NE | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
30140 | 30140 | Leslie Arends A000216 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 17 | |||||||||||||
29931 | 29931 | John McMillan M000568 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
29717 | 29717 | Robert Corbett C000772 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 30 | |||||||||||||
29699 | 29699 | William Colmer C000645 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
29679 | 29679 | Emanuel Celler C000264 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
29370 | 29370 | John McCormack M000364 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
29303 | 29303 | Michael Kirwan K000244 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
29040 | 29040 | Margaret Smith S000590 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
28988 | 28988 | Karl Mundt M001078 | rep | SD | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
28862 | 28862 | Charles Halleck H000081 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
28845 | 28845 | Ezekiel Gathings G000098 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
28787 | 28787 | Frances Bolton B000607 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 22 | |||||||||||||
28678 | 28678 | Albert Thomas T000156 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
28661 | 28661 | Howard Smith S000554 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
28646 | 28646 | Robert Secrest S000219 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
28536 | 28536 | Joseph Martin M000191 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 14 | |||||||||||||
28512 | 28512 | John Kunkel K000341 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 19 | |||||||||||||
28494 | 28494 | Eugene Keogh K000130 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
28425 | 28425 | Albert Gore G000320 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
28376 | 28376 | Harold Cooley C000736 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
28343 | 28343 | Clarence Brown B000909 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
28329 | 28329 | Herbert Bonner B000621 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
28317 | 28317 | Lindley Beckworth B000296 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
28295 | 28295 | Lyndon Johnson J000160 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
28235 | 28235 | Francis Walter W000108 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
28216 | 28216 | Carl Vinson V000105 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
28140 | 28140 | Harry Sheppard S000335 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
28067 | 28067 | Frank Osmers O000120 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
28023 | 28023 | Almer Monroney M000859 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
27950 | 27950 | Clarence Kilburn K000170 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 31 | |||||||||||||
27915 | 27915 | Benton Jensen J000100 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
27880 | 27880 | Joseph Hill H000598 | sen | AL | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
27853 | 27853 | Carl Hayden H000385 | sen | AZ | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
27817 | 27817 | George Grant G000381 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
27745 | 27745 | Everett Dirksen D000360 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
27723 | 27723 | Clifford Davis D000094 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
27702 | 27702 | Frank Carlson C000154 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
27687 | 27687 | Clarence Cannon C000117 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
27665 | 27665 | Charles Buckley B001024 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 23 | |||||||||||||
27573 | 27573 | James Van Zandt V000069 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 23 | |||||||||||||
27557 | 27557 | John Taber T000001 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 36 | |||||||||||||
27537 | 27537 | Brent Spence S000717 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
27490 | 27490 | Absalom Robertson R000317 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
27467 | 27467 | Brazilla Reece R000108 | rep | TN | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
27447 | 27447 | Samuel Rayburn R000082 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
27418 | 27418 | Louis Rabaut R000001 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
27398 | 27398 | William Norrell N000137 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
27344 | 27344 | Noah Mason M000224 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 12 | |||||||||||||
27287 | 27287 | Paul Kilday K000171 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
27276 | 27276 | Carey Kefauver K000044 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
27233 | 27233 | Clare Hoffman H000683 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
27192 | 27192 | Ivor Fenton F000075 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 13 | |||||||||||||
27185 | 27185 | Henry Dworshak D000585 | rep | ID | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
27142 | 27142 | Robert Chiperfield C000365 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 15 | |||||||||||||
27128 | 27128 | Overton Brooks B000884 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
27112 | 27112 | Frank Boykin B000725 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
27075 | 27075 | Herman Andersen A000179 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
27003 | 27003 | Richard Simpson S000436 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
26990 | 26990 | Edith Rogers R000392 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
26972 | 26972 | Edward Rees R000132 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
26960 | 26960 | Daniel Reed R000113 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 43 | |||||||||||||
26931 | 26931 | James Polk P000408 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
26924 | 26924 | James Oliver O000074 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
26871 | 26871 | William Hess H000550 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
26826 | 26826 | Carl Durham D000571 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
26751 | 26751 | Paul Brown B000940 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
26710 | 26710 | Graham Barden B000139 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
26695 | 26695 | Leo Allen A000138 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 13 | |||||||||||||
26681 | 26681 | Charles Wolverton W000683 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
26667 | 26667 | Alexander Wiley W000465 | sen | WI | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
26657 | 26657 | Richard Wigglesworth W000450 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 13 | |||||||||||||
26633 | 26633 | John Vorys V000119 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 12 | |||||||||||||
26622 | 26622 | Henry Talle T000028 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
26504 | 26504 | J. McGregor M000460 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 17 | |||||||||||||
26482 | 26482 | Karl Le Compte L000157 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
26436 | 26436 | Robert Kean K000029 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 12 | |||||||||||||
26426 | 26426 | Thomas Jenkins J000088 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
26380 | 26380 | Thomas Hennings H000502 | rep | MO | 1939-01-03 | 1940-12-31 | Democrat | 11 | |||||||||||||
26335 | 26335 | Noble Gregory G000447 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
26311 | 26311 | Herman Eberharter E000029 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 32 | |||||||||||||
26304 | 26304 | Martin Dies D000338 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
26290 | 26290 | John Dempsey D000228 | rep | NM | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
26255 | 26255 | Jere Cooper C000755 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
26240 | 26240 | William Cole C000617 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 37 | |||||||||||||
26228 | 26228 | Cliff Clevenger C000515 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
26215 | 26215 | Francis Case C000221 | rep | SD | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
26191 | 26191 | Usher Burdick B001079 | rep | ND | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
26168 | 26168 | August Andresen A000239 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
26140 | 26140 | Jesse Wolcott W000668 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
26119 | 26119 | Dewey Short S000377 | rep | MO | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
26107 | 26107 | James Richards R000214 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 5 |
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);