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 party
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1636 | 1636 | William Lattimore L000118 | rep | MS | 1803-10-17 | 1805-03-03 | -1 | ||||||||||||||
1250 | 1250 | Joseph Varnum V000074 | rep | MA | 1803-10-17 | 1805-03-03 | Democratic Republican | 4 | |||||||||||||
347 | 347 | Jonathan Dayton D000165 | sen | NJ | 1799-12-02 | 1805-03-03 | 2 | Federalist | |||||||||||||
514 | 514 | Simeon Olcott O000060 | sen | NH | 1801-12-07 | 1805-03-03 | 2 | Federalist | |||||||||||||
558 | 558 | Simeon Baldwin B000097 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
561 | 561 | Phineas Bruce B000970 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 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 | |||||||||||||
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 | |||||||||||||
592 | 592 | Samuel Hunt H000976 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
600 | 600 | Nahum Mitchell M000824 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 7 | |||||||||||||
607 | 607 | Thomas Plater P000378 | rep | MD | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
609 | 609 | Samuel Purviance P000577 | rep | NC | 1803-10-17 | 1805-03-03 | Federalist | 7 | |||||||||||||
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 | |||||||||||||
640 | 640 | Lemuel Williams W000526 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 8 | |||||||||||||
665 | 665 | Silas Betton B000425 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
750 | 750 | John Smith S000570 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
767 | 767 | Samuel Tenney T000127 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
778 | 778 | Peleg Wadsworth W000014 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 15 | |||||||||||||
832 | 832 | James Elliott E000122 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
954 | 954 | John Campbell C000091 | rep | MD | 1803-10-17 | 1805-03-03 | Federalist | 1 | |||||||||||||
959 | 959 | William Chamberlain C000280 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
1068 | 1068 | William Stedman S000828 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 11 | |||||||||||||
1081 | 1081 | Killian Van Rensselaer V000054 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 9 | |||||||||||||
1104 | 1104 | James Bayard B000249 | sen | DE | 1804-11-13 | 1805-03-03 | 2 | Federalist | |||||||||||||
1129 | 1129 | Martin Chittenden C000372 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 4 | |||||||||||||
1423 | 1423 | William Wells W000287 | sen | DE | 1799-12-02 | 1805-03-03 | 2 | Federalist | |||||||||||||
1535 | 1535 | Samuel Dana D000024 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1543 | 1543 | John Davenport D000075 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1609 | 1609 | Benjamin Huger H000915 | rep | SC | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
1643 | 1643 | Joseph Lewis L000290 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 7 | |||||||||||||
1687 | 1687 | Timothy Pickering P000324 | sen | MA | 1803-10-17 | 1805-03-03 | 2 | Federalist | |||||||||||||
1731 | 1731 | Samuel Taggart T000012 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 6 | |||||||||||||
1739 | 1739 | Benjamin Tallmadge T000029 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1992 | 1992 | Clifton Clagett C000399 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
2491 | 2491 | James Stephenson S000864 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
2712 | 2712 | Joshua Sands S000046 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
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 | |||||||||||||
468 | 468 | Christopher Ellery E000114 | sen | RI | 1801-12-07 | 1805-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
560 | 560 | Walter Bowie B000697 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
566 | 566 | Thomas Claiborne C000406 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 17 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
593 | 593 | Simon Larned L000097 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
599 | 599 | Andrew McCord M000359 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
608 | 608 | Samuel Potter P000468 | sen | RI | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
711 | 711 | John Hanna H000161 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
770 | 770 | Philip Thompson T000213 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
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 |
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);