legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
47 rows where party = "Federalist" and "start" is on date 1801-12-07
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
499 | 499 | Silas Lee L000204 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 12 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
531 | 531 | John Stratton S000994 | rep | VA | 1801-12-07 | 1803-03-03 | Federalist | 12 | |||||||||||||
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 | |||||||||||||
542 | 542 | Benjamin Walker W000046 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | 9 | |||||||||||||
547 | 547 | Henry Woods W000722 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 10 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
606 | 606 | Thomas Plater P000378 | rep | MD | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
622 | 622 | Samuel Thatcher T000143 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 12 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
713 | 713 | Seth Hastings H000331 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 4 | |||||||||||||
749 | 749 | John Smith S000570 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
766 | 766 | Samuel Tenney T000127 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
777 | 777 | Peleg Wadsworth W000014 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 13 | |||||||||||||
953 | 953 | John Campbell C000091 | rep | MD | 1801-12-07 | 1803-03-03 | Federalist | 1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1608 | 1608 | Benjamin Huger H000915 | rep | SC | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
1738 | 1738 | Benjamin Tallmadge T000029 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
3121 | 3121 | Joseph Hemphill H000470 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 3 |
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);