legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
224 rows where "start" is on date 1821-12-03
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2452 | 2452 | Raphael Neale N000018 | rep | MD | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2459 | 2459 | Thomas Patterson P000128 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 12 | |||||||||||||
2462 | 2462 | William Plumer P000394 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2470 | 2470 | Charles Rich R000207 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2474 | 2474 | William Rochester R000360 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 20 | |||||||||||||
2478 | 2478 | Thomas Rogers R000403 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2481 | 2481 | Thomas Ross R000456 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2484 | 2484 | Peter Sharpe S000297 | rep | NY | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2488 | 2488 | Arthur Smith S000515 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 20 | |||||||||||||
2493 | 2493 | James Stephenson S000864 | rep | VA | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2495 | 2495 | Ansel Sterling S000868 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2497 | 2497 | Ebenezer Stoddard S000943 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2503 | 2503 | John Tod T000290 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2506 | 2506 | Albert Tracy T000343 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 22 | |||||||||||||
2509 | 2509 | George Tucker T000397 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 15 | |||||||||||||
2514 | 2514 | Daniel Udree U000003 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2520 | 2520 | William Van Wyck V000068 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2523 | 2523 | Nicholas Ware W000148 | sen | GA | 1821-12-03 | 1823-03-03 | 2 | Republican | |||||||||||||
2526 | 2526 | Henry Warfield W000150 | rep | MD | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
2535 | 2535 | Jared Williams W000510 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2550 | 2550 | Robert Allen A000142 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2557 | 2557 | David Barton B000212 | sen | MO | 1821-12-03 | 1825-03-03 | 3 | Republican | |||||||||||||
2559 | 2559 | Francis Baylies B000255 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 10 | |||||||||||||
2567 | 2567 | John Campbell C000095 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2572 | 2572 | George Cassedy C000234 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2577 | 2577 | John Cocke C000571 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2580 | 2580 | Daniel Cook C000716 | rep | IL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2587 | 2587 | Samuel Edwards E000080 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2593 | 2593 | Weldon Edwards E000083 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2597 | 2597 | Patrick Farrelly F000032 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 15 | |||||||||||||
2600 | 2600 | John Findlay F000120 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2611 | 2611 | Robert Garnett G000077 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 12 | |||||||||||||
2616 | 2616 | Joseph Gist G000227 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2619 | 2619 | Andrew Govan G000346 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2630 | 2630 | Ebenezer Herrick H000538 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2635 | 2635 | Aaron Hobart H000659 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2642 | 2642 | Francis Johnson J000129 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2652 | 2652 | Samuel Lathrop L000112 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 5 | |||||||||||||
2657 | 2657 | Enoch Lincoln L000314 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2685 | 2685 | Archibald McNeill M000586 | rep | NC | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2691 | 2691 | James Mitchell M000816 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2697 | 2697 | George Plumer P000392 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
2700 | 2700 | Joel Poinsett P000404 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2706 | 2706 | Christopher Rankin R000054 | rep | MS | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2717 | 2717 | John Scott S000176 | rep | MO | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2721 | 2721 | William Smith S000626 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2731 | 2731 | David Trimble T000372 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2739 | 2739 | John Wilson W000597 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2747 | 2747 | Ephraim Bateman B000228 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2755 | 2755 | Daniel Rodney R000378 | rep | DE | 1821-12-03 | 1823-03-03 | Federalist | 0 | |||||||||||||
2766 | 2766 | Samuel Allen A000146 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 6 | |||||||||||||
2787 | 2787 | Burwell Bassett B000224 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
2815 | 2815 | John Carter C000197 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2831 | 2831 | John Eaton E000024 | sen | TN | 1821-12-03 | 1825-03-03 | 1 | ||||||||||||||
2839 | 2839 | John Floyd F000221 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2852 | 2852 | James Hamilton H000110 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2859 | 2859 | George Holcombe H000711 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2874 | 2874 | Peter Little L000354 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2881 | 2881 | John Long L000421 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 10 | |||||||||||||
2896 | 2896 | Louis McLane M000535 | rep | DE | 1821-12-03 | 1823-03-03 | Federalist | 0 | |||||||||||||
2916 | 2916 | James Noble N000118 | sen | IN | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2939 | 2939 | Benjamin Ruggles R000500 | sen | OH | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2946 | 2946 | Lemuel Sawyer S000089 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2949 | 2949 | Horatio Seymour S000268 | sen | VT | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2953 | 2953 | John Sloane S000494 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2973 | 2973 | Edward Tattnall T000051 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2983 | 2983 | Stephen Van Rensselaer V000056 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
2991 | 2991 | Thomas Whipple W000345 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3003 | 3003 | Silas Wood W000703 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3007 | 3007 | David Woodcock W000712 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 20 | |||||||||||||
3011 | 3011 | John Wright W000764 | rep | OH | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
3043 | 3043 | Philip Barbour B000131 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
3083 | 3083 | John Dickinson D000322 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 10 | |||||||||||||
3091 | 3091 | Henry Dwight D000579 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
3123 | 3123 | Joseph Hemphill H000470 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
3140 | 3140 | Samuel Ingham I000022 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
3150 | 3150 | Jonathan Jennings J000097 | rep | IN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3212 | 3212 | Alexander Smyth S000646 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
3236 | 3236 | Samuel Swan S001088 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3259 | 3259 | Starling Tucker T000402 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
3287 | 3287 | Mark Alexander A000099 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 18 | |||||||||||||
3341 | 3341 | Lewis Condict C000668 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3402 | 3402 | William Hendricks H000494 | rep | IN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3437 | 3437 | Josiah Johnston J000194 | rep | LA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3458 | 3458 | Rollin Mallary M000079 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3474 | 3474 | William McCoy M000377 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
3487 | 3487 | Thomas Mitchell M000829 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
3491 | 3491 | Gabriel Moore M000898 | rep | AL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3500 | 3500 | Jeremiah Nelson N000036 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
3514 | 3514 | Thomas Newton N000078 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 21 | |||||||||||||
3525 | 3525 | Nathaniel Pitcher P000367 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 12 | |||||||||||||
3556 | 3556 | John Taylor T000091 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
3562 | 3562 | Wiley Thompson T000222 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3569 | 3569 | Gideon Tomlinson T000300 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3595 | 3595 | Noyes Barber B000125 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3615 | 3615 | James Blair B000526 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
3680 | 3680 | George Gilmer G000216 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3687 | 3687 | Benjamin Gorham G000324 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3693 | 3693 | Thomas Hall H000072 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
3713 | 3713 | Joseph Kent K000125 | rep | MD | 1821-12-03 | 1823-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);