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 class
This data as json, copyable, CSV (advanced)
Suggested facets: district, address, phone, fax, contact_form, office, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
478 | 478 | Thomas Greene G000428 | rep | MS | 1801-12-07 | 1803-03-03 | -1 | ||||||||||||||
489 | 489 | Narsworthy Hunter H000986 | rep | MS | 1801-12-07 | 1803-03-03 | -1 | ||||||||||||||
1636 | 1636 | William Lattimore L000118 | rep | MS | 1803-10-17 | 1805-03-03 | -1 | ||||||||||||||
1637 | 1637 | William Lattimore L000118 | rep | MS | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
1638 | 1638 | William Lattimore L000118 | rep | MS | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1639 | 1639 | William Lattimore L000118 | rep | MS | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2705 | 2705 | Christopher Rankin R000054 | rep | MS | 1819-12-06 | 1821-03-03 | Republican | 1 | |||||||||||||
2706 | 2706 | Christopher Rankin R000054 | rep | MS | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2707 | 2707 | Christopher Rankin R000054 | rep | MS | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2708 | 2708 | Christopher Rankin R000054 | rep | MS | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
2848 | 2848 | William Haile H000022 | rep | MS | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
2849 | 2849 | William Haile H000022 | rep | MS | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3127 | 3127 | Thomas Hinds H000632 | rep | MS | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3128 | 3128 | Thomas Hinds H000632 | rep | MS | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3279 | 3279 | George Poindexter P000402 | rep | MS | 1807-10-26 | 1809-03-03 | -1 | ||||||||||||||
3280 | 3280 | George Poindexter P000402 | rep | MS | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
3281 | 3281 | George Poindexter P000402 | rep | MS | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
3282 | 3282 | George Poindexter P000402 | rep | MS | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
3637 | 3637 | Harry Cage C000018 | rep | MS | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3769 | 3769 | Franklin Plummer P000397 | rep | MS | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
3770 | 3770 | Franklin Plummer P000397 | rep | MS | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3893 | 3893 | David Dickson D000328 | rep | MS | 1835-12-07 | 1837-03-03 | Anti-Jacksonian | -1 | |||||||||||||
4170 | 4170 | John Claiborne C000404 | rep | MS | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4171 | 4171 | John Claiborne C000404 | rep | MS | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4205 | 4205 | Samuel Gholson G000149 | rep | MS | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4206 | 4206 | Samuel Gholson G000149 | rep | MS | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4328 | 4328 | Seargent Prentiss P000511 | rep | MS | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
4385 | 4385 | Thomas Word W000742 | rep | MS | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
5211 | 5211 | William Hammett H000125 | rep | MS | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5311 | 5311 | Tilghman Tucker T000404 | rep | MS | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5415 | 5415 | Henry Ellett E000116 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5511 | 5511 | Robert Roberts R000315 | rep | MS | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5512 | 5512 | Robert Roberts R000315 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5845 | 5845 | Patrick Tompkins T000308 | rep | MS | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
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 | |||||||||||||
6062 | 6062 | William McWillie M000612 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6137 | 6137 | Jacob Thompson T000203 | rep | MS | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6138 | 6138 | Jacob Thompson T000203 | rep | MS | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
6139 | 6139 | Jacob Thompson T000203 | rep | MS | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6140 | 6140 | Jacob Thompson T000203 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6141 | 6141 | Jacob Thompson T000203 | rep | MS | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6142 | 6142 | Jacob Thompson T000203 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6301 | 6301 | John Freeman F000363 | rep | MS | 1851-12-01 | 1853-03-03 | Unionist | 3 | |||||||||||||
6375 | 6375 | Benjamin Nabers N000001 | rep | MS | 1851-12-01 | 1853-03-03 | Unionist | 1 | |||||||||||||
6453 | 6453 | John Wilcox W000457 | rep | MS | 1851-12-01 | 1853-03-03 | Unionist | 2 | |||||||||||||
6466 | 6466 | Stephen Adams A000048 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6501 | 6501 | William Barry B000193 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6604 | 6604 | Wiley Harris H000256 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6772 | 6772 | Hendley Bennett B000375 | rep | MS | 1855-12-03 | 1857-03-03 | Democrat | 2 | |||||||||||||
6858 | 6858 | William Lake L000026 | rep | MS | 1855-12-03 | 1857-03-03 | American | 4 | |||||||||||||
6955 | 6955 | Daniel Wright W000757 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6956 | 6956 | Daniel Wright W000757 | rep | MS | 1855-12-03 | 1857-03-03 | Democrat | 1 | |||||||||||||
7020 | 7020 | Jefferson Davis D000113 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
7073 | 7073 | William Gwin G000540 | rep | MS | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
7192 | 7192 | John Quitman Q000022 | rep | MS | 1855-12-03 | 1857-03-03 | Democrat | 5 | |||||||||||||
7193 | 7193 | John Quitman Q000022 | rep | MS | 1857-12-07 | 1859-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
7504 | 7504 | John McRae M000596 | rep | MS | 1857-12-07 | 1859-03-03 | Democrat | 5 | |||||||||||||
7505 | 7505 | John McRae M000596 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
8924 | 8924 | George Harris H000238 | rep | MS | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8925 | 8925 | George Harris H000238 | rep | MS | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
8987 | 8987 | Legrand Perce P000221 | rep | MS | 1869-03-04 | 1871-03-03 | Republican | 5 | |||||||||||||
8988 | 8988 | Legrand Perce P000221 | rep | MS | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
9211 | 9211 | Albert Howe H000850 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9266 | 9266 | George McKee M000494 | rep | MS | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
9267 | 9267 | George McKee M000494 | rep | MS | 1869-03-04 | 1871-03-03 | Republican | 4 | |||||||||||||
9268 | 9268 | George McKee M000494 | rep | MS | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
9269 | 9269 | George McKee M000494 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9296 | 9296 | Jason Niles N000107 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9689 | 9689 | Guilford Wells W000283 | rep | MS | 1875-12-06 | 1877-03-03 | Ind. Republican | 2 | |||||||||||||
10438 | 10438 | John Lynch L000533 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
10439 | 10439 | John Lynch L000533 | rep | MS | 1875-12-06 | 1877-03-03 | Republican | 6 | |||||||||||||
10440 | 10440 | John Lynch L000533 | rep | MS | 1881-12-05 | 1883-03-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
10770 | 10770 | Elza Jeffords J000071 | rep | MS | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
10784 | 10784 | Lucius Lamar L000030 | rep | MS | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
10785 | 10785 | Lucius Lamar L000030 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
10786 | 10786 | Lucius Lamar L000030 | rep | MS | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
10787 | 10787 | Lucius Lamar L000030 | rep | MS | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
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 |
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);