legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
247 rows where "end" is on date 1831-03-03 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3034 | 3034 | Benedict Arnold A000287 | rep | NY | 1829-12-07 | 1831-03-03 | 16 | ||||||||||||||
3038 | 3038 | John Bailey B000041 | rep | MA | 1829-12-07 | 1831-03-03 | 10 | ||||||||||||||
3050 | 3050 | Mordecai Bartley B000210 | rep | OH | 1829-12-07 | 1831-03-03 | 14 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
3113 | 3113 | Henry Gurley G000529 | rep | LA | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3131 | 3131 | Gabriel Holmes H000737 | rep | NC | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3154 | 3154 | Jonathan Jennings J000097 | rep | IN | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3156 | 3156 | Kensey Johns J000112 | rep | DE | 1829-12-07 | 1831-03-03 | 0 | ||||||||||||||
3189 | 3189 | Isaac Pierson P000341 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3194 | 3194 | Joseph Richardson R000226 | rep | MA | 1829-12-07 | 1831-03-03 | 11 | ||||||||||||||
3205 | 3205 | Thomas Sill S000410 | rep | PA | 1829-12-07 | 1831-03-03 | 18 | ||||||||||||||
3216 | 3216 | Ambrose Spencer S000721 | rep | NY | 1829-12-07 | 1831-03-03 | 10 | ||||||||||||||
3235 | 3235 | James Strong S001010 | rep | NY | 1829-12-07 | 1831-03-03 | 8 | ||||||||||||||
3240 | 3240 | Samuel Swan S001088 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3246 | 3246 | John Test T000138 | rep | IN | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3266 | 3266 | John Varnum V000073 | rep | MA | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3270 | 3270 | Joseph Wingate W000632 | rep | ME | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3306 | 3306 | William Armstrong A000284 | rep | VA | 1829-12-07 | 1831-03-03 | 16 | ||||||||||||||
3350 | 3350 | Richard Cooper C000760 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3366 | 3366 | Philip Doddridge D000391 | rep | VA | 1829-12-07 | 1831-03-03 | 18 | ||||||||||||||
3407 | 3407 | James Hodges H000674 | rep | MA | 1829-12-07 | 1831-03-03 | 12 | ||||||||||||||
3417 | 3417 | Thomas Hughes H000928 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3420 | 3420 | Jonathan Hunt H000974 | rep | VT | 1829-12-07 | 1831-03-03 | 1 | ||||||||||||||
3426 | 3426 | Ralph Ingersoll I000020 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3443 | 3443 | Joseph Kendall K000094 | rep | MA | 1829-12-07 | 1831-03-03 | 6 | ||||||||||||||
3462 | 3462 | Rollin Mallary M000079 | rep | VT | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3533 | 3533 | James Randolph R000044 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3541 | 3541 | Benedict Semmes S000238 | rep | MD | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3599 | 3599 | Noyes Barber B000125 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3669 | 3669 | William Ellsworth E000150 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3726 | 3726 | Robert Letcher L000257 | rep | KY | 1829-12-07 | 1831-03-03 | 4 | ||||||||||||||
3826 | 3826 | Ebenezer Young Y000034 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
4108 | 4108 | Joseph White W000383 | rep | FL | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
2558 | 2558 | David Barton B000212 | sen | MO | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
2682 | 2682 | William Marks M000137 | sen | PA | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
2736 | 2736 | Calvin Willey W000482 | sen | CT | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
2758 | 2758 | Nathan Sanford S000052 | sen | NY | 1826-01-01 | 1831-03-03 | 3 | Adams | |||||||||||||
3017 | 3017 | Jacob Burnet B001117 | sen | OH | 1828-01-01 | 1831-03-03 | 3 | Adams | |||||||||||||
3331 | 3331 | Ezekiel Chambers C000282 | sen | MD | 1826-01-01 | 1831-03-03 | 3 | Adams | |||||||||||||
3403 | 3403 | William Hendricks H000494 | sen | IN | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
3439 | 3439 | Josiah Johnston J000194 | sen | LA | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
6539 | 6539 | Dudley Chase C000325 | sen | VT | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
3118 | 3118 | Joseph Hawkins H000371 | rep | NY | 1829-12-07 | 1831-03-03 | Adams Democrat | 20 | |||||||||||||
3466 | 3466 | Lewis Maxwell M000269 | rep | VA | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 21 | |||||||||||||
3634 | 3634 | Tristam Burges B001082 | rep | RI | 1829-12-07 | 1831-03-03 | Anti Jacksonian | -1 | |||||||||||||
3651 | 3651 | David Crockett C000918 | rep | TN | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 9 | |||||||||||||
3689 | 3689 | Benjamin Gorham G000324 | rep | MA | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 1 | |||||||||||||
4092 | 4092 | George Washington W000179 | rep | MD | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 3 | |||||||||||||
5559 | 5559 | Joseph Vance V000017 | rep | OH | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 4 | |||||||||||||
5957 | 5957 | Edmund Deberry D000181 | rep | NC | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 7 | |||||||||||||
3744 | 3744 | Henry Martindale M000204 | rep | NY | 1829-12-07 | 1831-03-03 | Anti Mason | 18 | |||||||||||||
4032 | 4032 | Dutee Pearce P000160 | rep | RI | 1829-12-07 | 1831-03-03 | Anti Mason | -1 | |||||||||||||
3200 | 3200 | Robert Rose R000439 | rep | NY | 1829-12-07 | 1831-03-03 | Anti Masonic | 26 | |||||||||||||
3325 | 3325 | William Cahoon C000020 | rep | VT | 1829-12-07 | 1831-03-03 | Anti Masonic | 5 | |||||||||||||
3574 | 3574 | Phineas Tracy T000346 | rep | NY | 1829-12-07 | 1831-03-03 | Anti Masonic | 29 | |||||||||||||
3889 | 3889 | Harmar Denny D000248 | rep | PA | 1829-12-07 | 1831-03-03 | Anti Masonic | 16 | |||||||||||||
4735 | 4735 | Timothy Childs C000355 | rep | NY | 1829-12-07 | 1831-03-03 | Anti Masonic | 27 | |||||||||||||
3052 | 3052 | Thomas Beekman B000308 | rep | NY | 1829-12-07 | 1831-03-03 | Anti-Jacksonian | 22 | |||||||||||||
5321 | 5321 | William Wilkins W000475 | rep | PA | 1829-12-07 | 1831-03-03 | Democrat | -1 | |||||||||||||
3230 | 3230 | Henry Storrs S000976 | rep | NY | 1829-12-07 | 1831-03-03 | Federalist | 14 | |||||||||||||
2711 | 2711 | John Rowan R000471 | sen | KY | 1825-12-05 | 1831-03-03 | 3 | Jackson | |||||||||||||
2761 | 2761 | William Smith S000628 | sen | SC | 1826-11-29 | 1831-03-03 | 3 | Jackson | |||||||||||||
3018 | 3018 | James Iredell I000028 | sen | NC | 1828-01-01 | 1831-03-03 | 3 | Jackson | |||||||||||||
3033 | 3033 | Willis Alston A000167 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3046 | 3046 | Philip Barbour B000131 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3051 | 3051 | Robert Baylor B000257 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3058 | 3058 | Peter Borst B000645 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3059 | 3059 | Elias Brown B000912 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3067 | 3067 | Nicholas Coleman C000620 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3070 | 3070 | Hector Craig C000856 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3071 | 3071 | Jacob Crocheron C000915 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3076 | 3076 | Charles De Witt D000284 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3078 | 3078 | Robert Desha D000272 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3090 | 3090 | Edward Dudley D000512 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3098 | 3098 | Jonas Earll E000011 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 23 | |||||||||||||
3103 | 3103 | Chauncey Forward F000290 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 13 | |||||||||||||
3106 | 3106 | Joseph Fry F000397 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3107 | 3107 | John Goodenow G000283 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3109 | 3109 | Innis Green G000412 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3114 | 3114 | Jehiel Halsey H000088 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 26 | |||||||||||||
3117 | 3117 | Jonathan Harvey H000308 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3126 | 3126 | Joseph Hemphill H000470 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3128 | 3128 | Thomas Hinds H000632 | rep | MS | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3144 | 3144 | Samuel Ingham I000022 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3145 | 3145 | Thomas Irwin I000043 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 14 | |||||||||||||
3157 | 3157 | John Kincaid K000186 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3158 | 3158 | Perkins King K000209 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3160 | 3160 | Pryor Lea L000166 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3161 | 3161 | George Leiper L000234 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3170 | 3170 | John Magee M000047 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 28 | |||||||||||||
3171 | 3171 | Alem Marr M000141 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 9 |
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);