legislator_terms

Table actions Table actions

493 rows where "end" is on date 1945-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
22520 22520 C000138 sen AR 1939-01-03 1945-01-03 3 Democrat                          
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                          
22551 22551 D000025 sen CT 1939-01-03 1945-01-03 3 Republican                          
22566 22566 D000111 sen PA 1939-01-03 1945-01-03 3 Republican                          
22633 22633 H000731 sen OR 1939-01-03 1945-01-03 3 Republican                          
22740 22740 N000176 sen ND 1939-01-03 1945-01-03 3 Republican                          
22754 22754 R000179 sen NC 1939-01-03 1945-01-03 3 Democrat                          
22793 22793 S000530 sen SC 1939-01-03 1945-01-03 3 Democrat                          
22826 22826 V000050 sen IN 1939-01-03 1945-01-03 3 Democrat                          
23355 23355 B001072 rep NY 1943-01-06 1945-01-03   Democrat 15                        
23358 23358 C000132 rep NY 1943-01-06 1945-01-03   Democrat 13                        
23364 23364 C000181 rep KY 1943-01-06 1945-01-03   Republican 4                        
23374 23374 C000195 rep CA 1943-01-06 1945-01-03   Republican 6                        
23377 23377 C000661 rep CT 1943-01-06 1945-01-03   Republican 3                        
23382 23382 C000795 rep CA 1943-01-06 1945-01-03   Democrat 15                        
23387 23387 C000898 rep KY 1943-01-06 1945-01-03   Democrat 4                        
23396 23396 C000968 rep NY 1943-01-06 1945-01-03   Republican 32                        
23409 23409 C000970 rep NY 1943-01-06 1945-01-03   Democrat 4                        
23411 23411 D000160 rep IL 1943-01-06 1945-01-03   Republican 0                        
23413 23413 D000292 rep IL 1943-01-06 1945-01-03   Republican 9                        
23414 23414 D000349 rep WI 1943-01-06 1945-01-03   Democrat 8                        
23420 23420 D000353 rep AK 1943-01-06 1945-01-03   Democrat 0                        
23427 23427 D000362 rep OK 1943-01-06 1945-01-03   Democrat 1                        
23433 23433 D000363 rep PA 1943-01-06 1945-01-03   Republican 17                        
23437 23437 D000453 rep NY 1943-01-06 1945-01-03   Republican 33                        
23441 23441 E000108 rep PI 1943-01-06 1945-01-03     0                        
23442 23442 E000141 rep MD 1943-01-06 1945-01-03   Republican 4                        
23443 23443 E000157 rep MO 1943-01-06 1945-01-03   Republican 8                        
23453 23453 E000182 rep CA 1943-01-06 1945-01-03   Republican 2                        
23455 23455 F000051 rep NY 1943-01-06 1945-01-03   Democrat 16                        
23468 23468 F000142 rep NY 1943-01-06 1945-01-03   Republican 26                        
23477 23477 F000175 rep NY 1943-01-06 1945-01-03   Democrat 24                        
23483 23483 F000267 rep CA 1943-01-06 1945-01-03   Democrat 14                        
23495 23495 F000417 rep SC 1943-01-06 1945-01-03   Democrat 2                        
23496 23496 F000418 rep SC 1943-01-06 1945-01-03   Democrat 2                        
23497 23497 F000432 rep PA 1943-01-06 1945-01-03   Democrat 25                        
23499 23499 G000014 rep MN 1943-01-06 1945-01-03   Republican 3                        
23507 23507 G000101 rep NY 1943-01-06 1945-01-03   Democrat 21                        
23514 23514 G000181 rep IA 1943-01-06 1945-01-03   Republican 6                        
23538 23538 G000415 rep FL 1943-01-06 1945-01-03   Democrat -1                        
23548 23548 G000538 rep KS 1943-01-06 1945-01-03   Republican 2                        
23550 23550 H000260 rep VA 1943-01-06 1945-01-03   Democrat 2                        
23555 23555 J000073 rep OH 1943-01-06 1945-01-03   Republican 3                        
23556 23556 J000121 rep IL 1943-01-06 1945-01-03   Republican 22                        
23558 23558 J000183 rep CA 1943-01-06 1945-01-03   Republican 18                        
23566 23566 K000111 rep NY 1943-01-06 1945-01-03   Democrat 18                        
23573 23573 K000257 rep TX 1943-01-06 1945-01-03   Democrat 14                        
23581 23581 L000037 rep KS 1943-01-06 1945-01-03   Republican 1                        
23587 23587 L000291 rep CO 1943-01-06 1945-01-03   Democrat 1                        
23595 23595 M000001 rep MN 1943-01-06 1945-01-03   Republican 4                        
23596 23596 M000360 rep TN 1943-01-06 1945-01-03   Democrat 5                        
23600 23600 M000454 rep PA 1943-01-06 1945-01-03   Democrat 2                        
23606 23606 M000545 rep NJ 1943-01-06 1945-01-03   Republican 6                        
23607 23607 M000579 rep WI 1943-01-06 1945-01-03   Democrat 5                        
23615 23615 M000611 rep CT 1943-01-06 1945-01-03   Republican 2                        
23620 23620 M000661 rep NY 1943-01-06 1945-01-03   Democrat 0                        
23621 23621 M000745 rep MO 1943-01-06 1945-01-03   Republican 11                        
23623 23623 M000756 rep PA 1943-01-06 1945-01-03   Republican 12                        
23625 23625 M000855 rep CT 1943-01-06 1945-01-03   Republican 0                        
23628 23628 M000993 rep NC 1943-01-06 1945-01-03   Democrat 10                        
23629 23629 M001058 rep NY 1943-01-06 1945-01-03   Republican 41                        
23630 23630 N000073 rep AL 1943-01-06 1945-01-03   Democrat 9                        
23635 23635 N000092 rep OK 1943-01-06 1945-01-03   Democrat 2                        
23638 23638 O000014 rep NY 1943-01-06 1945-01-03   Republican 38                        
23645 23645 O000065 rep NY 1943-01-06 1945-01-03   Democrat 11                        
23648 23648 P000013 rep PR 1943-01-06 1945-01-03   Coalitionist 0                        
23653 23653 P000142 rep TX 1943-01-06 1945-01-03   Democrat 7                        
23654 23654 P000494 rep PA 1943-01-06 1945-01-03   Republican 5                        
23655 23655 P000503 rep PA 1943-01-06 1945-01-03   Republican 2                        
23657 23657 R000406 rep CA 1943-01-06 1945-01-03   Democrat 16                        
23659 23659 R000413 rep CA 1943-01-06 1945-01-03   Republican 4                        
23660 23660 R000475 rep OH 1943-01-06 1945-01-03   Republican 14                        
23664 23664 S000079 rep WI 1943-01-06 1945-01-03   Progressive 2                        
23666 23666 S000105 rep PA 1943-01-06 1945-01-03   Democrat 16                        
23668 23668 S000126 rep WV 1943-01-06 1945-01-03   Republican 1                        
23675 23675 S000144 rep IL 1943-01-06 1945-01-03   Democrat 7                        
23683 23683 S000580 rep WV 1943-01-06 1945-01-03   Democrat 6                        
23684 23684 S000798 rep NY 1943-01-06 1945-01-03   Republican 0                        
23689 23689 S000816 rep AL 1943-01-06 1945-01-03   Democrat 5                        
23704 23704 S000820 rep AL 1943-01-06 1945-01-03   Democrat 3                        
23707 23707 S000823 rep NH 1943-01-06 1945-01-03   Republican 2                        
23710 23710 S001058 rep NV 1943-01-06 1945-01-03   Democrat 0                        
23729 23729 T000358 rep MA 1943-01-06 1945-01-03   Republican 1                        
23730 23730 T000384 rep PA 1943-01-06 1945-01-03   Republican 0                        
23734 23734 V000100 rep KY 1943-01-06 1945-01-03   Democrat 2                        
23735 23735 W000096 sen NJ 1943-11-26 1945-01-03 1 Democrat   appointment                      
23738 23738 W000130 rep MD 1943-01-06 1945-01-03   Democrat 1                        
23741 23741 W000294 rep NJ 1943-01-06 1945-01-03   Democrat 2                        
23744 23744 W000327 rep IL 1943-01-06 1945-01-03   Republican 19                        
23749 23749 W000343 rep GA 1943-01-06 1945-01-03   Democrat 9                        
23760 23760 W000483 rep DE 1943-01-06 1945-01-03   Republican 0                        
23763 23763 W000762 rep PA 1943-01-06 1945-01-03   Democrat 32                        
23764 23764 H000080 sen SC 1944-11-20 1945-01-03 3 Democrat   appointment                      
23765 23765 J000026 sen IN 1944-01-28 1945-01-03 3 Democrat   appointment                      
23766 23766 W000248 sen MA 1944-02-08 1945-01-03 2 Republican   appointment                      
23768 23768 B000086 rep MD 1943-01-06 1945-01-03   Democrat 2                        
23771 23771 B000093 rep NY 1943-01-06 1945-01-03   Republican 17                        
23777 23777 B000191 rep NY 1943-01-06 1945-01-03   Democrat 2                        
23783 23783 B000640 rep OK 1943-01-06 1945-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);