legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
170 rows where "end" is on date 1807-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1060 | 1060 | Dennis Smelt S000507 | rep | GA | 1806-09-01 | 1807-03-03 | Republican | 0 | |||||||||||||
1063 | 1063 | Samuel Smith S000610 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 11 | |||||||||||||
1069 | 1069 | William Stedman S000828 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 11 | |||||||||||||
1082 | 1082 | Killian Van Rensselaer V000054 | rep | NY | 1805-12-02 | 1807-03-03 | Federalist | 9 | |||||||||||||
1094 | 1094 | Thomas Worthington W000750 | sen | OH | 1803-10-17 | 1807-03-03 | 3 | Republican | |||||||||||||
1108 | 1108 | William Blackledge B000511 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
1115 | 1115 | Thomas Blount B000569 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1124 | 1124 | William Butler B001194 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1130 | 1130 | Martin Chittenden C000372 | rep | VT | 1805-12-02 | 1807-03-03 | Federalist | 4 | |||||||||||||
1144 | 1144 | Richard Cutts C001033 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
1173 | 1173 | Edwin Gray G000394 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 19 | |||||||||||||
1177 | 1177 | Isaiah Green G000413 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
1208 | 1208 | Josiah Quincy Q000015 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 1 | |||||||||||||
1214 | 1214 | Thomas Sammons S000023 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 13 | |||||||||||||
1218 | 1218 | Ebenezer Seaver S000215 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 13 | |||||||||||||
1229 | 1229 | John Smilie S000508 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
1238 | 1238 | Uri Tracy T000347 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 16 | |||||||||||||
1251 | 1251 | Joseph Varnum V000074 | rep | MA | 1805-12-02 | 1807-03-03 | Democratic Republican | 4 | |||||||||||||
1257 | 1257 | David Williams W000495 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1265 | 1265 | Richard Winn W000637 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
1279 | 1279 | William Bibb B000434 | rep | GA | 1807-01-26 | 1807-03-03 | Republican | -1 | |||||||||||||
1299 | 1299 | Robert Brown B000942 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1322 | 1322 | John Dawson D000151 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 10 | |||||||||||||
1330 | 1330 | William Ely E000168 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 5 | |||||||||||||
1389 | 1389 | John Rea R000089 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
1408 | 1408 | John Smith S000564 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1417 | 1417 | David Stone S000955 | sen | NC | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
1427 | 1427 | Robert Whitehill W000404 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
1442 | 1442 | Thomas Thompson T000220 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1461 | 1461 | David Bard B000137 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
1485 | 1485 | George Campbell C000083 | rep | TN | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1506 | 1506 | Matthew Clay C000487 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
1517 | 1517 | John Clopton C000531 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 22 | |||||||||||||
1536 | 1536 | Samuel Dana D000024 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1544 | 1544 | John Davenport D000075 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1558 | 1558 | William Findley F000124 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
1580 | 1580 | Charles Goldsborough G000261 | rep | MD | 1805-12-02 | 1807-03-03 | Federalist | 8 | |||||||||||||
1621 | 1621 | John Jackson J000021 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
1637 | 1637 | William Lattimore L000118 | rep | MS | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
1644 | 1644 | Joseph Lewis L000290 | rep | VA | 1805-12-02 | 1807-03-03 | Federalist | 7 | |||||||||||||
1669 | 1669 | Nicholas Moore M000909 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
1676 | 1676 | Thomas Moore M000919 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
1716 | 1716 | Richard Stanford S000794 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
1725 | 1725 | Lewis Sturges S001048 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1732 | 1732 | Samuel Taggart T000012 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 6 | |||||||||||||
1740 | 1740 | Benjamin Tallmadge T000029 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1831 | 1831 | John Eppes E000197 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 16 | |||||||||||||
1836 | 1836 | James Fisk F000154 | rep | VT | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1846 | 1846 | Peterson Goodwyn G000306 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 18 | |||||||||||||
1894 | 1894 | Timothy Pitkin P000368 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1981 | 1981 | William Burwell B001160 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 13 | |||||||||||||
2013 | 2013 | Elias Earle E000007 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
2083 | 2083 | Jonathan Moseley M001023 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
2142 | 2142 | Henry Southard S000685 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
2178 | 2178 | David Holmes H000735 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
2305 | 2305 | Philip Reed R000125 | sen | MD | 1806-11-25 | 1807-03-03 | 3 | Republican | |||||||||||||
2313 | 2313 | John Rhea R000181 | rep | TN | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
2353 | 2353 | Robert Wright W000768 | sen | MD | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
2390 | 2390 | John Chandler C000291 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 17 | |||||||||||||
2604 | 2604 | John Gaillard G000005 | sen | SC | 1804-01-01 | 1807-03-03 | 3 | Republican | |||||||||||||
2660 | 2660 | Edward Lloyd L000376 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
2671 | 2671 | Nathaniel Macon M000034 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
2781 | 2781 | Burwell Bassett B000224 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 12 | |||||||||||||
3026 | 3026 | Willis Alston A000167 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
3284 | 3284 | John Adair A000026 | sen | KY | 1805-12-02 | 1807-03-03 | 3 | Republican | |||||||||||||
3496 | 3496 | Jeremiah Nelson N000036 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 3 | |||||||||||||
3506 | 3506 | Thomas Newton N000078 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 20 | |||||||||||||
3776 | 3776 | John Randolph R000047 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 15 | |||||||||||||
4913 | 4913 | Jeremiah Morrow M001003 | rep | OH | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
5928 | 5928 | Henry Clay C000482 | sen | KY | 1806-01-01 | 1807-03-03 | 3 | Republican |
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);