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 end
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
670 | 670 | Phanuel Bishop B000488 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
672 | 672 | Joseph Bryan B000989 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
674 | 674 | Levi Casey C000226 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
676 | 676 | Christopher Clark C000424 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 13 | |||||||||||||
678 | 678 | Frederick Conrad C000704 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
679 | 679 | Leonard Covington C000817 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
686 | 686 | Peter Early E000014 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
696 | 696 | John Fowler F000322 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
717 | 717 | David Hough H000811 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
724 | 724 | Henry Livingston L000367 | rep | NY | 1805-12-02 | 1807-03-03 | Federalist | 8 | |||||||||||||
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 | |||||||||||||
728 | 728 | Patrick Magruder M000057 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
737 | 737 | Joseph Nicholson N000100 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
739 | 739 | Gideon Olin O000067 | rep | VT | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
741 | 741 | Thomas Randolph R000051 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 21 | |||||||||||||
742 | 742 | Peter Sailly S000015 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 11 | |||||||||||||
744 | 744 | Thomas Sandford S000041 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
745 | 745 | Martin Schuneman S000149 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
751 | 751 | John Smith S000570 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
752 | 752 | O’Brien Smith S000598 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
753 | 753 | Thomas Spalding S000698 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
757 | 757 | Joseph Stanton S000805 | rep | RI | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
768 | 768 | Samuel Tenney T000127 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
771 | 771 | Philip Thompson T000213 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
779 | 779 | Peleg Wadsworth W000014 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 15 | |||||||||||||
781 | 781 | Matthew Walton W000116 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
783 | 783 | John Whitehill W000403 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
804 | 804 | John Blake B000533 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
807 | 807 | John Boyle B000729 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
812 | 812 | James Broom B000888 | rep | DE | 1805-12-02 | 1807-03-03 | Federalist | 0 | |||||||||||||
815 | 815 | John Claiborne C000403 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 17 | |||||||||||||
817 | 817 | Daniel Clark C000426 | rep | OL | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
820 | 820 | Joseph Clay C000486 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
823 | 823 | George Clinton C000526 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
826 | 826 | Jacob Crowninshield C000947 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
828 | 828 | Ezra Darby D000047 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
833 | 833 | James Elliott E000122 | rep | VT | 1805-12-02 | 1807-03-03 | Federalist | 2 | |||||||||||||
839 | 839 | James Garnett G000075 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 11 | |||||||||||||
852 | 852 | Andrew Gregg G000442 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
862 | 862 | James Kelly K000073 | rep | PA | 1805-12-02 | 1807-03-03 | Federalist | 6 | |||||||||||||
866 | 866 | Nehemiah Knight K000286 | rep | RI | 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 | |||||||||||||
875 | 875 | John Morrow M001005 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
877 | 877 | Benjamin Parke P000052 | rep | IN | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
880 | 880 | John Pugh P000562 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
883 | 883 | Jacob Richards R000212 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
887 | 887 | John Russell R000529 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
890 | 890 | James Sloan S000493 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
901 | 901 | David Thomas T000163 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 12 | |||||||||||||
908 | 908 | Abram Trigg T000368 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
924 | 924 | Marmaduke Williams W000529 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
927 | 927 | Alexander Wilson W000568 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
955 | 955 | John Campbell C000091 | rep | MD | 1805-12-02 | 1807-03-03 | Federalist | 1 | |||||||||||||
964 | 964 | Orchard Cook C000723 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 16 | |||||||||||||
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 | |||||||||||||
1003 | 1003 | Walter Jones J000254 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
1006 | 1006 | Thomas Kenan K000089 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
1010 | 1010 | John Lambert L000036 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
1016 | 1016 | Michael Leib L000229 | 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 | |||||||||||||
1031 | 1031 | Robert Marion M000130 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
1037 | 1037 | Gurdon Mumford M001076 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1041 | 1041 | Roger Nelson N000041 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
1049 | 1049 | John Porter P000443 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
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 |
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);