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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: start, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8462 | 8462 | Francis Thomas T000166 | rep | MD | 1835-12-07 | 1837-03-03 | Jackson | 6 | |||||||||||||
8461 | 8461 | Francis Thomas T000166 | rep | MD | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
8460 | 8460 | Francis Thomas T000166 | rep | MD | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
7886 | 7886 | Charles Wickliffe W000442 | rep | KY | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
7885 | 7885 | Charles Wickliffe W000442 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
7884 | 7884 | Charles Wickliffe W000442 | rep | KY | 1827-12-03 | 1829-03-03 | Jackson | 9 | |||||||||||||
7883 | 7883 | Charles Wickliffe W000442 | rep | KY | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
7090 | 7090 | George Hopkins H000774 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 18 | |||||||||||||
6968 | 6968 | James Buchanan B001005 | sen | PA | 1834-01-01 | 1837-03-03 | 3 | Jackson | |||||||||||||
6967 | 6967 | James Buchanan B001005 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
6966 | 6966 | James Buchanan B001005 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 4 | |||||||||||||
6965 | 6965 | James Buchanan B001005 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 4 | |||||||||||||
6616 | 6616 | Samuel Houston H000827 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 7 | |||||||||||||
6547 | 6547 | Samuel Clark C000451 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 25 | |||||||||||||
6522 | 6522 | Linn Boyd B000719 | rep | KY | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
6513 | 6513 | Thomas Benton B000398 | sen | MO | 1827-12-03 | 1833-03-03 | 1 | Jackson | |||||||||||||
6512 | 6512 | Thomas Benton B000398 | sen | MO | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
6506 | 6506 | John Bell B000340 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
6505 | 6505 | John Bell B000340 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
6504 | 6504 | John Bell B000340 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
6503 | 6503 | John Bell B000340 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 7 | |||||||||||||
6484 | 6484 | Franklin Pierce P000333 | rep | NH | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
6483 | 6483 | Franklin Pierce P000333 | rep | NH | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
6476 | 6476 | Isaac Toucey T000319 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
6218 | 6218 | James Beale B000266 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 16 | |||||||||||||
6217 | 6217 | James Beale B000266 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 16 | |||||||||||||
6180 | 6180 | Robert Barnwell B000168 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
6116 | 6116 | Augustine Shepperd S000338 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
6115 | 6115 | Augustine Shepperd S000338 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
6114 | 6114 | Augustine Shepperd S000338 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 9 | |||||||||||||
6048 | 6048 | Job Mann M000106 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 18 | |||||||||||||
5875 | 5875 | William King K000217 | sen | AL | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
5874 | 5874 | William King K000217 | sen | AL | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
5830 | 5830 | Andrew Stewart S000899 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 14 | |||||||||||||
5786 | 5786 | James McKay M000489 | rep | NC | 1835-12-07 | 1837-03-03 | Jackson | 5 | |||||||||||||
5785 | 5785 | James McKay M000489 | rep | NC | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
5784 | 5784 | James McKay M000489 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
5770 | 5770 | Willie Mangum M000096 | sen | NC | 1831-12-05 | 1836-11-26 | 3 | Jackson | |||||||||||||
5769 | 5769 | Willie Mangum M000096 | rep | NC | 1825-12-05 | 1826-03-18 | Jackson | 8 | |||||||||||||
5756 | 5756 | Dixon Lewis L000278 | rep | AL | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
5755 | 5755 | Dixon Lewis L000278 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
5695 | 5695 | Richard French F000379 | rep | KY | 1835-12-07 | 1837-03-03 | Jackson | 11 | |||||||||||||
5675 | 5675 | George Dromgoole D000504 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 4 | |||||||||||||
5614 | 5614 | John Berrien B000413 | sen | GA | 1825-12-05 | 1829-12-31 | 3 | Jackson | |||||||||||||
5581 | 5581 | Archibald Yell Y000017 | rep | AR | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
5546 | 5546 | George Towns T000327 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
5527 | 5527 | Jesse Speight S000715 | rep | NC | 1835-12-07 | 1837-03-03 | Jackson | 4 | |||||||||||||
5526 | 5526 | Jesse Speight S000715 | rep | NC | 1833-12-02 | 1835-03-03 | Jackson | 4 | |||||||||||||
5525 | 5525 | Jesse Speight S000715 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
5524 | 5524 | Jesse Speight S000715 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
5462 | 5462 | Seaborn Jones J000252 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
5458 | 5458 | Joseph Johnson J000155 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 20 | |||||||||||||
5457 | 5457 | Joseph Johnson J000155 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 18 | |||||||||||||
5456 | 5456 | Joseph Johnson J000155 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 18 | |||||||||||||
5420 | 5420 | John Fairfield F000006 | rep | ME | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
5399 | 5399 | John Davis D000120 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
5379 | 5379 | Reuben Chapman C000316 | rep | AL | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
5361 | 5361 | James Black B000500 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 13 | |||||||||||||
5353 | 5353 | James Polk P000409 | rep | TN | 1835-12-07 | 1837-03-03 | Jackson | 9 | |||||||||||||
5352 | 5352 | James Polk P000409 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 9 | |||||||||||||
5351 | 5351 | James Polk P000409 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 6 | |||||||||||||
5350 | 5350 | James Polk P000409 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
5349 | 5349 | James Polk P000409 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 6 | |||||||||||||
5348 | 5348 | James Polk P000409 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 6 | |||||||||||||
5334 | 5334 | Silas Wright W000770 | sen | NY | 1833-12-02 | 1837-03-03 | 3 | Jackson | |||||||||||||
5332 | 5332 | Silas Wright W000770 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 20 | |||||||||||||
5327 | 5327 | Henry Wise W000649 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 8 | |||||||||||||
5326 | 5326 | Henry Wise W000649 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
5322 | 5322 | William Wilkins W000475 | sen | PA | 1831-12-05 | 1835-03-03 | 3 | Jackson | |||||||||||||
5284 | 5284 | Romulus Saunders S000078 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
5233 | 5233 | John Jones J000240 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 3 | |||||||||||||
5228 | 5228 | Cave Johnson J000122 | rep | TN | 1835-12-07 | 1837-03-03 | Jackson | 11 | |||||||||||||
5227 | 5227 | Cave Johnson J000122 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 11 | |||||||||||||
5226 | 5226 | Cave Johnson J000122 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 8 | |||||||||||||
5225 | 5225 | Cave Johnson J000122 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
5212 | 5212 | Edward Hannegan H000167 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 7 | |||||||||||||
5191 | 5191 | David Dickinson D000318 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
5169 | 5169 | Walter Coles C000625 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 6 | |||||||||||||
5154 | 5154 | John Campbell C000090 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
5129 | 5129 | Samuel Beardsley B000281 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 17 | |||||||||||||
5128 | 5128 | Samuel Beardsley B000281 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 17 | |||||||||||||
5127 | 5127 | Samuel Beardsley B000281 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 14 | |||||||||||||
5112 | 5112 | William Allen A000150 | rep | OH | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
5104 | 5104 | George McDuffie M000426 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
5103 | 5103 | George McDuffie M000426 | rep | SC | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
5102 | 5102 | George McDuffie M000426 | rep | SC | 1825-12-05 | 1827-03-03 | Jackson | 5 | |||||||||||||
5088 | 5088 | Levi Woodbury W000711 | sen | NH | 1825-12-05 | 1831-03-03 | 3 | Jackson | |||||||||||||
5052 | 5052 | Aaron Ward W000125 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 4 | |||||||||||||
5051 | 5051 | Aaron Ward W000125 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 4 | |||||||||||||
5050 | 5050 | Aaron Ward W000125 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
4997 | 4997 | Charles Sewall S000258 | rep | MD | 1831-12-05 | 1833-03-03 | Jackson | 6 | |||||||||||||
4983 | 4983 | William Russell R000540 | rep | OH | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
4982 | 4982 | William Russell R000540 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
4981 | 4981 | William Russell R000540 | rep | OH | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
4976 | 4976 | James Rogers R000396 | rep | SC | 1835-12-07 | 1837-03-03 | Jackson | 7 | |||||||||||||
4973 | 4973 | William Rives R000285 | sen | VA | 1832-01-01 | 1835-03-03 | 2 | Jackson | |||||||||||||
4971 | 4971 | William Rives R000285 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 10 | |||||||||||||
4970 | 4970 | William Rives R000285 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 10 | |||||||||||||
4962 | 4962 | John Reynolds R000174 | rep | IL | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
4961 | 4961 | John Reynolds R000174 | rep | IL | 1833-12-02 | 1835-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);