legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
509 rows where party = "Democrat" and state = "MS"
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4171 | 4171 | John Claiborne C000404 | rep | MS | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4206 | 4206 | Samuel Gholson G000149 | rep | MS | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
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 | |||||||||||||
5045 | 5045 | Robert Walker W000067 | sen | MS | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5046 | 5046 | Robert Walker W000067 | sen | MS | 1841-05-31 | 1845-12-31 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
5376 | 5376 | Joseph Chalmers C000273 | sen | MS | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
5528 | 5528 | Jesse Speight S000715 | sen | MS | 1845-12-01 | 1847-12-31 | 1 | Democrat | |||||||||||||
5694 | 5694 | Henry Foote F000251 | sen | MS | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
7021 | 7021 | Jefferson Davis D000113 | sen | MS | 1847-12-06 | 1851-03-03 | 1 | Democrat | |||||||||||||
7022 | 7022 | Jefferson Davis D000113 | sen | MS | 1857-12-07 | 1861-12-31 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
7503 | 7503 | John McRae M000596 | sen | MS | 1851-12-01 | 1853-03-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
10788 | 10788 | Lucius Lamar L000030 | sen | MS | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
10789 | 10789 | Lucius Lamar L000030 | sen | MS | 1883-12-03 | 1885-12-31 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
10810 | 10810 | Vannoy Manning M000111 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10820 | 10820 | Henry Muldrow M001068 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10821 | 10821 | Henry Muldrow M001068 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10822 | 10822 | Henry Muldrow M001068 | rep | MS | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10823 | 10823 | Henry Muldrow M001068 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
11187 | 11187 | Otho Singleton S000445 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
11188 | 11188 | Otho Singleton S000445 | rep | MS | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
11189 | 11189 | Otho Singleton S000445 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
11190 | 11190 | Otho Singleton S000445 | rep | MS | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
11191 | 11191 | Otho Singleton S000445 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
11192 | 11192 | Otho Singleton S000445 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
11193 | 11193 | Otho Singleton S000445 | rep | MS | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
11194 | 11194 | Otho Singleton S000445 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
11195 | 11195 | Otho Singleton S000445 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11238 | 11238 | Henry Van Eaton V000038 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
11239 | 11239 | Henry Van Eaton V000038 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
12081 | 12081 | Joseph Beeman B000309 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12228 | 12228 | Clarke Lewis L000276 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12229 | 12229 | Clarke Lewis L000276 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12572 | 12572 | James George G000127 | sen | MS | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
12573 | 12573 | James George G000127 | sen | MS | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12574 | 12574 | James George G000127 | sen | MS | 1893-08-07 | 1897-12-31 | 1 | Democrat | |||||||||||||
12810 | 12810 | Thomas Stockdale S000934 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 6 | |||||||||||||
12811 | 12811 | Thomas Stockdale S000934 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
12812 | 12812 | Thomas Stockdale S000934 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12813 | 12813 | Thomas Stockdale S000934 | rep | MS | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12997 | 12997 | Walter Denny D000251 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
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 |
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);