legislator_terms
223 rows where district = 27
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 |
Advanced export
JSON shape: default, array, newline-delimited
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);