legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,670 rows where district = 9
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, phone, rss_url, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | Theodorick Bland B000546 | rep | VA | 1789-03-04 | 1791-03-03 | 9 | ||||||||||||||
96 | 96 | James Gordon G000311 | rep | NY | 1793-12-02 | 1795-03-03 | 9 | ||||||||||||||
315 | 315 | John Williams W000513 | rep | NY | 1795-12-07 | 1797-03-03 | Federalist | 9 | |||||||||||||
316 | 316 | John Williams W000513 | rep | NY | 1797-05-15 | 1799-03-03 | Federalist | 9 | |||||||||||||
357 | 357 | Joseph Eggleston E000091 | rep | VA | 1797-05-15 | 1799-03-03 | Republican | 9 | |||||||||||||
358 | 358 | Joseph Eggleston E000091 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 9 | |||||||||||||
418 | 418 | Jonas Platt P000381 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 9 | |||||||||||||
542 | 542 | Benjamin Walker W000046 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | 9 | |||||||||||||
669 | 669 | Phanuel Bishop B000488 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
670 | 670 | Phanuel Bishop B000488 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
770 | 770 | Philip Thompson T000213 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
771 | 771 | Philip Thompson T000213 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
830 | 830 | Josiah Dean D000173 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 9 | |||||||||||||
847 | 847 | Andrew Gregg G000442 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 9 | |||||||||||||
848 | 848 | Andrew Gregg G000442 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 9 | |||||||||||||
849 | 849 | Andrew Gregg G000442 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 9 | |||||||||||||
850 | 850 | Andrew Gregg G000442 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 9 | |||||||||||||
923 | 923 | Marmaduke Williams W000529 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
924 | 924 | Marmaduke Williams W000529 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
925 | 925 | Marmaduke Williams W000529 | rep | NC | 1807-10-26 | 1809-03-03 | Republican | 9 | |||||||||||||
1020 | 1020 | John Love L000456 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 9 | |||||||||||||
1021 | 1021 | John Love L000456 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 9 | |||||||||||||
1081 | 1081 | Killian Van Rensselaer V000054 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 9 | |||||||||||||
1082 | 1082 | Killian Van Rensselaer V000054 | rep | NY | 1805-12-02 | 1807-03-03 | Federalist | 9 | |||||||||||||
1083 | 1083 | Killian Van Rensselaer V000054 | rep | NY | 1807-10-26 | 1809-03-03 | Federalist | 9 | |||||||||||||
1112 | 1112 | Thomas Blount B000569 | rep | NC | 1793-12-02 | 1795-03-03 | Republican | 9 | |||||||||||||
1113 | 1113 | Thomas Blount B000569 | rep | NC | 1795-12-07 | 1797-03-03 | Republican | 9 | |||||||||||||
1114 | 1114 | Thomas Blount B000569 | rep | NC | 1797-05-15 | 1799-03-03 | Republican | 9 | |||||||||||||
1137 | 1137 | James Cochran C000564 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 9 | |||||||||||||
1138 | 1138 | James Cochran C000564 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 9 | |||||||||||||
1154 | 1154 | William Giles G000183 | rep | VA | 1790-12-07 | 1791-03-03 | Republican | 9 | |||||||||||||
1155 | 1155 | William Giles G000183 | rep | VA | 1791-10-24 | 1793-03-03 | Republican | 9 | |||||||||||||
1156 | 1156 | William Giles G000183 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 9 | |||||||||||||
1157 | 1157 | William Giles G000183 | rep | VA | 1795-12-07 | 1797-03-03 | Republican | 9 | |||||||||||||
1158 | 1158 | William Giles G000183 | rep | VA | 1797-05-15 | 1798-10-02 | Republican | 9 | |||||||||||||
1159 | 1159 | William Giles G000183 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 9 | |||||||||||||
1215 | 1215 | Thomas Sammons S000023 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 9 | |||||||||||||
1216 | 1216 | Thomas Sammons S000023 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 9 | |||||||||||||
1228 | 1228 | John Smilie S000508 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
1229 | 1229 | John Smilie S000508 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
1230 | 1230 | John Smilie S000508 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 9 | |||||||||||||
1231 | 1231 | John Smilie S000508 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 9 | |||||||||||||
1232 | 1232 | John Smilie S000508 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 9 | |||||||||||||
1246 | 1246 | Joseph Varnum V000074 | rep | MA | 1795-12-07 | 1797-03-03 | Democratic Republican | 9 | |||||||||||||
1247 | 1247 | Joseph Varnum V000074 | rep | MA | 1797-05-15 | 1799-03-03 | Democratic Republican | 9 | |||||||||||||
1248 | 1248 | Joseph Varnum V000074 | rep | MA | 1799-12-02 | 1801-03-03 | Democratic Republican | 9 | |||||||||||||
1249 | 1249 | Joseph Varnum V000074 | rep | MA | 1801-12-07 | 1803-03-03 | Democratic Republican | 9 | |||||||||||||
1369 | 1369 | John Kershaw K000149 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1465 | 1465 | David Bard B000137 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1480 | 1480 | Thomas Burnside B001132 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1601 | 1601 | Aylett Hawes H000361 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 9 | |||||||||||||
1614 | 1614 | John Hungerford H000967 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1615 | 1615 | John Hungerford H000967 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1651 | 1651 | John Lovett L000466 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 9 | |||||||||||||
1652 | 1652 | John Lovett L000466 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 9 | |||||||||||||
1659 | 1659 | William Mayrant M000288 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1747 | 1747 | Micah Taul T000054 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1762 | 1762 | Laban Wheaton W000329 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 9 | |||||||||||||
1763 | 1763 | Laban Wheaton W000329 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 9 | |||||||||||||
1764 | 1764 | Laban Wheaton W000329 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 9 | |||||||||||||
1775 | 1775 | Bartlett Yancey Y000001 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1776 | 1776 | Bartlett Yancey Y000001 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1943 | 1943 | Rensselaer Westerlo W000309 | rep | NY | 1817-12-01 | 1819-03-03 | Federalist | 9 | |||||||||||||
1975 | 1975 | Joseph Brevard B000808 | rep | SC | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2022 | 2022 | Walter Folger F000242 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2023 | 2023 | Walter Folger F000242 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2064 | 2064 | William Maclay M000033 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
2065 | 2065 | William Maclay M000033 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2066 | 2066 | William Maclay M000033 | rep | PA | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2110 | 2110 | Tunstall Quarles Q000005 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2111 | 2111 | Tunstall Quarles Q000005 | rep | KY | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2126 | 2126 | Thomas Settle S000254 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2127 | 2127 | Thomas Settle S000254 | rep | NC | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2271 | 2271 | Thomas Montgomery M000872 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
2272 | 2272 | Thomas Montgomery M000872 | rep | KY | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2273 | 2273 | Thomas Montgomery M000872 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2337 | 2337 | Solomon Van Rensselaer V000055 | rep | NY | 1819-12-06 | 1821-03-03 | Federalist | 9 | |||||||||||||
2338 | 2338 | Solomon Van Rensselaer V000055 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
2377 | 2377 | William Ball B000103 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2378 | 2378 | William Ball B000103 | rep | VA | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2379 | 2379 | William Ball B000103 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2382 | 2382 | John Brown B000926 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2410 | 2410 | William Ellis E000137 | rep | PA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2426 | 2426 | James Hogeboom H000700 | rep | NY | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2547 | 2547 | Adam Alexander A000089 | rep | TN | 1823-12-01 | 1825-03-03 | Jacksonian Republican | 9 | |||||||||||||
2548 | 2548 | Adam Alexander A000089 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
2684 | 2684 | William McManus M000562 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 9 | |||||||||||||
2794 | 2794 | Philemon Beecher B000306 | rep | OH | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2795 | 2795 | Philemon Beecher B000306 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 9 | |||||||||||||
2796 | 2796 | Philemon Beecher B000306 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 9 | |||||||||||||
2815 | 2815 | John Carter C000197 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2866 | 2866 | George Kremer K000329 | rep | PA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2867 | 2867 | George Kremer K000329 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
2868 | 2868 | George Kremer K000329 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 9 | |||||||||||||
2981 | 2981 | Espy Van Horne V000044 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
2982 | 2982 | Espy Van Horne V000044 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 9 | |||||||||||||
2983 | 2983 | Stephen Van Rensselaer V000056 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
3023 | 3023 | Willis Alston A000167 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 9 | |||||||||||||
3024 | 3024 | Willis Alston A000167 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 9 | |||||||||||||
3084 | 3084 | John Dickinson D000322 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 9 |
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);