legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
878 rows where party = "Jackson" sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: end, class, start (date), end (date)
state 25 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2575 | 2575 | Henry Chambers C000284 | sen | AL | 1825-12-05 | 1827-03-03 | 3 | Jackson | |||||||||||||
2754 | 2754 | Israel Pickens P000322 | sen | AL | 1826-01-01 | 1827-03-03 | 3 | Jackson | |||||||||||||
2892 | 2892 | John McKee M000495 | rep | AL | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
2893 | 2893 | John McKee M000495 | rep | AL | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
2926 | 2926 | George Owen O000150 | rep | AL | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
2927 | 2927 | George Owen O000150 | rep | AL | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
3051 | 3051 | Robert Baylor B000257 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3493 | 3493 | Gabriel Moore M000898 | rep | AL | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
3494 | 3494 | Gabriel Moore M000898 | rep | AL | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3495 | 3495 | Gabriel Moore M000898 | sen | AL | 1831-12-05 | 1837-03-03 | 3 | Jackson | |||||||||||||
3737 | 3737 | Samuel Mardis M000128 | rep | AL | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
3738 | 3738 | Samuel Mardis M000128 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3763 | 3763 | John Murphy M001097 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
4172 | 4172 | Clement Clay C000481 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4173 | 4173 | Clement Clay C000481 | rep | AL | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
4174 | 4174 | Clement Clay C000481 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
4254 | 4254 | Joab Lawler L000129 | rep | AL | 1835-12-07 | 1837-03-03 | Jackson | 3 | |||||||||||||
4270 | 4270 | Joshua Martin M000192 | rep | AL | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4282 | 4282 | John McKinley M000519 | sen | AL | 1826-01-01 | 1831-03-03 | 3 | Jackson | |||||||||||||
4283 | 4283 | John McKinley M000519 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
5379 | 5379 | Reuben Chapman C000316 | rep | AL | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
5755 | 5755 | Dixon Lewis L000278 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
5756 | 5756 | Dixon Lewis L000278 | rep | AL | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
5874 | 5874 | William King K000217 | sen | AL | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
5875 | 5875 | William King K000217 | sen | AL | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
5581 | 5581 | Archibald Yell Y000017 | rep | AR | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
2408 | 2408 | Henry Edwards E000070 | sen | CT | 1823-12-01 | 1827-03-03 | 1 | Jackson | |||||||||||||
3969 | 3969 | Andrew Judson J000279 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4112 | 4112 | Zalmon Wildman W000463 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4219 | 4219 | Elisha Haley H000040 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4236 | 4236 | Orrin Holt H000748 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4245 | 4245 | Samuel Ingham I000021 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4317 | 4317 | Lancelot Phelps P000297 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4383 | 4383 | Thomas Whittlesey W000433 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
6476 | 6476 | Isaac Toucey T000319 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
2898 | 2898 | Louis McLane M000535 | rep | DE | 1825-12-05 | 1827-03-03 | Jackson | 0 | |||||||||||||
2899 | 2899 | Louis McLane M000535 | sen | DE | 1827-12-03 | 1829-12-31 | 1 | Jackson | |||||||||||||
2937 | 2937 | Henry Ridgely R000245 | sen | DE | 1827-12-03 | 1829-03-03 | 2 | Jackson | |||||||||||||
2544 | 2544 | Thomas Cobb C000553 | sen | GA | 1824-01-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
2571 | 2571 | George Cary C000212 | rep | GA | 1825-12-05 | 1827-03-03 | Jackson | -1 | |||||||||||||
2689 | 2689 | James Meriwether M000651 | rep | GA | 1825-12-05 | 1827-03-03 | Jackson | -1 | |||||||||||||
2836 | 2836 | John Floyd F000220 | rep | GA | 1827-12-03 | 1829-03-03 | Jackson | 7 | |||||||||||||
2843 | 2843 | Tomlinson Fort F000289 | rep | GA | 1827-12-03 | 1829-03-03 | Jackson | 6 | |||||||||||||
2975 | 2975 | Edward Tattnall T000051 | rep | GA | 1825-12-05 | 1827-03-03 | Jackson | -1 | |||||||||||||
2976 | 2976 | Edward Tattnall T000051 | rep | GA | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3019 | 3019 | Oliver Prince P000539 | sen | GA | 1828-01-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
3256 | 3256 | George Troup T000382 | sen | GA | 1829-12-07 | 1833-11-08 | 2 | Jackson | |||||||||||||
3388 | 3388 | John Forsyth F000284 | rep | GA | 1825-12-05 | 1827-03-03 | Jackson | -1 | |||||||||||||
3389 | 3389 | John Forsyth F000284 | sen | GA | 1829-12-07 | 1831-03-03 | 3 | Jackson | |||||||||||||
3390 | 3390 | John Forsyth F000284 | sen | GA | 1831-12-05 | 1834-06-27 | 3 | Jackson | |||||||||||||
3449 | 3449 | Henry Lamar L000027 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3450 | 3450 | Henry Lamar L000027 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
3503 | 3503 | Daniel Newnan N000071 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
3564 | 3564 | Wiley Thompson T000222 | rep | GA | 1825-12-05 | 1827-03-03 | Jackson | -1 | |||||||||||||
3565 | 3565 | Wiley Thompson T000222 | rep | GA | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
3566 | 3566 | Wiley Thompson T000222 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3567 | 3567 | Wiley Thompson T000222 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
3644 | 3644 | Augustin Clayton C000491 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
3645 | 3645 | Augustin Clayton C000491 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3681 | 3681 | George Gilmer G000216 | rep | GA | 1827-12-03 | 1829-03-03 | Jackson | -1 | |||||||||||||
3682 | 3682 | George Gilmer G000216 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3821 | 3821 | Richard Wilde W000460 | rep | GA | 1827-12-03 | 1829-03-03 | Jackson | -1 | |||||||||||||
3822 | 3822 | Richard Wilde W000460 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3823 | 3823 | Richard Wilde W000460 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
3824 | 3824 | Richard Wilde W000460 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3876 | 3876 | John Coffee C000583 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3877 | 3877 | John Coffee C000583 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
3973 | 3973 | John King K000207 | sen | GA | 1833-12-02 | 1835-03-03 | 2 | Jackson | |||||||||||||
4055 | 4055 | William Schley S000130 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
4095 | 4095 | James Wayne W000218 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4096 | 4096 | James Wayne W000218 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
4097 | 4097 | James Wayne W000218 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
4176 | 4176 | Jesse Cleveland C000513 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4187 | 4187 | Alfred Cuthbert C001023 | rep | GA | 1825-12-05 | 1827-03-03 | Jackson | -1 | |||||||||||||
4189 | 4189 | Alfred Cuthbert C001023 | sen | GA | 1835-12-07 | 1837-03-03 | 3 | Jackson | |||||||||||||
4207 | 4207 | Thomas Glascock G000230 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4211 | 4211 | Seaton Grantland G000385 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4227 | 4227 | Charles Haynes H000399 | rep | GA | 1825-12-05 | 1827-03-03 | Jackson | -1 | |||||||||||||
4228 | 4228 | Charles Haynes H000399 | rep | GA | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
4229 | 4229 | Charles Haynes H000399 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4230 | 4230 | Charles Haynes H000399 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4234 | 4234 | Hopkins Holsey H000744 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4247 | 4247 | Jabez Jackson J000015 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4264 | 4264 | Wilson Lumpkin L000512 | rep | GA | 1827-12-03 | 1829-03-03 | Jackson | 4 | |||||||||||||
4265 | 4265 | Wilson Lumpkin L000512 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4266 | 4266 | Wilson Lumpkin L000512 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
4306 | 4306 | George Owens O000157 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4793 | 4793 | Thomas Foster F000314 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4794 | 4794 | Thomas Foster F000314 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
4795 | 4795 | Thomas Foster F000314 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
4799 | 4799 | Roger Gamble G000033 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
5462 | 5462 | Seaborn Jones J000252 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
5546 | 5546 | George Towns T000327 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
5614 | 5614 | John Berrien B000413 | sen | GA | 1825-12-05 | 1829-12-31 | 3 | Jackson | |||||||||||||
3178 | 3178 | John McLean M000550 | sen | IL | 1829-12-07 | 1831-03-03 | 2 | Jackson | |||||||||||||
3278 | 3278 | David Baker B000058 | sen | IL | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
3441 | 3441 | Elias Kane K000006 | sen | IL | 1825-12-05 | 1831-03-03 | 3 | Jackson | |||||||||||||
3442 | 3442 | Elias Kane K000006 | sen | IL | 1831-12-05 | 1835-12-31 | 3 | Jackson | |||||||||||||
3665 | 3665 | Joseph Duncan D000535 | rep | IL | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3666 | 3666 | Joseph Duncan D000535 | rep | IL | 1829-12-07 | 1831-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);