legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
93 rows where party = "Whig" and state = "KY"
This data as json, copyable, CSV (advanced)
Suggested facets: start, end, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3831 | 3831 | Chilton Allan A000108 | rep | KY | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
3832 | 3832 | Chilton Allan A000108 | rep | KY | 1833-12-02 | 1835-03-03 | Whig | 10 | |||||||||||||
3833 | 3833 | Chilton Allan A000108 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
3922 | 3922 | Benjamin Hardin H000184 | rep | KY | 1833-12-02 | 1835-03-03 | Whig | 7 | |||||||||||||
3923 | 3923 | Benjamin Hardin H000184 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
4150 | 4150 | John Calhoon C000043 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4151 | 4151 | John Calhoon C000043 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
4163 | 4163 | John Chambers C000285 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 12 | |||||||||||||
4164 | 4164 | John Chambers C000285 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 12 | |||||||||||||
4224 | 4224 | James Harlan H000210 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 5 | |||||||||||||
4225 | 4225 | James Harlan H000210 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
4285 | 4285 | Richard Menefee M000638 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
4340 | 4340 | Edward Rumsey R000507 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
4354 | 4354 | William Southgate S000690 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 13 | |||||||||||||
4397 | 4397 | Simeon Anderson A000232 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4483 | 4483 | William Graves G000392 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 8 | |||||||||||||
4484 | 4484 | William Graves G000392 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 8 | |||||||||||||
4485 | 4485 | William Graves G000392 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
4503 | 4503 | Richard Hawes H000363 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 10 | |||||||||||||
4504 | 4504 | Richard Hawes H000363 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
4640 | 4640 | Sherrod Williams W000536 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
4641 | 4641 | Sherrod Williams W000536 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4642 | 4642 | Sherrod Williams W000536 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
4662 | 4662 | Landaff Andrews A000247 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4663 | 4663 | Landaff Andrews A000247 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 11 | |||||||||||||
4872 | 4872 | Thomas Marshall M000162 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
4906 | 4906 | James Morehead M000938 | sen | KY | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
4930 | 4930 | Bryan Owsley O000162 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4942 | 4942 | John Pope P000431 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4943 | 4943 | John Pope P000431 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
5011 | 5011 | James Sprigg S000750 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 8 | |||||||||||||
5037 | 5037 | Philip Triplett T000378 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5038 | 5038 | Philip Triplett T000378 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5207 | 5207 | Willis Green G000423 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5208 | 5208 | Willis Green G000423 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
5209 | 5209 | Willis Green G000423 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5316 | 5316 | John White W000380 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 9 | |||||||||||||
5317 | 5317 | John White W000380 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 9 | |||||||||||||
5318 | 5318 | John White W000380 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
5319 | 5319 | John White W000380 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 9 | |||||||||||||
5320 | 5320 | John White W000380 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
5358 | 5358 | Joshua Bell B000343 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
5481 | 5481 | John McHenry M000471 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5540 | 5540 | William Thomasson T000190 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
5541 | 5541 | William Thomasson T000190 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5550 | 5550 | Andrew Trumbo T000388 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 9 | |||||||||||||
5586 | 5586 | Bryan Young Y000030 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 5 | |||||||||||||
5632 | 5632 | Aylette Buckner B001032 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5682 | 5682 | William Duncan D000527 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
5701 | 5701 | John Gaines G000006 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
5848 | 5848 | Joseph Underwood U000011 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
5849 | 5849 | Joseph Underwood U000011 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
5850 | 5850 | Joseph Underwood U000011 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5851 | 5851 | Joseph Underwood U000011 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
5852 | 5852 | Joseph Underwood U000011 | sen | KY | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5882 | 5882 | Thomas Metcalfe M000676 | rep | KY | 1823-12-01 | 1825-03-03 | Whig | 2 | |||||||||||||
5885 | 5885 | Thomas Metcalfe M000676 | sen | KY | 1848-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5912 | 5912 | Daniel Breck B000782 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
5937 | 5937 | Henry Clay C000482 | sen | KY | 1831-12-05 | 1837-03-03 | 3 | Whig | |||||||||||||
5938 | 5938 | Henry Clay C000482 | sen | KY | 1837-09-04 | 1843-03-03 | 3 | Whig | |||||||||||||
5939 | 5939 | Henry Clay C000482 | sen | KY | 1849-12-03 | 1853-03-03 | 3 | Whig | |||||||||||||
6021 | 6021 | James Johnson J000147 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6061 | 6061 | Finis McLean M000546 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6066 | 6066 | Charles Morehead M000936 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
6067 | 6067 | Charles Morehead M000936 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
6448 | 6448 | William Ward W000145 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6452 | 6452 | Addison White W000350 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
6474 | 6474 | Archibald Dixon D000367 | sen | KY | 1852-01-01 | 1855-03-03 | 3 | Whig | |||||||||||||
6589 | 6589 | Presley Ewing E000279 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6590 | 6590 | Presley Ewing E000279 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
6600 | 6600 | Benjamin Grey G000453 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6601 | 6601 | Benjamin Grey G000453 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6612 | 6612 | Clement Hill H000589 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
6677 | 6677 | William Preston P000517 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6678 | 6678 | William Preston P000517 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 7 | |||||||||||||
6720 | 6720 | John Thompson T000208 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
6721 | 6721 | John Thompson T000208 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 5 | |||||||||||||
6722 | 6722 | John Thompson T000208 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
6723 | 6723 | John Thompson T000208 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
6793 | 6793 | Leander Cox C000837 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 9 | |||||||||||||
7141 | 7141 | Humphrey Marshall M000154 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
7142 | 7142 | Humphrey Marshall M000154 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
7272 | 7272 | Green Adams A000036 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
7320 | 7320 | Francis Bristow B000842 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
7723 | 7723 | John Crittenden C000912 | sen | KY | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
7724 | 7724 | John Crittenden C000912 | sen | KY | 1842-03-31 | 1843-03-03 | 3 | Whig | |||||||||||||
7725 | 7725 | John Crittenden C000912 | sen | KY | 1843-12-04 | 1848-06-12 | 3 | Whig | |||||||||||||
8122 | 8122 | Henry Grider G000455 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
8123 | 8123 | Henry Grider G000455 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
8299 | 8299 | Garrett Davis D000099 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
8300 | 8300 | Garrett Davis D000099 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
8301 | 8301 | Garrett Davis D000099 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
8302 | 8302 | Garrett Davis D000099 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 8 |
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);