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 state
This data as json, copyable, CSV (advanced)
Suggested facets: start (date), end (date)
state 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4255 | 4255 | Joab Lawler L000129 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4268 | 4268 | Francis Lyon L000542 | rep | AL | 1835-12-07 | 1837-03-03 | Whig | 5 | |||||||||||||
4269 | 4269 | Francis Lyon L000542 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
4436 | 4436 | George Crabb C000847 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4437 | 4437 | George Crabb C000847 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5189 | 5189 | James Dellet D000221 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
5190 | 5190 | James Dellet D000221 | rep | AL | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
5702 | 5702 | John Gayle G000106 | rep | AL | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5891 | 5891 | William Alston A000166 | rep | AL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6003 | 6003 | Henry Hilliard H000622 | rep | AL | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
6004 | 6004 | Henry Hilliard H000622 | rep | AL | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
6005 | 6005 | Henry Hilliard H000622 | rep | AL | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6486 | 6486 | James Abercrombie A000012 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6487 | 6487 | James Abercrombie A000012 | rep | AL | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
9406 | 9406 | Alexander White W000353 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
5488 | 5488 | Thomas Newton N000077 | rep | AR | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
4616 | 4616 | William Storrs S000977 | rep | CT | 1829-12-07 | 1831-03-03 | Whig | -1 | |||||||||||||
4617 | 4617 | William Storrs S000977 | rep | CT | 1831-12-05 | 1833-03-03 | Whig | -1 | |||||||||||||
4618 | 4618 | William Storrs S000977 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4699 | 4699 | William Boardman B000578 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4700 | 4700 | William Boardman B000578 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
4713 | 4713 | John Brockway B000854 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4714 | 4714 | John Brockway B000854 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
4928 | 4928 | Thomas Osborne O000114 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
4929 | 4929 | Thomas Osborne O000114 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
5040 | 5040 | Joseph Trumbull T000391 | rep | CT | 1833-12-02 | 1835-03-03 | Whig | -1 | |||||||||||||
5041 | 5041 | Joseph Trumbull T000391 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5042 | 5042 | Joseph Trumbull T000391 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
5084 | 5084 | Thomas Williams W000543 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5085 | 5085 | Thomas Williams W000543 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
5449 | 5449 | Jabez Huntington H000997 | rep | CT | 1829-12-07 | 1831-03-03 | Whig | -1 | |||||||||||||
5450 | 5450 | Jabez Huntington H000997 | rep | CT | 1831-12-05 | 1833-03-03 | Whig | -1 | |||||||||||||
5451 | 5451 | Jabez Huntington H000997 | rep | CT | 1833-12-02 | 1835-03-03 | Whig | -1 | |||||||||||||
5452 | 5452 | Jabez Huntington H000997 | sen | CT | 1840-01-01 | 1845-03-03 | 1 | Whig | |||||||||||||
5453 | 5453 | Jabez Huntington H000997 | sen | CT | 1845-12-01 | 1847-12-31 | 1 | Whig | |||||||||||||
5606 | 5606 | Roger Baldwin B000096 | sen | CT | 1847-12-06 | 1851-03-03 | 1 | Whig | |||||||||||||
5724 | 5724 | Samuel Hubbard H000889 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5725 | 5725 | Samuel Hubbard H000889 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5810 | 5810 | John Rockwell R000367 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5811 | 5811 | John Rockwell R000367 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5922 | 5922 | Thomas Butler B001191 | rep | CT | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6125 | 6125 | Truman Smith S000621 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
6126 | 6126 | Truman Smith S000621 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 5 | |||||||||||||
6127 | 6127 | Truman Smith S000621 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
6128 | 6128 | Truman Smith S000621 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6129 | 6129 | Truman Smith S000621 | sen | CT | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6256 | 6256 | Charles Chapman C000310 | rep | CT | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
7944 | 7944 | James Dixon D000369 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
7945 | 7945 | James Dixon D000369 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
4286 | 4286 | John Milligan M000767 | rep | DE | 1831-12-05 | 1833-03-03 | Whig | 0 | |||||||||||||
4287 | 4287 | John Milligan M000767 | rep | DE | 1833-12-02 | 1835-03-03 | Whig | 0 | |||||||||||||
4288 | 4288 | John Milligan M000767 | rep | DE | 1835-12-07 | 1837-03-03 | Whig | 0 | |||||||||||||
4289 | 4289 | John Milligan M000767 | rep | DE | 1837-09-04 | 1839-03-03 | Whig | 0 | |||||||||||||
4692 | 4692 | Richard Bayard B000251 | sen | DE | 1836-06-17 | 1839-03-03 | 1 | Whig | |||||||||||||
4693 | 4693 | Richard Bayard B000251 | sen | DE | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
4751 | 4751 | Thomas Clayton C000499 | sen | DE | 1837-09-04 | 1841-03-03 | 2 | Whig | |||||||||||||
4752 | 4752 | Thomas Clayton C000499 | sen | DE | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5277 | 5277 | George Rodney R000379 | rep | DE | 1841-05-31 | 1843-03-03 | Whig | 0 | |||||||||||||
5278 | 5278 | George Rodney R000379 | rep | DE | 1843-12-04 | 1845-03-03 | Whig | 0 | |||||||||||||
5825 | 5825 | Presley Spruance S000760 | sen | DE | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
6013 | 6013 | John Houston H000825 | rep | DE | 1845-12-01 | 1847-03-03 | Whig | 0 | |||||||||||||
6014 | 6014 | John Houston H000825 | rep | DE | 1847-12-06 | 1849-03-03 | Whig | 0 | |||||||||||||
6015 | 6015 | John Houston H000825 | rep | DE | 1849-12-03 | 1851-03-03 | Whig | 0 | |||||||||||||
6168 | 6168 | John Wales W000043 | sen | DE | 1849-12-03 | 1851-03-03 | 1 | Whig | |||||||||||||
6551 | 6551 | John Clayton C000496 | sen | DE | 1845-12-01 | 1849-12-31 | 1 | Whig | |||||||||||||
6074 | 6074 | Jackson Morton M001015 | sen | FL | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6242 | 6242 | Edward Cabell C000003 | rep | FL | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6243 | 6243 | Edward Cabell C000003 | rep | FL | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6244 | 6244 | Edward Cabell C000003 | rep | FL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6245 | 6245 | Edward Cabell C000003 | rep | FL | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
4517 | 4517 | Hines Holt H000745 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4658 | 4658 | Julius Alford A000104 | rep | GA | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
4659 | 4659 | Julius Alford A000104 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4660 | 4660 | Julius Alford A000104 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4757 | 4757 | George Crawford C000890 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4796 | 4796 | Thomas Foster F000314 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4800 | 4800 | Roger Gamble G000033 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4813 | 4813 | Richard Habersham H000003 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4814 | 4814 | Richard Habersham H000003 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4901 | 4901 | James Meriwether M000652 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4922 | 4922 | Eugenius Nisbet N000111 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4923 | 4923 | Eugenius Nisbet N000111 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
5054 | 5054 | Lott Warren W000167 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5055 | 5055 | Lott Warren W000167 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
5134 | 5134 | Edward Black B000494 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5164 | 5164 | Absalom Chappell C000319 | rep | GA | 1843-12-04 | 1845-03-03 | Whig | -1 | |||||||||||||
5166 | 5166 | Duncan Clinch C000520 | rep | GA | 1843-12-04 | 1845-03-03 | Whig | -1 | |||||||||||||
5174 | 5174 | Walter Colquitt C000648 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5177 | 5177 | Mark Cooper C000759 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5615 | 5615 | John Berrien B000413 | sen | GA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5616 | 5616 | John Berrien B000413 | sen | GA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5750 | 5750 | John Jones J000239 | rep | GA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5952 | 5952 | William Dawson D000156 | rep | GA | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
5953 | 5953 | William Dawson D000156 | rep | GA | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
5954 | 5954 | William Dawson D000156 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5955 | 5955 | William Dawson D000156 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
5956 | 5956 | William Dawson D000156 | sen | GA | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6032 | 6032 | Thomas King K000215 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
6033 | 6033 | Thomas King K000215 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -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);