legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
260 rows where "end" is on date 1845-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5131 | 5131 | James Belser B000354 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5190 | 5190 | James Dellet D000221 | rep | AL | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
5383 | 5383 | Reuben Chapman C000316 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5475 | 5475 | Felix McConnell M000356 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5495 | 5495 | William Payne P000154 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5579 | 5579 | William Yancey Y000003 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
10108 | 10108 | George Houston H000822 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
4798 | 4798 | William Fulton F000425 | sen | AR | 1841-05-31 | 1845-03-03 | 2 | Democrat | |||||||||||||
5182 | 5182 | Edward Cross C000930 | rep | AR | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5162 | 5162 | George Catlin C000251 | rep | CT | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5297 | 5297 | Thomas Seymour S000271 | rep | CT | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5298 | 5298 | Samuel Simons S000425 | rep | CT | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5305 | 5305 | John Stewart S000913 | rep | CT | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5452 | 5452 | Jabez Huntington H000997 | sen | CT | 1840-01-01 | 1845-03-03 | 1 | Whig | |||||||||||||
4693 | 4693 | Richard Bayard B000251 | sen | DE | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
5278 | 5278 | George Rodney R000379 | rep | DE | 1843-12-04 | 1845-03-03 | Whig | 0 | |||||||||||||
6958 | 6958 | David Yulee Y000061 | rep | FL | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5136 | 5136 | Edward Black B000494 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5164 | 5164 | Absalom Chappell C000319 | rep | GA | 1843-12-04 | 1845-03-03 | Whig | -1 | |||||||||||||
5166 | 5166 | Duncan Clinch C000520 | rep | GA | 1843-12-04 | 1845-03-03 | Whig | -1 | |||||||||||||
5179 | 5179 | Mark Cooper C000759 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5243 | 5243 | John Lamar L000029 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5253 | 5253 | John Millen M000713 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5306 | 5306 | William Stiles S000925 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5992 | 5992 | Hugh Haralson H000178 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6788 | 6788 | Howell Cobb C000548 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6861 | 6861 | John Lumpkin L000511 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
10549 | 10549 | Alexander Stephens S000854 | rep | GA | 1843-12-04 | 1845-03-03 | Whig | -1 | |||||||||||||
5864 | 5864 | Augustus Dodge D000394 | rep | IA | 1843-12-04 | 1845-03-03 | Democrat | 0 | |||||||||||||
5214 | 5214 | John Hardin H000185 | rep | IL | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
5439 | 5439 | Joseph Hoge H000697 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
6290 | 6290 | Orlando Ficklin F000101 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
7225 | 7225 | Robert Smith S000604 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
7386 | 7386 | Stephen Douglas D000457 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
7789 | 7789 | John McClernand M000337 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
8224 | 8224 | John Wentworth W000295 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5281 | 5281 | Samuel Sample S000024 | rep | IN | 1843-12-04 | 1845-03-03 | Whig | 9 | |||||||||||||
5401 | 5401 | John Davis D000120 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5465 | 5465 | Andrew Kennedy K000102 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5490 | 5490 | Robert Owen O000152 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5522 | 5522 | Thomas Smith S000615 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5716 | 5716 | Thomas Henley H000499 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5822 | 5822 | Caleb Smith S000519 | rep | IN | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
5914 | 5914 | William Brown B000950 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
6668 | 6668 | John Pettit P000277 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 8 | |||||||||||||
7880 | 7880 | Albert White W000351 | sen | IN | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
7901 | 7901 | Joseph Wright W000766 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5209 | 5209 | Willis Green G000423 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5320 | 5320 | John White W000380 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
5540 | 5540 | William Thomasson T000190 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
5542 | 5542 | John Tibbatts T000261 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5696 | 5696 | Richard French F000379 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5923 | 5923 | George Caldwell C000031 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
6427 | 6427 | James Stone S000958 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
6525 | 6525 | Linn Boyd B000719 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
8122 | 8122 | Henry Grider G000455 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
8301 | 8301 | Garrett Davis D000099 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
5139 | 5139 | Pierre Bossier B000651 | rep | LA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5242 | 5242 | Alcée La Branche L000001 | rep | LA | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5404 | 5404 | John Dawson D000152 | rep | LA | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
6070 | 6070 | Isaac Morse M001011 | rep | LA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
6920 | 6920 | John Slidell S000487 | rep | LA | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
4743 | 4743 | Rufus Choate C000375 | sen | MA | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
5122 | 5122 | Osmyn Baker B000071 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
5153 | 5153 | Barker Burnell B001114 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 10 | |||||||||||||
5261 | 5261 | William Parmenter P000076 | rep | MA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5325 | 5325 | Henry Williams W000503 | rep | MA | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5588 | 5588 | Amos Abbott A000004 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
5598 | 5598 | John Adams A000041 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
5727 | 5727 | Charles Hudson H000907 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 5 | |||||||||||||
5984 | 5984 | Joseph Grinnell G000477 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 10 | |||||||||||||
6026 | 6026 | Daniel King K000198 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
6200 | 6200 | Robert Winthrop W000646 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
6745 | 6745 | Julius Rockwell R000368 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
4388 | 4388 | William Merrick M000654 | sen | MD | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
5142 | 5142 | Francis Brengle B000797 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5163 | 5163 | John Causin C000258 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
5240 | 5240 | John Kennedy K000109 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
5266 | 5266 | Jacob Preston P000515 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 5 | |||||||||||||
5300 | 5300 | Thomas Spence S000720 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
5314 | 5314 | John Wethered W000311 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
5161 | 5161 | Shepard Cary C000217 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5217 | 5217 | Joshua Herrick H000539 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5315 | 5315 | Benjamin White W000357 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5413 | 5413 | Robert Dunlap D000543 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5422 | 5422 | John Fairfield F000006 | sen | ME | 1843-12-04 | 1845-03-03 | 1 | Democrat | |||||||||||||
5516 | 5516 | Luther Severance S000255 | rep | ME | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
7523 | 7523 | Freeman Morse M001010 | rep | ME | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
9514 | 9514 | Hannibal Hamlin H000121 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
4648 | 4648 | Augustus Porter P000437 | sen | MI | 1840-01-01 | 1845-03-03 | 1 | Whig | |||||||||||||
5249 | 5249 | Lucius Lyon L000544 | rep | MI | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5447 | 5447 | James Hunt H000971 | rep | MI | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5778 | 5778 | Robert McClelland M000334 | rep | MI | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5140 | 5140 | Gustavus Bower B000687 | rep | MO | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5220 | 5220 | James Hughes H000927 | rep | MO | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5506 | 5506 | James Relfe R000160 | rep | MO | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5746 | 5746 | John Jameson J000054 | rep | MO | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5908 | 5908 | James Bowlin B000701 | rep | MO | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6515 | 6515 | Thomas Benton B000398 | sen | MO | 1839-12-02 | 1845-03-03 | 1 | Democrat | |||||||||||||
4510 | 4510 | John Henderson H000482 | sen | MS | 1839-12-02 | 1845-03-03 | 1 | Whig |
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);