legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
273 rows where "end" is on date 1851-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5889 | 5889 | Nathaniel Albertson A000075 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5890 | 5890 | Henry Alexander A000093 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 17 | |||||||||||||
6208 | 6208 | Charles Allen A000115 | rep | MA | 1849-12-03 | 1851-03-03 | Free Soil | 5 | |||||||||||||
5891 | 5891 | William Alston A000166 | rep | AL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
5892 | 5892 | Josiah Anderson A000199 | rep | TN | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
5893 | 5893 | George Andrews A000245 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 14 | |||||||||||||
6491 | 6491 | William Ashe A000310 | rep | NC | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
5896 | 5896 | George Ashmun A000318 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
6212 | 6212 | Thomas Averett A000343 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
7643 | 7643 | Edward Baker B000059 | rep | IL | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
5606 | 5606 | Roger Baldwin B000096 | sen | CT | 1847-12-06 | 1851-03-03 | 1 | Whig | |||||||||||||
6182 | 6182 | Robert Barnwell B000168 | sen | SC | 1850-01-01 | 1851-03-03 | 2 | Democrat | |||||||||||||
5901 | 5901 | William Bay B000247 | rep | MO | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6765 | 6765 | Thomas Bayly B000259 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6219 | 6219 | James Beale B000266 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 14 | |||||||||||||
5902 | 5902 | John Bell B000339 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
6976 | 6976 | Henry Bennett B000376 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 22 | |||||||||||||
6516 | 6516 | Thomas Benton B000398 | sen | MO | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
7293 | 7293 | Kinsley Bingham B000473 | rep | MI | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6518 | 6518 | William Bissell B000492 | rep | IL | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
7296 | 7296 | Thomas Bocock B000582 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
5903 | 5903 | David Bokee B000599 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5904 | 5904 | Walter Booth B000631 | rep | CT | 1849-12-03 | 1851-03-03 | Free Soil | 2 | |||||||||||||
5907 | 5907 | Franklin Bowdon B000680 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6223 | 6223 | Richard Bowie B000694 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
5911 | 5911 | James Bowlin B000701 | rep | MO | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6528 | 6528 | Linn Boyd B000719 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5912 | 5912 | Daniel Breck B000782 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
7317 | 7317 | George Briggs B000829 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
6991 | 6991 | Jesse Bright B000835 | sen | IN | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5913 | 5913 | John Brisbin B000841 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 11 | |||||||||||||
9100 | 9100 | James Brooks B000881 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
7324 | 7324 | Albert Brown B000900 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
5915 | 5915 | William Brown B000950 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
5916 | 5916 | Alexander Buel B001037 | rep | MI | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5919 | 5919 | Henry Bullard B001049 | rep | LA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6234 | 6234 | Lorenzo Burrows B001143 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 34 | |||||||||||||
6239 | 6239 | Armistead Burt B001145 | rep | SC | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
5921 | 5921 | Chester Butler B001175 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 11 | |||||||||||||
5922 | 5922 | Thomas Butler B001191 | rep | CT | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6244 | 6244 | Edward Cabell C000003 | rep | FL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6246 | 6246 | Joseph Cable C000008 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 17 | |||||||||||||
5924 | 5924 | George Caldwell C000031 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6248 | 6248 | Joseph Caldwell C000037 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5641 | 5641 | John Calhoun C000044 | sen | SC | 1847-12-06 | 1851-03-03 | 2 | Democrat | |||||||||||||
5925 | 5925 | Samuel Calvin C000060 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 17 | |||||||||||||
8848 | 8848 | Lewis Campbell C000096 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6251 | 6251 | David Cartter C000206 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 18 | |||||||||||||
5926 | 5926 | Joseph Casey C000224 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 13 | |||||||||||||
6254 | 6254 | Lewis Cass C000233 | sen | MI | 1849-12-03 | 1851-03-03 | 1 | Democrat | |||||||||||||
6535 | 6535 | Joseph Chandler C000292 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5927 | 5927 | Charles Clarke C000459 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 19 | |||||||||||||
6258 | 6258 | Chauncey Cleveland C000511 | rep | CT | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
7262 | 7262 | Thomas Clingman C000524 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6791 | 6791 | Howell Cobb C000548 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
7348 | 7348 | Williamson Cobb C000554 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6260 | 6260 | William Colcock C000603 | rep | SC | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
5941 | 5941 | Orsamus Cole C000611 | rep | WI | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5943 | 5943 | Harmon Conger C000676 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 25 | |||||||||||||
5945 | 5945 | Charles Conrad C000703 | rep | LA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6554 | 6554 | Moses Corwin C000790 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
7715 | 7715 | Thomas Corwin C000791 | sen | OH | 1845-12-01 | 1851-03-03 | 1 | Whig | |||||||||||||
5950 | 5950 | John Crowell C000941 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 19 | |||||||||||||
6268 | 6268 | John Daniel D000034 | rep | NC | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
5951 | 5951 | Joel Danner D000045 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 15 | |||||||||||||
7021 | 7021 | Jefferson Davis D000113 | sen | MS | 1847-12-06 | 1851-03-03 | 1 | Democrat | |||||||||||||
5407 | 5407 | William Dayton D000166 | sen | NJ | 1845-12-01 | 1851-03-03 | 1 | Whig | |||||||||||||
5964 | 5964 | Edmund Deberry D000181 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
5965 | 5965 | Jesse Dickey D000313 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
5338 | 5338 | Daniel Dickinson D000317 | sen | NY | 1845-03-04 | 1851-03-03 | 1 | Democrat | |||||||||||||
5967 | 5967 | Rodolphus Dickinson D000325 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6272 | 6272 | Milo Dimmick D000350 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6566 | 6566 | David Disney D000361 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
8575 | 8575 | Nathan Dixon D000375 | rep | RI | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6278 | 6278 | Henry Dodge D000396 | sen | WI | 1848-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6282 | 6282 | James Doty D000443 | rep | WI | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
5969 | 5969 | William Duer D000515 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 23 | |||||||||||||
6284 | 6284 | James Duncan D000532 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6571 | 6571 | Cyrus Dunham D000540 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6806 | 6806 | Charles Durkee D000573 | rep | WI | 1849-12-03 | 1851-03-03 | Free Soil | 1 | |||||||||||||
7391 | 7391 | Henry Edmundson E000058 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 12 | |||||||||||||
5970 | 5970 | Samuel Eliot E000105 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6185 | 6185 | Franklin Elmore E000158 | sen | SC | 1850-01-01 | 1851-03-03 | 2 | Democrat | |||||||||||||
6287 | 6287 | Alexander Evans E000231 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
5972 | 5972 | Nathan Evans E000255 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 14 | |||||||||||||
5973 | 5973 | Andrew Ewing E000275 | rep | TN | 1849-12-03 | 1851-03-03 | Democrat | 8 | |||||||||||||
6187 | 6187 | Thomas Ewing E000281 | sen | OH | 1850-01-01 | 1851-03-03 | 1 | Whig | |||||||||||||
5975 | 5975 | Winfield Featherston F000055 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
7044 | 7044 | Graham Fitch F000158 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 9 | |||||||||||||
6299 | 6299 | Orin Fowler F000325 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 9 | |||||||||||||
5977 | 5977 | John Freedley F000360 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
6188 | 6188 | John Frémont F000374 | sen | CA | 1850-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6820 | 6820 | Thomas Fuller F000412 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6307 | 6307 | Meredith Gentry G000125 | rep | TN | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
5978 | 5978 | Elbridge Gerry G000138 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
7054 | 7054 | Joshua Giddings G000167 | rep | OH | 1849-12-03 | 1851-03-03 | Free Soil | 20 | |||||||||||||
8602 | 8602 | Abijah Gilbert G000171 | rep | CA | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
5979 | 5979 | Edward Gilbert G000172 | rep | CA | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
6310 | 6310 | Alfred Gilmore G000220 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 24 | |||||||||||||
5980 | 5980 | Rufus Goodenow G000285 | rep | ME | 1849-12-03 | 1851-03-03 | Whig | 4 |
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);