legislator_terms

Table actions Table actions

495 rows where "start" is on date 1939-01-03

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, end, 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
22473 22473 A000028 sen CO 1939-01-03 1941-12-31 3 Democrat                          
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                        
22511 22511 B000614 sen WA 1939-01-03 1944-11-13 3 Democrat                          
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                        
22520 22520 C000138 sen AR 1939-01-03 1945-01-03 3 Democrat                          
22523 22523 C000296 rep TN 1939-01-03 1941-01-03   Democrat 9                        
22526 22526 C000428 sen ID 1939-01-03 1945-01-03 3 Democrat                          
22528 22528 C000440 sen MO 1939-01-03 1945-01-03 3 Democrat                          
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                        
22551 22551 D000025 sen CT 1939-01-03 1945-01-03 3 Republican                          
22563 22563 D000063 rep PA 1939-01-03 1941-01-03   Republican 7                        
22566 22566 D000111 sen PA 1939-01-03 1945-01-03 3 Republican                          
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                        
22633 22633 H000731 sen OR 1939-01-03 1945-01-03 3 Republican                          
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                        
22740 22740 N000176 sen ND 1939-01-03 1945-01-03 3 Republican                          
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                        
22754 22754 R000179 sen NC 1939-01-03 1945-01-03 3 Democrat                          
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                        
22787 22787 S000523 rep ME 1939-01-03 1941-01-03   Republican 2                        
22793 22793 S000530 sen SC 1939-01-03 1945-01-03 3 Democrat                          
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                        
22826 22826 V000050 sen IN 1939-01-03 1945-01-03 3 Democrat                          
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                        
22853 22853 A000290 rep IL 1939-01-03 1941-01-03   Democrat 23                        
22862 22862 B000158 rep IL 1939-01-03 1941-01-03   Democrat 20                        
22868 22868 B000274 rep IL 1939-01-03 1941-01-03   Democrat 4                        
22881 22881 B000588 rep IN 1939-01-03 1941-01-03   Democrat 8                        
22887 22887 B000601 rep PA 1939-01-03 1941-01-03   Democrat 11                        
22890 22890 B000604 rep WI 1939-01-03 1941-01-03   Republican 1                        
22895 22895 B001017 rep CA 1939-01-03 1941-01-03   Democrat 3                        

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