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 ✖
- 1941-01-03 498
- 1933-03-03 493
- 1945-01-03 493
- 1939-01-03 492
- 1931-03-03 489
- 1963-01-03 489
- 1943-01-03 488
- 1947-01-03 488
- 1935-01-03 486
- 1949-01-03 486
- 1953-01-03 486
- 1937-01-03 485
- 1955-01-03 485
- 1961-01-03 483
- 1971-01-03 483
- 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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19384 | 19384 | Edward King K000200 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 15 | |||||||||||||
19385 | 19385 | Ladislas Lazaro L000153 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
19386 | 19386 | Ladislas Lazaro L000153 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19387 | 19387 | Ladislas Lazaro L000153 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19388 | 19388 | Ladislas Lazaro L000153 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19389 | 19389 | Ladislas Lazaro L000153 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
19390 | 19390 | Ladislas Lazaro L000153 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19391 | 19391 | Ladislas Lazaro L000153 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
19392 | 19392 | Ladislas Lazaro L000153 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | -1 | |||||||||||||
19393 | 19393 | Bill Lowrey L000484 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19394 | 19394 | Bill Lowrey L000484 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19395 | 19395 | Bill Lowrey L000484 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19396 | 19396 | Bill Lowrey L000484 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19397 | 19397 | Homer Lyon L000543 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
19398 | 19398 | Homer Lyon L000543 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19399 | 19399 | Homer Lyon L000543 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
19400 | 19400 | Homer Lyon L000543 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
19401 | 19401 | Clarence MacGregor M000009 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 41 | |||||||||||||
19402 | 19402 | Clarence MacGregor M000009 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 41 | |||||||||||||
19403 | 19403 | Clarence MacGregor M000009 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 41 | |||||||||||||
19404 | 19404 | Clarence MacGregor M000009 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 41 | |||||||||||||
19405 | 19405 | Clarence MacGregor M000009 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 41 | |||||||||||||
19406 | 19406 | Martin Madden M000038 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
19407 | 19407 | Martin Madden M000038 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
19408 | 19408 | Martin Madden M000038 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
19409 | 19409 | Martin Madden M000038 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
19410 | 19410 | Martin Madden M000038 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
19411 | 19411 | Martin Madden M000038 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
19412 | 19412 | Martin Madden M000038 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19413 | 19413 | Martin Madden M000038 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19414 | 19414 | Martin Madden M000038 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19415 | 19415 | Martin Madden M000038 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19416 | 19416 | Martin Madden M000038 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19417 | 19417 | Martin Madden M000038 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19418 | 19418 | Walter Magee M000049 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 35 | |||||||||||||
19419 | 19419 | Walter Magee M000049 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 35 | |||||||||||||
19420 | 19420 | Walter Magee M000049 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 35 | |||||||||||||
19421 | 19421 | Walter Magee M000049 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 35 | |||||||||||||
19422 | 19422 | Walter Magee M000049 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 35 | |||||||||||||
19423 | 19423 | Walter Magee M000049 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 35 | |||||||||||||
19424 | 19424 | Walter Magee M000049 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19425 | 19425 | Louis Monast M000850 | rep | RI | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19426 | 19426 | Paul Moore M000912 | rep | NJ | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
19427 | 19427 | Henry Moorman M000931 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
19428 | 19428 | John Morin M000961 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
19429 | 19429 | John Morin M000961 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 31 | |||||||||||||
19430 | 19430 | John Morin M000961 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 31 | |||||||||||||
19431 | 19431 | John Morin M000961 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 31 | |||||||||||||
19432 | 19432 | John Morin M000961 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 31 | |||||||||||||
19433 | 19433 | John Morin M000961 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 34 | |||||||||||||
19434 | 19434 | John Morin M000961 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 34 | |||||||||||||
19435 | 19435 | John Morin M000961 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 34 | |||||||||||||
19436 | 19436 | John Morrow M001004 | rep | NM | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19437 | 19437 | John Morrow M001004 | rep | NM | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
19438 | 19438 | John Morrow M001004 | rep | NM | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19439 | 19439 | George Moses M001028 | sen | NH | 1918-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
19440 | 19440 | George Moses M001028 | sen | NH | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19441 | 19441 | George Moses M001028 | sen | NH | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19442 | 19442 | William O’Brien O000018 | rep | WV | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19443 | 19443 | Tasker Oddie O000035 | sen | NV | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19444 | 19444 | Tasker Oddie O000035 | sen | NV | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19445 | 19445 | William Oldfield O000062 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
19446 | 19446 | William Oldfield O000062 | rep | AR | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
19447 | 19447 | William Oldfield O000062 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19448 | 19448 | William Oldfield O000062 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19449 | 19449 | William Oldfield O000062 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19450 | 19450 | William Oldfield O000062 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19451 | 19451 | William Oldfield O000062 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19452 | 19452 | William Oldfield O000062 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19453 | 19453 | William Oldfield O000062 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19454 | 19454 | William Oldfield O000062 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19455 | 19455 | Lee Overman O000140 | sen | NC | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
19456 | 19456 | Lee Overman O000140 | sen | NC | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
19457 | 19457 | Lee Overman O000140 | sen | NC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
19458 | 19458 | Lee Overman O000140 | sen | NC | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19459 | 19459 | Lee Overman O000140 | sen | NC | 1927-12-05 | 1930-12-12 | 3 | Democrat | |||||||||||||
19460 | 19460 | Cyrus Palmer P000037 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 13 | |||||||||||||
19461 | 19461 | George Peery P000186 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
19462 | 19462 | George Peery P000186 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
19463 | 19463 | George Peery P000186 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
19464 | 19464 | Henry Rathbone R000068 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | -1 | |||||||||||||
19465 | 19465 | Henry Rathbone R000068 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | -1 | |||||||||||||
19466 | 19466 | Henry Rathbone R000068 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19467 | 19467 | James Reed R000119 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19468 | 19468 | James Reed R000119 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
19469 | 19469 | James Reed R000119 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
19470 | 19470 | Thomas Rubey R000491 | rep | MO | 1911-04-04 | 1913-03-03 | Democrat | 16 | |||||||||||||
19471 | 19471 | Thomas Rubey R000491 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
19472 | 19472 | Thomas Rubey R000491 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
19473 | 19473 | Thomas Rubey R000491 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 16 | |||||||||||||
19474 | 19474 | Thomas Rubey R000491 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
19475 | 19475 | Thomas Rubey R000491 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
19476 | 19476 | Thomas Rubey R000491 | rep | MO | 1925-12-07 | 1927-03-04 | Democrat | 16 | |||||||||||||
19477 | 19477 | Thomas Rubey R000491 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 16 | |||||||||||||
19478 | 19478 | Samuel Shortridge S000380 | sen | CA | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19479 | 19479 | Samuel Shortridge S000380 | sen | CA | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19480 | 19480 | Nicholas Sinnott S000450 | rep | OR | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
19481 | 19481 | Nicholas Sinnott S000450 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19482 | 19482 | Nicholas Sinnott S000450 | rep | OR | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
19483 | 19483 | Nicholas Sinnott S000450 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 2 |
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);