legislator_terms

Table actions Table actions

498 rows where "end" is on date 1941-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
21628 21628 A000319 sen AZ 1935-01-03 1941-01-03 1 Democrat                          
21669 21669 B001089 sen NE 1935-01-03 1941-01-03 1 Democrat                          
21743 21743 D000410 sen OH 1935-01-03 1941-01-03 1 Democrat                          
21769 21769 F000354 sen ND 1935-01-03 1941-01-03 1 Republican                          
21802 21802 H000031 sen ME 1935-01-03 1941-01-03 1 Republican                          
21819 21819 H000749 sen WV 1935-01-03 1941-01-03 1 Democrat                          
21847 21847 K000216 sen UT 1935-01-03 1941-01-03 1 Democrat                          
21891 21891 M000800 sen IN 1935-01-03 1941-01-03 1 Democrat                          
21933 21933 P000372 sen NV 1935-01-03 1941-01-03 1 Democrat                          
21978 21978 T000335 sen DE 1935-01-03 1941-01-03 1 Republican                          
22054 22054 B000634 sen ID 1937-01-05 1941-01-03 2 Republican                          
22290 22290 L000514 sen MN 1937-01-05 1941-01-03 2 Farmer-Labor                          
22474 22474 A000097 rep MN 1939-01-03 1941-01-03   Republican 3                        
22476 22476 A000145 rep PA 1939-01-03 1941-01-03   Democrat 28                        
22478 22478 A000184 rep MO 1939-01-03 1941-01-03   Democrat 12                        
22488 22488 A000306 rep OH 1939-01-03 1941-01-03   Democrat 17                        
22489 22489 A000339 rep CT 1939-01-03 1941-01-03   Republican 4                        
22490 22490 B000102 rep CT 1939-01-03 1941-01-03   Republican 2                        
22502 22502 B000113 rep AL 1939-01-03 1941-01-03   Democrat 7                        
22504 22504 B000211 rep NY 1939-01-03 1941-01-03   Republican 17                        
22509 22509 B000606 rep OH 1939-01-03 1941-01-03   Republican 22                        
22512 22512 B001122 rep CO 1939-01-03 1941-01-03   Democrat 3                        
22513 22513 B001218 rep TN 1939-01-03 1941-01-03   Democrat 5                        
22517 22517 C000038 rep FL 1939-01-03 1941-01-03   Democrat 3                        
22523 22523 C000296 rep TN 1939-01-03 1941-01-03   Democrat 9                        
22535 22535 C000886 rep AR 1939-01-03 1941-01-03   Democrat 4                        
22540 22540 C000940 rep IN 1939-01-03 1941-01-03   Democrat 9                        
22544 22544 C000985 rep CO 1939-01-03 1941-01-03   Democrat 2                        
22547 22547 C000995 rep NY 1939-01-03 1941-01-03   Democrat 22                        
22550 22550 D000014 rep PA 1939-01-03 1941-01-03   Democrat 4                        
22563 22563 D000063 rep PA 1939-01-03 1941-01-03   Republican 7                        
22573 22573 D000265 rep LA 1939-01-03 1941-01-03   Democrat 7                        
22585 22585 D000468 rep IA 1939-01-03 1941-01-03   Republican 6                        
22589 22589 D000551 rep PA 1939-01-03 1941-01-03   Democrat 34                        
22590 22590 E000026 rep CA 1939-01-03 1941-01-03   Republican 18                        
22593 22593 E000253 rep NY 1939-01-03 1941-01-03   Democrat 5                        
22596 22596 F000082 rep OK 1939-01-03 1941-01-03   Democrat 8                        
22601 22601 F000086 rep LA 1939-01-03 1941-01-03   Democrat 1                        
22603 22603 F000385 rep IL 1939-01-03 1941-01-03   Democrat 21                        
22605 22605 G000080 rep TX 1939-01-03 1941-01-03   Democrat 17                        
22606 22606 G000087 rep PA 1939-01-03 1941-01-03   Republican 5                        
22607 22607 G000155 rep GA 1939-01-03 1941-01-03   Democrat 8                        
22608 22608 G000156 rep GA 1939-01-03 1941-01-03   Democrat 8                        
22615 22615 G000158 sen VT 1939-01-03 1941-01-03 3 Republican                          
22625 22625 G000265 rep MD 1939-01-03 1941-01-03   Democrat 1                        
22626 22626 G000303 rep IA 1939-01-03 1941-01-03   Republican 6                        
22628 22628 G000469 rep LA 1939-01-03 1941-01-03   Democrat 6                        
22629 22629 G000484 rep WI 1939-01-03 1941-01-03   Republican 3                        
22630 22630 H000295 rep NY 1939-01-03 1941-01-03   Republican 41                        
22631 22631 H000375 rep WI 1939-01-03 1941-01-03   Republican 2                        
22632 22632 H000454 rep NE 1939-01-03 1941-01-03   Republican 1                        
22634 22634 H000798 rep WY 1939-01-03 1941-01-03   Republican 0                        
22638 22638 I000002 rep PR 1939-01-03 1941-01-03   Coalitionist 0                        
22639 22639 J000075 rep NJ 1939-01-03 1941-01-03   Republican 2                        
22651 22651 J000236 rep TX 1939-01-03 1941-01-03   Democrat 18                        
22656 22656 K000056 rep IL 1939-01-03 1941-01-03   Democrat 25                        
22661 22661 K000101 rep MD 1939-01-03 1941-01-03   Democrat 4                        
22663 22663 K000248 rep AR 1939-01-03 1941-01-03   Democrat 7                        
22666 22666 L000439 rep NY 1939-01-03 1941-01-03   Republican 34                        
22676 22676 L000498 rep MA 1939-01-03 1941-01-03   Republican 9                        
22690 22690 M000119 rep MI 1939-01-03 1941-01-03   Republican 5                        
22691 22691 M000159 rep OH 1939-01-03 1941-01-03   Republican 0                        
22697 22697 M000186 rep CO 1939-01-03 1941-01-03   Democrat 3                        
22698 22698 M000187 rep IL 1939-01-03 1941-01-03   Democrat 0                        
22707 22707 M000296 rep IL 1939-01-03 1941-01-03   Democrat 9                        
22716 22716 M000557 rep MI 1939-01-03 1941-01-03   Republican 13                        
22717 22717 M000565 rep SC 1939-01-03 1941-01-03   Democrat 1                        
22725 22725 M000572 rep SC 1939-01-03 1941-01-03   Democrat 1                        
22734 22734 M000598 rep TN 1939-01-03 1941-01-03   Democrat 3                        
22736 22736 M001051 rep LA 1939-01-03 1941-01-03   Democrat 3                        
22744 22744 O000149 rep GA 1939-01-03 1941-01-03   Democrat 4                        
22750 22750 P000086 rep IL 1939-01-03 1941-01-03   Democrat 24                        
22751 22751 P000338 rep NY 1939-01-03 1941-01-03   Republican 31                        
22756 22756 R000269 rep RI 1939-01-03 1941-01-03   Republican 1                        
22757 22757 R000470 rep OH 1939-01-03 1941-01-03   Republican 3                        
22760 22760 R000555 rep MN 1939-01-03 1941-01-03   Democrat 2                        
22761 22761 S000031 rep RI 1939-01-03 1941-01-03   Republican 2                        
22767 22767 S000111 rep WI 1939-01-03 1941-01-03   Republican 4                        
22768 22768 S000218 rep OH 1939-01-03 1941-01-03   Republican 16                        
22777 22777 S000228 rep NJ 1939-01-03 1941-01-03   Republican 8                        
22784 22784 S000452 rep NY 1939-01-03 1941-01-03   Democrat 14                        
22785 22785 S000478 sen IL 1939-04-14 1941-01-03 2 Democrat   appointment                      
22787 22787 S000523 rep ME 1939-01-03 1941-01-03   Republican 2                        
22794 22794 S000620 rep IL 1939-01-03 1941-01-03   Democrat 0                        
22806 22806 S001051 rep NY 1939-01-03 1941-01-03   Democrat 13                        
22807 22807 S001108 rep NE 1939-01-03 1941-01-03   Republican 1                        
22818 22818 T000083 rep TN 1939-01-03 1941-01-03   Republican 2                        
22819 22819 T000236 rep MT 1939-01-03 1941-01-03   Republican 1                        
22824 22824 T000417 rep TN 1939-01-03 1941-01-03   Democrat 6                        
22834 22834 W000166 rep NC 1939-01-03 1941-01-03   Democrat 1                        
22835 22835 W000222 rep AL 1939-01-03 1941-01-03   Democrat 7                        
22837 22837 W000364 rep OH 1939-01-03 1941-01-03   Republican 13                        
22838 22838 W000500 rep DE 1939-01-03 1941-01-03   Republican 0                        
22842 22842 W000702 rep MO 1939-01-03 1941-01-03   Democrat 6                        
22848 22848 W000088 sen WA 1940-12-19 1941-01-03 1 Democrat                          
22850 22850 A000244 sen FL 1936-11-03 1941-01-03 1 Democrat                          
22853 22853 A000290 rep IL 1939-01-03 1941-01-03   Democrat 23                        
22856 22856 A000342 sen VT 1935-01-03 1941-01-03 1 Republican                          
22860 22860 B000132 sen NJ 1938-01-01 1941-01-03 1 Republican                          
22862 22862 B000158 rep IL 1939-01-03 1941-01-03   Democrat 20                        

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