legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
75 rows where party = "Whig" and "start" is on date 1835-12-07
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, end, class, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3833 | 3833 | Chilton Allan A000108 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
3840 | 3840 | Jeremiah Bailey B000040 | rep | ME | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
3867 | 3867 | William Chetwood C000349 | rep | NJ | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
3883 | 3883 | Joseph Crane C000872 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
3906 | 3906 | Philo Fuller F000411 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 30 | |||||||||||||
3912 | 3912 | Robert Goldsborough G000264 | sen | MD | 1835-12-07 | 1837-03-03 | 3 | Whig | |||||||||||||
3918 | 3918 | Gideon Hard H000180 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 33 | |||||||||||||
3923 | 3923 | Benjamin Hardin H000184 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
3925 | 3925 | James Harper H000221 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
3932 | 3932 | Abner Hazeltine H000416 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 31 | |||||||||||||
3938 | 3938 | Samuel Hoar H000656 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
3939 | 3939 | Elias Howell H000861 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 12 | |||||||||||||
3980 | 3980 | Nehemiah Knight K000287 | sen | RI | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
3989 | 3989 | George Lay L000150 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 29 | |||||||||||||
3996 | 3996 | Thomas Love L000459 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 32 | |||||||||||||
4016 | 4016 | William McComas M000352 | rep | VA | 1835-12-07 | 1837-03-03 | Whig | 19 | |||||||||||||
4036 | 4036 | John Pearson P000167 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 24 | |||||||||||||
4037 | 4037 | Ebenezer Pettigrew P000270 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
4061 | 4061 | William Shepard S000331 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4068 | 4068 | David Spangler S000699 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 13 | |||||||||||||
4071 | 4071 | Bellamy Storer S000971 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4105 | 4105 | Hugh White W000376 | sen | TN | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4128 | 4128 | Heman Allen A000123 | rep | VT | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
4150 | 4150 | John Calhoon C000043 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4163 | 4163 | John Chambers C000285 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 12 | |||||||||||||
4217 | 4217 | George Grennell G000451 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4224 | 4224 | James Harlan H000210 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 5 | |||||||||||||
4232 | 4232 | William Herod H000536 | rep | IN | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4268 | 4268 | Francis Lyon L000542 | rep | AL | 1835-12-07 | 1837-03-03 | Whig | 5 | |||||||||||||
4272 | 4272 | Abram Maury M000262 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 8 | |||||||||||||
4288 | 4288 | John Milligan M000767 | rep | DE | 1835-12-07 | 1837-03-03 | Whig | 0 | |||||||||||||
4294 | 4294 | Mathias Morris M000984 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4320 | 4320 | Stephen Phillips P000312 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
4337 | 4337 | John Robertson R000323 | rep | VA | 1835-12-07 | 1837-03-03 | Whig | 11 | |||||||||||||
4344 | 4344 | Ebenezer Shields S000360 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
4360 | 4360 | James Standifer S000789 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
4381 | 4381 | Elisha Whittlesey W000431 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 16 | |||||||||||||
4405 | 4405 | William Bond B000613 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
4419 | 4419 | William Carter C000204 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4483 | 4483 | William Graves G000392 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 8 | |||||||||||||
4522 | 4522 | Daniel Jenifer J000078 | rep | MD | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
4532 | 4532 | Abbott Lawrence L000130 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4555 | 4555 | Charles Mercer M000642 | rep | VA | 1835-12-07 | 1837-03-03 | Whig | 14 | |||||||||||||
4603 | 4603 | David Russell R000524 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 12 | |||||||||||||
4640 | 4640 | Sherrod Williams W000536 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
4658 | 4658 | Julius Alford A000104 | rep | GA | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
4709 | 4709 | George Briggs B000830 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
4723 | 4723 | William Calhoun C000046 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 8 | |||||||||||||
4736 | 4736 | Timothy Childs C000355 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 28 | |||||||||||||
4758 | 4758 | Caleb Cushing C001016 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
4776 | 4776 | George Evans E000241 | rep | ME | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
4783 | 4783 | Horace Everett E000265 | rep | VT | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
4808 | 4808 | Francis Granger G000376 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 26 | |||||||||||||
4817 | 4817 | Hiland Hall H000052 | rep | VT | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4836 | 4836 | Hiram Hunt H000970 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 9 | |||||||||||||
4859 | 4859 | Levi Lincoln L000315 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 5 | |||||||||||||
4874 | 4874 | Samson Mason M000225 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
4958 | 4958 | Abraham Rencher R000162 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
5026 | 5026 | John Taliaferro T000027 | rep | VA | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
5080 | 5080 | Lewis Williams W000527 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 13 | |||||||||||||
5093 | 5093 | John Young Y000042 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 30 | |||||||||||||
5316 | 5316 | John White W000380 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 9 | |||||||||||||
5345 | 5345 | Henry Johnson J000137 | rep | LA | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
5429 | 5429 | James Graham G000355 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 12 | |||||||||||||
5668 | 5668 | John Davis D000117 | sen | MA | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
5738 | 5738 | Joseph Ingersoll I000019 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
5848 | 5848 | Joseph Underwood U000011 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
5952 | 5952 | William Dawson D000156 | rep | GA | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
5959 | 5959 | Edmund Deberry D000181 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
6118 | 6118 | Augustine Shepperd S000338 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 9 | |||||||||||||
6161 | 6161 | Samuel Vinton V000107 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
6507 | 6507 | John Bell B000340 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
7712 | 7712 | Thomas Corwin C000791 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
7723 | 7723 | John Crittenden C000912 | sen | KY | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
7820 | 7820 | James Pearce P000161 | rep | MD | 1835-12-07 | 1837-03-03 | Whig | 2 |
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);