legislator_terms

Table actions Table actions

129 rows where party = "Ind. Republican-Democrat"

✎ 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
6189 6189 P000506 sen MD 1850-01-12 1851-03-03 1 Ind. Republican-Democrat                          
6190 6190 P000506 sen MD 1851-03-05 1857-03-03 1 Ind. Republican-Democrat                          
6295 6295 F000140 sen NY 1851-12-01 1857-03-03 1 Ind. Republican-Democrat                          
6309 6309 G000146 sen MO 1851-12-01 1857-03-03 1 Ind. Republican-Democrat                          
6348 6348 J000229 sen TN 1851-12-01 1857-03-03 1 Ind. Republican-Democrat                          
6552 6552 C000496 sen DE 1853-12-05 1857-03-03 2 Ind. Republican-Democrat                          
6754 6754 A000078 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 17                        
6756 6756 A000158 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 23                        
6759 6759 B000098 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 16                        
6760 6760 B000130 rep IN 1855-12-03 1857-03-03   Ind. Republican-Democrat 6                        
6774 6774 B000390 rep ME 1855-12-03 1857-03-03   Ind. Republican-Democrat 4                        
6777 6777 B000487 rep NJ 1855-12-03 1857-03-03   Ind. Republican-Democrat 3                        
6778 6778 B000751 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 7                        
6786 6786 C000353 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 7                        
6787 6787 C000457 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 9                        
6797 6797 C000980 rep IN 1855-12-03 1857-03-03   Ind. Republican-Democrat 4                        
6799 6799 D000161 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 1                        
6803 6803 D000332 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 14                        
6805 6805 D000546 rep IN 1855-12-03 1857-03-03   Ind. Republican-Democrat 3                        
6810 6810 E000177 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 6                        
6816 6816 F000181 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 31                        
6819 6819 F000410 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 12                        
6824 6824 G000027 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 12                        
6825 6825 G000179 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 23                        
6833 6833 H000272 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 2                        
6836 6836 H000355 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 32                        
6840 6840 H000730 rep IN 1855-12-03 1857-03-03   Ind. Republican-Democrat 5                        
6841 6841 H000799 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 18                        
6842 6842 H000931 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 19                        
6850 6850 K000119 rep MO 1855-12-03 1857-03-03   Ind. Republican-Democrat 1                        
6853 6853 K000213 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 11                        
6854 6854 K000285 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 20                        
6855 6855 K000294 rep ME 1855-12-03 1857-03-03   Ind. Republican-Democrat 3                        
6857 6857 K000295 rep IL 1855-12-03 1857-03-03   Ind. Republican-Democrat 4                        
6860 6860 L000322 rep MO 1855-12-03 1857-03-03   Ind. Republican-Democrat 3                        
6867 6867 M000008 rep IN 1855-12-03 1857-03-03   Ind. Republican-Democrat 8                        
6871 6871 M000319 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 22                        
6879 6879 M000613 rep VT 1855-12-03 1857-03-03   Ind. Republican-Democrat 1                        
6882 6882 M000741 rep MO 1855-12-03 1857-03-03   Ind. Republican-Democrat 5                        
6883 6883 M000744 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 12                        
6886 6886 M000911 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 10                        
6890 6890 O000075 rep MO 1855-12-03 1857-03-03   Ind. Republican-Democrat 4                        
6894 6894 P000162 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 15                        
6896 6896 P000198 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 3                        
6898 6898 P000213 rep NJ 1855-12-03 1857-03-03   Ind. Republican-Democrat 5                        
6900 6900 P000440 rep MO 1855-12-03 1857-03-03   Ind. Republican-Democrat 2                        
6902 6902 P000543 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 30                        
6908 6908 R000356 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 17                        
6910 6910 S000002 rep VT 1855-12-03 1857-03-03   Ind. Republican-Democrat 3                        
6912 6912 S000013 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 13                        
6914 6914 S000061 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 15                        
6915 6915 S000173 rep IN 1855-12-03 1857-03-03   Ind. Republican-Democrat 7                        
6919 6919 S000416 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 16                        
6928 6928 S000990 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 2                        
6930 6930 T000235 rep IA 1855-12-03 1857-03-03   Ind. Republican-Democrat 2                        
6936 6936 T000454 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 2                        
6940 6940 W000027 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 8                        
6943 6943 W000199 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 9                        
6954 6954 W000734 rep IL 1855-12-03 1857-03-03   Ind. Republican-Democrat 2                        
6962 6962 C000656 sen DE 1856-01-01 1857-12-31 2 Ind. Republican-Democrat                          
6979 6979 B000376 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 21                        
6981 6981 B000464 rep WI 1855-12-03 1857-03-03   Ind. Republican-Democrat 3                        
6984 6984 B000560 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 14                        
6989 6989 B000805 rep IN 1855-12-03 1857-03-03   Ind. Republican-Democrat 10                        
7001 7001 C000210 rep MO 1855-12-03 1857-03-03   Ind. Republican-Democrat 7                        
7012 7012 C000477 rep NJ 1855-12-03 1857-03-03   Ind. Republican-Democrat 1                        
7029 7029 D000389 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 15                        
7036 7036 E000049 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 18                        
7057 7057 G000167 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 20                        
7063 7063 G000373 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 24                        
7082 7082 H000207 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 7                        
7126 7126 K000340 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 10                        
7131 7131 L000236 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 18                        
7154 7154 M000251 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 20                        
7160 7160 M000948 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 25                        
7165 7165 M001042 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 5                        
7167 7167 M001105 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 10                        
7170 7170 N000093 rep OH 1855-12-03 1857-03-03   Ind. Republican-Democrat 4                        
7178 7178 P000064 rep NY 1855-12-03 1857-03-03   Ind. Republican-Democrat 27                        
7190 7190 P000576 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 22                        
7201 7201 R000273 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 21                        
7203 7203 R000300 rep NJ 1855-12-03 1857-03-03   Ind. Republican-Democrat 2                        
7205 7205 R000304 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 9                        
7242 7242 W000029 rep MI 1855-12-03 1857-03-03   Ind. Republican-Democrat 3                        
7251 7251 W000698 rep ME 1855-12-03 1857-03-03   Ind. Republican-Democrat 1                        
7273 7273 A000036 rep KY 1859-12-05 1861-03-03   Ind. Republican-Democrat 6                        
7278 7278 A000237 rep KY 1859-12-05 1861-03-03   Ind. Republican-Democrat 4                        
7304 7304 B000653 rep VA 1859-12-05 1861-03-03   Ind. Republican-Democrat 8                        
7310 7310 B000730 rep TN 1859-12-05 1861-03-03   Ind. Republican-Democrat 3                        
7321 7321 B000842 rep KY 1859-12-05 1861-03-03   Ind. Republican-Democrat 3                        
7381 7381 D000303 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 25                        
7404 7404 E000227 rep TN 1859-12-05 1861-03-03   Ind. Republican-Democrat 9                        
7419 7419 G000217 rep NC 1859-12-05 1861-03-03   Ind. Republican-Democrat 5                        
7437 7437 H000349 rep TN 1859-12-05 1861-03-03   Ind. Republican-Democrat 5                        
7447 7447 H000847 rep MI 1855-12-03 1857-03-03   Ind. Republican-Democrat 1                        
7514 7514 M000782 rep PA 1855-12-03 1857-03-03   Ind. Republican-Democrat 3                        
7518 7518 M000907 rep KY 1859-12-05 1861-03-03   Ind. Republican-Democrat 9                        
7536 7536 P000243 rep ME 1855-12-03 1857-03-03   Ind. Republican-Democrat 2                        
7538 7538 P000278 rep IN 1855-12-03 1857-03-03   Ind. Republican-Democrat 11                        
7548 7548 Q000002 rep TN 1859-12-05 1861-03-03   Ind. Republican-Democrat 8                        

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