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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
650 | 650 | Nathaniel Alexander A000100 | rep | NC | 1803-03-04 | 1805-03-03 | Republican | 10 | |||||||||||||
3025 | 3025 | Willis Alston A000167 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
557 | 557 | Theodorus Bailey B000049 | sen | NY | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
661 | 661 | Abraham Baldwin B000084 | sen | GA | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
558 | 558 | Simeon Baldwin B000097 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1460 | 1460 | David Bard B000137 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
1104 | 1104 | James Bayard B000249 | sen | DE | 1804-11-13 | 1805-03-03 | 2 | Federalist | |||||||||||||
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 | |||||||||||||
1107 | 1107 | William Blackledge B000511 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
560 | 560 | Walter Bowie B000697 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
1118 | 1118 | Adam Boyd B000714 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
806 | 806 | John Boyle B000729 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
330 | 330 | John Brown B000929 | sen | KY | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
1298 | 1298 | Robert Brown B000942 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
561 | 561 | Phineas Bruce B000970 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 17 | |||||||||||||
671 | 671 | Joseph Bryan B000989 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
550 | 550 | Pierce Butler B001186 | sen | SC | 1802-01-01 | 1805-03-03 | 3 | Republican | |||||||||||||
1123 | 1123 | William Butler B001194 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
1484 | 1484 | George Campbell C000083 | rep | TN | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
954 | 954 | John Campbell C000091 | rep | MD | 1803-10-17 | 1805-03-03 | Federalist | 1 | |||||||||||||
673 | 673 | Levi Casey C000226 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
959 | 959 | William Chamberlain C000280 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
1129 | 1129 | Martin Chittenden C000372 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 4 | |||||||||||||
1992 | 1992 | Clifton Clagett C000399 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
566 | 566 | Thomas Claiborne C000406 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 17 | |||||||||||||
675 | 675 | Christopher Clark C000424 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 13 | |||||||||||||
819 | 819 | Joseph Clay C000486 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
1505 | 1505 | Matthew Clay C000487 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 14 | |||||||||||||
822 | 822 | George Clinton C000526 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
1516 | 1516 | John Clopton C000531 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 22 | |||||||||||||
335 | 335 | William Cocke C000572 | sen | TN | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
677 | 677 | Frederick Conrad C000704 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
825 | 825 | Jacob Crowninshield C000947 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
568 | 568 | Manasseh Cutler C001026 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
1143 | 1143 | Richard Cutts C001033 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 14 | |||||||||||||
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 | |||||||||||||
1321 | 1321 | John Dawson D000151 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 10 | |||||||||||||
347 | 347 | Jonathan Dayton D000165 | sen | NJ | 1799-12-02 | 1805-03-03 | 2 | Federalist | |||||||||||||
572 | 572 | John Dennis D000243 | rep | MD | 1803-10-17 | 1805-03-03 | Federalist | 8 | |||||||||||||
681 | 681 | William Dickson D000333 | rep | TN | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
685 | 685 | Peter Early E000014 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
468 | 468 | Christopher Ellery E000114 | sen | RI | 1801-12-07 | 1805-03-03 | 2 | Republican | |||||||||||||
832 | 832 | James Elliott E000122 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
689 | 689 | Ebenezer Elmer E000154 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
1830 | 1830 | John Eppes E000197 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 16 | |||||||||||||
2234 | 2234 | William Eustis E000230 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
1557 | 1557 | William Findley F000124 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
695 | 695 | John Fowler F000322 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
836 | 836 | Jesse Franklin F000344 | sen | NC | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
1161 | 1161 | William Giles G000183 | sen | VA | 1804-12-04 | 1805-03-03 | 2 | Republican | |||||||||||||
578 | 578 | James Gillespie G000196 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
698 | 698 | Calvin Goddard G000248 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1845 | 1845 | Peterson Goodwyn G000306 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 18 | |||||||||||||
1172 | 1172 | Edwin Gray G000394 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 19 | |||||||||||||
851 | 851 | Andrew Gregg G000442 | rep | PA | 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 | |||||||||||||
704 | 704 | Roger Griswold G000488 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
711 | 711 | John Hanna H000161 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
1854 | 1854 | Josiah Hasbrouck H000314 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 7 | |||||||||||||
714 | 714 | Seth Hastings H000331 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 10 | |||||||||||||
978 | 978 | William Helms H000464 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
589 | 589 | Daniel Hiester H000570 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
2040 | 2040 | Joseph Hiester H000574 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
590 | 590 | John Hoge H000695 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 10 | |||||||||||||
857 | 857 | William Hoge H000699 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 10 | |||||||||||||
992 | 992 | James Holland H000718 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 11 | |||||||||||||
2177 | 2177 | David Holmes H000735 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
716 | 716 | David Hough H000811 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1609 | 1609 | Benjamin Huger H000915 | rep | SC | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
592 | 592 | Samuel Hunt H000976 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1620 | 1620 | John Jackson J000021 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
1002 | 1002 | Walter Jones J000254 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
1366 | 1366 | William Kennedy K000116 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
865 | 865 | Nehemiah Knight K000286 | rep | RI | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
593 | 593 | Simon Larned L000097 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
1636 | 1636 | William Lattimore L000118 | rep | MS | 1803-10-17 | 1805-03-03 | -1 | ||||||||||||||
1015 | 1015 | Michael Leib L000229 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
1643 | 1643 | Joseph Lewis L000290 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 7 | |||||||||||||
594 | 594 | Thomas Lewis L000294 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 5 | |||||||||||||
723 | 723 | Henry Livingston L000367 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 8 | |||||||||||||
596 | 596 | Thomas Lowndes L000482 | rep | SC | 1803-10-17 | 1805-03-03 | Federalist | 1 | |||||||||||||
726 | 726 | John Lucas L000492 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 11 | |||||||||||||
1024 | 1024 | Matthew Lyon L000545 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
2670 | 2670 | Nathaniel Macon M000034 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
599 | 599 | Andrew McCord M000359 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
871 | 871 | William McCreery M000387 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
732 | 732 | David Meriwether M000649 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
600 | 600 | Nahum Mitchell M000824 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 7 | |||||||||||||
1668 | 1668 | Nicholas Moore M000909 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
1675 | 1675 | Thomas Moore M000919 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 7 |
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);