legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2510 | 2510 | George Tucker T000397 | rep | VA | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2511 | 2511 | Jacob Tyson T000453 | rep | NY | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2521 | 2521 | William Van Wyck V000068 | rep | NY | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2522 | 2522 | Robert Vance V000018 | rep | NC | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2524 | 2524 | Nicholas Ware W000148 | sen | GA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2527 | 2527 | Henry Warfield W000150 | rep | MD | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2528 | 2528 | Isaac Wayne W000217 | rep | PA | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2529 | 2529 | David White W000363 | rep | KY | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2530 | 2530 | Lemuel Whitman W000422 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2536 | 2536 | Jared Williams W000510 | rep | VA | 1823-12-01 | 1825-03-03 | 17 | ||||||||||||||
2540 | 2540 | William Woods W000727 | rep | NY | 1823-12-01 | 1825-03-03 | 28 | ||||||||||||||
2545 | 2545 | Parmenio Adams A000042 | rep | NY | 1823-12-01 | 1825-03-03 | 29 | ||||||||||||||
2551 | 2551 | Robert Allen A000142 | rep | TN | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2553 | 2553 | James Allison A000157 | rep | PA | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2554 | 2554 | James Allison A000157 | rep | PA | 1825-12-05 | 1827-03-03 | -1 | ||||||||||||||
2560 | 2560 | Francis Baylies B000255 | rep | MA | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
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 | ||||||||||||||
2578 | 2578 | John Cocke C000571 | rep | TN | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2581 | 2581 | Daniel Cook C000716 | rep | IL | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2588 | 2588 | Samuel Edwards E000080 | rep | PA | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
2702 | 2702 | Joel Poinsett P000404 | rep | SC | 1825-12-05 | 1827-03-03 | -1 | ||||||||||||||
2707 | 2707 | Christopher Rankin R000054 | rep | MS | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2714 | 2714 | John Scott S000176 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2715 | 2715 | John Scott S000176 | rep | MO | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
2716 | 2716 | John Scott S000176 | rep | MO | 1819-12-06 | 1821-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 | ||||||||||||||
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 | ||||||||||||||
2778 | 2778 | Ichabod Bartlett B000205 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
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 | ||||||||||||||
2814 | 2814 | William Burleigh B001109 | rep | ME | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
2820 | 2820 | Henry Conway C000712 | rep | AR | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2821 | 2821 | Henry Conway C000712 | rep | AR | 1825-12-05 | 1827-03-03 | -1 | ||||||||||||||
2822 | 2822 | Henry Conway C000712 | rep | AR | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
2831 | 2831 | John Eaton E000024 | sen | TN | 1821-12-03 | 1825-03-03 | 1 | ||||||||||||||
2835 | 2835 | David Evans E000237 | rep | NY | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
3000 | 3000 | William Wilson W000619 | rep | OH | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
3004 | 3004 | Silas Wood W000703 | rep | NY | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
3011 | 3011 | John Wright W000764 | rep | OH | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
3012 | 3012 | John Wright W000764 | rep | OH | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
3016 | 3016 | William Young Y000057 | rep | KY | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
3034 | 3034 | Benedict Arnold A000287 | rep | NY | 1829-12-07 | 1831-03-03 | 16 | ||||||||||||||
3035 | 3035 | John Bailey B000041 | rep | MA | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
3038 | 3038 | John Bailey B000041 | rep | MA | 1829-12-07 | 1831-03-03 | 10 | ||||||||||||||
3047 | 3047 | Mordecai Bartley B000210 | rep | OH | 1823-12-01 | 1825-03-03 | 14 | ||||||||||||||
3050 | 3050 | Mordecai Bartley B000210 | rep | OH | 1829-12-07 | 1831-03-03 | 14 | ||||||||||||||
3054 | 3054 | Samuel Bell B000345 | sen | NH | 1829-12-07 | 1835-03-03 | 2 | ||||||||||||||
3057 | 3057 | John Biddle B000441 | rep | MI | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3061 | 3061 | Samuel Butman B001198 | rep | ME | 1829-12-07 | 1831-03-03 | 7 | ||||||||||||||
3068 | 3068 | Henry Cowles C000828 | rep | NY | 1829-12-07 | 1831-03-03 | 4 | ||||||||||||||
3072 | 3072 | Benjamin Crowninshield C000946 | rep | MA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3075 | 3075 | Benjamin Crowninshield C000946 | rep | MA | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3085 | 3085 | John Dickinson D000322 | rep | NY | 1829-12-07 | 1831-03-03 | 9 | ||||||||||||||
3088 | 3088 | Clement Dorsey D000437 | rep | MD | 1829-12-07 | 1831-03-03 | 1 | ||||||||||||||
3092 | 3092 | Henry Dwight D000579 | rep | MA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
3095 | 3095 | Henry Dwight D000579 | rep | MA | 1829-12-07 | 1831-03-03 | 9 | ||||||||||||||
3096 | 3096 | Samuel Eager E000002 | rep | NY | 1829-12-07 | 1831-03-03 | 6 | ||||||||||||||
3099 | 3099 | Isaac Finch F000117 | rep | NY | 1829-12-07 | 1831-03-03 | 19 | ||||||||||||||
3100 | 3100 | George Fisher F000146 | rep | NY | 1829-12-07 | 1831-03-03 | 20 | ||||||||||||||
3110 | 3110 | Henry Gurley G000529 | rep | LA | 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);