legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
247 rows where "end" is on date 1831-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3051 | 3051 | Robert Baylor B000257 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
4172 | 4172 | Clement Clay C000481 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4282 | 4282 | John McKinley M000519 | sen | AL | 1826-01-01 | 1831-03-03 | 3 | Jackson | |||||||||||||
5755 | 5755 | Dixon Lewis L000278 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
5290 | 5290 | Ambrose Sevier S000256 | rep | AR | 1829-12-07 | 1831-03-03 | Jacksonian | -1 | |||||||||||||
2736 | 2736 | Calvin Willey W000482 | sen | CT | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
3426 | 3426 | Ralph Ingersoll I000020 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3599 | 3599 | Noyes Barber B000125 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3669 | 3669 | William Ellsworth E000150 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3826 | 3826 | Ebenezer Young Y000034 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
4616 | 4616 | William Storrs S000977 | rep | CT | 1829-12-07 | 1831-03-03 | Whig | -1 | |||||||||||||
5449 | 5449 | Jabez Huntington H000997 | rep | CT | 1829-12-07 | 1831-03-03 | Whig | -1 | |||||||||||||
3156 | 3156 | Kensey Johns J000112 | rep | DE | 1829-12-07 | 1831-03-03 | 0 | ||||||||||||||
4108 | 4108 | Joseph White W000383 | rep | FL | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3389 | 3389 | John Forsyth F000284 | sen | GA | 1829-12-07 | 1831-03-03 | 3 | Jackson | |||||||||||||
3449 | 3449 | Henry Lamar L000027 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3566 | 3566 | Wiley Thompson T000222 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3822 | 3822 | Richard Wilde W000460 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4095 | 4095 | James Wayne W000218 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4229 | 4229 | Charles Haynes H000399 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4265 | 4265 | Wilson Lumpkin L000512 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4793 | 4793 | Thomas Foster F000314 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
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 | |||||||||||||
3666 | 3666 | Joseph Duncan D000535 | rep | IL | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3154 | 3154 | Jonathan Jennings J000097 | rep | IN | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3246 | 3246 | John Test T000138 | rep | IN | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3403 | 3403 | William Hendricks H000494 | sen | IN | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
4135 | 4135 | Ratliff Boon B000628 | rep | IN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
2711 | 2711 | John Rowan R000471 | sen | KY | 1825-12-05 | 1831-03-03 | 3 | Jackson | |||||||||||||
3066 | 3066 | James Clark C000436 | rep | KY | 1829-12-07 | 1831-03-03 | Republican | 3 | |||||||||||||
3067 | 3067 | Nicholas Coleman C000620 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3157 | 3157 | John Kincaid K000186 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3276 | 3276 | Joel Yancey Y000002 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
3361 | 3361 | Henry Daniel D000033 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3391 | 3391 | Nathan Gaither G000010 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3453 | 3453 | Joseph Lecompte L000186 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3640 | 3640 | Thomas Chilton C000359 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3726 | 3726 | Robert Letcher L000257 | rep | KY | 1829-12-07 | 1831-03-03 | 4 | ||||||||||||||
3731 | 3731 | Chittenden Lyon L000541 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3963 | 3963 | Richard Johnson J000170 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
7885 | 7885 | Charles Wickliffe W000442 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3113 | 3113 | Henry Gurley G000529 | rep | LA | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3186 | 3186 | Walter Overton O000147 | rep | LA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3439 | 3439 | Josiah Johnston J000194 | sen | LA | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
5060 | 5060 | Edward White W000365 | rep | LA | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
3038 | 3038 | John Bailey B000041 | rep | MA | 1829-12-07 | 1831-03-03 | 10 | ||||||||||||||
3075 | 3075 | Benjamin Crowninshield C000946 | rep | MA | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3095 | 3095 | Henry Dwight D000579 | rep | MA | 1829-12-07 | 1831-03-03 | 9 | ||||||||||||||
3194 | 3194 | Joseph Richardson R000226 | rep | MA | 1829-12-07 | 1831-03-03 | 11 | ||||||||||||||
3266 | 3266 | John Varnum V000073 | rep | MA | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3407 | 3407 | James Hodges H000674 | rep | MA | 1829-12-07 | 1831-03-03 | 12 | ||||||||||||||
3443 | 3443 | Joseph Kendall K000094 | rep | MA | 1829-12-07 | 1831-03-03 | 6 | ||||||||||||||
3689 | 3689 | Benjamin Gorham G000324 | rep | MA | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 1 | |||||||||||||
4214 | 4214 | George Grennell G000451 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 7 | |||||||||||||
4590 | 4590 | John Reed R000121 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
4688 | 4688 | Isaac Bates B000233 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 8 | |||||||||||||
5665 | 5665 | John Davis D000117 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 5 | |||||||||||||
6584 | 6584 | Edward Everett E000264 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
3059 | 3059 | Elias Brown B000912 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3088 | 3088 | Clement Dorsey D000437 | rep | MD | 1829-12-07 | 1831-03-03 | 1 | ||||||||||||||
3217 | 3217 | Richard Spencer S000729 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3222 | 3222 | Michael Sprigg S000751 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3268 | 3268 | Ephraim Wilson W000576 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3331 | 3331 | Ezekiel Chambers C000282 | sen | MD | 1826-01-01 | 1831-03-03 | 3 | Adams | |||||||||||||
3485 | 3485 | George Mitchell M000810 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3541 | 3541 | Benedict Semmes S000238 | rep | MD | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
4092 | 4092 | George Washington W000179 | rep | MD | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 3 | |||||||||||||
4238 | 4238 | Benjamin Howard H000835 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3061 | 3061 | Samuel Butman B001198 | rep | ME | 1829-12-07 | 1831-03-03 | 7 | ||||||||||||||
3197 | 3197 | James Ripley R000266 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3270 | 3270 | Joseph Wingate W000632 | rep | ME | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3299 | 3299 | John Anderson A000193 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3414 | 3414 | Cornelius Holland H000715 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3747 | 3747 | Rufus McIntire M000479 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3951 | 3951 | Leonard Jarvis J000062 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
4773 | 4773 | George Evans E000241 | rep | ME | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
3057 | 3057 | John Biddle B000441 | rep | MI | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
2558 | 2558 | David Barton B000212 | sen | MO | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
3187 | 3187 | Spencer Pettis P000275 | rep | MO | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3128 | 3128 | Thomas Hinds H000632 | rep | MS | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3277 | 3277 | Robert Adams A000043 | sen | MS | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
3018 | 3018 | James Iredell I000028 | sen | NC | 1828-01-01 | 1831-03-03 | 3 | Jackson | |||||||||||||
3033 | 3033 | Willis Alston A000167 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3090 | 3090 | Edward Dudley D000512 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3131 | 3131 | Gabriel Holmes H000737 | rep | NC | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3329 | 3329 | Samuel Carson C000193 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3527 | 3527 | Robert Potter P000467 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3605 | 3605 | Daniel Barringer B000181 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3696 | 3696 | Thomas Hall H000072 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
4058 | 4058 | William Shepard S000331 | rep | NC | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
4429 | 4429 | Henry Connor C000700 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
4955 | 4955 | Abraham Rencher R000162 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
5077 | 5077 | Lewis Williams W000527 | rep | NC | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
5524 | 5524 | Jesse Speight S000715 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
5957 | 5957 | Edmund Deberry D000181 | rep | NC | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 7 | |||||||||||||
6115 | 6115 | Augustine Shepperd S000338 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3117 | 3117 | Jonathan Harvey H000308 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3321 | 3321 | John Brodhead B000858 | rep | NH | 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);