legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,208 rows where party = "Whig" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10554 | 10554 | Alexander Stephens S000854 | rep | GA | 1853-12-05 | 1855-03-03 | Whig | 8 | |||||||||||||
10552 | 10552 | Alexander Stephens S000854 | rep | GA | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
10551 | 10551 | Alexander Stephens S000854 | rep | GA | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
10550 | 10550 | Alexander Stephens S000854 | rep | GA | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
10549 | 10549 | Alexander Stephens S000854 | rep | GA | 1843-12-04 | 1845-03-03 | Whig | -1 | |||||||||||||
9502 | 9502 | Charles Faulkner F000044 | rep | VA | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
9406 | 9406 | Alexander White W000353 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
9101 | 9101 | James Brooks B000881 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
9100 | 9100 | James Brooks B000881 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
9005 | 9005 | Sion Rogers R000402 | rep | NC | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
8850 | 8850 | Lewis Campbell C000096 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
8849 | 8849 | Lewis Campbell C000096 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
8848 | 8848 | Lewis Campbell C000096 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
8767 | 8767 | Elihu Washburne W000176 | rep | IL | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
8710 | 8710 | Robert Schenck S000118 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
8709 | 8709 | Robert Schenck S000118 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
8708 | 8708 | Robert Schenck S000118 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
8707 | 8707 | Robert Schenck S000118 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
8701 | 8701 | Robert Ridgway R000248 | rep | VA | 1867-03-04 | 1869-03-03 | Whig | -1 | |||||||||||||
8696 | 8696 | Alexander Ramsey R000026 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 14 | |||||||||||||
8695 | 8695 | Alexander Ramsey R000026 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 14 | |||||||||||||
8575 | 8575 | Nathan Dixon D000375 | rep | RI | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
8449 | 8449 | Thaddeus Stevens S000887 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
8448 | 8448 | Thaddeus Stevens S000887 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
8324 | 8324 | Thomas Eliot E000106 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
8305 | 8305 | Columbus Delano D000214 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 10 | |||||||||||||
8302 | 8302 | Garrett Davis D000099 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
8301 | 8301 | Garrett Davis D000099 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
8300 | 8300 | Garrett Davis D000099 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
8299 | 8299 | Garrett Davis D000099 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
8267 | 8267 | Nathaniel Boyden B000722 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
8241 | 8241 | Richard Yates Y000012 | rep | IL | 1853-12-05 | 1855-03-03 | Whig | 6 | |||||||||||||
8240 | 8240 | Richard Yates Y000012 | rep | IL | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
8211 | 8211 | Nathaniel Taylor T000095 | rep | TN | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
8180 | 8180 | William Newell N000066 | rep | NJ | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
8179 | 8179 | William Newell N000066 | rep | NJ | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
8157 | 8157 | Orlando Kellogg K000066 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 14 | |||||||||||||
8142 | 8142 | Jacob Howard H000839 | rep | MI | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
8123 | 8123 | Henry Grider G000455 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
8122 | 8122 | Henry Grider G000455 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
8114 | 8114 | William Fessenden F000099 | rep | ME | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
8093 | 8093 | William Campbell C000104 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
8092 | 8092 | William Campbell C000104 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
8091 | 8091 | William Campbell C000104 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
8065 | 8065 | William Wright W000772 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 5 | |||||||||||||
8042 | 8042 | John Stuart S001035 | rep | IL | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
8041 | 8041 | John Stuart S001035 | rep | IL | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
8012 | 8012 | Jesse Norton N000151 | rep | IL | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
7973 | 7973 | Reverdy Johnson J000169 | sen | MD | 1845-12-01 | 1849-12-31 | 1 | Whig | |||||||||||||
7952 | 7952 | Solomon Foot F000248 | rep | VT | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
7951 | 7951 | Solomon Foot F000248 | rep | VT | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
7945 | 7945 | James Dixon D000369 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
7944 | 7944 | James Dixon D000369 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
7880 | 7880 | Albert White W000351 | sen | IN | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
7879 | 7879 | Albert White W000351 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
7853 | 7853 | Elbridge Spaulding S000705 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 32 | |||||||||||||
7824 | 7824 | James Pearce P000161 | sen | MD | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
7823 | 7823 | James Pearce P000161 | sen | MD | 1843-12-04 | 1849-03-03 | 3 | Whig | |||||||||||||
7822 | 7822 | James Pearce P000161 | rep | MD | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
7821 | 7821 | James Pearce P000161 | rep | MD | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
7820 | 7820 | James Pearce P000161 | rep | MD | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
7807 | 7807 | Edward Morris M000975 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
7780 | 7780 | Henry Lane L000060 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
7779 | 7779 | Henry Lane L000060 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
7725 | 7725 | John Crittenden C000912 | sen | KY | 1843-12-04 | 1848-06-12 | 3 | Whig | |||||||||||||
7724 | 7724 | John Crittenden C000912 | sen | KY | 1842-03-31 | 1843-03-03 | 3 | Whig | |||||||||||||
7723 | 7723 | John Crittenden C000912 | sen | KY | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
7720 | 7720 | John Crisfield C000907 | rep | MD | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
7715 | 7715 | Thomas Corwin C000791 | sen | OH | 1845-12-01 | 1851-03-03 | 1 | Whig | |||||||||||||
7714 | 7714 | Thomas Corwin C000791 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
7713 | 7713 | Thomas Corwin C000791 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
7712 | 7712 | Thomas Corwin C000791 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
7711 | 7711 | Thomas Corwin C000791 | rep | OH | 1833-12-02 | 1835-03-03 | Whig | 4 | |||||||||||||
7710 | 7710 | Thomas Corwin C000791 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 2 | |||||||||||||
7703 | 7703 | Jacob Collamer C000628 | rep | VT | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
7702 | 7702 | Jacob Collamer C000628 | rep | VT | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
7701 | 7701 | Jacob Collamer C000628 | rep | VT | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
7665 | 7665 | John Bernhisel B000412 | rep | UT | 1861-07-04 | 1863-03-03 | Whig | -1 | |||||||||||||
7664 | 7664 | John Bernhisel B000412 | rep | UT | 1857-12-07 | 1859-03-03 | Whig | -1 | |||||||||||||
7663 | 7663 | John Bernhisel B000412 | rep | UT | 1855-12-03 | 1857-03-03 | Whig | -1 | |||||||||||||
7662 | 7662 | John Bernhisel B000412 | rep | UT | 1853-12-05 | 1855-03-03 | Whig | -1 | |||||||||||||
7661 | 7661 | John Bernhisel B000412 | rep | UT | 1851-12-01 | 1853-03-03 | Whig | -1 | |||||||||||||
7655 | 7655 | William Appleton A000270 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
7654 | 7654 | William Appleton A000270 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
7647 | 7647 | Abraham Lincoln L000313 | rep | IL | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
7643 | 7643 | Edward Baker B000059 | rep | IL | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
7642 | 7642 | Edward Baker B000059 | rep | IL | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
7621 | 7621 | Israel Washburn W000173 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
7620 | 7620 | Israel Washburn W000173 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
7612 | 7612 | Robert Toombs T000313 | rep | GA | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
7611 | 7611 | Robert Toombs T000313 | rep | GA | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
7610 | 7610 | Robert Toombs T000313 | rep | GA | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
7609 | 7609 | Robert Toombs T000313 | rep | GA | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
7582 | 7582 | Benjamin Stanton S000801 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
7523 | 7523 | Freeman Morse M001010 | rep | ME | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
7452 | 7452 | Robert Hunter H000988 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
7451 | 7451 | Robert Hunter H000988 | rep | VA | 1837-09-04 | 1839-03-03 | Whig | 9 | |||||||||||||
7402 | 7402 | Emerson Etheridge E000227 | rep | TN | 1853-12-05 | 1855-03-03 | Whig | 9 | |||||||||||||
7383 | 7383 | John Dick D000303 | rep | PA | 1859-12-05 | 1861-03-03 | Whig | -1 | |||||||||||||
7380 | 7380 | John Dick D000303 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 25 |
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);