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 ✖
- 1931-03-03 502
- 1919-03-03 501
- 1921-03-03 499
- 1933-03-03 499
- 1923-03-03 498
- 1941-01-03 498
- 1925-03-03 493
- 1945-01-03 493
- 1939-01-03 492
- 1929-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
- 1927-03-04 484
- 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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16507 | 16507 | Charles Patton P000136 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 21 | |||||||||||||
16508 | 16508 | Charles Patton P000136 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 21 | |||||||||||||
16509 | 16509 | Sereno Payne P000153 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 26 | |||||||||||||
16510 | 16510 | Sereno Payne P000153 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 27 | |||||||||||||
16511 | 16511 | Sereno Payne P000153 | rep | NY | 1889-12-02 | 1891-03-03 | Republican | 27 | |||||||||||||
16512 | 16512 | Sereno Payne P000153 | rep | NY | 1891-12-07 | 1893-03-03 | Republican | 27 | |||||||||||||
16513 | 16513 | Sereno Payne P000153 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 28 | |||||||||||||
16514 | 16514 | Sereno Payne P000153 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 28 | |||||||||||||
16515 | 16515 | Sereno Payne P000153 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 28 | |||||||||||||
16516 | 16516 | Sereno Payne P000153 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 28 | |||||||||||||
16517 | 16517 | Sereno Payne P000153 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 28 | |||||||||||||
16518 | 16518 | Sereno Payne P000153 | rep | NY | 1903-11-09 | 1905-03-03 | Republican | 31 | |||||||||||||
16519 | 16519 | Sereno Payne P000153 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 31 | |||||||||||||
16520 | 16520 | Sereno Payne P000153 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 31 | |||||||||||||
16521 | 16521 | Sereno Payne P000153 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 31 | |||||||||||||
16522 | 16522 | Sereno Payne P000153 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 31 | |||||||||||||
16523 | 16523 | Sereno Payne P000153 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 36 | |||||||||||||
16524 | 16524 | Irvin Pepper P000220 | rep | IA | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
16525 | 16525 | Irvin Pepper P000220 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16526 | 16526 | Andrew Peters P000251 | rep | MA | 1907-12-02 | 1909-03-03 | Democrat | 11 | |||||||||||||
16527 | 16527 | Andrew Peters P000251 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 11 | |||||||||||||
16528 | 16528 | Andrew Peters P000251 | rep | MA | 1911-04-04 | 1913-03-03 | Democrat | 11 | |||||||||||||
16529 | 16529 | Andrew Peters P000251 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
16530 | 16530 | John Peterson P000262 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16531 | 16531 | Frank Plumley P000396 | rep | VT | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
16532 | 16532 | Frank Plumley P000396 | rep | VT | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
16533 | 16533 | Frank Plumley P000396 | rep | VT | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
16534 | 16534 | James Post P000454 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
16535 | 16535 | James Post P000454 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
16536 | 16536 | Solomon Prouty P000551 | rep | IA | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
16537 | 16537 | Solomon Prouty P000551 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 7 | |||||||||||||
16538 | 16538 | Eugene Reed R000116 | rep | NH | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16539 | 16539 | Thomas Reilly R000156 | rep | CT | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
16540 | 16540 | Thomas Reilly R000156 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16541 | 16541 | William Richardson R000227 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
16542 | 16542 | William Richardson R000227 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
16543 | 16543 | William Richardson R000227 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
16544 | 16544 | William Richardson R000227 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
16545 | 16545 | William Richardson R000227 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
16546 | 16546 | William Richardson R000227 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
16547 | 16547 | William Richardson R000227 | rep | AL | 1911-04-04 | 1913-03-03 | Democrat | 8 | |||||||||||||
16548 | 16548 | William Richardson R000227 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16549 | 16549 | Seaborn Roddenbery R000370 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
16550 | 16550 | Seaborn Roddenbery R000370 | rep | GA | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
16551 | 16551 | Seaborn Roddenbery R000370 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16552 | 16552 | John Rothermel R000461 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 13 | |||||||||||||
16553 | 16553 | John Rothermel R000461 | rep | PA | 1909-03-15 | 1911-03-03 | Democrat | 13 | |||||||||||||
16554 | 16554 | John Rothermel R000461 | rep | PA | 1911-04-04 | 1913-03-03 | Democrat | 13 | |||||||||||||
16555 | 16555 | John Rothermel R000461 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16556 | 16556 | Arthur Rupley R000511 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
16557 | 16557 | Willard Saulsbury S000073 | sen | DE | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16558 | 16558 | Harry Seldomridge S000234 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16559 | 16559 | John Shafroth S000279 | rep | CO | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
16560 | 16560 | John Shafroth S000279 | rep | CO | 1897-03-15 | 1899-03-03 | Silver Republican | 1 | |||||||||||||
16561 | 16561 | John Shafroth S000279 | rep | CO | 1899-12-04 | 1901-03-03 | Silver Republican | 1 | |||||||||||||
16562 | 16562 | John Shafroth S000279 | rep | CO | 1901-12-02 | 1903-03-03 | Silver Republican | 1 | |||||||||||||
16563 | 16563 | John Shafroth S000279 | rep | CO | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16564 | 16564 | John Shafroth S000279 | sen | CO | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16565 | 16565 | William Sharp S000296 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 14 | |||||||||||||
16566 | 16566 | William Sharp S000296 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 14 | |||||||||||||
16567 | 16567 | William Sharp S000296 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
16568 | 16568 | Frank Smith S000535 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16569 | 16569 | Samuel Smith S000613 | rep | MI | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
16570 | 16570 | Samuel Smith S000613 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
16571 | 16571 | Samuel Smith S000613 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
16572 | 16572 | Samuel Smith S000613 | rep | MI | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
16573 | 16573 | Samuel Smith S000613 | rep | MI | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
16574 | 16574 | Samuel Smith S000613 | rep | MI | 1907-12-02 | 1909-03-03 | Republican | 6 | |||||||||||||
16575 | 16575 | Samuel Smith S000613 | rep | MI | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
16576 | 16576 | Samuel Smith S000613 | rep | MI | 1911-04-04 | 1913-03-03 | Republican | 6 | |||||||||||||
16577 | 16577 | Samuel Smith S000613 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 6 | |||||||||||||
16578 | 16578 | William Smith S000629 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
16579 | 16579 | William Smith S000629 | rep | MI | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
16580 | 16580 | William Smith S000629 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
16581 | 16581 | William Smith S000629 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
16582 | 16582 | William Smith S000629 | rep | MI | 1903-11-09 | 1905-03-03 | Republican | 5 | |||||||||||||
16583 | 16583 | William Smith S000629 | rep | MI | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
16584 | 16584 | William Smith S000629 | sen | MI | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
16585 | 16585 | William Smith S000629 | sen | MI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16586 | 16586 | Frederick Stevens S000878 | rep | MN | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
16587 | 16587 | Frederick Stevens S000878 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
16588 | 16588 | Frederick Stevens S000878 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 4 | |||||||||||||
16589 | 16589 | Frederick Stevens S000878 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
16590 | 16590 | Frederick Stevens S000878 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 4 | |||||||||||||
16591 | 16591 | Frederick Stevens S000878 | rep | MN | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
16592 | 16592 | Frederick Stevens S000878 | rep | MN | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
16593 | 16593 | Frederick Stevens S000878 | rep | MN | 1911-04-04 | 1913-03-03 | Republican | 4 | |||||||||||||
16594 | 16594 | Frederick Stevens S000878 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
16595 | 16595 | Raymond Stevens S000885 | rep | NH | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16596 | 16596 | Lawrence Stringer S001005 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16597 | 16597 | Timothy Sullivan S001061 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
16598 | 16598 | Timothy Sullivan S001061 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
16599 | 16599 | Timothy Sullivan S001061 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16600 | 16600 | Charles Talcott T000023 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 27 | |||||||||||||
16601 | 16601 | Charles Talcott T000023 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 33 | |||||||||||||
16602 | 16602 | Benjamin Taylor T000066 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 25 | |||||||||||||
16603 | 16603 | George Taylor T000078 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
16604 | 16604 | George Taylor T000078 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
16605 | 16605 | George Taylor T000078 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
16606 | 16606 | George Taylor T000078 | rep | AL | 1903-11-09 | 1905-03-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);