legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
281 rows where "end" is on date 1839-03-03
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4354 | 4354 | William Southgate S000690 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 13 | |||||||||||||
4355 | 4355 | James Spencer S000725 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 14 | |||||||||||||
4361 | 4361 | James Standifer S000789 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4362 | 4362 | William Stone S000965 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4363 | 4363 | Archibald Stuart S001032 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 7 | |||||||||||||
4366 | 4366 | William Taylor T000103 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 23 | |||||||||||||
4367 | 4367 | Obadiah Titus T000288 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4368 | 4368 | Henry Vail V000002 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 9 | |||||||||||||
4369 | 4369 | Abraham Vanderveer V000030 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4372 | 4372 | Taylor Webster W000241 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4374 | 4374 | Joseph Weeks W000247 | rep | NH | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4382 | 4382 | Elisha Whittlesey W000431 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 16 | |||||||||||||
4384 | 4384 | Thomas Whittlesey W000433 | rep | CT | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
4385 | 4385 | Thomas Word W000742 | rep | MS | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
4387 | 4387 | William Merrick M000654 | sen | MD | 1838-01-04 | 1839-03-03 | 1 | Whig | |||||||||||||
4389 | 4389 | James Trotter T000380 | sen | MS | 1838-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
4390 | 4390 | Thomas Williams W000539 | sen | MS | 1838-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
4391 | 4391 | John Allen A000135 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 15 | |||||||||||||
4395 | 4395 | Hugh Anderson A000190 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4398 | 4398 | William Beatty B000284 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 23 | |||||||||||||
4400 | 4400 | Andrew Beirne B000319 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4403 | 4403 | Richard Biddle B000443 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 22 | |||||||||||||
4406 | 4406 | William Bond B000613 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
4412 | 4412 | Jesse Bynum B001204 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4420 | 4420 | William Carter C000204 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 1 | |||||||||||||
4422 | 4422 | William Chapman C000318 | rep | IA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4433 | 4433 | Henry Connor C000700 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 11 | |||||||||||||
4436 | 4436 | George Crabb C000847 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4441 | 4441 | Robert Craig C000859 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 17 | |||||||||||||
4444 | 4444 | Isaac Crary C000882 | rep | MI | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4446 | 4446 | John Crockett C000920 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 12 | |||||||||||||
4448 | 4448 | Edward Curtis C001009 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4450 | 4450 | Thomas Davee D000068 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 8 | |||||||||||||
4452 | 4452 | Edward Davies D000088 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 4 | |||||||||||||
4456 | 4456 | John Dennis D000244 | rep | MD | 1837-09-04 | 1839-03-03 | Whig | 1 | |||||||||||||
4463 | 4463 | Charles Downing D000472 | rep | FL | 1837-09-04 | 1839-03-03 | -1 | ||||||||||||||
4471 | 4471 | Isaac Fletcher F000201 | rep | VT | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4477 | 4477 | James Garland G000067 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 12 | |||||||||||||
4481 | 4481 | Rice Garland G000070 | rep | LA | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4484 | 4484 | William Graves G000392 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 8 | |||||||||||||
4489 | 4489 | John Griffin G000462 | rep | SC | 1837-09-04 | 1839-03-03 | Nullifier | 9 | |||||||||||||
4495 | 4495 | Felix Grundy G000509 | sen | TN | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4497 | 4497 | Robert Hammond H000132 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 16 | |||||||||||||
4501 | 4501 | Albert Harrison H000261 | rep | MO | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4503 | 4503 | Richard Hawes H000363 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 10 | |||||||||||||
4508 | 4508 | Micajah Hawkins H000373 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4514 | 4514 | Josiah Hoffman H000687 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4519 | 4519 | Thomas Jackson J000027 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4523 | 4523 | Daniel Jenifer J000078 | rep | MD | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
4526 | 4526 | Nathaniel Jones J000243 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4528 | 4528 | Gouverneur Kemble K000084 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
4534 | 4534 | Daniel Leadbetter L000172 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
4540 | 4540 | Richard Marvin M000211 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 31 | |||||||||||||
4543 | 4543 | Charles McClure M000345 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
4556 | 4556 | Charles Mercer M000642 | rep | VA | 1837-09-04 | 1839-03-03 | Whig | 14 | |||||||||||||
4558 | 4558 | Charles Mitchell M000806 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 33 | |||||||||||||
4562 | 4562 | William Montgomery M000874 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 8 | |||||||||||||
4564 | 4564 | Samuel Morris M000987 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 17 | |||||||||||||
4566 | 4566 | Charles Naylor N000011 | rep | PA | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4569 | 4569 | Virgil Parris P000081 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4571 | 4571 | Lemuel Paynter P000155 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4573 | 4573 | Luther Peck P000179 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 30 | |||||||||||||
4575 | 4575 | David Petrikin P000267 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 15 | |||||||||||||
4577 | 4577 | William Potter P000469 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 14 | |||||||||||||
4579 | 4579 | John Prentiss P000509 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4582 | 4582 | James Rariden R000066 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
4594 | 4594 | John Reed R000121 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
4597 | 4597 | Eleazar Ripley R000265 | rep | LA | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4599 | 4599 | Francis Rives R000284 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4604 | 4604 | David Russell R000524 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 12 | |||||||||||||
4608 | 4608 | Charles Shepard S000329 | rep | NC | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4614 | 4614 | Samuel Southard S000689 | sen | NJ | 1833-12-02 | 1839-03-03 | 1 | Whig | |||||||||||||
4620 | 4620 | Henry Swearingen S001099 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4622 | 4622 | Nathaniel Tallmadge T000032 | sen | NY | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4627 | 4627 | Waddy Thompson T000221 | rep | SC | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
4635 | 4635 | David Wagener W000016 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 7 | |||||||||||||
4638 | 4638 | Reuel Williams W000532 | sen | ME | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
4641 | 4641 | Sherrod Williams W000536 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4644 | 4644 | John Worthington W000748 | rep | MD | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4678 | 4678 | John Aycrigg A000350 | rep | NJ | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
4682 | 4682 | Linn Banks B000115 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
4692 | 4692 | Richard Bayard B000251 | sen | DE | 1836-06-17 | 1839-03-03 | 1 | Whig | |||||||||||||
4702 | 4702 | Nathaniel Borden B000636 | rep | MA | 1837-09-04 | 1839-03-03 | Democrat | 10 | |||||||||||||
4710 | 4710 | George Briggs B000830 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
4724 | 4724 | William Calhoun C000046 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 8 | |||||||||||||
4732 | 4732 | Zadok Casey C000230 | rep | IL | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4737 | 4737 | Timothy Childs C000355 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 28 | |||||||||||||
4745 | 4745 | John Clark C000443 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 21 | |||||||||||||
4759 | 4759 | Caleb Cushing C001016 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4777 | 4777 | George Evans E000241 | rep | ME | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4784 | 4784 | Horace Everett E000265 | rep | VT | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4805 | 4805 | Patrick Goode G000278 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4818 | 4818 | Hiland Hall H000052 | rep | VT | 1837-09-04 | 1839-03-03 | Whig | 1 | |||||||||||||
4821 | 4821 | William Halstead H000092 | rep | NJ | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
4826 | 4826 | William Hastings H000332 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 9 | |||||||||||||
4830 | 4830 | Thomas Henry H000518 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 24 | |||||||||||||
4844 | 4844 | William Johnson J000180 | rep | MD | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
4848 | 4848 | George Keim K000050 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 9 | |||||||||||||
4860 | 4860 | Levi Lincoln L000315 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
4866 | 4866 | Francis Mallory M000080 | rep | VA | 1837-09-04 | 1839-03-03 | Whig | 1 |
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);