legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
56 rows where party = "Republican", state = "ME" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, url, phone, office, start (date), end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2392 | 2392 | John Chandler C000291 | sen | ME | 1820-01-01 | 1823-03-03 | 2 | Republican | |||||||||||||
7172 | 7172 | Amos Nourse N000162 | sen | ME | 1857-12-07 | 1857-12-31 | 1 | Republican | |||||||||||||
8070 | 8070 | Nathan Farwell F000038 | sen | ME | 1864-01-01 | 1865-03-03 | 2 | Republican | |||||||||||||
8115 | 8115 | William Fessenden F000099 | sen | ME | 1854-01-01 | 1859-03-03 | 2 | Republican | |||||||||||||
8116 | 8116 | William Fessenden F000099 | sen | ME | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
8117 | 8117 | William Fessenden F000099 | sen | ME | 1865-12-04 | 1869-12-31 | 2 | Republican | |||||||||||||
8978 | 8978 | Lot Morrill M000970 | sen | ME | 1861-07-04 | 1863-03-03 | 1 | Republican | |||||||||||||
8979 | 8979 | Lot Morrill M000970 | sen | ME | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8980 | 8980 | Lot Morrill M000970 | sen | ME | 1869-03-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8981 | 8981 | Lot Morrill M000970 | sen | ME | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
9721 | 9721 | James Blaine B000519 | sen | ME | 1876-07-10 | 1877-03-03 | 2 | Republican | |||||||||||||
9722 | 9722 | James Blaine B000519 | sen | ME | 1877-03-05 | 1881-03-05 | 2 | 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 | |||||||||||||
15107 | 15107 | William Frye F000398 | sen | ME | 1881-12-05 | 1883-03-03 | 2 | Republican | |||||||||||||
15108 | 15108 | William Frye F000398 | sen | ME | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
15109 | 15109 | William Frye F000398 | sen | ME | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
15110 | 15110 | William Frye F000398 | sen | ME | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15111 | 15111 | William Frye F000398 | sen | ME | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15112 | 15112 | William Frye F000398 | sen | ME | 1907-12-02 | 1911-12-31 | 2 | Republican | |||||||||||||
16316 | 16316 | Edwin Burleigh B001105 | sen | ME | 1913-04-07 | 1917-03-03 | 2 | Republican | |||||||||||||
18939 | 18939 | Bert Fernald F000084 | sen | ME | 1916-01-01 | 1919-03-03 | 2 | Republican | |||||||||||||
18940 | 18940 | Bert Fernald F000084 | sen | ME | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18941 | 18941 | Bert Fernald F000084 | sen | ME | 1925-12-07 | 1927-03-04 | 2 | Republican | |||||||||||||
19178 | 19178 | Arthur Gould G000340 | sen | ME | 1926-01-01 | 1931-03-03 | 2 | Republican | |||||||||||||
21797 | 21797 | Frederick Hale H000031 | sen | ME | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
21798 | 21798 | Frederick Hale H000031 | sen | ME | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
21799 | 21799 | Frederick Hale H000031 | sen | ME | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21800 | 21800 | Frederick Hale H000031 | sen | ME | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
23754 | 23754 | Wallace White W000396 | sen | ME | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
23755 | 23755 | Wallace White W000396 | sen | ME | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
23756 | 23756 | Wallace White W000396 | sen | ME | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24284 | 24284 | Ralph Brewster B000816 | sen | ME | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
24285 | 24285 | Ralph Brewster B000816 | sen | ME | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25777 | 25777 | Frederick Payne P000150 | sen | ME | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
29045 | 29045 | Margaret Smith S000590 | sen | ME | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
29046 | 29046 | Margaret Smith S000590 | sen | ME | 1955-01-05 | 1961-01-03 | 2 | Republican | |||||||||||||
29047 | 29047 | Margaret Smith S000590 | sen | ME | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
29048 | 29048 | Margaret Smith S000590 | sen | ME | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
34312 | 34312 | William Cohen C000598 | sen | ME | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
34313 | 34313 | William Cohen C000598 | sen | ME | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
34314 | 34314 | William Cohen C000598 | sen | ME | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
39079 | 39079 | Olympia Snowe S000663 | sen | ME | 1995-01-04 | 2001-01-03 | 1 | Republican | |||||||||||||
39080 | 39080 | Olympia Snowe S000663 | sen | ME | 2001-01-03 | 2007-01-03 | 1 | Republican | http://snowe.senate.gov/ | ||||||||||||
39081 | 39081 | Olympia Snowe S000663 | sen | ME | 2007-01-04 | 2013-01-03 | 1 | Republican | http://snowe.senate.gov/ | 154 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5344 | 202-224-1946 | http://www.snowe.senate.gov/public/index.cfm/contact?p=email | 154 Russell Senate Office Building | |||||||
41826 | 41826 | Susan Collins C001035 | sen | ME | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
41827 | 41827 | Susan Collins C001035 | sen | ME | 2003-01-07 | 2009-01-03 | 2 | Republican | http://collins.senate.gov | ||||||||||||
41828 | 41828 | Susan Collins C001035 | sen | ME | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.collins.senate.gov | 413 Dirksen Senate Office Building Washington DC 20510 | 202-224-2523 | 202-224-2693 | http://www.collins.senate.gov/public/index.cfm/email | 413 Dirksen Senate Office Building | senior | http://www.collins.senate.gov/public/?a=rss.feed | |||||
41829 | 41829 | Susan Collins C001035 | sen | ME | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.collins.senate.gov | 413 Dirksen Senate Office Building Washington DC 20510 | 202-224-2523 | 202-224-2693 | http://www.collins.senate.gov/contact | 413 Dirksen Senate Office Building | senior | http://www.collins.senate.gov/public/?a=rss.feed | |||||
41830 | 41830 | Susan Collins C001035 | sen | ME | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.collins.senate.gov | 413 Dirksen Senate Office Building Washington DC 20510 | 202-224-2523 | https://www.collins.senate.gov/contact | 413 Dirksen Senate Office Building | senior | http://www.collins.senate.gov/public/?a=rss.feed |
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);