legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
22 rows where class = 3 and "end" is on date 1849-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5114 | 5114 | William Allen A000150 | sen | OH | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5119 | 5119 | Arthur Bagby B000030 | sen | AL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5141 | 5141 | Sidney Breese B000793 | sen | IL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5176 | 5176 | Walter Colquitt C000648 | sen | GA | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5213 | 5213 | Edward Hannegan H000167 | sen | IN | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5257 | 5257 | John Niles N000108 | sen | CT | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5347 | 5347 | Henry Johnson J000137 | sen | LA | 1844-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5411 | 5411 | John Dix D000365 | sen | NY | 1845-12-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5572 | 5572 | James Westcott W000308 | sen | FL | 1845-12-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5860 | 5860 | Solon Borland B000642 | sen | AR | 1848-03-30 | 1849-03-03 | 3 | Democrat | |||||||||||||
5866 | 5866 | Augustus Dodge D000394 | sen | IA | 1848-12-07 | 1849-03-03 | 3 | Democrat | |||||||||||||
5869 | 5869 | Herschel Johnson J000139 | sen | GA | 1848-01-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5878 | 5878 | William King K000217 | sen | AL | 1848-07-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5885 | 5885 | Thomas Metcalfe M000676 | sen | KY | 1848-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5887 | 5887 | Isaac Walker W000055 | sen | WI | 1848-06-08 | 1849-03-03 | 3 | Democrat | |||||||||||||
5897 | 5897 | David Atchison A000322 | sen | MO | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5899 | 5899 | George Badger B000022 | sen | NC | 1846-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
6151 | 6151 | William Upham U000025 | sen | VT | 1843-12-04 | 1849-03-03 | 3 | Whig | |||||||||||||
6497 | 6497 | Charles Atherton A000323 | sen | NH | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
6780 | 6780 | Andrew Butler B001173 | sen | SC | 1846-01-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
7823 | 7823 | James Pearce P000161 | sen | MD | 1843-12-04 | 1849-03-03 | 3 | Whig | |||||||||||||
9108 | 9108 | Simon Cameron C000068 | sen | PA | 1845-12-01 | 1849-03-03 | 3 | Democrat |
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);