legislator_terms

Table actions Table actions

68 rows where party = "Populist"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
12136 12136 C000533 rep KS 1891-12-07 1893-03-03   Populist 3                        
12188 12188 H000094 rep MN 1891-12-07 1893-03-03   Populist 5                        
12256 12256 O000129 rep KS 1891-12-07 1893-03-03   Populist 4                        
12270 12270 P000188 sen KS 1891-12-07 1897-03-03 3 Populist                          
12418 12418 B000590 rep MN 1893-08-07 1895-03-03   Populist 7                        
12475 12475 C000122 rep CA 1893-08-07 1895-03-03   Populist 6                        
12510 12510 D000115 rep KS 1891-12-07 1893-03-03   Populist 5                        
12511 12511 D000115 rep KS 1893-08-07 1895-03-03   Populist 5                        
12642 12642 H000909 rep KS 1893-08-07 1895-03-03   Populist 3                        
12687 12687 M000498 rep NE 1891-12-07 1893-03-03   Populist 2                        
12688 12688 M000498 rep NE 1893-08-07 1895-03-03   Populist 5                        
12754 12754 P000199 rep CO 1893-08-07 1895-03-03   Populist 1                        
12909 12909 B000075 rep KS 1891-12-07 1893-03-03   Populist 6                        
12910 12910 B000075 rep KS 1893-08-07 1895-03-03   Populist 6                        
12911 12911 B000075 rep KS 1895-12-02 1897-03-03   Populist 6                        
12931 12931 B001183 sen NC 1895-12-02 1901-03-03 2 Populist                          
13010 13010 G000305 rep AL 1895-12-02 1897-03-03   Populist 5                        
13044 13044 K000083 rep NE 1891-12-07 1893-03-03   Populist 3                        
13045 13045 K000083 rep NE 1893-08-07 1895-03-03   Populist 6                        
13046 13046 K000083 rep NE 1895-12-02 1897-03-03   Populist 6                        
13243 13243 B000149 rep CA 1897-03-15 1899-03-03   Populist 6                        
13262 13262 B000654 rep KS 1897-03-15 1899-03-03   Populist -1                        
13272 13272 C000241 rep CA 1897-03-15 1899-03-03   Populist 7                        
13308 13308 F000323 rep NC 1897-03-15 1899-03-03   Populist 3                        
13312 13312 G000525 rep ID 1897-03-15 1899-03-03   Populist 1                        
13317 13317 H000258 rep KS 1893-08-07 1895-03-03   Populist -1                        
13318 13318 H000258 sen KS 1897-03-15 1903-03-03 3 Populist                          
13350 13350 H000843 rep AL 1895-12-02 1897-03-03   Populist 7                        
13351 13351 H000843 rep AL 1897-03-15 1899-03-03   Populist 7                        
13373 13373 K000060 rep SD 1897-03-15 1899-03-03   Populist -1                        
13376 13376 K000293 rep SD 1897-03-15 1899-03-03   Populist -1                        
13379 13379 K000353 sen SD 1891-12-07 1897-03-03 3 Populist                          
13390 13390 M000172 rep NC 1895-12-02 1897-03-03   Populist 6                        
13391 13391 M000172 rep NC 1897-03-15 1899-03-03   Populist 6                        
13392 13392 M000270 rep NE 1897-03-15 1899-03-03   Populist 3                        
13393 13393 M000370 rep KS 1897-03-15 1899-03-03   Populist 6                        
13450 13450 P000254 rep KS 1897-03-15 1899-03-03   Populist 2                        
13474 13474 S000389 rep NC 1895-12-02 1897-03-03   Populist 7                        
13475 13475 S000389 rep NC 1897-03-15 1899-03-03   Populist 7                        
13478 13478 S000432 rep KS 1891-12-07 1893-03-03   Populist 7                        
13479 13479 S000432 rep KS 1893-08-07 1895-03-03   Populist 7                        
13480 13480 S000432 rep KS 1897-03-15 1899-03-03   Populist 7                        
13481 13481 S000468 rep NC 1895-12-02 1897-03-03   Populist 1                        
13482 13482 S000468 rep NC 1897-03-15 1899-03-03   Populist 1                        
13501 13501 S001027 rep NC 1895-12-02 1897-03-03   Populist 4                        
13502 13502 S001027 rep NC 1897-03-15 1899-03-03   Populist 4                        
13519 13519 V000103 rep KS 1897-03-15 1899-03-03   Populist 5                        
13556 13556 A000153 sen NE 1893-08-07 1899-03-03 1 Populist                          
13557 13557 A000153 sen NE 1899-12-04 1901-03-28 1 Populist                          
13558 13558 A000334 rep NC 1899-12-04 1901-03-03   Populist 4                        
13672 13672 G000429 rep NE 1897-03-15 1899-03-03   Populist 6                        
13673 13673 G000429 rep NE 1899-12-04 1901-03-03   Populist 6                        
13783 13783 R000244 rep KS 1897-03-15 1899-03-03   Populist 3                        
13784 13784 R000244 rep KS 1899-12-04 1901-03-03   Populist 3                        
13806 13806 S001085 rep NE 1897-03-15 1899-03-03   Populist 5                        
13807 13807 S001085 rep NE 1899-12-04 1901-03-03   Populist 5                        
13850 13850 B000341 rep CO 1893-08-07 1895-03-03   Populist 2                        
13851 13851 B000341 rep CO 1895-12-02 1897-03-03   Populist 2                        
13852 13852 B000341 rep CO 1897-03-15 1899-03-03   Populist 2                        
13853 13853 B000341 rep CO 1899-12-04 1901-03-03   Populist 2                        
13854 13854 B000341 rep CO 1901-12-02 1903-03-03   Populist 2                        
13944 13944 E000061 rep MT 1901-12-02 1903-03-03   Populist 1                        
13967 13967 G000239 rep ID 1901-12-02 1903-03-03   Populist 1                        
14111 14111 N000056 rep NE 1899-12-04 1901-03-03   Populist 6                        
14112 14112 N000056 rep NE 1901-12-02 1903-03-03   Populist 6                        
14174 14174 S000811 rep NE 1897-03-15 1899-03-03   Populist 4                        
14175 14175 S000811 rep NE 1899-12-04 1901-03-03   Populist 4                        
14176 14176 S000811 rep NE 1901-12-02 1903-03-03   Populist 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);