legislator_terms

Table actions Table actions

21 rows where party = "Pro-Administration"

✎ 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
7 7 D000013 sen MA 1789-03-04 1791-03-03 1 Pro-Administration                          
8 8 E000155 sen NJ 1789-03-04 1791-03-03 1 Pro-Administration                          
14 14 H000368 sen NC 1789-03-04 1795-03-03 3 Pro-Administration                          
16 16 I000053 sen SC 1789-03-04 1795-03-03 3 Pro-Administration                          
17 17 J000182 sen CT 1789-03-04 1791-12-31 3 Pro-Administration                          
18 18 J000198 sen NC 1789-03-04 1793-03-03 2 Pro-Administration                          
22 22 M000985 sen PA 1789-03-04 1795-03-03 3 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                          
30 30 W000059 sen VA 1790-01-01 1791-03-03 1 Pro-Administration                          
36 36 C000185 sen MD 1789-03-04 1791-03-03 1 Pro-Administration                          
38 38 E000147 sen CT 1789-03-04 1791-03-03 1 Pro-Administration                          
46 46 R000091 sen DE 1789-03-04 1791-03-03 1 Pro-Administration                          
53 53 S000349 rep CT 1789-03-04 1791-03-03   Pro-Administration -1                        
54 54 S000349 sen CT 1791-10-24 1793-12-31 3 Pro-Administration                          
112 112 M000828 sen CT 1793-12-02 1795-03-03 3 Pro-Administration                          
120 120 S001009 sen MA 1789-03-04 1793-03-03 2 Pro-Administration                          
126 126 V000104 rep DE 1789-03-04 1791-03-03   Pro-Administration 0                        
127 127 V000104 rep DE 1791-10-24 1793-03-03   Pro-Administration 0                        
176 176 H000508 sen MD 1789-03-04 1795-03-03 3 Pro-Administration                          
289 289 S000154 sen NY 1789-03-04 1791-03-03 1 Pro-Administration                          

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