legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
285 rows where "end" is on date 1841-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5596 | 5596 | John Adams A000041 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
4659 | 4659 | Julius Alford A000104 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4392 | 4392 | John Allen A000135 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 15 | |||||||||||||
4393 | 4393 | Judson Allen A000137 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 20 | |||||||||||||
4394 | 4394 | James Alvord A000168 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4646 | 4646 | Alexander Anderson A000181 | sen | TN | 1840-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4396 | 4396 | Hugh Anderson A000190 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4397 | 4397 | Simeon Anderson A000232 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4662 | 4662 | Landaff Andrews A000247 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
6495 | 6495 | Charles Atherton A000323 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4679 | 4679 | John Aycrigg A000350 | rep | NJ | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5120 | 5120 | Osmyn Baker B000071 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4683 | 4683 | Linn Banks B000115 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
5124 | 5124 | Daniel Barnard B000152 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
4399 | 4399 | William Beatty B000284 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4401 | 4401 | Andrew Beirne B000319 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
6509 | 6509 | John Bell B000340 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
4404 | 4404 | Richard Biddle B000443 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 22 | |||||||||||||
5134 | 5134 | Edward Black B000494 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5137 | 5137 | Julius Blackwell B000516 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4699 | 4699 | William Boardman B000578 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4407 | 4407 | William Bond B000613 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
5624 | 5624 | John Botts B000655 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
6523 | 6523 | Linn Boyd B000719 | rep | KY | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4408 | 4408 | Henry Brackenridge B000732 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 22 | |||||||||||||
4705 | 4705 | David Brewster B000814 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4711 | 4711 | George Briggs B000830 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4713 | 4713 | John Brockway B000854 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5144 | 5144 | Aaron Brown B000899 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 10 | |||||||||||||
7322 | 7322 | Albert Brown B000900 | rep | MS | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4409 | 4409 | Anson Brown B000901 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
3854 | 3854 | Bedford Brown B000903 | sen | NC | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5149 | 5149 | Edmund Burke B001088 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4716 | 4716 | Sampson Butler B001189 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4719 | 4719 | William Butler B001197 | rep | KY | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4413 | 4413 | Jesse Bynum B001204 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
5638 | 5638 | John Calhoun C000044 | sen | SC | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4725 | 4725 | William Calhoun C000046 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
5156 | 5156 | John Campbell C000090 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
8092 | 8092 | William Campbell C000104 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4417 | 4417 | John Carr C000177 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
4418 | 4418 | James Carroll C000188 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4421 | 4421 | William Carter C000204 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4733 | 4733 | Zadok Casey C000230 | rep | IL | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
5381 | 5381 | Reuben Chapman C000316 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4423 | 4423 | William Chapman C000318 | rep | IA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4424 | 4424 | Thomas Chinn C000363 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4739 | 4739 | Thomas Chittenden C000374 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 18 | |||||||||||||
4746 | 4746 | John Clark C000443 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 21 | |||||||||||||
4751 | 4751 | Thomas Clayton C000499 | sen | DE | 1837-09-04 | 1841-03-03 | 2 | Whig | |||||||||||||
4753 | 4753 | Nathan Clifford C000518 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5171 | 5171 | Walter Coles C000625 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
5174 | 5174 | Walter Colquitt C000648 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4434 | 4434 | Henry Connor C000700 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 11 | |||||||||||||
5946 | 5946 | James Cooper C000753 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
5177 | 5177 | Mark Cooper C000759 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4435 | 4435 | William Cooper C000766 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
7714 | 7714 | Thomas Corwin C000791 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
4437 | 4437 | George Crabb C000847 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4442 | 4442 | Robert Craig C000859 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
5655 | 5655 | Robert Cranston C000879 | rep | RI | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4445 | 4445 | Isaac Crary C000882 | rep | MI | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
7723 | 7723 | John Crittenden C000912 | sen | KY | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4447 | 4447 | John Crockett C000920 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
5180 | 5180 | Edward Cross C000930 | rep | AR | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4449 | 4449 | Edward Curtis C001009 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4760 | 4760 | Caleb Cushing C001016 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5183 | 5183 | Amasa Dana D000020 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 22 | |||||||||||||
4451 | 4451 | Thomas Davee D000068 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4453 | 4453 | Edward Davies D000088 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 4 | |||||||||||||
8299 | 8299 | Garrett Davis D000099 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
4454 | 4454 | John Davis D000116 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
5668 | 5668 | John Davis D000117 | sen | MA | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
5400 | 5400 | John Davis D000120 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
5954 | 5954 | William Dawson D000156 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5961 | 5961 | Edmund Deberry D000181 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4455 | 4455 | James De La Montanya D000205 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
5189 | 5189 | James Dellet D000221 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4457 | 4457 | John Dennis D000244 | rep | MD | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4460 | 4460 | Philemon Dickerson D000309 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4763 | 4763 | William Doan D000380 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
5862 | 5862 | Augustus Dodge D000394 | rep | IA | 1840-12-28 | 1841-03-03 | Democrat | 0 | |||||||||||||
4462 | 4462 | Nicholas Doe D000398 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4765 | 4765 | Andrew Doig D000400 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 16 | |||||||||||||
6281 | 6281 | James Doty D000443 | rep | WI | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4464 | 4464 | Charles Downing D000472 | rep | FL | 1839-12-02 | 1841-03-03 | -1 | ||||||||||||||
5677 | 5677 | George Dromgoole D000504 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5194 | 5194 | Alexander Duncan D000528 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4465 | 4465 | Nehemiah Earll E000012 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4767 | 4767 | Ira Eastman E000020 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4769 | 4769 | John Edwards E000074 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 4 | |||||||||||||
4466 | 4466 | John Ely E000166 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4778 | 4778 | George Evans E000241 | rep | ME | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
4785 | 4785 | Horace Everett E000265 | rep | VT | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
6206 | 6206 | Millard Fillmore F000115 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 32 | |||||||||||||
4467 | 4467 | John Fine F000125 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
4470 | 4470 | Charles Fisher F000144 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 10 | |||||||||||||
4472 | 4472 | Isaac Fletcher F000201 | rep | VT | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
6296 | 6296 | John Floyd F000223 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 17 |
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);