legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
263 rows where "start" is on date 1847-12-06 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5590 | 5590 | Amos Abbott A000004 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
7272 | 7272 | Green Adams A000036 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5600 | 5600 | John Adams A000041 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5602 | 5602 | Chester Ashley A000311 | sen | AR | 1847-12-06 | 1849-03-03 | 2 | Democrat | |||||||||||||
5895 | 5895 | George Ashmun A000318 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5605 | 5605 | Archibald Atkinson A000328 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
5606 | 5606 | Roger Baldwin B000096 | sen | CT | 1847-12-06 | 1851-03-03 | 1 | Whig | |||||||||||||
5609 | 5609 | Daniel Barringer B000182 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5610 | 5610 | Washington Barrow B000185 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
6764 | 6764 | Thomas Bayly B000259 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
10006 | 10006 | Richard Beale B000268 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 8 | |||||||||||||
5612 | 5612 | Henry Bedinger B000302 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
5613 | 5613 | Hiram Belcher B000321 | rep | ME | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
6510 | 6510 | John Bell B000340 | sen | TN | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5616 | 5616 | John Berrien B000413 | sen | GA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
7292 | 7292 | Kinsley Bingham B000473 | rep | MI | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
5617 | 5617 | Ausburn Birdsall B000480 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 22 | |||||||||||||
5620 | 5620 | James Black B000501 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
5621 | 5621 | Esbon Blackmar B000513 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 27 | |||||||||||||
5623 | 5623 | John Blanchard B000539 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 17 | |||||||||||||
7295 | 7295 | Thomas Bocock B000582 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5626 | 5626 | John Botts B000655 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5906 | 5906 | Franklin Bowdon B000680 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
5910 | 5910 | James Bowlin B000701 | rep | MO | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6527 | 6527 | Linn Boyd B000719 | rep | KY | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
8267 | 8267 | Nathaniel Boyden B000722 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5627 | 5627 | James Bradbury B000734 | sen | ME | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5628 | 5628 | Edward Bradley B000741 | rep | MI | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5629 | 5629 | Jasper Brady B000754 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 16 | |||||||||||||
9747 | 9747 | Samuel Bridges B000824 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
6230 | 6230 | Richard Brodhead B000861 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
7323 | 7323 | Albert Brown B000900 | rep | MS | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5631 | 5631 | Charles Brown B000906 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
7924 | 7924 | William Brown B000948 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 15 | |||||||||||||
5632 | 5632 | Aylette Buckner B001032 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6238 | 6238 | Armistead Burt B001145 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
5920 | 5920 | Chester Butler B001175 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 11 | |||||||||||||
6243 | 6243 | Edward Cabell C000003 | rep | FL | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5641 | 5641 | John Calhoun C000044 | sen | SC | 1847-12-06 | 1851-03-03 | 2 | Democrat | |||||||||||||
5642 | 5642 | Richard Canby C000108 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6470 | 6470 | Charles Cathcart C000250 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 9 | |||||||||||||
5644 | 5644 | John Chapman C000314 | rep | MD | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5646 | 5646 | Lucien Chase C000330 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 9 | |||||||||||||
5647 | 5647 | Asa Clapp C000413 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5648 | 5648 | Franklin Clark C000432 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5649 | 5649 | Beverly Clarke C000458 | rep | KY | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5650 | 5650 | John Clarke C000466 | sen | RI | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
7261 | 7261 | Thomas Clingman C000524 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6790 | 6790 | Howell Cobb C000548 | rep | GA | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
7347 | 7347 | Williamson Cobb C000554 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
5652 | 5652 | William Cocke C000573 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
7703 | 7703 | Jacob Collamer C000628 | rep | VT | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5653 | 5653 | William Collins C000644 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 18 | |||||||||||||
5942 | 5942 | Harmon Conger C000676 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 25 | |||||||||||||
5657 | 5657 | Robert Cranston C000879 | rep | RI | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
7720 | 7720 | John Crisfield C000907 | rep | MD | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5949 | 5949 | John Crowell C000941 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 19 | |||||||||||||
5659 | 5659 | John Crozier C000951 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5661 | 5661 | John Cummins C000989 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 16 | |||||||||||||
6267 | 6267 | John Daniel D000034 | rep | NC | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
5662 | 5662 | Mason Darling D000054 | rep | WI | 1847-12-06 | 1849-03-03 | Democrat | -1 | |||||||||||||
7021 | 7021 | Jefferson Davis D000113 | sen | MS | 1847-12-06 | 1851-03-03 | 1 | Democrat | |||||||||||||
5670 | 5670 | John Davis D000117 | sen | MA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5672 | 5672 | John Dickey D000314 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 20 | |||||||||||||
5966 | 5966 | Rodolphus Dickinson D000325 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
7945 | 7945 | James Dixon D000369 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5673 | 5673 | Richard Donnell D000415 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
7388 | 7388 | Stephen Douglas D000457 | sen | IL | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5674 | 5674 | Solomon Downs D000476 | sen | LA | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5680 | 5680 | George Dromgoole D000504 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5968 | 5968 | William Duer D000515 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 23 | |||||||||||||
5682 | 5682 | William Duncan D000527 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
5681 | 5681 | Daniel Duncan D000529 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
6804 | 6804 | George Dunn D000546 | rep | IN | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5683 | 5683 | George Eckert E000034 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 14 | |||||||||||||
5685 | 5685 | Joseph Edsall E000059 | rep | NJ | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
5686 | 5686 | Thomas Edwards E000082 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
5687 | 5687 | Elisha Embree E000169 | rep | IN | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6286 | 6286 | Alexander Evans E000231 | rep | MD | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5971 | 5971 | Nathan Evans E000255 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 14 | |||||||||||||
5689 | 5689 | James Faran F000014 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
5690 | 5690 | John Farrelly F000031 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 22 | |||||||||||||
5974 | 5974 | Winfield Featherston F000055 | rep | MS | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5691 | 5691 | Alpheus Felch F000063 | sen | MI | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
6292 | 6292 | Orlando Ficklin F000101 | rep | IL | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
5692 | 5692 | David Fisher F000145 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5693 | 5693 | Thomas Flournoy F000216 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5694 | 5694 | Henry Foote F000251 | sen | MS | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5976 | 5976 | John Freedley F000360 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5697 | 5697 | Richard French F000379 | rep | KY | 1847-12-06 | 1849-03-03 | Democrat | 9 | |||||||||||||
5699 | 5699 | George Fries F000386 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 17 | |||||||||||||
5700 | 5700 | Andrew Fulton F000419 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 13 | |||||||||||||
5701 | 5701 | John Gaines G000006 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
5702 | 5702 | John Gayle G000106 | rep | AL | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6306 | 6306 | Meredith Gentry G000125 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
7053 | 7053 | Joshua Giddings G000167 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 20 | |||||||||||||
5706 | 5706 | William Goggin G000256 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5981 | 5981 | Daniel Gott G000339 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 24 | |||||||||||||
5707 | 5707 | Horace Greeley G000405 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
7065 | 7065 | James Green G000414 | rep | MO | 1847-12-06 | 1849-03-03 | Democrat | 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);