legislator_terms

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

495 rows where "start" is on date 1923-12-03

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: party, start (date), end (date)

Link rowid ▼ legislator_id type state start end class party district how party_affiliations url caucus address phone fax contact_form office state_rank rss_url end-type
18559 18559 Thomas Bayard B000252 sen DE 1923-12-03 1929-03-03 1 Democrat                          
18563 18563 Robert Allen A000144 rep WV 1923-12-03 1925-03-03   Democrat 2                        
18570 18570 Sydney Anderson A000233 rep MN 1923-12-03 1925-03-03   Republican 1                        
18571 18571 William Boyce B000712 rep DE 1923-12-03 1925-03-03   Democrat 0                        
18572 18572 Charles Browne B000954 rep NJ 1923-12-03 1925-03-03   Democrat 4                        
18573 18573 William Bruce B000972 sen MD 1923-12-03 1929-03-03 1 Democrat                          
18574 18574 James Buckley B001027 rep IL 1923-12-03 1925-03-03   Democrat 6                        
18582 18582 James Cantrill C000126 rep KY 1923-12-03 1925-03-03   Democrat 7                        
18592 18592 Frank Clark C000430 rep FL 1923-12-03 1925-03-03   Democrat 2                        
18600 18600 William Cockran C000575 rep NY 1923-12-03 1925-03-03   Democrat -1                        
18603 18603 Raymond Cole C000613 rep OH 1923-12-03 1925-03-03   Republican 8                        
18604 18604 Samuel Cook C000727 rep IN 1923-12-03 1925-03-03   Democrat 11                        
18605 18605 William Croll C000923 rep PA 1923-12-03 1925-03-03   Democrat 14                        
18606 18606 Herbert Cummings C000987 rep PA 1923-12-03 1925-03-03   Democrat 17                        
18617 18617 Charles Davis D000093 rep MN 1923-12-03 1925-03-03   Republican 3                        
18625 18625 Henry Dupré D000561 rep LA 1923-12-03 1925-03-03   Democrat 2                        
18630 18630 John Eagan E000001 rep NJ 1923-12-03 1925-03-03   Democrat 11                        
18631 18631 Edward Edwards E000066 sen NJ 1923-12-03 1929-03-03 1 Democrat                          
18632 18632 Hiram Evans E000243 rep IA 1923-12-03 1925-03-03   Republican 8                        
18636 18636 Louis Fairfield F000007 rep IN 1923-12-03 1925-03-03   Republican 12                        
18639 18639 George Favrot F000048 rep LA 1923-12-03 1925-03-03   Democrat 6                        
18640 18640 Woodbridge Ferris F000092 sen MI 1923-12-03 1928-03-23 1 Democrat                          
18647 18647 William Fields F000113 rep KY 1923-12-03 1925-03-03   Democrat 9                        
18648 18648 Frederick Fleetwood F000194 rep VT 1923-12-03 1925-03-03   Republican 1                        
18651 18651 Israel Foster F000306 rep OH 1923-12-03 1925-03-03   Republican 10                        
18653 18653 James Ganly G000038 rep NY 1923-12-03 1925-03-03   Democrat 24                        
18654 18654 Elmer Geran G000133 rep NJ 1923-12-03 1925-03-03   Democrat 3                        
18655 18655 Samuel Glatfelter G000234 rep PA 1923-12-03 1925-03-03   Democrat 22                        
18659 18659 William Graham G000364 rep IL 1923-12-03 1925-03-03   Republican 14                        
18673 18673 William Greene G000430 rep MA 1923-12-03 1925-03-03   Republican 15                        
18675 18675 James Hooker H000759 rep VA 1923-12-03 1925-03-03   Democrat 5                        
18680 18680 Harry Hull H000941 rep IA 1923-12-03 1925-03-03   Republican 2                        
18691 18691 Benjamin Humphreys H000960 rep MS 1923-12-03 1925-03-03   Democrat 3                        
18692 18692 William Humphreys H000964 rep MS 1923-12-03 1925-03-03   Democrat 3                        
18694 18694 Andrieus Jones J000210 sen NM 1923-12-03 1927-12-20 1 Democrat                          
18695 18695 Henry Jost J000273 rep MO 1923-12-03 1925-03-03   Democrat 5                        
18707 18707 Julius Kahn K000003 rep CA 1923-12-03 1925-03-03   Republican 4                        
18719 18719 Claude Kitchin K000250 rep NC 1923-12-03 1925-03-03   Democrat 2                        
18726 18726 Robert La Follette L000004 sen WI 1923-12-03 1925-12-31 1 Republican                          
18728 18728 Oscar Larson L000104 rep MN 1923-12-03 1925-03-03   Republican 8                        
18729 18729 Robert Leach L000171 rep MA 1923-12-03 1925-03-03   Republican 15                        
18730 18730 Thomas Lilly L000311 rep WV 1923-12-03 1925-03-03   Democrat 5                        
18734 18734 Edward Little L000349 rep KS 1923-12-03 1925-03-03   Republican 2                        
18743 18743 Henry Lodge L000393 sen MA 1923-12-03 1924-11-09 1 Republican                          
18745 18745 William Logan L000406 rep SC 1923-12-03 1925-03-03   Democrat 1                        
18747 18747 James MacLafferty M000028 rep CA 1923-12-03 1925-03-03   Republican 6                        
18748 18748 Earle Mayfield M000281 sen TX 1923-12-03 1929-03-03 1 Democrat                          
18755 18755 John McKenzie M000506 rep IL 1923-12-03 1925-03-03   Republican 13                        
18758 18758 George McLean M000547 sen CT 1923-12-03 1929-03-03 1 Republican                          
18759 18759 Frank McNulty M000588 rep NJ 1923-12-03 1925-03-03   Democrat 8                        
18760 18760 Edward Miller M000723 rep IL 1923-12-03 1925-03-03   Republican 22                        
18762 18762 Daniel Minahan M000789 rep NJ 1923-12-03 1925-03-03   Democrat 9                        
18764 18764 Allen Moore M000890 rep IL 1923-12-03 1925-03-03   Republican 19                        
18765 18765 Robert Moore M000914 rep GA 1923-12-03 1925-03-03   Democrat 1                        
18770 18770 Merrill Moores M000928 rep IN 1923-12-03 1925-03-03   Republican 7                        
18771 18771 Joseph Morris M000981 rep KY 1923-12-03 1925-03-03   Democrat 7                        
18778 18778 Luther Mott M001041 rep NY 1923-12-03 1925-03-03   Republican 32                        
18783 18783 Sydney Mudd M001060 rep MD 1923-12-03 1925-03-03   Republican 5                        
18785 18785 Mae Nolan N000125 rep CA 1923-12-03 1925-03-03   Republican 5                        
18787 18787 Charles O’Brien O000008 rep NJ 1923-12-03 1925-03-03   Democrat 12                        
18788 18788 Patrick O’Sullivan O000123 rep CT 1923-12-03 1925-03-03   Democrat 5                        
18792 18792 Henry Osborne O000112 rep CA 1923-12-03 1925-03-03   Republican -1                        
18798 18798 Calvin Paige P000024 rep MA 1923-12-03 1925-03-03   Republican 3                        
18804 18804 Frank Park P000051 rep GA 1923-12-03 1925-03-03   Democrat 2                        
18808 18808 John Rainey R000015 rep IL 1923-12-03 1925-03-03   Democrat 4                        
18809 18809 Samuel Ralston R000020 sen IN 1923-12-03 1925-12-31 1 Democrat                          
18812 18812 James Reed R000118 sen MO 1923-12-03 1929-03-03 1 Democrat                          
18816 18816 Stuart Reed R000127 rep WV 1923-12-03 1925-03-03   Republican 3                        
18817 18817 Charles Richards R000211 rep NV 1923-12-03 1925-03-03   Democrat 0                        
18828 18828 Daniel Riordan R000264 rep NY 1923-12-03 1925-03-03   Democrat 11                        
18830 18830 Sidney Roach R000289 rep MO 1923-12-03 1925-03-03   Republican 8                        
18832 18832 Benjamin Rosenbloom R000441 rep WV 1923-12-03 1925-03-03   Republican 1                        
18833 18833 William Salmon S000019 rep TN 1923-12-03 1925-03-03   Democrat 7                        
18837 18837 Everett Sanders S000034 rep IN 1923-12-03 1925-03-03   Republican 5                        
18838 18838 Lewis Sawyer S000090 rep AR 1923-12-03 1925-03-03   Democrat 6                        
18847 18847 Isaac Sherwood S000355 rep OH 1923-12-03 1925-03-03   Democrat 9                        
18848 18848 Frank Sites S000457 rep PA 1923-12-03 1925-03-03   Democrat 19                        
18855 18855 John Smith S000573 rep MI 1923-12-03 1925-03-03   Republican 3                        
18860 18860 Homer Snyder S000666 rep NY 1923-12-03 1925-03-03   Republican 33                        
18861 18861 Charles Stengle S000850 rep NY 1923-12-03 1925-03-03   Democrat 6                        
18866 18866 Peter Tague T000014 rep MA 1923-12-03 1925-03-03   Democrat 10                        
18873 18873 Horace Towner T000325 rep IA 1923-12-03 1925-03-03   Republican 8                        
18875 18875 John Tyson T000455 rep AL 1923-12-03 1925-03-03   Democrat 2                        
18880 18880 Charles Ward W000129 rep NY 1923-12-03 1925-03-03   Republican 27                        
18882 18882 Hallett Ward W000132 rep NC 1923-12-03 1925-03-03   Democrat 1                        
18883 18883 Elton Watkins W000191 rep OR 1923-12-03 1925-03-03   Democrat 3                        
18886 18886 John Webster W000240 rep WA 1923-12-03 1925-03-03   Republican 5                        
18887 18887 George Wertz W000300 rep PA 1923-12-03 1925-03-03   Republican 20                        
18888 18888 William Wilson W000621 rep IN 1923-12-03 1925-03-03   Democrat 1                        
18894 18894 Samuel Winslow W000639 rep MA 1923-12-03 1925-03-03   Republican 4                        
18899 18899 James Wise W000650 rep GA 1923-12-03 1925-03-03   Democrat 6                        
18900 18900 Joseph Wolff W000679 rep MO 1923-12-03 1925-03-03   Democrat 13                        
18906 18906 George Young Y000036 rep ND 1923-12-03 1925-03-03   Republican 2                        
18912 18912 Harris Bixler B000493 rep PA 1923-12-03 1925-03-03   Republican 28                        
18924 18924 Charles Carter C000196 rep OK 1923-12-03 1925-03-03   Democrat 3                        
18929 18929 William Cleary C000500 rep NY 1923-12-03 1925-03-03   Democrat 8                        
18937 18937 Benjamin Fairchild F000004 rep NY 1923-12-03 1925-03-03   Republican 24                        
18943 18943 John Fredericks F000358 rep CA 1923-12-03 1925-03-03   Republican 10                        
18954 18954 Charles Fuller F000407 rep IL 1923-12-03 1925-03-03   Republican 12                        
18957 18957 Frank Funk 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, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);