legislator_terms

Table actions Table actions

346 rows where district = 23

✎ 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
1521 1521 C000531 rep VA 1813-05-24 1815-03-03   Republican 23                        
1522 1522 C000531 rep VA 1815-12-04 1817-03-03   Republican 23                        
2439 2439 L000346 rep NY 1823-12-01 1825-03-03     23                        
2556 2556 B000023 rep NY 1825-12-05 1827-03-03   Adams 23                        
3097 3097 E000011 rep NY 1827-12-03 1829-03-03   Jackson 23                        
3098 3098 E000011 rep NY 1829-12-07 1831-03-03   Jackson 23                        
3435 3435 J000104 rep NY 1831-12-05 1833-03-03   Jackson 23                        
3796 3796 S000891 rep VA 1821-12-03 1823-03-03   Republican 23                        
3907 3907 F000415 rep NY 1833-12-02 1835-03-03   Jackson 23                        
3908 3908 F000415 rep NY 1835-12-07 1837-03-03   Jackson 23                        
3926 3926 H000276 rep PA 1833-12-02 1835-03-03   Jackson 23                        
3927 3927 H000276 rep PA 1835-12-07 1837-03-03   Jackson 23                        
4132 4132 B000437 rep NY 1837-09-04 1839-03-03   Democrat 23                        
4364 4364 T000103 rep NY 1833-12-02 1835-03-03   Jackson 23                        
4365 4365 T000103 rep NY 1835-12-07 1837-03-03   Jackson 23                        
4366 4366 T000103 rep NY 1837-09-04 1839-03-03   Democrat 23                        
4398 4398 B000284 rep PA 1837-09-04 1839-03-03   Democrat 23                        
4399 4399 B000284 rep PA 1839-12-02 1841-03-03   Democrat 23                        
4465 4465 E000012 rep NY 1839-12-02 1841-03-03   Democrat 23                        
4602 4602 R000393 rep NY 1839-12-02 1841-03-03   Democrat 23                        
4653 4653 T000450 rep VA 1815-12-04 1817-03-03   Republican 23                        
4654 4654 T000450 rep VA 1817-12-01 1819-03-03   Republican 23                        
4655 4655 T000450 rep VA 1819-12-06 1821-03-03   Republican 23                        
4696 4696 B000484 rep NY 1841-05-31 1843-03-03   Whig 23                        
4792 4792 F000296 rep NY 1841-05-31 1843-03-03   Whig 23                        
4840 4840 J000002 rep PA 1841-05-31 1843-03-03   Democrat 23                        
5275 5275 R000110 rep PA 1843-12-04 1845-03-03   Whig 23                        
5276 5276 R000351 rep NY 1843-12-04 1845-03-03   Democrat 23                        
5441 5441 H000812 rep NY 1845-12-01 1847-03-03   Democrat 23                        
5968 5968 D000515 rep NY 1847-12-06 1849-03-03   Whig 23                        
5969 5969 D000515 rep NY 1849-12-03 1851-03-03   Whig 23                        
6143 6143 T000204 rep PA 1845-12-01 1847-03-03   Democrat 23                        
6144 6144 T000204 rep PA 1847-12-06 1849-03-03   Democrat 23                        
6145 6145 T000204 rep PA 1849-12-03 1851-03-03   Democrat 23                        
6214 6214 B000005 rep NY 1851-12-01 1853-03-03   Democrat 23                        
6643 6643 L000540 rep NY 1853-12-05 1855-03-03   Independent 23                        
6726 6726 T000383 rep PA 1853-12-05 1855-03-03   Democrat 23                        
6756 6756 A000158 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 23                        
6825 6825 G000179 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 23                        
7444 7444 H000658 rep NY 1857-12-07 1859-03-03   Republican 23                        
7445 7445 H000658 rep NY 1859-12-05 1861-03-03   Republican 23                        
7591 7591 S000921 rep PA 1857-12-07 1859-03-03   Republican 23                        
7592 7592 S000921 rep PA 1859-12-05 1861-03-03   Republican 23                        
7927 7927 C000420 rep NY 1861-07-04 1863-03-03   Republican 23                        
8100 8100 D000139 rep NY 1863-12-07 1865-03-03   Republican 23                        
8101 8101 D000139 rep NY 1865-12-04 1867-03-03   Republican 23                        
8485 8485 W000538 rep PA 1863-12-07 1865-03-03   Republican 23                        
8486 8486 W000538 rep PA 1865-12-04 1867-03-03   Republican 23                        
8487 8487 W000538 rep PA 1867-03-04 1869-03-03   Republican 23                        
8666 8666 M000310 rep NY 1867-03-04 1869-03-03   Republican 23                        
8667 8667 M000310 rep NY 1869-03-04 1871-03-03   Republican 23                        
8689 8689 P000293 rep PA 1869-03-04 1871-03-03   Republican 23                        
9144 9144 C001007 rep PA 1851-12-01 1853-03-03   Democrat 23                        
9157 9157 D000513 rep NY 1871-03-04 1873-03-03   Republican 23                        
9229 9229 L000088 rep NY 1873-12-01 1875-03-03   Republican 23                        
9264 9264 M000487 rep PA 1871-03-04 1873-03-03   Republican 23                        
9265 9265 M000487 rep PA 1873-12-01 1875-03-03   Republican 23                        
9487 9487 C000561 rep PA 1875-12-06 1877-03-03   Democrat 23                        
9573 9573 L000442 rep NY 1875-12-06 1877-03-03   Democrat 23                        
9676 9676 W000079 rep PA 1861-07-04 1863-03-03   Republican 23                        
9730 9730 B000020 rep NY 1877-10-15 1879-03-03   Republican 23                        
9952 9952 T000209 rep PA 1873-12-01 1875-03-03   Republican 23                        
10510 10510 P000512 rep NY 1879-03-18 1881-03-03   Republican 23                        
10511 10511 P000512 rep NY 1881-12-05 1883-03-03   Republican 23                        
11201 11201 S000754 rep NY 1883-12-03 1885-03-03   Democrat 23                        
11202 11202 S000754 rep NY 1885-12-07 1887-03-03   Democrat 23                        
11592 11592 B000261 rep PA 1877-10-15 1879-03-03   Republican 23                        
11593 11593 B000261 rep PA 1879-03-18 1881-03-03   Republican 23                        
11594 11594 B000261 rep PA 1881-12-05 1883-03-03   Republican 23                        
11595 11595 B000261 rep PA 1883-12-03 1885-03-03   Republican 23                        
11596 11596 B000261 rep PA 1885-12-07 1887-03-03   Republican 23                        
11597 11597 B000261 rep PA 1887-12-05 1889-03-03   Republican 23                        
11598 11598 B000261 rep PA 1889-12-02 1891-03-03   Republican 23                        
12084 12084 B000393 rep NY 1891-12-07 1893-03-03   Democrat 23                        
12850 12850 W000313 rep NY 1893-08-07 1895-03-03   Republican 23                        
13306 13306 F000252 rep NY 1895-12-02 1897-03-03   Republican 23                        
13307 13307 F000252 rep NY 1897-03-15 1899-03-03   Republican 23                        
13492 13492 S000966 rep PA 1891-12-07 1893-03-03   Republican 23                        
13493 13493 S000966 rep PA 1893-08-07 1895-03-03   Republican 23                        
13494 13494 S000966 rep PA 1895-12-02 1897-03-03   Republican 23                        
13495 13495 S000966 rep PA 1897-03-15 1899-03-03   Republican 23                        
13952 13952 E000173 rep NY 1899-12-04 1901-03-03   Republican 23                        
13953 13953 E000173 rep NY 1901-12-02 1903-03-03   Republican 23                        
14280 14280 C000943 rep IL 1903-11-09 1905-03-03   Democrat 23                        
14642 14642 D000329 rep IL 1905-12-04 1907-03-03   Republican 23                        
15275 15275 S000345 rep NY 1887-12-05 1889-03-03   Republican 23                        
15276 15276 S000345 rep NY 1889-12-02 1891-03-03   Republican 23                        
15396 15396 C000745 rep PA 1903-11-09 1905-03-03   Republican 23                        
15397 15397 C000745 rep PA 1905-12-04 1907-03-03   Republican 23                        
15398 15398 C000745 rep PA 1907-12-02 1909-03-03   Republican 23                        
15399 15399 C000745 rep PA 1909-03-15 1911-03-03   Republican 23                        
15499 15499 G000363 rep PA 1897-03-15 1899-03-03   Republican 23                        
15500 15500 G000363 rep PA 1899-12-04 1901-03-03   Republican 23                        
15501 15501 G000363 rep PA 1901-12-02 1903-03-03   Republican 23                        
15741 15741 S000691 rep NY 1903-11-09 1905-03-03   Republican 23                        
15742 15742 S000691 rep NY 1905-12-04 1907-03-03   Republican 23                        
15743 15743 S000691 rep NY 1907-12-02 1909-03-03   Republican 23                        
15744 15744 S000691 rep NY 1909-03-15 1911-03-03   Republican 23                        
15930 15930 D000189 rep NY 1911-04-04 1913-03-03   Republican 23                        
16325 16325 C000180 rep PA 1913-04-07 1915-03-03   Democrat 23                        

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