legislator_terms

Table actions Table actions

499 rows where "end" is on date 1933-03-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
19213 19213 B000470 sen CT 1927-12-05 1933-03-03 3 Republican                          
19221 19221 B000520 sen WI 1927-12-05 1933-03-03 3 Republican                          
19236 19236 B000873 sen IA 1927-12-05 1933-03-03 3 Republican                          
19238 19238 B000895 sen LA 1927-12-05 1933-03-03 3 Democrat                          
19285 19285 D000009 sen VT 1927-12-05 1933-03-03 3 Republican                          
19370 19370 J000257 sen WA 1927-12-05 1933-03-03 3 Republican                          
19441 19441 M001028 sen NH 1927-12-05 1933-03-03 3 Republican                          
19444 19444 O000035 sen NV 1927-12-05 1933-03-03 3 Republican                          
19479 19479 S000380 sen CA 1927-12-05 1933-03-03 3 Republican                          
19492 19492 S000644 sen UT 1927-12-05 1933-03-03 3 Republican                          
19529 19529 W000186 sen CO 1927-12-05 1933-03-03 3 Republican                          
19538 19538 W000203 sen IN 1927-12-05 1933-03-03 3 Republican                          
19569 19569 G000238 sen IL 1928-12-03 1933-03-03 3 Republican                          
20019 20019 S001094 sen VA 1929-04-15 1933-03-03 1 Democrat                          
20080 20080 A000021 rep NJ 1931-12-07 1933-03-03   Republican 5                        
20084 20084 A000057 rep IL 1931-12-07 1933-03-03   Republican 19                        
20089 20089 A000084 rep RI 1931-12-07 1933-03-03   Republican 2                        
20093 20093 A000131 rep IL 1931-12-07 1933-03-03   Republican 14                        
20098 20098 A000277 rep NV 1931-12-07 1933-03-03   Republican 0                        
20108 20108 A000321 rep LA 1931-12-07 1933-03-03   Democrat 8                        
20112 20112 B000012 rep WV 1931-12-07 1933-03-03   Republican 1                        
20113 20113 B000082 rep NE 1931-12-07 1933-03-03   Republican 2                        
20120 20120 B000126 rep CA 1931-12-07 1933-03-03   Republican 7                        
20121 20121 B000217 rep MO 1931-12-07 1933-03-03   Democrat 16                        
20126 20126 B000312 rep PA 1931-12-07 1933-03-03   Republican 18                        
20127 20127 B000442 rep PA 1931-12-07 1933-03-03   Republican 18                        
20130 20130 B000596 rep MI 1931-12-07 1933-03-03   Republican 11                        
20135 20135 B000766 rep OH 1931-12-07 1933-03-03   Republican 7                        
20144 20144 B001075 rep RI 1931-12-07 1933-03-03   Republican 1                        
20150 20150 B001146 rep ND 1931-12-07 1933-03-03   Republican 1                        
20153 20153 B001187 rep OR 1931-12-07 1933-03-03   Republican 2                        
20157 20157 C000007 rep OH 1931-12-07 1933-03-03   Republican 4                        
20159 20159 C000081 rep IA 1931-12-07 1933-03-03   Republican 11                        
20167 20167 C000084 rep PA 1931-12-07 1933-03-03   Republican 36                        
20172 20172 C000114 rep IN 1931-12-07 1933-03-03   Democrat 4                        
20175 20175 C000328 rep PA 1931-12-07 1933-03-03   Republican 23                        
20182 20182 C000361 rep IL 1931-12-07 1933-03-03   Republican 10                        
20185 20185 C000364 rep IL 1931-12-07 1933-03-03   Republican 15                        
20187 20187 C000378 rep MN 1931-12-07 1933-03-03   Republican 1                        
20194 20194 C000384 rep SD 1931-12-07 1933-03-03   Republican 1                        
20200 20200 C000401 rep MN 1931-12-07 1933-03-03   Republican 2                        
20204 20204 C000412 rep MI 1931-12-07 1933-03-03   Republican 1                        
20210 20210 C000608 rep IA 1931-12-07 1933-03-03   Republican 5                        
20222 20222 C000630 rep MS 1931-12-07 1933-03-03   Democrat 8                        
20228 20228 C000652 rep UT 1931-12-07 1933-03-03   Republican 1                        
20230 20230 C000730 rep NY 1931-12-07 1933-03-03   Republican 41                        
20250 20250 C000752 rep WI 1931-12-07 1933-03-03   Republican -1                        
20257 20257 C000844 rep PA 1931-12-07 1933-03-03   Republican 30                        
20260 20260 C000864 rep CA 1931-12-07 1933-03-03   Republican 10                        
20271 20271 C000909 rep GA 1931-12-07 1933-03-03   Democrat 3                        
20272 20272 C001001 rep CA 1931-12-07 1933-03-03   Republican 3                        
20281 20281 D000012 rep MA 1931-12-07 1933-03-03   Republican 8                        
20285 20285 D000070 rep NY 1931-12-07 1933-03-03   Republican 33                        
20292 20292 D000098 rep TN 1931-12-07 1933-03-03   Democrat 5                        
20293 20293 D000129 rep PA 1931-12-07 1933-03-03   Republican 6                        
20308 20308 D000408 rep SC 1931-12-07 1933-03-03   Democrat 3                        
20311 20311 D000455 rep AZ 1931-12-07 1933-03-03   Democrat 0                        
20319 20319 D000486 rep FL 1931-12-07 1933-03-03   Democrat 1                        
20330 20330 D000591 rep MO 1931-12-07 1933-03-03   Republican 12                        
20338 20338 D000090 rep PR 1931-12-07 1933-03-03   Unionist 0                        
20340 20340 E000027 rep CO 1931-12-07 1933-03-03   Republican 1                        
20349 20349 E000062 rep GA 1931-12-07 1933-03-03   Democrat 1                        
20351 20351 E000203 rep PA 1931-12-07 1933-03-03   Republican 32                        
20355 20355 E000216 rep TN 1931-12-07 1933-03-03   Democrat 7                        
20356 20356 E000217 rep TN 1931-12-07 1933-03-03   Democrat 7                        
20359 20359 E000221 rep PA 1931-12-07 1933-03-03   Republican 35                        
20368 20368 E000247 rep MT 1931-12-07 1933-03-03   Democrat 1                        
20370 20370 F000130 rep KY 1931-12-07 1933-03-03   Republican 11                        
20371 20371 F000143 rep VA 1931-12-07 1933-03-03   Democrat 7                        
20372 20372 F000211 rep VA 1931-12-07 1933-03-03   Democrat 10                        
20378 20378 F000359 rep CA 1931-12-07 1933-03-03   Republican 8                        
20387 20387 F000366 rep CT 1931-12-07 1933-03-03   Republican 2                        
20400 20400 F000375 rep ID 1931-12-07 1933-03-03   Republican 1                        
20403 20403 F000400 rep MO 1931-12-07 1933-03-03   Democrat 14                        
20408 20408 G000046 rep OK 1931-12-07 1933-03-03   Republican 8                        
20416 20416 G000081 rep TX 1931-12-07 1933-03-03   Democrat 8                        
20421 20421 G000177 rep KY 1931-12-07 1933-03-03   Democrat 8                        
20422 20422 G000193 rep IN 1931-12-07 1933-03-03   Democrat 5                        
20426 20426 G000259 rep PA 1931-12-07 1933-03-03   Republican 4                        
20430 20430 G000299 rep MN 1931-12-07 1933-03-03   Republican 10                        
20444 20444 G000354 rep PA 1931-12-07 1933-03-03   Republican 2                        
20445 20445 G000370 rep IL 1931-12-07 1933-03-03   Republican 8                        
20454 20454 H000008 rep WA 1931-12-07 1933-03-03   Republican 2                        
20458 20458 H000030 rep NH 1931-12-07 1933-03-03   Republican -1                        
20461 20461 H000053 rep IL 1931-12-07 1933-03-03   Republican 17                        
20463 20463 H000069 rep MS 1931-12-07 1933-03-03   Democrat 6                        
20468 20468 H000071 rep ND 1931-12-07 1933-03-03   Republican 2                        
20475 20475 H000195 rep CO 1931-12-07 1933-03-03   Republican 3                        
20478 20478 H000259 sen GA 1931-12-07 1933-03-03 2 Democrat                          
20497 20497 H000350 rep IA 1931-12-07 1933-03-03   Republican 4                        
20510 20510 H000379 rep OR 1931-12-07 1933-03-03   Republican 1                        
20517 20517 H000669 rep KS 1931-12-07 1933-03-03   Republican 4                        
20521 20521 H000702 rep IN 1931-12-07 1933-03-03   Republican 12                        
20523 20523 H000704 rep WV 1931-12-07 1933-03-03   Republican 4                        
20528 20528 H000708 rep IL 1931-12-07 1933-03-03   Republican 18                        
20531 20531 H000772 rep MO 1931-12-07 1933-03-03   Republican 4                        
20532 20532 H000793 rep WA 1931-12-07 1933-03-03   Republican 1                        
20536 20536 H000826 rep DE 1931-12-07 1933-03-03   Republican 0                        
20539 20539 H000828 rep HI 1931-12-07 1933-03-03   Republican -1                        
20556 20556 H000944 rep IL 1931-12-07 1933-03-03   Republican 2                        

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