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
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
455 | 455 | John Bacon B000017 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
457 | 457 | John Bird B000477 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
458 | 458 | Thomas Boude B000660 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 7 | |||||||||||||
459 | 459 | John Breckinridge B000787 | sen | KY | 1801-12-07 | 1805-12-31 | 3 | Republican | |||||||||||||
463 | 463 | Samuel Cabell C000005 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 14 | |||||||||||||
464 | 464 | John Colhoun C000627 | sen | SC | 1801-12-07 | 1803-03-03 | 3 | Republican | |||||||||||||
467 | 467 | Thomas Davis D000138 | rep | KY | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
468 | 468 | Christopher Ellery E000114 | sen | RI | 1801-12-07 | 1805-03-03 | 2 | Republican | |||||||||||||
471 | 471 | Lucas Elmendorf E000153 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
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 | ||||||||||||||
484 | 484 | William Grove G000502 | rep | NC | 1801-12-07 | 1803-03-03 | Federalist | 7 | |||||||||||||
486 | 486 | Archibald Henderson H000475 | rep | NC | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
488 | 488 | William Hill H000611 | rep | NC | 1801-12-07 | 1803-03-03 | Federalist | 6 | |||||||||||||
489 | 489 | Narsworthy Hunter H000986 | rep | MS | 1801-12-07 | 1803-03-03 | -1 | ||||||||||||||
492 | 492 | George Jackson J000012 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 3 | |||||||||||||
495 | 495 | James Jackson J000017 | sen | GA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
496 | 496 | Charles Johnson J000123 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 8 | |||||||||||||
497 | 497 | William Jones J000258 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
499 | 499 | Silas Lee L000204 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 12 | |||||||||||||
501 | 501 | Levi Lincoln L000316 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
502 | 502 | George Logan L000401 | sen | PA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
504 | 504 | Ebenezer Mattoon M000259 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
507 | 507 | Lewis Morris M000983 | rep | VT | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
508 | 508 | Thomas Morris M000988 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | 10 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
518 | 518 | Nathan Read R000093 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 10 | |||||||||||||
521 | 521 | John Rutledge R000553 | rep | SC | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
523 | 523 | James Sheafe S000312 | sen | NH | 1801-12-07 | 1803-03-03 | 3 | Federalist | |||||||||||||
526 | 526 | William Shepard S000330 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
527 | 527 | Josiah Smith S000582 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
530 | 530 | Richard, Sprigg S000752 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
531 | 531 | John Stratton S000994 | rep | VA | 1801-12-07 | 1803-03-03 | Federalist | 12 | |||||||||||||
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 | |||||||||||||
539 | 539 | Uriah Tracy T000348 | sen | CT | 1801-12-07 | 1807-03-03 | 3 | Federalist | |||||||||||||
540 | 540 | George Upham U000022 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
541 | 541 | John Van Ness V000049 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
542 | 542 | Benjamin Walker W000046 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | 9 | |||||||||||||
545 | 545 | Robert Williams W000534 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 3 | |||||||||||||
547 | 547 | Henry Woods W000722 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 10 | |||||||||||||
556 | 556 | Theodorus Bailey B000049 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
559 | 559 | Walter Bowie B000697 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
565 | 565 | Thomas Claiborne C000406 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 8 | |||||||||||||
567 | 567 | Manasseh Cutler C001026 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 11 | |||||||||||||
571 | 571 | John Dennis D000243 | rep | MD | 1801-12-07 | 1803-03-03 | Federalist | 8 | |||||||||||||
588 | 588 | Daniel Hiester H000570 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
591 | 591 | Samuel Hunt H000976 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
595 | 595 | Thomas Lowndes L000482 | rep | SC | 1801-12-07 | 1803-03-03 | Federalist | 1 | |||||||||||||
601 | 601 | James Mott M001039 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
606 | 606 | Thomas Plater P000378 | rep | MD | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
616 | 616 | Israel Smith S000557 | rep | VT | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
620 | 620 | John Stewart S000912 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 8 | |||||||||||||
622 | 622 | Samuel Thatcher T000143 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 12 | |||||||||||||
627 | 627 | John Trigg T000370 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
629 | 629 | Isaac Van Horne V000045 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
636 | 636 | Samuel White W000392 | sen | DE | 1801-12-07 | 1803-03-03 | 1 | Federalist | |||||||||||||
639 | 639 | Lemuel Williams W000526 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 5 | |||||||||||||
653 | 653 | John Archer A000272 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
668 | 668 | Phanuel Bishop B000488 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 7 | |||||||||||||
680 | 680 | William Dickson D000333 | rep | TN | 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 | |||||||||||||
694 | 694 | John Fowler F000322 | rep | KY | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
710 | 710 | John Hanna H000161 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
713 | 713 | Seth Hastings H000331 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 4 | |||||||||||||
731 | 731 | David Meriwether M000649 | rep | GA | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
735 | 735 | Joseph Nicholson N000100 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
762 | 762 | Thomas Sumter S001073 | rep | SC | 1801-12-07 | 1801-12-15 | Republican | 4 | |||||||||||||
766 | 766 | Samuel Tenney T000127 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
769 | 769 | Philip Thompson T000213 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 18 | |||||||||||||
777 | 777 | Peleg Wadsworth W000014 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 13 | |||||||||||||
789 | 789 | Thomas Wynns W000786 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 8 | |||||||||||||
795 | 795 | John Milledge M000712 | rep | GA | 1801-12-07 | 1803-03-03 | Republican | 0 | |||||||||||||
810 | 810 | Stephen Bradley B000745 | sen | VT | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
850 | 850 | Andrew Gregg G000442 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 9 | |||||||||||||
856 | 856 | William Hoge H000699 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 12 | |||||||||||||
894 | 894 | John Smith S000566 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
899 | 899 | David Thomas T000163 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 7 | |||||||||||||
906 | 906 | Abram Trigg T000368 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
915 | 915 | Philip Van Cortlandt V000022 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 3 | |||||||||||||
947 | 947 | Richard Brent B000802 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 17 | |||||||||||||
953 | 953 | John Campbell C000091 | rep | MD | 1801-12-07 | 1803-03-03 | Federalist | 1 | |||||||||||||
977 | 977 | William Helms H000464 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
991 | 991 | James Holland H000718 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
1014 | 1014 | Michael Leib L000229 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
1066 | 1066 | John Stanly S000800 | rep | NC | 1801-12-07 | 1803-03-03 | Federalist | 10 | |||||||||||||
1080 | 1080 | Killian Van Rensselaer V000054 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | 8 | |||||||||||||
1103 | 1103 | James Bayard B000249 | rep | DE | 1801-12-07 | 1803-03-03 | Federalist | 0 | |||||||||||||
1122 | 1122 | William Butler B001194 | rep | SC | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
1142 | 1142 | Richard Cutts C001033 | rep | MA | 1801-12-07 | 1803-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);