legislator_terms

Table actions Table actions

480 rows where "start" is on date 1935-01-03

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, end, 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
19649 19649 C001028 sen NM 1935-01-03 1935-05-06 1 Republican                          
21608 21608 A000025 rep IL 1935-01-03 1937-01-03   Democrat 15                        
21616 21616 A000240 rep MA 1935-01-03 1937-01-03   Republican 6                        
21623 21623 A000300 rep IL 1935-01-03 1937-01-03   Democrat 23                        
21628 21628 A000319 sen AZ 1935-01-03 1941-01-03 1 Democrat                          
21630 21630 A000352 rep MT 1935-01-03 1937-01-03   Democrat 2                        
21641 21641 B000009 rep NJ 1935-01-03 1937-01-03   Republican 2                        
21644 21644 B000409 rep PA 1935-01-03 1937-01-03   Democrat 28                        
21654 21654 B000549 rep TX 1935-01-03 1937-01-03   Democrat 17                        
21656 21656 B000799 rep IL 1935-01-03 1937-01-03   Democrat 0                        
21658 21658 B000882 rep PA 1935-01-03 1937-01-03   Democrat 30                        
21662 21662 B000981 rep NY 1935-01-03 1937-01-03   Democrat 2                        
21667 21667 B001020 rep IL 1935-01-03 1937-01-03   Republican 12                        
21669 21669 B001089 sen NE 1935-01-03 1941-01-03 1 Democrat                          
21671 21671 B001124 rep CA 1935-01-03 1937-01-03   Republican 20                        
21685 21685 B001217 rep TN 1935-01-03 1937-01-03   Democrat 5                        
21688 21688 C000140 rep KY 1935-01-03 1937-01-03   Democrat 4                        
21690 21690 C000159 rep AL 1935-01-03 1937-01-03   Democrat 8                        
21692 21692 C000173 rep KS 1935-01-03 1937-01-03   Democrat 4                        
21695 21695 C000214 rep KY 1935-01-03 1937-01-03   Democrat 2                        
21698 21698 C000240 rep GA 1935-01-03 1937-01-03   Democrat 3                        
21701 21701 C000262 rep NJ 1935-01-03 1937-01-03   Republican 11                        
21703 21703 C000381 rep MN 1935-01-03 1937-01-03   Republican 5                        
21705 21705 C000402 rep MO 1935-01-03 1937-01-03   Democrat 12                        
21707 21707 C000643 rep CA 1935-01-03 1937-01-03   Republican 19                        
21711 21711 C000673 rep RI 1935-01-03 1937-01-03   Democrat 1                        
21722 21722 C000757 rep OH 1935-01-03 1937-01-03   Republican 19                        
21725 21725 C000769 sen NY 1935-01-03 1939-01-03 1 Democrat                          
21732 21732 C000785 rep NY 1935-01-03 1937-01-03   Democrat 28                        
21736 21736 C000931 rep TX 1935-01-03 1937-01-03   Democrat 11                        
21738 21738 D000177 rep LA 1935-01-03 1937-01-03   Democrat 8                        
21739 21739 D000218 rep PI 1935-01-03 1937-01-03     0                        
21740 21740 D000340 rep PA 1935-01-03 1937-01-03   Democrat 15                        
21742 21742 D000382 rep IL 1935-01-03 1937-01-03   Democrat 19                        
21743 21743 D000410 sen OH 1935-01-03 1941-01-03 1 Democrat                          
21748 21748 D000460 rep PA 1935-01-03 1937-01-03   Republican 19                        
21749 21749 D000501 rep PA 1935-01-03 1937-01-03   Democrat 20                        
21751 21751 D000517 rep OH 1935-01-03 1937-01-03   Democrat 9                        
21752 21752 D000519 rep NY 1935-01-03 1937-01-03   Democrat 38                        
21753 21753 D000545 rep MS 1935-01-03 1937-01-03   Democrat 5                        
21760 21760 E000003 rep TX 1935-01-03 1937-01-03   Democrat 8                        
21762 21762 E000098 rep OR 1935-01-03 1937-01-03   Republican 3                        
21763 21763 F000071 rep PA 1935-01-03 1937-01-03   Republican 3                        
21766 21766 F000114 rep OH 1935-01-03 1937-01-03   Democrat 13                        
21769 21769 F000354 sen ND 1935-01-03 1941-01-03 1 Republican                          
21770 21770 G000094 rep OK 1935-01-03 1937-01-03   Democrat 4                        
21774 21774 G000372 rep MA 1935-01-03 1937-01-03   Democrat 2                        
21776 21776 G000435 rep AZ 1935-01-03 1937-01-03   Democrat 0                        
21781 21781 G000448 rep KY 1935-01-03 1937-01-03   Democrat 1                        
21791 21791 G000457 rep NY 1935-01-03 1937-01-03   Democrat 22                        
21798 21798 G000518 rep PI 1935-01-03 1937-01-03     0                        
21802 21802 H000031 sen ME 1935-01-03 1941-01-03 1 Republican                          
21803 21803 H000122 rep ME 1935-01-03 1937-01-03   Democrat 1                        
21804 21804 H000131 rep OH 1935-01-03 1937-01-03   Democrat 11                        
21806 21806 H000580 rep CT 1935-01-03 1937-01-03   Republican 2                        
21813 21813 H000607 rep WA 1935-01-03 1937-01-03   Democrat 5                        
21815 21815 H000677 rep CA 1935-01-03 1937-01-03   Democrat 12                        
21818 21818 H000728 rep OH 1935-01-03 1937-01-03   Republican 1                        
21819 21819 H000749 sen WV 1935-01-03 1941-01-03 1 Democrat                          
21830 21830 H000903 rep AL 1935-01-03 1937-01-03   Democrat 9                        
21831 21831 I000004 rep IL 1935-01-03 1937-01-03   Democrat 0                        
21834 21834 J000038 rep IA 1935-01-03 1937-01-03   Democrat 2                        
21840 21840 K000002 rep CA 1935-01-03 1937-01-03   Republican 4                        
21841 21841 K000183 rep MI 1935-01-03 1937-01-03   Republican 3                        
21847 21847 K000216 sen UT 1935-01-03 1941-01-03 1 Democrat                          
21858 21858 L000222 rep NJ 1935-01-03 1937-01-03   Republican 12                        
21860 21860 L000383 rep WA 1935-01-03 1937-01-03   Democrat 6                        
21861 21861 M000071 rep MI 1935-01-03 1937-01-03   Republican 3                        
21863 21863 M000158 rep OH 1935-01-03 1937-01-03   Republican 7                        
21864 21864 M000214 rep IL 1935-01-03 1937-01-03   Democrat 21                        
21873 21873 M000427 rep AL 1935-01-03 1937-01-03   Democrat 1                        
21881 21881 M000604 rep SC 1935-01-03 1937-01-03   Democrat 4                        
21890 21890 M000663 rep CT 1935-01-03 1937-01-03   Republican 4                        
21891 21891 M000800 sen IN 1935-01-03 1941-01-03 1 Democrat                          
21893 21893 M000848 rep MT 1935-01-03 1937-01-03   Democrat 1                        
21897 21897 M000862 rep LA 1935-01-03 1937-01-03   Democrat 3                        
21898 21898 M000893 sen NJ 1935-01-03 1939-01-03 1 Democrat                          
21900 21900 M000932 rep ME 1935-01-03 1937-01-03   Democrat 2                        
21901 21901 M000962 rep PA 1935-01-03 1937-01-03   Democrat 32                        
21912 21912 O000077 rep AL 1935-01-03 1937-01-03   Democrat 6                        
21920 21920 P000075 rep AR 1935-01-03 1937-01-03   Democrat 7                        
21928 21928 P000237 rep NJ 1935-01-03 1937-01-03   Republican 7                        
21933 21933 P000372 sen NV 1935-01-03 1941-01-03 1 Democrat                          
21942 21942 R000061 rep PA 1935-01-03 1937-01-03   Republican 1                        
21944 21944 R000230 rep PA 1935-01-03 1937-01-03   Democrat 14                        
21948 21948 R000408 rep NH 1935-01-03 1937-01-03   Democrat 1                        
21951 21951 R000496 rep NY 1935-01-03 1937-01-03   Democrat 9                        
21952 21952 R000537 rep MA 1935-01-03 1937-01-03   Democrat 9                        
21960 21960 S000043 rep LA 1935-01-03 1937-01-03   Democrat 4                        
21961 21961 S000160 sen WA 1935-01-03 1940-12-16 1 Democrat                          
21970 21970 S000211 rep FL 1935-01-03 1937-01-03   Democrat -1                        
21972 21972 S000455 rep NY 1935-01-03 1937-01-03   Democrat 33                        
21973 21973 S000915 rep DE 1935-01-03 1937-01-03   Republican 0                        
21975 21975 T000187 rep NY 1935-01-03 1937-01-03   Republican 29                        
21976 21976 T000311 rep NY 1935-01-03 1937-01-03   Democrat 8                        
21978 21978 T000335 sen DE 1935-01-03 1941-01-03 1 Republican                          
21982 21982 T000353 sen FL 1935-01-03 1936-05-08 1 Democrat                          
21984 21984 T000386 rep OH 1935-01-03 1935-08-09   Democrat 0                        
21988 21988 T000433 rep PA 1935-01-03 1937-01-03   Republican 12                        
21995 21995 U000012 rep OH 1935-01-03 1937-01-03   Democrat 11                        

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