legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
34 rows where district = "-1" and state = "MS"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, start, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
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 | ||||||||||||||
3637 | 3637 | Harry Cage C000018 | rep | MS | 1833-12-02 | 1835-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 | |||||||||||||
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 | |||||||||||||
6466 | 6466 | Stephen Adams A000048 | rep | MS | 1845-12-01 | 1847-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 | |||||||||||||
7282 | 7282 | William Barksdale B000147 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
7322 | 7322 | Albert Brown B000900 | rep | MS | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
9266 | 9266 | George McKee M000494 | rep | MS | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
10810 | 10810 | Vannoy Manning M000111 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | -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);