legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
27 rows where district = 1 and "end" is on date 1847-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5366 | 5366 | William Brockenbrough B000852 | rep | FL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5391 | 5391 | Henry Cranston C000878 | rep | RI | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5396 | 5396 | Edmund Dargan D000052 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5433 | 5433 | James Graham G000355 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5467 | 5467 | John Lawrence L000136 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5488 | 5488 | Thomas Newton N000077 | rep | AR | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5491 | 5491 | Robert Owen O000152 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5514 | 5514 | John Scamman S000104 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5583 | 5583 | Archibald Yell Y000017 | rep | AR | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5604 | 5604 | Archibald Atkinson A000328 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5619 | 5619 | James Black B000501 | rep | SC | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5643 | 5643 | John Chapman C000314 | rep | MD | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5688 | 5688 | James Faran F000014 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5713 | 5713 | James Hampton H000138 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5779 | 5779 | Robert McClelland M000334 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6022 | 6022 | David Kaufman K000021 | rep | TX | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6034 | 6034 | Thomas King K000215 | rep | GA | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6037 | 6037 | Emile La Sére L000008 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6043 | 6043 | Lewis Levin L000262 | rep | PA | 1845-12-01 | 1847-03-03 | American | 1 | |||||||||||||
6201 | 6201 | Robert Winthrop W000646 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6242 | 6242 | Edward Cabell C000003 | rep | FL | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6526 | 6526 | Linn Boyd B000719 | rep | KY | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6921 | 6921 | John Slidell S000487 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
7226 | 7226 | Robert Smith S000604 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
7944 | 7944 | James Dixon D000369 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
7952 | 7952 | Solomon Foot F000248 | rep | VT | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
9541 | 9541 | Andrew Johnson J000116 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 1 |
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);