legislator_terms

Table actions Table actions

486 rows where "start" is on date 1927-12-05

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, end, 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
19183 19183 H000362 sen MO 1927-12-05 1933-02-03 3 Democrat                          
19197 19197 A000261 rep KS 1927-12-05 1929-03-03   Republican 1                        
19201 19201 B000291 rep WI 1927-12-05 1929-03-03   Republican 7                        
19206 19206 B000314 rep OH 1927-12-05 1929-03-03   Republican 13                        
19211 19211 B000407 rep WI 1927-12-05 1929-03-03   Socialist 5                        
19213 19213 B000470 sen CT 1927-12-05 1933-03-03 3 Republican                          
19220 19220 B000495 rep TX 1927-12-05 1929-03-03   Democrat 1                        
19221 19221 B000520 sen WI 1927-12-05 1933-03-03 3 Republican                          
19226 19226 B000597 rep IA 1927-12-05 1929-03-03   Republican 11                        
19228 19228 B000700 rep MA 1927-12-05 1929-03-03   Republican 2                        
19233 19233 B000702 rep AL 1927-12-05 1929-03-03   Democrat 5                        
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                          
19239 19239 B001171 rep PA 1927-12-05 1929-03-03   Republican 14                        
19255 19255 B001192 rep PA 1927-12-05 1929-03-03   Republican 8                        
19261 19261 C000139 sen AR 1927-12-05 1931-12-31 3 Democrat                          
19264 19264 C000194 rep MN 1927-12-05 1929-03-03   Farmer-Labor 8                        
19265 19265 C000599 rep NY 1927-12-05 1929-03-03   Democrat 17                        
19266 19266 C000654 rep MO 1927-12-05 1929-03-03   Democrat 5                        
19268 19268 C000959 rep OR 1927-12-05 1929-03-03   Republican -1                        
19279 19279 C001008 sen KS 1927-12-05 1929-03-03 3 Republican                          
19285 19285 D000009 sen VT 1927-12-05 1933-03-03 3 Republican                          
19290 19290 D000080 rep OH 1927-12-05 1929-03-03   Democrat 14                        
19294 19294 D000169 rep VA 1927-12-05 1929-03-03   Democrat 2                        
19295 19295 E000180 rep WV 1927-12-05 1929-03-03   Republican 6                        
19299 19299 F000047 rep MO 1927-12-05 1929-03-03   Republican 4                        
19301 19301 F000170 rep OH 1927-12-05 1929-03-03   Republican 4                        
19305 19305 F000395 rep MA 1927-12-05 1929-03-03   Republican 14                        
19307 19307 F000433 rep MN 1927-12-05 1929-03-03   Republican 1                        
19315 19315 G000024 rep MA 1927-12-05 1929-03-03   Democrat 12                        
19318 19318 G000053 rep IN 1927-12-05 1929-03-03   Democrat 3                        
19330 19330 G000082 rep TN 1927-12-05 1929-03-03   Democrat 9                        
19332 19332 G000288 sen ID 1927-12-05 1929-03-03 3 Republican                          
19341 19341 G000422 rep IA 1927-12-05 1929-03-03   Republican 9                        
19348 19348 H000277 rep VA 1927-12-05 1929-03-03   Democrat 7                        
19349 19349 H000421 rep PA 1927-12-05 1929-03-03   Republican -1                        
19355 19355 H000544 rep ME 1927-12-05 1929-03-03   Republican 4                        
19358 19358 H000837 rep OK 1927-12-05 1929-03-03   Democrat 1                        
19361 19361 J000040 rep NY 1927-12-05 1929-03-03   Democrat 38                        
19370 19370 J000257 sen WA 1927-12-05 1933-03-03 3 Republican                          
19372 19372 K000124 rep PA 1927-12-05 1929-03-03   Democrat 30                        
19377 19377 K000191 rep NY 1927-12-05 1929-03-03   Democrat 2                        
19384 19384 K000200 rep IL 1927-12-05 1929-03-03   Republican 15                        
19392 19392 L000153 rep LA 1927-12-05 1929-03-03   Democrat -1                        
19396 19396 L000484 rep MS 1927-12-05 1929-03-03   Democrat 2                        
19400 19400 L000543 rep NC 1927-12-05 1929-03-03   Democrat 6                        
19405 19405 M000009 rep NY 1927-12-05 1929-03-03   Republican 41                        
19417 19417 M000038 rep IL 1927-12-05 1929-03-03   Republican 1                        
19424 19424 M000049 rep NY 1927-12-05 1929-03-03   Republican -1                        
19425 19425 M000850 rep RI 1927-12-05 1929-03-03   Republican 3                        
19426 19426 M000912 rep NJ 1927-12-05 1929-03-03   Democrat 8                        
19427 19427 M000931 rep KY 1927-12-05 1929-03-03   Democrat 4                        
19435 19435 M000961 rep PA 1927-12-05 1929-03-03   Republican 34                        
19438 19438 M001004 rep NM 1927-12-05 1929-03-03   Democrat 1                        
19441 19441 M001028 sen NH 1927-12-05 1933-03-03 3 Republican                          
19442 19442 O000018 rep WV 1927-12-05 1929-03-03   Democrat 3                        
19444 19444 O000035 sen NV 1927-12-05 1933-03-03 3 Republican                          
19454 19454 O000062 rep AR 1927-12-05 1929-03-03   Democrat 2                        
19459 19459 O000140 sen NC 1927-12-05 1930-12-12 3 Democrat                          
19460 19460 P000037 rep PA 1927-12-05 1929-03-03   Republican 13                        
19463 19463 P000186 rep VA 1927-12-05 1929-03-03   Democrat 9                        
19466 19466 R000068 rep IL 1927-12-05 1929-03-03   Republican -1                        
19469 19469 R000119 rep AR 1927-12-05 1929-03-03   Democrat 6                        
19477 19477 R000491 rep MO 1927-12-05 1929-03-03   Democrat 16                        
19479 19479 S000380 sen CA 1927-12-05 1933-03-03 3 Republican                          
19487 19487 S000450 rep OR 1927-12-05 1929-03-03   Republican 2                        
19492 19492 S000644 sen UT 1927-12-05 1933-03-03 3 Republican                          
19497 19497 S000855 rep OH 1927-12-05 1929-03-03   Republican -1                        
19499 19499 S001024 rep WV 1927-12-05 1929-03-03   Republican 5                        
19502 19502 S001109 rep NY 1927-12-05 1929-03-03   Republican 32                        
19503 19503 T000049 rep OH 1927-12-05 1929-03-03   Republican 2                        
19510 19510 T000276 rep AR 1927-12-05 1929-03-03   Democrat 3                        
19512 19512 U000020 rep IN 1927-12-05 1929-03-03   Republican 7                        
19517 19517 V000004 rep CO 1927-12-05 1929-03-03   Republican -1                        
19526 19526 V000071 sen PA 1927-12-05 1929-12-06 3 Republican                          
19527 19527 V000102 rep IA 1927-12-05 1929-03-03   Republican 9                        
19528 19528 W000149 rep KY 1927-12-05 1929-03-03   Democrat 6                        
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                          
19543 19543 W000374 rep KS 1927-12-05 1929-03-03   Republican 6                        
19544 19544 W000393 rep CO 1927-12-05 1929-03-03   Democrat 1                        
19548 19548 W000561 sen OH 1927-12-05 1929-03-03 3 Republican                          
19551 19551 W000617 rep MS 1927-12-05 1929-03-03   Democrat 6                        
19554 19554 W000643 rep WY 1927-12-05 1929-03-03   Republican 0                        
19567 19567 B001159 rep OH 1927-12-05 1928-12-15   Republican 22                        
19586 19586 B000348 rep GA 1927-12-05 1929-03-03   Democrat 9                        
19593 19593 B000710 rep TX 1927-12-05 1929-03-03   Democrat 2                        
19596 19596 B000832 rep VT 1927-12-05 1929-03-03   Republican 1                        
19606 19606 B000955 rep WI 1927-12-05 1929-03-03   Republican 8                        
19615 19615 C000142 rep NY 1927-12-05 1929-03-03   Democrat 18                        
19621 19621 C000223 rep PA 1927-12-05 1929-03-03   Democrat 12                        
19625 19625 C000274 rep OH 1927-12-05 1929-03-03   Republican 9                        
19636 19636 C000870 rep MI 1927-12-05 1929-03-03   Republican 7                        
19645 19645 C001000 rep CA 1927-12-05 1929-03-03   Republican 3                        
19656 19656 D000229 rep NY 1927-12-05 1929-03-03   Republican 40                        
19664 19664 D000237 rep IL 1927-12-05 1929-03-03   Republican 25                        
19673 19673 D000483 rep IL 1927-12-05 1929-03-03   Democrat 4                        
19683 19683 E000127 rep IN 1927-12-05 1929-03-03   Republican 6                        
19695 19695 F000072 rep CT 1927-12-05 1929-03-03   Republican 1                        
19709 19709 F000149 rep TN 1927-12-05 1929-03-03   Democrat 10                        

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