legislator_terms

Table actions Table actions

480 rows where "end" is on date 1959-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
25579 25579 P000460 sen MI 1953-01-03 1959-01-03 1 Republican                          
25592 25592 B000176 sen WY 1953-01-03 1959-01-03 1 Republican                          
25610 25610 B000820 sen OH 1953-01-03 1959-01-03 1 Republican                          
25675 25675 F000190 sen VT 1953-01-03 1959-01-03 1 Republican                          
25730 25730 I000050 sen NY 1953-01-03 1959-01-03 1 Republican                          
25733 25733 J000093 sen IN 1953-01-03 1959-01-03 1 Republican                          
25745 25745 K000292 sen CA 1953-01-03 1959-01-03 1 Republican                          
25748 25748 L000070 sen ND 1953-01-03 1959-01-03 1 Republican                          
25762 25762 M000086 sen NV 1953-01-03 1959-01-03 1 Republican                          
25764 25764 M000177 sen PA 1953-01-03 1959-01-03 1 Republican                          
25780 25780 P000150 sen ME 1953-01-03 1959-01-03 1 Republican                          
25787 25787 P000575 sen CT 1953-01-03 1959-01-03 1 Republican                          
25814 25814 S000553 sen NJ 1953-01-03 1959-01-03 1 Republican                          
25825 25825 T000259 sen MN 1953-01-03 1959-01-03 1 Republican                          
25829 25829 W000190 sen UT 1953-01-03 1959-01-03 1 Republican                          
25869 25869 S000187 sen NC 1955-01-03 1959-01-03 2 Democrat                          
26157 26157 R000167 sen WV 1956-01-01 1959-01-03 1 Republican                          
26164 26164 A000133 rep CA 1957-01-03 1959-01-03   Republican 7                        
26180 26180 A000239 rep MN 1957-01-03 1959-01-03   Republican 1                        
26184 26184 B000276 rep IN 1957-01-03 1959-01-03   Republican 5                        
26187 26187 B000698 rep IL 1957-01-03 1959-01-03   Democrat 7                        
26191 26191 B000964 rep IN 1957-01-03 1959-01-03   Republican 11                        
26201 26201 B001079 rep ND 1957-01-03 1959-01-03   Republican 0                        
26206 26206 B001211 rep IL 1957-01-03 1959-01-03   Republican 3                        
26213 26213 C000182 rep PA 1957-01-03 1959-01-03   Republican 10                        
26230 26230 C000386 rep PA 1957-01-03 1959-01-03   Democrat 4                        
26240 26240 C000515 rep OH 1957-01-03 1959-01-03   Republican 5                        
26252 26252 C000617 rep NY 1957-01-03 1959-01-03   Republican 37                        
26267 26267 C000755 rep TN 1957-01-03 1959-01-03   Democrat 8                        
26273 26273 C000804 rep NY 1957-01-03 1959-01-03   Republican 17                        
26276 26276 C000905 rep CT 1957-01-03 1959-01-03   Republican 3                        
26285 26285 C000993 rep IA 1957-01-03 1959-01-03   Republican 5                        
26289 26289 D000155 rep UT 1957-01-03 1959-01-03   Republican 2                        
26290 26290 D000219 rep NJ 1957-01-03 1959-01-03   Democrat 14                        
26297 26297 D000228 rep NM 1957-01-03 1959-01-03   Democrat 0                        
26298 26298 D000246 rep OH 1957-01-03 1959-01-03   Republican 11                        
26302 26302 D000278 rep MD 1957-01-03 1959-01-03   Republican 2                        
26312 26312 D000338 rep TX 1957-01-03 1959-01-03   Democrat 0                        
26323 26323 E000029 rep PA 1957-01-03 1959-01-03   Democrat 28                        
26328 26328 G000129 rep KS 1957-01-03 1959-01-03   Republican 3                        
26336 26336 G000316 rep IL 1957-01-03 1959-01-03   Democrat 8                        
26347 26347 G000447 rep KY 1957-01-03 1959-01-03   Democrat 1                        
26354 26354 G000541 rep NY 1957-01-03 1959-01-03   Republican 27                        
26362 26362 H000036 rep ME 1957-01-03 1959-01-03   Republican 1                        
26367 26367 H000182 rep IN 1957-01-03 1959-01-03   Republican 6                        
26371 26371 H000275 rep NE 1957-01-03 1959-01-03   Republican 3                        
26372 26372 H000318 rep DE 1957-01-03 1959-01-03   Republican 0                        
26380 26380 H000405 rep AR 1957-01-03 1959-01-03   Democrat 5                        
26392 26392 H000549 rep MA 1957-01-03 1959-01-03   Republican 1                        
26401 26401 H000613 rep CO 1957-01-03 1959-01-03   Republican 2                        
26405 26405 H000623 rep CA 1957-01-03 1959-01-03   Republican 25                        
26413 26413 H000740 rep WA 1957-01-03 1959-01-03   Republican 4                        
26416 26416 H001021 rep MD 1957-01-03 1959-01-03   Republican 6                        
26421 26421 J000045 rep PA 1957-01-03 1959-01-03   Republican 7                        
26438 26438 J000088 rep OH 1957-01-03 1959-01-03   Republican 10                        
26448 26448 K000029 rep NJ 1957-01-03 1959-01-03   Republican 12                        
26456 26456 K000030 rep NY 1957-01-03 1959-01-03   Republican 32                        
26457 26457 K000042 rep IL 1957-01-03 1959-01-03   Republican 14                        
26466 26466 K000058 rep PA 1957-01-03 1959-01-03   Democrat 21                        
26468 26468 K000300 rep MN 1957-01-03 1959-01-03   Democrat 9                        
26471 26471 K000332 rep ND 1957-01-03 1959-01-03   Republican 0                        
26477 26477 L000077 rep GA 1957-01-03 1959-01-03   Democrat 7                        
26484 26484 L000108 rep NY 1957-01-03 1959-01-03   Republican 4                        
26494 26494 L000157 rep IA 1957-01-03 1959-01-03   Republican 4                        
26497 26497 L000416 rep LA 1957-01-03 1959-01-03   Democrat 8                        
26498 26498 M000274 rep CT 1957-01-03 1959-01-03   Republican 1                        
26506 26506 M000354 rep PA 1957-01-03 1959-01-03   Republican 13                        
26516 26516 M000460 rep OH 1957-01-03 1959-01-03   Republican 17                        
26517 26517 M000483 rep MI 1957-01-03 1959-01-03   Republican 7                        
26521 26521 M000609 rep IL 1957-01-03 1959-01-03   Republican 4                        
26529 26529 M000715 rep NE 1957-01-03 1959-01-03   Republican 4                        
26535 26535 M000724 rep MD 1957-01-03 1959-01-03   Republican 1                        
26539 26539 M000935 rep CT 1957-01-03 1959-01-03   Republican 4                        
26541 26541 N000017 rep WV 1957-01-03 1959-01-03   Republican 4                        
26547 26547 N000097 rep MA 1957-01-03 1959-01-03   Republican 9                        
26548 26548 N000110 rep IN 1957-01-03 1959-01-03   Republican 3                        
26557 26557 O000056 rep MN 1957-01-03 1959-01-03   Republican 2                        
26563 26563 P000119 rep CT 1957-01-03 1959-01-03   Republican 5                        
26567 26567 R000008 rep NY 1957-01-03 1959-01-03   Republican 41                        
26572 26572 R000329 rep VA 1957-01-03 1959-01-03   Democrat 1                        
26575 26575 R000359 rep KY 1957-01-03 1959-01-03   Republican 3                        
26581 26581 S000009 rep CT 1957-01-03 1959-01-03   Republican 0                        
26589 26589 S000194 rep KS 1957-01-03 1959-01-03   Republican 2                        
26594 26594 S000198 rep CA 1957-01-03 1959-01-03   Republican 1                        
26598 26598 S000315 rep IL 1957-01-03 1959-01-03   Republican 11                        
26601 26601 S000390 rep NC 1957-01-03 1959-01-03   Democrat 12                        
26605 26605 S000405 rep NJ 1957-01-03 1959-01-03   Democrat 13                        
26613 26613 S000437 rep IL 1957-01-03 1959-01-03   Republican 20                        
26622 26622 S000585 rep WI 1957-01-03 1959-01-03   Republican 1                        
26624 26624 S000819 rep PA 1957-01-03 1959-01-03   Republican 19                        
26634 26634 T000028 rep IA 1957-01-03 1959-01-03   Republican 2                        
26635 26635 T000139 rep WI 1957-01-03 1959-01-03   Republican 2                        
26645 26645 V000119 rep OH 1957-01-03 1959-01-03   Republican 12                        
26653 26653 V000125 rep IL 1957-01-03 1959-01-03   Republican 23                        
26669 26669 W000450 rep MA 1957-01-03 1959-01-03   Republican 13                        
26677 26677 W000549 rep NY 1957-01-03 1959-01-03   Republican 34                        
26693 26693 W000683 rep NJ 1957-01-03 1959-01-03   Republican 1                        
26694 26694 H000665 sen WV 1958-01-25 1959-01-03 2 Republican   appointment                      
26707 26707 A000138 rep IL 1957-01-03 1959-01-03   Republican 16                        
26709 26709 A000200 rep MT 1957-01-03 1959-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);