legislator_terms

Table actions Table actions

45 rows where party = "Democratic Republican"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: legislator_id, type, state, start, end, class, 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
178 178 L000067 sen NH 1789-03-04 1795-03-03 3 Democratic Republican                          
512 512 M001066 sen PA 1801-12-07 1801-12-31 3 Democratic Republican                          
548 548 B001186 sen SC 1789-03-04 1793-03-03 2 Democratic Republican                          
613 613 S000557 rep VT 1791-10-24 1793-03-03   Democratic Republican 1                        
614 614 S000557 rep VT 1793-12-02 1795-03-03   Democratic Republican 1                        
631 631 V000083 rep VA 1791-10-24 1793-03-03   Democratic Republican 6                        
632 632 V000083 rep VA 1793-12-02 1795-03-03   Democratic Republican 7                        
645 645 M000891 rep VA 1789-03-04 1791-03-03   Democratic Republican 3                        
646 646 M000891 rep VA 1791-10-24 1793-03-03   Democratic Republican 3                        
647 647 M000891 rep VA 1793-12-02 1795-03-03   Democratic Republican 2                        
656 656 B000084 rep GA 1789-03-04 1791-03-03   Democratic Republican 2                        
657 657 B000084 rep GA 1791-10-24 1793-03-03   Democratic Republican 2                        
658 658 B000084 rep GA 1793-12-02 1795-03-03   Democratic Republican 0                        
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                        
845 845 G000442 rep PA 1791-10-24 1793-03-03   Democratic Republican 6                        
846 846 G000442 rep PA 1793-12-02 1795-03-03   Democratic Republican -1                        
1164 1164 G000215 rep NH 1789-03-04 1791-03-03   Democratic Republican -1                        
1165 1165 G000215 rep NH 1791-10-24 1793-03-03   Democratic Republican -1                        
1166 1166 G000215 rep NH 1793-12-02 1795-03-03   Democratic Republican -1                        
1246 1246 V000074 rep MA 1795-12-07 1797-03-03   Democratic Republican 9                        
1247 1247 V000074 rep MA 1797-05-15 1799-03-03   Democratic Republican 9                        
1248 1248 V000074 rep MA 1799-12-02 1801-03-03   Democratic Republican 9                        
1249 1249 V000074 rep MA 1801-12-07 1803-03-03   Democratic Republican 9                        
1250 1250 V000074 rep MA 1803-10-17 1805-03-03   Democratic Republican 4                        
1251 1251 V000074 rep MA 1805-12-02 1807-03-03   Democratic Republican 4                        
1252 1252 V000074 rep MA 1807-10-26 1809-03-03   Democratic Republican 4                        
1253 1253 V000074 rep MA 1809-05-22 1811-03-03   Democratic Republican 4                        
1254 1254 V000074 sen MA 1811-11-04 1817-03-03 2 Democratic Republican                          
1812 1812 C000408 sen LA 1817-12-01 1817-12-31 2 Democratic Republican                          
2301 2301 P000362 rep MD 1791-10-24 1793-03-03   Democratic Republican 3                        
2499 2499 T000171 rep IN 1807-10-26 1809-03-03   Democratic Republican -1                        
2664 2664 M000034 rep NC 1791-10-24 1793-03-03   Democratic Republican 2                        
2665 2665 M000034 rep NC 1793-12-02 1795-03-03   Democratic Republican 5                        
2957 2957 S000609 rep MD 1793-12-02 1795-03-03   Democratic Republican 5                        
3022 3022 J000005 sen TN 1823-12-01 1825-12-31 2 Democratic Republican                          
3132 3132 H000739 rep MA 1817-12-01 1819-03-03   Democratic Republican 14                        
3133 3133 H000739 rep MA 1819-12-06 1820-03-15   Democratic Republican 14                        
3134 3134 H000739 sen ME 1820-06-13 1821-03-03 1 Democratic Republican                          
3135 3135 H000739 sen ME 1821-03-06 1827-03-03 1 Democratic Republican                          
3387 3387 F000284 rep GA 1823-12-01 1825-03-03   Democratic Republican -1                        
5636 5636 C000044 rep SC 1817-12-01 1819-03-03   Democratic Republican -1                        
5935 5935 C000482 rep KY 1823-12-01 1825-03-03   Democratic Republican 3                        
5936 5936 C000482 rep KY 1825-12-05 1827-03-03   Democratic Republican -1                        
6964 6964 B001005 rep PA 1823-12-01 1825-03-03   Democratic Republican 4                        

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