legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
163 rows where "start" is on date 1805-12-02 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
683 | 683 | Theodore Dwight D000582 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
699 | 699 | Calvin Goddard G000248 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
705 | 705 | Roger Griswold G000488 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
751 | 751 | John Smith S000570 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
1725 | 1725 | Lewis Sturges S001048 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1740 | 1740 | Benjamin Tallmadge T000029 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1894 | 1894 | Timothy Pitkin P000368 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
2083 | 2083 | Jonathan Moseley M001023 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
812 | 812 | James Broom B000888 | rep | DE | 1805-12-02 | 1807-03-03 | Federalist | 0 | |||||||||||||
662 | 662 | Abraham Baldwin B000084 | sen | GA | 1805-12-02 | 1807-03-04 | 2 | Republican | |||||||||||||
672 | 672 | Joseph Bryan B000989 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
686 | 686 | Peter Early E000014 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
753 | 753 | Thomas Spalding S000698 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
877 | 877 | Benjamin Parke P000052 | rep | IN | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
664 | 664 | George Bedinger B000301 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
696 | 696 | John Fowler F000322 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
744 | 744 | Thomas Sandford S000041 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
772 | 772 | Buckner Thruston T000249 | sen | KY | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
781 | 781 | Matthew Walton W000116 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
807 | 807 | John Boyle B000729 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1025 | 1025 | Matthew Lyon L000545 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
3284 | 3284 | John Adair A000026 | sen | KY | 1805-12-02 | 1807-03-03 | 3 | Republican | |||||||||||||
670 | 670 | Phanuel Bishop B000488 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
715 | 715 | Seth Hastings H000331 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 10 | |||||||||||||
779 | 779 | Peleg Wadsworth W000014 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 15 | |||||||||||||
800 | 800 | Joseph Barker B000144 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
802 | 802 | Barnabas Bidwell B000446 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 12 | |||||||||||||
826 | 826 | Jacob Crowninshield C000947 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
964 | 964 | Orchard Cook C000723 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 16 | |||||||||||||
1069 | 1069 | William Stedman S000828 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 11 | |||||||||||||
1144 | 1144 | Richard Cutts C001033 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
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 | |||||||||||||
1218 | 1218 | Ebenezer Seaver S000215 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 13 | |||||||||||||
1251 | 1251 | Joseph Varnum V000074 | rep | MA | 1805-12-02 | 1807-03-03 | Democratic Republican | 4 | |||||||||||||
1330 | 1330 | William Ely E000168 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 5 | |||||||||||||
1688 | 1688 | Timothy Pickering P000324 | sen | MA | 1805-12-02 | 1811-03-03 | 2 | Federalist | |||||||||||||
1732 | 1732 | Samuel Taggart T000012 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 6 | |||||||||||||
2390 | 2390 | John Chandler C000291 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 17 | |||||||||||||
3496 | 3496 | Jeremiah Nelson N000036 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 3 | |||||||||||||
655 | 655 | John Archer A000272 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
679 | 679 | Leonard Covington C000817 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
728 | 728 | Patrick Magruder M000057 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
737 | 737 | Joseph Nicholson N000100 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
872 | 872 | William McCreery M000387 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
955 | 955 | John Campbell C000091 | rep | MD | 1805-12-02 | 1807-03-03 | Federalist | 1 | |||||||||||||
1041 | 1041 | Roger Nelson N000041 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
1580 | 1580 | Charles Goldsborough G000261 | rep | MD | 1805-12-02 | 1807-03-03 | Federalist | 8 | |||||||||||||
1669 | 1669 | Nicholas Moore M000909 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
2660 | 2660 | Edward Lloyd L000376 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
1637 | 1637 | William Lattimore L000118 | rep | MS | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
729 | 729 | Duncan McFarlan M000437 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
788 | 788 | Joseph Winston W000642 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 12 | |||||||||||||
791 | 791 | Thomas Wynns W000786 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
924 | 924 | Marmaduke Williams W000529 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
993 | 993 | James Holland H000718 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 11 | |||||||||||||
1006 | 1006 | Thomas Kenan K000089 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
1243 | 1243 | James Turner T000423 | sen | NC | 1805-12-02 | 1811-03-03 | 2 | Republican | |||||||||||||
1716 | 1716 | Richard Stanford S000794 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
2671 | 2671 | Nathaniel Macon M000034 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
3026 | 3026 | Willis Alston A000167 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
666 | 666 | Silas Betton B000425 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
687 | 687 | Caleb Ellis E000130 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
717 | 717 | David Hough H000811 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
768 | 768 | Samuel Tenney T000127 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1168 | 1168 | Nicholas Gilman G000215 | sen | NH | 1805-12-02 | 1811-03-03 | 2 | Republican | |||||||||||||
1442 | 1442 | Thomas Thompson T000220 | 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 | |||||||||||||
722 | 722 | Aaron Kitchell K000246 | sen | NJ | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
828 | 828 | Ezra Darby D000047 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
890 | 890 | James Sloan S000493 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
979 | 979 | William Helms H000464 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
1010 | 1010 | John Lambert L000036 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
2142 | 2142 | Henry Southard S000685 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
706 | 706 | Silas Halsey H000090 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 17 | |||||||||||||
724 | 724 | Henry Livingston L000367 | rep | NY | 1805-12-02 | 1807-03-03 | Federalist | 8 | |||||||||||||
742 | 742 | Peter Sailly S000015 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 11 | |||||||||||||
745 | 745 | Martin Schuneman S000149 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
784 | 784 | Eliphalet Wickes W000440 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
785 | 785 | Nathan Williams W000531 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 15 | |||||||||||||
804 | 804 | John Blake B000533 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
823 | 823 | George Clinton C000526 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
868 | 868 | Josiah Masters M000232 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 10 | |||||||||||||
887 | 887 | John Russell R000529 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
901 | 901 | David Thomas T000163 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 12 | |||||||||||||
917 | 917 | Philip Van Cortlandt V000022 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
920 | 920 | Daniel Verplanck V000088 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
1037 | 1037 | Gurdon Mumford M001076 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1082 | 1082 | Killian Van Rensselaer V000054 | rep | NY | 1805-12-02 | 1807-03-03 | Federalist | 9 | |||||||||||||
1214 | 1214 | Thomas Sammons S000023 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 13 | |||||||||||||
1238 | 1238 | Uri Tracy T000347 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 16 | |||||||||||||
4913 | 4913 | Jeremiah Morrow M001003 | rep | OH | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
817 | 817 | Daniel Clark C000426 | rep | OL | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
652 | 652 | Isaac Anderson A000191 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 3 |
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);