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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2376 | 2376 | Joel Abbott A000003 | rep | GA | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
2545 | 2545 | Parmenio Adams A000042 | rep | NY | 1823-12-01 | 1825-03-03 | 29 | ||||||||||||||
2547 | 2547 | Adam Alexander A000089 | rep | TN | 1823-12-01 | 1825-03-03 | Jacksonian Republican | 9 | |||||||||||||
3288 | 3288 | Mark Alexander A000099 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 4 | |||||||||||||
2551 | 2551 | Robert Allen A000142 | rep | TN | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2767 | 2767 | Samuel Allen A000146 | rep | MA | 1823-12-01 | 1825-03-03 | Federalist | 7 | |||||||||||||
2553 | 2553 | James Allison A000157 | rep | PA | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
4669 | 4669 | William Archer A000275 | rep | VA | 1823-12-01 | 1825-03-03 | Whig | 3 | |||||||||||||
3035 | 3035 | John Bailey B000041 | rep | MA | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2380 | 2380 | William Ball B000103 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 13 | |||||||||||||
3596 | 3596 | Noyes Barber B000125 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3309 | 3309 | John Barbour B000128 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 15 | |||||||||||||
3044 | 3044 | Philip Barbour B000131 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 11 | |||||||||||||
2778 | 2778 | Ichabod Bartlett B000205 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3047 | 3047 | Mordecai Bartley B000210 | rep | OH | 1823-12-01 | 1825-03-03 | 14 | ||||||||||||||
2557 | 2557 | David Barton B000212 | sen | MO | 1821-12-03 | 1825-03-03 | 3 | Republican | |||||||||||||
2788 | 2788 | Burwell Bassett B000224 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 8 | |||||||||||||
2560 | 2560 | Francis Baylies B000255 | rep | MA | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2794 | 2794 | Philemon Beecher B000306 | rep | OH | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
3619 | 3619 | John Blair B000528 | rep | TN | 1823-12-01 | 1825-03-03 | Jacksonian | 1 | |||||||||||||
2563 | 2563 | William Bradley B000748 | rep | VT | 1823-12-01 | 1825-03-03 | Republican | 2 | |||||||||||||
2381 | 2381 | Samuel Breck B000783 | rep | PA | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2799 | 2799 | William Brent B000803 | rep | LA | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2359 | 2359 | Ethan Brown B000914 | sen | OH | 1822-01-01 | 1825-03-03 | 3 | Republican | |||||||||||||
2383 | 2383 | John Brown B000926 | rep | PA | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
6964 | 6964 | James Buchanan B001005 | rep | PA | 1823-12-01 | 1825-03-03 | Democratic Republican | 4 | |||||||||||||
2806 | 2806 | Daniel Buck B001015 | rep | VT | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2808 | 2808 | Richard Buckner B001033 | rep | KY | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
2812 | 2812 | William Burleigh B001109 | rep | ME | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2386 | 2386 | Hutchins Burton B001152 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2387 | 2387 | John Cady C000015 | rep | NY | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2388 | 2388 | Jacob Call C000049 | rep | IN | 1823-12-01 | 1825-03-03 | Jackson Republican | 1 | |||||||||||||
2389 | 2389 | Richard Call C000050 | rep | FL | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
4153 | 4153 | Churchill Cambreleng C000061 | rep | NY | 1823-12-01 | 1825-03-03 | Democrat | 3 | |||||||||||||
2568 | 2568 | John Campbell C000095 | rep | OH | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
3861 | 3861 | Robert Campbell C000098 | rep | SC | 1823-12-01 | 1825-03-03 | Jackson Republican | 3 | |||||||||||||
2816 | 2816 | John Carter C000197 | rep | SC | 1823-12-01 | 1825-03-03 | Jacksonian | 8 | |||||||||||||
2570 | 2570 | George Cary C000212 | rep | GA | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2573 | 2573 | George Cassedy C000234 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2394 | 2394 | Lot Clark C000447 | rep | NY | 1823-12-01 | 1825-03-03 | 21 | ||||||||||||||
5935 | 5935 | Henry Clay C000482 | rep | KY | 1823-12-01 | 1825-03-03 | Democratic Republican | 3 | |||||||||||||
2578 | 2578 | John Cocke C000571 | rep | TN | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2395 | 2395 | Ela Collins C000635 | rep | NY | 1823-12-01 | 1825-03-03 | 20 | ||||||||||||||
3342 | 3342 | Lewis Condict C000668 | rep | NJ | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
4426 | 4426 | Henry Connor C000700 | rep | NC | 1823-12-01 | 1825-03-03 | Democrat | 11 | |||||||||||||
2820 | 2820 | Henry Conway C000712 | rep | AR | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2581 | 2581 | Daniel Cook C000716 | rep | IL | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
5098 | 5098 | Samuel Crafts C000851 | rep | VT | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
3069 | 3069 | Hector Craig C000856 | rep | NY | 1823-12-01 | 1825-03-03 | Jacksonian | 6 | |||||||||||||
3072 | 3072 | Benjamin Crowninshield C000946 | rep | MA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2827 | 2827 | John Culpepper C000976 | rep | NC | 1823-12-01 | 1825-03-03 | Federalist | 7 | |||||||||||||
2398 | 2398 | Joshua Cushman C001020 | rep | ME | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
4186 | 4186 | Alfred Cuthbert C001023 | rep | GA | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
3659 | 3659 | Rowland Day D000159 | rep | NY | 1823-12-01 | 1825-03-03 | Jacksonian | 24 | |||||||||||||
2400 | 2400 | Job Durfee D000568 | rep | RI | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3092 | 3092 | Henry Dwight D000579 | rep | MA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2401 | 2401 | Justin Dwinell D000584 | rep | NY | 1823-12-01 | 1825-03-03 | 22 | ||||||||||||||
2831 | 2831 | John Eaton E000024 | sen | TN | 1821-12-03 | 1825-03-03 | 1 | ||||||||||||||
2402 | 2402 | Lewis Eaton E000025 | rep | NY | 1823-12-01 | 1825-03-03 | Crawford Republican | 12 | |||||||||||||
2405 | 2405 | Samuel Eddy E000040 | rep | RI | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2588 | 2588 | Samuel Edwards E000080 | rep | PA | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2594 | 2594 | Weldon Edwards E000083 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 6 | |||||||||||||
2018 | 2018 | John Elliott E000124 | sen | GA | 1819-12-06 | 1825-03-03 | 3 | Republican | |||||||||||||
2410 | 2410 | William Ellis E000137 | rep | PA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2598 | 2598 | Patrick Farrelly F000032 | rep | PA | 1823-12-01 | 1825-03-03 | 18 | ||||||||||||||
2601 | 2601 | John Findlay F000120 | rep | PA | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2840 | 2840 | John Floyd F000221 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 20 | |||||||||||||
3675 | 3675 | Samuel Foot F000247 | rep | CT | 1823-12-01 | 1825-03-03 | Adams | -1 | |||||||||||||
2411 | 2411 | Charles Foote F000249 | rep | NY | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
3387 | 3387 | John Forsyth F000284 | rep | GA | 1823-12-01 | 1825-03-03 | Democratic Republican | -1 | |||||||||||||
2413 | 2413 | Walter Forward F000291 | rep | PA | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2414 | 2414 | Joel Frost F000391 | rep | NY | 1823-12-01 | 1825-03-03 | Crawford Republican | 4 | |||||||||||||
2418 | 2418 | Timothy Fuller F000413 | rep | MA | 1823-12-01 | 1825-03-03 | Republican | 4 | |||||||||||||
2607 | 2607 | John Gaillard G000005 | sen | SC | 1819-12-06 | 1825-03-03 | 3 | Republican | |||||||||||||
2612 | 2612 | Robert Garnett G000077 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 12 | |||||||||||||
2614 | 2614 | Daniel Garrison G000083 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2419 | 2419 | Alfred Gatlin G000099 | rep | NC | 1823-12-01 | 1825-03-03 | Crawford Republican | 1 | |||||||||||||
2420 | 2420 | James Gazlay G000109 | rep | OH | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2617 | 2617 | Joseph Gist G000227 | rep | SC | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2620 | 2620 | Andrew Govan G000346 | rep | SC | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
3110 | 3110 | Henry Gurley G000529 | rep | LA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3694 | 3694 | Thomas Hall H000072 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 3 | |||||||||||||
2853 | 2853 | James Hamilton H000110 | rep | SC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2622 | 2622 | Robert Harris H000250 | rep | PA | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2422 | 2422 | Matthew Harvey H000309 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2625 | 2625 | Moses Hayden H000387 | rep | NY | 1823-12-01 | 1825-03-03 | 27 | ||||||||||||||
2423 | 2423 | William Hayward H000410 | rep | MD | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
3124 | 3124 | Joseph Hemphill H000470 | rep | PA | 1823-12-01 | 1825-03-03 | Federalist | 2 | |||||||||||||
2628 | 2628 | Robert Henry H000517 | rep | KY | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2425 | 2425 | John Herkimer H000529 | rep | NY | 1823-12-01 | 1825-03-03 | Republican | 15 | |||||||||||||
2631 | 2631 | Ebenezer Herrick H000538 | rep | ME | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2636 | 2636 | Aaron Hobart H000659 | rep | MA | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2426 | 2426 | James Hogeboom H000700 | rep | NY | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2860 | 2860 | George Holcombe H000711 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2430 | 2430 | Charles Hooks H000761 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
6615 | 6615 | Samuel Houston H000827 | rep | TN | 1823-12-01 | 1825-03-03 | Democrat | 7 | |||||||||||||
3141 | 3141 | Samuel Ingham I000022 | rep | PA | 1823-12-01 | 1825-03-03 | Jackson Republican | 8 | |||||||||||||
3430 | 3430 | Jacob Isacks I000045 | rep | TN | 1823-12-01 | 1825-03-03 | Jackson Republican | 4 | |||||||||||||
2431 | 2431 | Lemuel Jenkins J000085 | rep | NY | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
3151 | 3151 | Jonathan Jennings J000097 | rep | IN | 1823-12-01 | 1825-03-03 | 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);