legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
30 rows where party = "Democrat", state = "CT" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, end, class, url, phone, fax, office, state_rank, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4352 | 4352 | Perry Smith S000600 | sen | CT | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5256 | 5256 | John Niles N000108 | sen | CT | 1835-12-07 | 1839-03-03 | 1 | Democrat | |||||||||||||
5257 | 5257 | John Niles N000108 | sen | CT | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
6478 | 6478 | Isaac Toucey T000319 | sen | CT | 1852-01-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
9501 | 9501 | James English E000185 | sen | CT | 1875-12-06 | 1877-03-03 | 3 | Democrat | |||||||||||||
9713 | 9713 | William Barnum B000166 | sen | CT | 1876-01-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
10706 | 10706 | William Eaton E000028 | sen | CT | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
21383 | 21383 | Augustine Lonergan L000409 | sen | CT | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
23111 | 23111 | Francis Maloney M000088 | sen | CT | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23112 | 23112 | Francis Maloney M000088 | sen | CT | 1941-01-03 | 1945-12-31 | 1 | Democrat | |||||||||||||
24739 | 24739 | William Benton B000399 | sen | CT | 1949-12-17 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
25384 | 25384 | Brien McMahon M000559 | sen | CT | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25385 | 25385 | Brien McMahon M000559 | sen | CT | 1951-01-03 | 1953-01-03 | 3 | Democrat | |||||||||||||
28416 | 28416 | Thomas Dodd D000390 | sen | CT | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28417 | 28417 | Thomas Dodd D000390 | sen | CT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
31298 | 31298 | Abraham Ribicoff R000191 | sen | CT | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
31299 | 31299 | Abraham Ribicoff R000191 | sen | CT | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31300 | 31300 | Abraham Ribicoff R000191 | sen | CT | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
37607 | 37607 | Christopher Dodd D000388 | sen | CT | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
37608 | 37608 | Christopher Dodd D000388 | sen | CT | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
37609 | 37609 | Christopher Dodd D000388 | sen | CT | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
37610 | 37610 | Christopher Dodd D000388 | sen | CT | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://dodd.senate.gov/ | ||||||||||||
37611 | 37611 | Christopher Dodd D000388 | sen | CT | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://dodd.senate.gov | ||||||||||||
39059 | 39059 | Joseph Lieberman L000304 | sen | CT | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
39060 | 39060 | Joseph Lieberman L000304 | sen | CT | 1995-01-04 | 2001-01-03 | 1 | Democrat | |||||||||||||
39061 | 39061 | Joseph Lieberman L000304 | sen | CT | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://lieberman.senate.gov/ | ||||||||||||
41981 | 41981 | Richard Blumenthal B001277 | sen | CT | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
41982 | 41982 | Richard Blumenthal B001277 | sen | CT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
42965 | 42965 | Christopher Murphy M001169 | sen | CT | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.murphy.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-4041 | 202-225-5933 | http://www.murphy.senate.gov/contact | 136 Hart Senate Office Building | junior | http://www.theday.com/article/20121216/nws12/312169935/1069/rss | |||||
42966 | 42966 | Christopher Murphy M001169 | sen | CT | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.murphy.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-4041 | https://www.murphy.senate.gov/contact | 136 Hart Senate Office Building | junior | http://www.theday.com/article/20121216/nws12/312169935/1069/rss |
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);