legislator_terms

Table actions Table actions

482 rows where "end" is on date 1965-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
26735 26735 B000271 sen MD 1959-01-07 1965-01-03 1 Republican                          
26783 26783 B001208 sen VA 1959-01-07 1965-01-03 1 Democrat                          
26849 26849 E000181 sen CA 1959-01-07 1965-01-03 1 Democrat                          
26904 26904 K000036 sen NY 1959-01-07 1965-01-03 1 Republican                          
27603 27603 M000623 sen NM 1962-11-30 1965-01-03 1 Republican   appointment                      
27605 27605 A000011 rep OH 1963-01-09 1965-01-03   Republican 10                        
27610 27610 A000106 rep TX 1963-01-09 1965-01-03   Republican 5                        
27621 27621 A000227 rep NJ 1963-01-09 1965-01-03   Republican 3                        
27626 27626 A000228 rep KS 1963-01-09 1965-01-03   Republican 2                        
27633 27633 B000062 rep TN 1963-01-09 1965-01-03   Republican 2                        
27634 27634 B000064 rep TN 1963-01-09 1965-01-03   Republican 2                        
27637 27637 B000190 rep NY 1963-01-09 1965-01-03   Republican 25                        
27643 27643 B000292 rep NY 1963-01-09 1965-01-03   Republican 5                        
27645 27645 B000310 rep NE 1963-01-09 1965-01-03   Republican 1                        
27655 27655 B000377 rep MI 1963-01-09 1965-01-03   Republican 12                        
27658 27658 B000608 rep OH 1963-01-09 1965-01-03   Republican 11                        
27663 27663 B000867 rep IA 1963-01-09 1965-01-03   Republican 2                        
27665 27665 B000969 rep IN 1963-01-09 1965-01-03   Republican 11                        
27680 27680 B001024 rep NY 1963-01-09 1965-01-03   Democrat 23                        
27681 27681 B001104 rep CA 1963-01-09 1965-01-03   Democrat 27                        
27702 27702 C000117 rep MO 1963-01-09 1965-01-03   Democrat 9                        
27723 27723 C000346 rep CO 1963-01-09 1965-01-03   Republican 3                        
27738 27738 D000094 rep TN 1963-01-09 1965-01-03   Democrat 9                        
27744 27744 D000266 rep NY 1963-01-09 1965-01-03   Republican 3                        
27764 27764 D000481 rep CA 1963-01-09 1965-01-03   Democrat 23                        
27765 27765 E000055 sen OK 1963-01-09 1965-01-03 2 Democrat   appointment                      
27773 27773 E000120 rep AL 1963-01-09 1965-01-03   Democrat 0                        
27783 27783 F000087 rep PR 1963-01-09 1965-01-03   Popular Democrat 0                        
27785 27785 F000135 rep IL 1963-01-09 1965-01-03   Democrat 9                        
27792 27792 F000283 rep GA 1963-01-09 1965-01-03   Democrat 3                        
27802 27802 G000091 rep VA 1963-01-09 1965-01-03   Democrat 3                        
27813 27813 G000102 rep PA 1963-01-09 1965-01-03   Republican 23                        
27814 27814 G000192 rep HI 1963-01-09 1965-01-03   Democrat 1                        
27818 27818 G000237 rep NJ 1963-01-09 1965-01-03   Republican 2                        
27832 27832 G000381 rep AL 1963-01-09 1965-01-03   Democrat 0                        
27841 27841 G000421 rep PA 1963-01-09 1965-01-03   Democrat 5                        
27845 27845 H000191 rep ID 1963-01-09 1965-01-03   Democrat 2                        
27865 27865 H000424 rep NY 1963-01-09 1965-01-03   Democrat 21                        
27869 27869 H000471 rep SC 1963-01-09 1965-01-03   Democrat 5                        
27898 27898 H000678 rep IA 1963-01-09 1965-01-03   Republican 6                        
27901 27901 H000684 rep IL 1963-01-09 1965-01-03   Republican 14                        
27912 27912 H000786 rep WA 1963-01-09 1965-01-03   Republican 5                        
27917 27917 H000904 rep AL 1963-01-09 1965-01-03   Democrat 0                        
27930 27930 J000100 rep IA 1963-01-09 1965-01-03   Republican 7                        
27935 27935 J000109 rep MI 1963-01-09 1965-01-03   Republican 3                        
27941 27941 J000158 rep WI 1963-01-09 1965-01-03   Democrat 9                        
27952 27952 K000040 rep WV 1963-01-09 1965-01-03   Democrat 5                        
27965 27965 K000170 rep NY 1963-01-09 1965-01-03   Republican 31                        
27970 27970 K000177 rep TX 1963-01-09 1965-01-03   Democrat 15                        
27976 27976 K000298 rep MI 1963-01-09 1965-01-03   Republican 11                        
27984 27984 L000081 rep MD 1963-01-09 1965-01-03   Democrat 5                        
27993 27993 L000252 rep MI 1963-01-09 1965-01-03   Democrat 16                        
27997 27997 L000299 rep IL 1963-01-09 1965-01-03   Democrat 7                        
28000 28000 M000197 rep CA 1963-01-09 1965-01-03   Republican 38                        
28007 28007 M000478 rep ME 1963-01-09 1965-01-03   Republican 2                        
28008 28008 M000558 rep IL 1963-01-09 1965-01-03   Republican 19                        
28015 28015 M000620 rep MI 1963-01-09 1965-01-03   Republican 2                        
28022 28022 M000762 rep NY 1963-01-09 1965-01-03   Republican 40                        
28025 28025 M000770 rep PA 1963-01-09 1965-01-03   Republican 7                        
28053 28053 N000133 rep OR 1963-01-09 1965-01-03   Republican 1                        
28055 28055 N000178 rep ND 1963-01-09 1965-01-03   Republican 1                        
28069 28069 O000016 rep IL 1963-01-09 1965-01-03   Democrat 6                        
28078 28078 O000120 rep NJ 1963-01-09 1965-01-03   Republican 9                        
28085 28085 O000121 rep NY 1963-01-09 1965-01-03   Republican 37                        
28091 28091 P000349 rep GA 1963-01-09 1965-01-03   Democrat 2                        
28097 28097 P000352 rep NY 1963-01-09 1965-01-03   Republican 39                        
28107 28107 R000018 rep AL 1963-01-09 1965-01-03   Democrat 0                        
28108 28108 R000206 rep OH 1963-01-09 1965-01-03   Republican 1                        
28117 28117 R000250 rep NY 1963-01-09 1965-01-03   Republican 34                        
28124 28124 R000314 rep AL 1963-01-09 1965-01-03   Democrat 0                        
28126 28126 R000556 rep MI 1963-01-09 1965-01-03   Democrat 14                        
28133 28133 S000117 rep OH 1963-01-09 1965-01-03   Republican 3                        
28141 28141 S000327 rep CA 1963-01-09 1965-01-03   Democrat 5                        
28155 28155 S000335 rep CA 1963-01-09 1965-01-03   Democrat 33                        
28158 28158 S000378 rep ND 1963-01-09 1965-01-03   Republican 2                        
28160 28160 S000395 rep CT 1963-01-09 1965-01-03   Republican 4                        
28165 28165 S000408 rep KY 1963-01-09 1965-01-03   Republican 5                        
28179 28179 S000764 rep NY 1963-01-09 1965-01-03   Republican 27                        
28180 28180 S000775 rep MI 1963-01-09 1965-01-03   Democrat 0                        
28181 28181 S000928 rep WA 1963-01-09 1965-01-03   Republican 7                        
28189 28189 T000237 rep TX 1963-01-09 1965-01-03   Democrat 10                        
28198 28198 T000298 rep WA 1963-01-09 1965-01-03   Republican 6                        
28205 28205 V000051 rep WI 1963-01-09 1965-01-03   Republican 6                        
28231 28231 V000105 rep GA 1963-01-09 1965-01-03   Democrat 6                        
28234 28234 W000089 rep NJ 1963-01-09 1965-01-03   Republican 12                        
28250 28250 W000108 rep PA 1963-01-09 1965-01-03   Democrat 15                        
28251 28251 W000110 sen TN 1963-08-20 1965-01-03 2 Democrat   appointment                      
28252 28252 W000226 rep PA 1963-01-09 1965-01-03   Republican 24                        
28258 28258 W000310 rep WA 1963-01-09 1965-01-03   Republican 2                        
28265 28265 W000323 rep NY 1963-01-09 1965-01-03   Republican 28                        
28274 28274 W000439 rep OK 1963-01-09 1965-01-03   Democrat 6                        
28285 28285 W000572 rep IN 1963-01-09 1965-01-03   Republican 9                        
28296 28296 W000641 rep MS 1963-01-09 1965-01-03   Democrat 4                        
28311 28311 S000016 sen CA 1964-08-04 1965-01-03 1 Democrat   appointment                      
28317 28317 B000092 rep CA 1963-01-09 1965-01-03   Republican 14                        
28330 28330 B000296 rep TX 1963-01-09 1965-01-03   Democrat 3                        
28344 28344 B000621 rep NC 1963-01-09 1965-01-03   Democrat 1                        
28358 28358 B000909 rep OH 1963-01-09 1965-01-03   Republican 7                        
28362 28362 C000067 rep CA 1963-01-09 1965-01-03   Democrat 25                        
28373 28373 C000342 rep KY 1963-01-09 1965-01-03   Democrat 4                        

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