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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2594 | 2594 | Weldon Edwards E000083 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 6 | |||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
2622 | 2622 | Robert Harris H000250 | rep | PA | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2625 | 2625 | Moses Hayden H000387 | rep | NY | 1823-12-01 | 1825-03-03 | 27 | ||||||||||||||
2628 | 2628 | Robert Henry H000517 | rep | KY | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
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 | ||||||||||||||
2643 | 2643 | Francis Johnson J000129 | rep | KY | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2647 | 2647 | David Kidder K000163 | rep | ME | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2653 | 2653 | Samuel Lathrop L000112 | rep | MA | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
2658 | 2658 | Enoch Lincoln L000314 | rep | ME | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
2662 | 2662 | Edward Lloyd L000376 | sen | MD | 1819-12-06 | 1825-03-03 | 3 | Republican | |||||||||||||
2678 | 2678 | Nathaniel Macon M000034 | sen | NC | 1819-12-06 | 1825-03-03 | 3 | Republican | |||||||||||||
2680 | 2680 | Philip Markley M000135 | rep | PA | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2692 | 2692 | James Mitchell M000816 | rep | PA | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2698 | 2698 | George Plumer P000392 | rep | PA | 1823-12-01 | 1825-03-03 | 17 | ||||||||||||||
2701 | 2701 | Joel Poinsett P000404 | rep | SC | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2707 | 2707 | Christopher Rankin R000054 | rep | MS | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2718 | 2718 | John Scott S000176 | rep | MO | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2722 | 2722 | William Smith S000626 | rep | VA | 1823-12-01 | 1825-03-03 | 21 | ||||||||||||||
2725 | 2725 | Egbert Ten Eyck T000125 | rep | NY | 1823-12-01 | 1825-03-03 | 20 | ||||||||||||||
2727 | 2727 | Alexander Thomson T000227 | rep | PA | 1823-12-01 | 1825-03-03 | 13 | ||||||||||||||
2732 | 2732 | David Trimble T000372 | rep | KY | 1823-12-01 | 1825-03-03 | Republican | 1 | |||||||||||||
2737 | 2737 | Henry Wilson W000584 | rep | PA | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2740 | 2740 | John Wilson W000597 | rep | SC | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2767 | 2767 | Samuel Allen A000146 | rep | MA | 1823-12-01 | 1825-03-03 | Federalist | 7 | |||||||||||||
2778 | 2778 | Ichabod Bartlett B000205 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2788 | 2788 | Burwell Bassett B000224 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 8 | |||||||||||||
2794 | 2794 | Philemon Beecher B000306 | rep | OH | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2799 | 2799 | William Brent B000803 | rep | LA | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
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 | ||||||||||||||
2816 | 2816 | John Carter C000197 | rep | SC | 1823-12-01 | 1825-03-03 | Jacksonian | 8 | |||||||||||||
2820 | 2820 | Henry Conway C000712 | rep | AR | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2827 | 2827 | John Culpepper C000976 | rep | NC | 1823-12-01 | 1825-03-03 | Federalist | 7 | |||||||||||||
2831 | 2831 | John Eaton E000024 | sen | TN | 1821-12-03 | 1825-03-03 | 1 | ||||||||||||||
2840 | 2840 | John Floyd F000221 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 20 | |||||||||||||
2853 | 2853 | James Hamilton H000110 | rep | SC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2860 | 2860 | George Holcombe H000711 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2866 | 2866 | George Kremer K000329 | rep | PA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2875 | 2875 | Peter Little L000354 | rep | MD | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
2878 | 2878 | John Locke L000388 | rep | MA | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2882 | 2882 | John Long L000421 | rep | NC | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2891 | 2891 | John McKee M000495 | rep | AL | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2897 | 2897 | Louis McLane M000535 | rep | DE | 1823-12-01 | 1825-03-03 | Jacksonian | 0 | |||||||||||||
2900 | 2900 | William McLean M000552 | rep | OH | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2911 | 2911 | Thomas Moore M000921 | rep | KY | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2918 | 2918 | Jeremiah O’Brien O000013 | rep | ME | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2925 | 2925 | George Owen O000150 | rep | AL | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2954 | 2954 | John Sloane S000494 | rep | OH | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2974 | 2974 | Edward Tattnall T000051 | rep | GA | 1823-12-01 | 1825-03-03 | Crawford Republican | -1 | |||||||||||||
2984 | 2984 | Stephen Van Rensselaer V000056 | rep | NY | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2992 | 2992 | Thomas Whipple W000345 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2995 | 2995 | James Wilson W000588 | rep | PA | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2998 | 2998 | William Wilson W000619 | rep | OH | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
3004 | 3004 | Silas Wood W000703 | rep | NY | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
3012 | 3012 | John Wright W000764 | rep | OH | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
3035 | 3035 | John Bailey B000041 | rep | MA | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
3044 | 3044 | Philip Barbour B000131 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 11 | |||||||||||||
3047 | 3047 | Mordecai Bartley B000210 | rep | OH | 1823-12-01 | 1825-03-03 | 14 | ||||||||||||||
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 | ||||||||||||||
3092 | 3092 | Henry Dwight D000579 | rep | MA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
3110 | 3110 | Henry Gurley G000529 | rep | LA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3124 | 3124 | Joseph Hemphill H000470 | rep | PA | 1823-12-01 | 1825-03-03 | Federalist | 2 | |||||||||||||
3141 | 3141 | Samuel Ingham I000022 | rep | PA | 1823-12-01 | 1825-03-03 | Jackson Republican | 8 | |||||||||||||
3151 | 3151 | Jonathan Jennings J000097 | rep | IN | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3165 | 3165 | Edward Livingston L000366 | rep | LA | 1823-12-01 | 1825-03-03 | Jacksonian | 1 | |||||||||||||
3177 | 3177 | John McLean M000550 | sen | IL | 1824-01-01 | 1825-03-03 | 3 | Crawford Republican | |||||||||||||
3179 | 3179 | Daniel Miller M000722 | rep | PA | 1823-12-01 | 1825-03-03 | Jacksonian | 3 | |||||||||||||
3198 | 3198 | Robert Rose R000439 | rep | NY | 1823-12-01 | 1825-03-03 | Anti Mason | 26 | |||||||||||||
3213 | 3213 | Alexander Smyth S000646 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 22 | |||||||||||||
3227 | 3227 | Henry Storrs S000976 | rep | NY | 1823-12-01 | 1825-03-03 | Federalist | 14 | |||||||||||||
3232 | 3232 | James Strong S001010 | rep | NY | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
3237 | 3237 | Samuel Swan S001088 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3244 | 3244 | John Test T000138 | rep | IN | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
3260 | 3260 | Starling Tucker T000402 | rep | SC | 1823-12-01 | 1825-03-03 | Jacksonian | 9 | |||||||||||||
3271 | 3271 | George Wolf W000673 | rep | PA | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
3288 | 3288 | Mark Alexander A000099 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 4 | |||||||||||||
3309 | 3309 | John Barbour B000128 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 15 | |||||||||||||
3342 | 3342 | Lewis Condict C000668 | rep | NJ | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
3387 | 3387 | John Forsyth F000284 | rep | GA | 1823-12-01 | 1825-03-03 | Democratic Republican | -1 | |||||||||||||
3430 | 3430 | Jacob Isacks I000045 | rep | TN | 1823-12-01 | 1825-03-03 | Jackson Republican | 4 | |||||||||||||
3438 | 3438 | Josiah Johnston J000194 | sen | LA | 1824-01-15 | 1825-03-03 | 3 | Adams | |||||||||||||
3459 | 3459 | Rollin Mallary M000079 | rep | VT | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
3475 | 3475 | William McCoy M000377 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 19 | |||||||||||||
3483 | 3483 | George Mitchell M000810 | rep | MD | 1823-12-01 | 1825-03-03 | Jacksonian | 6 | |||||||||||||
3492 | 3492 | Gabriel Moore M000898 | rep | AL | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
3501 | 3501 | Jeremiah Nelson N000036 | rep | MA | 1823-12-01 | 1825-03-03 | Federalist | 3 | |||||||||||||
3515 | 3515 | Thomas Newton N000078 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 1 | |||||||||||||
3557 | 3557 | John Taylor T000091 | rep | NY | 1823-12-01 | 1825-03-03 | Republican | 17 | |||||||||||||
3563 | 3563 | Wiley Thompson T000222 | rep | GA | 1823-12-01 | 1825-03-03 | Jacksonian | -1 | |||||||||||||
3570 | 3570 | Gideon Tomlinson T000300 | rep | CT | 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);