legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
19,135 rows where party = "Republican"
This data as json, copyable, CSV (advanced)
state >30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1419 | 1419 | Charles Tait T000015 | sen | GA | 1809-05-22 | 1813-03-03 | 3 | Republican | |||||||||||||
1420 | 1420 | Charles Tait T000015 | sen | GA | 1813-05-24 | 1819-03-03 | 3 | Republican | |||||||||||||
1421 | 1421 | Adamson Tannehill T000036 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 14 | |||||||||||||
1426 | 1426 | James Whitehill W000402 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1427 | 1427 | Robert Whitehill W000404 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
1428 | 1428 | Robert Whitehill W000404 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 4 | |||||||||||||
1429 | 1429 | Robert Whitehill W000404 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
1430 | 1430 | Robert Whitehill W000404 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
1431 | 1431 | Robert Whitehill W000404 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
1433 | 1433 | Abiel Wood W000687 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 17 | |||||||||||||
1434 | 1434 | William Barry B000192 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1435 | 1435 | William Barry B000192 | sen | KY | 1814-01-01 | 1817-03-03 | 2 | Republican | |||||||||||||
1436 | 1436 | Joseph Kerr K000141 | sen | OH | 1814-01-01 | 1815-03-03 | 1 | Republican | |||||||||||||
1438 | 1438 | Jonathan Roberts R000313 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1439 | 1439 | Jonathan Roberts R000313 | rep | PA | 1813-05-24 | 1814-02-24 | Republican | 2 | |||||||||||||
1440 | 1440 | Jonathan Roberts R000313 | sen | PA | 1814-02-24 | 1815-03-03 | 1 | Republican | |||||||||||||
1441 | 1441 | Jonathan Roberts R000313 | sen | PA | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
1444 | 1444 | George Walker W000053 | sen | KY | 1814-01-01 | 1815-03-03 | 2 | Republican | |||||||||||||
1445 | 1445 | Jesse Wharton W000324 | rep | TN | 1807-10-26 | 1809-03-03 | Republican | 3 | |||||||||||||
1446 | 1446 | Jesse Wharton W000324 | sen | TN | 1814-01-01 | 1815-12-31 | 2 | Republican | |||||||||||||
1447 | 1447 | Asa Adgate A000056 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
1448 | 1448 | John Alexander A000096 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1449 | 1449 | John Alexander A000096 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1451 | 1451 | Daniel Avery A000345 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 14 | |||||||||||||
1452 | 1452 | Daniel Avery A000345 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 20 | |||||||||||||
1453 | 1453 | Daniel Avery A000345 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
1457 | 1457 | Ezra Baker B000060 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1458 | 1458 | David Bard B000137 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 10 | |||||||||||||
1459 | 1459 | David Bard B000137 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 10 | |||||||||||||
1460 | 1460 | David Bard B000137 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
1461 | 1461 | David Bard B000137 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
1462 | 1462 | David Bard B000137 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 4 | |||||||||||||
1463 | 1463 | David Bard B000137 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
1464 | 1464 | David Bard B000137 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
1465 | 1465 | David Bard B000137 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1466 | 1466 | David Bard B000137 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1467 | 1467 | Samuel Betts B000427 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
1468 | 1468 | James Birdsall B000482 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 15 | |||||||||||||
1478 | 1478 | Micah Brooks B000883 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
1480 | 1480 | Thomas Burnside B001132 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1482 | 1482 | James Caldwell C000033 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1483 | 1483 | James Caldwell C000033 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1484 | 1484 | George Campbell C000083 | rep | TN | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
1485 | 1485 | George Campbell C000083 | rep | TN | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1486 | 1486 | George Campbell C000083 | rep | TN | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
1487 | 1487 | George Campbell C000083 | sen | TN | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1488 | 1488 | George Campbell C000083 | sen | TN | 1815-12-04 | 1819-03-03 | 1 | Republican | |||||||||||||
1495 | 1495 | John Chappell C000320 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1496 | 1496 | John Chappell C000320 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1500 | 1500 | James Clark C000438 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1501 | 1501 | Archibald Clarke C000456 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
1502 | 1502 | Matthew Clay C000487 | rep | VA | 1797-05-15 | 1799-03-03 | Republican | 6 | |||||||||||||
1503 | 1503 | Matthew Clay C000487 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 6 | |||||||||||||
1504 | 1504 | Matthew Clay C000487 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
1505 | 1505 | Matthew Clay C000487 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 14 | |||||||||||||
1506 | 1506 | Matthew Clay C000487 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
1507 | 1507 | Matthew Clay C000487 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 14 | |||||||||||||
1508 | 1508 | Matthew Clay C000487 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 14 | |||||||||||||
1509 | 1509 | Matthew Clay C000487 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 14 | |||||||||||||
1510 | 1510 | Matthew Clay C000487 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1511 | 1511 | David Clendenin C000510 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1512 | 1512 | David Clendenin C000510 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1513 | 1513 | John Clopton C000531 | rep | VA | 1795-12-07 | 1797-03-03 | Republican | 13 | |||||||||||||
1514 | 1514 | John Clopton C000531 | rep | VA | 1797-05-15 | 1799-03-03 | Republican | 13 | |||||||||||||
1515 | 1515 | John Clopton C000531 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 13 | |||||||||||||
1516 | 1516 | John Clopton C000531 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 22 | |||||||||||||
1517 | 1517 | John Clopton C000531 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 22 | |||||||||||||
1518 | 1518 | John Clopton C000531 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 22 | |||||||||||||
1519 | 1519 | John Clopton C000531 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 22 | |||||||||||||
1520 | 1520 | John Clopton C000531 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 22 | |||||||||||||
1521 | 1521 | John Clopton C000531 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 23 | |||||||||||||
1522 | 1522 | John Clopton C000531 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 23 | |||||||||||||
1523 | 1523 | Samuel Conner C000692 | rep | MA | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
1526 | 1526 | William Crawford C000894 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 6 | |||||||||||||
1527 | 1527 | William Crawford C000894 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
1528 | 1528 | William Crawford C000894 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1529 | 1529 | William Crawford C000894 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
1530 | 1530 | Henry Crocheron C000914 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1550 | 1550 | Samuel Dickens D000306 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1555 | 1555 | William Findley F000124 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 11 | |||||||||||||
1556 | 1556 | William Findley F000124 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 11 | |||||||||||||
1557 | 1557 | William Findley F000124 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
1558 | 1558 | William Findley F000124 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
1559 | 1559 | William Findley F000124 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 8 | |||||||||||||
1560 | 1560 | William Findley F000124 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
1561 | 1561 | William Findley F000124 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
1562 | 1562 | William Findley F000124 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 11 | |||||||||||||
1563 | 1563 | William Findley F000124 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
1564 | 1564 | Jonathan Fisk F000155 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1565 | 1565 | Jonathan Fisk F000155 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1566 | 1566 | Jonathan Fisk F000155 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1567 | 1567 | Thomas Fletcher F000204 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1570 | 1570 | Thomas Gholson G000150 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 17 | |||||||||||||
1571 | 1571 | Thomas Gholson G000150 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 17 | |||||||||||||
1572 | 1572 | Thomas Gholson G000150 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 17 | |||||||||||||
1573 | 1573 | Thomas Gholson G000150 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 18 | |||||||||||||
1574 | 1574 | Thomas Gholson G000150 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 18 | |||||||||||||
1575 | 1575 | Hugh Glasgow G000231 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1576 | 1576 | Hugh Glasgow G000231 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1588 | 1588 | Isaac Griffin G000461 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 13 |
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);