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 1841-05-31 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10606 | 10606 | Fernando Wood W000694 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
10107 | 10107 | George Houston H000822 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
8300 | 8300 | Garrett Davis D000099 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
8142 | 8142 | Jacob Howard H000839 | rep | MI | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
8114 | 8114 | William Fessenden F000099 | rep | ME | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
8093 | 8093 | William Campbell C000104 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
8042 | 8042 | John Stuart S001035 | rep | IL | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
7822 | 7822 | James Pearce P000161 | rep | MD | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
7780 | 7780 | Henry Lane L000060 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
7569 | 7569 | William Smith S000627 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 13 | |||||||||||||
7453 | 7453 | Robert Hunter H000988 | rep | VA | 1841-05-31 | 1843-03-03 | Independent | 9 | |||||||||||||
7420 | 7420 | William Goode G000281 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 4 | |||||||||||||
7223 | 7223 | James Simmons S000417 | sen | RI | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
7093 | 7093 | George Hopkins H000774 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 18 | |||||||||||||
7073 | 7073 | William Gwin G000540 | rep | MS | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
7050 | 7050 | Joshua Giddings G000167 | rep | OH | 1841-05-31 | 1843-03-03 | Whig | 16 | |||||||||||||
6957 | 6957 | David Yulee Y000061 | rep | FL | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
6721 | 6721 | John Thompson T000208 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 5 | |||||||||||||
6695 | 6695 | Augustus Sollers S000674 | rep | MD | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
6524 | 6524 | Linn Boyd B000719 | rep | KY | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
6496 | 6496 | Charles Atherton A000323 | rep | NH | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
6480 | 6480 | John Weller W000274 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
6458 | 6458 | Christopher Williams W000493 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 13 | |||||||||||||
6422 | 6422 | Edward Stanly S000799 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
6370 | 6370 | John Moore M000903 | rep | LA | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
6304 | 6304 | Meredith Gentry G000125 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 8 | |||||||||||||
6297 | 6297 | John Floyd F000223 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 17 | |||||||||||||
6276 | 6276 | Henry Dodge D000396 | rep | WI | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
6264 | 6264 | John Daniel D000034 | rep | NC | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
6207 | 6207 | Millard Fillmore F000115 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 32 | |||||||||||||
6199 | 6199 | Robert Winthrop W000646 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
6193 | 6193 | Robert Rhett R000184 | rep | SC | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
6138 | 6138 | Jacob Thompson T000203 | rep | MS | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
6126 | 6126 | Truman Smith S000621 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 5 | |||||||||||||
6120 | 6120 | Augustine Shepperd S000338 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 9 | |||||||||||||
6046 | 6046 | Nathaniel Littlefield L000356 | rep | ME | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
6033 | 6033 | Thomas King K000215 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
6008 | 6008 | Isaac Holmes H000738 | rep | SC | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
5962 | 5962 | Edmund Deberry D000181 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
5955 | 5955 | William Dawson D000156 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
5947 | 5947 | James Cooper C000753 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
5877 | 5877 | William King K000217 | sen | AL | 1841-05-31 | 1844-04-15 | 2 | Democrat | |||||||||||||
5863 | 5863 | Augustus Dodge D000394 | rep | IA | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5851 | 5851 | Joseph Underwood U000011 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
5842 | 5842 | Richard Thompson T000214 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5793 | 5793 | Jacob Miller M000731 | sen | NJ | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5789 | 5789 | James McKay M000489 | rep | NC | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5761 | 5761 | Dixon Lewis L000278 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5739 | 5739 | Joseph Ingersoll I000019 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5734 | 5734 | Charles Ingersoll I000015 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5726 | 5726 | Charles Hudson H000907 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 5 | |||||||||||||
5704 | 5704 | William Goggin G000256 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
5656 | 5656 | Robert Cranston C000879 | rep | RI | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
5639 | 5639 | John Calhoun C000044 | sen | SC | 1841-05-31 | 1843-12-31 | 2 | Democrat | |||||||||||||
5630 | 5630 | Charles Brown B000906 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
5625 | 5625 | John Botts B000655 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 11 | |||||||||||||
5615 | 5615 | John Berrien B000413 | sen | GA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5597 | 5597 | John Adams A000041 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
5553 | 5553 | Hopkins Turney T000430 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5494 | 5494 | William Payne P000154 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5464 | 5464 | Andrew Kennedy K000102 | rep | IN | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5442 | 5442 | Edmund Hubard H000876 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5432 | 5432 | James Graham G000355 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
5426 | 5426 | Samuel Gordon G000315 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 20 | |||||||||||||
5403 | 5403 | John Dawson D000152 | rep | LA | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
5382 | 5382 | Reuben Chapman C000316 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5367 | 5367 | Milton Brown B000938 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
5330 | 5330 | Henry Wise W000649 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 8 | |||||||||||||
5319 | 5319 | John White W000380 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 9 | |||||||||||||
5309 | 5309 | George Summers S001066 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 19 | |||||||||||||
5302 | 5302 | Lewis Steenrod S000843 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 21 | |||||||||||||
5285 | 5285 | Romulus Saunders S000078 | rep | NC | 1841-05-31 | 1843-03-03 | Democrat | 8 | |||||||||||||
5277 | 5277 | George Rodney R000379 | rep | DE | 1841-05-31 | 1843-03-03 | Whig | 0 | |||||||||||||
5273 | 5273 | John Reding R000106 | rep | NH | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5271 | 5271 | Almon Read R000090 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 17 | |||||||||||||
5269 | 5269 | Kenneth Rayner R000087 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
5260 | 5260 | William Parmenter P000076 | rep | MA | 1841-05-31 | 1843-03-03 | Democrat | 4 | |||||||||||||
5250 | 5250 | James Mathews M000237 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 13 | |||||||||||||
5239 | 5239 | John Kennedy K000109 | rep | MD | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
5236 | 5236 | John Jones J000240 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5230 | 5230 | Cave Johnson J000122 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 11 | |||||||||||||
5221 | 5221 | James Irvin I000033 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 14 | |||||||||||||
5208 | 5208 | Willis Green G000423 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
5204 | 5204 | Thomas Gilmer G000218 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
5187 | 5187 | Ezra Dean D000171 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 18 | |||||||||||||
5185 | 5185 | Richard Davis D000128 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5181 | 5181 | Edward Cross C000930 | rep | AR | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
5178 | 5178 | Mark Cooper C000759 | rep | GA | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5175 | 5175 | Walter Colquitt C000648 | rep | GA | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5172 | 5172 | Walter Coles C000625 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
5167 | 5167 | James Clinton C000528 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
5157 | 5157 | John Campbell C000090 | rep | SC | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5152 | 5152 | Barker Burnell B001114 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 11 | |||||||||||||
5150 | 5150 | Edmund Burke B001088 | rep | NH | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5147 | 5147 | Jeremiah Brown B000925 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
5145 | 5145 | Aaron Brown B000899 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 10 | |||||||||||||
5135 | 5135 | Edward Black B000494 | rep | GA | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5132 | 5132 | Benjamin Bidlack B000445 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 15 | |||||||||||||
5125 | 5125 | Daniel Barnard B000152 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
5121 | 5121 | Osmyn Baker B000071 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 6 |
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);