legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
230 rows where "end" is on date 1823-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6963 | 6963 | James Buchanan B001005 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
5881 | 5881 | Thomas Metcalfe M000676 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
5873 | 5873 | William King K000217 | sen | AL | 1819-12-14 | 1823-03-03 | 2 | Republican | |||||||||||||
5828 | 5828 | Andrew Stewart S000899 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
5555 | 5555 | Joseph Vance V000017 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
5342 | 5342 | Henry Johnson J000137 | sen | LA | 1818-01-01 | 1823-03-03 | 2 | Republican | |||||||||||||
5282 | 5282 | Romulus Saunders S000078 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
5100 | 5100 | George McDuffie M000426 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
5097 | 5097 | Samuel Crafts C000851 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
5073 | 5073 | Lewis Williams W000527 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
4992 | 4992 | John Sergeant S000246 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
4879 | 4879 | John Mattocks M000258 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
4668 | 4668 | William Archer A000275 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 17 | |||||||||||||
4613 | 4613 | Samuel Southard S000689 | sen | NJ | 1821-03-06 | 1823-03-03 | 1 | Republican | |||||||||||||
4586 | 4586 | John Reed R000121 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
4548 | 4548 | Charles Mercer M000642 | rep | VA | 1821-12-03 | 1823-03-03 | Federalist | 8 | |||||||||||||
4425 | 4425 | Henry Connor C000700 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
4277 | 4277 | Isaac McKim M000516 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
4185 | 4185 | Alfred Cuthbert C001023 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
4152 | 4152 | Churchill Cambreleng C000061 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
3977 | 3977 | Nehemiah Knight K000287 | sen | RI | 1821-12-03 | 1823-03-03 | 2 | Republican | |||||||||||||
3961 | 3961 | Richard Johnson J000170 | sen | KY | 1819-12-06 | 1823-03-03 | 2 | Republican | |||||||||||||
3921 | 3921 | Benjamin Hardin H000184 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 10 | |||||||||||||
3796 | 3796 | Andrew Stevenson S000891 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 23 | |||||||||||||
3782 | 3782 | John Randolph R000047 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 16 | |||||||||||||
3759 | 3759 | John Morgan M000953 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
3713 | 3713 | Joseph Kent K000125 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
3693 | 3693 | Thomas Hall H000072 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
3687 | 3687 | Benjamin Gorham G000324 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3680 | 3680 | George Gilmer G000216 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3615 | 3615 | James Blair B000526 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
3595 | 3595 | Noyes Barber B000125 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3569 | 3569 | Gideon Tomlinson T000300 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3562 | 3562 | Wiley Thompson T000222 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3556 | 3556 | John Taylor T000091 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
3525 | 3525 | Nathaniel Pitcher P000367 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 12 | |||||||||||||
3514 | 3514 | Thomas Newton N000078 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 21 | |||||||||||||
3500 | 3500 | Jeremiah Nelson N000036 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
3491 | 3491 | Gabriel Moore M000898 | rep | AL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3487 | 3487 | Thomas Mitchell M000829 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
3474 | 3474 | William McCoy M000377 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
3458 | 3458 | Rollin Mallary M000079 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3437 | 3437 | Josiah Johnston J000194 | rep | LA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3402 | 3402 | William Hendricks H000494 | rep | IN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3341 | 3341 | Lewis Condict C000668 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3287 | 3287 | Mark Alexander A000099 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 18 | |||||||||||||
3259 | 3259 | Starling Tucker T000402 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
3236 | 3236 | Samuel Swan S001088 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3212 | 3212 | Alexander Smyth S000646 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
3150 | 3150 | Jonathan Jennings J000097 | rep | IN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3140 | 3140 | Samuel Ingham I000022 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
3123 | 3123 | Joseph Hemphill H000470 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
3091 | 3091 | Henry Dwight D000579 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
3083 | 3083 | John Dickinson D000322 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 10 | |||||||||||||
3079 | 3079 | Mahlon Dickerson D000308 | sen | NJ | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
3043 | 3043 | Philip Barbour B000131 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
3011 | 3011 | John Wright W000764 | rep | OH | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
3007 | 3007 | David Woodcock W000712 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 20 | |||||||||||||
3003 | 3003 | Silas Wood W000703 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2991 | 2991 | Thomas Whipple W000345 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2983 | 2983 | Stephen Van Rensselaer V000056 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
2973 | 2973 | Edward Tattnall T000051 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2953 | 2953 | John Sloane S000494 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2946 | 2946 | Lemuel Sawyer S000089 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2896 | 2896 | Louis McLane M000535 | rep | DE | 1821-12-03 | 1823-03-03 | Federalist | 0 | |||||||||||||
2881 | 2881 | John Long L000421 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 10 | |||||||||||||
2874 | 2874 | Peter Little L000354 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2859 | 2859 | George Holcombe H000711 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2852 | 2852 | James Hamilton H000110 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2839 | 2839 | John Floyd F000221 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2815 | 2815 | John Carter C000197 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2787 | 2787 | Burwell Bassett B000224 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
2766 | 2766 | Samuel Allen A000146 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 6 | |||||||||||||
2760 | 2760 | William Smith S000628 | sen | SC | 1817-03-04 | 1823-03-03 | 2 | Republican | |||||||||||||
2755 | 2755 | Daniel Rodney R000378 | rep | DE | 1821-12-03 | 1823-03-03 | Federalist | 0 | |||||||||||||
2747 | 2747 | Ephraim Bateman B000228 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2739 | 2739 | John Wilson W000597 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2731 | 2731 | David Trimble T000372 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2721 | 2721 | William Smith S000626 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2717 | 2717 | John Scott S000176 | rep | MO | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2706 | 2706 | Christopher Rankin R000054 | rep | MS | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2700 | 2700 | Joel Poinsett P000404 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2697 | 2697 | George Plumer P000392 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
2691 | 2691 | James Mitchell M000816 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2685 | 2685 | Archibald McNeill M000586 | rep | NC | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2657 | 2657 | Enoch Lincoln L000314 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2652 | 2652 | Samuel Lathrop L000112 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 5 | |||||||||||||
2642 | 2642 | Francis Johnson J000129 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2635 | 2635 | Aaron Hobart H000659 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2630 | 2630 | Ebenezer Herrick H000538 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2619 | 2619 | Andrew Govan G000346 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2616 | 2616 | Joseph Gist G000227 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2611 | 2611 | Robert Garnett G000077 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 12 | |||||||||||||
2600 | 2600 | John Findlay F000120 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2597 | 2597 | Patrick Farrelly F000032 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 15 | |||||||||||||
2593 | 2593 | Weldon Edwards E000083 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2587 | 2587 | Samuel Edwards E000080 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2580 | 2580 | Daniel Cook C000716 | rep | IL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2577 | 2577 | John Cocke C000571 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2572 | 2572 | George Cassedy C000234 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -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);