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
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
2711 | 2711 | John Rowan R000471 | sen | KY | 1825-12-05 | 1831-03-03 | 3 | Jackson | |||||||||||||
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 | |||||||||||||
2761 | 2761 | William Smith S000628 | sen | SC | 1826-11-29 | 1831-03-03 | 3 | Jackson | |||||||||||||
3017 | 3017 | Jacob Burnet B001117 | sen | OH | 1828-01-01 | 1831-03-03 | 3 | Adams | |||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
3046 | 3046 | Philip Barbour B000131 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3050 | 3050 | Mordecai Bartley B000210 | rep | OH | 1829-12-07 | 1831-03-03 | 14 | ||||||||||||||
3051 | 3051 | Robert Baylor B000257 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3052 | 3052 | Thomas Beekman B000308 | rep | NY | 1829-12-07 | 1831-03-03 | Anti-Jacksonian | 22 | |||||||||||||
3057 | 3057 | John Biddle B000441 | rep | MI | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
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 | |||||||||||||
3061 | 3061 | Samuel Butman B001198 | rep | ME | 1829-12-07 | 1831-03-03 | 7 | ||||||||||||||
3066 | 3066 | James Clark C000436 | rep | KY | 1829-12-07 | 1831-03-03 | Republican | 3 | |||||||||||||
3067 | 3067 | Nicholas Coleman C000620 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3068 | 3068 | Henry Cowles C000828 | rep | NY | 1829-12-07 | 1831-03-03 | 4 | ||||||||||||||
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 | |||||||||||||
3075 | 3075 | Benjamin Crowninshield C000946 | rep | MA | 1829-12-07 | 1831-03-03 | 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 | |||||||||||||
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 | ||||||||||||||
3090 | 3090 | Edward Dudley D000512 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
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 | ||||||||||||||
3098 | 3098 | Jonas Earll E000011 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 23 | |||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
3113 | 3113 | Henry Gurley G000529 | rep | LA | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
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 | |||||||||||||
3118 | 3118 | Joseph Hawkins H000371 | rep | NY | 1829-12-07 | 1831-03-03 | Adams Democrat | 20 | |||||||||||||
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 | |||||||||||||
3131 | 3131 | Gabriel Holmes H000737 | rep | NC | 1829-12-07 | 1831-03-03 | -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 | |||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
3173 | 3173 | William Martin M000202 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3174 | 3174 | Thomas Maxwell M000271 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 25 | |||||||||||||
3175 | 3175 | William McCreery M000386 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 15 | |||||||||||||
3178 | 3178 | John McLean M000550 | sen | IL | 1829-12-07 | 1831-03-03 | 2 | Jackson | |||||||||||||
3182 | 3182 | Daniel Miller M000722 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3184 | 3184 | Robert Monell M000853 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 21 | |||||||||||||
3185 | 3185 | Ebenezer Norton N000146 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 30 | |||||||||||||
3186 | 3186 | Walter Overton O000147 | rep | LA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3187 | 3187 | Spencer Pettis P000275 | rep | MO | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3189 | 3189 | Isaac Pierson P000341 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3190 | 3190 | Gershom Powers P000489 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 24 | |||||||||||||
3194 | 3194 | Joseph Richardson R000226 | rep | MA | 1829-12-07 | 1831-03-03 | 11 | ||||||||||||||
3197 | 3197 | James Ripley R000266 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3200 | 3200 | Robert Rose R000439 | rep | NY | 1829-12-07 | 1831-03-03 | Anti Masonic | 26 | |||||||||||||
3201 | 3201 | Jonah Sanford S000050 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 20 | |||||||||||||
3202 | 3202 | John Scott S000175 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3203 | 3203 | James Shields S000361 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3205 | 3205 | Thomas Sill S000410 | rep | PA | 1829-12-07 | 1831-03-03 | 18 | ||||||||||||||
3215 | 3215 | Alexander Smyth S000646 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 22 | |||||||||||||
3216 | 3216 | Ambrose Spencer S000721 | rep | NY | 1829-12-07 | 1831-03-03 | 10 | ||||||||||||||
3217 | 3217 | Richard Spencer S000729 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3222 | 3222 | Michael Sprigg S000751 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3224 | 3224 | John Sterigere S000867 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3230 | 3230 | Henry Storrs S000976 | rep | NY | 1829-12-07 | 1831-03-03 | Federalist | 14 | |||||||||||||
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 | ||||||||||||||
3249 | 3249 | James Trezvant T000365 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3263 | 3263 | Starling Tucker T000402 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3266 | 3266 | John Varnum V000073 | rep | MA | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3268 | 3268 | Ephraim Wilson W000576 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3270 | 3270 | Joseph Wingate W000632 | rep | ME | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3274 | 3274 | George Wolf W000673 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3276 | 3276 | Joel Yancey Y000002 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
3277 | 3277 | Robert Adams A000043 | sen | MS | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
3278 | 3278 | David Baker B000058 | sen | IL | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
3291 | 3291 | Mark Alexander A000099 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3294 | 3294 | Robert Allen A000143 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 17 | |||||||||||||
3299 | 3299 | John Anderson A000193 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3302 | 3302 | William Angel A000256 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 13 | |||||||||||||
3306 | 3306 | William Armstrong A000284 | rep | VA | 1829-12-07 | 1831-03-03 | 16 | ||||||||||||||
3312 | 3312 | John Barbour B000128 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 15 | |||||||||||||
3321 | 3321 | John Brodhead B000858 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3325 | 3325 | William Cahoon C000020 | rep | VT | 1829-12-07 | 1831-03-03 | Anti Masonic | 5 |
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);