legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
52 rows where party = "Federalist" and state = "VA"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
170 | 170 | George Hancock H000148 | rep | VA | 1795-12-07 | 1797-03-03 | Federalist | 5 | |||||||||||||
277 | 277 | James Machir M000013 | rep | VA | 1797-05-15 | 1799-03-03 | Federalist | 3 | |||||||||||||
283 | 283 | Daniel Morgan M000946 | rep | VA | 1797-05-15 | 1799-03-03 | Federalist | 1 | |||||||||||||
359 | 359 | Thomas Evans E000257 | rep | VA | 1797-05-15 | 1799-03-03 | Federalist | 12 | |||||||||||||
360 | 360 | Thomas Evans E000257 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 12 | |||||||||||||
393 | 393 | Henry Lee L000195 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 19 | |||||||||||||
402 | 402 | John Marshall M000157 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 13 | |||||||||||||
409 | 409 | Robert Page P000021 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
410 | 410 | Josiah Parker P000065 | rep | VA | 1789-03-04 | 1791-03-03 | Federalist | 8 | |||||||||||||
411 | 411 | Josiah Parker P000065 | rep | VA | 1791-10-24 | 1793-03-03 | Federalist | 8 | |||||||||||||
412 | 412 | Josiah Parker P000065 | rep | VA | 1793-12-02 | 1795-03-03 | Federalist | 11 | |||||||||||||
413 | 413 | Josiah Parker P000065 | rep | VA | 1795-12-07 | 1797-03-03 | Federalist | 11 | |||||||||||||
414 | 414 | Josiah Parker P000065 | rep | VA | 1797-05-15 | 1799-03-03 | Federalist | 11 | |||||||||||||
415 | 415 | Josiah Parker P000065 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 11 | |||||||||||||
419 | 419 | Leven Powell P000482 | rep | VA | 1799-12-02 | 1801-03-03 | Federalist | 17 | |||||||||||||
531 | 531 | John Stratton S000994 | rep | VA | 1801-12-07 | 1803-03-03 | Federalist | 12 | |||||||||||||
579 | 579 | Thomas Griffin G000467 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 12 | |||||||||||||
594 | 594 | Thomas Lewis L000294 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 5 | |||||||||||||
1072 | 1072 | Jacob Swoope S001125 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 4 | |||||||||||||
1099 | 1099 | John Baker B000067 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 2 | |||||||||||||
1260 | 1260 | Thomas Wilson W000615 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 1 | |||||||||||||
1274 | 1274 | Thomas Bayly B000260 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 13 | |||||||||||||
1306 | 1306 | Hugh Caperton C000131 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
1425 | 1425 | Francis White W000367 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1471 | 1471 | James Breckinridge B000785 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 5 | |||||||||||||
1472 | 1472 | James Breckinridge B000785 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 5 | |||||||||||||
1473 | 1473 | James Breckinridge B000785 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
1474 | 1474 | James Breckinridge B000785 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 5 | |||||||||||||
1643 | 1643 | Joseph Lewis L000290 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 7 | |||||||||||||
1644 | 1644 | Joseph Lewis L000290 | rep | VA | 1805-12-02 | 1807-03-03 | Federalist | 7 | |||||||||||||
1645 | 1645 | Joseph Lewis L000290 | rep | VA | 1807-10-26 | 1809-03-03 | Federalist | 7 | |||||||||||||
1646 | 1646 | Joseph Lewis L000290 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 7 | |||||||||||||
1647 | 1647 | Joseph Lewis L000290 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 7 | |||||||||||||
1648 | 1648 | Joseph Lewis L000290 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 8 | |||||||||||||
1649 | 1649 | Joseph Lewis L000290 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 8 | |||||||||||||
1705 | 1705 | Daniel Sheffey S000317 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 6 | |||||||||||||
1706 | 1706 | Daniel Sheffey S000317 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1707 | 1707 | Daniel Sheffey S000317 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 6 | |||||||||||||
1708 | 1708 | Daniel Sheffey S000317 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 6 | |||||||||||||
1746 | 1746 | Magnus Tate T000047 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1813 | 1813 | Edward Colston C000650 | rep | VA | 1817-12-01 | 1819-03-03 | Federalist | 2 | |||||||||||||
2103 | 2103 | James Pindall P000358 | rep | VA | 1817-12-01 | 1819-03-03 | Federalist | 1 | |||||||||||||
2104 | 2104 | James Pindall P000358 | rep | VA | 1819-12-06 | 1821-03-03 | Federalist | 1 | |||||||||||||
2339 | 2339 | Thomas Van Swearingen V000059 | rep | VA | 1819-12-06 | 1821-03-03 | Federalist | 2 | |||||||||||||
2340 | 2340 | Thomas Van Swearingen V000059 | rep | VA | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2491 | 2491 | James Stephenson S000864 | rep | VA | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
2492 | 2492 | James Stephenson S000864 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
2493 | 2493 | James Stephenson S000864 | rep | VA | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2494 | 2494 | James Stephenson S000864 | rep | VA | 1823-12-01 | 1825-03-03 | Federalist | 16 | |||||||||||||
4546 | 4546 | Charles Mercer M000642 | rep | VA | 1817-12-01 | 1819-03-03 | Federalist | 8 | |||||||||||||
4547 | 4547 | Charles Mercer M000642 | rep | VA | 1819-12-06 | 1821-03-03 | Federalist | 8 | |||||||||||||
4548 | 4548 | Charles Mercer M000642 | rep | VA | 1821-12-03 | 1823-03-03 | Federalist | 8 |
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);