legislator_terms

Table actions Table actions

490 rows where "end" is on date 1929-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
18559 18559 B000252 sen DE 1923-12-03 1929-03-03 1 Democrat                          
18573 18573 B000972 sen MD 1923-12-03 1929-03-03 1 Democrat                          
18631 18631 E000066 sen NJ 1923-12-03 1929-03-03 1 Democrat                          
18748 18748 M000281 sen TX 1923-12-03 1929-03-03 1 Democrat                          
18758 18758 M000547 sen CT 1923-12-03 1929-03-03 1 Republican                          
18812 18812 R000118 sen MO 1923-12-03 1929-03-03 1 Democrat                          
19177 19177 D000560 sen DE 1925-12-07 1929-03-03 2 Republican                          
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                        
19220 19220 B000495 rep TX 1927-12-05 1929-03-03   Democrat 1                        
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                        
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                        
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                          
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                        
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                        
19442 19442 O000018 rep WV 1927-12-05 1929-03-03   Democrat 3                        
19454 19454 O000062 rep AR 1927-12-05 1929-03-03   Democrat 2                        
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                        
19487 19487 S000450 rep OR 1927-12-05 1929-03-03   Republican 2                        
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                        
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                        
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                        
19570 19570 L000101 sen NM 1928-12-07 1929-03-03 1 Republican                          
19571 19571 L000386 sen OH 1928-04-04 1929-03-03 3 Democrat   appointment                      
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                        
19668 19668 D000345 sen WA 1923-12-03 1929-03-03 1 Democrat                          
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                        
19702 19702 F000096 sen OH 1923-12-03 1929-03-03 1 Republican                          
19709 19709 F000149 rep TN 1927-12-05 1929-03-03   Democrat 10                        
19714 19714 F000166 rep OH 1927-12-05 1929-03-03   Republican 3                        
19717 19717 F000287 rep NJ 1927-12-05 1929-03-03   Republican 9                        
19723 19723 G000001 rep PI 1927-12-05 1929-03-03     0                        
19731 19731 G000246 rep CT 1927-12-05 1929-03-03   Republican 5                        
19740 19740 G000425 sen VT 1923-12-03 1929-03-03 1 Republican                          
19751 19751 G000456 rep PA 1927-12-05 1929-03-03   Republican 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);