legislator_terms

Table actions Table actions

223 rows where district = 27

✎ 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
2625 2625 H000387 rep NY 1823-12-01 1825-03-03     27                        
2626 2626 H000387 rep NY 1825-12-05 1827-03-03   Adams 27                        
3704 3704 H000860 rep NY 1833-12-02 1835-03-03   Jackson 27                        
3817 3817 W000432 rep NY 1831-12-05 1833-03-03   Anti Masonic 27                        
3993 3993 L000197 rep NY 1835-12-07 1837-03-03   Jackson 27                        
4130 4130 A000246 rep NY 1837-09-04 1839-03-03   Democrat 27                        
4539 4539 M000081 rep NY 1839-12-02 1841-03-03   Democrat 27                        
4735 4735 C000355 rep NY 1829-12-07 1831-03-03   Anti Masonic 27                        
4927 4927 O000078 rep NY 1841-05-31 1843-03-03   Democrat 27                        
5123 5123 B000152 rep NY 1827-12-03 1829-03-03   Adams 27                        
5206 5206 G000406 rep NY 1843-12-04 1845-03-03   Democrat 27                        
5408 5408 D000223 rep NY 1845-12-01 1847-03-03   Democrat 27                        
5621 5621 B000513 rep NY 1847-12-06 1849-03-03   Whig 27                        
5720 5720 H000723 rep NY 1847-12-06 1849-03-03   Whig 27                        
6404 6404 S000007 rep NY 1849-12-03 1851-03-03   Whig 27                        
6405 6405 S000007 rep NY 1851-12-01 1853-03-03   Whig 27                        
6714 6714 T000088 rep NY 1853-12-05 1855-03-03   Democrat 27                        
7178 7178 P000064 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 27                        
7179 7179 P000064 rep NY 1857-12-07 1859-03-03   Republican 27                        
7625 7625 W000280 rep NY 1859-12-05 1861-03-03   Republican 27                        
7738 7738 D000364 rep NY 1861-07-04 1863-03-03   Republican 27                        
8050 8050 V000061 rep NY 1863-12-07 1865-03-03   Republican 27                        
8759 8759 W000133 rep NY 1865-12-04 1867-03-03   Republican 27                        
8760 8760 W000133 rep NY 1867-03-04 1869-03-03   Republican 27                        
8761 8761 W000133 rep NY 1869-03-04 1871-03-03   Republican 27                        
9370 9370 S000552 rep NY 1871-03-04 1873-03-03   Republican 27                        
9496 9496 E000087 rep PA 1875-12-06 1877-03-03   Democrat 27                        
10158 10158 O000119 rep PA 1879-03-18 1881-03-03   Republican 27                        
10426 10426 L000092 rep NY 1875-12-06 1877-03-03   Republican 27                        
10427 10427 L000092 rep NY 1877-10-15 1879-03-03   Republican 27                        
10428 10428 L000092 rep NY 1879-03-18 1881-03-03   Republican 27                        
10643 10643 B000761 rep PA 1883-12-03 1885-03-03   Republican 27                        
11505 11505 S000188 rep PA 1885-12-07 1887-03-03   Democrat 27                        
11506 11506 S000188 rep PA 1887-12-05 1889-03-03   Democrat 27                        
11877 11877 N000174 rep NY 1887-12-05 1889-03-03   Republican 27                        
11878 11878 N000174 rep NY 1889-12-02 1891-03-03   Republican 27                        
12017 12017 W000204 rep PA 1877-10-15 1879-03-03   Republican 27                        
12018 12018 W000204 rep PA 1881-12-05 1883-03-03   Republican 27                        
12019 12019 W000204 rep PA 1889-12-02 1891-03-03   Republican 27                        
13126 13126 P000429 rep NY 1895-12-02 1897-03-03   Republican 27                        
13252 13252 B000325 rep NY 1893-08-07 1895-03-03   Republican 27                        
13253 13253 B000325 rep NY 1897-03-15 1899-03-03   Republican 27                        
13487 13487 S000953 rep PA 1889-12-02 1891-03-03   Republican 27                        
13488 13488 S000953 rep PA 1891-12-07 1893-03-03   Republican 27                        
13489 13489 S000953 rep PA 1893-08-07 1895-03-03   Republican 27                        
13490 13490 S000953 rep PA 1895-12-02 1897-03-03   Republican 27                        
13491 13491 S000953 rep PA 1897-03-15 1899-03-03   Republican 27                        
14437 14437 P000383 rep NY 1873-12-01 1875-03-03   Republican 27                        
14891 14891 S000398 rep PA 1899-12-04 1901-03-03   Democrat 27                        
14892 14892 S000398 rep PA 1901-12-02 1903-03-03   Republican 27                        
14901 14901 S000635 rep PA 1903-11-09 1905-03-03   Republican 27                        
14902 14902 S000635 rep PA 1905-12-04 1907-03-03   Republican 27                        
14931 14931 W000011 rep NY 1881-12-05 1883-03-03   Republican 27                        
14932 14932 W000011 rep NY 1883-12-03 1885-03-03   Republican 27                        
14977 14977 B000267 rep PA 1907-12-02 1909-03-03   Republican 27                        
15282 15282 S000345 rep NY 1903-11-09 1905-03-03   Republican 27                        
15283 15283 S000345 rep NY 1905-12-04 1907-03-03   Republican 27                        
15284 15284 S000345 rep NY 1907-12-02 1909-03-03   Republican 27                        
15652 15652 M000772 rep NY 1909-03-15 1911-03-03   Republican 27                        
15944 15944 D000502 rep NY 1899-12-04 1901-03-03   Republican 27                        
15945 15945 D000502 rep NY 1901-12-02 1903-03-03   Republican 27                        
16439 16439 L000071 rep PA 1909-03-15 1911-03-03   Republican 27                        
16440 16440 L000071 rep PA 1911-04-04 1913-03-03   Republican 27                        
16441 16441 L000071 rep PA 1913-04-07 1915-03-03   Republican 27                        
16475 16475 M000330 rep NY 1913-04-07 1915-03-03   Democrat 27                        
16509 16509 P000153 rep NY 1885-12-07 1887-03-03   Republican 27                        
16510 16510 P000153 rep NY 1889-12-02 1891-03-03   Republican 27                        
16511 16511 P000153 rep NY 1891-12-07 1893-03-03   Republican 27                        
16599 16599 T000023 rep NY 1911-04-04 1913-03-03   Democrat 27                        
16911 16911 N000141 rep PA 1915-12-06 1917-03-03   Republican 27                        
18876 18876 W000129 rep NY 1915-12-06 1917-03-03   Republican 27                        
18877 18877 W000129 rep NY 1917-04-02 1919-03-03   Republican 27                        
18878 18878 W000129 rep NY 1919-05-19 1921-03-03   Republican 27                        
18879 18879 W000129 rep NY 1921-04-11 1923-03-03   Republican 27                        
18880 18880 W000129 rep NY 1923-12-03 1925-03-03   Republican 27                        
20775 20775 P000499 rep NY 1925-12-07 1927-03-04   Republican 27                        
20776 20776 P000499 rep NY 1927-12-05 1929-03-03   Republican 27                        
20777 20777 P000499 rep NY 1929-04-15 1931-03-03   Republican 27                        
20778 20778 P000499 rep NY 1931-12-07 1933-03-03   Republican 27                        
21563 21563 S001015 rep PA 1917-04-02 1919-03-03   Republican 27                        
21564 21564 S001015 rep PA 1919-05-19 1921-03-03   Republican 27                        
21565 21565 S001015 rep PA 1921-04-11 1923-03-03   Republican 27                        
21566 21566 S001015 rep PA 1923-12-03 1925-03-03   Republican 27                        
21567 21567 S001015 rep PA 1925-12-07 1927-03-04   Republican 27                        
21568 21568 S001015 rep PA 1927-12-05 1929-03-03   Republican 27                        
21569 21569 S001015 rep PA 1929-04-15 1931-03-03   Republican 27                        
21570 21570 S001015 rep PA 1931-12-07 1933-03-03   Republican 27                        
21571 21571 S001015 rep PA 1933-03-09 1935-01-03   Republican 27                        
22184 22184 G000302 rep NY 1933-03-09 1935-01-03   Republican 27                        
22185 22185 G000302 rep NY 1935-01-03 1937-01-03   Republican 27                        
22186 22186 G000302 rep NY 1937-01-05 1939-01-03   Republican 27                        
22194 22194 G000399 rep PA 1935-01-03 1937-01-03   Democrat 27                        
22195 22195 G000399 rep PA 1937-01-05 1939-01-03   Democrat 27                        
23189 23189 R000362 rep NY 1937-01-05 1939-01-03   Republican 27                        
23190 23190 R000362 rep NY 1939-01-03 1941-01-03   Republican 27                        
23191 23191 R000362 rep NY 1941-01-03 1943-01-03   Republican 27                        
24704 24704 T000263 rep PA 1939-01-03 1941-01-03   Republican 27                        
24705 24705 T000263 rep PA 1941-01-03 1943-01-03   Republican 27                        
24706 24706 T000263 rep PA 1943-01-06 1945-01-03   Republican 27                        
24879 24879 L000161 rep NY 1943-01-06 1945-01-03   Republican 27                        

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