legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
225 rows where "start" is on date 1815-12-04 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5932 | 5932 | Henry Clay C000482 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
5872 | 5872 | William King K000217 | rep | NC | 1815-12-04 | 1816-11-04 | Republican | 5 | |||||||||||||
5635 | 5635 | John Calhoun C000044 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
5565 | 5565 | Daniel Webster W000238 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
5070 | 5070 | Lewis Williams W000527 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 13 | |||||||||||||
4989 | 4989 | John Sergeant S000246 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
4749 | 4749 | Thomas Clayton C000499 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
4695 | 4695 | Victory Birdseye B000484 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
4653 | 4653 | John Tyler T000450 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 23 | |||||||||||||
4650 | 4650 | William Harrison H000279 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
4585 | 4585 | John Reed R000121 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 9 | |||||||||||||
4334 | 4334 | William Roane R000293 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
4263 | 4263 | Wilson Lumpkin L000512 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
4184 | 4184 | Alfred Cuthbert C001023 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
3959 | 3959 | Richard Johnson J000170 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
3919 | 3919 | Benjamin Hardin H000184 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
3819 | 3819 | Richard Wilde W000460 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
3780 | 3780 | John Randolph R000047 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 16 | |||||||||||||
3610 | 3610 | William Baylies B000256 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 8 | |||||||||||||
3592 | 3592 | John Adams A000038 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
3553 | 3553 | John Taylor T000091 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
3539 | 3539 | Erastus Root R000431 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
3511 | 3511 | Thomas Newton N000078 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
3497 | 3497 | Jeremiah Nelson N000036 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 3 | |||||||||||||
3480 | 3480 | Stephen Miller M000755 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
3471 | 3471 | William McCoy M000377 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
3399 | 3399 | William Hendricks H000494 | rep | IN | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
3384 | 3384 | John Forsyth F000284 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
3355 | 3355 | William Creighton C000902 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
3340 | 3340 | Lewis Condict C000668 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
3149 | 3149 | Jonathan Jennings J000097 | rep | IN | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
3138 | 3138 | Samuel Ingham I000022 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
3063 | 3063 | James Clark C000436 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
3040 | 3040 | Philip Barbour B000131 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
2964 | 2964 | Samuel Smith S000609 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2938 | 2938 | Benjamin Ruggles R000500 | sen | OH | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2928 | 2928 | Albion Parris P000079 | rep | MA | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
2871 | 2871 | Peter Little L000354 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2825 | 2825 | John Culpepper C000976 | rep | NC | 1815-12-04 | 1817-03-03 | Federalist | 7 | |||||||||||||
2785 | 2785 | Burwell Bassett B000224 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 13 | |||||||||||||
2757 | 2757 | Nathan Sanford S000052 | sen | NY | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2753 | 2753 | Israel Pickens P000322 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
2744 | 2744 | Ephraim Bateman B000228 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
2714 | 2714 | John Scott S000176 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2694 | 2694 | George Peter P000250 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 3 | |||||||||||||
2676 | 2676 | Nathaniel Macon M000034 | rep | NC | 1815-12-04 | 1815-12-13 | Republican | 6 | |||||||||||||
2590 | 2590 | Weldon Edwards E000083 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
2465 | 2465 | James Reynolds R000173 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
2427 | 2427 | Charles Hooks H000761 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2357 | 2357 | Robert Wright W000768 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
2302 | 2302 | William Pinkney P000362 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2282 | 2282 | Hugh Nelson N000035 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 22 | |||||||||||||
2269 | 2269 | William Milnor M000786 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
2261 | 2261 | William Lowndes L000483 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
2226 | 2226 | William Darlington D000059 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
2216 | 2216 | Newton Cannon C000123 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2193 | 2193 | James Barbour B000127 | sen | VA | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2186 | 2186 | Isham Talbot T000017 | sen | KY | 1815-12-04 | 1819-03-03 | 3 | Republican | |||||||||||||
2182 | 2182 | Elijah Mills M000774 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 5 | |||||||||||||
2171 | 2171 | Peter Wendover W000293 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
2168 | 2168 | James Wallace W000078 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
2145 | 2145 | Henry Southard S000685 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
2134 | 2134 | Ballard Smith S000516 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
2107 | 2107 | James Pleasants P000386 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 17 | |||||||||||||
2088 | 2088 | Jonathan Moseley M001023 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
2074 | 2074 | Alney McLean M000544 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2064 | 2064 | William Maclay M000033 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
2047 | 2047 | James Johnson J000142 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
2041 | 2041 | Joseph Hiester H000574 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
1986 | 1986 | William Burwell B001160 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 14 | |||||||||||||
1968 | 1968 | Stevenson Archer A000273 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1960 | 1960 | Benjamin Adams A000030 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 11 | |||||||||||||
1953 | 1953 | William Wilson W000618 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
1948 | 1948 | John Williams W000516 | sen | TN | 1815-12-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1946 | 1946 | James Wilkin W000472 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1944 | 1944 | John Whiteside W000412 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1941 | 1941 | Henry Tucker T000398 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1939 | 1939 | George Townsend T000333 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1935 | 1935 | Philip Stuart S001036 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1931 | 1931 | Solomon Strong S001017 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 12 | |||||||||||||
1916 | 1916 | John Savage S000082 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
1914 | 1914 | Nathaniel Ruggles R000503 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 13 | |||||||||||||
1911 | 1911 | John Ross R000449 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1908 | 1908 | Thomas Robertson R000326 | rep | LA | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1904 | 1904 | Thomas Rice R000204 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 18 | |||||||||||||
1901 | 1901 | Nathaniel Pope P000432 | rep | IL | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1899 | 1899 | Timothy Pitkin P000368 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1882 | 1882 | Thomas Nelson N000043 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 18 | |||||||||||||
1878 | 1878 | Henry Middleton M000699 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1876 | 1876 | James Mason M000215 | rep | RI | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1873 | 1873 | William Maclay M000030 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
1867 | 1867 | William Irving I000038 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1861 | 1861 | Joseph Hopkinson H000784 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1856 | 1856 | John Herbert H000525 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1851 | 1851 | Peterson Goodwyn G000306 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
1841 | 1841 | Daniel Forney F000278 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
1826 | 1826 | Joseph Desha D000271 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1817 | 1817 | Zadock Cook C000728 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1815 | 1815 | Oliver Comstock C000664 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
1806 | 1806 | Joseph Bryan B000990 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 2 |
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);