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
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145 | 145 | William Bingham B000474 | sen | PA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
147 | 147 | Timothy Bloodworth B000563 | sen | NC | 1795-12-07 | 1801-03-03 | 3 | Republican | |||||||||||||
168 | 168 | James Gunn G000526 | sen | GA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
179 | 179 | John Langdon L000067 | sen | NH | 1795-12-07 | 1801-03-03 | 3 | Republican | |||||||||||||
185 | 185 | Humphrey Marshall M000155 | sen | KY | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
200 | 200 | Elijah Paine P000026 | sen | VT | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
205 | 205 | Jacob Read R000092 | sen | SC | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
237 | 237 | John Laurance L000120 | sen | NY | 1796-01-01 | 1801-03-03 | 3 | Federalist | |||||||||||||
273 | 273 | James Lloyd L000377 | sen | MD | 1797-05-15 | 1801-03-03 | 3 | Federalist | |||||||||||||
320 | 320 | James Watson W000202 | sen | NY | 1798-01-01 | 1801-03-03 | 1 | Federalist | |||||||||||||
322 | 322 | Bailey Bartlett B000198 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 11 | |||||||||||||
324 | 324 | Jonathan Brace B000731 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
325 | 325 | John Brown B000927 | rep | RI | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
333 | 333 | Gabriel Christie C000382 | rep | MD | 1799-12-02 | 1801-03-03 | Republican | 6 | |||||||||||||
337 | 337 | William Cooper C000764 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
340 | 340 | William Craik C000863 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
342 | 342 | Franklin Davenport D000069 | rep | NJ | 1799-12-02 | 1801-03-03 | Federalist | 5 | |||||||||||||
351 | 351 | George Dent D000254 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
353 | 353 | Samuel Dexter D000296 | sen | MA | 1799-12-02 | 1801-03-03 | 2 | Federalist | |||||||||||||
354 | 354 | Joseph Dickson D000331 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
356 | 356 | William Edmond E000052 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
358 | 358 | Joseph Eggleston E000091 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 9 | |||||||||||||
360 | 360 | Thomas Evans E000257 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 12 | |||||||||||||
362 | 362 | Jonathan Freeman F000364 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
365 | 365 | Albert Gallatin G000020 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 12 | |||||||||||||
369 | 369 | Henry Glen G000235 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 8 | |||||||||||||
370 | 370 | Samuel Goode G000279 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 8 | |||||||||||||
371 | 371 | Elizur Goodrich G000294 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
373 | 373 | William Gordon G000318 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
381 | 381 | Thomas Hartley H000299 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 8 | |||||||||||||
384 | 384 | Jonathan Havens H000359 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
386 | 386 | James Imlay I000011 | rep | NJ | 1799-12-02 | 1801-03-03 | Federalist | 4 | |||||||||||||
387 | 387 | James Jones J000227 | rep | GA | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
392 | 392 | John Kittera K000253 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 7 | |||||||||||||
393 | 393 | Henry Lee L000195 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 19 | |||||||||||||
394 | 394 | James Linn L000336 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
401 | 401 | Samuel Lyman L000528 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
402 | 402 | John Marshall M000157 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 13 | |||||||||||||
403 | 403 | William McMillan M000571 | rep | OH | 1799-12-02 | 1801-03-03 | -1 | ||||||||||||||
407 | 407 | John Nicholas N000084 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 18 | |||||||||||||
408 | 408 | Abraham Nott N000161 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
409 | 409 | Robert Page P000021 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
415 | 415 | Josiah Parker P000065 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 11 | |||||||||||||
417 | 417 | Thomas Pinckney P000357 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
418 | 418 | Jonas Platt P000381 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 9 | |||||||||||||
419 | 419 | Leven Powell P000482 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 17 | |||||||||||||
422 | 422 | John Reed R000120 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
427 | 427 | Theodore Sedgwick S000222 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
430 | 430 | Samuel Sewall S000259 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
432 | 432 | Richard Spaight S000693 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 10 | |||||||||||||
438 | 438 | George Thatcher T000141 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 14 | |||||||||||||
439 | 439 | John Thomas T000173 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
442 | 442 | Richard Thomas T000183 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
444 | 444 | Robert Waln W000094 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
453 | 453 | William Hindman H000629 | sen | MD | 1800-01-01 | 1801-03-03 | 3 | Federalist | |||||||||||||
456 | 456 | John Bird B000477 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
462 | 462 | Samuel Cabell C000005 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 14 | |||||||||||||
466 | 466 | Thomas Davis D000138 | rep | KY | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
470 | 470 | Lucas Elmendorf E000153 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
476 | 476 | Abiel Foster F000297 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
483 | 483 | William Grove G000502 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 7 | |||||||||||||
485 | 485 | Archibald Henderson H000475 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
487 | 487 | William Hill H000611 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
491 | 491 | George Jackson J000012 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
498 | 498 | Silas Lee L000204 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 12 | |||||||||||||
500 | 500 | Levi Lincoln L000316 | rep | MA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
503 | 503 | Ebenezer Mattoon M000259 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
506 | 506 | Lewis Morris M000983 | rep | VT | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
511 | 511 | John Muhlenberg M001066 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
517 | 517 | Nathan Read R000093 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
520 | 520 | John Rutledge R000553 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
522 | 522 | James Sheafe S000312 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
525 | 525 | William Shepard S000330 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
532 | 532 | Benjamin Taliaferro T000025 | rep | GA | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
538 | 538 | Uriah Tracy T000348 | sen | CT | 1796-10-13 | 1801-03-03 | 3 | Federalist | |||||||||||||
544 | 544 | Robert Williams W000534 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
546 | 546 | Henry Woods W000722 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
555 | 555 | Theodorus Bailey B000049 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
570 | 570 | John Dennis D000243 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 8 | |||||||||||||
619 | 619 | John Stewart S000912 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 8 | |||||||||||||
626 | 626 | John Trigg T000370 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
638 | 638 | Lemuel Williams W000526 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 5 | |||||||||||||
641 | 641 | John Armstrong A000282 | sen | NY | 1800-11-06 | 1801-03-03 | 3 | Republican | |||||||||||||
667 | 667 | Phanuel Bishop B000488 | rep | MA | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
693 | 693 | John Fowler F000322 | rep | KY | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
702 | 702 | Roger Griswold G000488 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
709 | 709 | John Hanna H000161 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 6 | |||||||||||||
721 | 721 | Aaron Kitchell K000246 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
734 | 734 | Joseph Nicholson N000100 | rep | MD | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
748 | 748 | John Smith S000570 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
761 | 761 | Thomas Sumter S001073 | rep | SC | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
765 | 765 | Samuel Tenney T000127 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
776 | 776 | Peleg Wadsworth W000014 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 13 | |||||||||||||
843 | 843 | Chauncey Goodrich G000293 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
849 | 849 | Andrew Gregg G000442 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 9 | |||||||||||||
893 | 893 | John Smith S000566 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
905 | 905 | Abram Trigg T000368 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
914 | 914 | Philip Van Cortlandt V000022 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
962 | 962 | Christopher Champlin C000289 | rep | RI | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
1013 | 1013 | Michael Leib L000229 | rep | PA | 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);