legislator_terms

Table actions Table actions

16 rows where party = "Anti-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
1 1 B000226 sen DE 1789-03-04 1793-03-03 2 Anti-Administration                          
9 9 F000100 sen GA 1789-03-04 1793-03-03 2 Anti-Administration                          
12 12 G000403 sen VA 1789-03-04 1791-03-03 1 Anti-Administration                          
19 19 L000201 sen VA 1789-03-04 1793-03-03 2 Anti-Administration                          
20 20 M000031 sen PA 1789-03-04 1791-03-03 1 Anti-Administration                          
48 48 R000350 sen VT 1791-10-24 1796-10-15 1 Anti-Administration                          
70 70 E000075 sen KY 1792-01-01 1795-03-03 3 Anti-Administration                          
87 87 D000157 rep NC 1793-12-02 1795-03-03   Anti-Administration 8                        
137 137 W000633 sen NH 1789-03-04 1793-03-03 2 Anti-Administration                          
266 266 H000266 rep VA 1793-12-02 1795-03-03   Anti-Administration 10                        
575 575 G000196 rep NC 1793-12-02 1795-03-03   Anti-Administration 6                        
754 754 S000805 sen RI 1790-01-01 1793-03-03 2 Anti-Administration                          
1553 1553 F000124 rep PA 1791-10-24 1793-03-03   Anti-Administration 8                        
1554 1554 F000124 rep PA 1793-12-02 1795-03-03   Anti-Administration -1                        
1791 1791 M000858 sen VA 1790-11-09 1791-03-03 1 Anti-Administration                          
1792 1792 M000858 sen VA 1791-03-04 1794-05-27 1 Anti-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);