legislator_terms

Table actions Table actions

191 rows where district = 28

✎ 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
2540 2540 W000727 rep NY 1823-12-01 1825-03-03     28                        
2703 2703 P000448 rep NY 1825-12-05 1827-03-03   Adams 28                        
3169 3169 M000047 rep NY 1827-12-03 1829-03-03   Jackson 28                        
3170 3170 M000047 rep NY 1829-12-07 1831-03-03   Jackson 28                        
3583 3583 W000334 rep NY 1831-12-05 1833-03-03   Anti Masonic 28                        
3818 3818 W000432 rep NY 1833-12-02 1835-03-03   Anti Masonic 28                        
4530 4530 K000087 rep NY 1839-12-02 1841-03-03   Whig 28                        
4736 4736 C000355 rep NY 1835-12-07 1837-03-03   Whig 28                        
4737 4737 C000355 rep NY 1837-09-04 1839-03-03   Whig 28                        
4738 4738 C000355 rep NY 1841-05-31 1843-03-03   Whig 28                        
5262 5262 P000129 rep NY 1843-12-04 1845-03-03   Whig 28                        
5721 5721 H000736 rep NY 1845-12-01 1847-03-03   Whig 28                        
5722 5722 H000736 rep NY 1847-12-06 1849-03-03   Whig 28                        
6406 6406 S000122 rep NY 1849-12-03 1851-03-03   Whig 28                        
6407 6407 S000122 rep NY 1851-12-01 1853-03-03   Whig 28                        
6605 6605 H000326 rep NY 1853-12-05 1855-03-03   Democrat 28                        
7458 7458 I000036 rep NY 1859-12-05 1861-03-03   Republican 28                        
8049 8049 V000061 rep NY 1861-07-04 1863-03-03   Republican 28                        
8137 8137 H000292 rep NY 1865-12-04 1867-03-03   Republican 28                        
8442 8442 S000237 rep NY 1867-03-04 1869-03-03   Ind. Republican 28                        
8569 8569 D000126 rep NY 1869-03-04 1871-03-03   Republican 28                        
8627 8627 H000734 rep NY 1869-03-04 1871-03-03   Republican 28                        
8654 8654 K000080 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 28                        
8655 8655 K000080 rep NY 1857-12-07 1859-03-03   Republican 28                        
9118 9118 C000461 rep NY 1863-12-07 1865-03-03   Republican 28                        
9119 9119 C000461 rep NY 1871-03-04 1873-03-03   Republican 28                        
9371 9371 S000552 rep NY 1873-12-01 1875-03-03   Republican 28                        
10336 10336 D000580 rep NY 1877-10-15 1879-03-03   Republican 28                        
10337 10337 D000580 rep NY 1879-03-18 1881-03-03   Republican 28                        
10338 10338 D000580 rep NY 1881-12-05 1883-03-03   Republican 28                        
10960 10960 A000301 rep NY 1885-12-07 1887-03-03   Democrat 28                        
11128 11128 M000711 rep NY 1883-12-03 1885-03-03   Republican 28                        
11756 11756 F000212 rep NY 1887-12-05 1889-03-03   Republican 28                        
11757 11757 F000212 rep NY 1889-12-02 1891-03-03   Republican 28                        
11808 11808 K000135 rep PA 1889-12-02 1891-03-03   Democrat 28                        
12281 12281 R000366 rep NY 1891-12-07 1893-03-03   Democrat 28                        
12657 12657 K000330 rep PA 1891-12-07 1893-03-03   Democrat 28                        
12658 12658 K000330 rep PA 1893-08-07 1895-03-03   Democrat 28                        
13236 13236 A000299 rep PA 1895-12-02 1897-03-03   Republican 28                        
13237 13237 A000299 rep PA 1897-03-15 1899-03-03   Republican 28                        
13983 13983 H000054 rep PA 1899-12-04 1901-03-03   Democrat 28                        
13984 13984 H000054 rep PA 1901-12-02 1903-03-03   Democrat 28                        
14438 14438 P000383 rep NY 1875-12-06 1877-03-03   Republican 28                        
14893 14893 S000398 rep PA 1903-11-09 1905-03-03   Republican 28                        
14894 14894 S000398 rep PA 1905-12-04 1907-03-03   Republican 28                        
15581 15581 K000279 rep NY 1903-11-09 1905-03-03   Republican 28                        
15582 15582 K000279 rep NY 1905-12-04 1907-03-03   Republican 28                        
15583 15583 K000279 rep NY 1907-12-02 1909-03-03   Republican 28                        
15584 15584 K000279 rep NY 1909-03-15 1911-03-03   Republican 28                        
15817 15817 W000340 rep PA 1907-12-02 1909-03-03   Republican 28                        
15818 15818 W000340 rep PA 1909-03-15 1911-03-03   Republican 28                        
16192 16192 S000712 rep PA 1911-04-04 1913-03-03   Republican 28                        
16512 16512 P000153 rep NY 1893-08-07 1895-03-03   Republican 28                        
16513 16513 P000153 rep NY 1895-12-02 1897-03-03   Republican 28                        
16514 16514 P000153 rep NY 1897-03-15 1899-03-03   Republican 28                        
16515 16515 P000153 rep NY 1899-12-04 1901-03-03   Republican 28                        
16516 16516 P000153 rep NY 1901-12-02 1903-03-03   Republican 28                        
16885 16885 M000753 rep PA 1915-12-06 1917-03-03   Republican 28                        
17072 17072 B000421 rep PA 1917-04-02 1919-03-03   Democrat 28                        
17074 17074 B000552 rep PA 1917-04-02 1919-03-03   Republican 28                        
17780 17780 H000939 rep PA 1913-04-07 1915-03-03   Progressive 28                        
17781 17781 H000939 rep PA 1919-05-19 1921-03-03   Republican 28                        
17909 17909 S000053 rep NY 1915-12-06 1917-03-03   Republican 28                        
17910 17910 S000053 rep NY 1917-04-02 1919-03-03   Republican 28                        
17911 17911 S000053 rep NY 1919-05-19 1921-03-03   Republican 28                        
18521 18521 T000126 rep NY 1913-04-07 1915-03-03   Democrat 28                        
18522 18522 T000126 rep NY 1921-04-11 1923-03-03   Democrat 28                        
18772 18772 M001041 rep NY 1911-04-04 1913-03-03   Republican 28                        
18911 18911 B000493 rep PA 1921-04-11 1923-03-03   Republican 28                        
18912 18912 B000493 rep PA 1923-12-03 1925-03-03   Republican 28                        
18913 18913 B000493 rep PA 1925-12-07 1927-03-04   Republican 28                        
21208 21208 C000566 rep PA 1927-12-05 1929-03-03   Republican 28                        
21209 21209 C000566 rep PA 1929-04-15 1931-03-03   Republican 28                        
21210 21210 C000566 rep PA 1931-12-07 1933-03-03   Republican 28                        
21643 21643 B000409 rep PA 1933-03-09 1935-01-03   Democrat 28                        
21644 21644 B000409 rep PA 1935-01-03 1937-01-03   Democrat 28                        
21726 21726 C000785 rep NY 1923-12-03 1925-03-03   Democrat 28                        
21727 21727 C000785 rep NY 1925-12-07 1927-03-04   Democrat 28                        
21728 21728 C000785 rep NY 1927-12-05 1929-03-03   Democrat 28                        
21729 21729 C000785 rep NY 1929-04-15 1931-03-03   Democrat 28                        
21730 21730 C000785 rep NY 1931-12-07 1933-03-03   Democrat 28                        
21731 21731 C000785 rep NY 1933-03-09 1935-01-03   Democrat 28                        
21732 21732 C000785 rep NY 1935-01-03 1937-01-03   Democrat 28                        
22475 22475 A000145 rep PA 1937-01-05 1939-01-03   Democrat 28                        
22476 22476 A000145 rep PA 1939-01-03 1941-01-03   Democrat 28                        
24076 24076 R000373 rep PA 1945-01-03 1947-01-03   Republican 28                        
25174 25174 B001214 rep NY 1937-01-05 1939-01-03   Democrat 28                        
25175 25175 B001214 rep NY 1939-01-03 1941-01-03   Democrat 28                        
25176 25176 B001214 rep NY 1941-01-03 1943-01-03   Democrat 28                        
25177 25177 B001214 rep NY 1943-01-06 1945-01-03   Democrat 28                        
25973 25973 G000031 rep NY 1945-01-03 1947-01-03   Republican 28                        
25974 25974 G000031 rep NY 1947-01-03 1949-01-03   Republican 28                        
25975 25975 G000031 rep NY 1949-01-03 1951-01-03   Republican 28                        
25976 25976 G000031 rep NY 1951-01-03 1953-01-03   Republican 28                        
26321 26321 E000029 rep PA 1953-01-03 1955-01-03   Democrat 28                        
26322 26322 E000029 rep PA 1955-01-05 1957-01-03   Democrat 28                        
26323 26323 E000029 rep PA 1957-01-03 1959-01-03   Democrat 28                        
26458 26458 K000058 rep PA 1941-01-03 1943-01-03   Democrat 28                        
26459 26459 K000058 rep PA 1943-01-06 1945-01-03   Democrat 28                        
27271 27271 K000032 rep PA 1947-01-03 1949-01-03   Republican 28                        

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