legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
20,712 rows where party = "Democrat"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4395 | 4395 | Hugh Anderson A000190 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4396 | 4396 | Hugh Anderson A000190 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4398 | 4398 | William Beatty B000284 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 23 | |||||||||||||
4399 | 4399 | William Beatty B000284 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4400 | 4400 | Andrew Beirne B000319 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4401 | 4401 | Andrew Beirne B000319 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4412 | 4412 | Jesse Bynum B001204 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
4422 | 4422 | William Chapman C000318 | rep | IA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4423 | 4423 | William Chapman C000318 | rep | IA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4426 | 4426 | Henry Connor C000700 | rep | NC | 1823-12-01 | 1825-03-03 | Democrat | 11 | |||||||||||||
4433 | 4433 | Henry Connor C000700 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 11 | |||||||||||||
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 | |||||||||||||
4441 | 4441 | Robert Craig C000859 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 17 | |||||||||||||
4442 | 4442 | Robert Craig C000859 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4444 | 4444 | Isaac Crary C000882 | rep | MI | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4445 | 4445 | Isaac Crary C000882 | rep | MI | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4450 | 4450 | Thomas Davee D000068 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 8 | |||||||||||||
4451 | 4451 | Thomas Davee D000068 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
4460 | 4460 | Philemon Dickerson D000309 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -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 | |||||||||||||
4471 | 4471 | Isaac Fletcher F000201 | rep | VT | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
4477 | 4477 | James Garland G000067 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 12 | |||||||||||||
4490 | 4490 | John Griffin G000462 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
4495 | 4495 | Felix Grundy G000509 | sen | TN | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4496 | 4496 | Felix Grundy G000509 | sen | TN | 1839-12-02 | 1841-03-03 | 1 | Democrat | |||||||||||||
4497 | 4497 | Robert Hammond H000132 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 16 | |||||||||||||
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 | |||||||||||||
4501 | 4501 | Albert Harrison H000261 | rep | MO | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4502 | 4502 | Albert Harrison H000261 | rep | MO | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4508 | 4508 | Micajah Hawkins H000373 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4509 | 4509 | Micajah Hawkins H000373 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4511 | 4511 | John Hill H000594 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
4513 | 4513 | Solomon Hillen Solomon H000617 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4516 | 4516 | Joel Holleman H000721 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4518 | 4518 | Tilghman Howard H000844 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4519 | 4519 | Thomas Jackson J000027 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4520 | 4520 | Thomas Jackson J000027 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4526 | 4526 | Nathaniel Jones J000243 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4527 | 4527 | Nathaniel Jones J000243 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4528 | 4528 | Gouverneur Kemble K000084 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
4529 | 4529 | Gouverneur Kemble K000084 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4531 | 4531 | Joseph Kille K000178 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4534 | 4534 | Daniel Leadbetter L000172 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
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 | |||||||||||||
4543 | 4543 | Charles McClure M000345 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
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 | |||||||||||||
4562 | 4562 | William Montgomery M000874 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 8 | |||||||||||||
4563 | 4563 | William Montgomery M000874 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4564 | 4564 | Samuel Morris M000987 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 17 | |||||||||||||
4565 | 4565 | Samuel Morris M000987 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4569 | 4569 | Virgil Parris P000081 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4570 | 4570 | Virgil Parris P000081 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4571 | 4571 | Lemuel Paynter P000155 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4572 | 4572 | Lemuel Paynter P000155 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4575 | 4575 | David Petrikin P000267 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 15 | |||||||||||||
4576 | 4576 | David Petrikin P000267 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 15 | |||||||||||||
4577 | 4577 | William Potter P000469 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 14 | |||||||||||||
4578 | 4578 | William Potter P000469 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
4579 | 4579 | John Prentiss P000509 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
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 | |||||||||||||
4597 | 4597 | Eleazar Ripley R000265 | rep | LA | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4598 | 4598 | Eleazar Ripley R000265 | rep | LA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4599 | 4599 | Francis Rives R000284 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
4610 | 4610 | Albert Smith S000513 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4611 | 4611 | John Smith S000565 | rep | VT | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4619 | 4619 | Theron Strong S001020 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 25 | |||||||||||||
4620 | 4620 | Henry Swearingen S001099 | rep | OH | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4621 | 4621 | Henry Swearingen S001099 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4622 | 4622 | Nathaniel Tallmadge T000032 | sen | NY | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4624 | 4624 | Benjamin Tappan T000039 | sen | OH | 1839-12-02 | 1845-03-03 | 1 | Democrat | |||||||||||||
4625 | 4625 | Jonathan Taylor T000092 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 12 | |||||||||||||
4631 | 4631 | Aaron Vanderpoel V000028 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4632 | 4632 | Peter Vroom V000123 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4635 | 4635 | David Wagener W000016 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 7 | |||||||||||||
4636 | 4636 | David Wagener W000016 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4638 | 4638 | Reuel Williams W000532 | sen | ME | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
4639 | 4639 | Reuel Williams W000532 | sen | ME | 1839-12-02 | 1843-12-31 | 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);