legislator_terms

Table actions Table actions

488 rows where "end" is on date 1947-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
22876 22876 B000460 sen MS 1941-01-03 1947-01-03 1 Democrat                          
23017 23017 G000141 sen RI 1941-01-03 1947-01-03 1 Democrat                          
23021 23021 G000519 sen PA 1941-01-03 1947-01-03 1 Democrat                          
23099 23099 L000005 sen WI 1941-01-03 1947-01-03 1 Progressive                          
23141 23141 M000615 sen NY 1941-01-03 1947-01-03 1 Democrat                          
23157 23157 M001082 sen UT 1941-01-03 1947-01-03 1 Democrat                          
23186 23186 R000006 sen MD 1941-01-03 1947-01-03 1 Democrat                          
23244 23244 S000369 sen MN 1941-01-03 1947-01-03 1 Republican                          
23313 23313 T000409 sen DE 1941-01-03 1947-01-03 1 Democrat                          
23320 23320 W000097 sen MA 1941-01-03 1947-01-03 1 Democrat                          
23324 23324 W000330 sen MT 1941-01-03 1947-01-03 1 Democrat                          
23332 23332 W000563 sen IN 1941-01-03 1947-01-03 1 Republican                          
23346 23346 B000046 sen NC 1943-01-06 1947-01-03 2 Democrat                          
23351 23351 B000111 sen AL 1943-01-06 1947-01-03 2 Democrat                          
23767 23767 A000046 rep NH 1945-01-03 1947-01-03   Republican 2                        
23769 23769 B000086 rep MD 1945-01-03 1947-01-03   Democrat 2                        
23772 23772 B000093 rep NY 1945-01-03 1947-01-03   Republican 17                        
23778 23778 B000191 rep NY 1945-01-03 1947-01-03   Democrat 4                        
23779 23779 B000367 rep NY 1945-01-03 1947-01-03   Republican 29                        
23784 23784 B000640 rep OK 1945-01-03 1947-01-03   Democrat 4                        
23789 23789 B000743 rep PA 1945-01-03 1947-01-03   Democrat 3                        
23790 23790 B000828 sen MO 1945-01-18 1947-01-03 1 Democrat   appointment                      
23792 23792 B000976 rep PA 1945-01-03 1947-01-03   Republican 22                        
23795 23795 B001061 rep NV 1945-01-03 1947-01-03   Democrat 0                        
23799 23799 B001084 rep NC 1945-01-03 1947-01-03   Democrat 8                        
23800 23800 C000085 rep PA 1945-01-03 1947-01-03   Republican 29                        
23804 23804 C000115 rep FL 1945-01-03 1947-01-03   Democrat 4                        
23805 23805 C000211 sen NV 1945-07-25 1947-01-03 1 Democrat   appointment                      
23816 23816 C000565 rep MO 1945-01-03 1947-01-03   Democrat 13                        
23821 23821 C000584 rep WA 1945-01-03 1947-01-03   Democrat 6                        
23825 23825 C000996 rep MA 1945-01-03 1947-01-03   Democrat 11                        
23827 23827 D000067 rep VA 1945-01-03 1947-01-03   Democrat 2                        
23828 23828 D000206 rep WA 1945-01-03 1947-01-03   Democrat 1                        
23840 23840 D000335 rep NY 1945-01-03 1947-01-03   Democrat 19                        
23842 23842 D000452 rep IL 1945-01-03 1947-01-03   Democrat 0                        
23845 23845 E000016 rep TN 1945-01-03 1947-01-03   Democrat 5                        
23846 23846 E000210 rep NC 1945-01-03 1947-01-03   Democrat 10                        
23847 23847 G000019 rep MN 1945-01-03 1947-01-03   Democrat 3                        
23848 23848 G000051 rep OH 1945-01-03 1947-01-03   Democrat 3                        
23849 23849 G000117 rep CT 1945-01-03 1947-01-03   Democrat 3                        
23852 23852 G000163 rep GA 1945-01-03 1947-01-03   Democrat 8                        
23854 23854 G000194 rep CO 1945-01-03 1947-01-03   Republican 1                        
23855 23855 G000337 sen ID 1945-11-17 1947-01-03 2 Democrat   appointment                      
23867 23867 H000146 rep NY 1945-01-03 1947-01-03   Republican 36                        
23875 23875 H000200 rep SC 1945-01-03 1947-01-03   Democrat 3                        
23876 23876 H000293 sen CT 1945-02-15 1947-01-03 1 Republican   appointment                      
23877 23877 H000426 rep CA 1945-01-03 1947-01-03   Democrat 13                        
23880 23880 H000450 rep IL 1945-01-03 1947-01-03   Republican 24                        
23881 23881 H000515 rep WI 1945-01-03 1947-01-03   Republican 2                        
23883 23883 H000668 rep PA 1945-01-03 1947-01-03   Democrat 13                        
23884 23884 H000682 rep PA 1945-01-03 1947-01-03   Republican 23                        
23892 23892 H000741 rep MA 1945-01-03 1947-01-03   Republican 4                        
23897 23897 H000757 rep MI 1945-01-03 1947-01-03   Democrat 12                        
23898 23898 H000913 sen OH 1945-10-08 1947-01-03 1 Democrat   appointment                      
23903 23903 I000052 rep CA 1945-01-03 1947-01-03   Democrat 23                        
23913 23913 J000150 rep OK 1945-01-03 1947-01-03   Democrat 6                        
23932 23932 K000071 rep IL 1945-01-03 1947-01-03   Democrat 3                        
23941 23941 K000231 rep PA 1945-01-03 1947-01-03   Republican 9                        
23946 23946 K000315 rep CT 1945-01-03 1947-01-03   Democrat 1                        
23948 23948 L000003 rep IN 1945-01-03 1947-01-03   Republican 8                        
23962 23962 L000076 rep TX 1945-01-03 1947-01-03   Democrat 12                        
23963 23963 L000334 rep IL 1945-01-03 1947-01-03   Democrat 7                        
23969 23969 L000497 rep CT 1945-01-03 1947-01-03   Republican 4                        
23976 23976 M000091 rep LA 1945-01-03 1947-01-03   Democrat 2                        
23977 23977 M000097 rep GA 1945-01-03 1947-01-03   Democrat 5                        
23985 23985 M000272 rep KY 1945-01-03 1947-01-03   Democrat 7                        
23991 23991 M000446 rep MS 1945-01-03 1947-01-03   Democrat 7                        
23992 23992 M000451 rep PA 1945-01-03 1947-01-03   Democrat 6                        
23994 23994 M000504 rep LA 1945-01-03 1947-01-03   Democrat 5                        
24002 24002 M001040 rep OR 1945-01-03 1947-01-03   Republican 1                        
24013 24013 O000029 rep MT 1945-01-03 1947-01-03   Democrat 2                        
24019 24019 O000089 rep KY 1945-01-03 1947-01-03   Democrat 3                        
24021 24021 O000137 rep CA 1945-01-03 1947-01-03   Democrat 11                        
24029 24029 P000105 rep AL 1945-01-03 1947-01-03   Democrat 9                        
24030 24030 P000113 rep CA 1945-01-03 1947-01-03   Democrat 16                        
24036 24036 P000260 rep GA 1945-01-03 1947-01-03   Democrat 1                        
24043 24043 P000371 rep MN 1945-01-03 1947-01-03   Republican 8                        
24044 24044 P000361 rep PR 1945-01-03 1947-01-03   Popular Democrat 0                        
24051 24051 P000488 rep NJ 1945-01-03 1947-01-03   Republican 4                        
24052 24052 P000498 rep NC 1945-01-03 1947-01-03   Democrat 8                        
24053 24053 Q000019 rep NY 1945-01-03 1947-01-03   Democrat 26                        
24062 24062 R000032 rep GA 1945-01-03 1947-01-03   Democrat 5                        
24065 24065 R000163 rep IL 1945-01-03 1947-01-03   Democrat 9                        
24072 24072 R000341 rep UT 1945-01-03 1947-01-03   Democrat 2                        
24076 24076 R000373 rep PA 1945-01-03 1947-01-03   Republican 28                        
24077 24077 R000381 rep MD 1945-01-03 1947-01-03   Democrat 1                        
24078 24078 R000382 rep NY 1945-01-03 1947-01-03   Democrat 5                        
24079 24079 R000394 rep NY 1945-01-03 1947-01-03   Democrat 40                        
24081 24081 R000419 rep PI 1945-01-03 1947-01-03     0                        
24083 24083 R000473 rep IL 1945-01-03 1947-01-03   Democrat 2                        
24086 24086 R000538 rep TX 1945-01-03 1947-01-03   Democrat 17                        
24087 24087 R000565 rep CT 1945-01-03 1947-01-03   Democrat 0                        
24092 24092 S000069 rep VA 1945-01-03 1947-01-03   Democrat 3                        
24093 24093 S000080 rep WA 1945-01-03 1947-01-03   Democrat 3                        
24094 24094 S000293 rep NY 1945-01-03 1947-01-03   Republican 1                        
24098 24098 S000342 rep PA 1945-01-03 1947-01-03   Democrat 4                        
24100 24100 S000481 rep MO 1945-01-03 1947-01-03   Democrat 5                        
24107 24107 S000668 rep PA 1945-01-03 1947-01-03   Democrat 23                        
24108 24108 S000792 sen KY 1945-11-19 1947-01-03 2 Republican   appointment                      
24109 24109 S000812 rep MN 1945-01-03 1947-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);