legislator_terms

Table actions Table actions

43 rows where party = "Progressive"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: legislator_id, type, state, start, end, 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
16295 16295 B000987 rep WA 1913-04-07 1915-03-03   Progressive -1                        
16352 16352 F000009 rep WA 1913-04-07 1915-03-03   Progressive -1                        
16397 16397 H000633 rep IL 1913-04-07 1915-03-03   Progressive 12                        
16456 16456 M000006 rep MI 1913-04-07 1915-03-03   Progressive 12                        
16613 16613 T000228 rep IL 1913-04-07 1915-03-03   Progressive 10                        
17010 17010 S000861 rep CA 1915-12-06 1917-03-03   Progressive 10                        
17780 17780 H000939 rep PA 1913-04-07 1915-03-03   Progressive 28                        
18117 18117 C000297 rep NY 1913-04-07 1915-03-03   Progressive 19                        
18118 18118 C000297 rep NY 1915-12-06 1917-03-03   Progressive 19                        
18129 18129 C000770 rep IL 1915-12-06 1917-03-03   Progressive 11                        
18159 18159 E000161 rep CA 1915-12-06 1917-03-03   Progressive 6                        
19858 19858 M000201 rep LA 1915-12-06 1917-03-03   Progressive 3                        
19859 19859 M000201 rep LA 1917-04-02 1919-03-03   Progressive 3                        
20835 20835 S000113 rep MN 1915-12-06 1917-03-03   Progressive 10                        
20836 20836 S000113 rep MN 1917-04-02 1919-03-03   Progressive 10                        
20918 20918 T000119 rep PA 1913-04-07 1915-03-03   Progressive 24                        
21353 21353 K000076 rep PA 1917-04-02 1919-03-03   Progressive 30                        
22026 22026 A000176 rep WI 1935-01-03 1937-01-03   Progressive 1                        
22027 22027 A000176 rep WI 1937-01-05 1939-01-03   Progressive 1                        
22047 22047 B000598 rep WI 1935-01-03 1937-01-03   Progressive 7                        
22048 22048 B000598 rep WI 1937-01-05 1939-01-03   Progressive 7                        
22402 22402 S000137 rep WI 1935-01-03 1937-01-03   Progressive 8                        
22403 22403 S000137 rep WI 1937-01-05 1939-01-03   Progressive 8                        
23009 23009 G000118 rep WI 1935-01-03 1937-01-03   Progressive 10                        
23010 23010 G000118 rep WI 1937-01-05 1939-01-03   Progressive 10                        
23011 23011 G000118 rep WI 1939-01-03 1941-01-03   Progressive 10                        
23012 23012 G000118 rep WI 1941-01-03 1943-01-03   Progressive 10                        
23098 23098 L000005 sen WI 1935-01-03 1941-01-03 1 Progressive                          
23099 23099 L000005 sen WI 1941-01-03 1947-01-03 1 Progressive                          
23661 23661 S000079 rep WI 1935-01-03 1937-01-03   Progressive 2                        
23662 23662 S000079 rep WI 1937-01-05 1939-01-03   Progressive 2                        
23663 23663 S000079 rep WI 1941-01-03 1943-01-03   Progressive 2                        
23664 23664 S000079 rep WI 1943-01-06 1945-01-03   Progressive 2                        
25309 25309 H000356 rep CA 1937-01-05 1939-01-03   Progressive 4                        
25555 25555 W000718 rep MI 1913-04-07 1915-03-03   Progressive 10                        
25717 25717 H000943 rep WI 1935-01-03 1937-01-03   Progressive 9                        
25718 25718 H000943 rep WI 1937-01-05 1939-01-03   Progressive 9                        
25719 25719 H000943 rep WI 1939-01-03 1941-01-03   Progressive 9                        
25720 25720 H000943 rep WI 1941-01-03 1943-01-03   Progressive 9                        
25721 25721 H000943 rep WI 1943-01-06 1945-01-03   Progressive 9                        
25722 25722 H000943 rep WI 1945-01-03 1947-01-03   Progressive 9                        
27051 27051 W000663 rep WI 1935-01-03 1937-01-03   Progressive 3                        
27052 27052 W000663 rep WI 1937-01-05 1939-01-03   Progressive 3                        

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