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 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3284 | 3284 | John Adair A000026 | sen | KY | 1805-12-02 | 1807-03-03 | 3 | Republican | |||||||||||||
798 | 798 | Evan Alexander A000092 | rep | NC | 1806-02-24 | 1807-03-03 | Republican | 10 | |||||||||||||
3026 | 3026 | Willis Alston A000167 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
652 | 652 | Isaac Anderson A000191 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
655 | 655 | John Archer A000272 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
1461 | 1461 | David Bard B000137 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
800 | 800 | Joseph Barker B000144 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
2781 | 2781 | Burwell Bassett B000224 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 12 | |||||||||||||
664 | 664 | George Bedinger B000301 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
666 | 666 | Silas Betton B000425 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1279 | 1279 | William Bibb B000434 | rep | GA | 1807-01-26 | 1807-03-03 | Republican | -1 | |||||||||||||
802 | 802 | Barnabas Bidwell B000446 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 12 | |||||||||||||
670 | 670 | Phanuel Bishop B000488 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
1108 | 1108 | William Blackledge B000511 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
804 | 804 | John Blake B000533 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
1115 | 1115 | Thomas Blount B000569 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
807 | 807 | John Boyle B000729 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
810 | 810 | Stephen Bradley B000745 | sen | VT | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
812 | 812 | James Broom B000888 | rep | DE | 1805-12-02 | 1807-03-03 | Federalist | 0 | |||||||||||||
1299 | 1299 | Robert Brown B000942 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
672 | 672 | Joseph Bryan B000989 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
1981 | 1981 | William Burwell B001160 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 13 | |||||||||||||
1124 | 1124 | William Butler B001194 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1485 | 1485 | George Campbell C000083 | rep | TN | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
955 | 955 | John Campbell C000091 | rep | MD | 1805-12-02 | 1807-03-03 | Federalist | 1 | |||||||||||||
674 | 674 | Levi Casey C000226 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
2390 | 2390 | John Chandler C000291 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 17 | |||||||||||||
1130 | 1130 | Martin Chittenden C000372 | rep | VT | 1805-12-02 | 1807-03-03 | Federalist | 4 | |||||||||||||
815 | 815 | John Claiborne C000403 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 17 | |||||||||||||
676 | 676 | Christopher Clark C000424 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 13 | |||||||||||||
817 | 817 | Daniel Clark C000426 | rep | OL | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
5928 | 5928 | Henry Clay C000482 | sen | KY | 1806-01-01 | 1807-03-03 | 3 | Republican | |||||||||||||
820 | 820 | Joseph Clay C000486 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
1506 | 1506 | Matthew Clay C000487 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
823 | 823 | George Clinton C000526 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1517 | 1517 | John Clopton C000531 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 22 | |||||||||||||
678 | 678 | Frederick Conrad C000704 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
964 | 964 | Orchard Cook C000723 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 16 | |||||||||||||
679 | 679 | Leonard Covington C000817 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
826 | 826 | Jacob Crowninshield C000947 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1144 | 1144 | Richard Cutts C001033 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
1536 | 1536 | Samuel Dana D000024 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
828 | 828 | Ezra Darby D000047 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
1544 | 1544 | John Davenport D000075 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1322 | 1322 | John Dawson D000151 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 10 | |||||||||||||
682 | 682 | William Dickson D000333 | rep | TN | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
683 | 683 | Theodore Dwight D000582 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
2013 | 2013 | Elias Earle E000007 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
686 | 686 | Peter Early E000014 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
833 | 833 | James Elliott E000122 | rep | VT | 1805-12-02 | 1807-03-03 | Federalist | 2 | |||||||||||||
687 | 687 | Caleb Ellis E000130 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
690 | 690 | Ebenezer Elmer E000154 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
1330 | 1330 | William Ely E000168 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 5 | |||||||||||||
1831 | 1831 | John Eppes E000197 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 16 | |||||||||||||
1558 | 1558 | William Findley F000124 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
1836 | 1836 | James Fisk F000154 | rep | VT | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
696 | 696 | John Fowler F000322 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
2604 | 2604 | John Gaillard G000005 | sen | SC | 1804-01-01 | 1807-03-03 | 3 | Republican | |||||||||||||
839 | 839 | James Garnett G000075 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 11 | |||||||||||||
699 | 699 | Calvin Goddard G000248 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1580 | 1580 | Charles Goldsborough G000261 | rep | MD | 1805-12-02 | 1807-03-03 | Federalist | 8 | |||||||||||||
1846 | 1846 | Peterson Goodwyn G000306 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 18 | |||||||||||||
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 | |||||||||||||
852 | 852 | Andrew Gregg G000442 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
705 | 705 | Roger Griswold G000488 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
706 | 706 | Silas Halsey H000090 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 17 | |||||||||||||
707 | 707 | John Hamilton H000111 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 10 | |||||||||||||
712 | 712 | John Hanna H000161 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
715 | 715 | Seth Hastings H000331 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 10 | |||||||||||||
979 | 979 | William Helms H000464 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
993 | 993 | James Holland H000718 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 11 | |||||||||||||
2178 | 2178 | David Holmes H000735 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
717 | 717 | David Hough H000811 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
495 | 495 | James Jackson J000017 | sen | GA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
1621 | 1621 | John Jackson J000021 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
1003 | 1003 | Walter Jones J000254 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
862 | 862 | James Kelly K000073 | rep | PA | 1805-12-02 | 1807-03-03 | Federalist | 6 | |||||||||||||
1006 | 1006 | Thomas Kenan K000089 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
866 | 866 | Nehemiah Knight K000286 | rep | RI | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
1010 | 1010 | John Lambert L000036 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
1637 | 1637 | William Lattimore L000118 | rep | MS | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
1016 | 1016 | Michael Leib L000229 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
1644 | 1644 | Joseph Lewis L000290 | rep | VA | 1805-12-02 | 1807-03-03 | Federalist | 7 | |||||||||||||
724 | 724 | Henry Livingston L000367 | rep | NY | 1805-12-02 | 1807-03-03 | Federalist | 8 | |||||||||||||
2660 | 2660 | Edward Lloyd L000376 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
502 | 502 | George Logan L000401 | sen | PA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
725 | 725 | Christian Lower L000478 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
727 | 727 | John Lucas L000492 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
1025 | 1025 | Matthew Lyon L000545 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
2671 | 2671 | Nathaniel Macon M000034 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
728 | 728 | Patrick Magruder M000057 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1031 | 1031 | Robert Marion M000130 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
868 | 868 | Josiah Masters M000232 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 10 | |||||||||||||
872 | 872 | William McCreery M000387 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
729 | 729 | Duncan McFarlan M000437 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
730 | 730 | Cowles Mead M000614 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
733 | 733 | David Meriwether M000649 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
796 | 796 | John Milledge M000712 | sen | GA | 1806-06-19 | 1807-03-03 | 3 | Republican | |||||||||||||
1669 | 1669 | Nicholas Moore M000909 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 5 |
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);