legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
265 rows where "end" is on date 1849-03-03 sorted by rss_url
This data as json, copyable, CSV (advanced)
Suggested facets: start, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5114 | 5114 | William Allen A000150 | sen | OH | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5119 | 5119 | Arthur Bagby B000030 | sen | AL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5141 | 5141 | Sidney Breese B000793 | sen | IL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5176 | 5176 | Walter Colquitt C000648 | sen | GA | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5213 | 5213 | Edward Hannegan H000167 | sen | IN | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5257 | 5257 | John Niles N000108 | sen | CT | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5347 | 5347 | Henry Johnson J000137 | sen | LA | 1844-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5411 | 5411 | John Dix D000365 | sen | NY | 1845-12-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5572 | 5572 | James Westcott W000308 | sen | FL | 1845-12-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5590 | 5590 | Amos Abbott A000004 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
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 | |||||||||||||
5605 | 5605 | Archibald Atkinson A000328 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5626 | 5626 | John Botts B000655 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
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 | |||||||||||||
5631 | 5631 | Charles Brown B000906 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
5632 | 5632 | Aylette Buckner B001032 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5642 | 5642 | Richard Canby C000108 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
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 | |||||||||||||
5652 | 5652 | William Cocke C000573 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5653 | 5653 | William Collins C000644 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 18 | |||||||||||||
5657 | 5657 | Robert Cranston C000879 | rep | RI | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
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 | |||||||||||||
5662 | 5662 | Mason Darling D000054 | rep | WI | 1847-12-06 | 1849-03-03 | Democrat | -1 | |||||||||||||
5672 | 5672 | John Dickey D000314 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 20 | |||||||||||||
5673 | 5673 | Richard Donnell D000415 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5680 | 5680 | George Dromgoole D000504 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5681 | 5681 | Daniel Duncan D000529 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
5682 | 5682 | William Duncan D000527 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5706 | 5706 | William Goggin G000256 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5707 | 5707 | Horace Greeley G000405 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5708 | 5708 | Dudley Gregory G000446 | rep | NJ | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5710 | 5710 | Artemas Hale H000028 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
5711 | 5711 | Nathan Hall H000062 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 32 | |||||||||||||
5712 | 5712 | David Hammons H000136 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
5714 | 5714 | James Hampton H000138 | rep | NJ | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5715 | 5715 | William Haskell H000320 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 11 | |||||||||||||
5718 | 5718 | Thomas Henley H000499 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5719 | 5719 | Hugh Hill H000592 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5720 | 5720 | John Holley H000723 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 27 | |||||||||||||
5722 | 5722 | Elias Holmes H000736 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 28 | |||||||||||||
5723 | 5723 | John Hornbeck H000790 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5725 | 5725 | Samuel Hubbard H000889 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5729 | 5729 | Charles Hudson H000907 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5732 | 5732 | Washington Hunt H000978 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 34 | |||||||||||||
5737 | 5737 | Charles Ingersoll I000015 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5742 | 5742 | Joseph Ingersoll I000019 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5743 | 5743 | Alexander Irvin I000032 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 24 | |||||||||||||
5744 | 5744 | David Jackson J000007 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
5747 | 5747 | John Jameson J000054 | rep | MO | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5749 | 5749 | James Johnson J000146 | rep | NH | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5750 | 5750 | John Jones J000239 | rep | GA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5751 | 5751 | William Kennon K000122 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 15 | |||||||||||||
5752 | 5752 | Samuel Lahm L000021 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 18 | |||||||||||||
5753 | 5753 | Sidney Lawrence L000139 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 15 | |||||||||||||
5754 | 5754 | William Lawrence L000142 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 26 | |||||||||||||
5766 | 5766 | Thomas Ligon L000307 | rep | MD | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
5767 | 5767 | Frederick Lord L000440 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
5777 | 5777 | Dudley Marvin M000208 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 31 | |||||||||||||
5780 | 5780 | Robert McClelland M000334 | rep | MI | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
5783 | 5783 | Abraham McIlvaine M000474 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
5792 | 5792 | James McKay M000489 | rep | NC | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
5795 | 5795 | Joseph Mullin M001072 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 19 | |||||||||||||
5797 | 5797 | Henry Murphy M001093 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5798 | 5798 | Henry Nicoll N000103 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
5799 | 5799 | John Palfrey P000033 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5801 | 5801 | John Pendleton P000206 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
5802 | 5802 | George Petrie P000266 | rep | NY | 1847-12-06 | 1849-03-03 | Ind. Democrat | 17 | |||||||||||||
5804 | 5804 | Timothy Pilsbury P000353 | rep | TX | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5807 | 5807 | James Pollock P000416 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 13 | |||||||||||||
5808 | 5808 | William Preston P000518 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 12 | |||||||||||||
5809 | 5809 | William Rockhill R000364 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
5811 | 5811 | John Rockwell R000367 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 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);