legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,277 rows where class = 1
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2185 | 2185 | Elijah Mills M000774 | sen | MA | 1821-03-06 | 1827-03-03 | 1 | Adams | |||||||||||||
2193 | 2193 | James Barbour B000127 | sen | VA | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2194 | 2194 | James Barbour B000127 | sen | VA | 1821-12-03 | 1825-12-31 | 1 | Republican | |||||||||||||
2204 | 2204 | Elijah Boardman B000577 | sen | CT | 1821-12-03 | 1823-12-31 | 1 | Republican | |||||||||||||
2229 | 2229 | James De Wolf D000295 | sen | RI | 1821-12-03 | 1825-12-31 | 1 | Republican | |||||||||||||
2237 | 2237 | William Findlay F000122 | sen | PA | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
2303 | 2303 | William Pinkney P000362 | sen | MD | 1819-12-06 | 1821-03-03 | 1 | Republican | |||||||||||||
2304 | 2304 | William Pinkney P000362 | sen | MD | 1821-12-03 | 1823-03-03 | 1 | Republican | |||||||||||||
2361 | 2361 | James Lloyd L000378 | sen | MA | 1808-06-09 | 1809-03-03 | 1 | Federalist | |||||||||||||
2362 | 2362 | James Lloyd L000378 | sen | MA | 1809-03-04 | 1813-05-01 | 1 | Federalist | |||||||||||||
2367 | 2367 | Caesar Rodney R000377 | sen | DE | 1822-01-24 | 1823-01-29 | 1 | Republican | |||||||||||||
2370 | 2370 | John Taylor T000086 | sen | VA | 1803-10-17 | 1803-12-07 | 1 | Republican | |||||||||||||
2408 | 2408 | Henry Edwards E000070 | sen | CT | 1823-12-01 | 1827-03-03 | 1 | Jackson | |||||||||||||
2450 | 2450 | Joseph McIlvaine M000475 | sen | NJ | 1823-11-12 | 1826-08-19 | 1 | Adams | |||||||||||||
2748 | 2748 | Ephraim Bateman B000228 | sen | NJ | 1826-11-09 | 1827-03-03 | 1 | Adams | |||||||||||||
2749 | 2749 | Ephraim Bateman B000228 | sen | NJ | 1827-12-03 | 1829-01-12 | 1 | Adams | |||||||||||||
2757 | 2757 | Nathan Sanford S000052 | sen | NY | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2775 | 2775 | Isaac Barnard B000154 | sen | PA | 1827-12-03 | 1831-12-31 | 1 | Jackson | |||||||||||||
2830 | 2830 | John Eaton E000024 | sen | TN | 1818-09-05 | 1821-03-03 | 1 | Republican | |||||||||||||
2831 | 2831 | John Eaton E000024 | sen | TN | 1821-12-03 | 1825-03-03 | 1 | ||||||||||||||
2832 | 2832 | John Eaton E000024 | sen | TN | 1827-12-03 | 1829-03-09 | 1 | Jackson | |||||||||||||
2833 | 2833 | Powhatan Ellis E000136 | sen | MS | 1825-12-05 | 1827-03-03 | 1 | Jackson | |||||||||||||
2834 | 2834 | Powhatan Ellis E000136 | sen | MS | 1827-12-03 | 1833-03-03 | 1 | Jackson | |||||||||||||
2899 | 2899 | Louis McLane M000535 | sen | DE | 1827-12-03 | 1829-12-31 | 1 | Jackson | |||||||||||||
2915 | 2915 | James Noble N000118 | sen | IN | 1816-01-01 | 1821-03-03 | 1 | Republican | |||||||||||||
2916 | 2916 | James Noble N000118 | sen | IN | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2917 | 2917 | James Noble N000118 | sen | IN | 1827-12-03 | 1831-12-31 | 1 | Adams | |||||||||||||
2930 | 2930 | Albion Parris P000079 | sen | ME | 1827-12-03 | 1829-03-03 | 1 | Jackson | |||||||||||||
2938 | 2938 | Benjamin Ruggles R000500 | sen | OH | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2939 | 2939 | Benjamin Ruggles R000500 | sen | OH | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2940 | 2940 | Benjamin Ruggles R000500 | sen | OH | 1827-12-03 | 1833-03-03 | 1 | Adams | |||||||||||||
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 | |||||||||||||
2962 | 2962 | Samuel Smith S000609 | sen | MD | 1803-10-17 | 1809-03-03 | 1 | Republican | |||||||||||||
2963 | 2963 | Samuel Smith S000609 | sen | MD | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
2967 | 2967 | Samuel Smith S000609 | sen | MD | 1822-01-01 | 1827-03-03 | 1 | Jackson | |||||||||||||
2968 | 2968 | Samuel Smith S000609 | sen | MD | 1827-12-03 | 1833-03-03 | 1 | Jackson | |||||||||||||
3021 | 3021 | Andrew Jackson J000005 | sen | TN | 1797-05-15 | 1799-03-03 | 1 | Republican | |||||||||||||
3081 | 3081 | Mahlon Dickerson D000308 | sen | NJ | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
3089 | 3089 | Charles Dudley D000511 | sen | NY | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
3134 | 3134 | John Holmes H000739 | sen | ME | 1820-06-13 | 1821-03-03 | 1 | Democratic Republican | |||||||||||||
3135 | 3135 | John Holmes H000739 | sen | ME | 1821-03-06 | 1827-03-03 | 1 | Democratic Republican | |||||||||||||
3136 | 3136 | John Holmes H000739 | sen | ME | 1829-01-15 | 1833-03-03 | 1 | Adams | |||||||||||||
3191 | 3191 | Thomas Reed R000129 | sen | MS | 1826-01-01 | 1827-03-03 | 1 | Jackson | |||||||||||||
3359 | 3359 | George Dallas D000011 | sen | PA | 1831-12-05 | 1833-03-03 | 1 | Jackson | |||||||||||||
3398 | 3398 | Robert Hanna H000165 | sen | IN | 1831-12-05 | 1833-03-03 | 1 | Anti-Jacksonian | |||||||||||||
3588 | 3588 | John Tipton T000284 | sen | IN | 1832-01-03 | 1833-03-02 | 1 | Democrat | |||||||||||||
3589 | 3589 | John Tipton T000284 | sen | IN | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
3590 | 3590 | John Black B000503 | sen | MS | 1832-11-12 | 1833-03-03 | 1 | Jackson | |||||||||||||
3591 | 3591 | John Black B000503 | sen | MS | 1833-11-22 | 1838-01-22 | 1 | Whig | |||||||||||||
3676 | 3676 | Samuel Foot F000247 | sen | CT | 1827-12-03 | 1833-03-03 | 1 | Adams | |||||||||||||
3716 | 3716 | Joseph Kent K000125 | sen | MD | 1833-12-02 | 1837-12-31 | 1 | Whig | |||||||||||||
3753 | 3753 | Samuel McKean M000492 | sen | PA | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
3762 | 3762 | Thomas Morris M000989 | sen | OH | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
3764 | 3764 | Arnold Naudain N000010 | sen | DE | 1830-01-01 | 1833-03-03 | 1 | Anti-Jacksonian | |||||||||||||
3765 | 3765 | Arnold Naudain N000010 | sen | DE | 1833-12-02 | 1837-03-03 | 1 | ||||||||||||||
3785 | 3785 | John Randolph R000047 | sen | VA | 1825-12-26 | 1827-03-03 | 1 | Jackson | |||||||||||||
3788 | 3788 | Asher Robbins R000297 | sen | RI | 1825-12-05 | 1827-03-03 | 1 | Adams | |||||||||||||
3789 | 3789 | Asher Robbins R000297 | sen | RI | 1827-12-03 | 1833-03-03 | 1 | Adams | |||||||||||||
3790 | 3790 | Asher Robbins R000297 | sen | RI | 1833-12-02 | 1839-03-03 | 1 | Whig | |||||||||||||
3792 | 3792 | Ether Shepley S000334 | sen | ME | 1833-12-02 | 1837-03-03 | 1 | Jackson | |||||||||||||
3795 | 3795 | Nathan Smith S000594 | sen | CT | 1833-12-02 | 1835-12-31 | 1 | Anti-Jacksonian | |||||||||||||
3806 | 3806 | Benjamin Swift S001116 | sen | VT | 1833-12-02 | 1839-03-03 | 1 | Whig | |||||||||||||
4113 | 4113 | Judah Dana D000022 | sen | ME | 1836-01-01 | 1837-12-31 | 1 | Jackson | |||||||||||||
4123 | 4123 | Martin Van Buren V000009 | sen | NY | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
4124 | 4124 | Martin Van Buren V000009 | sen | NY | 1827-12-03 | 1829-03-03 | 1 | Jackson | |||||||||||||
4387 | 4387 | William Merrick M000654 | sen | MD | 1838-01-04 | 1839-03-03 | 1 | Whig | |||||||||||||
4388 | 4388 | William Merrick M000654 | sen | MD | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
4389 | 4389 | James Trotter T000380 | sen | MS | 1838-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
4390 | 4390 | Thomas Williams W000539 | sen | MS | 1838-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
4461 | 4461 | Nathan Dixon D000376 | sen | RI | 1839-12-02 | 1843-03-03 | 1 | Whig | |||||||||||||
4494 | 4494 | Felix Grundy G000509 | sen | TN | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
4495 | 4495 | Felix Grundy G000509 | sen | TN | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4496 | 4496 | Felix Grundy G000509 | sen | TN | 1839-12-02 | 1841-03-03 | 1 | Democrat | |||||||||||||
4510 | 4510 | John Henderson H000482 | sen | MS | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
4612 | 4612 | Samuel Southard S000689 | sen | NJ | 1821-01-26 | 1821-03-03 | 1 | Republican | |||||||||||||
4613 | 4613 | Samuel Southard S000689 | sen | NJ | 1821-03-06 | 1823-03-03 | 1 | Republican | |||||||||||||
4614 | 4614 | Samuel Southard S000689 | sen | NJ | 1833-12-02 | 1839-03-03 | 1 | Whig | |||||||||||||
4615 | 4615 | Samuel Southard S000689 | sen | NJ | 1839-12-02 | 1842-06-26 | 1 | Whig | |||||||||||||
4622 | 4622 | Nathaniel Tallmadge T000032 | sen | NY | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4623 | 4623 | Nathaniel Tallmadge T000032 | sen | NY | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
4624 | 4624 | Benjamin Tappan T000039 | sen | OH | 1839-12-02 | 1845-03-03 | 1 | Democrat | |||||||||||||
4638 | 4638 | Reuel Williams W000532 | sen | ME | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
4639 | 4639 | Reuel Williams W000532 | sen | ME | 1839-12-02 | 1843-12-31 | 1 | Democrat | |||||||||||||
4648 | 4648 | Augustus Porter P000437 | sen | MI | 1840-01-01 | 1845-03-03 | 1 | Whig | |||||||||||||
4656 | 4656 | John Tyler T000450 | sen | VA | 1827-12-03 | 1833-03-03 | 1 | Jackson | |||||||||||||
4657 | 4657 | John Tyler T000450 | sen | VA | 1833-12-02 | 1837-03-03 | 1 | ||||||||||||||
4692 | 4692 | Richard Bayard B000251 | sen | DE | 1836-06-17 | 1839-03-03 | 1 | Whig | |||||||||||||
4693 | 4693 | Richard Bayard B000251 | sen | DE | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
4743 | 4743 | Rufus Choate C000375 | sen | MA | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
4750 | 4750 | Thomas Clayton C000499 | sen | DE | 1824-01-01 | 1827-03-03 | 1 | Adams | |||||||||||||
4974 | 4974 | William Rives R000285 | sen | VA | 1836-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
4975 | 4975 | William Rives R000285 | sen | VA | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
5110 | 5110 | William Sprague S000746 | sen | RI | 1842-01-01 | 1845-03-03 | 1 | Whig | |||||||||||||
5200 | 5200 | Ephraim Foster F000302 | sen | TN | 1838-01-01 | 1839-03-03 | 1 | Whig | |||||||||||||
5201 | 5201 | Ephraim Foster F000302 | sen | TN | 1843-12-04 | 1845-03-03 | 1 | Whig | |||||||||||||
5248 | 5248 | Lucius Lyon L000544 | sen | MI | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
5256 | 5256 | John Niles N000108 | sen | CT | 1835-12-07 | 1839-03-03 | 1 | Democrat | |||||||||||||
5337 | 5337 | Daniel Dickinson D000317 | sen | NY | 1844-11-30 | 1845-03-03 | 1 | Democrat |
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);