legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
492 rows where "end" is on date 1939-01-03 sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22203 | 22203 | Paul Greever G000440 | rep | WY | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22979 | 22979 | Andrew Edmiston E000051 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23069 | 23069 | George Johnson J000132 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23677 | 23677 | Joseph Smith S000580 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
25340 | 25340 | John Kee K000039 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
25429 | 25429 | Robert Ramsay R000025 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
32243 | 32243 | Jennings Randolph R000046 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
21241 | 21241 | Francis Duffy D000518 | sen | WI | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22025 | 22025 | Thomas Amlie A000176 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 1 | |||||||||||||
22046 | 22046 | Gerald Boileau B000598 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 7 | |||||||||||||
22088 | 22088 | Raymond Cannon C000124 | rep | WI | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22354 | 22354 | Thomas O’Malley O000087 | rep | WI | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22382 | 22382 | Michael Reilly R000155 | rep | WI | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22400 | 22400 | George Schneider S000137 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 8 | |||||||||||||
23007 | 23007 | Bernard Gehrmann G000118 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 10 | |||||||||||||
23659 | 23659 | Harry Sauthoff S000079 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 2 | |||||||||||||
25715 | 25715 | Merlin Hull H000943 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 9 | |||||||||||||
27049 | 27049 | Gardner Withrow W000663 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 3 | |||||||||||||
22507 | 22507 | Homer Bone B000614 | sen | WA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22843 | 22843 | Monrad Wallgren W000088 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23039 | 23039 | Knute Hill H000600 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23103 | 23103 | Charles Leavy L000185 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23250 | 23250 | Martin Smith S000591 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23814 | 23814 | John Coffee C000584 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
31160 | 31160 | Warren Magnuson M000053 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22611 | 22611 | Ernest Gibson G000158 | sen | VT | 1933-11-21 | 1939-01-03 | 3 | Republican | appointment | ||||||||||||
24994 | 24994 | Charles Plumley P000395 | rep | VT | 1937-01-05 | 1939-01-03 | Republican | 0 | |||||||||||||
22208 | 22208 | Norman Hamilton H000116 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22328 | 22328 | Andrew Montague M000861 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
24085 | 24085 | Dave Satterfield S000069 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
24224 | 24224 | Clifton Woodrum W000720 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
24236 | 24236 | Thomas Burch B001069 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
24363 | 24363 | Patrick Drewry D000496 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
24384 | 24384 | John Flannagan F000191 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
24752 | 24752 | Schuyler Bland B000545 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
27489 | 27489 | Absalom Robertson R000317 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
28660 | 28660 | Howard Smith S000554 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
23152 | 23152 | Orrice Murdock M001082 | rep | UT | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
24065 | 24065 | James Robinson R000341 | rep | UT | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
24149 | 24149 | Elbert Thomas T000164 | sen | UT | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22074 | 22074 | James Buchanan B001006 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
22292 | 22292 | Fontaine Maverick M000263 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
22295 | 22295 | William McFarlane M000440 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
22393 | 22393 | Morgan Sanders S000037 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22601 | 22601 | Clyde Garrett G000080 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22647 | 22647 | John Jones J000236 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
23254 | 23254 | Charles South S000683 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
23567 | 23567 | Richard Kleberg K000257 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23647 | 23647 | Nat Patton P000142 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23918 | 23918 | Luther Johnson J000159 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23955 | 23955 | Fritz Lanham L000076 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
24125 | 24125 | Hatton Sumners S001072 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
24587 | 24587 | Joseph Mansfield M000112 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
24695 | 24695 | Robert Thomason T000189 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
24714 | 24714 | Milton West W000304 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
26303 | 26303 | Martin Dies D000338 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
27446 | 27446 | Samuel Rayburn R000082 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
28294 | 28294 | Lyndon Johnson J000160 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
28677 | 28677 | Albert Thomas T000156 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
31256 | 31256 | John Patman P000103 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
31622 | 31622 | George Mahon M000065 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
31718 | 31718 | William Poage P000398 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22026 | 22026 | Richard Atkinson A000332 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22036 | 22036 | George Berry B000417 | sen | TN | 1937-05-06 | 1939-01-03 | 2 | Democrat | appointment | ||||||||||||
22315 | 22315 | John Mitchell M000823 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22519 | 22519 | Walter Chandler C000296 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22730 | 22730 | Samuel McReynolds M000598 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22814 | 22814 | James Taylor T000083 | rep | TN | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
22820 | 22820 | Clarence Turner T000417 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23172 | 23172 | Herron Pearson P000165 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
26254 | 26254 | Jere Cooper C000755 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
27466 | 27466 | Brazilla Reece R000108 | rep | TN | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
22016 | 22016 | Herbert Hitchcock H000646 | sen | SD | 1936-12-29 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
22231 | 22231 | Fred Hildebrandt H000584 | rep | SD | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22465 | 22465 | Gladys Pyle P000581 | sen | SD | 1938-01-01 | 1939-01-03 | 3 | Republican | |||||||||||||
26214 | 26214 | Francis Case C000221 | rep | SD | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
22176 | 22176 | Allard Gasque G000092 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22177 | 22177 | Elizabeth Gasque G000093 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22290 | 22290 | Gabriel Mahon M000064 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22436 | 22436 | John Taylor T000087 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22721 | 22721 | Thomas McMillan M000572 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22789 | 22789 | Ellison Smith S000530 | sen | SC | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
23489 | 23489 | Hampton Fulmer F000417 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
26106 | 26106 | James Richards R000214 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22343 | 22343 | John O’Connell O000025 | rep | RI | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
26849 | 26849 | Aime Forand F000255 | rep | RI | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22634 | 22634 | Santiago Iglesias I000002 | rep | PR | 1937-01-05 | 1939-01-03 | Coalitionist | 0 | |||||||||||||
22363 | 22363 | Quintin Paredes P000050 | rep | PI | 1937-01-05 | 1939-01-03 | 0 | ||||||||||||||
23435 | 23435 | Joaquin Elizalde E000108 | rep | PI | 1937-01-05 | 1939-01-03 | 0 | ||||||||||||||
22105 | 22105 | Charles Crosby C000928 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 29 | |||||||||||||
22106 | 22106 | Peter De Muth D000225 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 30 | |||||||||||||
22115 | 22115 | Frank Dorsey D000438 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22116 | 22116 | Ira Drew D000494 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22127 | 22127 | Charles Eckert E000032 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 26 | |||||||||||||
22133 | 22133 | Henry Ellenbogen E000111 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 33 | |||||||||||||
22152 | 22152 | Benjamin Focht F000230 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 18 | |||||||||||||
22155 | 22155 | Oliver Frey F000382 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22179 | 22179 | James Gildea G000182 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
22181 | 22181 | Don Gingery G000224 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
22193 | 22193 | Joseph Gray G000399 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 27 |
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);