legislator_terms

Table actions Table actions

1,394 rows where state = "NC"

✎ 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
14 14 H000368 sen NC 1789-03-04 1795-03-03 3 Pro-Administration                          
18 18 J000198 sen NC 1789-03-04 1793-03-03 2 Pro-Administration                          
31 31 A000307 rep NC 1789-03-04 1791-03-03     1                        
32 32 A000307 rep NC 1791-10-24 1793-03-03     3                        
57 57 S000832 rep NC 1789-03-04 1791-03-03     4                        
58 58 S000832 rep NC 1791-10-24 1793-03-03     1                        
67 67 W000551 rep NC 1789-03-04 1791-03-03   Federalist 2                        
68 68 W000551 rep NC 1791-10-24 1793-03-03   Federalist 4                        
87 87 D000157 rep NC 1793-12-02 1795-03-03   Anti-Administration 8                        
107 107 M000166 sen NC 1793-12-02 1799-03-03 2 Republican                          
108 108 M000424 rep NC 1793-12-02 1795-03-03     1                        
109 109 M000622 rep NC 1793-12-02 1795-03-03     4                        
136 136 W000491 rep NC 1793-12-02 1795-03-03     10                        
146 146 B000563 rep NC 1789-03-04 1791-03-03     3                        
147 147 B000563 sen NC 1795-12-07 1801-03-03 3 Republican                          
214 214 S001029 rep NC 1795-12-07 1797-03-03   Federalist 4                        
217 217 T000050 rep NC 1795-12-07 1797-03-03   Republican 4                        
246 246 B000991 rep NC 1795-12-07 1797-03-03   Republican 10                        
247 247 B000991 rep NC 1797-05-15 1799-03-03   Republican 10                        
249 249 B001081 rep NC 1795-12-07 1797-03-03   Republican 8                        
250 250 B001081 rep NC 1797-05-15 1799-03-03   Republican 8                        
274 274 L000389 rep NC 1793-12-02 1795-03-03   Republican 2                        
275 275 L000389 rep NC 1795-12-07 1797-03-03   Republican 2                        
276 276 L000389 rep NC 1797-05-15 1799-03-03   Republican 2                        
282 282 M000423 rep NC 1797-05-15 1799-03-03   Republican 1                        
354 354 D000331 rep NC 1799-12-02 1801-03-03   Federalist 1                        
431 431 S000693 rep NC 1797-05-15 1799-03-03   Republican 10                        
432 432 S000693 rep NC 1799-12-02 1801-03-03   Republican 10                        
479 479 G000502 rep NC 1791-10-24 1793-03-03   Federalist 5                        
480 480 G000502 rep NC 1793-12-02 1795-03-03   Federalist 7                        
481 481 G000502 rep NC 1795-12-07 1797-03-03   Federalist 7                        
482 482 G000502 rep NC 1797-05-15 1799-03-03   Federalist 7                        
483 483 G000502 rep NC 1799-12-02 1801-03-03   Federalist 7                        
484 484 G000502 rep NC 1801-12-07 1803-03-03   Federalist 7                        
485 485 H000475 rep NC 1799-12-02 1801-03-03   Federalist 2                        
486 486 H000475 rep NC 1801-12-07 1803-03-03   Federalist 2                        
487 487 H000611 rep NC 1799-12-02 1801-03-03   Federalist 6                        
488 488 H000611 rep NC 1801-12-07 1803-03-03   Federalist 6                        
496 496 J000123 rep NC 1801-12-07 1803-03-03   Republican 8                        
543 543 W000534 rep NC 1797-05-15 1799-03-03   Republican 3                        
544 544 W000534 rep NC 1799-12-02 1801-03-03   Republican 3                        
545 545 W000534 rep NC 1801-12-07 1803-03-03   Republican 3                        
575 575 G000196 rep NC 1793-12-02 1795-03-03   Anti-Administration 6                        
576 576 G000196 rep NC 1795-12-07 1797-03-03   Republican 6                        
577 577 G000196 rep NC 1797-05-15 1799-03-03   Republican 6                        
578 578 G000196 rep NC 1803-10-17 1805-03-03   Republican 5                        
609 609 P000577 rep NC 1803-10-17 1805-03-03   Federalist 7                        
650 650 A000100 rep NC 1803-03-04 1805-03-03   Republican 10                        
729 729 M000437 rep NC 1805-12-02 1807-03-03   Republican 7                        
786 786 W000642 rep NC 1793-12-02 1795-03-03   Republican 3                        
787 787 W000642 rep NC 1803-10-17 1805-03-03   Republican 12                        
788 788 W000642 rep NC 1805-12-02 1807-03-03   Republican 12                        
789 789 W000786 rep NC 1801-12-07 1803-03-03   Republican 8                        
790 790 W000786 rep NC 1803-10-17 1805-03-03   Republican 1                        
791 791 W000786 rep NC 1805-12-02 1807-03-03   Republican 1                        
798 798 A000092 rep NC 1806-02-24 1807-03-03   Republican 10                        
799 799 A000092 rep NC 1807-10-26 1809-03-03   Republican 10                        
835 835 F000344 rep NC 1795-12-07 1797-03-03   Republican 3                        
836 836 F000344 sen NC 1799-12-02 1805-03-03 2 Republican                          
837 837 F000344 sen NC 1807-10-26 1813-03-03 3 Republican                          
923 923 W000529 rep NC 1803-10-17 1805-03-03   Republican 9                        
924 924 W000529 rep NC 1805-12-02 1807-03-03   Republican 9                        
925 925 W000529 rep NC 1807-10-26 1809-03-03   Republican 9                        
990 990 H000718 rep NC 1795-12-07 1797-03-03   Republican 1                        
991 991 H000718 rep NC 1801-12-07 1803-03-03   Republican 1                        
992 992 H000718 rep NC 1803-10-17 1805-03-03   Republican 11                        
993 993 H000718 rep NC 1805-12-02 1807-03-03   Republican 11                        
994 994 H000718 rep NC 1807-10-26 1809-03-03   Republican 11                        
995 995 H000718 rep NC 1809-05-22 1811-03-03   Republican 11                        
1006 1006 K000089 rep NC 1805-12-02 1807-03-03   Republican 5                        
1007 1007 K000089 rep NC 1807-10-26 1809-03-03   Republican 5                        
1008 1008 K000089 rep NC 1809-05-22 1811-03-03   Republican 5                        
1066 1066 S000800 rep NC 1801-12-07 1803-03-03   Federalist 10                        
1067 1067 S000800 rep NC 1809-05-22 1811-03-03   Federalist 4                        
1107 1107 B000511 rep NC 1803-10-17 1805-03-03   Republican 4                        
1108 1108 B000511 rep NC 1805-12-02 1807-03-03   Republican 4                        
1109 1109 B000511 rep NC 1807-10-26 1809-03-03   Republican 4                        
1110 1110 B000511 rep NC 1811-11-04 1813-03-03   Republican 4                        
1112 1112 B000569 rep NC 1793-12-02 1795-03-03   Republican 9                        
1113 1113 B000569 rep NC 1795-12-07 1797-03-03   Republican 9                        
1114 1114 B000569 rep NC 1797-05-15 1799-03-03   Republican 9                        
1115 1115 B000569 rep NC 1805-12-02 1807-03-03   Republican 3                        
1116 1116 B000569 rep NC 1807-10-26 1809-03-03   Republican 3                        
1117 1117 B000569 rep NC 1811-11-04 1813-03-03   Republican 3                        
1137 1137 C000564 rep NC 1809-05-22 1811-03-03   Republican 9                        
1138 1138 C000564 rep NC 1811-11-04 1813-03-03   Republican 9                        
1190 1190 M000302 rep NC 1809-05-22 1811-03-03   Federalist 7                        
1191 1191 M000302 rep NC 1811-11-04 1813-03-03   Federalist 7                        
1243 1243 T000423 sen NC 1805-12-02 1811-03-03 2 Republican                          
1244 1244 T000423 sen NC 1811-11-04 1817-03-03 2 Republican                          
1337 1337 F000279 rep NC 1813-05-24 1815-03-03   Republican 11                        
1338 1338 F000346 rep NC 1807-10-26 1809-03-03   Republican 12                        
1339 1339 F000346 rep NC 1809-05-22 1811-03-03   Republican 12                        
1340 1340 F000346 rep NC 1811-11-04 1813-03-03   Republican 12                        
1341 1341 F000346 rep NC 1813-05-24 1815-03-03   Republican 13                        
1366 1366 K000116 rep NC 1803-10-17 1805-03-03   Republican 3                        
1367 1367 K000116 rep NC 1809-05-22 1811-03-03   Republican 3                        
1368 1368 K000116 rep NC 1813-05-24 1815-03-03   Republican 3                        
1379 1379 P000168 rep NC 1809-05-22 1811-03-03   Federalist 10                        
1380 1380 P000168 rep NC 1811-11-04 1813-03-03   Federalist 10                        

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