legislator_terms
307 rows where district = 24
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2646 | 2646 | K000063 | rep | NY | 1825-12-05 | 1827-03-03 | Jackson | 24 | |||||||||||||
| 2847 | 2847 | G000085 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 24 | |||||||||||||
| 3190 | 3190 | P000489 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 24 | |||||||||||||
| 3659 | 3659 | D000159 | rep | NY | 1823-12-01 | 1825-03-03 | Jacksonian | 24 | |||||||||||||
| 3660 | 3660 | D000159 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 24 | |||||||||||||
| 3842 | 3842 | B000114 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 24 | |||||||||||||
| 3843 | 3843 | B000114 | rep | PA | 1835-12-07 | 1837-03-03 | Anti Masonic | 24 | |||||||||||||
| 3894 | 3894 | D000444 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 24 | |||||||||||||
| 3895 | 3895 | D000444 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 24 | |||||||||||||
| 4036 | 4036 | P000167 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 24 | |||||||||||||
| 4303 | 4303 | N000120 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 24 | |||||||||||||
| 4830 | 4830 | H000518 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 24 | |||||||||||||
| 4831 | 4831 | H000518 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 24 | |||||||||||||
| 4832 | 4832 | H000518 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 24 | |||||||||||||
| 4907 | 4907 | M000945 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 24 | |||||||||||||
| 4908 | 4908 | M000945 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 24 | |||||||||||||
| 5370 | 5370 | B001041 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 24 | |||||||||||||
| 5371 | 5371 | B001041 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 24 | |||||||||||||
| 5573 | 5573 | W000328 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 24 | |||||||||||||
| 5574 | 5574 | W000328 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 24 | |||||||||||||
| 5743 | 5743 | I000032 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 24 | |||||||||||||
| 5981 | 5981 | G000339 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 24 | |||||||||||||
| 5982 | 5982 | G000339 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 24 | |||||||||||||
| 6310 | 6310 | G000220 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 24 | |||||||||||||
| 6311 | 6311 | G000220 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 24 | |||||||||||||
| 6627 | 6627 | J000215 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 24 | |||||||||||||
| 6628 | 6628 | J000215 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 24 | |||||||||||||
| 6761 | 6761 | B000136 | rep | PA | 1855-12-03 | 1857-03-03 | Democrat | 24 | |||||||||||||
| 7059 | 7059 | G000209 | rep | PA | 1857-12-07 | 1859-03-03 | Democrat | 24 | |||||||||||||
| 7063 | 7063 | G000373 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 24 | |||||||||||||
| 7064 | 7064 | G000373 | rep | NY | 1857-12-07 | 1859-03-03 | Republican | 24 | |||||||||||||
| 7430 | 7430 | H000046 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 24 | |||||||||||||
| 7847 | 7847 | S000221 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 24 | |||||||||||||
| 7848 | 7848 | S000221 | rep | NY | 1861-07-04 | 1863-03-03 | Republican | 24 | |||||||||||||
| 7985 | 7985 | L000154 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 24 | |||||||||||||
| 8432 | 8432 | P000424 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 24 | |||||||||||||
| 8433 | 8433 | P000424 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 24 | |||||||||||||
| 8434 | 8434 | P000424 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 24 | |||||||||||||
| 8568 | 8568 | C000827 | rep | NY | 1869-03-04 | 1871-03-03 | Republican | 24 | |||||||||||||
| 8582 | 8582 | D000412 | rep | PA | 1869-03-04 | 1871-03-03 | Republican | 24 | |||||||||||||
| 8952 | 8952 | M000335 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 24 | |||||||||||||
| 9008 | 9008 | S000223 | rep | NY | 1871-03-04 | 1873-03-03 | Republican | 24 | |||||||||||||
| 9145 | 9145 | C001007 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 24 | |||||||||||||
| 9158 | 9158 | D000513 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 24 | |||||||||||||
| 9278 | 9278 | M000925 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 24 | |||||||||||||
| 9677 | 9677 | W000079 | rep | PA | 1875-12-06 | 1877-03-03 | Republican | 24 | |||||||||||||
| 9734 | 9734 | B000077 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 24 | |||||||||||||
| 9735 | 9735 | B000077 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 24 | |||||||||||||
| 10444 | 10444 | M000222 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 24 | |||||||||||||
| 10445 | 10445 | M000222 | rep | NY | 1881-12-05 | 1883-03-03 | Republican | 24 | |||||||||||||
| 10530 | 10530 | S000281 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 24 | |||||||||||||
| 10531 | 10531 | S000281 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 24 | |||||||||||||
| 10532 | 10532 | S000281 | rep | PA | 1881-12-05 | 1883-03-03 | Republican | 24 | |||||||||||||
| 10791 | 10791 | L000134 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 24 | |||||||||||||
| 10792 | 10792 | L000134 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 24 | |||||||||||||
| 10793 | 10793 | L000134 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 24 | |||||||||||||
| 11415 | 11415 | J000024 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 24 | |||||||||||||
| 11416 | 11416 | J000024 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 24 | |||||||||||||
| 11470 | 11470 | P000138 | rep | PA | 1861-07-04 | 1863-03-03 | Republican | 24 | |||||||||||||
| 11876 | 11876 | N000174 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 24 | |||||||||||||
| 11904 | 11904 | P000359 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 24 | |||||||||||||
| 11905 | 11905 | P000359 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 24 | |||||||||||||
| 11930 | 11930 | R000078 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 24 | |||||||||||||
| 12035 | 12035 | W000452 | rep | NY | 1887-12-05 | 1889-03-03 | Republican | 24 | |||||||||||||
| 12036 | 12036 | W000452 | rep | NY | 1889-12-02 | 1891-03-03 | Republican | 24 | |||||||||||||
| 12144 | 12144 | C000854 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 24 | |||||||||||||
| 12305 | 12305 | S000900 | rep | PA | 1891-12-07 | 1893-03-03 | Republican | 24 | |||||||||||||
| 12338 | 12338 | V000041 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 24 | |||||||||||||
| 12788 | 12788 | S000451 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 24 | |||||||||||||
| 12789 | 12789 | S000451 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 24 | |||||||||||||
| 13607 | 13607 | C000351 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 24 | |||||||||||||
| 13608 | 13608 | C000351 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 24 | |||||||||||||
| 13609 | 13609 | C000351 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 24 | |||||||||||||
| 13610 | 13610 | C000351 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
| 14160 | 14160 | S000302 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
| 14479 | 14479 | S000538 | rep | NY | 1903-11-09 | 1905-03-03 | Republican | 24 | |||||||||||||
| 14532 | 14532 | W000508 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 24 | |||||||||||||
| 14769 | 14769 | L000160 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 24 | |||||||||||||
| 14961 | 14961 | A000019 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 24 | |||||||||||||
| 14962 | 14962 | A000019 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 24 | |||||||||||||
| 14963 | 14963 | A000019 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
| 14964 | 14964 | A000019 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 24 | |||||||||||||
| 14965 | 14965 | A000019 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 24 | |||||||||||||
| 14966 | 14966 | A000019 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 24 | |||||||||||||
| 14967 | 14967 | A000019 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 24 | |||||||||||||
| 15382 | 15382 | C000315 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 24 | |||||||||||||
| 15383 | 15383 | C000315 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 24 | |||||||||||||
| 15384 | 15384 | C000315 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 24 | |||||||||||||
| 15580 | 15580 | K000279 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 24 | |||||||||||||
| 15778 | 15778 | T000123 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 24 | |||||||||||||
| 16077 | 16077 | M000252 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 24 | |||||||||||||
| 16362 | 16362 | F000321 | rep | IL | 1911-04-04 | 1913-03-03 | Democrat | 24 | |||||||||||||
| 16363 | 16363 | F000321 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 24 | |||||||||||||
| 16913 | 16913 | O000049 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 24 | |||||||||||||
| 16914 | 16914 | O000049 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 24 | |||||||||||||
| 17166 | 17166 | F000005 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 24 | |||||||||||||
| 17167 | 17167 | F000005 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 24 | |||||||||||||
| 17168 | 17168 | F000005 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 24 | |||||||||||||
| 18652 | 18652 | G000038 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 24 | |||||||||||||
| 18653 | 18653 | G000038 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 24 |
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);