legislator_terms

Table actions Table actions

39 rows where party = "Ind. Democrat"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, start, end, district, 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
4734 4734 C000230 rep IL 1841-05-31 1843-03-03   Ind. Democrat 2                        
5802 5802 P000266 rep NY 1847-12-06 1849-03-03   Ind. Democrat 17                        
6078 6078 N000047 rep PA 1843-12-04 1845-03-03   Ind. Democrat 15                        
6283 6283 D000443 rep WI 1851-12-01 1853-03-03   Ind. Democrat 3                        
6347 6347 J000153 rep OH 1851-12-01 1853-03-03   Ind. Democrat 16                        
6388 6388 P000412 rep TN 1851-12-01 1853-03-03   Ind. Democrat 6                        
6520 6520 B000492 rep IL 1853-12-05 1855-03-03   Ind. Democrat 8                        
7227 7227 S000604 rep IL 1847-12-06 1849-03-03   Ind. Democrat 1                        
7277 7277 A000234 rep MO 1859-12-05 1861-03-03   Ind. Democrat 2                        
7286 7286 B000172 rep NY 1857-12-07 1859-03-03   Ind. Democrat 4                        
7287 7287 B000172 rep NY 1859-12-05 1861-03-03   Ind. Democrat 4                        
7431 7431 H000103 rep TX 1859-12-05 1861-03-03   Ind. Democrat 2                        
7484 7484 L000176 rep VA 1859-12-05 1861-03-03   Ind. Democrat 6                        
7494 7494 M000179 rep VA 1859-12-05 1861-03-03   Ind. Democrat 13                        
7733 7733 D000202 rep VA 1859-12-05 1861-03-03   Ind. Democrat 3                        
7778 7778 K000147 rep NY 1861-07-04 1863-03-03   Ind. Democrat 4                        
8828 8828 B000523 rep MO 1857-12-07 1859-03-03   Ind. Democrat 1                        
9149 9149 D000119 rep WV 1873-12-01 1875-03-03   Ind. Democrat 1                        
10074 10074 F000070 rep GA 1875-12-06 1877-03-03   Ind. Democrat 7                        
10075 10075 F000070 rep GA 1877-10-15 1879-03-03   Ind. Democrat 7                        
10076 10076 F000070 rep GA 1879-03-18 1881-03-03   Ind. Democrat 7                        
10092 10092 H000247 rep VA 1859-12-05 1861-03-03   Ind. Democrat 9                        
10156 10156 O000011 rep NY 1879-03-18 1881-03-03   Ind. Democrat 10                        
10157 10157 O000099 rep NY 1879-03-18 1881-03-03   Ind. Democrat 2                        
10167 10167 P000248 rep GA 1879-03-18 1881-03-03   Ind. Democrat 4                        
10184 10184 S000092 rep MO 1879-03-18 1881-03-03   Ind. Democrat 8                        
10317 10317 C000885 rep AR 1877-10-15 1879-03-03   Ind. Democrat 3                        
10547 10547 S000711 rep GA 1879-03-18 1881-03-03   Ind. Democrat 9                        
10548 10548 S000711 rep GA 1881-12-05 1883-03-03   Ind. Democrat 9                        
10721 10721 F000127 rep IL 1883-12-03 1885-03-03   Ind. Democrat 2                        
10912 10912 T000425 rep KY 1879-03-18 1881-03-03   Ind. Democrat 1                        
10914 10914 T000425 rep KY 1883-12-03 1885-03-03   Ind. Democrat 1                        
10944 10944 Y000022 rep NC 1883-12-03 1885-03-03   Ind. Democrat 7                        
11448 11448 M000658 rep NY 1885-12-07 1887-03-03   Ind. Democrat 11                        
12684 12684 M000430 rep MA 1893-08-07 1895-03-03   Ind. Democrat 10                        
13733 13733 M000294 rep PA 1893-08-07 1895-03-03   Ind. Democrat 3                        
26088 26088 P000536 rep TN 1941-01-03 1943-01-03   Ind. Democrat 5                        
27076 27076 A000105 rep AR 1959-01-07 1961-01-03   Ind. Democrat 5                        
37041 37041 M000834 rep MA 1973-01-03 1975-01-03   Ind. Democrat 9                        

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