legislator_terms

Table actions Table actions

484 rows where "end" is on date 1937-01-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
20070 20070 C000146 sen WY 1931-12-07 1937-01-03 2 Republican                          
20231 20231 C000740 sen MA 1931-12-07 1937-01-03 2 Democrat                          
20251 20251 C000797 sen CO 1931-12-07 1937-01-03 2 Democrat                          
20300 20300 D000323 sen IA 1931-12-07 1937-01-03 2 Republican                          
20434 20434 G000323 sen OK 1931-12-07 1937-01-03 2 Democrat                          
20480 20480 H000325 sen DE 1931-12-07 1937-01-03 2 Republican                          
20608 20608 K000161 sen NH 1931-12-07 1937-01-03 2 Republican                          
20713 20713 M000670 sen RI 1931-12-07 1937-01-03 2 Republican                          
21107 21107 B000010 sen TN 1933-03-09 1937-01-03 2 Democrat   appointment                      
21265 21265 F000200 sen FL 1933-03-09 1937-01-03 3 Democrat                          
21448 21448 M001103 sen IA 1933-03-09 1937-01-03 3 Democrat                          
21453 21453 N000132 sen SD 1933-03-09 1937-01-03 3 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                        
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                        
21642 21642 B000389 sen MN 1935-12-27 1937-01-03 2 Farmer-Labor   appointment                      
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                        
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                        
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                        
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                        
21761 21761 E000006 rep OH 1936-11-03 1937-01-03   Democrat 0                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
21996 21996 U000036 rep IA 1935-01-03 1937-01-03   Democrat 6                        
21998 21998 W000299 rep SD 1935-01-03 1937-01-03   Democrat 2                        

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