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 party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
2445 | 2445 | James Matlack M000245 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2573 | 2573 | George Cassedy C000234 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2614 | 2614 | Daniel Garrison G000083 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2860 | 2860 | George Holcombe H000711 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3189 | 3189 | Isaac Pierson P000341 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3237 | 3237 | Samuel Swan S001088 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3240 | 3240 | Samuel Swan S001088 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3350 | 3350 | Richard Cooper C000760 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3351 | 3351 | Richard Cooper C000760 | rep | NJ | 1831-12-05 | 1833-03-03 | -1 | ||||||||||||||
3417 | 3417 | Thomas Hughes H000928 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3418 | 3418 | Thomas Hughes H000928 | rep | NJ | 1831-12-05 | 1833-03-03 | -1 | ||||||||||||||
3533 | 3533 | James Randolph R000044 | rep | NJ | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3534 | 3534 | James Randolph R000044 | rep | NJ | 1831-12-05 | 1833-03-03 | -1 | ||||||||||||||
2450 | 2450 | Joseph McIlvaine M000475 | sen | NJ | 1823-11-12 | 1826-08-19 | 1 | Adams | |||||||||||||
2748 | 2748 | Ephraim Bateman B000228 | sen | NJ | 1826-11-09 | 1827-03-03 | 1 | Adams | |||||||||||||
2749 | 2749 | Ephraim Bateman B000228 | sen | NJ | 1827-12-03 | 1829-01-12 | 1 | Adams | |||||||||||||
2951 | 2951 | Thomas Sinnickson S000449 | rep | NJ | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
2977 | 2977 | Hedge Thompson T000202 | rep | NJ | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
2978 | 2978 | Ebenezer Tucker T000396 | rep | NJ | 1825-12-05 | 1827-03-03 | Adams | -1 | |||||||||||||
2979 | 2979 | Ebenezer Tucker T000396 | rep | NJ | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
3188 | 3188 | Isaac Pierson P000341 | rep | NJ | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
3238 | 3238 | Samuel Swan S001088 | rep | NJ | 1825-12-05 | 1827-03-03 | Adams | -1 | |||||||||||||
3239 | 3239 | Samuel Swan S001088 | rep | NJ | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
3343 | 3343 | Lewis Condict C000668 | rep | NJ | 1825-12-05 | 1827-03-03 | Adams | -1 | |||||||||||||
3344 | 3344 | Lewis Condict C000668 | rep | NJ | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
3532 | 3532 | James Randolph R000044 | rep | NJ | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
3347 | 3347 | Silas Condit C000672 | rep | NJ | 1831-12-05 | 1833-03-03 | Anti Jacksonian | -1 | |||||||||||||
3546 | 3546 | Isaac Southard S000686 | rep | NJ | 1831-12-05 | 1833-03-03 | Anti Jacksonian | -1 | |||||||||||||
3104 | 3104 | Theodore Frelinghuysen F000373 | sen | NJ | 1829-12-07 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
7275 | 7275 | Garnett Adrain A000058 | rep | NJ | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 3 | |||||||||||||
7551 | 7551 | Jetur Riggs R000254 | rep | NJ | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 4 | |||||||||||||
4087 | 4087 | Garret Wall W000071 | sen | NJ | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4435 | 4435 | William Cooper C000766 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4460 | 4460 | Philemon Dickerson D000309 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4531 | 4531 | Joseph Kille K000178 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4606 | 4606 | Daniel Ryall R000554 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4632 | 4632 | Peter Vroom V000123 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
5197 | 5197 | Lucius Elmer E000156 | rep | NJ | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5198 | 5198 | Isaac Farlee F000017 | rep | NJ | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5241 | 5241 | Littleton Kirkpatrick K000236 | rep | NJ | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5536 | 5536 | George Sykes S001131 | rep | NJ | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5537 | 5537 | George Sykes S001131 | rep | NJ | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5684 | 5684 | Joseph Edsall E000059 | rep | NJ | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5685 | 5685 | Joseph Edsall E000059 | rep | NJ | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
6389 | 6389 | Rodman Price P000529 | rep | NJ | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6426 | 6426 | Robert Stockton S000942 | sen | NJ | 1851-12-01 | 1853-12-31 | 1 | Democrat | |||||||||||||
6454 | 6454 | Isaac Wildrick W000464 | rep | NJ | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6455 | 6455 | Isaac Wildrick W000464 | rep | NJ | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6641 | 6641 | Samuel Lilly L000310 | rep | NJ | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6690 | 6690 | Charles Skelton S000464 | rep | NJ | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6691 | 6691 | Charles Skelton S000464 | rep | NJ | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6706 | 6706 | Nathan Stratton S000996 | rep | NJ | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6707 | 6707 | Nathan Stratton S000996 | rep | NJ | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6937 | 6937 | George Vail V000001 | rep | NJ | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6938 | 6938 | George Vail V000001 | rep | NJ | 1855-12-03 | 1857-03-03 | Democrat | 4 | |||||||||||||
7098 | 7098 | John Huyler H001020 | rep | NJ | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7236 | 7236 | John Thomson T000231 | sen | NJ | 1853-12-05 | 1857-03-03 | 1 | Democrat | |||||||||||||
7237 | 7237 | John Thomson T000231 | sen | NJ | 1857-12-07 | 1863-03-03 | 1 | Democrat | |||||||||||||
7253 | 7253 | Jacob Wortendyke W000746 | rep | NJ | 1857-12-07 | 1859-03-03 | Democrat | 5 | |||||||||||||
7274 | 7274 | Garnett Adrain A000058 | rep | NJ | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7700 | 7700 | George Cobb C000546 | rep | NJ | 1861-07-04 | 1863-03-03 | Democrat | 4 | |||||||||||||
7999 | 7999 | George Middleton M000697 | rep | NJ | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
8019 | 8019 | Nehemiah Perry P000244 | rep | NJ | 1861-07-04 | 1863-03-03 | Democrat | 5 | |||||||||||||
8020 | 8020 | Nehemiah Perry P000244 | rep | NJ | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
8039 | 8039 | William Steele S000839 | rep | NJ | 1861-07-04 | 1863-03-03 | Democrat | 3 | |||||||||||||
8040 | 8040 | William Steele S000839 | rep | NJ | 1863-12-07 | 1865-03-03 | Democrat | 3 | |||||||||||||
8055 | 8055 | James Wall W000072 | sen | NJ | 1863-12-07 | 1863-12-31 | 1 | Democrat | |||||||||||||
8066 | 8066 | William Wright W000772 | sen | NJ | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
8067 | 8067 | William Wright W000772 | sen | NJ | 1863-12-07 | 1867-03-03 | 1 | Democrat | |||||||||||||
8196 | 8196 | Andrew Rogers R000387 | rep | NJ | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
8197 | 8197 | Andrew Rogers R000387 | rep | NJ | 1865-12-04 | 1867-03-03 | Democrat | 4 | |||||||||||||
8239 | 8239 | Edwin Wright W000758 | rep | NJ | 1865-12-04 | 1867-03-03 | Democrat | 5 | |||||||||||||
8443 | 8443 | Charles Sitgreaves S000458 | rep | NJ | 1865-12-04 | 1867-03-03 | Democrat | 3 | |||||||||||||
8444 | 8444 | Charles Sitgreaves S000458 | rep | NJ | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8554 | 8554 | Orestes Cleveland C000514 | rep | NJ | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8611 | 8611 | Charles Haight H000020 | rep | NJ | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8612 | 8612 | Charles Haight H000020 | rep | NJ | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8731 | 8731 | John Stockton S000939 | sen | NJ | 1865-12-04 | 1867-03-03 | 2 | Democrat | |||||||||||||
8732 | 8732 | John Stockton S000939 | sen | NJ | 1869-03-04 | 1875-03-03 | 1 | Democrat | |||||||||||||
8823 | 8823 | John Bird B000478 | rep | NJ | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8824 | 8824 | John Bird B000478 | rep | NJ | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
8896 | 8896 | Samuel Forker F000274 | rep | NJ | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
9512 | 9512 | Robert Hamilton H000117 | rep | NJ | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9513 | 9513 | Robert Hamilton H000117 | rep | NJ | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9617 | 9617 | Theodore Randolph R000050 | sen | NJ | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
9650 | 9650 | Frederick Teese T000111 | rep | NJ | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9779 | 9779 | Augustus Cutler C001025 | rep | NJ | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9780 | 9780 | Augustus Cutler C001025 | rep | NJ | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10037 | 10037 | Alvah Clark C000419 | rep | NJ | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10038 | 10038 | Alvah Clark C000419 | rep | NJ | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10196 | 10196 | Hezekiah Smith S000549 | rep | NJ | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10366 | 10366 | Augustus Hardenbergh H000183 | rep | NJ | 1875-12-06 | 1877-03-03 | Democrat | 7 |
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);