legislator_terms

Table actions Table actions

714 rows where state = "MN"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, class, party, district, phone, fax, contact_form, 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
6415 6415 S000396 rep MN 1849-12-03 1851-03-03     -1                        
6416 6416 S000396 rep MN 1851-12-01 1853-03-03     -1                        
7123 7123 K000219 rep MN 1857-12-07 1859-03-03   Democrat -1                        
7180 7180 P000301 rep MN 1857-12-07 1859-03-03   Democrat -1                        
7268 7268 R000198 rep MN 1853-12-05 1855-03-03   Democrat -1                        
7269 7269 R000198 rep MN 1855-12-03 1857-03-03   Democrat -1                        
7270 7270 R000198 sen MN 1858-01-01 1863-03-03 1 Democrat                          
7650 7650 A000081 rep MN 1859-12-05 1861-03-03   Republican -1                        
7651 7651 A000081 rep MN 1861-07-04 1863-03-03   Republican -1                        
8182 8182 N000145 sen MN 1865-12-04 1871-03-03 2 Democrat                          
8312 8312 D000417 rep MN 1863-12-07 1865-03-03   Republican 2                        
8313 8313 D000417 rep MN 1865-12-04 1867-03-03   Republican 2                        
8314 8314 D000417 rep MN 1867-03-04 1869-03-03   Republican 2                        
8543 8543 C000260 rep MN 1857-12-07 1859-03-03   Democrat -1                        
8697 8697 R000026 sen MN 1863-12-07 1869-03-03 1 Republican                          
8698 8698 R000026 sen MN 1869-03-04 1875-03-03 1 Republican                          
8782 8782 W000476 sen MN 1859-12-05 1865-03-03 2 Republican                          
8783 8783 W000476 rep MN 1869-03-04 1871-03-03   Republican 1                        
8784 8784 W000578 rep MN 1869-03-04 1871-03-03   Democrat 2                        
9023 9023 S000824 sen MN 1871-03-04 1871-12-31 2 Republican                          
9081 9081 A000344 rep MN 1871-03-04 1873-03-03   Republican 2                        
9082 9082 A000344 rep MN 1873-12-01 1875-03-03   Republican 3                        
9561 9561 K000218 rep MN 1875-12-06 1877-03-03   Republican 3                        
9945 9945 S000908 rep MN 1877-10-15 1879-03-03   Republican 3                        
10171 10171 P000400 rep MN 1879-03-18 1881-03-03   Democrat 2                        
10189 10189 S000362 sen MN 1858-01-01 1859-03-03 2 Democrat                          
10239 10239 W000629 rep MN 1859-12-05 1861-03-03   Republican -1                        
10240 10240 W000629 rep MN 1861-07-04 1863-03-03   Republican -1                        
10241 10241 W000629 rep MN 1863-12-07 1865-03-03   Republican 1                        
10242 10242 W000629 rep MN 1865-12-04 1867-03-03   Republican 1                        
10243 10243 W000629 rep MN 1867-03-04 1869-03-03   Republican 1                        
10244 10244 W000629 sen MN 1870-07-15 1871-01-22 2 Republican                          
10245 10245 W000629 sen MN 1871-03-04 1877-03-03 2 Republican                          
10246 10246 W000629 sen MN 1877-03-05 1881-03-07 2 Republican                          
10247 10247 W000629 sen MN 1881-11-15 1883-03-03 2 Republican                          
10339 10339 E000046 sen MN 1881-12-05 1881-12-31 2 Republican                          
10462 10462 M000570 sen MN 1875-12-06 1881-03-03 1 Republican                          
10463 10463 M000570 sen MN 1881-12-05 1887-03-03 1 Republican                          
10873 10873 S000003 sen MN 1883-12-03 1889-03-03 2 Republican                          
11050 11050 G000186 rep MN 1885-12-07 1887-03-03   Republican 4                        
11214 11214 S000988 rep MN 1873-12-01 1875-03-03   Republican 2                        
11215 11215 S000988 rep MN 1875-12-06 1877-03-03   Republican 2                        
11216 11216 S000988 rep MN 1877-10-15 1879-03-03   Republican 2                        
11217 11217 S000988 rep MN 1881-12-05 1883-03-03   Republican 2                        
11218 11218 S000988 rep MN 1883-12-03 1885-03-03   Republican 3                        
11219 11219 S000988 rep MN 1885-12-07 1887-03-03   Republican 3                        
11250 11250 W000026 rep MN 1883-12-03 1885-03-03   Republican 2                        
11251 11251 W000026 rep MN 1885-12-07 1887-03-03   Republican 2                        
11266 11266 W000387 rep MN 1883-12-03 1885-03-03   Republican 1                        
11267 11267 W000387 rep MN 1885-12-07 1887-03-03   Republican 1                        
11438 11438 M000003 rep MN 1887-12-05 1889-03-03   Democrat 3                        
11490 11490 R000196 rep MN 1887-12-05 1889-03-03   Democrat 4                        
11550 11550 W000614 rep MN 1887-12-05 1889-03-03   Democrat 1                        
11681 11681 C000665 rep MN 1889-12-02 1891-03-03   Republican 5                        
11740 11740 D000555 rep MN 1871-03-04 1873-03-03   Republican 1                        
11741 11741 D000555 rep MN 1873-12-01 1875-03-03   Republican 1                        
11742 11742 D000555 rep MN 1875-12-06 1877-03-03   Republican 1                        
11743 11743 D000555 rep MN 1877-10-15 1879-03-03   Republican 1                        
11744 11744 D000555 rep MN 1879-03-18 1881-03-03   Republican 1                        
11745 11745 D000555 rep MN 1881-12-05 1883-03-03   Republican 1                        
11746 11746 D000555 rep MN 1889-12-02 1891-03-03   Republican 1                        
11776 11776 H000047 rep MN 1889-12-02 1891-03-03   Republican 3                        
11965 11965 S000653 rep MN 1889-12-02 1891-03-03   Republican 4                        
12013 12013 W000175 rep MN 1879-03-18 1881-03-03   Republican 3                        
12014 12014 W000175 rep MN 1881-12-05 1883-03-03   Republican 3                        
12015 12015 W000175 rep MN 1883-12-03 1885-03-03   Republican 4                        
12016 12016 W000175 sen MN 1889-12-02 1895-03-03 2 Republican                          
12130 12130 C000242 rep MN 1891-12-07 1893-03-03   Democrat 4                        
12188 12188 H000094 rep MN 1891-12-07 1893-03-03   Populist 5                        
12190 12190 H000228 rep MN 1891-12-07 1893-03-03   Democrat 1                        
12402 12402 B000094 rep MN 1893-08-07 1895-03-03   Democrat 6                        
12418 12418 B000590 rep MN 1893-08-07 1895-03-03   Populist 7                        
12590 12590 H000065 rep MN 1891-12-07 1893-03-03   Democrat 3                        
12591 12591 H000065 rep MN 1893-08-07 1895-03-03   Democrat 3                        
13049 13049 K000166 rep MN 1893-08-07 1895-03-03   Republican 4                        
13050 13050 K000166 rep MN 1895-12-02 1897-03-03   Republican 4                        
13637 13637 D000095 sen MN 1887-12-05 1893-03-03 1 Republican                          
13638 13638 D000095 sen MN 1893-08-07 1899-03-03 1 Republican                          
13639 13639 D000095 sen MN 1899-12-04 1901-03-03 1 Republican                          
13940 13940 E000038 rep MN 1895-12-02 1897-03-03   Republican 7                        
13941 13941 E000038 rep MN 1897-03-15 1899-03-03   Republican 7                        
13942 13942 E000038 rep MN 1899-12-04 1901-03-03   Republican 7                        
13943 13943 E000038 rep MN 1901-12-02 1903-03-03   Republican 7                        
13986 13986 H000434 rep MN 1895-12-02 1897-03-03   Republican 3                        
13987 13987 H000434 rep MN 1897-03-15 1899-03-03   Republican 3                        
13988 13988 H000434 rep MN 1899-12-04 1901-03-03   Republican 3                        
13989 13989 H000434 rep MN 1901-12-02 1903-03-03   Republican 3                        
14097 14097 M000986 rep MN 1897-03-15 1899-03-03   Republican 6                        
14098 14098 M000986 rep MN 1899-12-04 1901-03-03   Republican 6                        
14099 14099 M000986 rep MN 1901-12-02 1903-03-03   Republican 6                        
14378 14378 L000319 rep MN 1887-12-05 1889-03-03   Republican 2                        
14379 14379 L000319 rep MN 1889-12-02 1891-03-03   Republican 2                        
14380 14380 L000319 rep MN 1891-12-07 1893-03-03   Republican 2                        
14381 14381 L000319 rep MN 1903-11-09 1905-03-03   Democrat 5                        
14595 14595 B001029 rep MN 1903-11-09 1905-03-03   Republican 6                        
14596 14596 B001029 rep MN 1905-12-04 1907-03-03   Republican 6                        
14655 14655 F000202 rep MN 1893-08-07 1895-03-03   Republican 5                        
14656 14656 F000202 rep MN 1895-12-02 1897-03-03   Republican 5                        
14657 14657 F000202 rep MN 1897-03-15 1899-03-03   Republican 5                        
14658 14658 F000202 rep MN 1899-12-04 1901-03-03   Republican 5                        

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