legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
165 rows where "end" is on date 1805-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4912 | 4912 | Jeremiah Morrow M001003 | rep | OH | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
3775 | 3775 | John Randolph R000047 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 15 | |||||||||||||
3537 | 3537 | Erastus Root R000431 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 14 | |||||||||||||
3505 | 3505 | Thomas Newton N000078 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 20 | |||||||||||||
3025 | 3025 | Willis Alston A000167 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
2712 | 2712 | Joshua Sands S000046 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
2670 | 2670 | Nathaniel Macon M000034 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
2491 | 2491 | James Stephenson S000864 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
2365 | 2365 | Caesar Rodney R000377 | rep | DE | 1803-10-17 | 1805-03-03 | Republican | 0 | |||||||||||||
2312 | 2312 | John Rhea R000181 | rep | TN | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
2292 | 2292 | Anthony New N000058 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 11 | |||||||||||||
2234 | 2234 | William Eustis E000230 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
2177 | 2177 | David Holmes H000735 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
2141 | 2141 | Henry Southard S000685 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
2040 | 2040 | Joseph Hiester H000574 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
1992 | 1992 | Clifton Clagett C000399 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1854 | 1854 | Josiah Hasbrouck H000314 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 7 | |||||||||||||
1845 | 1845 | Peterson Goodwyn G000306 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 18 | |||||||||||||
1830 | 1830 | John Eppes E000197 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 16 | |||||||||||||
1739 | 1739 | Benjamin Tallmadge T000029 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1731 | 1731 | Samuel Taggart T000012 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 6 | |||||||||||||
1715 | 1715 | Richard Stanford S000794 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
1687 | 1687 | Timothy Pickering P000324 | sen | MA | 1803-10-17 | 1805-03-03 | 2 | Federalist | |||||||||||||
1675 | 1675 | Thomas Moore M000919 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 7 | |||||||||||||
1668 | 1668 | Nicholas Moore M000909 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
1643 | 1643 | Joseph Lewis L000290 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 7 | |||||||||||||
1636 | 1636 | William Lattimore L000118 | rep | MS | 1803-10-17 | 1805-03-03 | -1 | ||||||||||||||
1620 | 1620 | John Jackson J000021 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
1609 | 1609 | Benjamin Huger H000915 | rep | SC | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
1557 | 1557 | William Findley F000124 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
1543 | 1543 | John Davenport D000075 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1535 | 1535 | Samuel Dana D000024 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1516 | 1516 | John Clopton C000531 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 22 | |||||||||||||
1505 | 1505 | Matthew Clay C000487 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 14 | |||||||||||||
1484 | 1484 | George Campbell C000083 | rep | TN | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
1460 | 1460 | David Bard B000137 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
1423 | 1423 | William Wells W000287 | sen | DE | 1799-12-02 | 1805-03-03 | 2 | Federalist | |||||||||||||
1407 | 1407 | John Smith S000564 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
1388 | 1388 | John Rea R000089 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 7 | |||||||||||||
1366 | 1366 | William Kennedy K000116 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
1321 | 1321 | John Dawson D000151 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 10 | |||||||||||||
1298 | 1298 | Robert Brown B000942 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
1264 | 1264 | Richard Winn W000637 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
1250 | 1250 | Joseph Varnum V000074 | rep | MA | 1803-10-17 | 1805-03-03 | Democratic Republican | 4 | |||||||||||||
1228 | 1228 | John Smilie S000508 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
1217 | 1217 | Ebenezer Seaver S000215 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 13 | |||||||||||||
1213 | 1213 | Thomas Sammons S000023 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 13 | |||||||||||||
1172 | 1172 | Edwin Gray G000394 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 19 | |||||||||||||
1161 | 1161 | William Giles G000183 | sen | VA | 1804-12-04 | 1805-03-03 | 2 | Republican | |||||||||||||
1143 | 1143 | Richard Cutts C001033 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 14 | |||||||||||||
1129 | 1129 | Martin Chittenden C000372 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 4 | |||||||||||||
1123 | 1123 | William Butler B001194 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
1118 | 1118 | Adam Boyd B000714 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
1107 | 1107 | William Blackledge B000511 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
1104 | 1104 | James Bayard B000249 | sen | DE | 1804-11-13 | 1805-03-03 | 2 | Federalist | |||||||||||||
1081 | 1081 | Killian Van Rensselaer V000054 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 9 | |||||||||||||
1068 | 1068 | William Stedman S000828 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 11 | |||||||||||||
1044 | 1044 | Wilson Nicholas N000086 | sen | VA | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
1040 | 1040 | Roger Nelson N000041 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
1024 | 1024 | Matthew Lyon L000545 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
1015 | 1015 | Michael Leib L000229 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
1002 | 1002 | Walter Jones J000254 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
992 | 992 | James Holland H000718 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 11 | |||||||||||||
978 | 978 | William Helms H000464 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
959 | 959 | William Chamberlain C000280 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
954 | 954 | John Campbell C000091 | rep | MD | 1803-10-17 | 1805-03-03 | Federalist | 1 | |||||||||||||
926 | 926 | Alexander Wilson W000568 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
923 | 923 | Marmaduke Williams W000529 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
919 | 919 | Daniel Verplanck V000088 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
916 | 916 | Philip Van Cortlandt V000022 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
907 | 907 | Abram Trigg T000368 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
900 | 900 | David Thomas T000163 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
889 | 889 | James Sloan S000493 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
885 | 885 | Samuel Riker R000257 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
882 | 882 | Jacob Richards R000212 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
871 | 871 | William McCreery M000387 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
865 | 865 | Nehemiah Knight K000286 | rep | RI | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
857 | 857 | William Hoge H000699 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 10 | |||||||||||||
851 | 851 | Andrew Gregg G000442 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
836 | 836 | Jesse Franklin F000344 | sen | NC | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
832 | 832 | James Elliott E000122 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
825 | 825 | Jacob Crowninshield C000947 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
822 | 822 | George Clinton C000526 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
819 | 819 | Joseph Clay C000486 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
806 | 806 | John Boyle B000729 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
790 | 790 | Thomas Wynns W000786 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
787 | 787 | Joseph Winston W000642 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
782 | 782 | John Whitehill W000403 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
780 | 780 | Matthew Walton W000116 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
778 | 778 | Peleg Wadsworth W000014 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 15 | |||||||||||||
770 | 770 | Philip Thompson T000213 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
767 | 767 | Samuel Tenney T000127 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
763 | 763 | Thomas Sumter S001073 | sen | SC | 1801-12-15 | 1805-03-03 | 2 | Republican | |||||||||||||
756 | 756 | Joseph Stanton S000805 | rep | RI | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
750 | 750 | John Smith S000570 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
743 | 743 | Thomas Sandford S000041 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
740 | 740 | Thomas Randolph R000051 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 21 | |||||||||||||
738 | 738 | Gideon Olin O000067 | rep | VT | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
736 | 736 | Joseph Nicholson N000100 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 7 | |||||||||||||
732 | 732 | David Meriwether M000649 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -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);