legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
248 rows where "start" is on date 1829-12-07 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3054 | 3054 | Samuel Bell B000345 | sen | NH | 1829-12-07 | 1835-03-03 | 2 | ||||||||||||||
3056 | 3056 | George Bibb B000433 | sen | KY | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
3081 | 3081 | Mahlon Dickerson D000308 | sen | NJ | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
3089 | 3089 | Charles Dudley D000511 | sen | NY | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
3104 | 3104 | Theodore Frelinghuysen F000373 | sen | NJ | 1829-12-07 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
3120 | 3120 | Robert Hayne H000398 | sen | SC | 1829-12-07 | 1833-03-03 | 2 | Nullifier | |||||||||||||
3168 | 3168 | Edward Livingston L000366 | sen | LA | 1829-12-07 | 1831-12-31 | 2 | Jackson | |||||||||||||
3178 | 3178 | John McLean M000550 | sen | IL | 1829-12-07 | 1831-03-03 | 2 | Jackson | |||||||||||||
3192 | 3192 | Thomas Reed R000129 | sen | MS | 1829-12-07 | 1829-12-31 | 2 | ||||||||||||||
3209 | 3209 | Nathaniel Silsbee S000411 | sen | MA | 1829-12-07 | 1835-03-03 | 2 | Adams | |||||||||||||
3220 | 3220 | Peleg Sprague S000744 | sen | ME | 1829-12-07 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
3243 | 3243 | Littleton Tazewell T000108 | sen | VA | 1829-12-07 | 1833-03-03 | 2 | Jackson | |||||||||||||
3256 | 3256 | George Troup T000382 | sen | GA | 1829-12-07 | 1833-11-08 | 2 | Jackson | |||||||||||||
3389 | 3389 | John Forsyth F000284 | sen | GA | 1829-12-07 | 1831-03-03 | 3 | Jackson | |||||||||||||
3853 | 3853 | Bedford Brown B000903 | sen | NC | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
3979 | 3979 | Nehemiah Knight K000287 | sen | RI | 1829-12-07 | 1835-03-03 | 2 | Whig | |||||||||||||
4104 | 4104 | Hugh White W000376 | sen | TN | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
4494 | 4494 | Felix Grundy G000509 | sen | TN | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
5875 | 5875 | William King K000217 | sen | AL | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
6549 | 6549 | John Clayton C000496 | sen | DE | 1829-12-07 | 1835-03-03 | 2 | ||||||||||||||
3057 | 3057 | John Biddle B000441 | rep | MI | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3117 | 3117 | Jonathan Harvey H000308 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3131 | 3131 | Gabriel Holmes H000737 | rep | NC | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3144 | 3144 | Samuel Ingham I000022 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3189 | 3189 | Isaac Pierson P000341 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3240 | 3240 | Samuel Swan S001088 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3321 | 3321 | John Brodhead B000858 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3333 | 3333 | Thomas Chandler C000294 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3345 | 3345 | Lewis Condict C000668 | rep | NJ | 1829-12-07 | 1831-03-03 | Republican | -1 | |||||||||||||
3350 | 3350 | Richard Cooper C000760 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3396 | 3396 | Joseph Hammons H000137 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3417 | 3417 | Thomas Hughes H000928 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3426 | 3426 | Ralph Ingersoll I000020 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3449 | 3449 | Henry Lamar L000027 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3533 | 3533 | James Randolph R000044 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3566 | 3566 | Wiley Thompson T000222 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3581 | 3581 | John Weeks W000245 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3599 | 3599 | Noyes Barber B000125 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3634 | 3634 | Tristam Burges B001082 | rep | RI | 1829-12-07 | 1831-03-03 | Anti Jacksonian | -1 | |||||||||||||
3669 | 3669 | William Ellsworth E000150 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3822 | 3822 | Richard Wilde W000460 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3826 | 3826 | Ebenezer Young Y000034 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3940 | 3940 | Henry Hubbard H000883 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4032 | 4032 | Dutee Pearce P000160 | rep | RI | 1829-12-07 | 1831-03-03 | Anti Mason | -1 | |||||||||||||
4095 | 4095 | James Wayne W000218 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4108 | 4108 | Joseph White W000383 | rep | FL | 1829-12-07 | 1831-03-03 | -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 | |||||||||||||
4616 | 4616 | William Storrs S000977 | rep | CT | 1829-12-07 | 1831-03-03 | Whig | -1 | |||||||||||||
4793 | 4793 | Thomas Foster F000314 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4972 | 4972 | William Rives R000285 | rep | VA | 1829-12-07 | 1831-03-03 | Jacksonian | -1 | |||||||||||||
5290 | 5290 | Ambrose Sevier S000256 | rep | AR | 1829-12-07 | 1831-03-03 | Jacksonian | -1 | |||||||||||||
5321 | 5321 | William Wilkins W000475 | rep | PA | 1829-12-07 | 1831-03-03 | Democrat | -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 | ||||||||||||||
3088 | 3088 | Clement Dorsey D000437 | rep | MD | 1829-12-07 | 1831-03-03 | 1 | ||||||||||||||
3128 | 3128 | Thomas Hinds H000632 | rep | MS | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3187 | 3187 | Spencer Pettis P000275 | rep | MO | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3361 | 3361 | Henry Daniel D000033 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3372 | 3372 | William Drayton D000490 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3378 | 3378 | James Findlay F000119 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3420 | 3420 | Jonathan Hunt H000974 | rep | VT | 1829-12-07 | 1831-03-03 | 1 | ||||||||||||||
3455 | 3455 | James Lent L000242 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3518 | 3518 | Thomas Newton N000078 | rep | VA | 1829-12-07 | 1831-03-03 | Republican | 1 | |||||||||||||
3622 | 3622 | John Blair B000528 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3666 | 3666 | Joseph Duncan D000535 | rep | IL | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3689 | 3689 | Benjamin Gorham G000324 | rep | MA | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 1 | |||||||||||||
3747 | 3747 | Rufus McIntire M000479 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3997 | 3997 | George Loyall L000488 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4058 | 4058 | William Shepard S000331 | rep | NC | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
4073 | 4073 | Joel Sutherland S001083 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4135 | 4135 | Ratliff Boon B000628 | rep | IN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4172 | 4172 | Clement Clay C000481 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
5060 | 5060 | Edward White W000365 | rep | LA | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
3033 | 3033 | Willis Alston A000167 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3051 | 3051 | Robert Baylor B000257 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3067 | 3067 | Nicholas Coleman C000620 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3071 | 3071 | Jacob Crocheron C000915 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3075 | 3075 | Benjamin Crowninshield C000946 | rep | MA | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3113 | 3113 | Henry Gurley G000529 | rep | LA | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3126 | 3126 | Joseph Hemphill H000470 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3154 | 3154 | Jonathan Jennings J000097 | rep | IN | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3160 | 3160 | Pryor Lea L000166 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3203 | 3203 | James Shields S000361 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3249 | 3249 | James Trezvant T000365 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3299 | 3299 | John Anderson A000193 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3462 | 3462 | Rollin Mallary M000079 | rep | VT | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3541 | 3541 | Benedict Semmes S000238 | rep | MD | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
6180 | 6180 | Robert Barnwell B000168 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3066 | 3066 | James Clark C000436 | rep | KY | 1829-12-07 | 1831-03-03 | Republican | 3 | |||||||||||||
3182 | 3182 | Daniel Miller M000722 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3186 | 3186 | Walter Overton O000147 | rep | LA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3246 | 3246 | John Test T000138 | rep | IN | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3266 | 3266 | John Varnum V000073 | rep | MA | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3270 | 3270 | Joseph Wingate W000632 | rep | ME | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3578 | 3578 | Gulian Verplanck V000089 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3696 | 3696 | Thomas Hall H000072 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3880 | 3880 | Joseph Crane C000872 | rep | OH | 1829-12-07 | 1831-03-03 | Whig | 3 | |||||||||||||
4092 | 4092 | George Washington W000179 | rep | MD | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 3 | |||||||||||||
4099 | 4099 | Campbell White W000358 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 3 |
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);