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
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, class, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4388 | 4388 | William Merrick M000654 | sen | MD | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
4510 | 4510 | John Henderson H000482 | sen | MS | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
4623 | 4623 | Nathaniel Tallmadge T000032 | sen | NY | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
4624 | 4624 | Benjamin Tappan T000039 | sen | OH | 1839-12-02 | 1845-03-03 | 1 | Democrat | |||||||||||||
4648 | 4648 | Augustus Porter P000437 | sen | MI | 1840-01-01 | 1845-03-03 | 1 | Whig | |||||||||||||
4693 | 4693 | Richard Bayard B000251 | sen | DE | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
4743 | 4743 | Rufus Choate C000375 | sen | MA | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
4798 | 4798 | William Fulton F000425 | sen | AR | 1841-05-31 | 1845-03-03 | 2 | Democrat | |||||||||||||
4975 | 4975 | William Rives R000285 | sen | VA | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
5110 | 5110 | William Sprague S000746 | sen | RI | 1842-01-01 | 1845-03-03 | 1 | Whig | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5163 | 5163 | John Causin C000258 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5190 | 5190 | James Dellet D000221 | rep | AL | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
5192 | 5192 | David Dickinson D000318 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
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 | |||||||||||||
5199 | 5199 | Elias Florence F000213 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 9 | |||||||||||||
5201 | 5201 | Ephraim Foster F000302 | sen | TN | 1843-12-04 | 1845-03-03 | 1 | Whig | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5209 | 5209 | Willis Green G000423 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5210 | 5210 | Edward Hamlin H000120 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 21 | |||||||||||||
5211 | 5211 | William Hammett H000125 | rep | MS | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5214 | 5214 | John Hardin H000185 | rep | IL | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
5215 | 5215 | Samuel Hays H000406 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 22 | |||||||||||||
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 | |||||||||||||
5220 | 5220 | James Hughes H000927 | rep | MO | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5222 | 5222 | James Irvin I000033 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 17 | |||||||||||||
5224 | 5224 | Michael Jenks J000092 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
5231 | 5231 | Cave Johnson J000122 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5232 | 5232 | Perley Johnson J000167 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 13 | |||||||||||||
5237 | 5237 | John Jones J000240 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5240 | 5240 | John Kennedy K000109 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
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 | |||||||||||||
5255 | 5255 | Willoughby Newton N000080 | rep | VA | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
5261 | 5261 | William Parmenter P000076 | rep | MA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5262 | 5262 | Thomas Patterson P000129 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 28 | |||||||||||||
5263 | 5263 | Elisha Potter P000462 | rep | RI | 1843-12-04 | 1845-03-03 | Law and Order | 2 | |||||||||||||
5265 | 5265 | Zadock Pratt P000507 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 11 | |||||||||||||
5266 | 5266 | Jacob Preston P000515 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 5 | |||||||||||||
5267 | 5267 | Smith Purdy P000571 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 22 | |||||||||||||
5270 | 5270 | Kenneth Rayner R000087 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 9 | |||||||||||||
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 | |||||||||||||
5275 | 5275 | Charles Reed R000110 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 23 | |||||||||||||
5276 | 5276 | Orville Robinson R000351 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 23 | |||||||||||||
5278 | 5278 | George Rodney R000379 | rep | DE | 1843-12-04 | 1845-03-03 | Whig | 0 | |||||||||||||
5279 | 5279 | Charles Rogers R000390 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 14 | |||||||||||||
5280 | 5280 | Jeremiah Russell R000528 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5281 | 5281 | Samuel Sample S000024 | rep | IN | 1843-12-04 | 1845-03-03 | Whig | 9 | |||||||||||||
5286 | 5286 | Romulus Saunders S000078 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5288 | 5288 | William Senter S000245 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
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 |
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);