legislator_terms

Table actions Table actions

77 rows where party = "Unionist"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, state, start, end, class, 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
6301 6301 F000363 rep MS 1851-12-01 1853-03-03   Unionist 3                        
6346 6346 J000144 rep GA 1851-12-01 1853-03-03   Unionist 2                        
6374 6374 M001086 rep GA 1851-12-01 1853-03-03   Unionist 4                        
6375 6375 N000001 rep MS 1851-12-01 1853-03-03   Unionist 1                        
6453 6453 W000457 rep MS 1851-12-01 1853-03-03   Unionist 2                        
7117 7117 K000103 sen MD 1857-12-07 1863-03-03 1 Unionist                          
7674 7674 B000822 rep TN 1861-07-04 1863-03-03   Unionist 3                        
7675 7675 B000956 rep RI 1861-07-04 1863-03-03   Unionist 2                        
7683 7683 C000058 rep MD 1861-07-04 1863-03-03   Unionist 6                        
7688 7688 C000150 rep VA 1861-03-04 1861-07-09   Unionist 11                        
7689 7689 C000150 sen VA 1861-07-09 1865-03-03 2 Unionist                          
7690 7690 C000229 rep KY 1861-07-04 1863-03-03   Unionist 1                        
7699 7699 C000505 rep TN 1861-07-04 1863-03-03   Unionist 4                        
7721 7721 C000907 rep MD 1861-07-04 1863-03-03   Unionist 1                        
7727 7727 C000912 rep KY 1861-07-04 1863-03-03   Unionist 8                        
7739 7739 D000542 rep KY 1861-07-04 1863-03-03   Unionist 6                        
7750 7750 F000147 rep DE 1861-07-04 1863-03-03   Unionist 0                        
7751 7751 F000189 rep LA 1861-07-04 1863-03-03   Unionist 1                        
7763 7763 H000274 rep OH 1861-07-04 1863-03-03   Unionist 7                        
7773 7773 J000019 rep KY 1861-07-04 1863-03-03   Unionist 2                        
7782 7782 L000179 rep MD 1861-07-04 1863-03-03   Unionist 3                        
7788 7788 M000275 rep MD 1861-07-04 1863-03-03   Unionist 4                        
7803 7803 M000641 rep KY 1861-07-04 1863-03-03   Unionist 10                        
7860 7860 T000157 rep MA 1861-07-04 1863-03-03   Unionist 3                        
7865 7865 U000030 rep VA 1861-07-04 1863-03-03   Unionist 7                        
7887 7887 W000442 rep KY 1861-07-04 1863-03-03   Unionist 5                        
7900 7900 W000609 sen MO 1862-01-01 1863-12-31 3 Unionist                          
7902 7902 W000766 sen IN 1862-01-01 1863-03-03 1 Unionist                          
7916 7916 B000525 rep VA 1861-07-04 1863-03-03   Unionist 11                        
7920 7920 B000678 sen VA 1863-12-07 1865-03-03 1 Unionist                          
7925 7925 B000948 rep VA 1861-07-04 1863-03-03   Unionist 10                        
7929 7929 C000479 rep KY 1863-12-07 1865-03-03   Unionist 7                        
7964 7964 H000079 rep MO 1863-12-07 1865-03-03   Unionist 8                        
7977 7977 K000194 rep MO 1863-12-07 1865-03-03   Unionist 6                        
7993 7993 M000082 rep KY 1861-07-04 1863-03-03   Unionist 7                        
7994 7994 M000082 rep KY 1863-12-07 1865-03-03   Unionist 5                        
8030 8030 R000412 rep MO 1863-12-07 1865-03-03   Unionist 9                        
8032 8032 S000227 rep VA 1861-07-04 1863-03-03   Unionist 1                        
8033 8033 S000227 rep VA 1863-12-07 1865-03-03   Unionist -1                        
8068 8068 Y000015 rep KY 1861-07-04 1863-03-03   Unionist 2                        
8069 8069 Y000015 rep KY 1863-12-07 1865-03-03   Unionist 2                        
8094 8094 C000104 rep TN 1865-12-04 1867-03-03   Unionist 5                        
8095 8095 C000747 rep TN 1865-12-04 1867-03-03   Unionist 4                        
8124 8124 G000455 rep KY 1861-07-04 1863-03-03   Unionist 3                        
8125 8125 G000455 rep KY 1863-12-07 1865-03-03   Unionist 3                        
8132 8132 H000187 rep KY 1861-07-04 1863-03-03   Unionist 4                        
8133 8133 H000187 rep KY 1863-12-07 1865-03-03   Unionist 4                        
8168 8168 L000217 rep TN 1865-12-04 1867-03-03   Unionist 8                        
8212 8212 T000095 rep TN 1865-12-04 1867-03-03   Unionist 1                        
8221 8221 W000239 rep MD 1861-07-04 1863-03-03   Unionist 2                        
8230 8230 W000318 rep VA 1861-07-04 1863-03-03   Unionist 12                        
8233 8233 W000484 sen VA 1861-07-04 1863-03-03 1 Unionist                          
8465 8465 T000166 rep MD 1861-07-04 1863-03-03   Unionist 5                        
8620 8620 H000370 rep TN 1865-12-04 1867-03-03   Unionist 7                        
8668 8668 M000507 rep VA 1861-07-04 1863-03-03   Unionist 7                        
9254 9254 M000284 rep TN 1861-07-04 1863-03-03   Unionist 2                        
10553 10553 S000854 rep GA 1851-12-01 1853-03-03   Unionist 7                        
11054 11054 H000019 rep LA 1861-07-04 1863-03-03   Unionist 2                        
11241 11241 W000015 rep KY 1861-07-04 1863-03-03   Unionist 9                        
11242 11242 W000015 rep KY 1863-12-07 1865-03-03   Unionist 9                        
13077 13077 M000371 rep AZ 1869-03-04 1871-03-03   Unionist 0                        
13078 13078 M000371 rep AZ 1871-03-04 1873-03-03   Unionist 0                        
13079 13079 M000371 rep AZ 1873-12-01 1875-03-03   Unionist 0                        
15588 15588 L000102 rep PR 1905-12-04 1907-03-03   Unionist 0                        
15589 15589 L000102 rep PR 1907-12-02 1909-03-03   Unionist 0                        
15590 15590 L000102 rep PR 1909-03-15 1911-03-03   Unionist 0                        
16939 16939 R000279 rep PR 1911-04-04 1913-03-03   Unionist 0                        
16940 16940 R000279 rep PR 1913-04-07 1915-03-03   Unionist 0                        
16941 16941 R000279 rep PR 1915-12-06 1917-03-03   Unionist 0                        
20331 20331 D000090 rep PR 1917-04-02 1919-03-03   Unionist 0                        
20332 20332 D000090 rep PR 1919-05-19 1921-03-03   Unionist 0                        
20333 20333 D000090 rep PR 1921-04-11 1923-03-03   Unionist 0                        
20334 20334 D000090 rep PR 1923-12-03 1925-03-03   Unionist 0                        
20335 20335 D000090 rep PR 1925-12-07 1927-03-04   Unionist 0                        
20336 20336 D000090 rep PR 1927-12-05 1929-03-03   Unionist 0                        
20337 20337 D000090 rep PR 1929-04-15 1931-03-03   Unionist 0                        
20338 20338 D000090 rep PR 1931-12-07 1933-03-03   Unionist 0                        

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