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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3277 | 3277 | Robert Adams A000043 | sen | MS | 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 | |||||||||||||
3033 | 3033 | Willis Alston A000167 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
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 | |||||||||||||
4672 | 4672 | William Archer A000275 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3306 | 3306 | William Armstrong A000284 | rep | VA | 1829-12-07 | 1831-03-03 | 16 | ||||||||||||||
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 | ||||||||||||||
3278 | 3278 | David Baker B000058 | sen | IL | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
3599 | 3599 | Noyes Barber B000125 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3312 | 3312 | John Barbour B000128 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 15 | |||||||||||||
3046 | 3046 | Philip Barbour B000131 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
6180 | 6180 | Robert Barnwell B000168 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3605 | 3605 | Daniel Barringer B000181 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3050 | 3050 | Mordecai Bartley B000210 | rep | OH | 1829-12-07 | 1831-03-03 | 14 | ||||||||||||||
2558 | 2558 | David Barton B000212 | sen | MO | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
4688 | 4688 | Isaac Bates B000233 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 8 | |||||||||||||
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 | |||||||||||||
6504 | 6504 | John Bell B000340 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3057 | 3057 | John Biddle B000441 | rep | MI | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3616 | 3616 | James Blair B000526 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3622 | 3622 | John Blair B000528 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3849 | 3849 | Abraham Bockee B000581 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
4135 | 4135 | Ratliff Boon B000628 | rep | IN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3058 | 3058 | Peter Borst B000645 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3626 | 3626 | Thomas Bouldin B000663 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3321 | 3321 | John Brodhead B000858 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3059 | 3059 | Elias Brown B000912 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
6967 | 6967 | James Buchanan B001005 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3634 | 3634 | Tristam Burges B001082 | rep | RI | 1829-12-07 | 1831-03-03 | Anti Jacksonian | -1 | |||||||||||||
3017 | 3017 | Jacob Burnet B001117 | sen | OH | 1828-01-01 | 1831-03-03 | 3 | Adams | |||||||||||||
3061 | 3061 | Samuel Butman B001198 | rep | ME | 1829-12-07 | 1831-03-03 | 7 | ||||||||||||||
3325 | 3325 | William Cahoon C000020 | rep | VT | 1829-12-07 | 1831-03-03 | Anti Masonic | 5 | |||||||||||||
4156 | 4156 | Churchill Cambreleng C000061 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
5154 | 5154 | John Campbell C000090 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3329 | 3329 | Samuel Carson C000193 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3331 | 3331 | Ezekiel Chambers C000282 | sen | MD | 1826-01-01 | 1831-03-03 | 3 | Adams | |||||||||||||
3333 | 3333 | Thomas Chandler C000294 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
6539 | 6539 | Dudley Chase C000325 | sen | VT | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
4735 | 4735 | Timothy Childs C000355 | rep | NY | 1829-12-07 | 1831-03-03 | Anti Masonic | 27 | |||||||||||||
3640 | 3640 | Thomas Chilton C000359 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3870 | 3870 | Nathaniel Claiborne C000405 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3066 | 3066 | James Clark C000436 | rep | KY | 1829-12-07 | 1831-03-03 | Republican | 3 | |||||||||||||
4172 | 4172 | Clement Clay C000481 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3335 | 3335 | Richard Coke C000602 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3067 | 3067 | Nicholas Coleman C000620 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3345 | 3345 | Lewis Condict C000668 | rep | NJ | 1829-12-07 | 1831-03-03 | Republican | -1 | |||||||||||||
4429 | 4429 | Henry Connor C000700 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3350 | 3350 | Richard Cooper C000760 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3647 | 3647 | Richard Coulter C000808 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 17 | |||||||||||||
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 | |||||||||||||
4438 | 4438 | Robert Craig C000859 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 20 | |||||||||||||
3880 | 3880 | Joseph Crane C000872 | rep | OH | 1829-12-07 | 1831-03-03 | Whig | 3 | |||||||||||||
3352 | 3352 | Thomas Crawford C000893 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3357 | 3357 | William Creighton C000902 | rep | OH | 1829-12-07 | 1831-03-03 | Republican | 6 | |||||||||||||
3071 | 3071 | Jacob Crocheron C000915 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3651 | 3651 | David Crockett C000918 | rep | TN | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 9 | |||||||||||||
3075 | 3075 | Benjamin Crowninshield C000946 | rep | MA | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3361 | 3361 | Henry Daniel D000033 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3655 | 3655 | Thomas Davenport D000079 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
5665 | 5665 | John Davis D000117 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 5 | |||||||||||||
3885 | 3885 | Warren Davis D000142 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
5957 | 5957 | Edmund Deberry D000181 | rep | NC | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 7 | |||||||||||||
3889 | 3889 | Harmar Denny D000248 | rep | PA | 1829-12-07 | 1831-03-03 | Anti Masonic | 16 | |||||||||||||
3078 | 3078 | Robert Desha D000272 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3076 | 3076 | Charles De Witt D000284 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3085 | 3085 | John Dickinson D000322 | rep | NY | 1829-12-07 | 1831-03-03 | 9 | ||||||||||||||
3366 | 3366 | Philip Doddridge D000391 | rep | VA | 1829-12-07 | 1831-03-03 | 18 | ||||||||||||||
3088 | 3088 | Clement Dorsey D000437 | rep | MD | 1829-12-07 | 1831-03-03 | 1 | ||||||||||||||
3368 | 3368 | Joseph Draper D000487 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 22 | |||||||||||||
3372 | 3372 | William Drayton D000490 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3090 | 3090 | Edward Dudley D000512 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3666 | 3666 | Joseph Duncan D000535 | rep | IL | 1829-12-07 | 1831-03-03 | Jackson | 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 | ||||||||||||||
3098 | 3098 | Jonas Earll E000011 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 23 | |||||||||||||
3669 | 3669 | William Ellsworth E000150 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
4773 | 4773 | George Evans E000241 | rep | ME | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
3374 | 3374 | Joshua Evans E000248 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
6584 | 6584 | Edward Everett E000264 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
4780 | 4780 | Horace Everett E000265 | rep | VT | 1829-12-07 | 1831-03-03 | Whig | 3 | |||||||||||||
3099 | 3099 | Isaac Finch F000117 | rep | NY | 1829-12-07 | 1831-03-03 | 19 | ||||||||||||||
3378 | 3378 | James Findlay F000119 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3100 | 3100 | George Fisher F000146 | rep | NY | 1829-12-07 | 1831-03-03 | 20 | ||||||||||||||
3381 | 3381 | James Ford F000263 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3389 | 3389 | John Forsyth F000284 | sen | GA | 1829-12-07 | 1831-03-03 | 3 | Jackson | |||||||||||||
3103 | 3103 | Chauncey Forward F000290 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 13 | |||||||||||||
4793 | 4793 | Thomas Foster F000314 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3106 | 3106 | Joseph Fry F000397 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3391 | 3391 | Nathan Gaither G000010 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3393 | 3393 | John Gilmore G000222 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 16 | |||||||||||||
3107 | 3107 | John Goodenow G000283 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3683 | 3683 | William Gordon G000319 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
3689 | 3689 | Benjamin Gorham G000324 | rep | MA | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 1 | |||||||||||||
3109 | 3109 | Innis Green G000412 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
4214 | 4214 | George Grennell G000451 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 7 |
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);