legislator_terms

Table actions

496 rows where "start" is on date 1917-04-02

✎ 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
17053 17053 William Adamson A000051 rep GA 1917-04-02 1919-03-03   Democrat 4                        
17058 17058 Richard Austin A000341 rep TN 1917-04-02 1919-03-03   Republican 2                        
17059 17059 Mark Bacon B000018 rep MI 1917-04-02 1919-03-03   Republican 2                        
17065 17065 Henry Barnhart B000164 rep IN 1917-04-02 1919-03-03   Democrat 13                        
17068 17068 Elsworth Bathrick B000240 rep OH 1917-04-02 1919-03-03   Democrat 14                        
17071 17071 Samuel Beakes B000264 rep MI 1917-04-02 1919-03-03   Democrat 2                        
17072 17072 Earl Beshlin B000421 rep PA 1917-04-02 1919-03-03   Democrat 28                        
17073 17073 William Birch B000476 rep NJ 1917-04-02 1919-03-03   Republican 5                        
17074 17074 Orrin Bleakley B000552 rep PA 1917-04-02 1919-03-03   Republican 28                        
17079 17079 William Borland B000643 rep MO 1917-04-02 1919-03-03   Democrat 5                        
17081 17081 James Britt B000846 rep NC 1917-04-02 1919-03-03   Republican 10                        
17083 17083 Andrew Brodbeck B000855 rep PA 1917-04-02 1919-03-03   Democrat 20                        
17086 17086 Henry Bruckner B000974 rep NY 1917-04-02 1919-03-03   Democrat 22                        
17092 17092 William Calder C000025 sen NY 1917-04-02 1923-03-03 1 Republican                          
17094 17094 John Capstick C000136 rep NJ 1917-04-02 1919-03-03   Republican 5                        
17096 17096 William Carter C000205 rep MA 1917-04-02 1919-03-03   Republican 13                        
17102 17102 William Cary C000218 rep WI 1917-04-02 1919-03-03   Republican 4                        
17103 17103 Henry Clark C000433 rep PA 1917-04-02 1919-03-03   Republican 25                        
17106 17106 Horatio Claypool C000490 rep OH 1917-04-02 1919-03-03   Democrat 11                        
17107 17107 Daniel Comstock C000663 rep IN 1917-04-02 1919-03-03   Republican 6                        
17110 17110 John Connelly C000689 rep KS 1917-04-02 1919-03-03   Democrat 6                        
17115 17115 Michael Conry C000707 rep NY 1917-04-02 1919-03-03   Democrat -1                        
17117 17117 Edward Cooper C000748 rep WV 1917-04-02 1919-03-03   Republican 5                        
17123 17123 William Cox C000840 rep IN 1917-04-02 1919-03-03   Democrat 3                        
17127 17127 Charles Culberson C000963 sen TX 1917-04-02 1923-03-03 1 Democrat                          
17130 17130 Harry Dale D000008 rep NY 1917-04-02 1919-03-03   Democrat 4                        
17139 17139 James Davidson D000084 rep WI 1917-04-02 1919-03-03   Republican 6                        
17142 17142 Perl Decker D000184 rep MO 1917-04-02 1919-03-03   Democrat 15                        
17143 17143 George Denton D000258 rep IN 1917-04-02 1919-03-03   Democrat 1                        
17148 17148 Martin Dies D000337 rep TX 1917-04-02 1919-03-03   Democrat 2                        
17151 17151 Charles Dillon D000348 rep SD 1917-04-02 1919-03-03   Republican 1                        
17158 17158 Lincoln Dixon D000374 rep IN 1917-04-02 1919-03-03   Democrat 4                        
17161 17161 Dudley Doolittle D000427 rep KS 1917-04-02 1919-03-03   Democrat 4                        
17164 17164 Dow Drukker D000505 rep NJ 1917-04-02 1919-03-03   Republican 7                        
17165 17165 Frederick Essen E000219 rep MO 1917-04-02 1919-03-03   Republican 10                        
17171 17171 George Fairchild F000005 rep NY 1917-04-02 1919-03-03   Republican 34                        
17181 17181 David Finley F000131 rep SC 1917-04-02 1919-03-03   Democrat -1                        
17191 17191 John Fitzgerald F000165 rep NY 1917-04-02 1919-03-03   Democrat 7                        
17193 17193 Joseph Flynn F000228 rep NY 1917-04-02 1919-03-03   Democrat 3                        
17204 17204 George Foss F000295 rep IL 1917-04-02 1919-03-03   Republican 10                        
17210 17210 Martin Foster F000309 rep IL 1917-04-02 1919-03-03   Democrat 23                        
17211 17211 Joseph France F000333 sen MD 1917-04-02 1923-03-03 1 Republican                          
17212 17212 George Francis F000335 rep NY 1917-04-02 1919-03-03   Republican 18                        
17213 17213 Joseph Frelinghuysen F000370 sen NJ 1917-04-02 1923-03-03 1 Republican                          
17222 17222 Augustus Gardner G000050 rep MA 1917-04-02 1919-03-03   Republican 6                        
17225 17225 William Gordon G000317 rep OH 1917-04-02 1919-03-03   Democrat 20                        
17227 17227 Edward Gray G000393 rep NJ 1917-04-02 1919-03-03   Republican 8                        
17229 17229 Oscar Gray G000401 rep AL 1917-04-02 1919-03-03   Democrat 1                        
17237 17237 Alexander Gregg G000441 rep TX 1917-04-02 1919-03-03   Democrat 7                        
17240 17240 Daniel Griffin G000460 rep NY 1917-04-02 1919-03-03   Democrat 8                        
17243 17243 Charles Hamilton H000104 rep NY 1917-04-02 1919-03-03   Republican 43                        
17250 17250 Courtney Hamlin H000119 rep MO 1917-04-02 1919-03-03   Democrat 7                        
17257 17257 Everis Hayes H000389 rep CA 1917-04-02 1919-03-03   Republican 8                        
17259 17259 Robert Heaton H000433 rep PA 1917-04-02 1919-03-03   Republican 12                        
17260 17260 Victor Heintz H000455 rep OH 1917-04-02 1919-03-03   Republican 2                        
17264 17264 Henry Helgesen H000459 rep ND 1917-04-02 1919-03-03   Republican 1                        
17267 17267 Guy Helvering H000466 rep KS 1917-04-02 1919-03-03   Democrat 5                        
17271 17271 Walter Hensley H000522 rep MO 1917-04-02 1919-03-03   Democrat 13                        
17282 17282 Ebenezer Hill H000591 rep CT 1917-04-02 1919-03-03   Republican 4                        
17284 17284 Benjamin Hilliard H000620 rep CO 1917-04-02 1919-03-03   Democrat 1                        
17289 17289 Gilbert Hitchcock H000645 sen NE 1917-04-02 1923-03-03 1 Democrat                          
17292 17292 David Hollingsworth H000726 rep OH 1917-04-02 1919-03-03   Republican 18                        
17294 17294 George Hood H000755 rep NC 1917-04-02 1919-03-03   Democrat 3                        
17301 17301 William Houston H000829 rep TN 1917-04-02 1919-03-03   Democrat 5                        
17305 17305 William Howard H000849 rep GA 1917-04-02 1919-03-03   Democrat 5                        
17307 17307 George Hulbert H000934 rep NY 1917-04-02 1919-03-03   Democrat 21                        
17321 17321 William Jones J000259 rep VA 1917-04-02 1919-03-03   Democrat 1                        
17324 17324 Edward Keating K000035 rep CO 1917-04-02 1919-03-03   Democrat 3                        
17325 17325 James Kehoe K000046 rep FL 1917-04-02 1919-03-03   Democrat 3                        
17326 17326 Frank Kellogg K000065 sen MN 1917-04-02 1923-03-03 1 Republican                          
17329 17329 John Key K000157 rep OH 1917-04-02 1919-03-03   Democrat 8                        
17332 17332 Philander Knox K000296 sen PA 1917-04-02 1921-12-31 1 Republican                          
17336 17336 William La Follette L000006 rep WA 1917-04-02 1919-03-03   Republican 4                        
17339 17339 Adam Littlepage L000358 rep WV 1917-04-02 1919-03-03   Democrat 6                        
17343 17343 Charles Lobeck L000385 rep NE 1917-04-02 1919-03-03   Democrat 2                        
17344 17344 George Lunn L000518 rep NY 1917-04-02 1919-03-03   Democrat 30                        
17345 17345 Charles Martin M000170 rep IL 1917-04-02 1919-03-03   Democrat 4                        
17349 17349 Porter McCumber M000397 sen ND 1917-04-02 1923-03-03 1 Republican                          
17351 17351 Atkins McLemore M000554 rep TX 1917-04-02 1919-03-03   Democrat -1                        
17353 17353 Jacob Meeker M000629 rep MO 1917-04-02 1919-03-03   Republican 10                        
17358 17358 Clarence Miller M000717 rep MN 1917-04-02 1919-03-03   Republican 8                        
17360 17360 Henry Myers M001129 sen MT 1917-04-02 1923-03-03 1 Democrat                          
17361 17361 Harry New N000059 sen IN 1917-04-02 1923-03-03 1 Republican                          
17364 17364 Patrick Norton N000156 rep ND 1917-04-02 1919-03-03   Republican 3                        
17368 17368 George O’Shaunessy O000117 rep RI 1917-04-02 1919-03-03   Democrat 1                        
17369 17369 Daniel Oliver O000071 rep NY 1917-04-02 1919-03-03   Democrat 23                        
17371 17371 Arthur Overmyer O000141 rep OH 1917-04-02 1919-03-03   Democrat 13                        
17374 17374 Carroll Page P000014 sen VT 1917-04-02 1923-03-03 1 Republican                          
17377 17377 Miles Poindexter P000403 sen WA 1917-04-02 1923-03-03 1 Republican                          
17378 17378 Albert Polk P000407 rep DE 1917-04-02 1919-03-03   Democrat 0                        
17380 17380 Atlee Pomerene P000420 sen OH 1917-04-02 1923-03-03 1 Democrat                          
17384 17384 Caleb Powers P000487 rep KY 1917-04-02 1919-03-03   Republican 11                        
17386 17386 Harry Pratt P000500 rep NY 1917-04-02 1919-03-03   Republican 37                        
17389 17389 Jesse Price P000527 rep MD 1917-04-02 1919-03-03   Democrat 1                        
17393 17393 Edwin Roberts R000309 rep NV 1917-04-02 1919-03-03   Republican 0                        
17395 17395 Charles Rowland R000480 rep PA 1917-04-02 1919-03-03   Republican 21                        
17400 17400 Joseph Russell R000533 rep MO 1917-04-02 1919-03-03   Democrat 14                        
17403 17403 George Scott S000170 rep IA 1917-04-02 1919-03-03   Republican 11                        
17405 17405 John Scott S000180 rep PA 1917-04-02 1919-03-03   Republican -1                        
17415 17415 Dorsey Shackleford S000274 rep MO 1917-04-02 1919-03-03   Democrat 8                        

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