legislator_terms

Table actions Table actions

271 rows where district = 25

✎ 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
2434 2434 L000138 rep NY 1823-12-01 1825-03-03     25                        
2639 2639 H000950 rep NY 1825-12-05 1827-03-03   Adams 25                        
3008 3008 W000712 rep NY 1827-12-03 1829-03-03   Adams 25                        
3174 3174 M000271 rep NY 1829-12-07 1831-03-03   Jackson 25                        
3314 3314 B000194 rep NY 1831-12-05 1833-03-03   Anti Masonic 25                        
3866 3866 C000306 rep NY 1835-12-07 1837-03-03   Jackson 25                        
4133 4133 B000483 rep NY 1837-09-04 1839-03-03   Democrat 25                        
4473 4473 G000011 rep PA 1833-12-02 1835-03-03   Jackson 25                        
4474 4474 G000011 rep PA 1835-12-07 1837-03-03   Jackson 25                        
4475 4475 G000011 rep PA 1839-12-02 1841-03-03   Democrat 25                        
4619 4619 S001020 rep NY 1839-12-02 1841-03-03   Democrat 25                        
4885 4885 M000285 rep NY 1841-05-31 1843-03-03   Whig 25                        
4938 4938 P000391 rep PA 1837-09-04 1839-03-03   Democrat 25                        
4939 4939 P000391 rep PA 1841-05-31 1843-03-03   Democrat 25                        
5504 5504 R000069 rep NY 1843-12-04 1845-03-03   Democrat 25                        
5505 5505 R000069 rep NY 1845-12-01 1847-03-03   Democrat 25                        
5942 5942 C000676 rep NY 1847-12-06 1849-03-03   Whig 25                        
5943 5943 C000676 rep NY 1849-12-03 1851-03-03   Whig 25                        
6336 6336 H000855 rep NY 1851-12-01 1853-03-03   Democrat 25                        
6547 6547 C000451 rep NY 1833-12-02 1835-03-03   Jackson 25                        
7159 7159 M000948 rep NY 1853-12-05 1855-03-03   Whig 25                        
7160 7160 M000948 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 25                        
7161 7161 M000948 rep NY 1857-12-07 1859-03-03   Republican 25                        
7334 7334 B001199 rep NY 1859-12-05 1861-03-03   Republican 25                        
7380 7380 D000303 rep PA 1853-12-05 1855-03-03   Whig 25                        
7381 7381 D000303 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 25                        
7382 7382 D000303 rep PA 1857-12-07 1859-03-03   Republican 25                        
7657 7657 B000002 rep PA 1859-12-05 1861-03-03   Republican 25                        
7658 7658 B000002 rep PA 1861-07-04 1863-03-03   Republican 25                        
8177 8177 M000974 rep NY 1863-12-07 1865-03-03   Republican 25                        
8178 8178 M000974 rep NY 1865-12-04 1867-03-03   Republican 25                        
8431 8431 P000424 rep NY 1861-07-04 1863-03-03   Republican 25                        
8656 8656 K000080 rep NY 1867-03-04 1869-03-03   Republican 25                        
8657 8657 K000080 rep NY 1869-03-04 1871-03-03   Republican 25                        
9225 9225 L000042 rep NY 1871-03-04 1873-03-03   Republican 25                        
9539 9539 J000091 rep PA 1875-12-06 1877-03-03   Democrat 25                        
9571 9571 L000182 rep NY 1875-12-06 1877-03-03   Republican 25                        
9574 9574 M000007 rep NY 1873-12-01 1875-03-03   Republican 25                        
10218 10218 W000373 rep PA 1877-10-15 1879-03-03   Republican 25                        
10219 10219 W000373 rep PA 1879-03-18 1881-03-03   Republican 25                        
10473 10473 M001030 rep PA 1881-12-05 1883-03-03   National Greenbacker 25                        
10832 10832 P000139 rep PA 1883-12-03 1885-03-03   Democrat 25                        
11265 11265 W000354 rep PA 1885-12-07 1887-03-03   Republican 25                        
11396 11396 H000643 rep NY 1877-10-15 1879-03-03   Republican 25                        
11397 11397 H000643 rep NY 1879-03-18 1881-03-03   Republican 25                        
11398 11398 H000643 rep NY 1881-12-05 1883-03-03   Republican 25                        
11399 11399 H000643 rep NY 1883-12-03 1885-03-03   Republican 25                        
11400 11400 H000643 rep NY 1885-12-07 1887-03-03   Republican 25                        
11439 11439 M000044 rep PA 1887-12-05 1889-03-03   Republican 25                        
11986 11986 T000329 rep PA 1889-12-02 1891-03-03   Republican 25                        
12181 12181 G000195 rep PA 1891-12-07 1893-03-03   Democrat 25                        
13120 13120 P000313 rep PA 1893-08-07 1895-03-03   Republican 25                        
13121 13121 P000313 rep PA 1895-12-02 1897-03-03   Republican 25                        
13249 13249 B000325 rep NY 1887-12-05 1889-03-03   Republican 25                        
13250 13250 B000325 rep NY 1889-12-02 1891-03-03   Republican 25                        
13251 13251 B000325 rep NY 1891-12-07 1893-03-03   Republican 25                        
14167 14167 S000385 rep PA 1897-03-15 1899-03-03   Republican 25                        
14168 14168 S000385 rep PA 1899-12-04 1901-03-03   Republican 25                        
14169 14169 S000385 rep PA 1901-12-02 1903-03-03   Republican 25                        
14783 14783 L000347 rep NY 1903-11-09 1905-03-03   Republican 25                        
14784 14784 L000347 rep NY 1905-12-04 1907-03-03   Republican 25                        
15277 15277 S000345 rep NY 1893-08-07 1895-03-03   Republican 25                        
15278 15278 S000345 rep NY 1895-12-02 1897-03-03   Republican 25                        
15279 15279 S000345 rep NY 1897-03-15 1899-03-03   Republican 25                        
15280 15280 S000345 rep NY 1899-12-04 1901-03-03   Republican 25                        
15281 15281 S000345 rep NY 1901-12-02 1903-03-03   Republican 25                        
15295 15295 S000541 rep IL 1903-11-09 1905-03-03   Republican 25                        
15296 15296 S000541 rep IL 1905-12-04 1907-03-03   Republican 25                        
15297 15297 S000541 rep IL 1907-12-02 1909-03-03   Republican 25                        
15435 15435 D000567 rep NY 1907-12-02 1909-03-03   Republican 25                        
15436 15436 D000567 rep NY 1909-03-15 1911-03-03   Republican 25                        
15830 15830 A000071 rep NY 1911-04-04 1913-03-03   Progressive Republican 25                        
15848 15848 B000230 rep PA 1903-11-09 1905-03-03   Republican 25                        
15849 15849 B000230 rep PA 1905-12-04 1907-03-03   Republican 25                        
15850 15850 B000230 rep PA 1907-12-02 1909-03-03   Republican 25                        
15851 15851 B000230 rep PA 1909-03-15 1911-03-03   Republican 25                        
15852 15852 B000230 rep PA 1911-04-04 1913-03-03   Republican 25                        
16212 16212 T000154 rep IL 1907-12-02 1909-03-03   Republican 25                        
16213 16213 T000154 rep IL 1909-03-15 1911-03-03   Republican 25                        
16214 16214 T000154 rep IL 1911-04-04 1913-03-03   Republican 25                        
16601 16601 T000066 rep NY 1913-04-07 1915-03-03   Democrat 25                        
16848 16848 L000303 rep PA 1915-12-06 1917-03-03   Democrat 25                        
17103 17103 C000433 rep PA 1917-04-02 1919-03-03   Republican 25                        
18231 18231 H001005 rep NY 1915-12-06 1917-03-03   Republican 25                        
18232 18232 H001005 rep NY 1917-04-02 1919-03-03   Republican 25                        
18233 18233 H001005 rep NY 1919-05-19 1921-03-03   Republican 25                        
18234 18234 H001005 rep NY 1921-04-11 1923-03-03   Republican 25                        
19658 19658 D000237 rep IL 1915-12-06 1917-03-03   Republican 25                        
19659 19659 D000237 rep IL 1917-04-02 1919-03-03   Republican 25                        
19660 19660 D000237 rep IL 1919-05-19 1921-03-03   Republican 25                        
19661 19661 D000237 rep IL 1921-04-11 1923-03-03   Republican 25                        
19662 19662 D000237 rep IL 1923-12-03 1925-03-03   Republican 25                        
19663 19663 D000237 rep IL 1925-12-07 1927-03-04   Republican 25                        
19664 19664 D000237 rep IL 1927-12-05 1929-03-03   Republican 25                        
19665 19665 D000237 rep IL 1929-04-15 1931-03-03   Republican 25                        
20026 20026 W000023 rep NY 1923-12-03 1925-03-03   Republican 25                        
20027 20027 W000023 rep NY 1925-12-07 1927-03-04   Republican 25                        
20028 20028 W000023 rep NY 1927-12-05 1929-03-03   Republican 25                        
20029 20029 W000023 rep NY 1929-04-15 1931-03-03   Republican 25                        
20847 20847 S000387 rep PA 1913-04-07 1915-03-03   Republican 25                        

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