legislator_terms

Table actions Table actions

485 rows where "end" is on date 1955-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
24816 24816 C000774 sen OR 1949-01-03 1955-01-03 2 Republican                          
24834 24834 F000081 sen MI 1949-01-03 1955-01-03 2 Republican                          
24838 24838 G000205 sen IA 1949-01-03 1955-01-03 2 Democrat                          
24848 24848 H000495 sen NJ 1949-01-03 1955-01-03 2 Republican                          
24870 24870 J000127 sen CO 1949-01-03 1955-01-03 2 Democrat                          
24924 24924 M000279 sen SC 1949-01-03 1955-01-03 2 Democrat                          
25332 25332 H000679 sen NC 1951-01-03 1955-01-03 3 Democrat                          
25574 25574 G000481 sen NE 1952-01-01 1955-01-03 2 Republican                          
25587 25587 A000257 rep OR 1953-01-03 1955-01-03   Republican 3                        
25596 25596 B000242 rep AL 1953-01-03 1955-01-03   Democrat 9                        
25603 25603 B000486 rep IL 1953-01-03 1955-01-03   Republican 25                        
25604 25604 B000618 rep PA 1953-01-03 1955-01-03   Republican 11                        
25608 25608 B000762 rep CA 1953-01-03 1955-01-03   Republican 13                        
25618 25618 B000999 rep SC 1953-01-03 1955-01-03   Democrat 4                        
25619 25619 B001099 sen OH 1953-10-13 1955-01-03 3 Democrat   appointment                      
25623 25623 B001161 rep IL 1953-01-03 1955-01-03   Republican 3                        
25634 25634 C000070 rep GA 1953-01-03 1955-01-03   Democrat 4                        
25635 25635 C000080 rep FL 1953-01-03 1955-01-03   Democrat 1                        
25636 25636 C000416 rep MI 1953-01-03 1955-01-03   Republican 6                        
25640 25640 C000614 rep MO 1953-01-03 1955-01-03   Republican 6                        
25641 25641 C000674 rep CA 1953-01-03 1955-01-03   Democrat 6                        
25660 25660 C000932 rep OH 1953-01-03 1955-01-03   Democrat 21                        
25665 25665 D000281 rep MT 1953-01-03 1955-01-03   Republican 2                        
25672 25672 F000034 rep HI 1953-01-03 1955-01-03   Republican 0                        
25678 25678 G000258 rep KY 1953-01-03 1955-01-03   Republican 8                        
25684 25684 G000297 rep MA 1953-01-03 1955-01-03   Republican 8                        
25692 25692 G000360 rep PA 1953-01-03 1955-01-03   Republican 25                        
25698 25698 H000014 rep MN 1953-01-03 1955-01-03   Republican 9                        
25708 25708 H000284 rep NJ 1953-01-03 1955-01-03   Democrat 14                        
25711 25711 H000460 rep NY 1953-01-03 1955-01-03   Democrat 8                        
25712 25712 H000616 rep MO 1953-01-03 1955-01-03   Republican 4                        
25715 25715 H000858 rep NJ 1953-01-03 1955-01-03   Democrat 4                        
25726 25726 H000943 rep WI 1953-01-03 1955-01-03   Republican 9                        
25728 25728 H000979 rep CA 1953-01-03 1955-01-03   Republican 12                        
25736 25736 J000207 rep IL 1953-01-03 1955-01-03   Republican 12                        
25739 25739 K000150 rep WI 1953-01-03 1955-01-03   Republican 5                        
25751 25751 L000089 rep FL 1953-01-03 1955-01-03   Democrat 4                        
25755 25755 L000496 rep TX 1953-01-03 1955-01-03   Democrat 12                        
25760 25760 L000525 rep TX 1953-01-03 1955-01-03   Democrat 14                        
25767 25767 M000656 rep IN 1953-01-03 1955-01-03   Republican 8                        
25768 25768 M000729 rep KS 1953-01-03 1955-01-03   Democrat 1                        
25775 25775 O000009 rep MI 1953-01-03 1955-01-03   Democrat 13                        
25776 25776 O000004 rep MI 1953-01-03 1955-01-03   Republican 17                        
25779 25779 P000107 rep AZ 1953-01-03 1955-01-03   Democrat 2                        
25785 25785 P000475 rep CA 1953-01-03 1955-01-03   Republican 24                        
25789 25789 R000100 rep OH 1953-01-03 1955-01-03   Independent 9                        
25793 25793 R000140 rep TX 1953-01-03 1955-01-03   Democrat 16                        
25798 25798 R000391 rep FL 1953-01-03 1955-01-03   Democrat 6                        
25801 25801 R000425 rep NY 1953-01-03 1955-01-03   Democrat 20                        
25810 25810 S000277 rep MI 1953-01-03 1955-01-03   Republican 3                        
25811 25811 S000499 rep MD 1953-01-03 1955-01-03   Republican 5                        
25819 25819 S000797 rep VA 1953-01-03 1955-01-03   Democrat 5                        
25820 25820 S001006 rep UT 1953-01-03 1955-01-03   Republican 1                        
25823 25823 S001087 rep TN 1953-01-03 1955-01-03   Democrat 6                        
25826 25826 U000032 sen NH 1953-08-14 1955-01-03 3 Republican   appointment                      
25827 25827 W000123 rep DE 1953-01-03 1955-01-03   Republican 0                        
25835 25835 W000252 rep OH 1953-01-03 1955-01-03   Republican 13                        
25839 25839 W000342 rep GA 1953-01-03 1955-01-03   Democrat 8                        
25843 25843 W000604 rep TX 1953-01-03 1955-01-03   Democrat 5                        
25848 25848 Y000024 rep CA 1953-01-03 1955-01-03   Democrat 26                        
25849 25849 A000010 sen NE 1954-01-01 1955-01-03 2 Republican                          
25857 25857 B000709 sen NE 1954-04-16 1955-01-03 2 Republican   appointment                      
25858 25858 B000913 sen NV 1954-10-01 1955-01-03 3 Republican   appointment                      
25859 25859 C000906 sen WY 1954-06-24 1955-01-03 2 Republican   appointment                      
25860 25860 D000031 sen SC 1954-09-06 1955-01-03 2 Democrat   appointment                      
25865 25865 O000088 sen WY 1954-11-29 1955-01-03 2 Democrat                          
25867 25867 R000180 sen NE 1954-07-03 1955-01-03 1 Republican   appointment                      
25868 25868 S000187 sen NC 1954-11-29 1955-01-03 2 Democrat                          
25885 25885 B000823 sen NH 1949-01-03 1955-01-03 2 Republican                          
25889 25889 B001009 rep PA 1953-01-03 1955-01-03   Democrat 30                        
25896 25896 C000156 rep NC 1953-01-03 1955-01-03   Democrat 7                        
25901 25901 C000336 rep NC 1953-01-03 1955-01-03   Democrat 5                        
25903 25903 C000743 rep OR 1953-01-03 1955-01-03   Republican 2                        
25906 25906 C000960 rep IN 1953-01-03 1955-01-03   Republican 3                        
25912 25912 D000175 rep NC 1953-01-03 1955-01-03   Democrat 8                        
25924 25924 D000354 rep MI 1953-01-03 1955-01-03   Democrat 15                        
25930 25930 D000403 rep IA 1953-01-03 1955-01-03   Republican 6                        
25942 25942 D000411 rep MI 1953-01-03 1955-01-03   Republican 18                        
25945 25945 D000421 rep NY 1953-01-03 1955-01-03   Democrat 18                        
25952 25952 E000146 rep OR 1953-01-03 1955-01-03   Republican 4                        
25954 25954 F000035 rep HI 1953-01-03 1955-01-03   Republican 0                        
25961 25961 F000085 rep NM 1953-01-03 1955-01-03   Democrat 0                        
25964 25964 F000126 rep NY 1953-01-03 1955-01-03   Democrat 22                        
25967 25967 F000356 sen DE 1949-01-03 1955-01-03 2 Democrat                          
25977 25977 G000031 rep NY 1953-01-03 1955-01-03   Republican 26                        
25979 25979 G000124 rep TX 1953-01-03 1955-01-03   Democrat 3                        
25984 25984 G000369 rep PA 1953-01-03 1955-01-03   Democrat 2                        
25988 25988 G000418 sen RI 1949-01-03 1955-01-03 2 Democrat                          
25994 25994 H000154 rep NJ 1953-01-03 1955-01-03   Republican 2                        
26004 26004 H000640 rep CA 1953-01-03 1955-01-03   Republican 20                        
26008 26008 H000689 rep IL 1953-01-03 1955-01-03   Republican 10                        
26023 26023 H000768 rep KS 1953-01-03 1955-01-03   Republican 5                        
26030 26030 J000157 rep CA 1953-01-03 1955-01-03   Republican 11                        
26034 26034 J000263 rep NC 1953-01-03 1955-01-03   Democrat 11                        
26037 26037 K000208 rep PA 1953-01-03 1955-01-03   Republican 8                        
26045 26045 K000261 rep NY 1953-01-03 1955-01-03   Democrat 19                        
26049 26049 L000468 rep SD 1953-01-03 1955-01-03   Republican 1                        
26058 26058 M000199 rep IA 1953-01-03 1955-01-03   Republican 1                        
26064 26064 M001108 sen MT 1949-01-03 1955-01-03 2 Democrat                          
26074 26074 N000023 sen WV 1949-01-03 1955-01-03 2 Democrat                          

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