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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3023 | 3023 | Willis Alston A000167 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 9 | |||||||||||||
641 | 641 | John Armstrong A000282 | sen | NY | 1800-11-06 | 1801-03-03 | 3 | Republican | |||||||||||||
1455 | 1455 | George Baer B000026 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 4 | |||||||||||||
555 | 555 | Theodorus Bailey B000049 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
322 | 322 | Bailey Bartlett B000198 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 11 | |||||||||||||
1102 | 1102 | James Bayard B000249 | rep | DE | 1799-12-02 | 1801-03-03 | Federalist | 0 | |||||||||||||
145 | 145 | William Bingham B000474 | sen | PA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
456 | 456 | John Bird B000477 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
667 | 667 | Phanuel Bishop B000488 | rep | MA | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
147 | 147 | Timothy Bloodworth B000563 | sen | NC | 1795-12-07 | 1801-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
1296 | 1296 | Robert Brown B000942 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
462 | 462 | Samuel Cabell C000005 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 14 | |||||||||||||
962 | 962 | Christopher Champlin C000289 | 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 | |||||||||||||
1811 | 1811 | William Claiborne C000408 | rep | TN | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
1503 | 1503 | Matthew Clay C000487 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 6 | |||||||||||||
1996 | 1996 | John Condit C000671 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
1533 | 1533 | Samuel Dana D000024 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
342 | 342 | Franklin Davenport D000069 | rep | NJ | 1799-12-02 | 1801-03-03 | Federalist | 5 | |||||||||||||
1541 | 1541 | John Davenport D000075 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
466 | 466 | Thomas Davis D000138 | rep | KY | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
1319 | 1319 | John Dawson D000151 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 15 | |||||||||||||
570 | 570 | John Dennis D000243 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 8 | |||||||||||||
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 | |||||||||||||
470 | 470 | Lucas Elmendorf E000153 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
360 | 360 | Thomas Evans E000257 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 12 | |||||||||||||
476 | 476 | Abiel Foster F000297 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
693 | 693 | John Fowler F000322 | rep | KY | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
843 | 843 | Chauncey Goodrich G000293 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
1170 | 1170 | Edwin Gray G000394 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 10 | |||||||||||||
849 | 849 | Andrew Gregg G000442 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 9 | |||||||||||||
702 | 702 | Roger Griswold G000488 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
483 | 483 | William Grove G000502 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 7 | |||||||||||||
168 | 168 | James Gunn G000526 | sen | GA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
709 | 709 | John Hanna H000161 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 6 | |||||||||||||
1786 | 1786 | Robert Harper H000225 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 5 | |||||||||||||
4649 | 4649 | William Harrison H000279 | rep | OH | 1799-12-02 | 1801-03-03 | -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 | |||||||||||||
485 | 485 | Archibald Henderson H000475 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
2038 | 2038 | Joseph Hiester H000574 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
487 | 487 | William Hill H000611 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
453 | 453 | William Hindman H000629 | sen | MD | 1800-01-01 | 1801-03-03 | 3 | Federalist | |||||||||||||
2175 | 2175 | David Holmes H000735 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
1607 | 1607 | Benjamin Huger H000915 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
386 | 386 | James Imlay I000011 | rep | NJ | 1799-12-02 | 1801-03-03 | Federalist | 4 | |||||||||||||
491 | 491 | George Jackson J000012 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
387 | 387 | James Jones J000227 | rep | GA | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
721 | 721 | Aaron Kitchell K000246 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
392 | 392 | John Kittera K000253 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 7 | |||||||||||||
179 | 179 | John Langdon L000067 | sen | NH | 1795-12-07 | 1801-03-03 | 3 | Republican | |||||||||||||
237 | 237 | John Laurance L000120 | sen | NY | 1796-01-01 | 1801-03-03 | 3 | Federalist | |||||||||||||
393 | 393 | Henry Lee L000195 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 19 | |||||||||||||
498 | 498 | Silas Lee L000204 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 12 | |||||||||||||
1013 | 1013 | Michael Leib L000229 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
500 | 500 | Levi Lincoln L000316 | rep | MA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
394 | 394 | James Linn L000336 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
3164 | 3164 | Edward Livingston L000366 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
273 | 273 | James Lloyd L000377 | sen | MD | 1797-05-15 | 1801-03-03 | 3 | Federalist | |||||||||||||
401 | 401 | Samuel Lyman L000528 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
1023 | 1023 | Matthew Lyon L000545 | rep | VT | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
2668 | 2668 | Nathaniel Macon M000034 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
185 | 185 | Humphrey Marshall M000155 | sen | KY | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
402 | 402 | John Marshall M000157 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 13 | |||||||||||||
503 | 503 | Ebenezer Mattoon M000259 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
403 | 403 | William McMillan M000571 | rep | OH | 1799-12-02 | 1801-03-03 | -1 | ||||||||||||||
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 | |||||||||||||
2290 | 2290 | Anthony New N000058 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 16 | |||||||||||||
407 | 407 | John Nicholas N000084 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 18 | |||||||||||||
734 | 734 | Joseph Nicholson N000100 | rep | MD | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
408 | 408 | Abraham Nott N000161 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
1889 | 1889 | Harrison Otis O000127 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 8 | |||||||||||||
409 | 409 | Robert Page P000021 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
200 | 200 | Elijah Paine P000026 | sen | VT | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
415 | 415 | Josiah Parker P000065 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 11 | |||||||||||||
2101 | 2101 | Charles Pinckney P000354 | sen | SC | 1799-12-02 | 1801-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
3773 | 3773 | John Randolph R000047 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
205 | 205 | Jacob Read R000092 | sen | SC | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
517 | 517 | Nathan Read R000093 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
422 | 422 | John Reed R000120 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
520 | 520 | John Rutledge R000553 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
427 | 427 | Theodore Sedgwick S000222 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 1 |
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);