legislator_terms

Table actions Table actions

232 rows where district = 26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, party, url, address, phone, fax, contact_form, office, 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
3114 3114 H000088 rep NY 1829-12-07 1831-03-03   Jackson 26                        
3198 3198 R000439 rep NY 1823-12-01 1825-03-03   Anti Mason 26                        
3199 3199 R000439 rep NY 1825-12-05 1827-03-03   Adams 26                        
3200 3200 R000439 rep NY 1829-12-07 1831-03-03   Anti Masonic 26                        
3308 3308 B000006 rep NY 1831-12-05 1833-03-03   Anti Masonic 26                        
3663 3663 D000330 rep NY 1831-12-05 1833-03-03   Anti Masonic 26                        
3664 3664 D000330 rep NY 1833-12-02 1835-03-03   Anti Masonic 26                        
4346 4346 S000399 rep NY 1837-09-04 1839-03-03   Whig 26                        
4808 4808 G000376 rep NY 1835-12-07 1837-03-03   Whig 26                        
4809 4809 G000376 rep NY 1839-12-02 1841-03-03   Whig 26                        
4810 4810 G000376 rep NY 1841-05-31 1843-03-03   Whig 26                        
4811 4811 G000449 rep NY 1841-05-31 1843-03-03   Whig 26                        
4884 4884 M000285 rep NY 1827-12-03 1829-03-03   Adams 26                        
5184 5184 D000020 rep NY 1843-12-04 1845-03-03   Democrat 26                        
5416 5416 E000149 rep NY 1845-12-01 1847-03-03   Democrat 26                        
5754 5754 L000142 rep NY 1847-12-06 1849-03-03   Whig 26                        
5774 5774 M000208 rep NY 1823-12-01 1825-03-03   Whig 26                        
5775 5775 M000208 rep NY 1825-12-05 1827-03-03   Adams 26                        
5776 5776 M000208 rep NY 1827-12-03 1829-03-03   Adams 26                        
6020 6020 J000031 rep NY 1849-12-03 1851-03-03   Whig 26                        
6443 6443 W000030 rep NY 1851-12-01 1853-03-03   Whig 26                        
6887 6887 O000070 rep NY 1853-12-05 1855-03-03   Democrat 26                        
6888 6888 O000070 rep NY 1855-12-03 1857-03-03   Democrat 26                        
7544 7544 P000470 rep NY 1857-12-07 1859-03-03   Republican 26                        
7545 7545 P000470 rep NY 1859-12-05 1861-03-03   Republican 26                        
7691 7691 C000278 rep NY 1861-07-04 1863-03-03   Republican 26                        
8377 8377 L000317 rep NY 1867-03-04 1869-03-03   Republican 26                        
8630 8630 H000808 rep NY 1863-12-07 1865-03-03   Republican 26                        
8631 8631 H000808 rep NY 1865-12-04 1867-03-03   Republican 26                        
8632 8632 H000808 rep NY 1869-03-04 1871-03-03   Republican 26                        
8913 8913 G000296 rep NY 1871-03-04 1873-03-03   Republican 26                        
9226 9226 L000042 rep NY 1873-12-01 1875-03-03   Republican 26                        
9575 9575 M000007 rep NY 1875-12-06 1877-03-03   Republican 26                        
9634 9634 S000313 rep PA 1875-12-06 1877-03-03   Democrat 26                        
9953 9953 T000209 rep PA 1877-10-15 1879-03-03   Republican 26                        
10063 10063 D000305 rep PA 1879-03-18 1881-03-03   Republican 26                        
10281 10281 C000072 rep NY 1877-10-15 1879-03-03   Republican 26                        
10282 10282 C000072 rep NY 1879-03-18 1881-03-03   Republican 26                        
10283 10283 C000072 rep NY 1881-12-05 1883-03-03   Republican 26                        
11040 11040 F000193 rep PA 1885-12-07 1887-03-03   Republican 26                        
11129 11129 M000711 rep NY 1885-12-07 1887-03-03   Republican 26                        
11387 11387 H000063 rep PA 1887-12-05 1889-03-03   Democrat 26                        
11707 11707 C000965 rep PA 1889-12-02 1891-03-03   Republican 26                        
11726 11726 D000207 rep NY 1887-12-05 1889-03-03   Republican 26                        
11727 11727 D000207 rep NY 1889-12-02 1891-03-03   Republican 26                        
13011 13011 G000487 rep PA 1891-12-07 1893-03-03   Republican 26                        
13012 13012 G000487 rep PA 1895-12-02 1897-03-03   Republican 26                        
13503 13503 S001050 rep PA 1897-03-15 1899-03-03   Republican 26                        
13669 13669 G000095 rep PA 1899-12-04 1901-03-03   Democrat 26                        
14130 14130 R000076 rep NY 1891-12-07 1893-03-03   Republican 26                        
14131 14131 R000076 rep NY 1893-08-07 1895-03-03   Republican 26                        
14132 14132 R000076 rep NY 1895-12-02 1897-03-03   Republican 26                        
14133 14133 R000076 rep NY 1897-03-15 1899-03-03   Republican 26                        
14134 14134 R000076 rep NY 1899-12-04 1901-03-03   Republican 26                        
14135 14135 R000076 rep NY 1901-12-02 1903-03-03   Republican 26                        
14476 14476 S000391 rep PA 1903-11-09 1905-03-03   Democrat 26                        
14653 14653 F000180 rep NY 1903-11-09 1905-03-03   Republican 26                        
14654 14654 F000180 rep NY 1905-12-04 1907-03-03   Republican 26                        
14885 14885 S000134 rep PA 1905-12-04 1907-03-03   Republican 26                        
14890 14890 S000398 rep PA 1893-08-07 1895-03-03   Democrat 26                        
14995 14995 B000860 rep PA 1907-12-02 1909-03-03   Democrat 26                        
15847 15847 B000230 rep PA 1901-12-02 1903-03-03   Republican 26                        
15951 15951 D000581 rep NY 1901-12-02 1903-03-03   Republican 26                        
16073 16073 M000077 rep NY 1907-12-02 1909-03-03   Republican 26                        
16074 16074 M000077 rep NY 1909-03-15 1911-03-03   Republican 26                        
16075 16075 M000077 rep NY 1911-04-04 1913-03-03   Republican 26                        
16484 16484 M000660 rep NY 1911-04-04 1913-03-03   Republican 26                        
16503 16503 P000035 rep PA 1909-03-15 1911-03-03   Democrat 26                        
16504 16504 P000035 rep PA 1911-04-04 1913-03-03   Democrat 26                        
16505 16505 P000035 rep PA 1913-04-07 1915-03-03   Democrat 26                        
16508 16508 P000153 rep NY 1883-12-03 1885-03-03   Republican 26                        
16883 16883 M000753 rep PA 1881-12-05 1883-03-03   Republican 26                        
16884 16884 M000753 rep PA 1883-12-03 1885-03-03   Republican 26                        
17885 17885 P000379 rep NY 1913-04-07 1915-03-03   Republican 26                        
17886 17886 P000379 rep NY 1915-12-06 1917-03-03   Republican 26                        
17887 17887 P000379 rep NY 1917-04-02 1919-03-03   Republican 26                        
17888 17888 P000379 rep NY 1919-05-19 1921-03-03   Republican 26                        
17964 17964 S000831 rep PA 1915-12-06 1917-03-03   Democrat 26                        
17965 17965 S000831 rep PA 1917-04-02 1919-03-03   Democrat 26                        
17966 17966 S000831 rep PA 1919-05-19 1921-03-03   Democrat 26                        
18286 18286 K000240 rep PA 1921-04-11 1923-03-03   Republican 26                        
19058 19058 P000314 rep PA 1923-12-03 1925-03-03   Republican 26                        
19059 19059 P000314 rep PA 1925-12-07 1927-03-04   Republican 26                        
21580 21580 S001114 rep PA 1927-12-05 1929-03-03   Republican 26                        
21581 21581 S001114 rep PA 1929-04-15 1931-03-03   Republican 26                        
21582 21582 S001114 rep PA 1931-12-07 1933-03-03   Republican 26                        
21583 21583 S001114 rep PA 1933-03-09 1935-01-03   Republican 26                        
22128 22128 E000032 rep PA 1935-01-03 1937-01-03   Democrat 26                        
22129 22129 E000032 rep PA 1937-01-05 1939-01-03   Democrat 26                        
23456 23456 F000142 rep NY 1919-05-19 1921-03-03   Republican 26                        
23457 23457 F000142 rep NY 1921-04-11 1923-03-03   Republican 26                        
23458 23458 F000142 rep NY 1923-12-03 1925-03-03   Republican 26                        
23459 23459 F000142 rep NY 1925-12-07 1927-03-04   Republican 26                        
23460 23460 F000142 rep NY 1927-12-05 1929-03-03   Republican 26                        
23461 23461 F000142 rep NY 1929-04-15 1931-03-03   Republican 26                        
23462 23462 F000142 rep NY 1931-12-07 1933-03-03   Republican 26                        
23463 23463 F000142 rep NY 1933-03-09 1935-01-03   Republican 26                        
23464 23464 F000142 rep NY 1935-01-03 1937-01-03   Republican 26                        
23465 23465 F000142 rep NY 1937-01-05 1939-01-03   Republican 26                        
23466 23466 F000142 rep NY 1939-01-03 1941-01-03   Republican 26                        

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