legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
17 rows where party = "Jackson" and state = "MS"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, end, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2538 | 2538 | Thomas Williams W000540 | sen | MS | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
2708 | 2708 | Christopher Rankin R000054 | rep | MS | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
2833 | 2833 | Powhatan Ellis E000136 | sen | MS | 1825-12-05 | 1827-03-03 | 1 | Jackson | |||||||||||||
2834 | 2834 | Powhatan Ellis E000136 | sen | MS | 1827-12-03 | 1833-03-03 | 1 | Jackson | |||||||||||||
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 | |||||||||||||
3191 | 3191 | Thomas Reed R000129 | sen | MS | 1826-01-01 | 1827-03-03 | 1 | Jackson | |||||||||||||
3277 | 3277 | Robert Adams A000043 | sen | MS | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
3283 | 3283 | George Poindexter P000402 | sen | MS | 1830-01-01 | 1835-03-03 | 2 | Jackson | |||||||||||||
3590 | 3590 | John Black B000503 | sen | MS | 1832-11-12 | 1833-03-03 | 1 | Jackson | |||||||||||||
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 | |||||||||||||
4170 | 4170 | John Claiborne C000404 | rep | MS | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4205 | 4205 | Samuel Gholson G000149 | rep | MS | 1835-12-07 | 1837-03-03 | Jackson | -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);