legislator_terms

Table actions Table actions

493 rows where "end" is on date 1925-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
17544 17544 B000100 sen DE 1919-05-19 1925-03-03 2 Republican                          
17643 17643 D000298 sen SC 1919-05-19 1925-03-03 2 Democrat                          
17656 17656 E000109 sen WV 1919-05-19 1925-03-03 2 Republican                          
17828 17828 M000369 sen IL 1919-05-19 1925-03-03 2 Republican                          
17879 17879 O000153 sen OK 1919-05-19 1925-03-03 2 Democrat                          
17931 17931 S000363 sen TN 1919-05-19 1925-03-03 2 Democrat                          
17963 17963 S000796 sen KY 1919-05-19 1925-03-03 2 Democrat                          
17968 17968 S000872 sen SD 1919-05-19 1925-03-03 2 Republican                          
18078 18078 B001144 sen NM 1921-04-11 1925-03-03 2 Republican   appointment                      
18563 18563 A000144 rep WV 1923-12-03 1925-03-03   Democrat 2                        
18570 18570 A000233 rep MN 1923-12-03 1925-03-03   Republican 1                        
18571 18571 B000712 rep DE 1923-12-03 1925-03-03   Democrat 0                        
18572 18572 B000954 rep NJ 1923-12-03 1925-03-03   Democrat 4                        
18574 18574 B001027 rep IL 1923-12-03 1925-03-03   Democrat 6                        
18582 18582 C000126 rep KY 1923-12-03 1925-03-03   Democrat 7                        
18592 18592 C000430 rep FL 1923-12-03 1925-03-03   Democrat 2                        
18600 18600 C000575 rep NY 1923-12-03 1925-03-03   Democrat -1                        
18603 18603 C000613 rep OH 1923-12-03 1925-03-03   Republican 8                        
18604 18604 C000727 rep IN 1923-12-03 1925-03-03   Democrat 11                        
18605 18605 C000923 rep PA 1923-12-03 1925-03-03   Democrat 14                        
18606 18606 C000987 rep PA 1923-12-03 1925-03-03   Democrat 17                        
18617 18617 D000093 rep MN 1923-12-03 1925-03-03   Republican 3                        
18625 18625 D000561 rep LA 1923-12-03 1925-03-03   Democrat 2                        
18630 18630 E000001 rep NJ 1923-12-03 1925-03-03   Democrat 11                        
18632 18632 E000243 rep IA 1923-12-03 1925-03-03   Republican 8                        
18636 18636 F000007 rep IN 1923-12-03 1925-03-03   Republican 12                        
18639 18639 F000048 rep LA 1923-12-03 1925-03-03   Democrat 6                        
18647 18647 F000113 rep KY 1923-12-03 1925-03-03   Democrat 9                        
18648 18648 F000194 rep VT 1923-12-03 1925-03-03   Republican 1                        
18651 18651 F000306 rep OH 1923-12-03 1925-03-03   Republican 10                        
18653 18653 G000038 rep NY 1923-12-03 1925-03-03   Democrat 24                        
18654 18654 G000133 rep NJ 1923-12-03 1925-03-03   Democrat 3                        
18655 18655 G000234 rep PA 1923-12-03 1925-03-03   Democrat 22                        
18659 18659 G000364 rep IL 1923-12-03 1925-03-03   Republican 14                        
18673 18673 G000430 rep MA 1923-12-03 1925-03-03   Republican 15                        
18675 18675 H000759 rep VA 1923-12-03 1925-03-03   Democrat 5                        
18680 18680 H000941 rep IA 1923-12-03 1925-03-03   Republican 2                        
18691 18691 H000960 rep MS 1923-12-03 1925-03-03   Democrat 3                        
18692 18692 H000964 rep MS 1923-12-03 1925-03-03   Democrat 3                        
18695 18695 J000273 rep MO 1923-12-03 1925-03-03   Democrat 5                        
18707 18707 K000003 rep CA 1923-12-03 1925-03-03   Republican 4                        
18719 18719 K000250 rep NC 1923-12-03 1925-03-03   Democrat 2                        
18728 18728 L000104 rep MN 1923-12-03 1925-03-03   Republican 8                        
18729 18729 L000171 rep MA 1923-12-03 1925-03-03   Republican 15                        
18730 18730 L000311 rep WV 1923-12-03 1925-03-03   Democrat 5                        
18734 18734 L000349 rep KS 1923-12-03 1925-03-03   Republican 2                        
18745 18745 L000406 rep SC 1923-12-03 1925-03-03   Democrat 1                        
18747 18747 M000028 rep CA 1923-12-03 1925-03-03   Republican 6                        
18755 18755 M000506 rep IL 1923-12-03 1925-03-03   Republican 13                        
18759 18759 M000588 rep NJ 1923-12-03 1925-03-03   Democrat 8                        
18760 18760 M000723 rep IL 1923-12-03 1925-03-03   Republican 22                        
18762 18762 M000789 rep NJ 1923-12-03 1925-03-03   Democrat 9                        
18764 18764 M000890 rep IL 1923-12-03 1925-03-03   Republican 19                        
18765 18765 M000914 rep GA 1923-12-03 1925-03-03   Democrat 1                        
18770 18770 M000928 rep IN 1923-12-03 1925-03-03   Republican 7                        
18771 18771 M000981 rep KY 1923-12-03 1925-03-03   Democrat 7                        
18778 18778 M001041 rep NY 1923-12-03 1925-03-03   Republican 32                        
18783 18783 M001060 rep MD 1923-12-03 1925-03-03   Republican 5                        
18785 18785 N000125 rep CA 1923-12-03 1925-03-03   Republican 5                        
18787 18787 O000008 rep NJ 1923-12-03 1925-03-03   Democrat 12                        
18788 18788 O000123 rep CT 1923-12-03 1925-03-03   Democrat 5                        
18792 18792 O000112 rep CA 1923-12-03 1925-03-03   Republican -1                        
18798 18798 P000024 rep MA 1923-12-03 1925-03-03   Republican 3                        
18804 18804 P000051 rep GA 1923-12-03 1925-03-03   Democrat 2                        
18808 18808 R000015 rep IL 1923-12-03 1925-03-03   Democrat 4                        
18816 18816 R000127 rep WV 1923-12-03 1925-03-03   Republican 3                        
18817 18817 R000211 rep NV 1923-12-03 1925-03-03   Democrat 0                        
18828 18828 R000264 rep NY 1923-12-03 1925-03-03   Democrat 11                        
18830 18830 R000289 rep MO 1923-12-03 1925-03-03   Republican 8                        
18832 18832 R000441 rep WV 1923-12-03 1925-03-03   Republican 1                        
18833 18833 S000019 rep TN 1923-12-03 1925-03-03   Democrat 7                        
18837 18837 S000034 rep IN 1923-12-03 1925-03-03   Republican 5                        
18838 18838 S000090 rep AR 1923-12-03 1925-03-03   Democrat 6                        
18847 18847 S000355 rep OH 1923-12-03 1925-03-03   Democrat 9                        
18848 18848 S000457 rep PA 1923-12-03 1925-03-03   Democrat 19                        
18855 18855 S000573 rep MI 1923-12-03 1925-03-03   Republican 3                        
18860 18860 S000666 rep NY 1923-12-03 1925-03-03   Republican 33                        
18861 18861 S000850 rep NY 1923-12-03 1925-03-03   Democrat 6                        
18866 18866 T000014 rep MA 1923-12-03 1925-03-03   Democrat 10                        
18873 18873 T000325 rep IA 1923-12-03 1925-03-03   Republican 8                        
18875 18875 T000455 rep AL 1923-12-03 1925-03-03   Democrat 2                        
18880 18880 W000129 rep NY 1923-12-03 1925-03-03   Republican 27                        
18882 18882 W000132 rep NC 1923-12-03 1925-03-03   Democrat 1                        
18883 18883 W000191 rep OR 1923-12-03 1925-03-03   Democrat 3                        
18886 18886 W000240 rep WA 1923-12-03 1925-03-03   Republican 5                        
18887 18887 W000300 rep PA 1923-12-03 1925-03-03   Republican 20                        
18888 18888 W000621 rep IN 1923-12-03 1925-03-03   Democrat 1                        
18894 18894 W000639 rep MA 1923-12-03 1925-03-03   Republican 4                        
18899 18899 W000650 rep GA 1923-12-03 1925-03-03   Democrat 6                        
18900 18900 W000679 rep MO 1923-12-03 1925-03-03   Democrat 13                        
18906 18906 Y000036 rep ND 1923-12-03 1925-03-03   Republican 2                        
18912 18912 B000493 rep PA 1923-12-03 1925-03-03   Republican 28                        
18924 18924 C000196 rep OK 1923-12-03 1925-03-03   Democrat 3                        
18929 18929 C000500 rep NY 1923-12-03 1925-03-03   Democrat 8                        
18932 18932 E000044 sen NJ 1919-05-19 1925-03-03 2 Republican                          
18937 18937 F000004 rep NY 1923-12-03 1925-03-03   Republican 24                        
18940 18940 F000084 sen ME 1919-05-19 1925-03-03 2 Republican                          
18943 18943 F000358 rep CA 1923-12-03 1925-03-03   Republican 10                        
18954 18954 F000407 rep IL 1923-12-03 1925-03-03   Republican 12                        
18957 18957 F000428 rep IL 1923-12-03 1925-03-03   Republican 17                        

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