legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
132 rows where "start" is on date 1801-12-07 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
459 | 459 | John Breckinridge B000787 | sen | KY | 1801-12-07 | 1805-12-31 | 3 | Republican | |||||||||||||
464 | 464 | John Colhoun C000627 | sen | SC | 1801-12-07 | 1803-03-03 | 3 | Republican | |||||||||||||
468 | 468 | Christopher Ellery E000114 | sen | RI | 1801-12-07 | 1805-03-03 | 2 | Republican | |||||||||||||
495 | 495 | James Jackson J000017 | sen | GA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
502 | 502 | George Logan L000401 | sen | PA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
512 | 512 | John Muhlenberg M001066 | sen | PA | 1801-12-07 | 1801-12-31 | 3 | Democratic Republican | |||||||||||||
513 | 513 | Aaron Ogden O000041 | sen | NJ | 1801-12-07 | 1803-03-03 | 1 | Federalist | |||||||||||||
514 | 514 | Simeon Olcott O000060 | sen | NH | 1801-12-07 | 1805-03-03 | 2 | Federalist | |||||||||||||
523 | 523 | James Sheafe S000312 | sen | NH | 1801-12-07 | 1803-03-03 | 3 | Federalist | |||||||||||||
539 | 539 | Uriah Tracy T000348 | sen | CT | 1801-12-07 | 1807-03-03 | 3 | Federalist | |||||||||||||
636 | 636 | Samuel White W000392 | sen | DE | 1801-12-07 | 1803-03-03 | 1 | Federalist | |||||||||||||
810 | 810 | Stephen Bradley B000745 | sen | VT | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
1417 | 1417 | David Stone S000955 | sen | NC | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
2353 | 2353 | Robert Wright W000768 | sen | MD | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
457 | 457 | John Bird B000477 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
472 | 472 | Paul Fearing F000054 | rep | OH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
477 | 477 | Abiel Foster F000297 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
478 | 478 | Thomas Greene G000428 | rep | MS | 1801-12-07 | 1803-03-03 | -1 | ||||||||||||||
489 | 489 | Narsworthy Hunter H000986 | rep | MS | 1801-12-07 | 1803-03-03 | -1 | ||||||||||||||
515 | 515 | Joseph Peirce P000190 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
516 | 516 | Elias Perkins P000231 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
533 | 533 | Benjamin Taliaferro T000025 | rep | GA | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
535 | 535 | Thomas Tillinghast T000273 | rep | RI | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
540 | 540 | George Upham U000022 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
591 | 591 | Samuel Hunt H000976 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
601 | 601 | James Mott M001039 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
684 | 684 | Peter Early E000014 | rep | GA | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
688 | 688 | Ebenezer Elmer E000154 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
697 | 697 | Calvin Goddard G000248 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
703 | 703 | Roger Griswold G000488 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
731 | 731 | David Meriwether M000649 | rep | GA | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
749 | 749 | John Smith S000570 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
755 | 755 | Joseph Stanton S000805 | rep | RI | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
766 | 766 | Samuel Tenney T000127 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
977 | 977 | William Helms H000464 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
1534 | 1534 | Samuel Dana D000024 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
1542 | 1542 | John Davenport D000075 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
1738 | 1738 | Benjamin Tallmadge T000029 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
1997 | 1997 | John Condit C000671 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
2140 | 2140 | Henry Southard S000685 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
795 | 795 | John Milledge M000712 | rep | GA | 1801-12-07 | 1803-03-03 | Republican | 0 | |||||||||||||
1103 | 1103 | James Bayard B000249 | rep | DE | 1801-12-07 | 1803-03-03 | Federalist | 0 | |||||||||||||
455 | 455 | John Bacon B000017 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
467 | 467 | Thomas Davis D000138 | rep | KY | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
497 | 497 | William Jones J000258 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
595 | 595 | Thomas Lowndes L000482 | rep | SC | 1801-12-07 | 1803-03-03 | Federalist | 1 | |||||||||||||
616 | 616 | Israel Smith S000557 | rep | VT | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
680 | 680 | William Dickson D000333 | rep | TN | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
894 | 894 | John Smith S000566 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
953 | 953 | John Campbell C000091 | rep | MD | 1801-12-07 | 1803-03-03 | Federalist | 1 | |||||||||||||
991 | 991 | James Holland H000718 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
1406 | 1406 | John Smith S000564 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
486 | 486 | Archibald Henderson H000475 | rep | NC | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
507 | 507 | Lewis Morris M000983 | rep | VT | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
521 | 521 | John Rutledge R000553 | rep | SC | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
526 | 526 | William Shepard S000330 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
530 | 530 | Richard, Sprigg S000752 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
559 | 559 | Walter Bowie B000697 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
694 | 694 | John Fowler F000322 | rep | KY | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
1014 | 1014 | Michael Leib L000229 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
1194 | 1194 | Samuel Mitchill M000831 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
2176 | 2176 | David Holmes H000735 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
492 | 492 | George Jackson J000012 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 3 | |||||||||||||
504 | 504 | Ebenezer Mattoon M000259 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
545 | 545 | Robert Williams W000534 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 3 | |||||||||||||
606 | 606 | Thomas Plater P000378 | rep | MD | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
915 | 915 | Philip Van Cortlandt V000022 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 3 | |||||||||||||
1608 | 1608 | Benjamin Huger H000915 | rep | SC | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
3121 | 3121 | Joseph Hemphill H000470 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
471 | 471 | Lucas Elmendorf E000153 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
501 | 501 | Levi Lincoln L000316 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
588 | 588 | Daniel Hiester H000570 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
629 | 629 | Isaac Van Horne V000045 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
713 | 713 | Seth Hastings H000331 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 4 | |||||||||||||
762 | 762 | Thomas Sumter S001073 | rep | SC | 1801-12-07 | 1801-12-15 | Republican | 4 | |||||||||||||
906 | 906 | Abram Trigg T000368 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
1263 | 1263 | Richard Winn W000637 | rep | SC | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
1297 | 1297 | Robert Brown B000942 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
1714 | 1714 | Richard Stanford S000794 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
556 | 556 | Theodorus Bailey B000049 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
627 | 627 | John Trigg T000370 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
639 | 639 | Lemuel Williams W000526 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 5 | |||||||||||||
1122 | 1122 | William Butler B001194 | rep | SC | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
2039 | 2039 | Joseph Hiester H000574 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
2669 | 2669 | Nathaniel Macon M000034 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
2961 | 2961 | Samuel Smith S000609 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
488 | 488 | William Hill H000611 | rep | NC | 1801-12-07 | 1803-03-03 | Federalist | 6 | |||||||||||||
527 | 527 | Josiah Smith S000582 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
541 | 541 | John Van Ness V000049 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
653 | 653 | John Archer A000272 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
710 | 710 | John Hanna H000161 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
1504 | 1504 | Matthew Clay C000487 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
1674 | 1674 | Thomas Moore M000919 | rep | SC | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
458 | 458 | Thomas Boude B000660 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 7 | |||||||||||||
484 | 484 | William Grove G000502 | rep | NC | 1801-12-07 | 1803-03-03 | Federalist | 7 | |||||||||||||
668 | 668 | Phanuel Bishop B000488 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 7 | |||||||||||||
735 | 735 | Joseph Nicholson N000100 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 7 | |||||||||||||
899 | 899 | David Thomas T000163 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 7 | |||||||||||||
3774 | 3774 | John Randolph R000047 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 7 | |||||||||||||
496 | 496 | Charles Johnson J000123 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 8 |
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);