legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows
This data as json, copyable, CSV (advanced)
end (date) >30 ✖
- 1945-01-03 493
- 1963-01-03 489
- 1947-01-03 488
- 1941-01-03 486
- 1949-01-03 486
- 1953-01-03 486
- 1955-01-03 485
- 1961-01-03 483
- 1971-01-03 483
- 1943-01-03 482
- 1951-01-03 482
- 1965-01-03 482
- 1983-01-03 481
- 1959-01-03 480
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- 1981-01-03 479
- 1987-01-03 478
- 1957-01-03 477
- 1973-01-03 477
- 1979-01-03 477
- 1985-01-03 477
- 2015-01-03 476
- 1989-01-03 475
- 1993-01-03 475
- 1969-01-03 474
- 1995-01-03 474
- 1991-01-03 473
- 1999-01-03 473
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22370 | 22370 | Theodore Peyser P000281 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
22371 | 22371 | Theodore Peyser P000281 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22372 | 22372 | Theodore Peyser P000281 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22373 | 22373 | Alfred Phillips P000305 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22374 | 22374 | James Quinn Q000017 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 31 | |||||||||||||
22375 | 22375 | James Quinn Q000017 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 31 | |||||||||||||
22376 | 22376 | Michael Reilly R000155 | rep | WI | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
22377 | 22377 | Michael Reilly R000155 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
22378 | 22378 | Michael Reilly R000155 | rep | WI | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
22379 | 22379 | Michael Reilly R000155 | rep | WI | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
22380 | 22380 | Michael Reilly R000155 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22381 | 22381 | Michael Reilly R000155 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22382 | 22382 | Michael Reilly R000155 | rep | WI | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22383 | 22383 | Hugh Rigney R000256 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
22384 | 22384 | Alphonse Roy R000483 | rep | NH | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22385 | 22385 | Morgan Sanders S000037 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
22386 | 22386 | Morgan Sanders S000037 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
22387 | 22387 | Morgan Sanders S000037 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
22388 | 22388 | Morgan Sanders S000037 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
22389 | 22389 | Morgan Sanders S000037 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22390 | 22390 | Morgan Sanders S000037 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22391 | 22391 | Morgan Sanders S000037 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22392 | 22392 | Morgan Sanders S000037 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22393 | 22393 | Morgan Sanders S000037 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22394 | 22394 | George Schneider S000137 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
22395 | 22395 | George Schneider S000137 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
22396 | 22396 | George Schneider S000137 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
22397 | 22397 | George Schneider S000137 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
22398 | 22398 | George Schneider S000137 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 9 | |||||||||||||
22399 | 22399 | George Schneider S000137 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 8 | |||||||||||||
22400 | 22400 | George Schneider S000137 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 8 | |||||||||||||
22401 | 22401 | Henry Schwartz S000157 | sen | WY | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
22402 | 22402 | Byron Scott S000165 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
22403 | 22403 | Byron Scott S000165 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
22404 | 22404 | Morris Sheppard S000337 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
22405 | 22405 | Morris Sheppard S000337 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
22406 | 22406 | Morris Sheppard S000337 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
22407 | 22407 | Morris Sheppard S000337 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
22408 | 22408 | Morris Sheppard S000337 | rep | TX | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
22409 | 22409 | Morris Sheppard S000337 | sen | TX | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
22410 | 22410 | Morris Sheppard S000337 | sen | TX | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22411 | 22411 | Morris Sheppard S000337 | sen | TX | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
22412 | 22412 | Morris Sheppard S000337 | sen | TX | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22413 | 22413 | Morris Sheppard S000337 | sen | TX | 1937-01-05 | 1941-12-31 | 2 | Democrat | |||||||||||||
22414 | 22414 | William Smathers S000506 | sen | NJ | 1937-04-15 | 1943-01-03 | 2 | Democrat | |||||||||||||
22415 | 22415 | Gomer Smith S000543 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22416 | 22416 | Bertrand Snell S000652 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 31 | |||||||||||||
22417 | 22417 | Bertrand Snell S000652 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 31 | |||||||||||||
22418 | 22418 | Bertrand Snell S000652 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 31 | |||||||||||||
22419 | 22419 | Bertrand Snell S000652 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 31 | |||||||||||||
22420 | 22420 | Bertrand Snell S000652 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 31 | |||||||||||||
22421 | 22421 | Bertrand Snell S000652 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 31 | |||||||||||||
22422 | 22422 | Bertrand Snell S000652 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 31 | |||||||||||||
22423 | 22423 | Bertrand Snell S000652 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 31 | |||||||||||||
22424 | 22424 | Bertrand Snell S000652 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 31 | |||||||||||||
22425 | 22425 | Bertrand Snell S000652 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 31 | |||||||||||||
22426 | 22426 | Bertrand Snell S000652 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 31 | |||||||||||||
22427 | 22427 | Bertrand Snell S000652 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 31 | |||||||||||||
22428 | 22428 | Michael Stack S000773 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22429 | 22429 | Michael Stack S000773 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22430 | 22430 | Henry Stubbs S001038 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
22431 | 22431 | Henry Stubbs S001038 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22432 | 22432 | Henry Stubbs S001038 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
22433 | 22433 | Guy Swope S001127 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
22434 | 22434 | John Taylor T000087 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22435 | 22435 | John Taylor T000087 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22436 | 22436 | John Taylor T000087 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22437 | 22437 | Henry Teigan T000112 | rep | MN | 1937-01-05 | 1939-01-03 | Farmer-Labor | 3 | |||||||||||||
22438 | 22438 | Chester Thompson T000197 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
22439 | 22439 | Chester Thompson T000197 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
22440 | 22440 | Chester Thompson T000197 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
22441 | 22441 | Lloyd Thurston T000257 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
22442 | 22442 | Lloyd Thurston T000257 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
22443 | 22443 | Lloyd Thurston T000257 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
22444 | 22444 | Lloyd Thurston T000257 | rep | IA | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
22445 | 22445 | Lloyd Thurston T000257 | rep | IA | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
22446 | 22446 | Lloyd Thurston T000257 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
22447 | 22447 | Lloyd Thurston T000257 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
22448 | 22448 | Frank Towey T000323 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
22449 | 22449 | Andrew Transue T000354 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22450 | 22450 | Frederick Vinson V000106 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
22451 | 22451 | Frederick Vinson V000106 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
22452 | 22452 | Frederick Vinson V000106 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
22453 | 22453 | Frederick Vinson V000106 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
22454 | 22454 | Frederick Vinson V000106 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22455 | 22455 | Frederick Vinson V000106 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22456 | 22456 | Frederick Vinson V000106 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22457 | 22457 | Otha Wearin W000221 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22458 | 22458 | Otha Wearin W000221 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22459 | 22459 | Otha Wearin W000221 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22460 | 22460 | James Wilcox W000455 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22461 | 22461 | James Wilcox W000455 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22462 | 22462 | James Wilcox W000455 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22463 | 22463 | Alexander Barry B000187 | sen | OR | 1938-01-01 | 1939-01-03 | 3 | Republican | |||||||||||||
22464 | 22464 | John Milton M000787 | sen | NJ | 1938-01-18 | 1939-01-03 | 1 | Democrat | appointment | ||||||||||||
22465 | 22465 | Gladys Pyle P000581 | sen | SD | 1938-01-01 | 1939-01-03 | 3 | Republican | |||||||||||||
22466 | 22466 | Alfred Reames R000099 | sen | OR | 1938-02-01 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
22467 | 22467 | Thomas Storke S000973 | sen | CA | 1938-11-09 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
22468 | 22468 | Alva Adams A000028 | sen | CO | 1923-12-03 | 1925-03-03 | 3 | Democrat | appointment | ||||||||||||
22469 | 22469 | Alva Adams A000028 | sen | CO | 1933-03-09 | 1939-01-03 | 3 | Democrat |
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);