legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
241 rows where "start" is on date 1823-12-01 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2891 | 2891 | John McKee M000495 | rep | AL | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2925 | 2925 | George Owen O000150 | rep | AL | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
3492 | 3492 | Gabriel Moore M000898 | rep | AL | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
5874 | 5874 | William King K000217 | sen | AL | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
2820 | 2820 | Henry Conway C000712 | rep | AR | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2408 | 2408 | Henry Edwards E000070 | sen | CT | 1823-12-01 | 1827-03-03 | 1 | Jackson | |||||||||||||
2496 | 2496 | Ansel Sterling S000868 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2498 | 2498 | Ebenezer Stoddard S000943 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2530 | 2530 | Lemuel Whitman W000422 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3570 | 3570 | Gideon Tomlinson T000300 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3596 | 3596 | Noyes Barber B000125 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3675 | 3675 | Samuel Foot F000247 | rep | CT | 1823-12-01 | 1825-03-03 | Adams | -1 | |||||||||||||
2519 | 2519 | Nicholas Van Dyke V000037 | sen | DE | 1823-12-01 | 1827-03-03 | 2 | Adams | |||||||||||||
2897 | 2897 | Louis McLane M000535 | rep | DE | 1823-12-01 | 1825-03-03 | Jacksonian | 0 | |||||||||||||
2389 | 2389 | Richard Call C000050 | rep | FL | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2376 | 2376 | Joel Abbott A000003 | rep | GA | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
2524 | 2524 | Nicholas Ware W000148 | sen | GA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2570 | 2570 | George Cary C000212 | rep | GA | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2974 | 2974 | Edward Tattnall T000051 | rep | GA | 1823-12-01 | 1825-03-03 | Crawford Republican | -1 | |||||||||||||
3387 | 3387 | John Forsyth F000284 | rep | GA | 1823-12-01 | 1825-03-03 | Democratic Republican | -1 | |||||||||||||
3563 | 3563 | Wiley Thompson T000222 | rep | GA | 1823-12-01 | 1825-03-03 | Jacksonian | -1 | |||||||||||||
3820 | 3820 | Richard Wilde W000460 | rep | GA | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
4186 | 4186 | Alfred Cuthbert C001023 | rep | GA | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
2501 | 2501 | Jesse Thomas T000171 | sen | IL | 1823-12-01 | 1829-03-03 | 2 | Adams | |||||||||||||
2581 | 2581 | Daniel Cook C000716 | rep | IL | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2388 | 2388 | Jacob Call C000049 | rep | IN | 1823-12-01 | 1825-03-03 | Jackson Republican | 1 | |||||||||||||
2464 | 2464 | William Prince P000540 | rep | IN | 1823-12-01 | 1825-03-03 | Republican | 1 | |||||||||||||
3151 | 3151 | Jonathan Jennings J000097 | rep | IN | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3244 | 3244 | John Test T000138 | rep | IN | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2433 | 2433 | John Johnson J000154 | rep | KY | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2502 | 2502 | Philip Thompson T000211 | rep | KY | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2529 | 2529 | David White W000363 | rep | KY | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2628 | 2628 | Robert Henry H000517 | rep | KY | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2643 | 2643 | Francis Johnson J000129 | rep | KY | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2732 | 2732 | David Trimble T000372 | rep | KY | 1823-12-01 | 1825-03-03 | Republican | 1 | |||||||||||||
2808 | 2808 | Richard Buckner B001033 | rep | KY | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
2911 | 2911 | Thomas Moore M000921 | rep | KY | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
3723 | 3723 | Robert Letcher L000257 | rep | KY | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
3962 | 3962 | Richard Johnson J000170 | sen | KY | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
5882 | 5882 | Thomas Metcalfe M000676 | rep | KY | 1823-12-01 | 1825-03-03 | Whig | 2 | |||||||||||||
5935 | 5935 | Henry Clay C000482 | rep | KY | 1823-12-01 | 1825-03-03 | Democratic Republican | 3 | |||||||||||||
7882 | 7882 | Charles Wickliffe W000442 | rep | KY | 1823-12-01 | 1825-03-03 | Jacksonian | 9 | |||||||||||||
2799 | 2799 | William Brent B000803 | rep | LA | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
3110 | 3110 | Henry Gurley G000529 | rep | LA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3165 | 3165 | Edward Livingston L000366 | rep | LA | 1823-12-01 | 1825-03-03 | Jacksonian | 1 | |||||||||||||
5343 | 5343 | Henry Johnson J000137 | sen | LA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2364 | 2364 | James Lloyd L000378 | sen | MA | 1823-12-01 | 1826-05-23 | 2 | Adams | |||||||||||||
2418 | 2418 | Timothy Fuller F000413 | rep | MA | 1823-12-01 | 1825-03-03 | Republican | 4 | |||||||||||||
2486 | 2486 | Jonas Sibley S000397 | rep | MA | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2560 | 2560 | Francis Baylies B000255 | rep | MA | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2636 | 2636 | Aaron Hobart H000659 | rep | MA | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2653 | 2653 | Samuel Lathrop L000112 | rep | MA | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
2767 | 2767 | Samuel Allen A000146 | rep | MA | 1823-12-01 | 1825-03-03 | Federalist | 7 | |||||||||||||
2878 | 2878 | John Locke L000388 | rep | MA | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
3035 | 3035 | John Bailey B000041 | rep | MA | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
3072 | 3072 | Benjamin Crowninshield C000946 | rep | MA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3092 | 3092 | Henry Dwight D000579 | rep | MA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
3501 | 3501 | Jeremiah Nelson N000036 | rep | MA | 1823-12-01 | 1825-03-03 | Federalist | 3 | |||||||||||||
4587 | 4587 | John Reed R000121 | rep | MA | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
5566 | 5566 | Daniel Webster W000238 | rep | MA | 1823-12-01 | 1825-03-03 | Adams | 1 | |||||||||||||
2423 | 2423 | William Hayward H000410 | rep | MD | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2435 | 2435 | John Lee L000196 | rep | MD | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2453 | 2453 | Raphael Neale N000018 | rep | MD | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2527 | 2527 | Henry Warfield W000150 | rep | MD | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2875 | 2875 | Peter Little L000354 | rep | MD | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
3483 | 3483 | George Mitchell M000810 | rep | MD | 1823-12-01 | 1825-03-03 | Jacksonian | 6 | |||||||||||||
3714 | 3714 | Joseph Kent K000125 | rep | MD | 1823-12-01 | 1825-03-03 | Republican | 2 | |||||||||||||
4117 | 4117 | John Spence S000719 | rep | MD | 1823-12-01 | 1825-03-03 | Anti-Jacksonian | 8 | |||||||||||||
4278 | 4278 | Isaac McKim M000516 | rep | MD | 1823-12-01 | 1825-03-03 | Jacksonian | 5 | |||||||||||||
2393 | 2393 | John Chandler C000291 | sen | ME | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
2398 | 2398 | Joshua Cushman C001020 | rep | ME | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2443 | 2443 | Stephen Longfellow L000430 | rep | ME | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2631 | 2631 | Ebenezer Herrick H000538 | rep | ME | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2647 | 2647 | David Kidder K000163 | rep | ME | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2658 | 2658 | Enoch Lincoln L000314 | rep | ME | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
2812 | 2812 | William Burleigh B001109 | rep | ME | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2918 | 2918 | Jeremiah O’Brien O000013 | rep | ME | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2472 | 2472 | Gabriel Richard R000210 | rep | MI | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2718 | 2718 | John Scott S000176 | rep | MO | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2538 | 2538 | Thomas Williams W000540 | sen | MS | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
2707 | 2707 | Christopher Rankin R000054 | rep | MS | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2386 | 2386 | Hutchins Burton B001152 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2419 | 2419 | Alfred Gatlin G000099 | rep | NC | 1823-12-01 | 1825-03-03 | Crawford Republican | 1 | |||||||||||||
2430 | 2430 | Charles Hooks H000761 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
2455 | 2455 | George Outlaw O000139 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2490 | 2490 | Richard Spaight S000694 | rep | NC | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2522 | 2522 | Robert Vance V000018 | rep | NC | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2594 | 2594 | Weldon Edwards E000083 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 6 | |||||||||||||
2827 | 2827 | John Culpepper C000976 | rep | NC | 1823-12-01 | 1825-03-03 | Federalist | 7 | |||||||||||||
2882 | 2882 | John Long L000421 | rep | NC | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
3319 | 3319 | John Branch B000763 | sen | NC | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
3694 | 3694 | Thomas Hall H000072 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 3 | |||||||||||||
4426 | 4426 | Henry Connor C000700 | rep | NC | 1823-12-01 | 1825-03-03 | Democrat | 11 | |||||||||||||
5074 | 5074 | Lewis Williams W000527 | rep | NC | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
5283 | 5283 | Romulus Saunders S000078 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 9 | |||||||||||||
5768 | 5768 | Willie Mangum M000096 | rep | NC | 1823-12-01 | 1825-03-03 | Jacksonian | 8 | |||||||||||||
2422 | 2422 | Matthew Harvey H000309 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2442 | 2442 | Arthur Livermore L000362 | rep | NH | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
2447 | 2447 | Aaron Matson M000247 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2463 | 2463 | William Plumer P000394 | rep | NH | 1823-12-01 | 1825-03-03 | -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);