legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
651 rows where state = "MS" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, url, phone, fax, contact_form, office, state_rank, start (date), end (date)
party 10 ✖
- Democrat 509
- Republican 100
- Jackson 17
- Whig 6
- Unionist 3
- American 1
- Anti-Jacksonian 1
- Ind. Republican 1
- Independent 1
- States Rights 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29524 | 29524 | Thomas Abernethy A000016 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
29525 | 29525 | Thomas Abernethy A000016 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
29526 | 29526 | Thomas Abernethy A000016 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29527 | 29527 | Thomas Abernethy A000016 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
29528 | 29528 | Thomas Abernethy A000016 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29529 | 29529 | Thomas Abernethy A000016 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29530 | 29530 | Thomas Abernethy A000016 | rep | MS | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
29531 | 29531 | Thomas Abernethy A000016 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29532 | 29532 | Thomas Abernethy A000016 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29533 | 29533 | Thomas Abernethy A000016 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29534 | 29534 | Thomas Abernethy A000016 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29535 | 29535 | Thomas Abernethy A000016 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29536 | 29536 | Thomas Abernethy A000016 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29537 | 29537 | Thomas Abernethy A000016 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29538 | 29538 | Thomas Abernethy A000016 | rep | MS | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
3277 | 3277 | Robert Adams A000043 | sen | MS | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
6466 | 6466 | Stephen Adams A000048 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6467 | 6467 | Stephen Adams A000048 | sen | MS | 1852-01-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
8799 | 8799 | James Alcorn A000079 | sen | MS | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
13548 | 13548 | John Allen A000134 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
13549 | 13549 | John Allen A000134 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
13550 | 13550 | John Allen A000134 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
13551 | 13551 | John Allen A000134 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
13552 | 13552 | John Allen A000134 | rep | MS | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
13553 | 13553 | John Allen A000134 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
13554 | 13554 | John Allen A000134 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
13555 | 13555 | John Allen A000134 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
8790 | 8790 | Adelbert Ames A000172 | sen | MS | 1870-01-01 | 1875-03-03 | 1 | Republican | |||||||||||||
11563 | 11563 | Chapman Anderson A000183 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 5 | |||||||||||||
11564 | 11564 | Chapman Anderson A000183 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
10963 | 10963 | Ethelbert Barksdale B000146 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10964 | 10964 | Ethelbert Barksdale B000146 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
7282 | 7282 | William Barksdale B000147 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
7283 | 7283 | William Barksdale B000147 | rep | MS | 1855-12-03 | 1857-03-03 | Democrat | 3 | |||||||||||||
7284 | 7284 | William Barksdale B000147 | rep | MS | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7285 | 7285 | William Barksdale B000147 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
11287 | 11287 | Frederick Barry B000188 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11288 | 11288 | Frederick Barry B000188 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
9086 | 9086 | Henry Barry B000189 | rep | MS | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
9087 | 9087 | Henry Barry B000189 | rep | MS | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
9088 | 9088 | Henry Barry B000189 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
6501 | 6501 | William Barry B000193 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
12081 | 12081 | Joseph Beeman B000309 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
6772 | 6772 | Hendley Bennett B000375 | rep | MS | 1855-12-03 | 1857-03-03 | Democrat | 2 | |||||||||||||
22872 | 22872 | Theodore Bilbo B000460 | sen | MS | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22873 | 22873 | Theodore Bilbo B000460 | sen | MS | 1941-01-03 | 1947-01-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 | |||||||||||||
32506 | 32506 | David Bowen B000682 | rep | MS | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
32507 | 32507 | David Bowen B000682 | rep | MS | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32508 | 32508 | David Bowen B000682 | rep | MS | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
32509 | 32509 | David Bowen B000682 | rep | MS | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32510 | 32510 | David Bowen B000682 | rep | MS | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
15351 | 15351 | Eaton Bowers B000689 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
15352 | 15352 | Eaton Bowers B000689 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
15353 | 15353 | Eaton Bowers B000689 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15354 | 15354 | Eaton Bowers B000689 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
6468 | 6468 | Walker Brooke B000872 | sen | MS | 1852-01-01 | 1853-03-03 | 2 | Whig | |||||||||||||
7322 | 7322 | Albert Brown B000900 | rep | MS | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
7323 | 7323 | Albert Brown B000900 | rep | MS | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
7324 | 7324 | Albert Brown B000900 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
7325 | 7325 | Albert Brown B000900 | rep | MS | 1851-12-01 | 1853-03-03 | States Rights | 4 | |||||||||||||
7326 | 7326 | Albert Brown B000900 | sen | MS | 1854-01-01 | 1859-03-03 | 2 | Democrat | |||||||||||||
7327 | 7327 | Albert Brown B000900 | sen | MS | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
9461 | 9461 | Blanche Bruce B000968 | sen | MS | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
21179 | 21179 | Thomas Busby B001163 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21180 | 21180 | Thomas Busby B001163 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
21181 | 21181 | Thomas Busby B001163 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21182 | 21182 | Thomas Busby B001163 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21183 | 21183 | Thomas Busby B001163 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21184 | 21184 | Thomas Busby B001163 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
15364 | 15364 | Adam Byrd B001207 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
15365 | 15365 | Adam Byrd B001207 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
15366 | 15366 | Adam Byrd B001207 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
15367 | 15367 | Adam Byrd B001207 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
3637 | 3637 | Harry Cage C000018 | rep | MS | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
17594 | 17594 | Ezekiel Candler C000110 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
17595 | 17595 | Ezekiel Candler C000110 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
17596 | 17596 | Ezekiel Candler C000110 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
17597 | 17597 | Ezekiel Candler C000110 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
17598 | 17598 | Ezekiel Candler C000110 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
17599 | 17599 | Ezekiel Candler C000110 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
17600 | 17600 | Ezekiel Candler C000110 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17601 | 17601 | Ezekiel Candler C000110 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17602 | 17602 | Ezekiel Candler C000110 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17603 | 17603 | Ezekiel Candler C000110 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
13598 | 13598 | Thomas Catchings C000247 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
13599 | 13599 | Thomas Catchings C000247 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 3 | |||||||||||||
13600 | 13600 | Thomas Catchings C000247 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
13601 | 13601 | Thomas Catchings C000247 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
13602 | 13602 | Thomas Catchings C000247 | rep | MS | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
13603 | 13603 | Thomas Catchings C000247 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13604 | 13604 | Thomas Catchings C000247 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13605 | 13605 | Thomas Catchings C000247 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
10668 | 10668 | James Chalmers C000272 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10669 | 10669 | James Chalmers C000272 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10670 | 10670 | James Chalmers C000272 | rep | MS | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
10671 | 10671 | James Chalmers C000272 | rep | MS | 1883-12-03 | 1885-03-03 | Independent | 2 | |||||||||||||
5376 | 5376 | Joseph Chalmers C000273 | sen | MS | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
4170 | 4170 | John Claiborne C000404 | rep | MS | 1835-12-07 | 1837-03-03 | Jackson | -1 |
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);