legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
633 rows where party = "Republican" and state = "NJ"
This data as json, copyable, CSV (advanced)
Suggested facets: class, fax, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
394 | 394 | James Linn L000336 | rep | NJ | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2145 | 2145 | Henry Southard S000685 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
2146 | 2146 | Henry Southard S000685 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2147 | 2147 | Henry Southard S000685 | rep | NJ | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2444 | 2444 | James Matlack M000245 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2572 | 2572 | George Cassedy C000234 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2744 | 2744 | Ephraim Bateman B000228 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
2745 | 2745 | Ephraim Bateman B000228 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2746 | 2746 | Ephraim Bateman B000228 | rep | NJ | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2747 | 2747 | Ephraim Bateman B000228 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2859 | 2859 | George Holcombe H000711 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3079 | 3079 | Mahlon Dickerson D000308 | sen | NJ | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
3236 | 3236 | Samuel Swan S001088 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3338 | 3338 | Lewis Condict C000668 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
3339 | 3339 | Lewis Condict C000668 | rep | NJ | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
3340 | 3340 | Lewis Condict C000668 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
3341 | 3341 | Lewis Condict C000668 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3342 | 3342 | Lewis Condict C000668 | rep | NJ | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
3345 | 3345 | Lewis Condict C000668 | rep | NJ | 1829-12-07 | 1831-03-03 | Republican | -1 | |||||||||||||
3346 | 3346 | Lewis Condict C000668 | rep | NJ | 1831-12-05 | 1833-03-03 | Republican | -1 | |||||||||||||
4612 | 4612 | Samuel Southard S000689 | sen | NJ | 1821-01-26 | 1821-03-03 | 1 | Republican | |||||||||||||
4613 | 4613 | Samuel Southard S000689 | sen | NJ | 1821-03-06 | 1823-03-03 | 1 | Republican | |||||||||||||
7013 | 7013 | Isaiah Clawson C000477 | rep | NJ | 1857-12-07 | 1859-03-03 | Republican | 1 | |||||||||||||
7204 | 7204 | George Robbins R000300 | rep | NJ | 1857-12-07 | 1859-03-03 | Republican | 2 | |||||||||||||
7535 | 7535 | William Pennington P000214 | rep | NJ | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7600 | 7600 | John Ten Eyck T000122 | sen | NJ | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
7813 | 7813 | John Nixon N000115 | rep | NJ | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7814 | 7814 | John Nixon N000115 | rep | NJ | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
7857 | 7857 | John Stratton S000995 | rep | NJ | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7858 | 7858 | John Stratton S000995 | rep | NJ | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
7895 | 7895 | Richard Field F000106 | sen | NJ | 1862-01-01 | 1863-03-03 | 1 | Republican | |||||||||||||
8181 | 8181 | William Newell N000066 | rep | NJ | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8206 | 8206 | John Starr S000817 | rep | NJ | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8207 | 8207 | John Starr S000817 | rep | NJ | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8243 | 8243 | Alexander Cattell C000254 | sen | NJ | 1866-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8673 | 8673 | William Moore M000922 | rep | NJ | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8674 | 8674 | William Moore M000922 | rep | NJ | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8900 | 8900 | Frederick Frelinghuysen F000369 | sen | NJ | 1866-01-01 | 1869-03-03 | 1 | Republican | |||||||||||||
8901 | 8901 | Frederick Frelinghuysen F000369 | sen | NJ | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8917 | 8917 | George Halsey H000087 | rep | NJ | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8918 | 8918 | George Halsey H000087 | rep | NJ | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
9117 | 9117 | Amos Clark C000421 | rep | NJ | 1873-12-01 | 1875-03-03 | Republican | 3 |
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);