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)
start (date) >30 ✖
- 1939-01-03 495
- 1941-01-03 492
- 1943-01-06 487
- 1947-01-03 485
- 1945-01-03 484
- 1951-01-03 484
- 1959-01-07 484
- 1961-01-03 484
- 1937-01-05 483
- 1969-01-03 482
- 1981-01-05 482
- 1963-01-09 481
- 1989-01-03 481
- 1949-01-03 480
- 1957-01-03 480
- 1975-01-14 480
- 1935-01-03 479
- 1971-01-21 478
- 1977-01-04 478
- 1983-01-03 478
- 1991-01-03 478
- 1953-01-03 477
- 1965-01-04 477
- 1973-01-03 477
- 1979-01-15 477
- 1985-01-03 477
- 1987-01-06 477
- 1993-01-05 476
- 1997-01-07 475
- 2015-01-06 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21475 | 21475 | Hubert Peavey P000174 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
21476 | 21476 | Hubert Peavey P000174 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
21477 | 21477 | Hubert Peavey P000174 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
21478 | 21478 | Hubert Peavey P000174 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
21479 | 21479 | Hubert Peavey P000174 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
21480 | 21480 | Hubert Peavey P000174 | rep | WI | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
21481 | 21481 | James Pope P000430 | sen | ID | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
21482 | 21482 | Edward Pou P000474 | rep | NC | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
21483 | 21483 | Edward Pou P000474 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
21484 | 21484 | Edward Pou P000474 | rep | NC | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
21485 | 21485 | Edward Pou P000474 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
21486 | 21486 | Edward Pou P000474 | rep | NC | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
21487 | 21487 | Edward Pou P000474 | rep | NC | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
21488 | 21488 | Edward Pou P000474 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
21489 | 21489 | Edward Pou P000474 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
21490 | 21490 | Edward Pou P000474 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21491 | 21491 | Edward Pou P000474 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21492 | 21492 | Edward Pou P000474 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
21493 | 21493 | Edward Pou P000474 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21494 | 21494 | Edward Pou P000474 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
21495 | 21495 | Edward Pou P000474 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21496 | 21496 | Edward Pou P000474 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21497 | 21497 | Edward Pou P000474 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21498 | 21498 | Edward Pou P000474 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21499 | 21499 | Anning Prall P000495 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
21500 | 21500 | Anning Prall P000495 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 11 | |||||||||||||
21501 | 21501 | Anning Prall P000495 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 11 | |||||||||||||
21502 | 21502 | Anning Prall P000495 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
21503 | 21503 | Anning Prall P000495 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
21504 | 21504 | Anning Prall P000495 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
21505 | 21505 | Heartsill Ragon R000009 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21506 | 21506 | Heartsill Ragon R000009 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
21507 | 21507 | Heartsill Ragon R000009 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
21508 | 21508 | Heartsill Ragon R000009 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21509 | 21509 | Heartsill Ragon R000009 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
21510 | 21510 | Heartsill Ragon R000009 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21511 | 21511 | Henry Rainey R000014 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 20 | |||||||||||||
21512 | 21512 | Henry Rainey R000014 | rep | IL | 1905-12-04 | 1907-03-03 | Democrat | 20 | |||||||||||||
21513 | 21513 | Henry Rainey R000014 | rep | IL | 1907-12-02 | 1909-03-03 | Democrat | 20 | |||||||||||||
21514 | 21514 | Henry Rainey R000014 | rep | IL | 1909-03-15 | 1911-03-03 | Democrat | 20 | |||||||||||||
21515 | 21515 | Henry Rainey R000014 | rep | IL | 1911-04-04 | 1913-03-03 | Democrat | 20 | |||||||||||||
21516 | 21516 | Henry Rainey R000014 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
21517 | 21517 | Henry Rainey R000014 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 20 | |||||||||||||
21518 | 21518 | Henry Rainey R000014 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 20 | |||||||||||||
21519 | 21519 | Henry Rainey R000014 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 20 | |||||||||||||
21520 | 21520 | Henry Rainey R000014 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 20 | |||||||||||||
21521 | 21521 | Henry Rainey R000014 | rep | IL | 1925-12-07 | 1927-03-04 | Democrat | 20 | |||||||||||||
21522 | 21522 | Henry Rainey R000014 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 20 | |||||||||||||
21523 | 21523 | Henry Rainey R000014 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 20 | |||||||||||||
21524 | 21524 | Henry Rainey R000014 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 20 | |||||||||||||
21525 | 21525 | Henry Rainey R000014 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 20 | |||||||||||||
21526 | 21526 | Frank Reid R000145 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
21527 | 21527 | Frank Reid R000145 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
21528 | 21528 | Frank Reid R000145 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
21529 | 21529 | Frank Reid R000145 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
21530 | 21530 | Frank Reid R000145 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
21531 | 21531 | Frank Reid R000145 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 11 | |||||||||||||
21532 | 21532 | James Ruffin R000498 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21533 | 21533 | Ashton Shallenberger S000280 | rep | NE | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
21534 | 21534 | Ashton Shallenberger S000280 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
21535 | 21535 | Ashton Shallenberger S000280 | rep | NE | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
21536 | 21536 | Ashton Shallenberger S000280 | rep | NE | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21537 | 21537 | Ashton Shallenberger S000280 | rep | NE | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
21538 | 21538 | Ashton Shallenberger S000280 | rep | NE | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
21539 | 21539 | Ashton Shallenberger S000280 | rep | NE | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
21540 | 21540 | Ashton Shallenberger S000280 | rep | NE | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21541 | 21541 | Francis Shoemaker S000374 | rep | MN | 1933-03-09 | 1935-01-03 | Farmer-Labor | 0 | |||||||||||||
21542 | 21542 | James Simpson S000431 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
21543 | 21543 | James Sinclair S000442 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
21544 | 21544 | James Sinclair S000442 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
21545 | 21545 | James Sinclair S000442 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
21546 | 21546 | James Sinclair S000442 | rep | ND | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21547 | 21547 | James Sinclair S000442 | rep | ND | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21548 | 21548 | James Sinclair S000442 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21549 | 21549 | James Sinclair S000442 | rep | ND | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21550 | 21550 | James Sinclair S000442 | rep | ND | 1933-03-09 | 1935-01-03 | Republican | -1 | |||||||||||||
21551 | 21551 | Gale Stalker S000783 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 37 | |||||||||||||
21552 | 21552 | Gale Stalker S000783 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 37 | |||||||||||||
21553 | 21553 | Gale Stalker S000783 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 37 | |||||||||||||
21554 | 21554 | Gale Stalker S000783 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 37 | |||||||||||||
21555 | 21555 | Gale Stalker S000783 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 37 | |||||||||||||
21556 | 21556 | Gale Stalker S000783 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 37 | |||||||||||||
21557 | 21557 | Frederick Steiwer S000848 | sen | OR | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
21558 | 21558 | Frederick Steiwer S000848 | sen | OR | 1933-03-09 | 1939-01-03 | 3 | Republican | |||||||||||||
21559 | 21559 | Edward Stokes S000946 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21560 | 21560 | Edward Stokes S000946 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 6 | |||||||||||||
21561 | 21561 | Nathan Strong S001015 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 27 | |||||||||||||
21562 | 21562 | Nathan Strong S001015 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 27 | |||||||||||||
21563 | 21563 | Nathan Strong S001015 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 27 | |||||||||||||
21564 | 21564 | Nathan Strong S001015 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 27 | |||||||||||||
21565 | 21565 | Nathan Strong S001015 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 27 | |||||||||||||
21566 | 21566 | Nathan Strong S001015 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 27 | |||||||||||||
21567 | 21567 | Nathan Strong S001015 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 27 | |||||||||||||
21568 | 21568 | Nathan Strong S001015 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 27 | |||||||||||||
21569 | 21569 | Nathan Strong S001015 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 27 | |||||||||||||
21570 | 21570 | Sterling Strong S001019 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21571 | 21571 | Elmer Studley S001041 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21572 | 21572 | Fletcher Swank S001089 | rep | OK | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
21573 | 21573 | Fletcher Swank S001089 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21574 | 21574 | Fletcher Swank S001089 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 5 |
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);