legislator_terms

Table actions Table actions

1,297 rows where state = "NJ"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, class, party, district, start (date), end (date)

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
8 8 E000155 sen NJ 1789-03-04 1791-03-03 1 Pro-Administration                          
24 24 P000102 sen NJ 1789-03-04 1791-03-03 2 Pro-Administration                          
29 29 D000324 sen NJ 1790-01-01 1793-03-03 2 Pro-Administration                          
73 73 B000282 rep NJ 1793-12-02 1795-03-03     -1                        
74 74 B000661 rep NJ 1789-03-04 1791-03-03     -1                        
75 75 B000661 rep NJ 1791-10-24 1793-03-03     -1                        
76 76 B000661 rep NJ 1793-12-02 1795-03-03     -1                        
80 80 C000012 rep NJ 1789-03-04 1791-03-03     -1                        
81 81 C000012 rep NJ 1793-12-02 1795-03-03     -1                        
83 83 C000418 rep NJ 1791-10-24 1793-03-03     -1                        
84 84 C000418 rep NJ 1793-12-02 1795-03-03     -1                        
93 93 F000368 sen NJ 1793-12-02 1797-03-03 2 Federalist                          
175 175 H000488 rep NJ 1795-12-07 1797-03-03   Federalist -1                        
211 211 S000555 rep NJ 1795-12-07 1797-03-03   Federalist -1                        
287 287 R000550 sen NJ 1791-10-24 1797-03-03 1 Federalist                          
288 288 R000550 sen NJ 1797-05-15 1799-03-03 1 Federalist                          
291 291 S000448 rep NJ 1789-03-04 1791-03-03   Federalist -1                        
292 292 S000448 rep NJ 1797-05-15 1799-03-03   Federalist -1                        
310 310 T000232 rep NJ 1795-12-07 1797-03-03   Federalist -1                        
311 311 T000232 rep NJ 1797-05-15 1799-03-03   Federalist -1                        
341 341 D000069 sen NJ 1798-12-05 1799-03-03 1 Federalist                          
342 342 D000069 rep NJ 1799-12-02 1801-03-03   Federalist 5                        
343 343 D000165 rep NJ 1791-10-24 1793-03-03   Federalist -1                        
344 344 D000165 rep NJ 1793-12-02 1795-03-03   Federalist -1                        
345 345 D000165 rep NJ 1795-12-07 1797-03-03   Federalist -1                        
346 346 D000165 rep NJ 1797-05-15 1799-03-03   Federalist -1                        
347 347 D000165 sen NJ 1799-12-02 1805-03-03 2 Federalist                          
385 385 I000011 rep NJ 1797-05-15 1799-03-03   Federalist -1                        
386 386 I000011 rep NJ 1799-12-02 1801-03-03   Federalist 4                        
394 394 L000336 rep NJ 1799-12-02 1801-03-03   Republican 3                        
513 513 O000041 sen NJ 1801-12-07 1803-03-03 1 Federalist                          
601 601 M001039 rep NJ 1801-12-07 1803-03-03   Republican -1                        
602 602 M001039 rep NJ 1803-10-17 1805-03-03   Republican -1                        
688 688 E000154 rep NJ 1801-12-07 1803-03-03   Republican -1                        
689 689 E000154 rep NJ 1803-10-17 1805-03-03   Republican -1                        
690 690 E000154 rep NJ 1805-12-02 1807-03-03   Republican -1                        
718 718 K000246 rep NJ 1791-10-24 1793-03-03   Democratic Republican -1                        
719 719 K000246 rep NJ 1793-12-02 1795-03-03   Democratic Republican -1                        
720 720 K000246 rep NJ 1795-12-07 1797-03-03   Federalist -1                        
721 721 K000246 rep NJ 1799-12-02 1801-03-03   Republican 2                        
722 722 K000246 sen NJ 1805-12-02 1809-12-31 2 Republican                          
828 828 D000047 rep NJ 1805-12-02 1807-03-03   Republican -1                        
829 829 D000047 rep NJ 1807-10-26 1809-03-03   Republican -1                        
889 889 S000493 rep NJ 1803-10-17 1805-03-03   Republican -1                        
890 890 S000493 rep NJ 1805-12-02 1807-03-03   Republican -1                        
891 891 S000493 rep NJ 1807-10-26 1809-03-03   Republican -1                        
967 967 C000834 rep NJ 1809-05-22 1811-03-03   Republican -1                        
977 977 H000464 rep NJ 1801-12-07 1803-03-03   Republican -1                        
978 978 H000464 rep NJ 1803-10-17 1805-03-03   Republican -1                        
979 979 H000464 rep NJ 1805-12-02 1807-03-03   Republican -1                        
980 980 H000464 rep NJ 1807-10-26 1809-03-03   Republican -1                        
981 981 H000464 rep NJ 1809-05-22 1811-03-03   Republican -1                        
1010 1010 L000036 rep NJ 1805-12-02 1807-03-03   Republican -1                        
1011 1011 L000036 rep NJ 1807-10-26 1809-03-03   Republican -1                        
1012 1012 L000036 sen NJ 1809-05-22 1815-03-03 1 Republican                          
1059 1059 S000200 rep NJ 1809-05-22 1811-03-03   Republican -1                        
1118 1118 B000714 rep NJ 1803-10-17 1805-03-03   Republican -1                        
1119 1119 B000714 rep NJ 1807-10-26 1809-03-03   Republican -1                        
1120 1120 B000714 rep NJ 1809-05-22 1811-03-03   Republican -1                        
1121 1121 B000714 rep NJ 1811-11-04 1813-03-03   Republican -1                        
1189 1189 M000267 rep NJ 1811-11-04 1813-03-03   Republican -1                        
1202 1202 M000951 rep NJ 1811-11-04 1813-03-03   Republican -1                        
1203 1203 N000064 rep NJ 1807-10-26 1809-03-03   Republican -1                        
1204 1204 N000064 rep NJ 1809-05-22 1811-03-03   Republican -1                        
1205 1205 N000064 rep NJ 1811-11-04 1813-03-03   Republican -1                        
1288 1288 B000467 rep NJ 1813-05-24 1815-03-03   Republican 3                        
1311 1311 C000843 rep NJ 1813-05-24 1815-03-03   Federalist 3                        
1356 1356 H000914 rep NJ 1809-05-22 1811-03-03   Republican 0                        
1357 1357 H000914 rep NJ 1811-11-04 1813-03-03   Republican 0                        
1358 1358 H000914 rep NJ 1813-05-24 1814-05-20   Federalist 3                        
1397 1397 S000150 rep NJ 1789-03-04 1791-03-03   Federalist -1                        
1398 1398 S000150 rep NJ 1797-05-15 1799-03-03   Federalist -1                        
1399 1399 S000150 sen NJ 1799-12-02 1801-12-31 1 Federalist                          
1400 1400 S000150 rep NJ 1813-05-24 1815-03-03   Federalist 2                        
1414 1414 S000941 sen NJ 1796-01-01 1799-03-03 2 Federalist                          
1415 1415 S000941 rep NJ 1813-05-24 1815-03-03   Federalist 2                        
1457 1457 B000060 rep NJ 1815-12-04 1817-03-03   Republican -1                        
1760 1760 W000141 rep NJ 1813-05-24 1815-03-03   Republican 1                        
1761 1761 W000141 rep NJ 1815-12-04 1817-03-03   Republican -1                        
1770 1770 W000595 sen NJ 1815-12-04 1821-01-08 1 Republican                          
1800 1800 B000368 rep NJ 1815-12-04 1817-03-03   Republican -1                        
1801 1801 B000368 rep NJ 1817-12-01 1819-03-03   Republican -1                        
1971 1971 B000566 rep NJ 1817-12-01 1819-03-03   Republican -1                        
1972 1972 B000566 rep NJ 1819-12-06 1821-03-03   Republican -1                        
1996 1996 C000671 rep NJ 1799-12-02 1801-03-03   Republican 1                        
1997 1997 C000671 rep NJ 1801-12-07 1803-03-03   Republican -1                        
1998 1998 C000671 sen NJ 1803-10-17 1809-03-03 1 Republican                          
1999 1999 C000671 sen NJ 1809-05-22 1811-03-03 2 Republican                          
2000 2000 C000671 sen NJ 1811-11-04 1817-03-03 2 Republican                          
2001 2001 C000671 rep NJ 1819-12-06 1821-03-03   Republican -1                        
2055 2055 K000227 rep NJ 1817-12-01 1819-03-03   Republican -1                        
2056 2056 K000227 rep NJ 1819-12-06 1821-03-03   Republican -1                        
2059 2059 L000337 rep NJ 1817-12-01 1819-03-03   Republican -1                        
2060 2060 L000337 rep NJ 1819-12-06 1821-03-03   Republican -1                        
2137 2137 S000518 rep NJ 1819-12-06 1821-03-03   Republican -1                        
2140 2140 S000685 rep NJ 1801-12-07 1803-03-03   Republican -1                        
2141 2141 S000685 rep NJ 1803-10-17 1805-03-03   Republican -1                        
2142 2142 S000685 rep NJ 1805-12-02 1807-03-03   Republican -1                        
2143 2143 S000685 rep NJ 1807-10-26 1809-03-03   Republican -1                        
2144 2144 S000685 rep NJ 1809-05-22 1811-03-03   Republican -1                        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);