legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
125 rows where "end" is on date 1849-03-03 and party = "Whig"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5347 | 5347 | Henry Johnson J000137 | sen | LA | 1844-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5590 | 5590 | Amos Abbott A000004 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5600 | 5600 | John Adams A000041 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5609 | 5609 | Daniel Barringer B000182 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5610 | 5610 | Washington Barrow B000185 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5613 | 5613 | Hiram Belcher B000321 | rep | ME | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5621 | 5621 | Esbon Blackmar B000513 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 27 | |||||||||||||
5623 | 5623 | John Blanchard B000539 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 17 | |||||||||||||
5626 | 5626 | John Botts B000655 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5629 | 5629 | Jasper Brady B000754 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 16 | |||||||||||||
5632 | 5632 | Aylette Buckner B001032 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5642 | 5642 | Richard Canby C000108 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5644 | 5644 | John Chapman C000314 | rep | MD | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5652 | 5652 | William Cocke C000573 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5657 | 5657 | Robert Cranston C000879 | rep | RI | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5659 | 5659 | John Crozier C000951 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5672 | 5672 | John Dickey D000314 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 20 | |||||||||||||
5673 | 5673 | Richard Donnell D000415 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5681 | 5681 | Daniel Duncan D000529 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
5682 | 5682 | William Duncan D000527 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
5683 | 5683 | George Eckert E000034 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 14 | |||||||||||||
5686 | 5686 | Thomas Edwards E000082 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
5687 | 5687 | Elisha Embree E000169 | rep | IN | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5690 | 5690 | John Farrelly F000031 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 22 | |||||||||||||
5692 | 5692 | David Fisher F000145 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5693 | 5693 | Thomas Flournoy F000216 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5700 | 5700 | Andrew Fulton F000419 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 13 | |||||||||||||
5701 | 5701 | John Gaines G000006 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
5702 | 5702 | John Gayle G000106 | rep | AL | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5706 | 5706 | William Goggin G000256 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5707 | 5707 | Horace Greeley G000405 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5708 | 5708 | Dudley Gregory G000446 | rep | NJ | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5710 | 5710 | Artemas Hale H000028 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
5711 | 5711 | Nathan Hall H000062 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 32 | |||||||||||||
5714 | 5714 | James Hampton H000138 | rep | NJ | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5715 | 5715 | William Haskell H000320 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 11 | |||||||||||||
5720 | 5720 | John Holley H000723 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 27 | |||||||||||||
5722 | 5722 | Elias Holmes H000736 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 28 | |||||||||||||
5723 | 5723 | John Hornbeck H000790 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5725 | 5725 | Samuel Hubbard H000889 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5729 | 5729 | Charles Hudson H000907 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5732 | 5732 | Washington Hunt H000978 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 34 | |||||||||||||
5742 | 5742 | Joseph Ingersoll I000019 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5743 | 5743 | Alexander Irvin I000032 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 24 | |||||||||||||
5750 | 5750 | John Jones J000239 | rep | GA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5754 | 5754 | William Lawrence L000142 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 26 | |||||||||||||
5777 | 5777 | Dudley Marvin M000208 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 31 | |||||||||||||
5783 | 5783 | Abraham McIlvaine M000474 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
5795 | 5795 | Joseph Mullin M001072 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 19 | |||||||||||||
5799 | 5799 | John Palfrey P000033 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5801 | 5801 | John Pendleton P000206 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
5807 | 5807 | James Pollock P000416 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 13 | |||||||||||||
5808 | 5808 | William Preston P000518 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 12 | |||||||||||||
5811 | 5811 | John Rockwell R000367 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5812 | 5812 | James Roman R000414 | rep | MD | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5815 | 5815 | Eliakim Sherrill S000351 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
5821 | 5821 | John Slingerland S000488 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 13 | |||||||||||||
5824 | 5824 | Caleb Smith S000519 | rep | IN | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5826 | 5826 | Daniel St. John S000766 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
5836 | 5836 | Andrew Stewart S000899 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 18 | |||||||||||||
5838 | 5838 | John Strohm S001008 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5839 | 5839 | Frederick Tallmadge T000030 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5841 | 5841 | Bannon Thibodeaux T000152 | rep | LA | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5843 | 5843 | Richard Thompson T000214 | rep | IN | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
5845 | 5845 | Patrick Tompkins T000308 | rep | MS | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5847 | 5847 | John Tweedy T000441 | rep | WI | 1847-12-06 | 1849-03-03 | Whig | -1 | |||||||||||||
5853 | 5853 | Cornelius Warren W000162 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5885 | 5885 | Thomas Metcalfe M000676 | sen | KY | 1848-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5895 | 5895 | George Ashmun A000318 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5899 | 5899 | George Badger B000022 | sen | NC | 1846-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5920 | 5920 | Chester Butler B001175 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 11 | |||||||||||||
5942 | 5942 | Harmon Conger C000676 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 25 | |||||||||||||
5949 | 5949 | John Crowell C000941 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 19 | |||||||||||||
5968 | 5968 | William Duer D000515 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 23 | |||||||||||||
5971 | 5971 | Nathan Evans E000255 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 14 | |||||||||||||
5976 | 5976 | John Freedley F000360 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5981 | 5981 | Daniel Gott G000339 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 24 | |||||||||||||
5986 | 5986 | Joseph Grinnell G000477 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
5990 | 5990 | Moses Hampton H000139 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 21 | |||||||||||||
6001 | 6001 | William Henry H000520 | rep | VT | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6004 | 6004 | Henry Hilliard H000622 | rep | AL | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
6014 | 6014 | John Houston H000825 | rep | DE | 1847-12-06 | 1849-03-03 | Whig | 0 | |||||||||||||
6028 | 6028 | Daniel King K000198 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
6035 | 6035 | Thomas King K000215 | rep | GA | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6053 | 6053 | George Marsh M000147 | rep | VT | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
6066 | 6066 | Charles Morehead M000936 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
6076 | 6076 | William Nelson N000045 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
6079 | 6079 | Henry Nes N000047 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 15 | |||||||||||||
6097 | 6097 | Harvey Putnam P000580 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 33 | |||||||||||||
6100 | 6100 | Gideon Reynolds R000172 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 12 | |||||||||||||
6104 | 6104 | Joseph Root R000433 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 21 | |||||||||||||
6106 | 6106 | Robert Rose R000438 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 29 | |||||||||||||
6108 | 6108 | David Rumsey R000506 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 30 | |||||||||||||
6121 | 6121 | Augustine Shepperd S000338 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6123 | 6123 | Peter Silvester S000413 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 11 | |||||||||||||
6128 | 6128 | Truman Smith S000621 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6151 | 6151 | William Upham U000025 | sen | VT | 1843-12-04 | 1849-03-03 | 3 | Whig | |||||||||||||
6153 | 6153 | John Van Dyke V000035 | rep | NJ | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6164 | 6164 | Samuel Vinton V000107 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 12 | |||||||||||||
6172 | 6172 | Hugh White W000375 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 16 |
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);