legislator_terms

Table actions Table actions

394 rows where district = 22

✎ 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
1516 1516 C000531 rep VA 1803-10-17 1805-03-03   Republican 22                        
1517 1517 C000531 rep VA 1805-12-02 1807-03-03   Republican 22                        
1518 1518 C000531 rep VA 1807-10-26 1809-03-03   Republican 22                        
1519 1519 C000531 rep VA 1809-05-22 1811-03-03   Republican 22                        
1520 1520 C000531 rep VA 1811-11-04 1813-03-03   Republican 22                        
2281 2281 N000035 rep VA 1813-05-24 1815-03-03   Republican 22                        
2282 2282 N000035 rep VA 1815-12-04 1817-03-03   Republican 22                        
2283 2283 N000035 rep VA 1817-12-01 1819-03-03   Republican 22                        
2284 2284 N000035 rep VA 1819-12-06 1821-03-03   Republican 22                        
2285 2285 N000035 rep VA 1821-12-03 1823-03-03   Republican 22                        
2401 2401 D000584 rep NY 1823-12-01 1825-03-03     22                        
2506 2506 T000343 rep NY 1821-12-03 1823-03-03   Republican 22                        
2596 2596 E000223 rep VA 1825-12-05 1827-03-03   Adams 22                        
2690 2690 M000737 rep NY 1825-12-05 1827-03-03   Adams 22                        
2971 2971 S000986 rep NY 1827-12-03 1829-03-03   Jackson 22                        
3052 3052 B000308 rep NY 1829-12-07 1831-03-03   Anti-Jacksonian 22                        
3213 3213 S000646 rep VA 1823-12-01 1825-03-03   Republican 22                        
3214 3214 S000646 rep VA 1827-12-03 1829-03-03   Jackson 22                        
3215 3215 S000646 rep VA 1829-12-07 1831-03-03   Jackson 22                        
3368 3368 D000487 rep VA 1829-12-07 1831-03-03   Jackson 22                        
3369 3369 D000487 rep VA 1831-12-05 1833-03-03   Jackson 22                        
3436 3436 J000185 rep VA 1831-12-05 1833-03-03   Jackson 22                        
3535 3535 R000115 rep NY 1831-12-05 1833-03-03   Jackson 22                        
3699 3699 H000089 rep NY 1833-12-02 1835-03-03   Jackson 22                        
3702 3702 H000345 rep NY 1833-12-02 1835-03-03   Jackson 22                        
3891 3891 D000248 rep PA 1833-12-02 1835-03-03   Anti Masonic 22                        
3892 3892 D000248 rep PA 1835-12-07 1837-03-03   Anti Masonic 22                        
4042 4042 R000177 rep NY 1835-12-07 1837-03-03   Jackson 22                        
4131 4131 B000311 rep NY 1837-09-04 1839-03-03   Democrat 22                        
4146 4146 B000984 rep NY 1837-09-04 1839-03-03   Democrat 22                        
4213 4213 G000397 rep NY 1837-09-04 1839-03-03   Democrat 22                        
4403 4403 B000443 rep PA 1837-09-04 1839-03-03   Anti Masonic 22                        
4404 4404 B000443 rep PA 1839-12-02 1841-03-03   Anti Masonic 22                        
4408 4408 B000732 rep PA 1839-12-02 1841-03-03   Whig 22                        
4537 4537 L000249 rep NY 1835-12-07 1837-03-03   Jackson 22                        
4538 4538 L000249 rep NY 1839-12-02 1841-03-03   Democrat 22                        
4839 4839 I000044 rep PA 1841-05-31 1843-03-03   Whig 22                        
4931 4931 P000093 rep NY 1841-05-31 1843-03-03   Democrat 22                        
4968 4968 R000255 rep NY 1841-05-31 1843-03-03   Democrat 22                        
5183 5183 D000020 rep NY 1839-12-02 1841-03-03   Democrat 22                        
5215 5215 H000406 rep PA 1843-12-04 1845-03-03   Democrat 22                        
5267 5267 P000571 rep NY 1843-12-04 1845-03-03   Democrat 22                        
5424 5424 G000089 rep PA 1845-12-01 1847-03-03   Democrat 22                        
5533 5533 S001018 rep NY 1845-12-01 1847-03-03   Democrat 22                        
5617 5617 B000480 rep NY 1847-12-06 1849-03-03   Democrat 22                        
5690 5690 F000031 rep PA 1847-12-06 1849-03-03   Whig 22                        
6334 6334 H000853 rep PA 1849-12-03 1851-03-03   Free Soil 22                        
6335 6335 H000853 rep PA 1851-12-01 1853-03-03   Whig 22                        
6621 6621 H000854 rep PA 1853-12-05 1855-03-03   Whig 22                        
6692 6692 S000542 rep NY 1853-12-05 1855-03-03   Free Soil 22                        
6871 6871 M000319 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 22                        
6976 6976 B000376 rep NY 1849-12-03 1851-03-03   Whig 22                        
6977 6977 B000376 rep NY 1851-12-01 1853-03-03   Whig 22                        
7061 7061 G000300 rep NY 1853-12-05 1855-03-03   Whig 22                        
7062 7062 G000300 rep NY 1857-12-07 1859-03-03   Republican 22                        
7190 7190 P000576 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 22                        
7191 7191 P000576 rep PA 1857-12-07 1859-03-03   Republican 22                        
7485 7485 L000199 rep NY 1859-12-05 1861-03-03   Republican 22                        
7799 7799 M000531 rep PA 1859-12-05 1861-03-03   Republican 22                        
7800 7800 M000531 rep PA 1861-07-04 1863-03-03   Republican 22                        
7986 7986 L000357 rep NY 1863-12-07 1865-03-03   Republican 22                        
8141 8141 H000742 rep NY 1865-12-04 1867-03-03   Republican 22                        
8399 8399 M000929 rep PA 1863-12-07 1865-03-03   Republican 22                        
8400 8400 M000929 rep PA 1865-12-04 1867-03-03   Republican 22                        
8401 8401 M000929 rep PA 1867-03-04 1869-03-03   Republican 22                        
8549 8549 C000392 rep NY 1867-03-04 1869-03-03   Republican 22                        
8550 8550 C000392 rep NY 1869-03-04 1871-03-03   Republican 22                        
9227 9227 L000088 rep NY 1861-07-04 1863-03-03   Republican 22                        
9228 9228 L000088 rep NY 1871-03-04 1873-03-03   Republican 22                        
9328 9328 R000310 rep NY 1873-12-01 1875-03-03   Republican 22                        
9731 9731 B000032 rep NY 1875-12-06 1877-03-03   Republican 22                        
9732 9732 B000032 rep NY 1877-10-15 1879-03-03   Republican 22                        
10340 10340 E000207 rep PA 1877-10-15 1879-03-03   Republican 22                        
10341 10341 E000207 rep PA 1879-03-18 1881-03-03   Republican 22                        
10342 10342 E000207 rep PA 1881-12-05 1883-03-03   Republican 22                        
10465 10465 M000760 rep NY 1879-03-18 1881-03-03   Republican 22                        
10756 10756 H000775 rep PA 1875-12-06 1877-03-03   Democrat 22                        
10757 10757 H000775 rep PA 1883-12-03 1885-03-03   Democrat 22                        
10890 10890 S000467 rep NY 1881-12-05 1883-03-03   Republican 22                        
10891 10891 S000467 rep NY 1883-12-03 1885-03-03   Republican 22                        
11146 11146 N000024 rep PA 1869-03-04 1871-03-03   Republican 22                        
11147 11147 N000024 rep PA 1871-03-04 1873-03-03   Republican 22                        
11148 11148 N000024 rep PA 1873-12-01 1875-03-03   Republican 22                        
11149 11149 N000024 rep PA 1885-12-07 1887-03-03   Republican 22                        
11468 11468 P000053 rep NY 1885-12-07 1887-03-03   Republican 22                        
11469 11469 P000053 rep NY 1887-12-05 1889-03-03   Republican 22                        
11818 11818 L000085 rep NY 1889-12-02 1891-03-03   Republican 22                        
12282 12282 R000535 rep NY 1891-12-07 1893-03-03   Republican 22                        
12991 12991 C001012 rep NY 1891-12-07 1893-03-03   Republican 22                        
12992 12992 C001012 rep NY 1893-08-07 1895-03-03   Republican 22                        
12993 12993 C001012 rep NY 1895-12-02 1897-03-03   Republican 22                        
14780 14780 L000347 rep NY 1897-03-15 1899-03-03   Republican 22                        
14781 14781 L000347 rep NY 1899-12-04 1901-03-03   Republican 22                        
14782 14782 L000347 rep NY 1901-12-02 1903-03-03   Republican 22                        
15291 15291 S000541 rep IL 1895-12-02 1897-03-03   Republican 22                        
15292 15292 S000541 rep IL 1897-03-15 1899-03-03   Republican 22                        
15293 15293 S000541 rep IL 1899-12-04 1901-03-03   Republican 22                        
15294 15294 S000541 rep IL 1901-12-02 1903-03-03   Republican 22                        
15540 15540 H000911 rep PA 1903-11-09 1905-03-03   Republican 22                        
15541 15541 H000911 rep PA 1905-12-04 1907-03-03   Republican 22                        

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