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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3285 | 3285 | John Adair A000026 | rep | KY | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
3593 | 3593 | John Adams A000038 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
3277 | 3277 | Robert Adams A000043 | sen | MS | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
2762 | 2762 | William Addams A000053 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 7 | |||||||||||||
2763 | 2763 | William Addams A000053 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 7 | |||||||||||||
2548 | 2548 | Adam Alexander A000089 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
3289 | 3289 | Mark Alexander A000099 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 4 | |||||||||||||
3290 | 3290 | Mark Alexander A000099 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 4 | |||||||||||||
3291 | 3291 | Mark Alexander A000099 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3292 | 3292 | Mark Alexander A000099 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
2552 | 2552 | Robert Allen A000142 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 5 | |||||||||||||
3293 | 3293 | Robert Allen A000143 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 17 | |||||||||||||
3294 | 3294 | Robert Allen A000143 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 17 | |||||||||||||
3295 | 3295 | Robert Allen A000143 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 17 | |||||||||||||
5112 | 5112 | William Allen A000150 | rep | OH | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
3031 | 3031 | Willis Alston A000167 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
3032 | 3032 | Willis Alston A000167 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3033 | 3033 | Willis Alston A000167 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3297 | 3297 | John Anderson A000193 | rep | ME | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
3298 | 3298 | John Anderson A000193 | rep | ME | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3299 | 3299 | John Anderson A000193 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3300 | 3300 | John Anderson A000193 | rep | ME | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
3302 | 3302 | William Angel A000256 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 13 | |||||||||||||
3303 | 3303 | William Angel A000256 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 13 | |||||||||||||
3834 | 3834 | Joseph Anthony A000263 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 16 | |||||||||||||
3835 | 3835 | Joseph Anthony A000263 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 16 | |||||||||||||
4670 | 4670 | William Archer A000275 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
4671 | 4671 | William Archer A000275 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
4672 | 4672 | William Archer A000275 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
4673 | 4673 | William Archer A000275 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
4674 | 4674 | William Archer A000275 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3836 | 3836 | Michael Ash A000305 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 3 | |||||||||||||
2555 | 2555 | Henry Ashley A000313 | rep | NY | 1825-12-05 | 1827-03-03 | Jackson | 11 | |||||||||||||
3278 | 3278 | David Baker B000058 | sen | IL | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
3310 | 3310 | John Barbour B000128 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 15 | |||||||||||||
3311 | 3311 | John Barbour B000128 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 15 | |||||||||||||
3312 | 3312 | John Barbour B000128 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 15 | |||||||||||||
3313 | 3313 | John Barbour B000128 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 15 | |||||||||||||
3045 | 3045 | Philip Barbour B000131 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 11 | |||||||||||||
3046 | 3046 | Philip Barbour B000131 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
2774 | 2774 | Stephen Barlow B000150 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 18 | |||||||||||||
2775 | 2775 | Isaac Barnard B000154 | sen | PA | 1827-12-03 | 1831-12-31 | 1 | Jackson | |||||||||||||
6180 | 6180 | Robert Barnwell B000168 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3603 | 3603 | Daniel Barringer B000181 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 8 | |||||||||||||
3604 | 3604 | Daniel Barringer B000181 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 8 | |||||||||||||
3605 | 3605 | Daniel Barringer B000181 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3606 | 3606 | Daniel Barringer B000181 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 8 | |||||||||||||
3844 | 3844 | Samuel Barton B000215 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
2789 | 2789 | Burwell Bassett B000224 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 8 | |||||||||||||
2790 | 2790 | Burwell Bassett B000224 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 8 | |||||||||||||
3315 | 3315 | James Bates B000234 | rep | ME | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
2561 | 2561 | Francis Baylies B000255 | rep | MA | 1825-12-05 | 1827-03-03 | Jackson | 12 | |||||||||||||
3051 | 3051 | Robert Baylor B000257 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
6217 | 6217 | James Beale B000266 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 16 | |||||||||||||
6218 | 6218 | James Beale B000266 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 16 | |||||||||||||
3845 | 3845 | Benning Bean B000277 | rep | NH | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3846 | 3846 | Benning Bean B000277 | rep | NH | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
5127 | 5127 | Samuel Beardsley B000281 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 14 | |||||||||||||
5128 | 5128 | Samuel Beardsley B000281 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 17 | |||||||||||||
5129 | 5129 | Samuel Beardsley B000281 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 17 | |||||||||||||
3847 | 3847 | Andrew Beaumont B000286 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 15 | |||||||||||||
3848 | 3848 | Andrew Beaumont B000286 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 15 | |||||||||||||
2797 | 2797 | George Belden B000324 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 7 | |||||||||||||
6503 | 6503 | John Bell B000340 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 7 | |||||||||||||
6504 | 6504 | John Bell B000340 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
6505 | 6505 | John Bell B000340 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
6506 | 6506 | John Bell B000340 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
6512 | 6512 | Thomas Benton B000398 | sen | MO | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
6513 | 6513 | Thomas Benton B000398 | sen | MO | 1827-12-03 | 1833-03-03 | 1 | Jackson | |||||||||||||
3316 | 3316 | John Bergen B000405 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
5614 | 5614 | John Berrien B000413 | sen | GA | 1825-12-05 | 1829-12-31 | 3 | Jackson | |||||||||||||
3317 | 3317 | Lauchlin Bethune B000423 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
3056 | 3056 | George Bibb B000433 | sen | KY | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
5361 | 5361 | James Black B000500 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 13 | |||||||||||||
3590 | 3590 | John Black B000503 | sen | MS | 1832-11-12 | 1833-03-03 | 1 | Jackson | |||||||||||||
3616 | 3616 | James Blair B000526 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3617 | 3617 | James Blair B000526 | rep | SC | 1831-12-05 | 1833-03-03 | Jackson | 8 | |||||||||||||
3618 | 3618 | James Blair B000526 | rep | SC | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
3620 | 3620 | John Blair B000528 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
3621 | 3621 | John Blair B000528 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3622 | 3622 | John Blair B000528 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3623 | 3623 | John Blair B000528 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
3624 | 3624 | John Blair B000528 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3849 | 3849 | Abraham Bockee B000581 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3850 | 3850 | Abraham Bockee B000581 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
3851 | 3851 | Abraham Bockee B000581 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 5 | |||||||||||||
3625 | 3625 | Charles Bodle B000585 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
4134 | 4134 | Ratliff Boon B000628 | rep | IN | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
4135 | 4135 | Ratliff Boon B000628 | rep | IN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4136 | 4136 | Ratliff Boon B000628 | rep | IN | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
4137 | 4137 | Ratliff Boon B000628 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
4138 | 4138 | Ratliff Boon B000628 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
4701 | 4701 | Nathaniel Borden B000636 | rep | MA | 1835-12-07 | 1837-03-03 | Jackson | 10 | |||||||||||||
3058 | 3058 | Peter Borst B000645 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3318 | 3318 | Joseph Bouck B000659 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 12 | |||||||||||||
4140 | 4140 | James Bouldin B000662 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
4141 | 4141 | James Bouldin B000662 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 5 | |||||||||||||
3626 | 3626 | Thomas Bouldin B000663 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3627 | 3627 | Thomas Bouldin B000663 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
3628 | 3628 | Thomas Bouldin B000663 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 5 |
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);