legislator_terms

Table actions Table actions

479 rows where "end" is on date 1967-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
27062 27062 N000052 sen OR 1961-01-03 1967-01-03 2 Democrat                          
27186 27186 D000456 sen IL 1961-01-03 1967-01-03 2 Democrat                          
27500 27500 R000317 sen VA 1961-01-03 1967-01-03 2 Democrat                          
27508 27508 S000021 sen MA 1961-01-03 1967-01-03 2 Republican                          
27604 27604 S000434 sen WY 1962-01-01 1967-01-03 2 Republican                          
28310 28310 B000223 sen TN 1964-11-04 1967-01-03 2 Democrat                          
28312 28312 A000204 rep AL 1965-01-04 1967-01-03   Republican 4                        
28318 28318 B000092 rep CA 1965-01-04 1967-01-03   Republican 14                        
28319 28319 B000108 rep IA 1965-01-04 1967-01-03   Democrat 4                        
28331 28331 B000296 rep TX 1965-01-04 1967-01-03   Democrat 3                        
28345 28345 B000621 rep NC 1965-01-04 1967-01-03   Democrat 1                        
28359 28359 B000909 rep OH 1965-01-04 1967-01-03   Republican 7                        
28360 28360 C000054 rep NE 1965-01-04 1967-01-03   Democrat 1                        
28361 28361 C000055 rep GA 1965-01-04 1967-01-03   Republican 3                        
28363 28363 C000067 rep CA 1965-01-04 1967-01-03   Democrat 25                        
28374 28374 C000342 rep KY 1965-01-04 1967-01-03   Democrat 4                        
28375 28375 C000516 rep MI 1965-01-04 1967-01-03   Democrat 11                        
28392 28392 C000736 rep NC 1965-01-04 1967-01-03   Democrat 4                        
28393 28393 C000866 rep PA 1965-01-04 1967-01-03   Democrat 19                        
28398 28398 C001005 rep PA 1965-01-04 1967-01-03   Republican 8                        
28408 28408 D000004 rep PA 1965-01-04 1967-01-03   Republican 9                        
28416 28416 D000260 rep IN 1965-01-04 1967-01-03   Democrat 8                        
28421 28421 D000588 rep CA 1965-01-04 1967-01-03   Democrat 33                        
28424 28424 E000148 rep KS 1965-01-04 1967-01-03   Republican 3                        
28425 28425 F000023 rep KY 1965-01-04 1967-01-03   Democrat 3                        
28426 28426 F000025 rep MI 1965-01-04 1967-01-03   Democrat 19                        
28427 28427 G000208 rep OH 1965-01-04 1967-01-03   Democrat 1                        
28439 28439 G000348 rep CT 1965-01-04 1967-01-03   Democrat 6                        
28440 28440 G000450 rep IA 1965-01-04 1967-01-03   Democrat 6                        
28441 28441 G000454 rep TN 1965-01-04 1967-01-03   Democrat 9                        
28448 28448 H000013 rep CA 1965-01-04 1967-01-03   Democrat 18                        
28449 28449 H000173 rep IA 1965-01-04 1967-01-03   Democrat 7                        
28462 28462 H000249 rep AR 1965-01-04 1967-01-03   Democrat 4                        
28471 28471 H000310 rep IN 1965-01-04 1967-01-03   Republican 10                        
28477 28477 H001001 rep NH 1965-01-04 1967-01-03   Democrat 1                        
28483 28483 J000098 rep VA 1965-01-04 1967-01-03   Democrat 9                        
28484 28484 J000151 rep OK 1965-01-04 1967-01-03   Democrat 6                        
28494 28494 J000246 rep MO 1965-01-04 1967-01-03   Democrat 10                        
28510 28510 K000130 rep NY 1965-01-04 1967-01-03   Democrat 11                        
28513 28513 K000199 rep UT 1965-01-04 1967-01-03   Democrat 2                        
28514 28514 K000326 rep NJ 1965-01-04 1967-01-03   Democrat 12                        
28523 28523 K000341 rep PA 1965-01-04 1967-01-03   Republican 16                        
28527 28527 L000326 rep NY 1965-01-04 1967-01-03   Republican 17                        
28528 28528 L000458 rep OH 1965-01-04 1967-01-03   Democrat 3                        
28529 28529 M000022 rep GA 1965-01-04 1967-01-03   Democrat 4                        
28530 28530 M000026 rep MI 1965-01-04 1967-01-03   Democrat 7                        
28531 28531 M000182 rep AL 1965-01-04 1967-01-03   Republican 7                        
28552 28552 M000191 rep MA 1965-01-04 1967-01-03   Republican 10                        
28559 28559 M000253 rep FL 1965-01-04 1967-01-03   Democrat 8                        
28571 28571 M000418 rep DE 1965-01-04 1967-01-03   Democrat 0                        
28572 28572 M000459 rep NJ 1965-01-04 1967-01-03   Democrat 2                        
28573 28573 M000610 rep CO 1965-01-04 1967-01-03   Democrat 2                        
28576 28576 M000836 rep OH 1965-01-04 1967-01-03   Democrat 10                        
28588 28588 M000995 rep LA 1965-01-04 1967-01-03   Democrat 6                        
28601 28601 M001114 rep TN 1965-01-04 1967-01-03   Democrat 7                        
28609 28609 O000015 rep NY 1965-01-04 1967-01-03   Democrat 29                        
28611 28611 O000084 rep MN 1965-01-04 1967-01-03   Democrat 6                        
28618 28618 R000003 rep WI 1965-01-04 1967-01-03   Democrat 6                        
28619 28619 R000107 rep ND 1965-01-04 1967-01-03   Democrat 2                        
28623 28623 R000282 rep AK 1965-01-04 1967-01-03   Democrat 0                        
28631 28631 R000404 rep TX 1965-01-04 1967-01-03   Democrat 18                        
28637 28637 R000426 rep CA 1965-01-04 1967-01-03   Democrat 26                        
28638 28638 R000525 sen SC 1965-04-22 1967-01-03 3 Democrat   appointment                      
28639 28639 S000128 rep IL 1965-01-04 1967-01-03   Democrat 19                        
28640 28640 S000131 rep IA 1965-01-04 1967-01-03   Democrat 1                        
28645 28645 S000184 rep NC 1965-01-04 1967-01-03   Democrat 5                        
28655 28655 S000219 rep OH 1965-01-04 1967-01-03   Democrat 15                        
28657 28657 S000243 rep AZ 1965-01-04 1967-01-03   Democrat 3                        
28659 28659 S000401 rep MD 1965-01-04 1967-01-03   Democrat 0                        
28677 28677 S000554 rep VA 1965-01-04 1967-01-03   Democrat 8                        
28678 28678 S000782 rep WI 1965-01-04 1967-01-03   Democrat 1                        
28679 28679 S001103 rep OH 1965-01-04 1967-01-03   Democrat 0                        
28694 28694 T000156 rep TX 1965-01-04 1967-01-03   Democrat 8                        
28695 28695 T000178 rep TX 1965-01-04 1967-01-03   Democrat 8                        
28706 28706 T000198 rep TX 1965-01-04 1967-01-03   Democrat 9                        
28713 28713 T000218 rep LA 1965-01-04 1967-01-03   Democrat 7                        
28714 28714 T000294 rep MI 1965-01-04 1967-01-03   Democrat 3                        
28718 28718 T000297 rep PA 1965-01-04 1967-01-03   Democrat 4                        
28729 28729 T000373 rep AR 1965-01-04 1967-01-03   Democrat 3                        
28732 28732 T000411 rep ME 1965-01-04 1967-01-03   Republican 1                        
28734 28734 T000436 rep GA 1965-01-04 1967-01-03   Democrat 8                        
28736 28736 V000109 rep MI 1965-01-04 1967-01-03   Democrat 2                        
28737 28737 W000065 rep MS 1965-01-04 1967-01-03   Republican 4                        
28739 28739 W000290 rep GA 1965-01-04 1967-01-03   Democrat 5                        
28741 28741 W000362 rep ID 1965-01-04 1967-01-03   Democrat 1                        
28755 28755 S000739 sen VA 1966-12-31 1967-01-03 2 Democrat                          
28758 28758 A000161 sen CO 1961-01-03 1967-01-03 2 Republican                          
28765 28765 A000186 sen NM 1961-01-03 1967-01-03 2 Democrat                          
28773 28773 A000223 rep SC 1965-01-04 1967-01-03   Democrat 4                        
28783 28783 B000201 sen AK 1961-01-03 1967-01-03 2 Democrat                          
28788 28788 B000593 sen DE 1961-01-03 1967-01-03 2 Republican                          
28803 28803 B000607 rep OH 1965-01-04 1967-01-03   Republican 22                        
28808 28808 C000758 sen KY 1961-01-03 1967-01-03 2 Republican                          
28817 28817 C001014 rep MO 1965-01-04 1967-01-03   Republican 2                        
28823 28823 E000112 sen LA 1961-01-03 1967-01-03 2 Democrat                          
28831 28831 F000137 rep NY 1965-01-04 1967-01-03   Republican 24                        
28845 28845 F000233 rep RI 1965-01-04 1967-01-03   Democrat 2                        
28861 28861 G000098 rep AR 1965-01-04 1967-01-03   Democrat 1                        
28878 28878 H000081 rep IN 1965-01-04 1967-01-03   Republican 2                        
28889 28889 H000197 rep VA 1965-01-04 1967-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);