legislator_terms

Table actions Table actions

484 rows where "start" is on date 1945-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
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                        
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                        
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                        
23841 23841 D000414 sen MO 1945-01-03 1951-01-03 3 Republican                          
23842 23842 D000452 rep IL 1945-01-03 1947-01-03   Democrat 0                        
23844 23844 D000469 sen CA 1945-01-03 1951-01-03 3 Democrat                          
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                        
23857 23857 G000532 sen SD 1945-01-03 1951-01-03 3 Republican                          
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                        
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                        
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                        
23925 23925 J000159 rep TX 1945-01-03 1946-07-17   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                        
23967 23967 L000493 sen IL 1945-01-03 1951-01-03 3 Democrat                          
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                        
23995 23995 M001029 sen ND 1945-01-03 1945-12-31 3 Democrat                          
24002 24002 M001040 rep OR 1945-01-03 1947-01-03   Republican 1                        
24004 24004 M001099 rep PA 1945-01-03 1946-07-17   Democrat 10                        
24008 24008 M001127 sen PA 1945-01-03 1951-01-03 3 Democrat                          
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                        
24025 24025 O000146 sen LA 1945-01-03 1949-01-03 3 Democrat                          
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                        
24064 24064 R000112 sen KS 1945-01-03 1949-11-08 3 Republican                          
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                        
24109 24109 S000812 rep MN 1945-01-03 1947-01-03   Democrat 4                        
24111 24111 S000918 rep OK 1945-01-03 1947-01-03   Democrat 3                        
24115 24115 S001071 rep IL 1945-01-03 1947-01-03   Republican 18                        
24132 24132 S001072 rep TX 1945-01-03 1947-01-03   Democrat 5                        
24135 24135 T000018 rep CT 1945-01-03 1947-01-03   Republican 5                        
24145 24145 T000045 rep GA 1945-01-03 1947-01-03   Democrat 7                        
24146 24146 T000079 sen ID 1945-01-03 1951-01-03 3 Democrat                          
24151 24151 T000155 rep OH 1945-01-03 1947-01-03   Democrat 16                        
24154 24154 T000164 sen UT 1945-01-03 1951-01-03 3 Democrat                          
24160 24160 T000177 sen OK 1945-01-03 1951-01-03 3 Democrat                          
24166 24166 T000295 rep CA 1945-01-03 1947-01-03   Democrat 7                        

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