legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,710 rows where party = "Republican" and type = "sen" sorted by class
This data as json, copyable, CSV (advanced)
state >30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9518 | 9518 | Hannibal Hamlin H000121 | sen | ME | 1857-12-07 | 1861-12-31 | 1 | Republican | |||||||||||||
9519 | 9519 | Hannibal Hamlin H000121 | sen | ME | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
9520 | 9520 | Hannibal Hamlin H000121 | sen | ME | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
9633 | 9633 | William Sharon S000292 | sen | NV | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10000 | 10000 | Henry Baldwin B000089 | sen | MI | 1879-03-18 | 1881-03-03 | 1 | Republican | |||||||||||||
10025 | 10025 | Matthew Carpenter C000171 | sen | WI | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
10027 | 10027 | Zachariah Chandler C000299 | sen | MI | 1857-12-07 | 1863-03-03 | 1 | Republican | |||||||||||||
10028 | 10028 | Zachariah Chandler C000299 | sen | MI | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
10029 | 10029 | Zachariah Chandler C000299 | sen | MI | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
10030 | 10030 | Zachariah Chandler C000299 | sen | MI | 1879-03-18 | 1879-12-31 | 1 | Republican | |||||||||||||
10279 | 10279 | Angus Cameron C000064 | sen | WI | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10305 | 10305 | Omar Conger C000678 | sen | MI | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10441 | 10441 | William Mahone M000067 | sen | VA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10462 | 10462 | Samuel McMillan M000570 | sen | MN | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10463 | 10463 | Samuel McMillan M000570 | sen | MN | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10464 | 10464 | John Miller M000740 | sen | CA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10466 | 10466 | Warner Miller M000760 | sen | NY | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10469 | 10469 | John Mitchell M000819 | sen | PA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10583 | 10583 | Charles Van Wyck V000067 | sen | NE | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11282 | 11282 | Abram Williams W000486 | sen | CA | 1886-01-01 | 1887-03-03 | 1 | Republican | |||||||||||||
11345 | 11345 | Henry Dawes D000148 | sen | MA | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
11346 | 11346 | Henry Dawes D000148 | sen | MA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11347 | 11347 | Henry Dawes D000148 | sen | MA | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
11358 | 11358 | George Edmunds E000056 | sen | VT | 1866-01-01 | 1869-03-03 | 1 | Republican | |||||||||||||
11359 | 11359 | George Edmunds E000056 | sen | VT | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
11360 | 11360 | George Edmunds E000056 | sen | VT | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
11361 | 11361 | George Edmunds E000056 | sen | VT | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11362 | 11362 | George Edmunds E000056 | sen | VT | 1887-12-05 | 1891-12-31 | 1 | Republican | |||||||||||||
11401 | 11401 | Frank Hiscock H000643 | sen | NY | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
11464 | 11464 | Algernon Paddock P000010 | sen | NE | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
11465 | 11465 | Algernon Paddock P000010 | sen | NE | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
11503 | 11503 | Philetus Sawyer S000091 | sen | WI | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11504 | 11504 | Philetus Sawyer S000091 | sen | WI | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
11554 | 11554 | Benjamin Harrison H000263 | sen | IN | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11562 | 11562 | John Allen A000130 | sen | WA | 1889-11-19 | 1893-03-03 | 1 | Republican | |||||||||||||
11656 | 11656 | Lyman Casey C000227 | sen | ND | 1889-12-02 | 1893-03-03 | 1 | Republican | |||||||||||||
12065 | 12065 | Wilbur Sanders S000039 | sen | MT | 1890-01-01 | 1893-03-03 | 1 | Republican | |||||||||||||
12156 | 12156 | Charles Felton F000068 | sen | CA | 1891-12-07 | 1893-03-03 | 1 | Republican | |||||||||||||
12782 | 12782 | John Sherman S000346 | sen | OH | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
12783 | 12783 | John Sherman S000346 | sen | OH | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
12784 | 12784 | John Sherman S000346 | sen | OH | 1893-08-07 | 1897-12-31 | 1 | Republican | |||||||||||||
12808 | 12808 | Francis Stockbridge S000932 | sen | MI | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
12809 | 12809 | Francis Stockbridge S000932 | sen | MI | 1893-08-07 | 1895-03-03 | 1 | Republican | |||||||||||||
12884 | 12884 | John Patton P000141 | sen | MI | 1894-01-01 | 1895-12-31 | 1 | Republican | |||||||||||||
13157 | 13157 | William Sewell S000262 | sen | NJ | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
13216 | 13216 | John Wilson W000602 | sen | WA | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
13637 | 13637 | Cushman Davis D000095 | sen | MN | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
13638 | 13638 | Cushman Davis D000095 | sen | MN | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
13639 | 13639 | Cushman Davis D000095 | sen | MN | 1899-12-04 | 1901-03-03 | 1 | Republican | |||||||||||||
13667 | 13667 | Addison Foster F000298 | sen | WA | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13683 | 13683 | Marcus Hanna H000163 | sen | OH | 1897-03-15 | 1899-03-03 | 1 | Republican | |||||||||||||
13684 | 13684 | Marcus Hanna H000163 | sen | OH | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13702 | 13702 | Joseph Hawley H000377 | sen | CT | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
13703 | 13703 | Joseph Hawley H000377 | sen | CT | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
13704 | 13704 | Joseph Hawley H000377 | sen | CT | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
13705 | 13705 | Joseph Hawley H000377 | sen | CT | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13708 | 13708 | Monroe Hayward H000409 | sen | NE | 1899-12-04 | 1899-12-31 | 1 | Republican | |||||||||||||
13740 | 13740 | Louis McComas M000351 | sen | MD | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13769 | 13769 | Joseph Quarles Q000003 | sen | WI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13801 | 13801 | William Stewart S000922 | sen | NV | 1864-01-01 | 1869-03-03 | 1 | Republican | |||||||||||||
13802 | 13802 | William Stewart S000922 | sen | NV | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
13803 | 13803 | William Stewart S000922 | sen | NV | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
13805 | 13805 | William Stewart S000922 | sen | NV | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13842 | 13842 | Thomas Bard B000138 | sen | CA | 1900-01-01 | 1905-03-03 | 1 | Republican | |||||||||||||
13935 | 13935 | Charles Dietrich D000341 | sen | NE | 1901-12-02 | 1905-03-03 | 1 | Republican | |||||||||||||
14031 | 14031 | Thomas Kearns K000034 | sen | UT | 1901-12-02 | 1905-03-03 | 1 | Republican | |||||||||||||
14126 | 14126 | Matthew Quay Q000006 | sen | PA | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
14127 | 14127 | Matthew Quay Q000006 | sen | PA | 1893-03-04 | 1899-03-03 | 1 | Republican | |||||||||||||
14128 | 14128 | Matthew Quay Q000006 | sen | PA | 1901-01-16 | 1904-05-28 | 1 | Republican | |||||||||||||
14440 | 14440 | Thomas Platt P000383 | sen | NY | 1881-12-05 | 1881-12-31 | 1 | Republican | |||||||||||||
14544 | 14544 | Charles Dick D000302 | sen | OH | 1904-03-24 | 1905-03-03 | 1 | Republican | |||||||||||||
14545 | 14545 | Charles Dick D000302 | sen | OH | 1905-03-05 | 1911-03-03 | 1 | Republican | |||||||||||||
14557 | 14557 | Nelson Aldrich A000083 | sen | RI | 1881-10-05 | 1887-03-03 | 1 | Republican | |||||||||||||
14558 | 14558 | Nelson Aldrich A000083 | sen | RI | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
14559 | 14559 | Nelson Aldrich A000083 | sen | RI | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
14560 | 14560 | Nelson Aldrich A000083 | sen | RI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14561 | 14561 | Nelson Aldrich A000083 | sen | RI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14573 | 14573 | Albert Beveridge B000429 | sen | IN | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14574 | 14574 | Albert Beveridge B000429 | sen | IN | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14598 | 14598 | Morgan Bulkeley B001044 | sen | CT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14602 | 14602 | Elmer Burkett B001103 | sen | NE | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14611 | 14611 | Julius Burrows B001142 | sen | MI | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
14612 | 14612 | Julius Burrows B001142 | sen | MI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14613 | 14613 | Julius Burrows B001142 | sen | MI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14618 | 14618 | Thomas Carter C000200 | sen | MT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14641 | 14641 | Chauncey Depew D000264 | sen | NY | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14642 | 14642 | Chauncey Depew D000264 | sen | NY | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14662 | 14662 | Frank Flint F000207 | sen | CA | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14690 | 14690 | Eugene Hale H000029 | sen | ME | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
14691 | 14691 | Eugene Hale H000029 | sen | ME | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
14692 | 14692 | Eugene Hale H000029 | sen | ME | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
14693 | 14693 | Eugene Hale H000029 | sen | ME | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14694 | 14694 | Eugene Hale H000029 | sen | ME | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14737 | 14737 | John Kean K000028 | sen | NJ | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14738 | 14738 | John Kean K000028 | sen | NJ | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14862 | 14862 | Samuel Piles P000351 | sen | WA | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14865 | 14865 | Redfield Proctor P000547 | sen | VT | 1891-12-07 | 1893-03-03 | 1 | Republican | |||||||||||||
14866 | 14866 | Redfield Proctor P000547 | sen | VT | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
14867 | 14867 | Redfield Proctor P000547 | sen | VT | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14868 | 14868 | Redfield Proctor P000547 | sen | VT | 1905-12-04 | 1909-03-03 | 1 | Republican |
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);