legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
86 rows where district = 2 and state = "MS"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, url, address, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5974 | 5974 | Winfield Featherston F000055 | rep | MS | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5975 | 5975 | Winfield Featherston F000055 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6453 | 6453 | John Wilcox W000457 | rep | MS | 1851-12-01 | 1853-03-03 | Unionist | 2 | |||||||||||||
6501 | 6501 | William Barry B000193 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6772 | 6772 | Hendley Bennett B000375 | rep | MS | 1855-12-03 | 1857-03-03 | Democrat | 2 | |||||||||||||
7378 | 7378 | Reuben Davis D000127 | rep | MS | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
7379 | 7379 | Reuben Davis D000127 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
8976 | 8976 | Joseph Morphis M000963 | rep | MS | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8977 | 8977 | Joseph Morphis M000963 | rep | MS | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9211 | 9211 | Albert Howe H000850 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9689 | 9689 | Guilford Wells W000283 | rep | MS | 1875-12-06 | 1877-03-03 | Ind. Republican | 2 | |||||||||||||
10671 | 10671 | James Chalmers C000272 | rep | MS | 1883-12-03 | 1885-03-03 | Independent | 2 | |||||||||||||
10807 | 10807 | Vannoy Manning M000111 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10808 | 10808 | Vannoy Manning M000111 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10809 | 10809 | Vannoy Manning M000111 | rep | MS | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
11864 | 11864 | James Morgan M000952 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11865 | 11865 | James Morgan M000952 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
11866 | 11866 | James Morgan M000952 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
13052 | 13052 | John Kyle K000354 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
13053 | 13053 | John Kyle K000354 | rep | MS | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
13054 | 13054 | John Kyle K000354 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13543 | 13543 | William Sullivan S001062 | rep | MS | 1897-03-15 | 1898-05-31 | Democrat | 2 | |||||||||||||
15754 | 15754 | Thomas Spight S000734 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
15755 | 15755 | Thomas Spight S000734 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
15756 | 15756 | Thomas Spight S000734 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
15757 | 15757 | Thomas Spight S000734 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15758 | 15758 | Thomas Spight S000734 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15759 | 15759 | Thomas Spight S000734 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15760 | 15760 | Thomas Spight S000734 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
19393 | 19393 | Bill Lowrey L000484 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19394 | 19394 | Bill Lowrey L000484 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19395 | 19395 | Bill Lowrey L000484 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19396 | 19396 | Bill Lowrey L000484 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19990 | 19990 | Hubert Stephens S000857 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
19991 | 19991 | Hubert Stephens S000857 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19992 | 19992 | Hubert Stephens S000857 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19993 | 19993 | Hubert Stephens S000857 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19994 | 19994 | Hubert Stephens S000857 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
22963 | 22963 | Wall Doxey D000480 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
22964 | 22964 | Wall Doxey D000480 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22965 | 22965 | Wall Doxey D000480 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22966 | 22966 | Wall Doxey D000480 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22967 | 22967 | Wall Doxey D000480 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22968 | 22968 | Wall Doxey D000480 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
33268 | 33268 | William Franklin F000347 | rep | MS | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
33269 | 33269 | William Franklin F000347 | rep | MS | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
35226 | 35226 | Albert Espy E000218 | rep | MS | 1987-01-06 | 1989-01-03 | Democrat | 2 | |||||||||||||
35227 | 35227 | Albert Espy E000218 | rep | MS | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
35228 | 35228 | Albert Espy E000218 | rep | MS | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35229 | 35229 | Albert Espy E000218 | rep | MS | 1993-01-05 | 1993-01-22 | Democrat | 2 | |||||||||||||
35642 | 35642 | Jamie Whitten W000428 | rep | MS | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
35643 | 35643 | Jamie Whitten W000428 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
35644 | 35644 | Jamie Whitten W000428 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
35645 | 35645 | Jamie Whitten W000428 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
35646 | 35646 | Jamie Whitten W000428 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
35647 | 35647 | Jamie Whitten W000428 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
35648 | 35648 | Jamie Whitten W000428 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
35649 | 35649 | Jamie Whitten W000428 | rep | MS | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
35650 | 35650 | Jamie Whitten W000428 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
35651 | 35651 | Jamie Whitten W000428 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
35652 | 35652 | Jamie Whitten W000428 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
35653 | 35653 | Jamie Whitten W000428 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35654 | 35654 | Jamie Whitten W000428 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35655 | 35655 | Jamie Whitten W000428 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
35656 | 35656 | Jamie Whitten W000428 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
35657 | 35657 | Jamie Whitten W000428 | rep | MS | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
43450 | 43450 | Bennie Thompson T000193 | rep | MS | 1993-04-13 | 1995-01-03 | Democrat | 2 | |||||||||||||
43451 | 43451 | Bennie Thompson T000193 | rep | MS | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
43452 | 43452 | Bennie Thompson T000193 | rep | MS | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
43453 | 43453 | Bennie Thompson T000193 | rep | MS | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
43454 | 43454 | Bennie Thompson T000193 | rep | MS | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
43455 | 43455 | Bennie Thompson T000193 | rep | MS | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/thompson | ||||||||||||
43456 | 43456 | Bennie Thompson T000193 | rep | MS | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/thompson | ||||||||||||
43457 | 43457 | Bennie Thompson T000193 | rep | MS | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://benniethompson.house.gov | ||||||||||||
43458 | 43458 | Bennie Thompson T000193 | rep | MS | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://benniethompson.house.gov | ||||||||||||
43459 | 43459 | Bennie Thompson T000193 | rep | MS | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://benniethompson.house.gov | 2466 Rayburn HOB; Washington DC 20515-2402 | 202-225-5876 | 202-225-5898 | https://forms.house.gov/benniethompson/contact-form.shtml | 2466 Rayburn House Office Building | |||||||
43460 | 43460 | Bennie Thompson T000193 | rep | MS | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://benniethompson.house.gov | 2466 Rayburn HOB; Washington DC 20515-2402 | 202-225-5876 | 202-225-5898 | https://forms.house.gov/benniethompson/contact-form.shtml | 2466 Rayburn House Office Building | http://benniethompson.house.gov/index.php?format=feed&type=rss | ||||||
43461 | 43461 | Bennie Thompson T000193 | rep | MS | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://benniethompson.house.gov | 2466 Rayburn HOB; Washington DC 20515-2402 | 202-225-5876 | 202-225-5898 | https://forms.house.gov/benniethompson/contact-form.shtml | 2466 Rayburn House Office Building | http://benniethompson.house.gov/index.php?format=feed&type=rss | ||||||
43462 | 43462 | Bennie Thompson T000193 | rep | MS | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://benniethompson.house.gov | 2466 Rayburn House Office Building; Washington DC 20515-2402 | 202-225-5876 | 202-225-5898 | 2466 Rayburn House Office Building | http://benniethompson.house.gov/index.php?format=feed&type=rss | |||||||
43463 | 43463 | Bennie Thompson T000193 | rep | MS | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://benniethompson.house.gov | 2466 Rayburn House Office Building Washington DC 20515-2402 | 202-225-5876 | 2466 Rayburn House Office Building | http://benniethompson.house.gov/index.php?format=feed&type=rss | ||||||||
43464 | 43464 | Bennie Thompson T000193 | rep | MS | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://benniethompson.house.gov | 2466 Rayburn House Office Building Washington DC 20515-2402 | 202-225-5876 | 2466 Rayburn House Office Building | http://benniethompson.house.gov/index.php?format=feed&type=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);