legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
283 rows where "start" is on date 1835-12-07 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3830 | 3830 | Benjamin Leigh L000232 | sen | VA | 1835-12-07 | 1836-07-04 | 2 | Anti-Jacksonian | |||||||||||||
3854 | 3854 | Bedford Brown B000903 | sen | NC | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
3899 | 3899 | William Ewing E000283 | sen | IL | 1835-12-07 | 1837-03-03 | 3 | Jackson | |||||||||||||
3912 | 3912 | Robert Goldsborough G000264 | sen | MD | 1835-12-07 | 1837-03-03 | 3 | Whig | |||||||||||||
3943 | 3943 | Henry Hubbard H000883 | sen | NH | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
3974 | 3974 | John King K000207 | sen | GA | 1835-12-07 | 1837-12-31 | 2 | Democrat | |||||||||||||
3980 | 3980 | Nehemiah Knight K000287 | sen | RI | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4050 | 4050 | John Robinson R000344 | sen | IL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4051 | 4051 | John Ruggles R000502 | sen | ME | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4087 | 4087 | Garret Wall W000071 | sen | NJ | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4105 | 4105 | Hugh White W000376 | sen | TN | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4189 | 4189 | Alfred Cuthbert C001023 | sen | GA | 1835-12-07 | 1837-03-03 | 3 | Jackson | |||||||||||||
5045 | 5045 | Robert Walker W000067 | sen | MS | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5256 | 5256 | John Niles N000108 | sen | CT | 1835-12-07 | 1839-03-03 | 1 | Democrat | |||||||||||||
5638 | 5638 | John Calhoun C000044 | sen | SC | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5668 | 5668 | John Davis D000117 | sen | MA | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
5876 | 5876 | William King K000217 | sen | AL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
6550 | 6550 | John Clayton C000496 | sen | DE | 1835-12-07 | 1837-03-03 | 2 | ||||||||||||||
7723 | 7723 | John Crittenden C000912 | sen | KY | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
3839 | 3839 | William Ashley A000315 | rep | MO | 1835-12-07 | 1837-03-03 | Jacksonian | -1 | |||||||||||||
3846 | 3846 | Benning Bean B000277 | rep | NH | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
3860 | 3860 | Robert Burns B001129 | rep | NH | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
3867 | 3867 | William Chetwood C000349 | rep | NJ | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
3877 | 3877 | John Coffee C000583 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
3888 | 3888 | Warren Davis D000142 | rep | SC | 1835-12-07 | 1837-03-03 | Nullifier | -1 | |||||||||||||
3893 | 3893 | David Dickson D000328 | rep | MS | 1835-12-07 | 1837-03-03 | Anti-Jacksonian | -1 | |||||||||||||
3904 | 3904 | Samuel Fowler F000327 | rep | NJ | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
3969 | 3969 | Andrew Judson J000279 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
3995 | 3995 | Thomas Lee L000205 | rep | NJ | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4025 | 4025 | James Parker P000061 | rep | NJ | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4035 | 4035 | Dutee Pearce P000160 | rep | RI | 1835-12-07 | 1837-03-03 | Anti Masonic | -1 | |||||||||||||
4052 | 4052 | John Sanford S000049 | rep | GA | 1835-12-07 | 1837-03-03 | Union Democrat | -1 | |||||||||||||
4054 | 4054 | Ferdinand Schenck S000116 | rep | NJ | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4056 | 4056 | William Schley S000130 | rep | GA | 1835-12-07 | 1837-03-03 | Jacksonian | -1 | |||||||||||||
4063 | 4063 | William Shinn S000365 | rep | NJ | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4077 | 4077 | James Terrell T000130 | rep | GA | 1835-12-07 | 1837-03-03 | -1 | ||||||||||||||
4098 | 4098 | James Wayne W000218 | rep | GA | 1835-12-07 | 1837-03-03 | Jacksonian | -1 | |||||||||||||
4102 | 4102 | Campbell White W000358 | rep | NY | 1835-12-07 | 1837-03-03 | Jacksonian | -1 | |||||||||||||
4111 | 4111 | Joseph White W000383 | rep | FL | 1835-12-07 | 1837-03-03 | -1 | ||||||||||||||
4112 | 4112 | Zalmon Wildman W000463 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4170 | 4170 | John Claiborne C000404 | rep | MS | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4176 | 4176 | Jesse Cleveland C000513 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4181 | 4181 | Samuel Cushman C001021 | rep | NH | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4205 | 4205 | Samuel Gholson G000149 | rep | MS | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
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 | |||||||||||||
4219 | 4219 | Elisha Haley H000040 | rep | CT | 1835-12-07 | 1837-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 | |||||||||||||
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 | |||||||||||||
4247 | 4247 | Jabez Jackson J000015 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4306 | 4306 | George Owens O000157 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4317 | 4317 | Lancelot Phelps P000297 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4373 | 4373 | Joseph Weeks W000247 | rep | NH | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4383 | 4383 | Thomas Whittlesey W000433 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4459 | 4459 | Philemon Dickerson D000309 | rep | NJ | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4500 | 4500 | Albert Harrison H000261 | rep | MO | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4658 | 4658 | Julius Alford A000104 | rep | GA | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
5109 | 5109 | William Sprague S000746 | rep | RI | 1835-12-07 | 1837-03-03 | Anti Masonic | -1 | |||||||||||||
5293 | 5293 | Ambrose Sevier S000256 | rep | AR | 1835-12-07 | 1836-06-15 | Jacksonian | -1 | |||||||||||||
5546 | 5546 | George Towns T000327 | rep | GA | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
5952 | 5952 | William Dawson D000156 | rep | GA | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
6476 | 6476 | Isaac Toucey T000319 | rep | CT | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
6484 | 6484 | Franklin Pierce P000333 | rep | NH | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
6629 | 6629 | George Jones J000221 | rep | MI | 1835-12-07 | 1837-03-03 | Democrat | -1 | |||||||||||||
4288 | 4288 | John Milligan M000767 | rep | DE | 1835-12-07 | 1837-03-03 | Whig | 0 | |||||||||||||
3945 | 3945 | Abel Huntington H000994 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
3999 | 3999 | George Loyall L000488 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
4041 | 4041 | Henry Pinckney P000355 | rep | SC | 1835-12-07 | 1837-03-03 | Nullifier | 1 | |||||||||||||
4061 | 4061 | William Shepard S000331 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4070 | 4070 | John Steele S000834 | rep | MD | 1835-12-07 | 1837-03-03 | Anti Jacksonian | 1 | |||||||||||||
4071 | 4071 | Bellamy Storer S000971 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4076 | 4076 | Joel Sutherland S001083 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
4138 | 4138 | Ratliff Boon B000628 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
4419 | 4419 | William Carter C000204 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4443 | 4443 | Isaac Crary C000882 | rep | MI | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
4532 | 4532 | Abbott Lawrence L000130 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4817 | 4817 | Hiland Hall H000052 | rep | VT | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4962 | 4962 | John Reynolds R000174 | rep | IL | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
5345 | 5345 | Henry Johnson J000137 | rep | LA | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
5379 | 5379 | Reuben Chapman C000316 | rep | AL | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
5420 | 5420 | John Fairfield F000006 | rep | ME | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
5581 | 5581 | Archibald Yell Y000017 | rep | AR | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
6522 | 6522 | Linn Boyd B000719 | rep | KY | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
3844 | 3844 | Samuel Barton B000215 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
3858 | 3858 | Samuel Bunch B001058 | rep | TN | 1835-12-07 | 1837-03-03 | Jacksonian | 2 | |||||||||||||
3914 | 3914 | William Grayson G000404 | rep | SC | 1835-12-07 | 1837-03-03 | Nullifier | 2 | |||||||||||||
3925 | 3925 | James Harper H000221 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
3930 | 3930 | Albert Hawes H000360 | rep | KY | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4008 | 4008 | John Mason M000220 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4270 | 4270 | Joshua Martin M000192 | rep | AL | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4320 | 4320 | Stephen Phillips P000312 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
4348 | 4348 | Francis Smith S000531 | rep | ME | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4371 | 4371 | Taylor Webster W000241 | rep | OH | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4411 | 4411 | Jesse Bynum B001204 | rep | NC | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4596 | 4596 | Eleazar Ripley R000265 | rep | LA | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4731 | 4731 | Zadok Casey C000230 | rep | IL | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
5006 | 5006 | William Slade S000475 | rep | VT | 1835-12-07 | 1837-03-03 | Anti Masonic | 2 | |||||||||||||
5399 | 5399 | John Davis D000120 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 2 |
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);