legislator_terms

Table actions Table actions

487 rows where "start" is on date 1943-01-06

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, end, 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
23346 23346 B000046 sen NC 1943-01-06 1947-01-03 2 Democrat                          
23348 23348 B000099 sen MN 1943-01-06 1949-01-03 2 Republican                          
23351 23351 B000111 sen AL 1943-01-06 1947-01-03 2 Democrat                          
23353 23353 B000874 sen IL 1943-01-06 1949-01-03 2 Republican                          
23354 23354 B001013 sen DE 1943-01-06 1949-01-03 2 Republican                          
23355 23355 B001072 rep NY 1943-01-06 1945-01-03   Democrat 15                        
23356 23356 B001168 sen SD 1943-01-06 1948-09-27 2 Republican                          
23358 23358 C000132 rep NY 1943-01-06 1945-01-03   Democrat 13                        
23363 23363 C000133 sen KS 1943-01-06 1949-01-03 2 Republican                          
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                        
23376 23376 C000290 sen KY 1943-01-06 1945-12-31 2 Democrat                          
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                        
23528 23528 G000232 sen VA 1943-01-06 1946-05-28 2 Democrat                          
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                        
23553 23553 H000334 sen NM 1943-01-06 1949-01-03 2 Democrat                          
23554 23554 H000365 sen NJ 1943-01-06 1949-01-03 2 Republican                          
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                        
23614 23614 M000583 sen OR 1943-01-06 1944-02-25 2 Republican                          
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                        
23626 23626 M000895 sen OK 1943-01-06 1949-01-03 2 Republican                          
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                        
23640 23640 O000034 sen TX 1943-01-06 1949-01-03 2 Democrat                          
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                        
23656 23656 R000320 sen WY 1943-01-06 1949-01-03 2 Republican                          
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                        
23709 23709 S000901 sen TN 1943-01-06 1949-01-03 2 Democrat                          
23710 23710 S001058 rep NV 1943-01-06 1945-01-03   Democrat 0                        
23713 23713 T000172 sen ID 1943-01-06 1945-12-31 2 Republican                          
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                        
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                        
23759 23759 W000396 sen ME 1943-01-06 1949-01-03 2 Republican                          
23760 23760 W000483 rep DE 1943-01-06 1945-01-03   Republican 0                        
23761 23761 W000581 sen IA 1943-01-06 1949-01-03 2 Republican                          

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