legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
261 rows where "start" is on date 1843-12-04 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
5114 | 5114 | William Allen A000150 | sen | OH | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5355 | 5355 | Joseph Anderson A000198 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5116 | 5116 | Archibald Arrington A000302 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 8 | |||||||||||||
5117 | 5117 | John Ashe A000308 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 10 | |||||||||||||
5897 | 5897 | David Atchison A000322 | sen | MO | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
6497 | 6497 | Charles Atherton A000323 | sen | NH | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5603 | 5603 | Archibald Atkinson A000328 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5119 | 5119 | Arthur Bagby B000030 | sen | AL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5122 | 5122 | Osmyn Baker B000071 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
5126 | 5126 | Daniel Barnard B000152 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 13 | |||||||||||||
5607 | 5607 | Daniel Barringer B000182 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
6762 | 6762 | Thomas Bayly B000259 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5130 | 5130 | Samuel Beardsley B000281 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 20 | |||||||||||||
5131 | 5131 | James Belser B000354 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5359 | 5359 | Charles Benton B000394 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 17 | |||||||||||||
5133 | 5133 | Benjamin Bidlack B000445 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 11 | |||||||||||||
5136 | 5136 | Edward Black B000494 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5362 | 5362 | James Black B000500 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 16 | |||||||||||||
5618 | 5618 | James Black B000501 | rep | SC | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5138 | 5138 | Julius Blackwell B000516 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5139 | 5139 | Pierre Bossier B000651 | rep | LA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5140 | 5140 | Gustavus Bower B000687 | 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 | |||||||||||||
6525 | 6525 | Linn Boyd B000719 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5141 | 5141 | Sidney Breese B000793 | sen | IL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5142 | 5142 | Francis Brengle B000797 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5143 | 5143 | Henry Brinkerhoff B000837 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 21 | |||||||||||||
5364 | 5364 | Jacob Brinkerhoff B000838 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 11 | |||||||||||||
6228 | 6228 | Richard Brodhead B000861 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5146 | 5146 | Aaron Brown B000899 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5148 | 5148 | Jeremiah Brown B000925 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
5368 | 5368 | Milton Brown B000938 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 11 | |||||||||||||
5914 | 5914 | William Brown B000950 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
6970 | 6970 | James Buchanan B001005 | sen | PA | 1843-12-04 | 1845-12-31 | 3 | Democrat | |||||||||||||
5370 | 5370 | Joseph Buffington B001041 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 24 | |||||||||||||
5151 | 5151 | Edmund Burke B001088 | rep | NH | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5153 | 5153 | Barker Burnell B001114 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 10 | |||||||||||||
6236 | 6236 | Armistead Burt B001145 | rep | SC | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5923 | 5923 | George Caldwell C000031 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5158 | 5158 | John Campbell C000090 | rep | SC | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5159 | 5159 | Levi Carpenter C000169 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 20 | |||||||||||||
5374 | 5374 | Charles Carroll C000186 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 29 | |||||||||||||
5160 | 5160 | Jeremiah Cary C000215 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 21 | |||||||||||||
5161 | 5161 | Shepard Cary C000217 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5162 | 5162 | George Catlin C000251 | rep | CT | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5163 | 5163 | John Causin C000258 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
5377 | 5377 | Augustus Chapman C000308 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 12 | |||||||||||||
5383 | 5383 | Reuben Chapman C000316 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5164 | 5164 | Absalom Chappell C000319 | rep | GA | 1843-12-04 | 1845-03-03 | Whig | -1 | |||||||||||||
5165 | 5165 | Samuel Chilton C000358 | rep | VA | 1843-12-04 | 1845-03-03 | Whig | 9 | |||||||||||||
5166 | 5166 | Duncan Clinch C000520 | rep | GA | 1843-12-04 | 1845-03-03 | Whig | -1 | |||||||||||||
7260 | 7260 | Thomas Clingman C000524 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
5168 | 5168 | James Clinton C000528 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
6788 | 6788 | Howell Cobb C000548 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5173 | 5173 | Walter Coles C000625 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
7701 | 7701 | Jacob Collamer C000628 | rep | VT | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5176 | 5176 | Walter Colquitt C000648 | sen | GA | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5179 | 5179 | Mark Cooper C000759 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5390 | 5390 | Henry Cranston C000878 | rep | RI | 1843-12-04 | 1845-03-03 | Law and Order | 1 | |||||||||||||
7725 | 7725 | John Crittenden C000912 | sen | KY | 1843-12-04 | 1848-06-12 | 3 | Whig | |||||||||||||
5182 | 5182 | Edward Cross C000930 | rep | AR | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5392 | 5392 | Alvan Cullom C000972 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5184 | 5184 | Amasa Dana D000020 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 26 | |||||||||||||
6265 | 6265 | John Daniel D000034 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5397 | 5397 | Cornelius Darragh D000061 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 21 | |||||||||||||
8301 | 8301 | Garrett Davis D000099 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
5401 | 5401 | John Davis D000120 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5186 | 5186 | Richard Davis D000128 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 8 | |||||||||||||
5404 | 5404 | John Dawson D000152 | rep | LA | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5188 | 5188 | Ezra Dean D000171 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 18 | |||||||||||||
5963 | 5963 | Edmund Deberry D000181 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
5190 | 5190 | James Dellet D000221 | rep | AL | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
5671 | 5671 | John Dickey D000314 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 20 | |||||||||||||
5192 | 5192 | David Dickinson D000318 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
5409 | 5409 | Paul Dillingham D000346 | rep | VT | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5864 | 5864 | Augustus Dodge D000394 | rep | IA | 1843-12-04 | 1845-03-03 | Democrat | 0 | |||||||||||||
6277 | 6277 | Henry Dodge D000396 | rep | WI | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
7386 | 7386 | Stephen Douglas D000457 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5678 | 5678 | George Dromgoole D000504 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5195 | 5195 | Alexander Duncan D000528 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5413 | 5413 | Robert Dunlap D000543 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5196 | 5196 | Chesselden Ellis E000131 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 16 | |||||||||||||
5197 | 5197 | Lucius Elmer E000156 | rep | NJ | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5422 | 5422 | John Fairfield F000006 | sen | ME | 1843-12-04 | 1845-03-03 | 1 | Democrat | |||||||||||||
5198 | 5198 | Isaac Farlee F000017 | rep | NJ | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
6290 | 6290 | Orlando Ficklin F000101 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
6294 | 6294 | Hamilton Fish F000140 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
5199 | 5199 | Elias Florence F000213 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 9 | |||||||||||||
7951 | 7951 | Solomon Foot F000248 | rep | VT | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
5201 | 5201 | Ephraim Foster F000302 | sen | TN | 1843-12-04 | 1845-03-03 | 1 | Whig | |||||||||||||
8897 | 8897 | Henry Foster F000305 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 19 | |||||||||||||
5696 | 5696 | Richard French F000379 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5202 | 5202 | Henry Frick F000383 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 13 | |||||||||||||
5203 | 5203 | George Fuller F000409 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 12 | |||||||||||||
7051 | 7051 | Joshua Giddings G000167 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 20 | |||||||||||||
5205 | 5205 | Thomas Gilmer G000218 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5705 | 5705 | William Goggin G000256 | rep | VA | 1843-12-04 | 1845-03-03 | Whig | 5 | |||||||||||||
5206 | 5206 | Byram Green G000406 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 27 |
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);