legislator_terms

Table actions Table actions

488 rows where "end" is on date 1943-01-03

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, start, 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
22016 22016 B000941 sen MI 1937-01-05 1943-01-03 2 Democrat                          
22078 22078 B001055 sen SD 1937-01-05 1943-01-03 2 Democrat                          
22228 22228 H000543 sen IA 1937-01-05 1943-01-03 2 Democrat                          
22237 22237 H000926 sen DE 1937-01-05 1943-01-03 2 Democrat                          
22269 22269 L000198 sen OK 1937-01-05 1943-01-03 2 Democrat                          
22342 22342 N000139 sen NE 1937-01-05 1943-01-03 2 Independent                          
22404 22404 S000157 sen WY 1937-01-05 1943-01-03 2 Democrat                          
22417 22417 S000506 sen NJ 1937-04-15 1943-01-03 2 Democrat                          
22854 22854 A000290 rep IL 1941-01-03 1943-01-03   Democrat 23                        
22858 22858 B000112 rep AL 1941-01-03 1943-01-03   Democrat 7                        
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                        
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                        
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                        
23019 23019 G000147 rep CA 1941-01-03 1943-01-03   Democrat 17                        
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                        
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                        
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                        
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                        
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                        
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                        
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                        
23209 23209 R000443 sen WV 1941-01-13 1943-01-03 2 Democrat   appointment                      
23212 23212 R000546 rep PA 1941-01-03 1943-01-03   Republican 15                        
23215 23215 S000008 rep PA 1941-01-03 1943-01-03   Democrat 1                        
23218 23218 S000036 rep LA 1941-01-03 1943-01-03   Democrat 6                        
23223 23223 S000110 rep IL 1941-01-03 1943-01-03   Democrat 22                        
23228 23228 S000145 rep IN 1941-01-03 1943-01-03   Democrat 1                        
23230 23230 S000162 rep NY 1941-01-03 1943-01-03   Democrat 42                        
23234 23234 S000285 rep CT 1941-01-03 1943-01-03   Democrat 3                        
23240 23240 S000287 rep MO 1941-01-03 1943-01-03   Democrat 5                        

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