legislator_terms

Table actions Table actions

537 rows where state = "AR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, class, party, district, url, address, phone, fax, contact_form, office, state_rank, 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
2196 2196 B000235 rep AR 1819-12-06 1821-03-03     -1                        
2197 2197 B000235 rep AR 1821-12-03 1823-03-03     -1                        
2820 2820 C000712 rep AR 1823-12-01 1825-03-03     -1                        
2821 2821 C000712 rep AR 1825-12-05 1827-03-03     -1                        
2822 2822 C000712 rep AR 1827-12-03 1829-03-03     -1                        
4797 4797 F000425 sen AR 1836-01-01 1841-03-03 2 Democrat                          
4798 4798 F000425 sen AR 1841-05-31 1845-03-03 2 Democrat                          
5180 5180 C000930 rep AR 1839-12-02 1841-03-03   Democrat 1                        
5181 5181 C000930 rep AR 1841-05-31 1843-03-03   Democrat 1                        
5182 5182 C000930 rep AR 1843-12-04 1845-03-03   Democrat 1                        
5289 5289 S000256 rep AR 1828-02-23 1829-03-03   Jacksonian -1                        
5290 5290 S000256 rep AR 1829-12-07 1831-03-03   Jacksonian -1                        
5291 5291 S000256 rep AR 1831-12-05 1833-03-03   Jacksonian -1                        
5292 5292 S000256 rep AR 1833-12-02 1835-03-03   Jacksonian -1                        
5293 5293 S000256 rep AR 1835-12-07 1836-06-15   Jacksonian -1                        
5294 5294 S000256 sen AR 1836-09-18 1837-03-03 3 Democrat                          
5295 5295 S000256 sen AR 1837-09-04 1843-03-03 3 Democrat                          
5296 5296 S000256 sen AR 1843-12-04 1848-03-15 3 Democrat                          
5488 5488 N000077 rep AR 1845-12-01 1847-03-03   Whig 1                        
5581 5581 Y000017 rep AR 1835-12-07 1837-03-03   Jackson 1                        
5582 5582 Y000017 rep AR 1837-09-04 1839-03-03   Democrat 1                        
5583 5583 Y000017 rep AR 1845-12-01 1847-03-03   Democrat 1                        
5601 5601 A000311 sen AR 1844-01-01 1847-03-03 2 Democrat                          
5602 5602 A000311 sen AR 1847-12-06 1849-03-03 2 Democrat                          
5860 5860 B000642 sen AR 1848-03-30 1849-03-03 3 Democrat                          
5861 5861 B000642 sen AR 1849-03-05 1853-04-11 3 Democrat                          
6845 6845 J000172 rep AR 1847-12-06 1849-03-03   Democrat 1                        
6846 6846 J000172 rep AR 1849-12-03 1851-03-03   Democrat 1                        
6847 6847 J000172 rep AR 1851-12-01 1853-03-03   Democrat 1                        
6848 6848 J000172 sen AR 1853-12-05 1855-03-03 3 Democrat                          
6849 6849 J000172 sen AR 1855-12-03 1861-03-03 3 Democrat                          
7068 7068 G000436 rep AR 1853-12-05 1855-03-03   Democrat 1                        
7069 7069 G000436 rep AR 1855-12-03 1857-03-03   Democrat 1                        
7070 7070 G000436 rep AR 1857-12-07 1859-03-03   Democrat 1                        
7244 7244 W000163 rep AR 1853-12-05 1855-03-03   Democrat 2                        
7245 7245 W000163 rep AR 1857-12-07 1859-03-03   Democrat 2                        
7443 7443 H000628 rep AR 1859-12-05 1861-03-03   Democrat 1                        
7559 7559 R000544 rep AR 1855-12-03 1857-03-03   Democrat 2                        
7560 7560 R000544 rep AR 1859-12-05 1861-03-03   Democrat 2                        
7564 7564 S000216 sen AR 1848-01-01 1853-03-03 2 Democrat                          
7565 7565 S000216 sen AR 1853-12-05 1859-03-03 2 Democrat                          
7566 7566 S000216 sen AR 1859-12-05 1861-12-31 2 Democrat                          
7804 7804 M000801 sen AR 1861-07-04 1861-12-31 3 Democrat                          
8330 8330 E000123 rep AR 1867-03-04 1869-03-03   Republican 2                        
8353 8353 H000631 rep AR 1867-03-04 1869-03-03   Republican 2                        
8495 8495 M000408 sen AR 1868-01-01 1871-03-03 2 Republican                          
8498 8498 R000195 sen AR 1868-01-01 1873-03-03 3 Republican                          
8703 8703 R000388 rep AR 1869-03-04 1871-03-03   Democrat 2                        
8704 8704 R000434 rep AR 1867-03-04 1869-03-03   Republican 1                        
8705 8705 R000434 rep AR 1869-03-04 1871-03-03   Republican 1                        
8835 8835 B000603 rep AR 1867-03-04 1869-03-03   Republican 3                        
8836 8836 B000603 rep AR 1869-03-04 1871-03-03   Republican 3                        
8837 8837 B000603 rep AR 1871-03-04 1873-03-03   Republican 3                        
8858 8858 C000498 sen AR 1871-03-04 1877-03-03 2 Republican                          
8885 8885 E000072 rep AR 1871-03-04 1873-03-03   Liberal Republican 3                        
8922 8922 H000157 rep AR 1871-03-04 1873-03-03   Democrat 1                        
9154 9154 D000441 sen AR 1873-12-01 1879-03-03 3 Republican                          
9201 9201 H000671 rep AR 1873-12-01 1875-03-03   Republican 1                        
9216 9216 H001027 rep AR 1873-12-01 1875-03-03   Liberal Republican -1                        
9375 9375 S000671 rep AR 1871-03-04 1873-03-03   Republican 2                        
9376 9376 S000671 rep AR 1873-12-01 1875-03-03   Republican 2                        
9703 9703 W000567 rep AR 1873-12-01 1875-03-03   Republican 3                        
9704 9704 W000567 rep AR 1875-12-06 1877-03-03   Democrat 3                        
9820 9820 G000100 rep AR 1875-12-06 1877-03-03   Democrat 1                        
9821 9821 G000100 rep AR 1877-10-15 1879-03-03   Democrat 1                        
10193 10193 S000484 rep AR 1875-12-06 1877-03-03   Democrat 2                        
10194 10194 S000484 rep AR 1877-10-15 1879-03-03   Democrat 2                        
10195 10195 S000484 rep AR 1879-03-18 1881-03-03   Democrat 2                        
10212 10212 W000057 sen AR 1879-03-18 1885-03-03 3 Democrat                          
10317 10317 C000885 rep AR 1877-10-15 1879-03-03   Ind. Democrat 3                        
10318 10318 C000885 rep AR 1879-03-18 1881-03-03   Democrat 3                        
10319 10319 C000885 rep AR 1881-12-05 1883-03-03   Democrat 3                        
10357 10357 G000527 rep AR 1873-12-01 1875-03-03   Democrat 3                        
10358 10358 G000527 rep AR 1875-12-06 1877-03-03   Democrat 4                        
10359 10359 G000527 rep AR 1877-10-15 1879-03-03   Democrat 4                        
10360 10360 G000527 rep AR 1879-03-18 1881-03-03   Democrat 4                        
10361 10361 G000527 rep AR 1881-12-05 1883-03-03   Democrat 4                        
10723 10723 G000065 sen AR 1877-10-15 1883-03-03 2 Democrat                          
10724 10724 G000065 sen AR 1883-12-03 1885-12-31 2 Democrat                          
11353 11353 D000552 rep AR 1879-03-18 1881-03-03   Democrat 1                        
11354 11354 D000552 rep AR 1881-12-05 1883-03-03   Democrat 1                        
11355 11355 D000552 rep AR 1883-12-03 1885-03-03   Democrat 1                        
11356 11356 D000552 rep AR 1885-12-07 1887-03-03   Democrat 1                        
11357 11357 D000552 rep AR 1887-12-05 1889-03-03   Democrat 1                        
11752 11752 F000056 rep AR 1889-12-02 1891-03-03   Union Labor 1                        
11936 11936 R000399 rep AR 1883-12-03 1885-03-03   Democrat 3                        
11937 11937 R000399 rep AR 1885-12-07 1887-03-03   Democrat 4                        
11938 11938 R000399 rep AR 1887-12-05 1889-03-03   Democrat 4                        
11939 11939 R000399 rep AR 1889-12-02 1891-03-03   Democrat 4                        
12131 12131 C000249 rep AR 1889-12-02 1891-03-03   Democrat 1                        
12132 12132 C000249 rep AR 1891-12-07 1893-03-03   Democrat 1                        
12265 12265 P000184 rep AR 1883-12-03 1885-03-03   Democrat 4                        
12266 12266 P000184 rep AR 1885-12-07 1887-03-03   Democrat 5                        
12267 12267 P000184 rep AR 1887-12-05 1889-03-03   Democrat 5                        
12268 12268 P000184 rep AR 1889-12-02 1891-03-03   Democrat 5                        
12269 12269 P000184 rep AR 1891-12-07 1893-03-03   Democrat 5                        
12425 12425 B000784 rep AR 1883-12-03 1885-03-03   Democrat -1                        
12426 12426 B000784 rep AR 1885-12-07 1887-03-03   Democrat 2                        
12427 12427 B000784 rep AR 1887-12-05 1889-03-03   Democrat 2                        
12428 12428 B000784 rep AR 1889-12-02 1891-03-03   Democrat 2                        

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