legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
275 rows where "start" is on date 1839-12-02
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4388 | 4388 | William Merrick M000654 | sen | MD | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
4392 | 4392 | John Allen A000135 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 15 | |||||||||||||
4393 | 4393 | Judson Allen A000137 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 20 | |||||||||||||
4394 | 4394 | James Alvord A000168 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4396 | 4396 | Hugh Anderson A000190 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4397 | 4397 | Simeon Anderson A000232 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4399 | 4399 | William Beatty B000284 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4401 | 4401 | Andrew Beirne B000319 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
4404 | 4404 | Richard Biddle B000443 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 22 | |||||||||||||
4407 | 4407 | William Bond B000613 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4408 | 4408 | Henry Brackenridge B000732 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 22 | |||||||||||||
4409 | 4409 | Anson Brown B000901 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4413 | 4413 | Jesse Bynum B001204 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4417 | 4417 | John Carr C000177 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
4418 | 4418 | James Carroll C000188 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4421 | 4421 | William Carter C000204 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4423 | 4423 | William Chapman C000318 | rep | IA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4424 | 4424 | Thomas Chinn C000363 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4434 | 4434 | Henry Connor C000700 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 11 | |||||||||||||
4435 | 4435 | William Cooper C000766 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4437 | 4437 | George Crabb C000847 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4442 | 4442 | Robert Craig C000859 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4445 | 4445 | Isaac Crary C000882 | rep | MI | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4447 | 4447 | John Crockett C000920 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
4449 | 4449 | Edward Curtis C001009 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4451 | 4451 | Thomas Davee D000068 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4453 | 4453 | Edward Davies D000088 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 4 | |||||||||||||
4454 | 4454 | John Davis D000116 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4455 | 4455 | James De La Montanya D000205 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4457 | 4457 | John Dennis D000244 | rep | MD | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4460 | 4460 | Philemon Dickerson D000309 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4461 | 4461 | Nathan Dixon D000376 | sen | RI | 1839-12-02 | 1843-03-03 | 1 | Whig | |||||||||||||
4462 | 4462 | Nicholas Doe D000398 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4464 | 4464 | Charles Downing D000472 | rep | FL | 1839-12-02 | 1841-03-03 | -1 | ||||||||||||||
4465 | 4465 | Nehemiah Earll E000012 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4466 | 4466 | John Ely E000166 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4467 | 4467 | John Fine F000125 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
4470 | 4470 | Charles Fisher F000144 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 10 | |||||||||||||
4472 | 4472 | Isaac Fletcher F000201 | rep | VT | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4475 | 4475 | John Galbraith G000011 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 25 | |||||||||||||
4478 | 4478 | James Garland G000067 | rep | VA | 1839-12-02 | 1841-03-03 | Conservative | 12 | |||||||||||||
4482 | 4482 | Rice Garland G000070 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4485 | 4485 | William Graves G000392 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
4490 | 4490 | John Griffin G000462 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
4491 | 4491 | Moses Grinnell G000479 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4496 | 4496 | Felix Grundy G000509 | sen | TN | 1839-12-02 | 1841-03-03 | 1 | Democrat | |||||||||||||
4498 | 4498 | Robert Hammond H000132 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 16 | |||||||||||||
4499 | 4499 | Augustus Hand H000152 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4502 | 4502 | Albert Harrison H000261 | rep | MO | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4504 | 4504 | Richard Hawes H000363 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
4509 | 4509 | Micajah Hawkins H000373 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4510 | 4510 | John Henderson H000482 | sen | MS | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
4511 | 4511 | John Hill H000594 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
4512 | 4512 | John Hill H000595 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4513 | 4513 | Solomon Hillen Solomon H000617 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4515 | 4515 | Josiah Hoffman H000687 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4516 | 4516 | Joel Holleman H000721 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4517 | 4517 | Hines Holt H000745 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4518 | 4518 | Tilghman Howard H000844 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4520 | 4520 | Thomas Jackson J000027 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4524 | 4524 | Daniel Jenifer J000078 | rep | MD | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4525 | 4525 | Charles Johnston J000184 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4527 | 4527 | Nathaniel Jones J000243 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4529 | 4529 | Gouverneur Kemble K000084 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4530 | 4530 | Thomas Kempshall K000087 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 28 | |||||||||||||
4531 | 4531 | Joseph Kille K000178 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4533 | 4533 | Abbott Lawrence L000130 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4535 | 4535 | Daniel Leadbetter L000172 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4536 | 4536 | Isaac Leet L000211 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 21 | |||||||||||||
4538 | 4538 | Stephen Leonard L000249 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 22 | |||||||||||||
4539 | 4539 | Meredith Mallory M000081 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 27 | |||||||||||||
4541 | 4541 | Richard Marvin M000211 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 31 | |||||||||||||
4542 | 4542 | William McCarty M000322 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 14 | |||||||||||||
4544 | 4544 | Charles McClure M000345 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4545 | 4545 | George McCulloch M000389 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
4557 | 4557 | Charles Mercer M000642 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 14 | |||||||||||||
4559 | 4559 | Charles Mitchell M000806 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 33 | |||||||||||||
4560 | 4560 | James Monroe M000856 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4563 | 4563 | William Montgomery M000874 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4565 | 4565 | Samuel Morris M000987 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4567 | 4567 | Charles Naylor N000011 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4568 | 4568 | Rufus Palen P000032 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4570 | 4570 | Virgil Parris P000081 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4572 | 4572 | Lemuel Paynter P000155 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4574 | 4574 | Luther Peck P000179 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 30 | |||||||||||||
4576 | 4576 | David Petrikin P000267 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 15 | |||||||||||||
4578 | 4578 | William Potter P000469 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
4580 | 4580 | John Prentiss P000509 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4581 | 4581 | William Ramsey R000030 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4583 | 4583 | James Rariden R000066 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4595 | 4595 | John Reed R000121 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4598 | 4598 | Eleazar Ripley R000265 | rep | LA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4600 | 4600 | Francis Rives R000284 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4601 | 4601 | Thomas Robinson R000353 | rep | DE | 1839-12-02 | 1841-03-03 | Democrat | 0 | |||||||||||||
4602 | 4602 | Edward Rogers R000393 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4605 | 4605 | David Russell R000524 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
4606 | 4606 | Daniel Ryall R000554 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4607 | 4607 | Green Samuels S000028 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 16 | |||||||||||||
4609 | 4609 | Charles Shepard S000329 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 4 |
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);