legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1935-01-03 sorted by legislator_id descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22010 | 22010 | Marion Zioncheck Z000011 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
24721 | 24721 | Orville Zimmerman Z000009 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
28747 | 28747 | Stephen Young Y000053 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
24223 | 24223 | Clifton Woodrum W000720 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
25560 | 25560 | Roy Woodruff W000718 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
22837 | 22837 | Reuben Wood W000702 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
26679 | 26679 | Charles Wolverton W000683 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
24211 | 24211 | James Wolfenden W000678 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
26138 | 26138 | Jesse Wolcott W000668 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
27048 | 27048 | Gardner Withrow W000663 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 3 | |||||||||||||
22008 | 22008 | William Wilson W000622 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22007 | 22007 | Riley Wilson W000608 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23325 | 23325 | Clyde Williams W000494 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22461 | 22461 | James Wilcox W000455 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
26655 | 26655 | Richard Wigglesworth W000450 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 13 | |||||||||||||
25090 | 25090 | William Whittington W000430 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
25078 | 25078 | Compton White W000361 | rep | ID | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
23742 | 23742 | Benjamin Whelchel W000343 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
23320 | 23320 | Burton Wheeler W000330 | sen | MT | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
24713 | 24713 | Milton West W000304 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21996 | 21996 | Theodore Werner W000299 | rep | SD | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
25066 | 25066 | Richard Welch W000265 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
24194 | 24194 | Zebulon Weaver W000230 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
22458 | 22458 | Otha Wearin W000221 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22829 | 22829 | Lindsay Warren W000166 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
28233 | 28233 | Francis Walter W000108 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
23316 | 23316 | David Walsh W000097 | sen | MA | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22842 | 22842 | Monrad Wallgren W000088 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
25051 | 25051 | James Wadsworth W000012 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 39 | |||||||||||||
22455 | 22455 | Frederick Vinson V000106 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
28214 | 28214 | Carl Vinson V000105 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
24709 | 24709 | Arthur Vandenberg V000025 | sen | MI | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
21994 | 21994 | Hubert Utterback U000036 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21993 | 21993 | Mell Underwood U000012 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
24247 | 24247 | William Umstead U000005 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21986 | 21986 | Charles Turpin T000433 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 12 | |||||||||||||
22819 | 22819 | Clarence Turner T000417 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
24229 | 24229 | Harry Truman T000387 | sen | MO | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21982 | 21982 | Charles Truax T000386 | rep | OH | 1935-01-03 | 1935-08-09 | Democrat | 0 | |||||||||||||
23722 | 23722 | Allen Treadway T000358 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
21980 | 21980 | Park Trammell T000353 | sen | FL | 1935-01-03 | 1936-05-08 | 1 | Democrat | |||||||||||||
21976 | 21976 | John Townsend T000335 | sen | DE | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
21974 | 21974 | Richard Tonry T000311 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
24158 | 24158 | John Tolan T000295 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
25521 | 25521 | Charles Tobey T000289 | rep | NH | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
23306 | 23306 | George Tinkham T000283 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
22446 | 22446 | Lloyd Thurston T000257 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
22439 | 22439 | Chester Thompson T000197 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
24694 | 24694 | Robert Thomason T000189 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
21973 | 21973 | William Thomas T000187 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 29 | |||||||||||||
24145 | 24145 | William Thom T000155 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
23290 | 23290 | David Terry T000133 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22435 | 22435 | John Taylor T000087 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22813 | 22813 | James Taylor T000083 | rep | TN | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
23283 | 23283 | Edward Taylor T000072 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
24137 | 24137 | Malcolm Tarver T000045 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
27555 | 27555 | John Taber T000001 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 36 | |||||||||||||
23266 | 23266 | Martin Sweeney S001102 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
23260 | 23260 | William Sutphin S001086 | rep | NJ | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
24124 | 24124 | Hatton Sumners S001072 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22801 | 22801 | Christopher Sullivan S001051 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22431 | 22431 | Henry Stubbs S001038 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
21971 | 21971 | John Stewart S000915 | rep | DE | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
25492 | 25492 | Karl Stefan S000845 | rep | NE | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
23697 | 23697 | Henry Steagall S000820 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23682 | 23682 | Joe Starnes S000816 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22428 | 22428 | Michael Stack S000773 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
27535 | 27535 | Brent Spence S000717 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23253 | 23253 | Charles South S000683 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
25032 | 25032 | Andrew Somers S000676 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
24099 | 24099 | John Snyder S000668 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 24 | |||||||||||||
22426 | 22426 | Bertrand Snell S000652 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 31 | |||||||||||||
23249 | 23249 | Martin Smith S000591 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23676 | 23676 | Joseph Smith S000580 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
23244 | 23244 | John Smith S000572 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
28659 | 28659 | Howard Smith S000554 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
21970 | 21970 | Frederick Sisson S000455 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 33 | |||||||||||||
22779 | 22779 | William Sirovich S000452 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
26117 | 26117 | Dewey Short S000377 | rep | MO | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
23240 | 23240 | Henrik Shipstead S000369 | sen | MN | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
23234 | 23234 | Joseph Shannon S000287 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23228 | 23228 | James Shanley S000285 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22772 | 22772 | George Seger S000228 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
28644 | 28644 | Robert Secrest S000219 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21968 | 21968 | William Sears S000211 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | -1 | |||||||||||||
23334 | 23334 | James Scrugham S000196 | rep | NV | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
22402 | 22402 | Byron Scott S000165 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
21959 | 21959 | Lewis Schwellenbach S000160 | sen | WA | 1935-01-03 | 1940-12-16 | 1 | Democrat | |||||||||||||
23222 | 23222 | William Schulte S000145 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
23668 | 23668 | Leonard Schuetz S000144 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22399 | 22399 | George Schneider S000137 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 8 | |||||||||||||
23217 | 23217 | Edwin Schaefer S000110 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
23658 | 23658 | Harry Sauthoff S000079 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 2 | |||||||||||||
21958 | 21958 | John Sandlin S000043 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22392 | 22392 | Morgan Sanders S000037 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23214 | 23214 | Jared Sanders S000036 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
25012 | 25012 | George Sadowski S000011 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
25468 | 25468 | Adolph Sabath S000001 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22755 | 22755 | Elmer Ryan R000555 | rep | MN | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21950 | 21950 | Richard Russell R000537 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 9 |
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);