legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
19 rows where "start" is on date 1831-12-05 and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3324 | 3324 | Alexander Buckner B001030 | sen | MO | 1831-12-05 | 1833-12-31 | 3 | Jackson | |||||||||||||
3332 | 3332 | Ezekiel Chambers C000282 | sen | MD | 1831-12-05 | 1835-03-03 | 3 | Adams | |||||||||||||
3359 | 3359 | George Dallas D000011 | sen | PA | 1831-12-05 | 1833-03-03 | 1 | Jackson | |||||||||||||
3390 | 3390 | John Forsyth F000284 | sen | GA | 1831-12-05 | 1834-06-27 | 3 | Jackson | |||||||||||||
3398 | 3398 | Robert Hanna H000165 | sen | IN | 1831-12-05 | 1833-03-03 | 1 | Anti-Jacksonian | |||||||||||||
3404 | 3404 | William Hendricks H000494 | sen | IN | 1831-12-05 | 1837-03-03 | 3 | Adams | |||||||||||||
3405 | 3405 | Isaac Hill H000593 | sen | NH | 1831-12-05 | 1837-03-03 | 3 | Jackson | |||||||||||||
3440 | 3440 | Josiah Johnston J000194 | sen | LA | 1831-12-05 | 1833-05-19 | 3 | ||||||||||||||
3442 | 3442 | Elias Kane K000006 | sen | IL | 1831-12-05 | 1835-12-31 | 3 | Jackson | |||||||||||||
3464 | 3464 | William Marcy M000127 | sen | NY | 1831-12-05 | 1833-12-31 | 3 | Jackson | |||||||||||||
3482 | 3482 | Stephen Miller M000755 | sen | SC | 1831-12-05 | 1833-12-31 | 3 | Nullifier | |||||||||||||
3495 | 3495 | Gabriel Moore M000898 | sen | AL | 1831-12-05 | 1837-03-03 | 3 | Jackson | |||||||||||||
3572 | 3572 | Gideon Tomlinson T000300 | sen | CT | 1831-12-05 | 1837-03-03 | 3 | Anti-Jacksonian | |||||||||||||
3580 | 3580 | George Waggaman W000017 | sen | LA | 1831-12-05 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
4326 | 4326 | Samuel Prentiss P000510 | sen | VT | 1831-12-05 | 1837-03-03 | 3 | Anti-Jacksonian | |||||||||||||
5322 | 5322 | William Wilkins W000475 | sen | PA | 1831-12-05 | 1835-03-03 | 3 | Jackson | |||||||||||||
5770 | 5770 | Willie Mangum M000096 | sen | NC | 1831-12-05 | 1836-11-26 | 3 | Jackson | |||||||||||||
5937 | 5937 | Henry Clay C000482 | sen | KY | 1831-12-05 | 1837-03-03 | 3 | Whig | |||||||||||||
6186 | 6186 | Thomas Ewing E000281 | sen | OH | 1831-12-05 | 1837-03-03 | 3 | Anti-Jacksonian |
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);