legislator_terms

Table actions Table actions

764 rows where state = "IA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, class, party, district, url, 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
4422 4422 C000318 rep IA 1837-09-04 1839-03-03   Democrat -1                        
4423 4423 C000318 rep IA 1839-12-02 1841-03-03   Democrat -1                        
5436 5436 H000330 rep IA 1845-12-01 1847-03-03   Democrat -1                        
5862 5862 D000394 rep IA 1840-12-28 1841-03-03   Democrat 0                        
5863 5863 D000394 rep IA 1841-05-31 1843-03-03   Democrat 0                        
5864 5864 D000394 rep IA 1843-12-04 1845-03-03   Democrat 0                        
5865 5865 D000394 rep IA 1845-12-01 1846-12-28   Democrat 0                        
5866 5866 D000394 sen IA 1848-12-07 1849-03-03 3 Democrat                          
5867 5867 D000394 sen IA 1849-03-05 1855-02-22 3 Democrat                          
6040 6040 L000215 rep IA 1845-12-01 1847-03-03   Democrat -1                        
6041 6041 L000215 rep IA 1847-12-06 1849-03-03   Democrat 2                        
6042 6042 L000215 rep IA 1849-12-03 1851-03-03   Democrat 2                        
6063 6063 M000721 rep IA 1849-12-03 1851-03-03   Whig 1                        
6146 6146 T000223 rep IA 1847-12-06 1849-03-03   Democrat 1                        
6147 6147 T000223 rep IA 1849-12-03 1851-03-03   Democrat 1                        
6257 6257 C000445 rep IA 1851-12-01 1853-03-03   Democrat 2                        
6553 6553 C000720 rep IA 1853-12-05 1855-03-03   Whig 2                        
6606 6606 H000500 rep IA 1851-12-01 1853-03-03   Democrat 1                        
6607 6607 H000500 rep IA 1853-12-05 1855-03-03   Democrat 1                        
6631 6631 J000221 sen IA 1848-01-01 1853-03-03 2 Democrat                          
6632 6632 J000221 sen IA 1853-12-05 1859-03-03 2 Democrat                          
6826 6826 H000043 rep IA 1855-12-03 1857-03-03   Democrat 1                        
6930 6930 T000235 rep IA 1855-12-03 1857-03-03   Ind. Republican-Democrat 2                        
7023 7023 D000140 rep IA 1857-12-07 1859-03-03   Republican 2                        
7728 7728 C001013 rep IA 1857-12-07 1859-03-03   Republican 1                        
7729 7729 C001013 rep IA 1859-12-05 1861-03-03   Republican 1                        
7730 7730 C001013 rep IA 1861-07-04 1863-03-03   Republican 1                        
8127 8127 G000475 sen IA 1859-12-05 1865-03-03 2 Republican                          
8128 8128 G000475 sen IA 1865-12-04 1869-12-31 2 Republican                          
8129 8129 G000478 rep IA 1863-12-07 1865-03-03   Republican 4                        
8130 8130 G000478 rep IA 1865-12-04 1867-03-03   Republican 4                        
8311 8311 D000395 rep IA 1867-03-04 1869-03-03   Republican 5                        
8346 8346 H000211 sen IA 1855-12-03 1861-03-03 3 Republican                          
8347 8347 H000211 sen IA 1861-07-04 1865-12-31 3 Republican                          
8348 8348 H000211 sen IA 1867-03-04 1873-03-03 3 Republican                          
8359 8359 H000877 rep IA 1863-12-07 1865-03-03   Republican 6                        
8360 8360 H000877 rep IA 1865-12-04 1867-03-03   Republican 6                        
8361 8361 H000877 rep IA 1867-03-04 1869-03-03   Republican 6                        
8690 8690 P000421 rep IA 1869-03-04 1871-03-03   Republican 6                        
8722 8722 S000648 rep IA 1869-03-04 1871-03-03   Republican 2                        
8787 8787 W000676 rep IA 1869-03-04 1871-03-03   Republican 2                        
8794 8794 H000864 sen IA 1870-01-01 1871-03-03 2 Republican                          
8983 8983 P000038 rep IA 1869-03-04 1871-03-03   Republican 5                        
8984 8984 P000038 rep IA 1871-03-04 1873-03-03   Republican 5                        
9052 9052 W000034 rep IA 1871-03-04 1873-03-03   Republican 4                        
9065 9065 W000759 sen IA 1871-03-04 1877-03-03 2 Republican                          
9135 9135 C000801 rep IA 1871-03-04 1873-03-03   Republican 2                        
9136 9136 C000801 rep IA 1873-12-01 1875-03-03   Republican 2                        
9152 9152 D000413 rep IA 1871-03-04 1873-03-03   Republican 3                        
9153 9153 D000413 rep IA 1873-12-01 1875-03-03   Republican 3                        
9237 9237 L000451 rep IA 1867-03-04 1869-03-03   Republican 4                        
9238 9238 L000451 rep IA 1869-03-04 1871-03-03   Republican 4                        
9239 9239 L000451 rep IA 1873-12-01 1875-03-03   Republican 6                        
9300 9300 O000103 rep IA 1871-03-04 1873-03-03   Republican 6                        
9301 9301 O000103 rep IA 1873-12-01 1875-03-03   Republican 9                        
9442 9442 A000067 rep IA 1875-12-06 1877-03-03   Democrat 3                        
9577 9577 M000379 rep IA 1869-03-04 1871-03-03   Republican 1                        
9578 9578 M000379 rep IA 1871-03-04 1873-03-03   Republican 1                        
9579 9579 M000379 rep IA 1873-12-01 1875-03-03   Republican 1                        
9580 9580 M000379 rep IA 1875-12-06 1877-03-03   Republican 1                        
9613 9613 P000501 rep IA 1873-12-01 1875-03-03   Republican 4                        
9614 9614 P000501 rep IA 1875-12-06 1877-03-03   Republican 4                        
9663 9663 T000406 rep IA 1875-12-06 1877-03-03   Republican 2                        
9757 9757 B001078 rep IA 1877-10-15 1879-03-03   Republican 3                        
9778 9778 C000986 rep IA 1877-10-15 1879-03-03   Republican 7                        
9869 9869 K000242 sen IA 1866-01-01 1867-03-03 3 Republican                          
9870 9870 K000242 sen IA 1877-10-15 1881-12-31 2 Republican                          
9890 9890 O000076 rep IA 1875-12-06 1877-03-03   Republican 9                        
9891 9891 O000076 rep IA 1877-10-15 1879-03-03   Republican 9                        
9929 9929 S000025 rep IA 1875-12-06 1877-03-03   Republican 6                        
9930 9930 S000025 rep IA 1877-10-15 1879-03-03   Republican 6                        
9946 9946 S000960 rep IA 1877-10-15 1879-03-03   Republican 1                        
10039 10039 C000450 rep IA 1877-10-15 1879-03-03   Republican 5                        
10040 10040 C000450 rep IA 1879-03-18 1881-03-03   Republican 5                        
10087 10087 G000203 rep IA 1879-03-18 1881-03-03   National Greenbacker 7                        
10172 10172 P000525 rep IA 1863-12-07 1865-03-03   Republican 2                        
10173 10173 P000525 rep IA 1865-12-04 1867-03-03   Republican 2                        
10174 10174 P000525 rep IA 1867-03-04 1869-03-03   Republican 2                        
10175 10175 P000525 rep IA 1877-10-15 1879-03-03   Republican 2                        
10176 10176 P000525 rep IA 1879-03-18 1881-03-03   Republican 2                        
10182 10182 S000060 rep IA 1877-10-15 1879-03-03   Republican 8                        
10183 10183 S000060 rep IA 1879-03-18 1881-03-03   Republican 8                        
10289 10289 C000166 rep IA 1879-03-18 1881-03-03   Republican 9                        
10290 10290 C000166 rep IA 1881-12-05 1883-03-03   Republican 9                        
10330 10330 D000188 rep IA 1877-10-15 1879-03-03   Republican 4                        
10331 10331 D000188 rep IA 1879-03-18 1881-03-03   Republican 4                        
10332 10332 D000188 rep IA 1881-12-05 1883-03-03   Republican 4                        
10344 10344 F000039 rep IA 1881-12-05 1883-03-03   Republican 2                        
10451 10451 M000407 rep IA 1873-12-01 1875-03-03   Republican 8                        
10452 10452 M000407 rep IA 1875-12-06 1877-03-03   Republican 8                        
10453 10453 M000407 sen IA 1881-12-05 1883-03-03 2 Republican                          
10562 10562 T000224 rep IA 1879-03-18 1881-03-03   Republican 5                        
10563 10563 T000224 rep IA 1881-12-05 1883-03-03   Republican 5                        
10677 10677 C000719 rep IA 1881-12-05 1883-03-03   Democrat 6                        
10678 10678 C000719 rep IA 1883-12-03 1885-03-03   Democrat 6                        
10686 10686 C001032 rep IA 1881-12-05 1883-03-03   Republican 6                        
10687 10687 C001032 rep IA 1883-12-03 1885-03-03   Republican 6                        
10773 10773 K000018 rep IA 1863-12-07 1865-03-03   Republican 5                        
10774 10774 K000018 rep IA 1865-12-04 1867-03-03   Republican 5                        
10775 10775 K000018 rep IA 1873-12-01 1875-03-03   Republican 7                        

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