legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
263 rows where "start" is on date 1847-12-06
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5808 | 5808 | William Preston P000518 | rep | VA | 1847-12-06 | 1849-03-03 | Whig | 12 | |||||||||||||
5809 | 5809 | William Rockhill R000364 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
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 | |||||||||||||
5814 | 5814 | William Sawyer S000095 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
5815 | 5815 | Eliakim Sherrill S000351 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
5818 | 5818 | Richard Simpson S000435 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5820 | 5820 | Alexander Sims S000438 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
5825 | 5825 | Presley Spruance S000760 | sen | DE | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5826 | 5826 | Daniel St. John S000766 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
5827 | 5827 | George Starkweather S000814 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 21 | |||||||||||||
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 | |||||||||||||
5844 | 5844 | Robert Thompson T000215 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 14 | |||||||||||||
5845 | 5845 | Patrick Tompkins T000308 | rep | MS | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5846 | 5846 | Thomas Turner T000429 | rep | IL | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
5847 | 5847 | John Tweedy T000441 | rep | WI | 1847-12-06 | 1849-03-03 | Whig | -1 | |||||||||||||
5852 | 5852 | Joseph Underwood U000011 | sen | KY | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5853 | 5853 | Cornelius Warren W000162 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5856 | 5856 | William Wick W000436 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
5857 | 5857 | James Wiley W000467 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
5859 | 5859 | Hezekiah Williams W000504 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
5895 | 5895 | George Ashmun A000318 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5906 | 5906 | Franklin Bowdon B000680 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
5910 | 5910 | James Bowlin B000701 | rep | MO | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
5966 | 5966 | Rodolphus Dickinson D000325 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
5974 | 5974 | Winfield Featherston F000055 | rep | MS | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
5994 | 5994 | Hugh Haralson H000178 | rep | GA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5997 | 5997 | John Harmanson H000214 | rep | LA | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
6011 | 6011 | Isaac Holmes H000738 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
6014 | 6014 | John Houston H000825 | rep | DE | 1847-12-06 | 1849-03-03 | Whig | 0 | |||||||||||||
6018 | 6018 | Samuel Inge I000013 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6023 | 6023 | David Kaufman K000021 | rep | TX | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
6038 | 6038 | Emile La Sére L000008 | rep | LA | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6041 | 6041 | Shepherd Leffler L000215 | rep | IA | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6044 | 6044 | Lewis Levin L000262 | rep | PA | 1847-12-06 | 1849-03-03 | American | 1 | |||||||||||||
6049 | 6049 | Job Mann M000106 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 19 | |||||||||||||
6053 | 6053 | George Marsh M000147 | rep | VT | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
6056 | 6056 | James McDowell M000419 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 11 | |||||||||||||
6064 | 6064 | John Miller M000742 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 11 | |||||||||||||
6066 | 6066 | Charles Morehead M000936 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
6068 | 6068 | Jonathan Morris M000979 | rep | OH | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
6072 | 6072 | Isaac Morse M001011 | rep | LA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
6089 | 6089 | Lucius Peck P000178 | rep | VT | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
6130 | 6130 | Pierre Soulé S000682 | sen | LA | 1847-12-06 | 1847-12-31 | 2 | Democrat | |||||||||||||
6135 | 6135 | William Strong S001021 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 9 | |||||||||||||
6141 | 6141 | Jacob Thompson T000203 | rep | MS | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6144 | 6144 | James Thompson T000204 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 23 | |||||||||||||
6146 | 6146 | William Thompson T000223 | rep | IA | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
6175 | 6175 | James Wilson W000587 | rep | NH | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
6196 | 6196 | Robert Rhett R000184 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
6202 | 6202 | Robert Winthrop W000646 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6230 | 6230 | Richard Brodhead B000861 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
6238 | 6238 | Armistead Burt B001145 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
6243 | 6243 | Edward Cabell C000003 | rep | FL | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
6267 | 6267 | John Daniel D000034 | rep | NC | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
6286 | 6286 | Alexander Evans E000231 | rep | MD | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
6292 | 6292 | Orlando Ficklin F000101 | rep | IL | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
6306 | 6306 | Meredith Gentry G000125 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
6315 | 6315 | Willard Hall H000077 | rep | MO | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6344 | 6344 | Timothy Jenkins J000089 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 20 | |||||||||||||
6354 | 6354 | Horace Mann M000102 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
6362 | 6362 | Richard Meade M000618 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6377 | 6377 | David Outlaw O000138 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
6381 | 6381 | Charles Peaslee P000173 | rep | NH | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6394 | 6394 | John Robinson R000343 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
6414 | 6414 | Henry Sibley S000396 | rep | WI | 1847-12-06 | 1849-03-03 | -1 | ||||||||||||||
6417 | 6417 | Ephraim Smart S000503 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
6437 | 6437 | Amos Tuck T000394 | rep | NH | 1847-12-06 | 1849-03-03 | Independent | 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);