legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
505 rows where party = "Democrat" and state = "NJ"
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, phone, contact_form, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
10367 | 10367 | Augustus Hardenbergh H000183 | rep | NJ | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
10368 | 10368 | Augustus Hardenbergh H000183 | rep | NJ | 1881-12-05 | 1883-03-03 | Democrat | 7 | |||||||||||||
10374 | 10374 | Henry Harris H000240 | rep | NJ | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
10522 | 10522 | Miles Ross R000452 | rep | NJ | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
10523 | 10523 | Miles Ross R000452 | rep | NJ | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10524 | 10524 | Miles Ross R000452 | rep | NJ | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10525 | 10525 | Miles Ross R000452 | rep | NJ | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
10719 | 10719 | Thomas Ferrell F000089 | rep | NJ | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10720 | 10720 | William Fiedler F000103 | rep | NJ | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
11051 | 11051 | Robert Green G000416 | rep | NJ | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11299 | 11299 | Rufus Blodgett B000562 | sen | NJ | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
11476 | 11476 | James Pidcock P000331 | rep | NJ | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11477 | 11477 | James Pidcock P000331 | rep | NJ | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
11839 | 11839 | William McAdoo M000292 | rep | NJ | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
11840 | 11840 | William McAdoo M000292 | rep | NJ | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
11841 | 11841 | William McAdoo M000292 | rep | NJ | 1887-12-05 | 1889-03-03 | Democrat | 7 | |||||||||||||
11842 | 11842 | William McAdoo M000292 | rep | NJ | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
11850 | 11850 | John McPherson M000593 | sen | NJ | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
11851 | 11851 | John McPherson M000593 | sen | NJ | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11852 | 11852 | John McPherson M000593 | sen | NJ | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
12173 | 12173 | Samuel Fowler F000326 | rep | NJ | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12174 | 12174 | Samuel Fowler F000326 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12237 | 12237 | Edward McDonald M000409 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12462 | 12462 | Cornelius Cadmus C000010 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12463 | 12463 | Cornelius Cadmus C000010 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12504 | 12504 | Johnston Cornish C000786 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12517 | 12517 | John Dunn D000550 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12529 | 12529 | Thomas English E000188 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12530 | 12530 | Thomas English E000188 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12545 | 12545 | George Fielder F000109 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12569 | 12569 | Jacob Geissenhainer G000119 | rep | NJ | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12570 | 12570 | Jacob Geissenhainer G000119 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12571 | 12571 | Jacob Geissenhainer G000119 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12790 | 12790 | James Smith S000561 | sen | NJ | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13627 | 13627 | William Daly D000015 | rep | NJ | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
13955 | 13955 | De Flanagan F000185 | rep | NJ | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14153 | 14153 | Joshua Salmon S000017 | rep | NJ | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
14154 | 14154 | Joshua Salmon S000017 | rep | NJ | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14246 | 14246 | Allan Benny B000385 | rep | NJ | 1903-11-09 | 1905-03-03 | Democrat | 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);