legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,268 rows where state = "NJ" sorted by office
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, phone, state_rank, rss_url, start (date), end (date)
party 13 ✖
- Republican 633
- Democrat 505
- Whig 35
- Federalist 28
- Jackson 18
- Adams 13
- Ind. Republican-Democrat 4
- Pro-Administration 3
- Anti Jacksonian 2
- Anti-Lecompton Democrat 2
- Democratic Republican 2
- Anti-Jacksonian 1
- Ind. Whig 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8 | 8 | Jonathan Elmer E000155 | sen | NJ | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
24 | 24 | William Paterson P000102 | sen | NJ | 1789-03-04 | 1791-03-03 | 2 | Pro-Administration | |||||||||||||
29 | 29 | Philemon Dickinson D000324 | sen | NJ | 1790-01-01 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
73 | 73 | John Beatty B000282 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
74 | 74 | Elias Boudinot B000661 | rep | NJ | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
75 | 75 | Elias Boudinot B000661 | rep | NJ | 1791-10-24 | 1793-03-03 | -1 | ||||||||||||||
76 | 76 | Elias Boudinot B000661 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
80 | 80 | Lambert Cadwalader C000012 | rep | NJ | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
81 | 81 | Lambert Cadwalader C000012 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
83 | 83 | Abraham Clark C000418 | rep | NJ | 1791-10-24 | 1793-03-03 | -1 | ||||||||||||||
84 | 84 | Abraham Clark C000418 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
93 | 93 | Frederick Frelinghuysen F000368 | sen | NJ | 1793-12-02 | 1797-03-03 | 2 | Federalist | |||||||||||||
175 | 175 | Thomas Henderson H000488 | rep | NJ | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
211 | 211 | Isaac Smith S000555 | rep | NJ | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
287 | 287 | John Rutherfurd R000550 | sen | NJ | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
288 | 288 | John Rutherfurd R000550 | sen | NJ | 1797-05-15 | 1799-03-03 | 1 | Federalist | |||||||||||||
291 | 291 | Thomas Sinnickson S000448 | rep | NJ | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
292 | 292 | Thomas Sinnickson S000448 | rep | NJ | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
310 | 310 | Mark Thomson T000232 | rep | NJ | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
311 | 311 | Mark Thomson T000232 | rep | NJ | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
341 | 341 | Franklin Davenport D000069 | sen | NJ | 1798-12-05 | 1799-03-03 | 1 | Federalist | |||||||||||||
342 | 342 | Franklin Davenport D000069 | rep | NJ | 1799-12-02 | 1801-03-03 | Federalist | 5 | |||||||||||||
343 | 343 | Jonathan Dayton D000165 | rep | NJ | 1791-10-24 | 1793-03-03 | Federalist | -1 | |||||||||||||
344 | 344 | Jonathan Dayton D000165 | rep | NJ | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
345 | 345 | Jonathan Dayton D000165 | rep | NJ | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
346 | 346 | Jonathan Dayton D000165 | rep | NJ | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
347 | 347 | Jonathan Dayton D000165 | sen | NJ | 1799-12-02 | 1805-03-03 | 2 | Federalist | |||||||||||||
385 | 385 | James Imlay I000011 | rep | NJ | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
386 | 386 | James Imlay I000011 | rep | NJ | 1799-12-02 | 1801-03-03 | Federalist | 4 | |||||||||||||
394 | 394 | James Linn L000336 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
513 | 513 | Aaron Ogden O000041 | sen | NJ | 1801-12-07 | 1803-03-03 | 1 | Federalist | |||||||||||||
601 | 601 | James Mott M001039 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
602 | 602 | James Mott M001039 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
688 | 688 | Ebenezer Elmer E000154 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
689 | 689 | Ebenezer Elmer E000154 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
690 | 690 | Ebenezer Elmer E000154 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
718 | 718 | Aaron Kitchell K000246 | rep | NJ | 1791-10-24 | 1793-03-03 | Democratic Republican | -1 | |||||||||||||
719 | 719 | Aaron Kitchell K000246 | rep | NJ | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
720 | 720 | Aaron Kitchell K000246 | rep | NJ | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
721 | 721 | Aaron Kitchell K000246 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
722 | 722 | Aaron Kitchell K000246 | sen | NJ | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
828 | 828 | Ezra Darby D000047 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
829 | 829 | Ezra Darby D000047 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
889 | 889 | James Sloan S000493 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
890 | 890 | James Sloan S000493 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
891 | 891 | James Sloan S000493 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
967 | 967 | James Cox C000834 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
977 | 977 | William Helms H000464 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
978 | 978 | William Helms H000464 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
979 | 979 | William Helms H000464 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
980 | 980 | William Helms H000464 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
981 | 981 | William Helms H000464 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1010 | 1010 | John Lambert L000036 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
1011 | 1011 | John Lambert L000036 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
1012 | 1012 | John Lambert L000036 | sen | NJ | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1059 | 1059 | John Scudder S000200 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1118 | 1118 | Adam Boyd B000714 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
1119 | 1119 | Adam Boyd B000714 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
1120 | 1120 | Adam Boyd B000714 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1121 | 1121 | Adam Boyd B000714 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1189 | 1189 | George Maxwell M000267 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1202 | 1202 | James Morgan M000951 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1203 | 1203 | Thomas Newbold N000064 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
1204 | 1204 | Thomas Newbold N000064 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1205 | 1205 | Thomas Newbold N000064 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1288 | 1288 | Thomas Bines B000467 | rep | NJ | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1311 | 1311 | William Coxe C000843 | rep | NJ | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1356 | 1356 | Jacob Hufty H000914 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | 0 | |||||||||||||
1357 | 1357 | Jacob Hufty H000914 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | 0 | |||||||||||||
1358 | 1358 | Jacob Hufty H000914 | rep | NJ | 1813-05-24 | 1814-05-20 | Federalist | 3 | |||||||||||||
1397 | 1397 | James Schureman S000150 | rep | NJ | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
1398 | 1398 | James Schureman S000150 | rep | NJ | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
1399 | 1399 | James Schureman S000150 | sen | NJ | 1799-12-02 | 1801-12-31 | 1 | Federalist | |||||||||||||
1400 | 1400 | James Schureman S000150 | rep | NJ | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1414 | 1414 | Richard Stockton S000941 | sen | NJ | 1796-01-01 | 1799-03-03 | 2 | Federalist | |||||||||||||
1415 | 1415 | Richard Stockton S000941 | rep | NJ | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1457 | 1457 | Ezra Baker B000060 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1760 | 1760 | Thomas Ward W000141 | rep | NJ | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1761 | 1761 | Thomas Ward W000141 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1770 | 1770 | James Wilson W000595 | sen | NJ | 1815-12-04 | 1821-01-08 | 1 | Republican | |||||||||||||
1800 | 1800 | Benjamin Bennet B000368 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1801 | 1801 | Benjamin Bennet B000368 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
1971 | 1971 | Joseph Bloomfield B000566 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
1972 | 1972 | Joseph Bloomfield B000566 | rep | NJ | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
1996 | 1996 | John Condit C000671 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
1997 | 1997 | John Condit C000671 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
1998 | 1998 | John Condit C000671 | sen | NJ | 1803-10-17 | 1809-03-03 | 1 | Republican | |||||||||||||
1999 | 1999 | John Condit C000671 | sen | NJ | 1809-05-22 | 1811-03-03 | 2 | Republican | |||||||||||||
2000 | 2000 | John Condit C000671 | sen | NJ | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
2001 | 2001 | John Condit C000671 | rep | NJ | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2055 | 2055 | Charles Kinsey K000227 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2056 | 2056 | Charles Kinsey K000227 | rep | NJ | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2059 | 2059 | John Linn L000337 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2060 | 2060 | John Linn L000337 | rep | NJ | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2137 | 2137 | Bernard Smith S000518 | rep | NJ | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2140 | 2140 | Henry Southard S000685 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
2141 | 2141 | Henry Southard S000685 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
2142 | 2142 | Henry Southard S000685 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
2143 | 2143 | Henry Southard S000685 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
2144 | 2144 | Henry Southard S000685 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 |
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);