legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
380 rows where state = "VT"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, start, end, class, district, url, address, fax, contact_form, office, state_rank, start (date), end (date)
party 16 ✖
- Republican 225
- Whig 49
- Democrat 25
- Federalist 25
- Adams 12
- Independent 12
- Anti Masonic 8
- Ind. Republican-Democrat 4
- Democratic Republican 2
- Anti Jacksonian 1
- Anti-Administration 1
- Anti-Jacksonian 1
- Free Soil 1
- Ind. Republican 1
- Jackson 1
- National Greenbacker 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48 | 48 | Moses Robinson R000350 | sen | VT | 1791-10-24 | 1796-10-15 | 1 | Anti-Administration | |||||||||||||
115 | 115 | Nathaniel Niles N000109 | rep | VT | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
116 | 116 | Nathaniel Niles N000109 | rep | VT | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
152 | 152 | Daniel Buck B001014 | rep | VT | 1795-12-07 | 1797-03-03 | Federalist | 2 | |||||||||||||
200 | 200 | Elijah Paine P000026 | sen | VT | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
252 | 252 | Nathaniel Chipman C000369 | sen | VT | 1797-05-15 | 1803-03-03 | 1 | Federalist | |||||||||||||
505 | 505 | Lewis Morris M000983 | rep | VT | 1797-05-15 | 1799-03-03 | Federalist | 2 | |||||||||||||
506 | 506 | Lewis Morris M000983 | rep | VT | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
507 | 507 | Lewis Morris M000983 | rep | VT | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
613 | 613 | Israel Smith S000557 | rep | VT | 1791-10-24 | 1793-03-03 | Democratic Republican | 1 | |||||||||||||
614 | 614 | Israel Smith S000557 | rep | VT | 1793-12-02 | 1795-03-03 | Democratic Republican | 1 | |||||||||||||
615 | 615 | Israel Smith S000557 | rep | VT | 1795-12-07 | 1797-03-03 | Republican | 1 | |||||||||||||
616 | 616 | Israel Smith S000557 | rep | VT | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
617 | 617 | Israel Smith S000557 | sen | VT | 1803-10-17 | 1807-12-31 | 1 | Republican | |||||||||||||
738 | 738 | Gideon Olin O000067 | rep | VT | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
739 | 739 | Gideon Olin O000067 | rep | VT | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
809 | 809 | Stephen Bradley B000745 | sen | VT | 1791-10-24 | 1795-03-03 | 3 | ||||||||||||||
810 | 810 | Stephen Bradley B000745 | sen | VT | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
811 | 811 | Stephen Bradley B000745 | sen | VT | 1807-10-26 | 1813-03-03 | 3 | Republican | |||||||||||||
832 | 832 | James Elliott E000122 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
833 | 833 | James Elliott E000122 | rep | VT | 1805-12-02 | 1807-03-03 | Federalist | 2 | |||||||||||||
834 | 834 | James Elliott E000122 | rep | VT | 1807-10-26 | 1809-03-03 | Federalist | 2 | |||||||||||||
930 | 930 | James Witherell W000657 | rep | VT | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
959 | 959 | William Chamberlain C000280 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
960 | 960 | William Chamberlain C000280 | rep | VT | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
998 | 998 | Jonathan Hubbard H000886 | rep | VT | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
1022 | 1022 | Matthew Lyon L000545 | rep | VT | 1797-05-15 | 1799-03-03 | Republican | 1 | |||||||||||||
1023 | 1023 | Matthew Lyon L000545 | rep | VT | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
1055 | 1055 | Jonathan Robinson R000346 | sen | VT | 1807-10-26 | 1809-03-03 | 1 | Republican | |||||||||||||
1056 | 1056 | Jonathan Robinson R000346 | sen | VT | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1129 | 1129 | Martin Chittenden C000372 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 4 | |||||||||||||
1130 | 1130 | Martin Chittenden C000372 | rep | VT | 1805-12-02 | 1807-03-03 | Federalist | 4 | |||||||||||||
1131 | 1131 | Martin Chittenden C000372 | rep | VT | 1807-10-26 | 1809-03-03 | Federalist | 4 | |||||||||||||
1132 | 1132 | Martin Chittenden C000372 | rep | VT | 1809-05-22 | 1811-03-03 | Federalist | 4 | |||||||||||||
1133 | 1133 | Martin Chittenden C000372 | rep | VT | 1811-11-04 | 1813-03-03 | Federalist | 4 | |||||||||||||
1222 | 1222 | Samuel Shaw S000310 | rep | VT | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
1223 | 1223 | Samuel Shaw S000310 | rep | VT | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1224 | 1224 | Samuel Shaw S000310 | rep | VT | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
1305 | 1305 | Ezra Butler B001176 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
1403 | 1403 | Richard Skinner S000469 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
1497 | 1497 | Daniel Chipman C000366 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1626 | 1626 | Luther Jewett J000107 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1635 | 1635 | Chauncey Langdon L000066 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1657 | 1657 | Asa Lyon L000539 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1658 | 1658 | Charles Marsh M000146 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1683 | 1683 | John Noyes N000164 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1753 | 1753 | Isaac Tichenor T000264 | sen | VT | 1796-01-01 | 1797-03-03 | 1 | Federalist | |||||||||||||
1754 | 1754 | Isaac Tichenor T000264 | sen | VT | 1815-12-04 | 1821-03-03 | 1 | Federalist | |||||||||||||
1793 | 1793 | Heman Allen A000122 | rep | VT | 1817-12-01 | 1819-03-03 | Republican | 0 | |||||||||||||
1836 | 1836 | James Fisk F000154 | rep | VT | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1837 | 1837 | James Fisk F000154 | rep | VT | 1807-10-26 | 1809-03-03 | Republican | 3 | |||||||||||||
1838 | 1838 | James Fisk F000154 | rep | VT | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1839 | 1839 | James Fisk F000154 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
1840 | 1840 | James Fisk F000154 | sen | VT | 1817-12-01 | 1819-03-03 | 3 | Republican | |||||||||||||
1863 | 1863 | William Hunter H000990 | rep | VT | 1817-12-01 | 1819-03-03 | Republican | 0 | |||||||||||||
1958 | 1958 | William Palmer P000045 | sen | VT | 1818-10-20 | 1819-03-03 | 3 | Republican | |||||||||||||
1959 | 1959 | William Palmer P000045 | sen | VT | 1819-03-04 | 1825-03-03 | 3 | Republican | |||||||||||||
2077 | 2077 | Orsamus Merrill M000657 | rep | VT | 1817-12-01 | 1819-03-03 | Republican | 0 | |||||||||||||
2078 | 2078 | Orsamus Merrill M000657 | rep | VT | 1819-12-06 | 1821-03-03 | Republican | 0 | |||||||||||||
2112 | 2112 | Mark Richards R000217 | rep | VT | 1817-12-01 | 1819-03-03 | Republican | 0 | |||||||||||||
2113 | 2113 | Mark Richards R000217 | rep | VT | 1819-12-06 | 1821-03-03 | Republican | 0 | |||||||||||||
2150 | 2150 | William Strong S001022 | rep | VT | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
2151 | 2151 | William Strong S001022 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
2152 | 2152 | William Strong S001022 | rep | VT | 1819-12-06 | 1821-03-03 | Republican | 0 | |||||||||||||
2257 | 2257 | Elias Keyes K000160 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2345 | 2345 | Phineas White W000389 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2454 | 2454 | Henry Olin O000068 | rep | VT | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2467 | 2467 | Charles Rich R000207 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
2468 | 2468 | Charles Rich R000207 | rep | VT | 1817-12-01 | 1819-03-03 | Republican | 0 | |||||||||||||
2469 | 2469 | Charles Rich R000207 | rep | VT | 1819-12-06 | 1821-03-03 | Republican | 0 | |||||||||||||
2470 | 2470 | Charles Rich R000207 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2471 | 2471 | Charles Rich R000207 | rep | VT | 1823-12-01 | 1825-03-03 | Republican | 3 | |||||||||||||
2562 | 2562 | William Bradley B000748 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
2563 | 2563 | William Bradley B000748 | rep | VT | 1823-12-01 | 1825-03-03 | Republican | 2 | |||||||||||||
2564 | 2564 | William Bradley B000748 | rep | VT | 1825-12-05 | 1827-03-03 | Adams | 1 | |||||||||||||
2687 | 2687 | Ezra Meech M000625 | rep | VT | 1819-12-06 | 1821-03-03 | Republican | 0 | |||||||||||||
2688 | 2688 | Ezra Meech M000625 | rep | VT | 1825-12-05 | 1827-03-03 | Jackson | 4 | |||||||||||||
2806 | 2806 | Daniel Buck B001015 | rep | VT | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2807 | 2807 | Daniel Buck B001015 | rep | VT | 1827-12-03 | 1829-03-03 | Adams | 5 | |||||||||||||
2949 | 2949 | Horatio Seymour S000268 | sen | VT | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2950 | 2950 | Horatio Seymour S000268 | sen | VT | 1827-12-03 | 1833-03-03 | 1 | Adams | |||||||||||||
2987 | 2987 | George Wales W000042 | rep | VT | 1825-12-05 | 1827-03-03 | Adams | 3 | |||||||||||||
2988 | 2988 | George Wales W000042 | rep | VT | 1827-12-03 | 1829-03-03 | Adams | 3 | |||||||||||||
3325 | 3325 | William Cahoon C000020 | rep | VT | 1829-12-07 | 1831-03-03 | Anti Masonic | 5 | |||||||||||||
3326 | 3326 | William Cahoon C000020 | rep | VT | 1831-12-05 | 1833-03-03 | Anti Masonic | 5 | |||||||||||||
3419 | 3419 | Jonathan Hunt H000974 | rep | VT | 1827-12-03 | 1829-03-03 | Adams | 1 | |||||||||||||
3420 | 3420 | Jonathan Hunt H000974 | rep | VT | 1829-12-07 | 1831-03-03 | 1 | ||||||||||||||
3421 | 3421 | Jonathan Hunt H000974 | rep | VT | 1831-12-05 | 1833-03-03 | 1 | ||||||||||||||
3457 | 3457 | Rollin Mallary M000079 | rep | VT | 1819-12-06 | 1821-03-03 | Republican | 0 | |||||||||||||
3458 | 3458 | Rollin Mallary M000079 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3459 | 3459 | Rollin Mallary M000079 | rep | VT | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
3460 | 3460 | Rollin Mallary M000079 | rep | VT | 1825-12-05 | 1827-03-03 | Adams | 2 | |||||||||||||
3461 | 3461 | Rollin Mallary M000079 | rep | VT | 1827-12-03 | 1829-03-03 | Adams | 2 | |||||||||||||
3462 | 3462 | Rollin Mallary M000079 | rep | VT | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3463 | 3463 | Rollin Mallary M000079 | rep | VT | 1831-12-05 | 1833-03-03 | 2 | ||||||||||||||
3661 | 3661 | Benjamin Deming D000226 | rep | VT | 1833-12-02 | 1835-03-03 | Anti Masonic | 5 | |||||||||||||
3804 | 3804 | Benjamin Swift S001116 | rep | VT | 1827-12-03 | 1829-03-03 | Adams | 4 | |||||||||||||
3805 | 3805 | Benjamin Swift S001116 | rep | VT | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
3806 | 3806 | Benjamin Swift S001116 | sen | VT | 1833-12-02 | 1839-03-03 | 1 | Whig | |||||||||||||
3949 | 3949 | Henry Janes J000056 | rep | VT | 1833-12-02 | 1835-03-03 | Anti Masonic | 5 |
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);