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 end
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330 | 330 | John Brown B000929 | sen | KY | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
335 | 335 | William Cocke C000572 | sen | TN | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
347 | 347 | Jonathan Dayton D000165 | sen | NJ | 1799-12-02 | 1805-03-03 | 2 | Federalist | |||||||||||||
468 | 468 | Christopher Ellery E000114 | sen | RI | 1801-12-07 | 1805-03-03 | 2 | Republican | |||||||||||||
514 | 514 | Simeon Olcott O000060 | sen | NH | 1801-12-07 | 1805-03-03 | 2 | Federalist | |||||||||||||
550 | 550 | Pierce Butler B001186 | sen | SC | 1802-01-01 | 1805-03-03 | 3 | Republican | |||||||||||||
557 | 557 | Theodorus Bailey B000049 | sen | NY | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
558 | 558 | Simeon Baldwin B000097 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
560 | 560 | Walter Bowie B000697 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
561 | 561 | Phineas Bruce B000970 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 17 | |||||||||||||
566 | 566 | Thomas Claiborne C000406 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 17 | |||||||||||||
568 | 568 | Manasseh Cutler C001026 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
572 | 572 | John Dennis D000243 | rep | MD | 1803-10-17 | 1805-03-03 | Federalist | 8 | |||||||||||||
573 | 573 | Thomas Dwight D000583 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 5 | |||||||||||||
574 | 574 | John Earle E000008 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
578 | 578 | James Gillespie G000196 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
579 | 579 | Thomas Griffin G000467 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 12 | |||||||||||||
580 | 580 | Gaylord Griswold G000482 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 15 | |||||||||||||
581 | 581 | Samuel Hammond H000133 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
583 | 583 | Wade Hampton H000140 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
589 | 589 | Daniel Hiester H000570 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
590 | 590 | John Hoge H000695 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 10 | |||||||||||||
592 | 592 | Samuel Hunt H000976 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
593 | 593 | Simon Larned L000097 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
594 | 594 | Thomas Lewis L000294 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 5 | |||||||||||||
596 | 596 | Thomas Lowndes L000482 | rep | SC | 1803-10-17 | 1805-03-03 | Federalist | 1 | |||||||||||||
599 | 599 | Andrew McCord M000359 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
600 | 600 | Nahum Mitchell M000824 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 7 | |||||||||||||
602 | 602 | James Mott M001039 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
603 | 603 | Beriah Palmer P000036 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 11 | |||||||||||||
604 | 604 | John Paterson P000101 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 16 | |||||||||||||
605 | 605 | Oliver Phelps P000298 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 17 | |||||||||||||
607 | 607 | Thomas Plater P000378 | rep | MD | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
608 | 608 | Samuel Potter P000468 | sen | RI | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
609 | 609 | Samuel Purviance P000577 | rep | NC | 1803-10-17 | 1805-03-03 | Federalist | 7 | |||||||||||||
612 | 612 | Thomson Skinner S000471 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
621 | 621 | John Stewart S000912 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
623 | 623 | Samuel Thatcher T000143 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 16 | |||||||||||||
624 | 624 | George Tibbits T000262 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 10 | |||||||||||||
628 | 628 | John Trigg T000370 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 13 | |||||||||||||
630 | 630 | Isaac Van Horne V000045 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
635 | 635 | Abraham Venable V000083 | sen | VA | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
640 | 640 | Lemuel Williams W000526 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 8 | |||||||||||||
650 | 650 | Nathaniel Alexander A000100 | rep | NC | 1803-03-04 | 1805-03-03 | Republican | 10 | |||||||||||||
651 | 651 | Isaac Anderson A000191 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
654 | 654 | John Archer A000272 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
661 | 661 | Abraham Baldwin B000084 | sen | GA | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
663 | 663 | George Bedinger B000301 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
665 | 665 | Silas Betton B000425 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
669 | 669 | Phanuel Bishop B000488 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
671 | 671 | Joseph Bryan B000989 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
673 | 673 | Levi Casey C000226 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
675 | 675 | Christopher Clark C000424 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 13 | |||||||||||||
677 | 677 | Frederick Conrad C000704 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
681 | 681 | William Dickson D000333 | rep | TN | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
685 | 685 | Peter Early E000014 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
689 | 689 | Ebenezer Elmer E000154 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
695 | 695 | John Fowler F000322 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
698 | 698 | Calvin Goddard G000248 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
704 | 704 | Roger Griswold G000488 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
711 | 711 | John Hanna H000161 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
714 | 714 | Seth Hastings H000331 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 10 | |||||||||||||
716 | 716 | David Hough H000811 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
723 | 723 | Henry Livingston L000367 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 8 | |||||||||||||
726 | 726 | John Lucas L000492 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 11 | |||||||||||||
732 | 732 | David Meriwether M000649 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
736 | 736 | Joseph Nicholson N000100 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 7 | |||||||||||||
738 | 738 | Gideon Olin O000067 | rep | VT | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
740 | 740 | Thomas Randolph R000051 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 21 | |||||||||||||
743 | 743 | Thomas Sandford S000041 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
750 | 750 | John Smith S000570 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
756 | 756 | Joseph Stanton S000805 | rep | RI | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
763 | 763 | Thomas Sumter S001073 | sen | SC | 1801-12-15 | 1805-03-03 | 2 | Republican | |||||||||||||
767 | 767 | Samuel Tenney T000127 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
770 | 770 | Philip Thompson T000213 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
778 | 778 | Peleg Wadsworth W000014 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 15 | |||||||||||||
780 | 780 | Matthew Walton W000116 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
782 | 782 | John Whitehill W000403 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
787 | 787 | Joseph Winston W000642 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
790 | 790 | Thomas Wynns W000786 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
806 | 806 | John Boyle B000729 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
819 | 819 | Joseph Clay C000486 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
822 | 822 | George Clinton C000526 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
825 | 825 | Jacob Crowninshield C000947 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
832 | 832 | James Elliott E000122 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
836 | 836 | Jesse Franklin F000344 | sen | NC | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
851 | 851 | Andrew Gregg G000442 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
857 | 857 | William Hoge H000699 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 10 | |||||||||||||
865 | 865 | Nehemiah Knight K000286 | rep | RI | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
871 | 871 | William McCreery M000387 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
882 | 882 | Jacob Richards R000212 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
885 | 885 | Samuel Riker R000257 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
889 | 889 | James Sloan S000493 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
900 | 900 | David Thomas T000163 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
907 | 907 | Abram Trigg T000368 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
916 | 916 | Philip Van Cortlandt V000022 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
919 | 919 | Daniel Verplanck V000088 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
923 | 923 | Marmaduke Williams W000529 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
926 | 926 | Alexander Wilson W000568 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
954 | 954 | John Campbell C000091 | rep | MD | 1803-10-17 | 1805-03-03 | Federalist | 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);