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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10551 | 10551 | Alexander Stephens S000854 | rep | GA | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
10457 | 10457 | Robert McLane M000537 | rep | MD | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
10110 | 10110 | George Houston H000822 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
10006 | 10006 | Richard Beale B000268 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 8 | |||||||||||||
9881 | 9881 | William Lynde L000538 | rep | WI | 1847-12-06 | 1849-03-03 | Democrat | -1 | |||||||||||||
9747 | 9747 | Samuel Bridges B000824 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
9542 | 9542 | Andrew Johnson J000116 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
8709 | 8709 | Robert Schenck S000118 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
8267 | 8267 | Nathaniel Boyden B000722 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
8226 | 8226 | John Wentworth W000295 | rep | IL | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
8179 | 8179 | William Newell N000066 | rep | NJ | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
8157 | 8157 | Orlando Kellogg K000066 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 14 | |||||||||||||
8022 | 8022 | William Richardson R000228 | rep | IL | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
7945 | 7945 | James Dixon D000369 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
7924 | 7924 | William Brown B000948 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 15 | |||||||||||||
7889 | 7889 | David Wilmot W000566 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 12 | |||||||||||||
7828 | 7828 | John Phelps P000296 | rep | MO | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
7791 | 7791 | John McClernand M000337 | rep | IL | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
7720 | 7720 | John Crisfield C000907 | rep | MD | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
7703 | 7703 | Jacob Collamer C000628 | rep | VT | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
7647 | 7647 | Abraham Lincoln L000313 | rep | IL | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
7610 | 7610 | Robert Toombs T000313 | rep | GA | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
7604 | 7604 | James Thomas T000170 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
7541 | 7541 | Samuel Peyton P000284 | rep | KY | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
7496 | 7496 | John McQueen M000595 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
7490 | 7490 | William Maclay M000032 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
7455 | 7455 | Robert Hunter H000988 | sen | VA | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
7427 | 7427 | John Hale H000034 | sen | NH | 1847-12-06 | 1853-03-03 | 2 | Free Soil | |||||||||||||
7388 | 7388 | Stephen Douglas D000457 | sen | IL | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
7347 | 7347 | Williamson Cobb C000554 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
7323 | 7323 | Albert Brown B000900 | rep | MS | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
7295 | 7295 | Thomas Bocock B000582 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
7292 | 7292 | Kinsley Bingham B000473 | rep | MI | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
7272 | 7272 | Green Adams A000036 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
7261 | 7261 | Thomas Clingman C000524 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
7227 | 7227 | Robert Smith S000604 | rep | IL | 1847-12-06 | 1849-03-03 | Ind. Democrat | 1 | |||||||||||||
7146 | 7146 | James Mason M000216 | sen | VA | 1847-12-06 | 1851-03-03 | 1 | Democrat | |||||||||||||
7103 | 7103 | George Jones J000222 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
7065 | 7065 | James Green G000414 | rep | MO | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
7053 | 7053 | Joshua Giddings G000167 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 20 | |||||||||||||
7021 | 7021 | Jefferson Davis D000113 | sen | MS | 1847-12-06 | 1851-03-03 | 1 | Democrat | |||||||||||||
6931 | 6931 | Benjamin Thurston T000255 | rep | RI | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6863 | 6863 | John Lumpkin L000511 | rep | GA | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
6845 | 6845 | Robert Johnson J000172 | rep | AR | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6843 | 6843 | Alfred Iverson I000049 | rep | GA | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6827 | 6827 | Sampson Harris H000252 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
6804 | 6804 | George Dunn D000546 | rep | IN | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
6790 | 6790 | Howell Cobb C000548 | rep | GA | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
6764 | 6764 | Thomas Bayly B000259 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
6747 | 6747 | Julius Rockwell R000368 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
6722 | 6722 | John Thompson T000208 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
6715 | 6715 | John Taylor T000089 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
6710 | 6710 | Charles Stuart S001033 | rep | MI | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6698 | 6698 | Frederick Stanton S000802 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
6680 | 6680 | Thomas Ritchey R000271 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 13 | |||||||||||||
6670 | 6670 | John Pettit P000277 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 8 | |||||||||||||
6618 | 6618 | Samuel Houston H000827 | sen | TX | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
6527 | 6527 | Linn Boyd B000719 | rep | KY | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6510 | 6510 | John Bell B000340 | sen | TN | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
6470 | 6470 | Charles Cathcart C000250 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 9 | |||||||||||||
6463 | 6463 | Joseph Woodward W000732 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
6444 | 6444 | Daniel Wallace W000075 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6440 | 6440 | Abraham Venable V000084 | rep | NC | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
6437 | 6437 | Amos Tuck T000394 | rep | NH | 1847-12-06 | 1849-03-03 | Independent | 1 | |||||||||||||
6417 | 6417 | Ephraim Smart S000503 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
6414 | 6414 | Henry Sibley S000396 | rep | WI | 1847-12-06 | 1849-03-03 | -1 | ||||||||||||||
6394 | 6394 | John Robinson R000343 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
6381 | 6381 | Charles Peaslee P000173 | rep | NH | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6377 | 6377 | David Outlaw O000138 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
6362 | 6362 | Richard Meade M000618 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6354 | 6354 | Horace Mann M000102 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
6344 | 6344 | Timothy Jenkins J000089 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 20 | |||||||||||||
6315 | 6315 | Willard Hall H000077 | rep | MO | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6306 | 6306 | Meredith Gentry G000125 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
6292 | 6292 | Orlando Ficklin F000101 | rep | IL | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
6286 | 6286 | Alexander Evans E000231 | rep | MD | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
6267 | 6267 | John Daniel D000034 | rep | NC | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
6243 | 6243 | Edward Cabell C000003 | rep | FL | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6238 | 6238 | Armistead Burt B001145 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
6230 | 6230 | Richard Brodhead B000861 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
6202 | 6202 | Robert Winthrop W000646 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6196 | 6196 | Robert Rhett R000184 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
6175 | 6175 | James Wilson W000587 | rep | NH | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
6172 | 6172 | Hugh White W000375 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 16 | |||||||||||||
6164 | 6164 | Samuel Vinton V000107 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 12 | |||||||||||||
6153 | 6153 | John Van Dyke V000035 | rep | NJ | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6146 | 6146 | William Thompson T000223 | rep | IA | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6144 | 6144 | James Thompson T000204 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 23 | |||||||||||||
6141 | 6141 | Jacob Thompson T000203 | rep | MS | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6135 | 6135 | William Strong S001021 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 9 | |||||||||||||
6130 | 6130 | Pierre Soulé S000682 | sen | LA | 1847-12-06 | 1847-12-31 | 2 | Democrat | |||||||||||||
6128 | 6128 | Truman Smith S000621 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6123 | 6123 | Peter Silvester S000413 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 11 | |||||||||||||
6121 | 6121 | Augustine Shepperd S000338 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6108 | 6108 | David Rumsey R000506 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 30 | |||||||||||||
6106 | 6106 | Robert Rose R000438 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 29 | |||||||||||||
6104 | 6104 | Joseph Root R000433 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 21 | |||||||||||||
6100 | 6100 | Gideon Reynolds R000172 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 12 | |||||||||||||
6097 | 6097 | Harvey Putnam P000580 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 33 | |||||||||||||
6089 | 6089 | Lucius Peck P000178 | rep | VT | 1847-12-06 | 1849-03-03 | Democrat | 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);