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 party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4464 | 4464 | Charles Downing D000472 | rep | FL | 1839-12-02 | 1841-03-03 | -1 | ||||||||||||||
4404 | 4404 | Richard Biddle B000443 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 22 | |||||||||||||
4453 | 4453 | Edward Davies D000088 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 4 | |||||||||||||
4769 | 4769 | John Edwards E000074 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 4 | |||||||||||||
4831 | 4831 | Thomas Henry H000518 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 24 | |||||||||||||
4841 | 4841 | Francis James J000049 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 4 | |||||||||||||
4925 | 4925 | Charles Ogle O000047 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 18 | |||||||||||||
4478 | 4478 | James Garland G000067 | rep | VA | 1839-12-02 | 1841-03-03 | Conservative | 12 | |||||||||||||
7092 | 7092 | George Hopkins H000774 | rep | VA | 1839-12-02 | 1841-03-03 | Conservative | 18 | |||||||||||||
3854 | 3854 | Bedford Brown B000903 | sen | NC | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
3943 | 3943 | Henry Hubbard H000883 | sen | NH | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4050 | 4050 | John Robinson R000344 | sen | IL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4051 | 4051 | John Ruggles R000502 | sen | ME | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4087 | 4087 | Garret Wall W000071 | sen | NJ | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4114 | 4114 | Robert Nicholas N000085 | sen | LA | 1836-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4267 | 4267 | Wilson Lumpkin L000512 | sen | GA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4304 | 4304 | John Norvell N000158 | sen | MI | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4335 | 4335 | William Roane R000293 | sen | VA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4393 | 4393 | Judson Allen A000137 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 20 | |||||||||||||
4396 | 4396 | Hugh Anderson A000190 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
4413 | 4413 | Jesse Bynum B001204 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
4423 | 4423 | William Chapman C000318 | rep | IA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4434 | 4434 | Henry Connor C000700 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 11 | |||||||||||||
4435 | 4435 | William Cooper C000766 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4442 | 4442 | Robert Craig C000859 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4445 | 4445 | Isaac Crary C000882 | rep | MI | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4451 | 4451 | Thomas Davee D000068 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4454 | 4454 | John Davis D000116 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4455 | 4455 | James De La Montanya D000205 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4460 | 4460 | Philemon Dickerson D000309 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4465 | 4465 | Nehemiah Earll E000012 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4466 | 4466 | John Ely E000166 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
4475 | 4475 | John Galbraith G000011 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 25 | |||||||||||||
4490 | 4490 | John Griffin G000462 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
4496 | 4496 | Felix Grundy G000509 | sen | TN | 1839-12-02 | 1841-03-03 | 1 | Democrat | |||||||||||||
4498 | 4498 | Robert Hammond H000132 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 16 | |||||||||||||
4499 | 4499 | Augustus Hand H000152 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4502 | 4502 | Albert Harrison H000261 | rep | MO | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4509 | 4509 | Micajah Hawkins H000373 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4511 | 4511 | John Hill H000594 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
4513 | 4513 | Solomon Hillen Solomon H000617 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4516 | 4516 | Joel Holleman H000721 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4518 | 4518 | Tilghman Howard H000844 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4520 | 4520 | Thomas Jackson J000027 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4527 | 4527 | Nathaniel Jones J000243 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4529 | 4529 | Gouverneur Kemble K000084 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4531 | 4531 | Joseph Kille K000178 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4535 | 4535 | Daniel Leadbetter L000172 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4536 | 4536 | Isaac Leet L000211 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 21 | |||||||||||||
4538 | 4538 | Stephen Leonard L000249 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 22 | |||||||||||||
4539 | 4539 | Meredith Mallory M000081 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 27 | |||||||||||||
4544 | 4544 | Charles McClure M000345 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4545 | 4545 | George McCulloch M000389 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
4563 | 4563 | William Montgomery M000874 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4565 | 4565 | Samuel Morris M000987 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4570 | 4570 | Virgil Parris P000081 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4572 | 4572 | Lemuel Paynter P000155 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4576 | 4576 | David Petrikin P000267 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 15 | |||||||||||||
4578 | 4578 | William Potter P000469 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
4580 | 4580 | John Prentiss P000509 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4581 | 4581 | William Ramsey R000030 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4598 | 4598 | Eleazar Ripley R000265 | rep | LA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4600 | 4600 | Francis Rives R000284 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4601 | 4601 | Thomas Robinson R000353 | rep | DE | 1839-12-02 | 1841-03-03 | Democrat | 0 | |||||||||||||
4602 | 4602 | Edward Rogers R000393 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4606 | 4606 | Daniel Ryall R000554 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4607 | 4607 | Green Samuels S000028 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 16 | |||||||||||||
4609 | 4609 | Charles Shepard S000329 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4610 | 4610 | Albert Smith S000513 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4611 | 4611 | John Smith S000565 | rep | VT | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4619 | 4619 | Theron Strong S001020 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 25 | |||||||||||||
4621 | 4621 | Henry Swearingen S001099 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4625 | 4625 | Jonathan Taylor T000092 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 12 | |||||||||||||
4631 | 4631 | Aaron Vanderpoel V000028 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4632 | 4632 | Peter Vroom V000123 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4636 | 4636 | David Wagener W000016 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4645 | 4645 | John Worthington W000748 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
4646 | 4646 | Alexander Anderson A000181 | sen | TN | 1840-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4683 | 4683 | Linn Banks B000115 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4705 | 4705 | David Brewster B000814 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
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 | |||||||||||||
4733 | 4733 | Zadok Casey C000230 | rep | IL | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4753 | 4753 | Nathan Clifford C000518 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4763 | 4763 | William Doan D000380 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4765 | 4765 | Andrew Doig D000400 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 16 | |||||||||||||
4767 | 4767 | Ira Eastman E000020 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4790 | 4790 | Joseph Fornance F000276 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4797 | 4797 | William Fulton F000425 | sen | AR | 1836-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4803 | 4803 | James Gerry G000140 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 11 | |||||||||||||
4824 | 4824 | John Hastings H000328 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4833 | 4833 | Enos Hook H000756 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 20 | |||||||||||||
4849 | 4849 | George Keim K000050 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 9 |
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);