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 party
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5108 | 5108 | George McDuffie M000426 | sen | SC | 1843-12-04 | 1846-08-17 | 3 | Democrat | |||||||||||||
5114 | 5114 | William Allen A000150 | sen | OH | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5116 | 5116 | Archibald Arrington A000302 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 8 | |||||||||||||
5119 | 5119 | Arthur Bagby B000030 | sen | AL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5141 | 5141 | Sidney Breese B000793 | sen | IL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5143 | 5143 | Henry Brinkerhoff B000837 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 21 | |||||||||||||
5146 | 5146 | Aaron Brown B000899 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5151 | 5151 | Edmund Burke B001088 | rep | NH | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5168 | 5168 | James Clinton C000528 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5173 | 5173 | Walter Coles C000625 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
5182 | 5182 | Edward Cross C000930 | rep | AR | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5184 | 5184 | Amasa Dana D000020 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 26 | |||||||||||||
5186 | 5186 | Richard Davis D000128 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 8 | |||||||||||||
5188 | 5188 | Ezra Dean D000171 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 18 | |||||||||||||
5195 | 5195 | Alexander Duncan D000528 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
5198 | 5198 | Isaac Farlee F000017 | rep | NJ | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5203 | 5203 | George Fuller F000409 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 12 | |||||||||||||
5205 | 5205 | Thomas Gilmer G000218 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5206 | 5206 | Byram Green G000406 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 27 | |||||||||||||
5211 | 5211 | William Hammett H000125 | rep | MS | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5213 | 5213 | Edward Hannegan H000167 | sen | IN | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5215 | 5215 | Samuel Hays H000406 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 22 | |||||||||||||
5216 | 5216 | William Haywood H000411 | sen | NC | 1843-12-04 | 1847-03-03 | 3 | Democrat | |||||||||||||
5217 | 5217 | Joshua Herrick H000539 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5218 | 5218 | William Hubbell H000895 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 30 | |||||||||||||
5219 | 5219 | Daniel Huger H000917 | sen | SC | 1843-12-04 | 1845-12-31 | 2 | Democrat | |||||||||||||
5220 | 5220 | James Hughes H000927 | rep | MO | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5231 | 5231 | Cave Johnson J000122 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5237 | 5237 | John Jones J000240 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5241 | 5241 | Littleton Kirkpatrick K000236 | rep | NJ | 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 | |||||||||||||
5243 | 5243 | John Lamar L000029 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5244 | 5244 | Moses Leonard L000248 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5246 | 5246 | William Lucas L000494 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5249 | 5249 | Lucius Lyon L000544 | rep | MI | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5251 | 5251 | James Mathews M000237 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 16 | |||||||||||||
5252 | 5252 | William McCauslen M000323 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 17 | |||||||||||||
5253 | 5253 | John Millen M000713 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5254 | 5254 | Heman Moore M000899 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5257 | 5257 | John Niles N000108 | sen | CT | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5261 | 5261 | William Parmenter P000076 | rep | MA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5265 | 5265 | Zadock Pratt P000507 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 11 | |||||||||||||
5267 | 5267 | Smith Purdy P000571 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 22 | |||||||||||||
5272 | 5272 | Almon Read R000090 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 12 | |||||||||||||
5274 | 5274 | John Reding R000106 | rep | NH | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5276 | 5276 | Orville Robinson R000351 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 23 | |||||||||||||
5280 | 5280 | Jeremiah Russell R000528 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5286 | 5286 | Romulus Saunders S000078 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5287 | 5287 | James Semple S000239 | sen | IL | 1843-12-04 | 1847-03-03 | 2 | Democrat | |||||||||||||
5296 | 5296 | Ambrose Sevier S000256 | sen | AR | 1843-12-04 | 1848-03-15 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
5299 | 5299 | John Smith S000576 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5303 | 5303 | Lewis Steenrod S000843 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 15 | |||||||||||||
5304 | 5304 | Lemuel Stetson S000874 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 15 | |||||||||||||
5305 | 5305 | John Stewart S000913 | rep | CT | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5306 | 5306 | William Stiles S000925 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5307 | 5307 | Alfred Stone S000952 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5308 | 5308 | Selah Strong S001016 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5311 | 5311 | Tilghman Tucker T000404 | rep | MS | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5315 | 5315 | Benjamin White W000357 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5323 | 5323 | William Wilkins W000475 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 21 | |||||||||||||
5325 | 5325 | Henry Williams W000503 | rep | MA | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5331 | 5331 | Henry Wise W000649 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5336 | 5336 | Silas Wright W000770 | sen | NY | 1843-12-04 | 1845-03-03 | 3 | Democrat | |||||||||||||
5355 | 5355 | Joseph Anderson A000198 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5359 | 5359 | Charles Benton B000394 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 17 | |||||||||||||
5362 | 5362 | James Black B000500 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 16 | |||||||||||||
5364 | 5364 | Jacob Brinkerhoff B000838 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 11 | |||||||||||||
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 | |||||||||||||
5392 | 5392 | Alvan Cullom C000972 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5401 | 5401 | John Davis D000120 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5404 | 5404 | John Dawson D000152 | rep | LA | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5409 | 5409 | Paul Dillingham D000346 | rep | VT | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
5439 | 5439 | Joseph Hoge H000697 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5443 | 5443 | Edmund Hubard H000876 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5445 | 5445 | Orville Hungerford H000968 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 19 | |||||||||||||
5447 | 5447 | James Hunt H000971 | rep | MI | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5465 | 5465 | Andrew Kennedy K000102 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5475 | 5475 | Felix McConnell M000356 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5479 | 5479 | Joseph McDowell M000425 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 7 |
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);