legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,108 rows where party = "Whig" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2507 | 2507 | Albert Tracy T000343 | rep | NY | 1823-12-01 | 1825-03-03 | Whig | 30 | |||||||||||||
3805 | 3805 | Benjamin Swift S001116 | rep | VT | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
3880 | 3880 | Joseph Crane C000872 | rep | OH | 1829-12-07 | 1831-03-03 | Whig | 3 | |||||||||||||
3881 | 3881 | Joseph Crane C000872 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
3882 | 3882 | Joseph Crane C000872 | rep | OH | 1833-12-02 | 1835-03-03 | Whig | 3 | |||||||||||||
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 | |||||||||||||
3918 | 3918 | Gideon Hard H000180 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 33 | |||||||||||||
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 | |||||||||||||
3924 | 3924 | James Harper H000221 | rep | PA | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
4058 | 4058 | William Shepard S000331 | rep | NC | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
4059 | 4059 | William Shepard S000331 | rep | NC | 1831-12-05 | 1833-03-03 | Whig | 1 | |||||||||||||
4060 | 4060 | William Shepard S000331 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 1 | |||||||||||||
4061 | 4061 | William Shepard S000331 | rep | NC | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4067 | 4067 | David Spangler S000699 | rep | OH | 1833-12-02 | 1835-03-03 | Whig | 13 | |||||||||||||
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 | |||||||||||||
4125 | 4125 | James Alexander A000095 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
4126 | 4126 | Heman Allen A000123 | rep | VT | 1831-12-05 | 1833-03-03 | Whig | 4 | |||||||||||||
4127 | 4127 | Heman Allen A000123 | rep | VT | 1833-12-02 | 1835-03-03 | Whig | 4 | |||||||||||||
4128 | 4128 | Heman Allen A000123 | rep | VT | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
4129 | 4129 | Heman Allen A000123 | rep | VT | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
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 | |||||||||||||
4168 | 4168 | Richard Cheatham C000341 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
4180 | 4180 | Charles Coffin C000587 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 17 | |||||||||||||
4196 | 4196 | George Dunn D000547 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4198 | 4198 | John Ewing E000277 | rep | IN | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4199 | 4199 | John Ewing E000277 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
4209 | 4209 | William Graham G000361 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4214 | 4214 | George Grennell G000451 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 7 | |||||||||||||
4215 | 4215 | George Grennell G000451 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 7 | |||||||||||||
4216 | 4216 | George Grennell G000451 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 6 | |||||||||||||
4217 | 4217 | George Grennell G000451 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4218 | 4218 | George Grennell G000451 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
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 | |||||||||||||
4232 | 4232 | William Herod H000536 | rep | IN | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4233 | 4233 | William Herod H000536 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
4255 | 4255 | Joab Lawler L000129 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4261 | 4261 | Andrew Loomis L000436 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 17 | |||||||||||||
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 | |||||||||||||
4272 | 4272 | Abram Maury M000262 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 8 | |||||||||||||
4273 | 4273 | Abram Maury M000262 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 8 | |||||||||||||
4285 | 4285 | Richard Menefee M000638 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
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 | |||||||||||||
4294 | 4294 | Mathias Morris M000984 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4295 | 4295 | Mathias Morris M000984 | rep | PA | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
4305 | 4305 | Joseph Noyes N000165 | rep | ME | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
4311 | 4311 | William Patterson P000133 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 29 | |||||||||||||
4319 | 4319 | Stephen Phillips P000312 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4320 | 4320 | Stephen Phillips P000312 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
4321 | 4321 | Stephen Phillips P000312 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
4328 | 4328 | Seargent Prentiss P000511 | rep | MS | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
4336 | 4336 | John Robertson R000323 | rep | VA | 1833-12-02 | 1835-03-03 | Whig | 11 | |||||||||||||
4337 | 4337 | John Robertson R000323 | rep | VA | 1835-12-07 | 1837-03-03 | Whig | 11 | |||||||||||||
4338 | 4338 | John Robertson R000323 | rep | VA | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
4339 | 4339 | Edward Robinson R000334 | rep | ME | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4340 | 4340 | Edward Rumsey R000507 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
4341 | 4341 | Samuel Sawyer S000093 | rep | NC | 1837-09-04 | 1839-03-03 | Whig | 1 | |||||||||||||
4344 | 4344 | Ebenezer Shields S000360 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
4345 | 4345 | Ebenezer Shields S000360 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 10 | |||||||||||||
4346 | 4346 | Mark Sibley S000399 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 26 | |||||||||||||
4354 | 4354 | William Southgate S000690 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 13 | |||||||||||||
4360 | 4360 | James Standifer S000789 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
4361 | 4361 | James Standifer S000789 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4362 | 4362 | William Stone S000965 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4375 | 4375 | Elisha Whittlesey W000431 | rep | OH | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
4378 | 4378 | Elisha Whittlesey W000431 | rep | OH | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
4379 | 4379 | Elisha Whittlesey W000431 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 13 | |||||||||||||
4381 | 4381 | Elisha Whittlesey W000431 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 16 | |||||||||||||
4382 | 4382 | Elisha Whittlesey W000431 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 16 | |||||||||||||
4385 | 4385 | Thomas Word W000742 | rep | MS | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
4391 | 4391 | John Allen A000135 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 15 | |||||||||||||
4392 | 4392 | John Allen A000135 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 15 | |||||||||||||
4394 | 4394 | James Alvord A000168 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4397 | 4397 | Simeon Anderson A000232 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4405 | 4405 | William Bond B000613 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
4406 | 4406 | William Bond B000613 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 7 |
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);