legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
74 rows where party = "Whig" and state = "NC"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, start, end, class, district, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4037 | 4037 | Ebenezer Pettigrew P000270 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
4058 | 4058 | William Shepard S000331 | rep | NC | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
4059 | 4059 | William Shepard S000331 | rep | NC | 1831-12-05 | 1833-03-03 | Whig | 1 | |||||||||||||
4060 | 4060 | William Shepard S000331 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 1 | |||||||||||||
4061 | 4061 | William Shepard S000331 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4341 | 4341 | Samuel Sawyer S000093 | rep | NC | 1837-09-04 | 1839-03-03 | Whig | 1 | |||||||||||||
4608 | 4608 | Charles Shepard S000329 | rep | NC | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4647 | 4647 | William Graham G000362 | sen | NC | 1840-01-01 | 1843-03-03 | 3 | Whig | |||||||||||||
4905 | 4905 | Anderson Mitchell M000804 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 13 | |||||||||||||
4957 | 4957 | Abraham Rencher R000162 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 10 | |||||||||||||
4958 | 4958 | Abraham Rencher R000162 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
4959 | 4959 | Abraham Rencher R000162 | rep | NC | 1837-09-04 | 1839-03-03 | Whig | 10 | |||||||||||||
4960 | 4960 | Abraham Rencher R000162 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
5056 | 5056 | William Washington W000182 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
5074 | 5074 | Lewis Williams W000527 | rep | NC | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
5077 | 5077 | Lewis Williams W000527 | rep | NC | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
5078 | 5078 | Lewis Williams W000527 | rep | NC | 1831-12-05 | 1833-03-03 | Whig | 13 | |||||||||||||
5079 | 5079 | Lewis Williams W000527 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 13 | |||||||||||||
5080 | 5080 | Lewis Williams W000527 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 13 | |||||||||||||
5081 | 5081 | Lewis Williams W000527 | rep | NC | 1837-09-04 | 1839-03-03 | Whig | 13 | |||||||||||||
5082 | 5082 | Lewis Williams W000527 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 13 | |||||||||||||
5083 | 5083 | Lewis Williams W000527 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 13 | |||||||||||||
5268 | 5268 | Kenneth Rayner R000087 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5269 | 5269 | Kenneth Rayner R000087 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
5270 | 5270 | Kenneth Rayner R000087 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 9 | |||||||||||||
5428 | 5428 | James Graham G000355 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 12 | |||||||||||||
5429 | 5429 | James Graham G000355 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 12 | |||||||||||||
5430 | 5430 | James Graham G000355 | rep | NC | 1837-09-04 | 1839-03-03 | Whig | 12 | |||||||||||||
5431 | 5431 | James Graham G000355 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
5432 | 5432 | James Graham G000355 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
5433 | 5433 | James Graham G000355 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5607 | 5607 | Daniel Barringer B000182 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5608 | 5608 | Daniel Barringer B000182 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5609 | 5609 | Daniel Barringer B000182 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5673 | 5673 | Richard Donnell D000415 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5771 | 5771 | Willie Mangum M000096 | sen | NC | 1840-11-25 | 1841-03-03 | 2 | Whig | |||||||||||||
5772 | 5772 | Willie Mangum M000096 | sen | NC | 1841-03-04 | 1847-03-03 | 2 | Whig | |||||||||||||
5773 | 5773 | Willie Mangum M000096 | sen | NC | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5899 | 5899 | George Badger B000022 | sen | NC | 1846-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5900 | 5900 | George Badger B000022 | sen | NC | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
5958 | 5958 | Edmund Deberry D000181 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 7 | |||||||||||||
5959 | 5959 | Edmund Deberry D000181 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
5960 | 5960 | Edmund Deberry D000181 | rep | NC | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
5961 | 5961 | Edmund Deberry D000181 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
5962 | 5962 | Edmund Deberry D000181 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
5963 | 5963 | Edmund Deberry D000181 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
5964 | 5964 | Edmund Deberry D000181 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6117 | 6117 | Augustine Shepperd S000338 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 9 | |||||||||||||
6118 | 6118 | Augustine Shepperd S000338 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 9 | |||||||||||||
6119 | 6119 | Augustine Shepperd S000338 | rep | NC | 1837-09-04 | 1839-03-03 | Whig | 9 | |||||||||||||
6120 | 6120 | Augustine Shepperd S000338 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 9 | |||||||||||||
6121 | 6121 | Augustine Shepperd S000338 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6122 | 6122 | Augustine Shepperd S000338 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6248 | 6248 | Joseph Caldwell C000037 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6249 | 6249 | Joseph Caldwell C000037 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6274 | 6274 | Alfred Dockery D000385 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
6275 | 6275 | Alfred Dockery D000385 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6372 | 6372 | James Morehead M000937 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6377 | 6377 | David Outlaw O000138 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
6378 | 6378 | David Outlaw O000138 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 9 | |||||||||||||
6379 | 6379 | David Outlaw O000138 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 9 | |||||||||||||
6420 | 6420 | Edward Stanly S000799 | rep | NC | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
6421 | 6421 | Edward Stanly S000799 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
6422 | 6422 | Edward Stanly S000799 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
6423 | 6423 | Edward Stanly S000799 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
6424 | 6424 | Edward Stanly S000799 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
6634 | 6634 | John Kerr K000140 | rep | NC | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
6904 | 6904 | Richard Puryear P000578 | rep | NC | 1853-12-05 | 1855-03-03 | Whig | 6 | |||||||||||||
7260 | 7260 | Thomas Clingman C000524 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
7261 | 7261 | Thomas Clingman C000524 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
7262 | 7262 | Thomas Clingman C000524 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
7263 | 7263 | Thomas Clingman C000524 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
8267 | 8267 | Nathaniel Boyden B000722 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
9005 | 9005 | Sion Rogers R000402 | rep | NC | 1853-12-05 | 1855-03-03 | Whig | 4 |
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);