legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3,899 rows where district = 2
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | Aedanus Burke B001086 | rep | SC | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
33 | 33 | Robert Barnwell B000167 | rep | SC | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
50 | 50 | Joshua Seney S000242 | rep | MD | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
51 | 51 | Joshua Seney S000242 | rep | MD | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
67 | 67 | Hugh Williamson W000551 | rep | NC | 1789-03-04 | 1791-03-03 | Federalist | 2 | |||||||||||||
111 | 111 | John Mercer M000645 | rep | MD | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
115 | 115 | Nathaniel Niles N000109 | rep | VT | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
116 | 116 | Nathaniel Niles N000109 | rep | VT | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
124 | 124 | Thomas Tredwell T000361 | rep | NY | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
134 | 134 | Artemas Ward W000127 | rep | MA | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
152 | 152 | Daniel Buck B001014 | rep | VT | 1795-12-07 | 1797-03-03 | Federalist | 2 | |||||||||||||
159 | 159 | Gabriel Duvall D000578 | rep | MD | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
160 | 160 | Gabriel Duvall D000578 | rep | MD | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
183 | 183 | William Lyman L000530 | rep | MA | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
184 | 184 | William Lyman L000530 | rep | MA | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
187 | 187 | Frederick Muhlenberg M001063 | rep | PA | 1791-10-24 | 1793-03-03 | Anti-administration | 2 | |||||||||||||
189 | 189 | Frederick Muhlenberg M001063 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
193 | 193 | Alexander Orr O000101 | rep | KY | 1791-10-24 | 1793-03-03 | Republican | 2 | |||||||||||||
194 | 194 | Alexander Orr O000101 | rep | KY | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
195 | 195 | Alexander Orr O000101 | rep | KY | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
225 | 225 | Benjamin Goodhue G000286 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 2 | |||||||||||||
226 | 226 | Benjamin Goodhue G000286 | rep | MA | 1791-10-24 | 1793-03-03 | Federalist | 2 | |||||||||||||
233 | 233 | John Hunter H000982 | rep | SC | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
235 | 235 | John Laurance L000120 | rep | NY | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
236 | 236 | John Laurance L000120 | rep | NY | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
274 | 274 | Matthew Locke L000389 | rep | NC | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
275 | 275 | Matthew Locke L000389 | rep | NC | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
276 | 276 | Matthew Locke L000389 | rep | NC | 1797-05-15 | 1799-03-03 | Republican | 2 | |||||||||||||
281 | 281 | Blair McClenachan M000336 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 2 | |||||||||||||
382 | 382 | Jonathan Havens H000359 | rep | NY | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
383 | 383 | Jonathan Havens H000359 | rep | NY | 1797-05-15 | 1799-03-03 | Republican | 2 | |||||||||||||
384 | 384 | Jonathan Havens H000359 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
425 | 425 | Theodore Sedgwick S000222 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 2 | |||||||||||||
439 | 439 | John Thomas T000173 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
445 | 445 | Dwight Foster F000301 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 2 | |||||||||||||
449 | 449 | William Hindman H000629 | rep | MD | 1791-10-24 | 1793-03-03 | Federalist | 2 | |||||||||||||
485 | 485 | Archibald Henderson H000475 | rep | NC | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
486 | 486 | Archibald Henderson H000475 | rep | NC | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
505 | 505 | Lewis Morris M000983 | rep | VT | 1797-05-15 | 1799-03-03 | Federalist | 2 | |||||||||||||
506 | 506 | Lewis Morris M000983 | rep | VT | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
507 | 507 | Lewis Morris M000983 | rep | VT | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
519 | 519 | John Rutledge R000553 | rep | SC | 1797-05-15 | 1799-03-03 | Federalist | 2 | |||||||||||||
520 | 520 | John Rutledge R000553 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
521 | 521 | John Rutledge R000553 | rep | SC | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
524 | 524 | William Shepard S000330 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 2 | |||||||||||||
525 | 525 | William Shepard S000330 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
526 | 526 | William Shepard S000330 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
528 | 528 | Richard, Sprigg S000752 | rep | MD | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
529 | 529 | Richard, Sprigg S000752 | rep | MD | 1797-05-15 | 1799-03-03 | Republican | 2 | |||||||||||||
530 | 530 | Richard, Sprigg S000752 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
559 | 559 | Walter Bowie B000697 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
560 | 560 | Walter Bowie B000697 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
582 | 582 | Wade Hampton H000140 | rep | SC | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
630 | 630 | Isaac Van Horne V000045 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
647 | 647 | Andrew Moore M000891 | rep | VA | 1793-12-02 | 1795-03-03 | Democratic Republican | 2 | |||||||||||||
648 | 648 | Andrew Moore M000891 | rep | VA | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
656 | 656 | Abraham Baldwin B000084 | rep | GA | 1789-03-04 | 1791-03-03 | Democratic Republican | 2 | |||||||||||||
657 | 657 | Abraham Baldwin B000084 | rep | GA | 1791-10-24 | 1793-03-03 | Democratic Republican | 2 | |||||||||||||
677 | 677 | Frederick Conrad C000704 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
678 | 678 | Frederick Conrad C000704 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
679 | 679 | Leonard Covington C000817 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
692 | 692 | John Fowler F000322 | rep | KY | 1797-05-15 | 1799-03-03 | Republican | 2 | |||||||||||||
693 | 693 | John Fowler F000322 | rep | KY | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
694 | 694 | John Fowler F000322 | rep | KY | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
721 | 721 | Aaron Kitchell K000246 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
806 | 806 | John Boyle B000729 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
807 | 807 | John Boyle B000729 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
808 | 808 | John Boyle B000729 | rep | KY | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
823 | 823 | George Clinton C000526 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
824 | 824 | George Clinton C000526 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
825 | 825 | Jacob Crowninshield C000947 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
826 | 826 | Jacob Crowninshield C000947 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
827 | 827 | Jacob Crowninshield C000947 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
832 | 832 | James Elliott E000122 | rep | VT | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
833 | 833 | James Elliott E000122 | rep | VT | 1805-12-02 | 1807-03-03 | Federalist | 2 | |||||||||||||
834 | 834 | James Elliott E000122 | rep | VT | 1807-10-26 | 1809-03-03 | Federalist | 2 | |||||||||||||
875 | 875 | John Morrow M001005 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
876 | 876 | John Morrow M001005 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
880 | 880 | John Pugh P000562 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
881 | 881 | John Pugh P000562 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
897 | 897 | Joseph Story S000978 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
998 | 998 | Jonathan Hubbard H000886 | rep | VT | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
1013 | 1013 | Michael Leib L000229 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
1014 | 1014 | Michael Leib L000229 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
1036 | 1036 | Pleasant Miller M000750 | rep | TN | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1039 | 1039 | Gurdon Mumford M001076 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1048 | 1048 | Benjamin Pickman P000330 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
1078 | 1078 | Archibald Van Horne V000043 | rep | MD | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
1079 | 1079 | Archibald Van Horne V000043 | rep | MD | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1099 | 1099 | John Baker B000067 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 2 | |||||||||||||
1123 | 1123 | William Butler B001194 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
1124 | 1124 | William Butler B001194 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1125 | 1125 | William Butler B001194 | rep | SC | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
1126 | 1126 | William Butler B001194 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1127 | 1127 | William Butler B001194 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1194 | 1194 | Samuel Mitchill M000831 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
1197 | 1197 | Samuel Mitchill M000831 | rep | NY | 1810-12-04 | 1811-03-03 | Republican | 2 | |||||||||||||
1198 | 1198 | Samuel Mitchill M000831 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1206 | 1206 | William Paulding P000146 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1212 | 1212 | William Rodman R000375 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 2 |
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);