legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
243 rows where "end" is on date 1825-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7882 | 7882 | Charles Wickliffe W000442 | rep | KY | 1823-12-01 | 1825-03-03 | Jacksonian | 9 | |||||||||||||
6964 | 6964 | James Buchanan B001005 | rep | PA | 1823-12-01 | 1825-03-03 | Democratic Republican | 4 | |||||||||||||
6615 | 6615 | Samuel Houston H000827 | rep | TN | 1823-12-01 | 1825-03-03 | Democrat | 7 | |||||||||||||
6155 | 6155 | Samuel Vinton V000107 | rep | OH | 1823-12-01 | 1825-03-03 | Whig | 7 | |||||||||||||
5935 | 5935 | Henry Clay C000482 | rep | KY | 1823-12-01 | 1825-03-03 | Democratic Republican | 3 | |||||||||||||
5882 | 5882 | Thomas Metcalfe M000676 | rep | KY | 1823-12-01 | 1825-03-03 | Whig | 2 | |||||||||||||
5829 | 5829 | Andrew Stewart S000899 | rep | PA | 1823-12-01 | 1825-03-03 | Anti Mason | 14 | |||||||||||||
5774 | 5774 | Dudley Marvin M000208 | rep | NY | 1823-12-01 | 1825-03-03 | Whig | 26 | |||||||||||||
5768 | 5768 | Willie Mangum M000096 | rep | NC | 1823-12-01 | 1825-03-03 | Jacksonian | 8 | |||||||||||||
5566 | 5566 | Daniel Webster W000238 | rep | MA | 1823-12-01 | 1825-03-03 | Adams | 1 | |||||||||||||
5556 | 5556 | Joseph Vance V000017 | rep | OH | 1823-12-01 | 1825-03-03 | Anti Jacksonian | 4 | |||||||||||||
5455 | 5455 | Joseph Johnson J000155 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 18 | |||||||||||||
5343 | 5343 | Henry Johnson J000137 | sen | LA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
5283 | 5283 | Romulus Saunders S000078 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 9 | |||||||||||||
5101 | 5101 | George McDuffie M000426 | rep | SC | 1823-12-01 | 1825-03-03 | Democrat | 5 | |||||||||||||
5098 | 5098 | Samuel Crafts C000851 | rep | VT | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
5074 | 5074 | Lewis Williams W000527 | rep | NC | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
5022 | 5022 | John Taliaferro T000027 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 13 | |||||||||||||
4969 | 4969 | William Rives R000285 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 10 | |||||||||||||
4669 | 4669 | William Archer A000275 | rep | VA | 1823-12-01 | 1825-03-03 | Whig | 3 | |||||||||||||
4587 | 4587 | John Reed R000121 | rep | MA | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
4549 | 4549 | Charles Mercer M000642 | rep | VA | 1823-12-01 | 1825-03-03 | Whig | 14 | |||||||||||||
4426 | 4426 | Henry Connor C000700 | rep | NC | 1823-12-01 | 1825-03-03 | Democrat | 11 | |||||||||||||
4375 | 4375 | Elisha Whittlesey W000431 | rep | OH | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
4356 | 4356 | James Standifer S000789 | rep | TN | 1823-12-01 | 1825-03-03 | Jacksonian | 3 | |||||||||||||
4278 | 4278 | Isaac McKim M000516 | rep | MD | 1823-12-01 | 1825-03-03 | Jacksonian | 5 | |||||||||||||
4186 | 4186 | Alfred Cuthbert C001023 | rep | GA | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
4153 | 4153 | Churchill Cambreleng C000061 | rep | NY | 1823-12-01 | 1825-03-03 | Democrat | 3 | |||||||||||||
4117 | 4117 | John Spence S000719 | rep | MD | 1823-12-01 | 1825-03-03 | Anti-Jacksonian | 8 | |||||||||||||
3861 | 3861 | Robert Campbell C000098 | rep | SC | 1823-12-01 | 1825-03-03 | Jackson Republican | 3 | |||||||||||||
3820 | 3820 | Richard Wilde W000460 | rep | GA | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
3797 | 3797 | Andrew Stevenson S000891 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 9 | |||||||||||||
3783 | 3783 | John Randolph R000047 | rep | VA | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
3760 | 3760 | John Morgan M000953 | rep | NY | 1823-12-01 | 1825-03-03 | Jacksonian | 3 | |||||||||||||
3750 | 3750 | Samuel McKean M000492 | rep | PA | 1823-12-01 | 1825-03-03 | Jacksonian | 9 | |||||||||||||
3741 | 3741 | Henry Martindale M000204 | rep | NY | 1823-12-01 | 1825-03-03 | Anti Mason | 18 | |||||||||||||
3723 | 3723 | Robert Letcher L000257 | rep | KY | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
3714 | 3714 | Joseph Kent K000125 | rep | MD | 1823-12-01 | 1825-03-03 | Republican | 2 | |||||||||||||
3694 | 3694 | Thomas Hall H000072 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 3 | |||||||||||||
3675 | 3675 | Samuel Foot F000247 | rep | CT | 1823-12-01 | 1825-03-03 | Adams | -1 | |||||||||||||
3659 | 3659 | Rowland Day D000159 | rep | NY | 1823-12-01 | 1825-03-03 | Jacksonian | 24 | |||||||||||||
3619 | 3619 | John Blair B000528 | rep | TN | 1823-12-01 | 1825-03-03 | Jacksonian | 1 | |||||||||||||
3596 | 3596 | Noyes Barber B000125 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3570 | 3570 | Gideon Tomlinson T000300 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3563 | 3563 | Wiley Thompson T000222 | rep | GA | 1823-12-01 | 1825-03-03 | Jacksonian | -1 | |||||||||||||
3557 | 3557 | John Taylor T000091 | rep | NY | 1823-12-01 | 1825-03-03 | Republican | 17 | |||||||||||||
3515 | 3515 | Thomas Newton N000078 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 1 | |||||||||||||
3501 | 3501 | Jeremiah Nelson N000036 | rep | MA | 1823-12-01 | 1825-03-03 | Federalist | 3 | |||||||||||||
3492 | 3492 | Gabriel Moore M000898 | rep | AL | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
3483 | 3483 | George Mitchell M000810 | rep | MD | 1823-12-01 | 1825-03-03 | Jacksonian | 6 | |||||||||||||
3475 | 3475 | William McCoy M000377 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 19 | |||||||||||||
3459 | 3459 | Rollin Mallary M000079 | rep | VT | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
3438 | 3438 | Josiah Johnston J000194 | sen | LA | 1824-01-15 | 1825-03-03 | 3 | Adams | |||||||||||||
3430 | 3430 | Jacob Isacks I000045 | rep | TN | 1823-12-01 | 1825-03-03 | Jackson Republican | 4 | |||||||||||||
3387 | 3387 | John Forsyth F000284 | rep | GA | 1823-12-01 | 1825-03-03 | Democratic Republican | -1 | |||||||||||||
3342 | 3342 | Lewis Condict C000668 | rep | NJ | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
3309 | 3309 | John Barbour B000128 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 15 | |||||||||||||
3288 | 3288 | Mark Alexander A000099 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 4 | |||||||||||||
3271 | 3271 | George Wolf W000673 | rep | PA | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
3260 | 3260 | Starling Tucker T000402 | rep | SC | 1823-12-01 | 1825-03-03 | Jacksonian | 9 | |||||||||||||
3244 | 3244 | John Test T000138 | rep | IN | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
3237 | 3237 | Samuel Swan S001088 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3232 | 3232 | James Strong S001010 | rep | NY | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
3227 | 3227 | Henry Storrs S000976 | rep | NY | 1823-12-01 | 1825-03-03 | Federalist | 14 | |||||||||||||
3213 | 3213 | Alexander Smyth S000646 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 22 | |||||||||||||
3198 | 3198 | Robert Rose R000439 | rep | NY | 1823-12-01 | 1825-03-03 | Anti Mason | 26 | |||||||||||||
3179 | 3179 | Daniel Miller M000722 | rep | PA | 1823-12-01 | 1825-03-03 | Jacksonian | 3 | |||||||||||||
3177 | 3177 | John McLean M000550 | sen | IL | 1824-01-01 | 1825-03-03 | 3 | Crawford Republican | |||||||||||||
3165 | 3165 | Edward Livingston L000366 | rep | LA | 1823-12-01 | 1825-03-03 | Jacksonian | 1 | |||||||||||||
3151 | 3151 | Jonathan Jennings J000097 | rep | IN | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3141 | 3141 | Samuel Ingham I000022 | rep | PA | 1823-12-01 | 1825-03-03 | Jackson Republican | 8 | |||||||||||||
3124 | 3124 | Joseph Hemphill H000470 | rep | PA | 1823-12-01 | 1825-03-03 | Federalist | 2 | |||||||||||||
3110 | 3110 | Henry Gurley G000529 | rep | LA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3092 | 3092 | Henry Dwight D000579 | rep | MA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
3072 | 3072 | Benjamin Crowninshield C000946 | rep | MA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3069 | 3069 | Hector Craig C000856 | rep | NY | 1823-12-01 | 1825-03-03 | Jacksonian | 6 | |||||||||||||
3047 | 3047 | Mordecai Bartley B000210 | rep | OH | 1823-12-01 | 1825-03-03 | 14 | ||||||||||||||
3044 | 3044 | Philip Barbour B000131 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 11 | |||||||||||||
3035 | 3035 | John Bailey B000041 | rep | MA | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
3012 | 3012 | John Wright W000764 | rep | OH | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
3004 | 3004 | Silas Wood W000703 | rep | NY | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2998 | 2998 | William Wilson W000619 | rep | OH | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
2995 | 2995 | James Wilson W000588 | rep | PA | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2992 | 2992 | Thomas Whipple W000345 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2984 | 2984 | Stephen Van Rensselaer V000056 | rep | NY | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2974 | 2974 | Edward Tattnall T000051 | rep | GA | 1823-12-01 | 1825-03-03 | Crawford Republican | -1 | |||||||||||||
2954 | 2954 | John Sloane S000494 | rep | OH | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2925 | 2925 | George Owen O000150 | rep | AL | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2918 | 2918 | Jeremiah O’Brien O000013 | rep | ME | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2911 | 2911 | Thomas Moore M000921 | rep | KY | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2900 | 2900 | William McLean M000552 | rep | OH | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2897 | 2897 | Louis McLane M000535 | rep | DE | 1823-12-01 | 1825-03-03 | Jacksonian | 0 | |||||||||||||
2891 | 2891 | John McKee M000495 | rep | AL | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2882 | 2882 | John Long L000421 | rep | NC | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2878 | 2878 | John Locke L000388 | rep | MA | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2875 | 2875 | Peter Little L000354 | rep | MD | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
2866 | 2866 | George Kremer K000329 | rep | PA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2860 | 2860 | George Holcombe H000711 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2853 | 2853 | James Hamilton H000110 | rep | SC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2840 | 2840 | John Floyd F000221 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 20 |
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);