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 legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24723 | 24723 | Orville Zimmerman Z000009 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
23330 | 23330 | Oscar Youngdahl Y000059 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
24225 | 24225 | Clifton Woodrum W000720 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
25562 | 25562 | Roy Woodruff W000718 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
22839 | 22839 | Reuben Wood W000702 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
26681 | 26681 | Charles Wolverton W000683 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
24213 | 24213 | James Wolfenden W000678 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
26140 | 26140 | Jesse Wolcott W000668 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
24203 | 24203 | Thomas Winter W000645 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
22835 | 22835 | George Williams W000500 | rep | DE | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
23327 | 23327 | Clyde Williams W000494 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
25092 | 25092 | William Whittington W000430 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22834 | 22834 | Dudley White W000364 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 13 | |||||||||||||
25080 | 25080 | Compton White W000361 | rep | ID | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23744 | 23744 | Benjamin Whelchel W000343 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
23739 | 23739 | William Wheat W000327 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 19 | |||||||||||||
24715 | 24715 | Milton West W000304 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
25068 | 25068 | Richard Welch W000265 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
24196 | 24196 | Zebulon Weaver W000230 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
22832 | 22832 | Zadoc Weatherford W000222 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
22831 | 22831 | Lindsay Warren W000166 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23733 | 23733 | David Ward W000130 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
28235 | 28235 | Francis Walter W000108 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
24181 | 24181 | Robert Wagner W000021 | sen | NY | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
25053 | 25053 | James Wadsworth W000012 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 39 | |||||||||||||
23311 | 23311 | Albert Vreeland V000121 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 11 | |||||||||||||
26633 | 26633 | John Vorys V000119 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 12 | |||||||||||||
24175 | 24175 | Horace Voorhis V000118 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
28216 | 28216 | Carl Vinson V000105 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23729 | 23729 | Beverly Vincent V000100 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
27573 | 27573 | James Van Zandt V000069 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 23 | |||||||||||||
22823 | 22823 | Frederick Van Nuys V000050 | sen | IN | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24172 | 24172 | Millard Tydings T000446 | sen | MD | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
22821 | 22821 | Clarence Turner T000417 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23724 | 23724 | Allen Treadway T000358 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
24160 | 24160 | John Tolan T000295 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
25523 | 25523 | Charles Tobey T000289 | sen | NH | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
23308 | 23308 | George Tinkham T000283 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
24701 | 24701 | Harve Tibbott T000263 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 27 | |||||||||||||
22816 | 22816 | Jacob Thorkelson T000236 | rep | MT | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
24696 | 24696 | Robert Thomason T000189 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
24156 | 24156 | John Thomas T000177 | sen | OK | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
25042 | 25042 | John Thomas T000175 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
24150 | 24150 | Elbert Thomas T000164 | sen | UT | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
28678 | 28678 | Albert Thomas T000156 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23294 | 23294 | Lewis Thill T000153 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
23292 | 23292 | David Terry T000133 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23287 | 23287 | Rudolph Tenerowicz T000124 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22815 | 22815 | James Taylor T000083 | rep | TN | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23285 | 23285 | Edward Taylor T000072 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24139 | 24139 | Malcolm Tarver T000045 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
26622 | 26622 | Henry Talle T000028 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
25517 | 25517 | Robert Taft T000009 | sen | OH | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
27557 | 27557 | John Taber T000001 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 36 | |||||||||||||
22804 | 22804 | John Sweet S001108 | rep | NE | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23268 | 23268 | Martin Sweeney S001102 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
23262 | 23262 | William Sutphin S001086 | rep | NJ | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24126 | 24126 | Hatton Sumners S001072 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24109 | 24109 | Jessie Sumner S001071 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
22803 | 22803 | Christopher Sullivan S001051 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
23705 | 23705 | Arthur Stewart S000901 | sen | TN | 1939-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
25494 | 25494 | Karl Stefan S000845 | rep | NE | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
23702 | 23702 | Foster Stearns S000823 | rep | NH | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23699 | 23699 | Henry Steagall S000820 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23684 | 23684 | Joe Starnes S000816 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24678 | 24678 | Raymond Springer S000755 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
27537 | 27537 | Brent Spence S000717 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
30695 | 30695 | John Sparkman S000701 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23255 | 23255 | Charles South S000683 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
25034 | 25034 | Andrew Somers S000676 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
24101 | 24101 | John Snyder S000668 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 24 | |||||||||||||
22791 | 22791 | Thomas Smith S000620 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
23251 | 23251 | Martin Smith S000591 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
29040 | 29040 | Margaret Smith S000590 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23678 | 23678 | Joseph Smith S000580 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23246 | 23246 | John Smith S000572 | rep | CT | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
28661 | 28661 | Howard Smith S000554 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
25021 | 25021 | Frederick Smith S000536 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
22790 | 22790 | Ellison Smith S000530 | sen | SC | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
22784 | 22784 | Clyde Smith S000523 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22781 | 22781 | William Sirovich S000452 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
27003 | 27003 | Richard Simpson S000436 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
26119 | 26119 | Dewey Short S000377 | rep | MO | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
24092 | 24092 | John Sheridan S000342 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
28140 | 28140 | Harry Sheppard S000335 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
23236 | 23236 | Joseph Shannon S000287 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23230 | 23230 | James Shanley S000285 | rep | CT | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
25800 | 25800 | Paul Shafer S000277 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
22774 | 22774 | George Seger S000228 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
28646 | 28646 | Robert Secrest S000219 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
22765 | 22765 | James Seccombe S000218 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
23336 | 23336 | James Scrugham S000196 | rep | NV | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
23226 | 23226 | Pius Schwert S000162 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 42 | |||||||||||||
23224 | 23224 | William Schulte S000145 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23670 | 23670 | Leonard Schuetz S000144 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23664 | 23664 | Andrew Schiffler S000126 | rep | WV | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
22764 | 22764 | John Schafer S000111 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
23219 | 23219 | Edwin Schaefer S000110 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 22 |
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);