legislator_terms

Table actions Table actions

485 rows where "end" is on date 1917-03-03

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, start, class, party, 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
15886 15886 B000992 sen FL 1911-04-04 1917-03-03 1 Democrat                          
15888 15888 C000360 sen WV 1911-04-04 1917-03-03 1 Democrat                          
15891 15891 C000414 sen MN 1911-04-04 1917-03-03 1 Republican                          
15897 15897 C000425 sen WY 1911-04-04 1917-03-03 1 Republican                          
16017 16017 J000124 sen ME 1911-04-04 1917-03-03 1 Democrat                          
16020 16020 K000132 sen IN 1911-04-04 1917-03-03 1 Democrat                          
16043 16043 L000165 sen TN 1911-04-04 1917-03-03 1 Democrat                          
16053 16053 L000343 sen RI 1911-04-04 1917-03-03 1 Republican                          
16076 16076 M000205 sen NJ 1911-04-04 1917-03-03 1 Democrat                          
16132 16132 O000050 sen NY 1911-04-04 1917-03-03 1 Democrat                          
16134 16134 O000073 sen PA 1911-04-04 1917-03-03 1 Republican                          
16205 16205 S001080 sen UT 1911-04-04 1917-03-03 1 Republican                          
16238 16238 W000743 sen CA 1911-04-04 1917-03-03 1 Republican                          
16241 16241 D000559 sen DE 1911-04-04 1917-03-03 1 Republican                          
16243 16243 C000253 sen NM 1912-03-27 1917-03-03 1 Republican                          
16315 16315 B001105 sen ME 1913-04-07 1917-03-03 2 Republican                          
16658 16658 L000189 sen MD 1914-01-28 1917-03-03 1 Democrat                          
16662 16662 A000013 rep AL 1915-12-06 1917-03-03   Democrat -1                        
16667 16667 A000027 rep IN 1915-12-06 1917-03-03   Democrat 8                        
16674 16674 A000064 rep SC 1915-12-06 1917-03-03   Democrat 3                        
16677 16677 A000111 rep OH 1915-12-06 1917-03-03   Democrat 2                        
16679 16679 B000050 rep PA 1915-12-06 1917-03-03   Democrat 19                        
16685 16685 B000133 rep PA 1915-12-06 1917-03-03   Republican 32                        
16686 16686 B000269 rep PA 1915-12-06 1917-03-03   Republican 20                        
16688 16688 B000359 rep CA 1915-12-06 1917-03-03   Republican 10                        
16692 16692 B000370 rep NY 1915-12-06 1917-03-03   Republican 23                        
16707 16707 B000949 rep WV 1915-12-06 1917-03-03   Democrat 2                        
16710 16710 B001001 rep IL 1915-12-06 1917-03-03   Democrat 7                        
16718 16718 B001083 rep TX 1915-12-06 1917-03-03   Democrat 9                        
16721 16721 B001095 rep WI 1915-12-06 1917-03-03   Democrat 2                        
16724 16724 C000056 rep TX 1915-12-06 1917-03-03   Democrat 12                        
16727 16727 C000323 rep NY 1915-12-06 1917-03-03   Republican 30                        
16730 16730 C000463 sen AR 1915-12-06 1917-03-03 3 Democrat                          
16734 16734 C000521 rep IN 1915-12-06 1917-03-03   Democrat 12                        
16735 16735 C000622 rep PA 1915-12-06 1917-03-03   Republican 30                        
16739 16739 C000975 rep IN 1915-12-06 1917-03-03   Democrat 2                        
16742 16742 D000029 rep NY 1915-12-06 1917-03-03   Republican 39                        
16746 16746 D000074 rep OK 1915-12-06 1917-03-03   Democrat 1                        
16747 16747 D000110 rep TX 1915-12-06 1917-03-03   Democrat -1                        
16751 16751 D000500 rep NY 1915-12-06 1917-03-03   Democrat 42                        
16753 16753 E000015 rep PI 1915-12-06 1917-03-03     0                        
16754 16754 F000021 rep NY 1915-12-06 1917-03-03   Democrat 14                        
16767 16767 G000344 rep NY 1915-12-06 1917-03-03   Democrat 23                        
16777 16777 G000517 rep ME 1915-12-06 1917-03-03   Republican 4                        
16779 16779 H000283 rep NJ 1915-12-06 1917-03-03   Democrat 6                        
16789 16789 H000382 rep VA 1915-12-06 1917-03-03   Democrat 7                        
16799 16799 H000516 rep TX 1915-12-06 1917-03-03   Democrat 11                        
16802 16802 H000630 rep ME 1915-12-06 1917-03-03   Republican 1                        
16803 16803 H000785 rep PA 1915-12-06 1917-03-03   Republican 23                        
16810 16810 H000866 rep UT 1915-12-06 1917-03-03   Republican 1                        
16814 16814 H000920 rep GA 1915-12-06 1917-03-03   Democrat 12                        
16821 16821 H000958 rep WA 1915-12-06 1917-03-03   Republican 1                        
16831 16831 J000156 rep SC 1915-12-06 1917-03-03   Democrat 4                        
16833 16833 K000052 rep PA 1915-12-06 1917-03-03   Republican 22                        
16836 16836 K000127 rep CA 1915-12-06 1917-03-03   Independent 1                        
16839 16839 K000310 rep WI 1915-12-06 1917-03-03   Democrat 9                        
16845 16845 L000014 rep PA 1915-12-06 1917-03-03   Republican -1                        
16847 16847 L000302 rep IN 1915-12-06 1917-03-03   Democrat 1                        
16848 16848 L000303 rep PA 1915-12-06 1917-03-03   Democrat 25                        
16853 16853 L000320 rep MN 1915-12-06 1917-03-03   Republican 6                        
16863 16863 L000380 rep MO 1915-12-06 1917-03-03   Democrat 1                        
16865 16865 L000399 rep NY 1915-12-06 1917-03-03   Democrat 13                        
16871 16871 L000449 rep MI 1915-12-06 1917-03-03   Republican 10                        
16872 16872 M000254 rep OH 1915-12-06 1917-03-03   Republican 5                        
16873 16873 M000363 rep SC 1915-12-06 1917-03-03   Democrat 5                        
16874 16874 M000378 rep ID 1915-12-06 1917-03-03   Republican -1                        
16879 16879 M000405 rep IL 1915-12-06 1917-03-03   Democrat 4                        
16882 16882 M000448 rep ME 1915-12-06 1917-03-03   Democrat 2                        
16885 16885 M000753 rep PA 1915-12-06 1917-03-03   Republican 28                        
16886 16886 M000758 rep DE 1915-12-06 1917-03-03   Republican 0                        
16887 16887 M000888 rep OH 1915-12-06 1917-03-03   Republican 15                        
16890 16890 M000955 rep LA 1915-12-06 1917-03-03   Democrat 6                        
16894 16894 M000998 rep IN 1915-12-06 1917-03-03   Democrat 9                        
16896 16896 M001034 rep WV 1915-12-06 1917-03-03   Republican 4                        
16900 16900 M001037 rep IN 1915-12-06 1917-03-03   Democrat 5                        
16902 16902 M001118 rep OK 1915-12-06 1917-03-03   Democrat 4                        
16911 16911 N000141 rep PA 1915-12-06 1917-03-03   Republican 27                        
16912 16912 O000002 rep CT 1915-12-06 1917-03-03   Republican 1                        
16914 16914 O000049 rep NY 1915-12-06 1917-03-03   Democrat 24                        
16921 16921 P000022 rep NC 1915-12-06 1917-03-03   Democrat 7                        
16924 16924 P000109 rep NY 1915-12-06 1917-03-03   Democrat 18                        
16933 16933 Q000009 rep PI 1915-12-06 1917-03-03     0                        
16938 16938 R000070 rep IN 1915-12-06 1917-03-03   Democrat 11                        
16941 16941 R000279 rep PR 1915-12-06 1917-03-03   Unionist 0                        
16950 16950 R000311 rep MA 1915-12-06 1917-03-03   Republican 9                        
16951 16951 R000493 rep GA 1915-12-06 1917-03-03   Democrat 8                        
16952 16952 R000534 rep OH 1915-12-06 1917-03-03   Republican 4                        
16960 16960 S000371 sen IN 1915-12-06 1917-03-03 3 Democrat                          
16962 16962 S000540 rep MN 1915-12-06 1917-03-03   Republican 5                        
16985 16985 S000636 rep TX 1915-12-06 1917-03-03   Democrat 16                        
16996 16996 S000702 rep FL 1915-12-06 1917-03-03   Democrat 1                        
16997 16997 S000837 rep IA 1915-12-06 1917-03-03   Democrat 11                        
17007 17007 S000858 rep TX 1915-12-06 1917-03-03   Democrat 13                        
17010 17010 S000861 rep CA 1915-12-06 1917-03-03   Progressive 10                        
17013 17013 S000954 rep IL 1915-12-06 1917-03-03   Democrat 16                        
17021 17021 S000982 rep MT 1915-12-06 1917-03-03   Democrat -1                        
17024 17024 T000011 rep KS 1915-12-06 1917-03-03   Democrat 2                        
17026 17026 T000059 rep IL 1915-12-06 1917-03-03   Democrat 14                        
17031 17031 T000366 rep GA 1915-12-06 1917-03-03   Democrat 8                        
17032 17032 W000535 rep OH 1915-12-06 1917-03-03   Republican 14                        

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