legislator_terms

Table actions Table actions

307 rows where district = 24

✎ 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
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                        

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