legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
281 rows where "end" is on date 1839-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4255 | 4255 | Joab Lawler L000129 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4269 | 4269 | Francis Lyon L000542 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
4271 | 4271 | Joshua Martin M000192 | rep | AL | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4436 | 4436 | George Crabb C000847 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
5380 | 5380 | Reuben Chapman C000316 | rep | AL | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
5759 | 5759 | Dixon Lewis L000278 | rep | AL | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
5582 | 5582 | Archibald Yell Y000017 | rep | AR | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4220 | 4220 | Elisha Haley H000040 | rep | CT | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4237 | 4237 | Orrin Holt H000748 | rep | CT | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4246 | 4246 | Samuel Ingham I000021 | rep | CT | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4318 | 4318 | Lancelot Phelps P000297 | rep | CT | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4384 | 4384 | Thomas Whittlesey W000433 | rep | CT | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
5256 | 5256 | John Niles N000108 | sen | CT | 1835-12-07 | 1839-03-03 | 1 | Democrat | |||||||||||||
6477 | 6477 | Isaac Toucey T000319 | rep | CT | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4289 | 4289 | John Milligan M000767 | rep | DE | 1837-09-04 | 1839-03-03 | Whig | 0 | |||||||||||||
4692 | 4692 | Richard Bayard B000251 | sen | DE | 1836-06-17 | 1839-03-03 | 1 | Whig | |||||||||||||
4463 | 4463 | Charles Downing D000472 | rep | FL | 1837-09-04 | 1839-03-03 | -1 | ||||||||||||||
4177 | 4177 | Jesse Cleveland C000513 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4208 | 4208 | Thomas Glascock G000230 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4212 | 4212 | Seaton Grantland G000385 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4231 | 4231 | Charles Haynes H000399 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4235 | 4235 | Hopkins Holsey H000744 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4248 | 4248 | Jabez Jackson J000015 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4307 | 4307 | George Owens O000157 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
5547 | 5547 | George Towns T000327 | rep | GA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
5953 | 5953 | William Dawson D000156 | rep | GA | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
4422 | 4422 | William Chapman C000318 | rep | IA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4276 | 4276 | William May M000277 | rep | IL | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4353 | 4353 | Adam Snyder S000664 | rep | IL | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4732 | 4732 | Zadok Casey C000230 | rep | IL | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
3589 | 3589 | John Tipton T000284 | sen | IN | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4139 | 4139 | Ratliff Boon B000628 | rep | IN | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4196 | 4196 | George Dunn D000547 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
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 | |||||||||||||
4233 | 4233 | William Herod H000536 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
4582 | 4582 | James Rariden R000066 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
7879 | 7879 | Albert White W000351 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
4151 | 4151 | John Calhoon C000043 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
4164 | 4164 | John Chambers C000285 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 12 | |||||||||||||
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 | |||||||||||||
4302 | 4302 | John Murray M001110 | rep | KY | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
4484 | 4484 | William Graves G000392 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 8 | |||||||||||||
4503 | 4503 | Richard Hawes H000363 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 10 | |||||||||||||
4641 | 4641 | Sherrod Williams W000536 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4941 | 4941 | John Pope P000431 | rep | KY | 1837-09-04 | 1839-03-03 | Independent | 7 | |||||||||||||
5317 | 5317 | John White W000380 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 9 | |||||||||||||
5849 | 5849 | Joseph Underwood U000011 | rep | KY | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4481 | 4481 | Rice Garland G000070 | rep | LA | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4597 | 4597 | Eleazar Ripley R000265 | rep | LA | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
5346 | 5346 | Henry Johnson J000137 | rep | LA | 1837-09-04 | 1839-03-03 | Whig | 1 | |||||||||||||
4201 | 4201 | Richard Fletcher F000203 | rep | MA | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4218 | 4218 | George Grennell G000451 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
4321 | 4321 | Stephen Phillips P000312 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
4594 | 4594 | John Reed R000121 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
4702 | 4702 | Nathaniel Borden B000636 | rep | MA | 1837-09-04 | 1839-03-03 | Democrat | 10 | |||||||||||||
4710 | 4710 | George Briggs B000830 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
4724 | 4724 | William Calhoun C000046 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 8 | |||||||||||||
4759 | 4759 | Caleb Cushing C001016 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4826 | 4826 | William Hastings H000332 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 9 | |||||||||||||
4860 | 4860 | Levi Lincoln L000315 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
4985 | 4985 | Leverett Saltonstall S000020 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
5258 | 5258 | William Parmenter P000076 | rep | MA | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
5569 | 5569 | Daniel Webster W000238 | sen | MA | 1833-12-02 | 1839-03-03 | 1 | Whig | |||||||||||||
5595 | 5595 | John Adams A000041 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 12 | |||||||||||||
4241 | 4241 | Benjamin Howard H000835 | rep | MD | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
4281 | 4281 | Isaac McKim M000516 | rep | MD | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
4387 | 4387 | William Merrick M000654 | sen | MD | 1838-01-04 | 1839-03-03 | 1 | Whig | |||||||||||||
4456 | 4456 | John Dennis D000244 | rep | MD | 1837-09-04 | 1839-03-03 | Whig | 1 | |||||||||||||
4523 | 4523 | Daniel Jenifer J000078 | rep | MD | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
4644 | 4644 | John Worthington W000748 | rep | MD | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4844 | 4844 | William Johnson J000180 | rep | MD | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
5238 | 5238 | John Kennedy K000109 | rep | MD | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
7821 | 7821 | James Pearce P000161 | rep | MD | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
8463 | 8463 | Francis Thomas T000166 | rep | MD | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4161 | 4161 | Timothy Carter C000202 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4169 | 4169 | Jonathan Cilley C000395 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4305 | 4305 | Joseph Noyes N000165 | rep | ME | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
4339 | 4339 | Edward Robinson R000334 | rep | ME | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4349 | 4349 | Francis Smith S000531 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4395 | 4395 | Hugh Anderson A000190 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4450 | 4450 | Thomas Davee D000068 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 8 | |||||||||||||
4569 | 4569 | Virgil Parris P000081 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4638 | 4638 | Reuel Williams W000532 | sen | ME | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
4777 | 4777 | George Evans E000241 | rep | ME | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
5421 | 5421 | John Fairfield F000006 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4444 | 4444 | Isaac Crary C000882 | rep | MI | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
5248 | 5248 | Lucius Lyon L000544 | sen | MI | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
4501 | 4501 | Albert Harrison H000261 | rep | MO | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4902 | 4902 | John Miller M000735 | rep | MO | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
6514 | 6514 | Thomas Benton B000398 | sen | MO | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4171 | 4171 | John Claiborne C000404 | rep | MS | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4206 | 4206 | Samuel Gholson G000149 | rep | MS | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4328 | 4328 | Seargent Prentiss P000511 | rep | MS | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
4385 | 4385 | Thomas Word W000742 | rep | MS | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
4389 | 4389 | James Trotter T000380 | sen | MS | 1838-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
4390 | 4390 | Thomas Williams W000539 | sen | MS | 1838-01-01 | 1839-03-03 | 1 | Democrat |
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);