legislator_terms

Table actions Table actions

492 rows where "start" is on date 1941-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
22849 22849 W000088 sen WA 1941-01-03 1945-01-09 1 Democrat                          
22851 22851 A000244 sen FL 1941-01-03 1946-09-18 1 Democrat                          
22854 22854 A000290 rep IL 1941-01-03 1943-01-03   Democrat 23                        
22857 22857 A000342 sen VT 1941-01-03 1946-08-02 1 Republican                          
22858 22858 B000112 rep AL 1941-01-03 1943-01-03   Democrat 7                        
22861 22861 B000132 sen NJ 1941-01-03 1943-12-31 1 Republican                          
22863 22863 B000158 rep IL 1941-01-03 1943-01-03   Democrat 20                        
22869 22869 B000274 rep IL 1941-01-03 1943-01-03   Democrat 4                        
22873 22873 B000320 rep NY 1941-01-03 1943-01-03   Democrat 41                        
22874 22874 B000380 rep MO 1941-01-03 1943-01-03   Republican 6                        
22876 22876 B000460 sen MS 1941-01-03 1947-01-03 1 Democrat                          
22882 22882 B000588 rep IN 1941-01-03 1943-01-03   Democrat 8                        
22888 22888 B000601 rep PA 1941-01-03 1943-01-03   Democrat 11                        
22889 22889 B000602 rep PA 1941-01-03 1943-01-03   Democrat 11                        
22891 22891 B000604 rep WI 1941-01-03 1943-01-03   Republican 1                        
22896 22896 B001017 rep CA 1941-01-03 1943-01-03   Democrat 3                        
22900 22900 B001023 rep MN 1941-01-03 1943-01-03   Farmer-Labor 9                        
22901 22901 B001150 sen OH 1941-01-03 1945-12-31 1 Republican                          
22902 22902 B001222 rep MD 1941-01-03 1941-05-27   Democrat 6                        
22904 22904 B001206 rep MD 1941-01-03 1941-02-27   Democrat 6                        
22912 22912 C000207 rep OK 1941-01-03 1943-01-03   Democrat 3                        
22916 22916 C000225 rep MA 1941-01-03 1943-01-03   Democrat 3                        
22919 22919 C000489 rep OH 1941-01-03 1943-01-03   Democrat 11                        
22922 22922 C000535 rep NY 1941-01-03 1943-01-03   Republican 29                        
22926 22926 C000582 rep NE 1941-01-03 1943-01-03   Democrat 5                        
22933 22933 C000616 rep MD 1941-01-03 1943-01-03   Democrat 2                        
22943 22943 C000642 rep MS 1941-01-03 1943-01-03   Democrat 5                        
22946 22946 C000693 rep MA 1941-01-03 1943-01-03   Democrat 7                        
22947 22947 C000768 rep NE 1941-01-03 1943-01-03   Republican 1                        
22959 22959 C000948 rep NY 1941-01-03 1943-01-03   Republican 30                        
22963 22963 D000050 rep VA 1941-01-03 1943-01-03   Democrat 2                        
22964 22964 D000108 rep OH 1941-01-03 1943-01-03   Democrat 6                        
22965 22965 D000475 rep CT 1941-01-03 1943-01-03   Democrat 4                        
22972 22972 D000480 sen MS 1941-01-03 1943-01-03 2 Democrat                          
22977 22977 D000536 rep MO 1941-01-03 1943-01-03   Democrat 3                        
22979 22979 E000041 rep NY 1941-01-03 1943-01-03   Democrat 14                        
22984 22984 E000051 rep WV 1941-01-03 1943-01-03   Democrat 3                        
22985 22985 E000107 rep MA 1941-01-03 1943-01-03   Democrat 9                        
22987 22987 E000132 rep AR 1941-01-03 1943-01-03   Democrat 3                        
22992 22992 F000001 rep PA 1941-01-03 1943-01-03   Democrat 25                        
22994 22994 F000169 rep CT 1941-01-03 1943-01-03   Democrat 2                        
22997 22997 F000183 rep MA 1941-01-03 1943-01-03   Democrat 11                        
23000 23000 F000192 rep PA 1941-01-03 1943-01-03   Democrat 12                        
23002 23002 F000240 rep NC 1941-01-03 1943-01-03   Democrat 5                        
23006 23006 F000258 rep MS 1941-01-03 1943-01-03   Democrat 4                        
23008 23008 F000264 rep CA 1941-01-03 1943-01-03   Republican 16                        
23012 23012 G000118 rep WI 1941-01-03 1943-01-03   Progressive 10                        
23017 23017 G000141 sen RI 1941-01-03 1947-01-03 1 Democrat                          
23019 23019 G000147 rep CA 1941-01-03 1943-01-03   Democrat 17                        
23021 23021 G000519 sen PA 1941-01-03 1947-01-03 1 Democrat                          
23026 23026 H000026 rep PA 1941-01-03 1943-01-03   Democrat 22                        
23029 23029 H000231 rep IA 1941-01-03 1943-01-03   Democrat 9                        
23034 23034 H000294 rep OH 1941-01-03 1943-01-03   Democrat 14                        
23039 23039 H000423 rep MA 1941-01-03 1943-01-03   Democrat 8                        
23044 23044 H000600 rep WA 1941-01-03 1943-01-03   Democrat 4                        
23045 23045 H000709 rep OH 1941-01-03 1943-01-03   Democrat 3                        
23050 23050 H000824 rep KS 1941-01-03 1943-01-03   Democrat 5                        
23053 23053 H000983 rep OH 1941-01-03 1943-01-03   Democrat 9                        
23057 23057 I000010 rep OH 1941-01-03 1943-01-03   Democrat 18                        
23060 23060 J000039 rep IA 1941-01-03 1943-01-03   Democrat 2                        
23063 23063 J000060 rep PA 1941-01-03 1943-01-03   Republican 20                        
23066 23066 J000090 rep NH 1941-01-03 1943-01-03   Republican 1                        
23068 23068 J000111 rep WI 1941-01-03 1943-01-03   Republican 8                        
23074 23074 J000132 rep WV 1941-01-03 1943-01-03   Democrat 4                        
23079 23079 J000140 sen CA 1941-01-03 1945-12-31 1 Republican                          
23081 23081 K000112 rep NY 1941-01-03 1943-01-03   Democrat 15                        
23085 23085 K000214 rep HI 1941-01-03 1943-01-03   Republican 0                        
23090 23090 K000303 rep IL 1941-01-03 1943-01-03   Democrat 8                        
23095 23095 K000321 rep CA 1941-01-03 1943-01-03   Democrat 13                        
23099 23099 L000005 sen WI 1941-01-03 1947-01-03 1 Progressive                          
23105 23105 L000100 rep IN 1941-01-03 1943-01-03   Democrat 11                        
23108 23108 L000185 rep WA 1941-01-03 1943-01-03   Democrat 5                        
23111 23111 M000016 rep IL 1941-01-03 1943-01-03   Democrat 6                        
23112 23112 M000018 rep CT 1941-01-03 1943-01-03   Democrat 0                        
23115 23115 M000088 sen CT 1941-01-03 1945-12-31 1 Democrat                          
23119 23119 M000231 rep OK 1941-01-03 1943-01-03   Democrat 7                        
23121 23121 M000297 rep PA 1941-01-03 1943-01-03   Democrat 33                        
23122 23122 M000484 rep WY 1941-01-03 1943-01-03   Democrat 0                        
23126 23126 M000510 rep IL 1941-01-03 1943-01-03   Democrat 2                        
23130 23130 M000538 rep NE 1941-01-03 1943-01-03   Democrat 2                        
23141 23141 M000615 sen NY 1941-01-03 1947-01-03 1 Democrat                          
23142 23142 M000681 rep MD 1941-01-03 1943-01-03   Democrat 4                        
23145 23145 M000775 rep LA 1941-01-03 1943-01-03   Democrat 5                        
23149 23149 M000805 rep IL 1941-01-03 1943-01-03   Democrat 1                        
23152 23152 M001026 rep PA 1941-01-03 1943-01-03   Democrat 14                        
23157 23157 M001082 sen UT 1941-01-03 1947-01-03 1 Democrat                          
23158 23158 N000006 rep IA 1941-01-03 1943-01-03   Republican 9                        
23167 23167 N000046 rep MO 1941-01-03 1943-01-03   Democrat 2                        
23171 23171 O000033 rep NY 1941-01-03 1943-01-03   Democrat 0                        
23172 23172 P000011 rep IL 1941-01-03 1943-01-03   Republican 10                        
23177 23177 P000165 rep TN 1941-01-03 1943-01-03   Democrat 7                        
23178 23178 P000288 rep NY 1941-01-03 1943-01-03   Republican 16                        
23183 23183 P000339 rep OR 1941-01-03 1943-01-03   Democrat 2                        
23184 23184 P000385 rep LA 1941-01-03 1943-01-03   Democrat 7                        
23186 23186 R000006 sen MD 1941-01-03 1947-01-03 1 Democrat                          
23188 23188 R000055 rep MT 1941-01-03 1943-01-03   Republican 1                        
23191 23191 R000362 rep NY 1941-01-03 1943-01-03   Republican 27                        
23196 23196 R000405 rep OK 1941-01-03 1943-01-03   Democrat 0                        
23208 23208 R000418 rep MO 1941-01-03 1943-01-03   Democrat 1                        
23212 23212 R000546 rep PA 1941-01-03 1943-01-03   Republican 15                        

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