legislator_terms

Table actions Table actions

539 rows where state = "KS"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, class, party, district, address, phone, fax, contact_form, office, state_rank, rss_url, 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
6950 6950 W000414 rep KS 1853-12-05 1855-03-03   Democrat -1                        
6951 6951 W000414 rep KS 1855-12-03 1857-03-03   Democrat -1                        
7533 7533 P000085 rep KS 1857-12-07 1859-03-03   Republican -1                        
7534 7534 P000085 rep KS 1859-12-05 1861-03-03   Republican -1                        
7707 7707 C000713 rep KS 1859-12-05 1861-03-03   Republican 1                        
7708 7708 C000713 rep KS 1861-07-04 1863-03-03   Republican 1                        
8062 8062 W000461 rep KS 1863-12-07 1865-03-03   Republican 1                        
8163 8163 L000061 sen KS 1861-07-04 1865-03-03 2 Republican                          
8164 8164 L000061 sen KS 1865-12-04 1867-03-03 2 Republican                          
8247 8247 R000445 sen KS 1866-01-01 1871-03-03 2 Republican                          
8429 8429 P000423 sen KS 1861-07-04 1867-03-03 3 Republican                          
8430 8430 P000423 sen KS 1867-03-04 1873-03-03 3 Republican                          
8551 8551 C000470 rep KS 1865-12-04 1867-03-03   Republican 1                        
8552 8552 C000470 rep KS 1867-03-04 1869-03-03   Republican 1                        
8553 8553 C000470 rep KS 1869-03-04 1871-03-03   Republican 1                        
8846 8846 C000027 sen KS 1871-03-04 1873-12-31 2 Republican                          
9126 9126 C000551 rep KS 1873-12-01 1875-03-03   Republican -1                        
9142 9142 C000952 sen KS 1873-12-01 1875-03-03 2 Republican                          
9240 9240 L000473 rep KS 1871-03-04 1873-03-03   Republican 1                        
9241 9241 L000473 rep KS 1873-12-01 1875-03-03   Republican -1                        
9432 9432 H000307 sen KS 1874-01-01 1877-03-03 2 Republican                          
9460 9460 B000951 rep KS 1875-12-06 1877-03-03   Republican 3                        
9511 9511 G000287 rep KS 1875-12-06 1877-03-03   Democrat 2                        
9894 9894 P000315 rep KS 1873-12-01 1875-03-03   Republican -1                        
9895 9895 P000315 rep KS 1875-12-06 1877-03-03   Republican 1                        
9896 9896 P000315 rep KS 1877-10-15 1879-03-03   Republican 1                        
10740 10740 H000316 rep KS 1877-10-15 1879-03-03   Republican 2                        
10741 10741 H000316 rep KS 1879-03-18 1881-03-03   Republican 2                        
10742 10742 H000316 rep KS 1881-12-05 1883-03-03   Republican 2                        
10743 10743 H000316 rep KS 1883-12-03 1885-03-03   Republican 2                        
11068 11068 H000142 rep KS 1883-12-03 1885-03-03   Republican -1                        
11069 11069 H000142 rep KS 1885-12-07 1887-03-03   Republican 6                        
11086 11086 I000012 sen KS 1873-12-01 1879-03-03 3 Republican                          
11087 11087 I000012 sen KS 1879-03-18 1885-03-03 3 Republican                          
11088 11088 I000012 sen KS 1885-12-07 1891-03-03 3 Republican                          
11565 11565 A000194 rep KS 1879-03-18 1881-03-03   Republican 1                        
11566 11566 A000194 rep KS 1881-12-05 1883-03-03   Republican 1                        
11567 11567 A000194 rep KS 1883-12-03 1885-03-03   Republican 1                        
11568 11568 A000194 rep KS 1885-12-07 1887-03-03   Republican 5                        
11569 11569 A000194 rep KS 1887-12-05 1889-03-03   Ind. Republican 5                        
11570 11570 A000194 rep KS 1889-12-02 1891-03-03   Republican 5                        
11783 11783 K000059 rep KS 1889-12-02 1891-03-03   Republican 4                        
11867 11867 M000968 rep KS 1883-12-03 1885-03-03   Republican -1                        
11868 11868 M000968 rep KS 1885-12-07 1887-03-03   Republican 1                        
11869 11869 M000968 rep KS 1887-12-05 1889-03-03   Republican 1                        
11870 11870 M000968 rep KS 1889-12-02 1891-03-03   Republican 1                        
11897 11897 P000256 rep KS 1883-12-03 1885-03-03   Republican -1                        
11898 11898 P000256 rep KS 1885-12-07 1887-03-03   Republican 7                        
11899 11899 P000256 rep KS 1887-12-05 1889-03-03   Republican 7                        
11900 11900 P000256 rep KS 1889-12-02 1891-03-03   Republican 7                        
11906 11906 P000389 sen KS 1877-10-15 1883-03-03 2 Republican                          
11907 11907 P000389 sen KS 1883-12-03 1889-03-03 2 Republican                          
11908 11908 P000389 sen KS 1889-12-02 1891-12-31 2 Republican                          
11946 11946 R000559 rep KS 1877-10-15 1879-03-03   Republican 3                        
11947 11947 R000559 rep KS 1879-03-18 1881-03-03   Republican 3                        
11948 11948 R000559 rep KS 1881-12-05 1883-03-03   Republican 3                        
11949 11949 R000559 rep KS 1883-12-03 1885-03-03   Republican 3                        
11950 11950 R000559 rep KS 1885-12-07 1887-03-03   Republican 4                        
11951 11951 R000559 rep KS 1887-12-05 1889-03-03   Republican 4                        
11952 11952 R000559 rep KS 1889-12-02 1891-03-03   Republican 4                        
11995 11995 T000419 rep KS 1887-12-05 1889-03-03   Republican 6                        
11996 11996 T000419 rep KS 1889-12-02 1891-03-03   Republican 6                        
12136 12136 C000533 rep KS 1891-12-07 1893-03-03   Populist 3                        
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                          
12389 12389 P000228 rep KS 1883-12-03 1885-03-03   Republican -1                        
12390 12390 P000228 rep KS 1885-12-07 1887-03-03   Republican 3                        
12391 12391 P000228 rep KS 1887-12-05 1889-03-03   Republican 3                        
12392 12392 P000228 rep KS 1889-12-02 1891-03-03   Republican 3                        
12393 12393 P000228 sen KS 1892-01-01 1893-12-31 2 Republican                          
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                        
12557 12557 F000429 rep KS 1883-12-03 1885-03-03   Republican 2                        
12558 12558 F000429 rep KS 1885-12-07 1887-03-03   Republican 2                        
12559 12559 F000429 rep KS 1887-12-05 1889-03-03   Republican 2                        
12560 12560 F000429 rep KS 1889-12-02 1891-03-03   Republican 2                        
12561 12561 F000429 rep KS 1891-12-07 1893-03-03   Republican 2                        
12562 12562 F000429 rep KS 1893-08-07 1895-03-03   Republican 2                        
12642 12642 H000909 rep KS 1893-08-07 1895-03-03   Populist 3                        
12680 12680 M000185 sen KS 1893-08-07 1895-03-03 2 Democrat                          
12697 12697 M000901 rep KS 1893-08-07 1895-03-03   Democrat 2                        
12908 12908 B000070 sen KS 1895-12-02 1901-03-03 2 Republican                          
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                        
12919 12919 B000573 rep KS 1895-12-02 1897-03-03   Republican -1                        
13051 13051 K000238 rep KS 1895-12-02 1897-03-03   Republican 3                        
13093 13093 M000749 rep KS 1895-12-02 1897-03-03   Republican 2                        
13262 13262 B000654 rep KS 1897-03-15 1899-03-03   Populist -1                        
13265 13265 B000856 rep KS 1891-12-07 1893-03-03   Republican 1                        
13266 13266 B000856 rep KS 1893-08-07 1895-03-03   Republican 1                        
13267 13267 B000856 rep KS 1895-12-02 1897-03-03   Republican 1                        
13268 13268 B000856 rep KS 1897-03-15 1899-03-03   Republican 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                          
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                        
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                        

Next page

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