legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
754 rows where state = "CT" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, url, address, phone, fax, office, state_rank, rss_url, start (date), end (date)
party 12 ✖
- Republican 284
- Democrat 256
- Federalist 111
- Whig 34
- Adams 16
- Jackson 9
- Pro-Administration 5
- American 4
- Anti-Jacksonian 3
- Free Soil 2
- Anti Jacksonian 1
- Independent 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
239 | 239 | John Allen A000129 | rep | CT | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
6974 | 6974 | Samuel Arnold A000294 | rep | CT | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
22486 | 22486 | Albert Austin A000339 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
21107 | 21107 | Charles Bakewell B000079 | rep | CT | 1933-03-09 | 1935-01-03 | Republican | 0 | |||||||||||||
2771 | 2771 | John Baldwin B000090 | rep | CT | 1825-12-05 | 1827-03-03 | Adams | -1 | |||||||||||||
2772 | 2772 | John Baldwin B000090 | rep | CT | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
24231 | 24231 | Raymond Baldwin B000095 | sen | CT | 1946-12-27 | 1947-01-03 | 1 | Republican | |||||||||||||
24232 | 24232 | Raymond Baldwin B000095 | sen | CT | 1947-01-03 | 1949-12-16 | 1 | Republican | |||||||||||||
5606 | 5606 | Roger Baldwin B000096 | sen | CT | 1847-12-06 | 1851-03-03 | 1 | Whig | |||||||||||||
558 | 558 | Simeon Baldwin B000097 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
22487 | 22487 | Thomas Ball B000102 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
3595 | 3595 | Noyes Barber B000125 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3596 | 3596 | Noyes Barber B000125 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3597 | 3597 | Noyes Barber B000125 | rep | CT | 1825-12-05 | 1827-03-03 | Adams | -1 | |||||||||||||
3598 | 3598 | Noyes Barber B000125 | rep | CT | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
3599 | 3599 | Noyes Barber B000125 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3600 | 3600 | Noyes Barber B000125 | rep | CT | 1831-12-05 | 1833-03-03 | -1 | ||||||||||||||
3601 | 3601 | Noyes Barber B000125 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
9709 | 9709 | William Barnum B000166 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
9710 | 9710 | William Barnum B000166 | rep | CT | 1869-03-04 | 1871-03-03 | Democrat | 4 | |||||||||||||
9711 | 9711 | William Barnum B000166 | rep | CT | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9712 | 9712 | William Barnum B000166 | rep | CT | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9713 | 9713 | William Barnum B000166 | sen | CT | 1876-01-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
6502 | 6502 | Nathan Belcher B000322 | rep | CT | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
24739 | 24739 | William Benton B000399 | sen | CT | 1949-12-17 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
19212 | 19212 | Hiram Bingham B000470 | sen | CT | 1924-01-01 | 1927-03-04 | 3 | Republican | |||||||||||||
19213 | 19213 | Hiram Bingham B000470 | sen | CT | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
6983 | 6983 | William Bishop B000491 | rep | CT | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
2204 | 2204 | Elijah Boardman B000577 | sen | CT | 1821-12-03 | 1823-12-31 | 1 | Republican | |||||||||||||
4699 | 4699 | William Boardman B000578 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4700 | 4700 | William Boardman B000578 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5904 | 5904 | Walter Booth B000631 | rep | CT | 1849-12-03 | 1851-03-03 | Free Soil | 2 | |||||||||||||
26741 | 26741 | Chester Bowles B000699 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
323 | 323 | Jonathan Brace B000731 | rep | CT | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
324 | 324 | Jonathan Brace B000731 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
8089 | 8089 | Augustus Brandegee B000768 | rep | CT | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8090 | 8090 | Augustus Brandegee B000768 | rep | CT | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
18059 | 18059 | Frank Brandegee B000769 | rep | CT | 1902-11-04 | 1903-03-03 | Republican | 3 | |||||||||||||
18060 | 18060 | Frank Brandegee B000769 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
18061 | 18061 | Frank Brandegee B000769 | rep | CT | 1905-03-04 | 1905-05-10 | Republican | 3 | |||||||||||||
18062 | 18062 | Frank Brandegee B000769 | sen | CT | 1905-05-10 | 1909-03-03 | 3 | Republican | |||||||||||||
18063 | 18063 | Frank Brandegee B000769 | sen | CT | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
18064 | 18064 | Frank Brandegee B000769 | sen | CT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18065 | 18065 | Frank Brandegee B000769 | sen | CT | 1921-04-11 | 1924-10-14 | 3 | Republican | |||||||||||||
4713 | 4713 | John Brockway B000854 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4714 | 4714 | John Brockway B000854 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
10982 | 10982 | John Buck B001018 | rep | CT | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
10983 | 10983 | John Buck B001018 | rep | CT | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
8536 | 8536 | William Buckingham B001021 | sen | CT | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
14598 | 14598 | Morgan Bulkeley B001044 | sen | CT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
7681 | 7681 | Alfred Burnham B001123 | rep | CT | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7682 | 7682 | Alfred Burnham B001123 | rep | CT | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
2210 | 2210 | Daniel Burrows B001140 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
26199 | 26199 | Prescott Bush B001167 | sen | CT | 1952-01-01 | 1957-01-03 | 3 | Republican | |||||||||||||
26200 | 26200 | Prescott Bush B001167 | sen | CT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
5922 | 5922 | Thomas Butler B001191 | rep | CT | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
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 | |||||
5162 | 5162 | George Catlin C000251 | rep | CT | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
1490 | 1490 | Epaphroditus Champion C000288 | rep | CT | 1807-10-26 | 1809-03-03 | Federalist | -1 | |||||||||||||
1491 | 1491 | Epaphroditus Champion C000288 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1492 | 1492 | Epaphroditus Champion C000288 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1493 | 1493 | Epaphroditus Champion C000288 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1494 | 1494 | Epaphroditus Champion C000288 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
6256 | 6256 | Charles Chapman C000310 | rep | CT | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
22090 | 22090 | William Citron C000397 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
22091 | 22091 | William Citron C000397 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
7010 | 7010 | Ezra Clark C000429 | rep | CT | 1855-12-03 | 1857-03-03 | American | 1 | |||||||||||||
7011 | 7011 | Ezra Clark C000429 | rep | CT | 1857-12-07 | 1859-03-03 | Republican | 1 | |||||||||||||
6258 | 6258 | Chauncey Cleveland C000511 | rep | CT | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6259 | 6259 | Chauncey Cleveland C000511 | rep | CT | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
254 | 254 | Joshua Coit C000600 | rep | CT | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
255 | 255 | Joshua Coit C000600 | rep | CT | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
256 | 256 | Joshua Coit C000600 | rep | CT | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
23374 | 23374 | C. Compton C000661 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
32574 | 32574 | William Cotter C000799 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
32575 | 32575 | William Cotter C000799 | rep | CT | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
32576 | 32576 | William Cotter C000799 | rep | CT | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
32577 | 32577 | William Cotter C000799 | rep | CT | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
32578 | 32578 | William Cotter C000799 | rep | CT | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32579 | 32579 | William Cotter C000799 | rep | CT | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
26271 | 26271 | Albert Cretella C000905 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26272 | 26272 | Albert Cretella C000905 | rep | CT | 1955-01-05 | 1957-01-03 | Republican | 3 | |||||||||||||
26273 | 26273 | Albert Cretella C000905 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
42223 | 42223 | Joe Courtney C001069 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://courtney.house.gov | ||||||||||||
42224 | 42224 | Joe Courtney C001069 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://courtney.house.gov | ||||||||||||
42225 | 42225 | Joe Courtney C001069 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://courtney.house.gov | 215 Cannon HOB; Washington DC 20515-0702 | 202-225-2076 | 202-225-4977 | http://courtney.house.gov/email/ | 215 Cannon House Office Building | |||||||
42226 | 42226 | Joe Courtney C001069 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://courtney.house.gov | 2348 Rayburn HOB; Washington DC 20515-0702 | 202-225-2076 | 202-225-4977 | https://courtney.house.gov/email-joe1 | 2348 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||
42227 | 42227 | Joe Courtney C001069 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://courtney.house.gov | 2348 Rayburn HOB; Washington DC 20515-0702 | 202-225-2076 | 202-225-4977 | https://courtney.house.gov/email-joe1 | 2348 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||
42228 | 42228 | Joe Courtney C001069 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://courtney.house.gov | 2348 Rayburn House Office Building; Washington DC 20515-0702 | 202-225-2076 | 202-225-4977 | 2348 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | |||||||
42229 | 42229 | Joe Courtney C001069 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://courtney.house.gov | 2332 Rayburn House Office Building Washington DC 20515-0702 | 202-225-2076 | 2332 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||||
42230 | 42230 | Joe Courtney C001069 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://courtney.house.gov | 2449 Rayburn House Office Building Washington DC 20515-0702 | 202-225-2076 | 2449 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||||
29198 | 29198 | Emilio Daddario D000001 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29199 | 29199 | Emilio Daddario D000001 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29200 | 29200 | Emilio Daddario D000001 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29201 | 29201 | Emilio Daddario D000001 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29202 | 29202 | Emilio Daddario D000001 | rep | CT | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29203 | 29203 | Emilio Daddario D000001 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
1313 | 1313 | David Daggett D000002 | sen | CT | 1813-05-24 | 1819-03-03 | 3 | Federalist |
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);