legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
130 rows where "end" is on date 1801-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4649 | 4649 | William Harrison H000279 | rep | OH | 1799-12-02 | 1801-03-03 | -1 | ||||||||||||||
3773 | 3773 | John Randolph R000047 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
3241 | 3241 | Littleton Tazewell T000108 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 13 | |||||||||||||
3164 | 3164 | Edward Livingston L000366 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
3023 | 3023 | Willis Alston A000167 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 9 | |||||||||||||
2960 | 2960 | Samuel Smith S000609 | rep | MD | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
2668 | 2668 | Nathaniel Macon M000034 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
2290 | 2290 | Anthony New N000058 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 16 | |||||||||||||
2175 | 2175 | David Holmes H000735 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
2101 | 2101 | Charles Pinckney P000354 | sen | SC | 1799-12-02 | 1801-03-03 | 2 | Republican | |||||||||||||
2038 | 2038 | Joseph Hiester H000574 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
1996 | 1996 | John Condit C000671 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
1889 | 1889 | Harrison Otis O000127 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 8 | |||||||||||||
1811 | 1811 | William Claiborne C000408 | rep | TN | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
1786 | 1786 | Robert Harper H000225 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 5 | |||||||||||||
1713 | 1713 | Richard Stanford S000794 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
1607 | 1607 | Benjamin Huger H000915 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
1541 | 1541 | John Davenport D000075 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
1533 | 1533 | Samuel Dana D000024 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
1503 | 1503 | Matthew Clay C000487 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 6 | |||||||||||||
1455 | 1455 | George Baer B000026 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 4 | |||||||||||||
1416 | 1416 | David Stone S000955 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 8 | |||||||||||||
1319 | 1319 | John Dawson D000151 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 15 | |||||||||||||
1296 | 1296 | Robert Brown B000942 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
1248 | 1248 | Joseph Varnum V000074 | rep | MA | 1799-12-02 | 1801-03-03 | Democratic Republican | 9 | |||||||||||||
1226 | 1226 | John Smilie S000508 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 11 | |||||||||||||
1170 | 1170 | Edwin Gray G000394 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 10 | |||||||||||||
1102 | 1102 | James Bayard B000249 | rep | DE | 1799-12-02 | 1801-03-03 | Federalist | 0 | |||||||||||||
1073 | 1073 | John Thompson T000206 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
1023 | 1023 | Matthew Lyon L000545 | rep | VT | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
1013 | 1013 | Michael Leib L000229 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
962 | 962 | Christopher Champlin C000289 | rep | RI | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
914 | 914 | Philip Van Cortlandt V000022 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
905 | 905 | Abram Trigg T000368 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
893 | 893 | John Smith S000566 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
849 | 849 | Andrew Gregg G000442 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 9 | |||||||||||||
843 | 843 | Chauncey Goodrich G000293 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
776 | 776 | Peleg Wadsworth W000014 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 13 | |||||||||||||
765 | 765 | Samuel Tenney T000127 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
761 | 761 | Thomas Sumter S001073 | rep | SC | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
748 | 748 | John Smith S000570 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
734 | 734 | Joseph Nicholson N000100 | rep | MD | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
721 | 721 | Aaron Kitchell K000246 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
709 | 709 | John Hanna H000161 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 6 | |||||||||||||
702 | 702 | Roger Griswold G000488 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
693 | 693 | John Fowler F000322 | rep | KY | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
667 | 667 | Phanuel Bishop B000488 | rep | MA | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
641 | 641 | John Armstrong A000282 | sen | NY | 1800-11-06 | 1801-03-03 | 3 | Republican | |||||||||||||
638 | 638 | Lemuel Williams W000526 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 5 | |||||||||||||
626 | 626 | John Trigg T000370 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
619 | 619 | John Stewart S000912 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 8 | |||||||||||||
570 | 570 | John Dennis D000243 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 8 | |||||||||||||
555 | 555 | Theodorus Bailey B000049 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
546 | 546 | Henry Woods W000722 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
544 | 544 | Robert Williams W000534 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
538 | 538 | Uriah Tracy T000348 | sen | CT | 1796-10-13 | 1801-03-03 | 3 | Federalist | |||||||||||||
532 | 532 | Benjamin Taliaferro T000025 | rep | GA | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
525 | 525 | William Shepard S000330 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
522 | 522 | James Sheafe S000312 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
520 | 520 | John Rutledge R000553 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
517 | 517 | Nathan Read R000093 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
511 | 511 | John Muhlenberg M001066 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
506 | 506 | Lewis Morris M000983 | rep | VT | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
503 | 503 | Ebenezer Mattoon M000259 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
500 | 500 | Levi Lincoln L000316 | rep | MA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
498 | 498 | Silas Lee L000204 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 12 | |||||||||||||
491 | 491 | George Jackson J000012 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
487 | 487 | William Hill H000611 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
485 | 485 | Archibald Henderson H000475 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
483 | 483 | William Grove G000502 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 7 | |||||||||||||
476 | 476 | Abiel Foster F000297 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
470 | 470 | Lucas Elmendorf E000153 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
466 | 466 | Thomas Davis D000138 | rep | KY | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
462 | 462 | Samuel Cabell C000005 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 14 | |||||||||||||
456 | 456 | John Bird B000477 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
453 | 453 | William Hindman H000629 | sen | MD | 1800-01-01 | 1801-03-03 | 3 | Federalist | |||||||||||||
444 | 444 | Robert Waln W000094 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
442 | 442 | Richard Thomas T000183 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
439 | 439 | John Thomas T000173 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
438 | 438 | George Thatcher T000141 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 14 | |||||||||||||
432 | 432 | Richard Spaight S000693 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 10 | |||||||||||||
430 | 430 | Samuel Sewall S000259 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
427 | 427 | Theodore Sedgwick S000222 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
422 | 422 | John Reed R000120 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
419 | 419 | Leven Powell P000482 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 17 | |||||||||||||
418 | 418 | Jonas Platt P000381 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 9 | |||||||||||||
417 | 417 | Thomas Pinckney P000357 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
415 | 415 | Josiah Parker P000065 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 11 | |||||||||||||
409 | 409 | Robert Page P000021 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
408 | 408 | Abraham Nott N000161 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
407 | 407 | John Nicholas N000084 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 18 | |||||||||||||
403 | 403 | William McMillan M000571 | rep | OH | 1799-12-02 | 1801-03-03 | -1 | ||||||||||||||
402 | 402 | John Marshall M000157 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 13 | |||||||||||||
401 | 401 | Samuel Lyman L000528 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
394 | 394 | James Linn L000336 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
393 | 393 | Henry Lee L000195 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 19 | |||||||||||||
392 | 392 | John Kittera K000253 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 7 | |||||||||||||
387 | 387 | James Jones J000227 | rep | GA | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
386 | 386 | James Imlay I000011 | rep | NJ | 1799-12-02 | 1801-03-03 | Federalist | 4 | |||||||||||||
384 | 384 | Jonathan Havens H000359 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 2 |
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);