legislator_terms
45,526 rows
This data as json, CSV (advanced)
| Link | rowid | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | caucus | url | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | Richard Bassett B000226 | sen | DE | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 2 | 2 | Theodorick Bland B000546 | rep | VA | 1789-03-04 | 1791-03-03 | null | null | 9 | null | null | null | null | null | null | null | null | null | null | null | null |
| 3 | 3 | Aedanus Burke B001086 | rep | SC | 1789-03-04 | 1791-03-03 | null | null | 2 | null | null | null | null | null | null | null | null | null | null | null | null |
| 4 | 4 | Daniel Carroll C000187 | rep | MD | 1789-03-04 | 1791-03-03 | null | null | 6 | null | null | null | null | null | null | null | null | null | null | null | null |
| 5 | 5 | George Clymer C000538 | rep | PA | 1789-03-04 | 1791-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 6 | 6 | Benjamin Contee C000710 | rep | MD | 1789-03-04 | 1791-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 7 | 7 | Tristram Dalton D000013 | sen | MA | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 8 | 8 | Jonathan Elmer E000155 | sen | NJ | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 9 | 9 | William Few F000100 | sen | GA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 10 | 10 | William Floyd F000224 | rep | NY | 1789-03-04 | 1791-03-03 | null | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 11 | 11 | George Gale G000012 | rep | MD | 1789-03-04 | 1791-03-03 | null | null | 5 | null | null | null | null | null | null | null | null | null | null | null | null |
| 12 | 12 | William Grayson G000403 | sen | VA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 13 | 13 | Jonathan Grout G000500 | rep | MA | 1789-03-04 | 1791-03-03 | null | null | 8 | null | null | null | null | null | null | null | null | null | null | null | null |
| 14 | 14 | Benjamin Hawkins H000368 | sen | NC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 15 | 15 | Benjamin Huntington H000995 | rep | CT | 1789-03-04 | 1791-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 16 | 16 | Ralph Izard I000053 | sen | SC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 17 | 17 | William Johnson J000182 | sen | CT | 1789-03-04 | 1791-12-31 | 3 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 18 | 18 | Samuel Johnston J000198 | sen | NC | 1789-03-04 | 1793-03-03 | 2 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 19 | 19 | Richard Lee L000201 | sen | VA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 20 | 20 | William Maclay M000031 | sen | PA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 21 | 21 | George Mathews M000234 | rep | GA | 1789-03-04 | 1791-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 22 | 22 | Robert Morris M000985 | sen | PA | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 23 | 23 | George Partridge P000092 | rep | MA | 1789-03-04 | 1791-03-03 | null | null | 5 | null | null | null | null | null | null | null | null | null | null | null | null |
| 24 | 24 | William Paterson P000102 | sen | NJ | 1789-03-04 | 1791-03-03 | 2 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 25 | 25 | William Smith S000624 | rep | MD | 1789-03-04 | 1791-03-03 | null | null | 4 | null | null | null | null | null | null | null | null | null | null | null | null |
| 26 | 26 | Michael Stone S000961 | rep | MD | 1789-03-04 | 1791-03-03 | null | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 27 | 27 | Jeremiah Van Rensselaer V000053 | rep | NY | 1789-03-04 | 1791-03-03 | null | null | 6 | null | null | null | null | null | null | null | null | null | null | null | null |
| 28 | 28 | Henry Wynkoop W000783 | rep | PA | 1789-03-04 | 1791-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 29 | 29 | Philemon Dickinson D000324 | sen | NJ | 1790-01-01 | 1793-03-03 | 2 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 30 | 30 | John Walker W000059 | sen | VA | 1790-01-01 | 1791-03-03 | 1 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 31 | 31 | John Ashe A000307 | rep | NC | 1789-03-04 | 1791-03-03 | null | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 32 | 32 | John Ashe A000307 | rep | NC | 1791-10-24 | 1793-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 33 | 33 | Robert Barnwell B000167 | rep | SC | 1791-10-24 | 1793-03-03 | null | null | 2 | null | null | null | null | null | null | null | null | null | null | null | null |
| 34 | 34 | Aaron Burr B001133 | sen | NY | 1791-10-24 | 1797-03-03 | 1 | Republican | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 35 | 35 | George Cabot C000009 | sen | MA | 1791-10-24 | 1797-03-03 | 1 | Federalist | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 36 | 36 | Charles Carroll C000185 | sen | MD | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 37 | 37 | Charles Carroll C000185 | sen | MD | 1791-10-24 | 1793-03-03 | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 38 | 38 | Oliver Ellsworth E000147 | sen | CT | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 39 | 39 | Oliver Ellsworth E000147 | sen | CT | 1791-10-24 | 1797-03-03 | 1 | Federalist | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 40 | 40 | Elbridge Gerry G000139 | rep | MA | 1789-03-04 | 1791-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 41 | 41 | Elbridge Gerry G000139 | rep | MA | 1791-10-24 | 1793-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 42 | 42 | Daniel Huger H000916 | rep | SC | 1789-03-04 | 1791-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 43 | 43 | Daniel Huger H000916 | rep | SC | 1791-10-24 | 1793-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 44 | 44 | Israel Jacobs J000036 | rep | PA | 1791-10-24 | 1793-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 45 | 45 | Philip Key K000158 | rep | MD | 1791-10-24 | 1793-03-03 | null | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 46 | 46 | George Read R000091 | sen | DE | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 47 | 47 | George Read R000091 | sen | DE | 1791-10-24 | 1793-12-31 | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 48 | 48 | Moses Robinson R000350 | sen | VT | 1791-10-24 | 1796-10-15 | 1 | Anti-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 49 | 49 | Cornelius Schoonmaker S000140 | rep | NY | 1791-10-24 | 1793-03-03 | null | null | 4 | null | null | null | null | null | null | null | null | null | null | null | null |
| 50 | 50 | Joshua Seney S000242 | rep | MD | 1789-03-04 | 1791-03-03 | null | null | 2 | null | null | null | null | null | null | null | null | null | null | null | null |
| 51 | 51 | Joshua Seney S000242 | rep | MD | 1791-10-24 | 1793-03-03 | null | null | 2 | null | null | null | null | null | null | null | null | null | null | null | null |
| 52 | 52 | Upton Sheredine S000340 | rep | MD | 1791-10-24 | 1793-03-03 | null | null | 6 | null | null | null | null | null | null | null | null | null | null | null | null |
| 53 | 53 | Roger Sherman S000349 | rep | CT | 1789-03-04 | 1791-03-03 | null | Pro-Administration | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 54 | 54 | Roger Sherman S000349 | sen | CT | 1791-10-24 | 1793-12-31 | 3 | Pro-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 55 | 55 | Peter Silvester S000412 | rep | NY | 1789-03-04 | 1791-03-03 | null | null | 5 | null | null | null | null | null | null | null | null | null | null | null | null |
| 56 | 56 | Peter Silvester S000412 | rep | NY | 1791-10-24 | 1793-03-03 | null | null | 5 | null | null | null | null | null | null | null | null | null | null | null | null |
| 57 | 57 | John Steele S000832 | rep | NC | 1789-03-04 | 1791-03-03 | null | null | 4 | null | null | null | null | null | null | null | null | null | null | null | null |
| 58 | 58 | John Steele S000832 | rep | NC | 1791-10-24 | 1793-03-03 | null | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 59 | 59 | Samuel Sterett S000866 | rep | MD | 1791-10-24 | 1793-03-03 | null | null | 4 | null | null | null | null | null | null | null | null | null | null | null | null |
| 60 | 60 | Jonathan Sturges S001047 | rep | CT | 1789-03-04 | 1791-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 61 | 61 | Jonathan Sturges S001047 | rep | CT | 1791-10-24 | 1793-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 62 | 62 | Thomas Tucker T000403 | rep | SC | 1789-03-04 | 1791-03-03 | null | null | 5 | null | null | null | null | null | null | null | null | null | null | null | null |
| 63 | 63 | Thomas Tucker T000403 | rep | SC | 1791-10-24 | 1793-03-03 | null | null | 5 | null | null | null | null | null | null | null | null | null | null | null | null |
| 64 | 64 | Anthony Wayne W000216 | rep | GA | 1791-10-24 | 1793-03-03 | null | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 65 | 65 | Alexander White W000352 | rep | VA | 1789-03-04 | 1791-03-03 | null | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 66 | 66 | Alexander White W000352 | rep | VA | 1791-10-24 | 1793-03-03 | null | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 67 | 67 | Hugh Williamson W000551 | rep | NC | 1789-03-04 | 1791-03-03 | null | Federalist | 2 | null | null | null | null | null | null | null | null | null | null | null | null |
| 68 | 68 | Hugh Williamson W000551 | rep | NC | 1791-10-24 | 1793-03-03 | null | Federalist | 4 | null | null | null | null | null | null | null | null | null | null | null | null |
| 69 | 69 | Francis Willis W000560 | rep | GA | 1791-10-24 | 1793-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 70 | 70 | John Edwards E000075 | sen | KY | 1792-01-01 | 1795-03-03 | 3 | Anti-Administration | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 71 | 71 | Richard Potts P000473 | sen | MD | 1793-01-10 | 1796-10-14 | 1 | Federalist | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 72 | 72 | James Armstrong A000280 | rep | PA | 1793-12-02 | 1795-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 73 | 73 | John Beatty B000282 | rep | NJ | 1793-12-02 | 1795-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 74 | 74 | Elias Boudinot B000661 | rep | NJ | 1789-03-04 | 1791-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 75 | 75 | Elias Boudinot B000661 | rep | NJ | 1791-10-24 | 1793-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 76 | 76 | Elias Boudinot B000661 | rep | NJ | 1793-12-02 | 1795-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 77 | 77 | Shearjashub Bourne B000671 | rep | MA | 1791-10-24 | 1793-03-03 | null | null | 5 | null | null | null | null | null | null | null | null | null | null | null | null |
| 78 | 78 | Shearjashub Bourne B000671 | rep | MA | 1793-12-02 | 1795-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 79 | 79 | William Bradford B000739 | sen | RI | 1793-12-02 | 1797-12-31 | 2 | Federalist | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 80 | 80 | Lambert Cadwalader C000012 | rep | NJ | 1789-03-04 | 1791-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 81 | 81 | Lambert Cadwalader C000012 | rep | NJ | 1793-12-02 | 1795-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 82 | 82 | Thomas Carnes C000163 | rep | GA | 1793-12-02 | 1795-03-03 | null | null | 0 | null | null | null | null | null | null | null | null | null | null | null | null |
| 83 | 83 | Abraham Clark C000418 | rep | NJ | 1791-10-24 | 1793-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 84 | 84 | Abraham Clark C000418 | rep | NJ | 1793-12-02 | 1795-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 85 | 85 | David Cobb C000545 | rep | MA | 1793-12-02 | 1795-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 86 | 86 | Peleg Coffin C000591 | rep | MA | 1793-12-02 | 1795-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 87 | 87 | William Dawson D000157 | rep | NC | 1793-12-02 | 1795-03-03 | null | Anti-Administration | 8 | null | null | null | null | null | null | null | null | null | null | null | null |
| 88 | 88 | Benjamin Edwards E000060 | rep | MD | 1793-12-02 | 1795-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 89 | 89 | Thomas Fitzsimons F000178 | rep | PA | 1789-03-04 | 1791-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 90 | 90 | Thomas Fitzsimons F000178 | rep | PA | 1791-10-24 | 1793-03-03 | null | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 91 | 91 | Thomas Fitzsimons F000178 | rep | PA | 1793-12-02 | 1795-03-03 | null | null | -1 | null | null | null | null | null | null | null | null | null | null | null | null |
| 92 | 92 | Uriah Forrest F000282 | rep | MD | 1793-12-02 | 1795-03-03 | null | null | 3 | null | null | null | null | null | null | null | null | null | null | null | null |
| 93 | 93 | Frederick Frelinghuysen F000368 | sen | NJ | 1793-12-02 | 1797-03-03 | 2 | Federalist | null | null | null | null | null | null | null | null | null | null | null | null | null |
| 94 | 94 | Alexander Gillon G000211 | rep | SC | 1793-12-02 | 1795-03-03 | null | null | 5 | null | null | null | null | null | null | null | null | null | null | null | null |
| 95 | 95 | James Gordon G000311 | rep | NY | 1791-10-24 | 1793-03-03 | null | null | 6 | null | null | null | null | null | null | null | null | null | null | null | null |
| 96 | 96 | James Gordon G000311 | rep | NY | 1793-12-02 | 1795-03-03 | null | null | 9 | null | null | null | null | null | null | null | null | null | null | null | null |
| 97 | 97 | Samuel Griffin G000466 | rep | VA | 1789-03-04 | 1791-03-03 | null | null | 10 | null | null | null | null | null | null | null | null | null | null | null | null |
| 98 | 98 | Samuel Griffin G000466 | rep | VA | 1791-10-24 | 1793-03-03 | null | null | 10 | null | null | null | null | null | null | null | null | null | null | null | null |
| 99 | 99 | Samuel Griffin G000466 | rep | VA | 1793-12-02 | 1795-03-03 | null | null | 13 | null | null | null | null | null | null | null | null | null | null | null | null |
| 100 | 100 | Samuel Holten H000750 | rep | MA | 1793-12-02 | 1795-03-03 | null | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null |
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, [caucus] TEXT, [url] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);