legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
651 rows where state = "MS"
This data as json, copyable, CSV (advanced)
party 4 ✖
- Democrat 459
- Republican 90
- Ind. Republican 1
- Independent 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
9433 | 9433 | Henry Pease P000172 | sen | MS | 1874-01-01 | 1875-03-03 | 1 | Republican | |||||||||||||
9461 | 9461 | Blanche Bruce B000968 | sen | MS | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
13054 | 13054 | John Kyle K000354 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13164 | 13164 | James Spencer S000726 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
13201 | 13201 | Edward Walthall W000111 | sen | MS | 1885-12-07 | 1889-03-03 | 2 | Democrat | |||||||||||||
13202 | 13202 | Edward Walthall W000111 | sen | MS | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
13203 | 13203 | Edward Walthall W000111 | sen | MS | 1895-12-02 | 1899-03-03 | 2 | Democrat | |||||||||||||
13381 | 13381 | William Love L000461 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13543 | 13543 | William Sullivan S001062 | rep | MS | 1897-03-15 | 1898-05-31 | Democrat | 2 | |||||||||||||
13544 | 13544 | William Sullivan S001062 | sen | MS | 1898-05-31 | 1901-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
13709 | 13709 | Patrick Henry H000512 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
13710 | 13710 | Patrick Henry H000512 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
13963 | 13963 | Andrew Fox F000330 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 4 |
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);