legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
483 rows where "start" is on date 1937-01-05 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24722 | 24722 | Orville Zimmerman Z000009 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
24224 | 24224 | Clifton Woodrum W000720 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
25561 | 25561 | Roy Woodruff W000718 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
22838 | 22838 | Reuben Wood W000702 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
26680 | 26680 | Charles Wolverton W000683 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
24212 | 24212 | James Wolfenden W000678 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
26139 | 26139 | Jesse Wolcott W000668 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
27049 | 27049 | Gardner Withrow W000663 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 3 | |||||||||||||
23326 | 23326 | Clyde Williams W000494 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22462 | 22462 | James Wilcox W000455 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
26656 | 26656 | Richard Wigglesworth W000450 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 13 | |||||||||||||
25091 | 25091 | William Whittington W000430 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23755 | 23755 | Wallace White W000396 | sen | ME | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
22833 | 22833 | Dudley White W000364 | rep | OH | 1937-01-05 | 1939-01-03 | Republican | 13 | |||||||||||||
25079 | 25079 | Compton White W000361 | rep | ID | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23743 | 23743 | Benjamin Whelchel W000343 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
24714 | 24714 | Milton West W000304 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
23736 | 23736 | Elmer Wene W000294 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
25067 | 25067 | Richard Welch W000265 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
24195 | 24195 | Zebulon Weaver W000230 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22459 | 22459 | Otha Wearin W000221 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22830 | 22830 | Lindsay Warren W000166 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
28234 | 28234 | Francis Walter W000108 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
22843 | 22843 | Monrad Wallgren W000088 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
25052 | 25052 | James Wadsworth W000012 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 39 | |||||||||||||
24174 | 24174 | Horace Voorhis V000118 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
22456 | 22456 | Frederick Vinson V000106 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
28215 | 28215 | Carl Vinson V000105 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23728 | 23728 | Beverly Vincent V000100 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
24248 | 24248 | William Umstead U000005 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22820 | 22820 | Clarence Turner T000417 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23723 | 23723 | Allen Treadway T000358 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
22449 | 22449 | Andrew Transue T000354 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22448 | 22448 | Frank Towey T000323 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
24159 | 24159 | John Tolan T000295 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
25522 | 25522 | Charles Tobey T000289 | rep | NH | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
23307 | 23307 | George Tinkham T000283 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
22447 | 22447 | Lloyd Thurston T000257 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
22440 | 22440 | Chester Thompson T000197 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
24695 | 24695 | Robert Thomason T000189 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
25041 | 25041 | John Thomas T000175 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
28677 | 28677 | Albert Thomas T000156 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
24146 | 24146 | William Thom T000155 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
23291 | 23291 | David Terry T000133 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22437 | 22437 | Henry Teigan T000112 | rep | MN | 1937-01-05 | 1939-01-03 | Farmer-Labor | 3 | |||||||||||||
22436 | 22436 | John Taylor T000087 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22814 | 22814 | James Taylor T000083 | rep | TN | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
23284 | 23284 | Edward Taylor T000072 | rep | CO | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
24138 | 24138 | Malcolm Tarver T000045 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
27556 | 27556 | John Taber T000001 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 36 | |||||||||||||
22433 | 22433 | Guy Swope S001127 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
23267 | 23267 | Martin Sweeney S001102 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
23261 | 23261 | William Sutphin S001086 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
24125 | 24125 | Hatton Sumners S001072 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22802 | 22802 | Christopher Sullivan S001051 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
22432 | 22432 | Henry Stubbs S001038 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
25493 | 25493 | Karl Stefan S000845 | rep | NE | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
23698 | 23698 | Henry Steagall S000820 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23683 | 23683 | Joe Starnes S000816 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22429 | 22429 | Michael Stack S000773 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
27536 | 27536 | Brent Spence S000717 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
30694 | 30694 | John Sparkman S000701 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
23254 | 23254 | Charles South S000683 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
25033 | 25033 | Andrew Somers S000676 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
24100 | 24100 | John Snyder S000668 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 24 | |||||||||||||
22427 | 22427 | Bertrand Snell S000652 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 31 | |||||||||||||
23250 | 23250 | Martin Smith S000591 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23677 | 23677 | Joseph Smith S000580 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23245 | 23245 | John Smith S000572 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
28660 | 28660 | Howard Smith S000554 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22415 | 22415 | Gomer Smith S000543 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22783 | 22783 | Clyde Smith S000523 | rep | ME | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
22780 | 22780 | William Sirovich S000452 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
27002 | 27002 | Richard Simpson S000436 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 18 | |||||||||||||
26118 | 26118 | Dewey Short S000377 | rep | MO | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
22413 | 22413 | Morris Sheppard S000337 | sen | TX | 1937-01-05 | 1941-12-31 | 2 | Democrat | |||||||||||||
28139 | 28139 | Harry Sheppard S000335 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
23235 | 23235 | Joseph Shannon S000287 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23229 | 23229 | James Shanley S000285 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
25799 | 25799 | Paul Shafer S000277 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
22773 | 22773 | George Seger S000228 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
28645 | 28645 | Robert Secrest S000219 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
23335 | 23335 | James Scrugham S000196 | rep | NV | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22403 | 22403 | Byron Scott S000165 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
22401 | 22401 | Henry Schwartz S000157 | sen | WY | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23223 | 23223 | William Schulte S000145 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23669 | 23669 | Leonard Schuetz S000144 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22400 | 22400 | George Schneider S000137 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 8 | |||||||||||||
23218 | 23218 | Edwin Schaefer S000110 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
23659 | 23659 | Harry Sauthoff S000079 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 2 | |||||||||||||
24085 | 24085 | Dave Satterfield S000069 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22393 | 22393 | Morgan Sanders S000037 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
25013 | 25013 | George Sadowski S000011 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23210 | 23210 | Leon Sacks S000008 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
25469 | 25469 | Adolph Sabath S000001 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22756 | 22756 | Elmer Ryan R000555 | rep | MN | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23207 | 23207 | Albert Rutherford R000546 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 15 | |||||||||||||
29025 | 29025 | Richard Russell R000536 | sen | GA | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
22384 | 22384 | Alphonse Roy R000483 | rep | NH | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23203 | 23203 | Milton Romjue R000418 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 1 |
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);