legislator_terms

Table actions

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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: type, 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
17054 17054 William Adamson A000051 rep GA 1917-04-02 1919-03-03   Democrat 4                        
17059 17059 Richard Austin A000341 rep TN 1917-04-02 1919-03-03   Republican 2                        
17060 17060 Mark Bacon B000018 rep MI 1917-04-02 1919-03-03   Republican 2                        
17066 17066 Henry Barnhart B000164 rep IN 1917-04-02 1919-03-03   Democrat 13                        
17069 17069 Elsworth Bathrick B000240 rep OH 1917-04-02 1919-03-03   Democrat 14                        
17072 17072 Samuel Beakes B000264 rep MI 1917-04-02 1919-03-03   Democrat 2                        
17073 17073 Earl Beshlin B000421 rep PA 1917-04-02 1919-03-03   Democrat 28                        
17074 17074 William Birch B000476 rep NJ 1917-04-02 1919-03-03   Republican 5                        
17075 17075 Orrin Bleakley B000552 rep PA 1917-04-02 1919-03-03   Republican 28                        
17080 17080 William Borland B000643 rep MO 1917-04-02 1919-03-03   Democrat 5                        
17082 17082 James Britt B000846 rep NC 1917-04-02 1919-03-03   Republican 10                        
17084 17084 Andrew Brodbeck B000855 rep PA 1917-04-02 1919-03-03   Democrat 20                        
17087 17087 Henry Bruckner B000974 rep NY 1917-04-02 1919-03-03   Democrat 22                        
17093 17093 William Calder C000025 sen NY 1917-04-02 1923-03-03 1 Republican                          
17095 17095 John Capstick C000136 rep NJ 1917-04-02 1919-03-03   Republican 5                        
17097 17097 William Carter C000205 rep MA 1917-04-02 1919-03-03   Republican 13                        
17103 17103 William Cary C000218 rep WI 1917-04-02 1919-03-03   Republican 4                        
17104 17104 Henry Clark C000433 rep PA 1917-04-02 1919-03-03   Republican 25                        
17107 17107 Horatio Claypool C000490 rep OH 1917-04-02 1919-03-03   Democrat 11                        
17108 17108 Daniel Comstock C000663 rep IN 1917-04-02 1919-03-03   Republican 6                        
17111 17111 John Connelly C000689 rep KS 1917-04-02 1919-03-03   Democrat 6                        
17116 17116 Michael Conry C000707 rep NY 1917-04-02 1919-03-03   Democrat -1                        
17118 17118 Edward Cooper C000748 rep WV 1917-04-02 1919-03-03   Republican 5                        
17124 17124 William Cox C000840 rep IN 1917-04-02 1919-03-03   Democrat 3                        
17128 17128 Charles Culberson C000963 sen TX 1917-04-02 1923-03-03 1 Democrat                          
17131 17131 Harry Dale D000008 rep NY 1917-04-02 1919-03-03   Democrat 4                        
17140 17140 James Davidson D000084 rep WI 1917-04-02 1919-03-03   Republican 6                        
17143 17143 Perl Decker D000184 rep MO 1917-04-02 1919-03-03   Democrat 15                        
17144 17144 George Denton D000258 rep IN 1917-04-02 1919-03-03   Democrat 1                        
17149 17149 Martin Dies D000337 rep TX 1917-04-02 1919-03-03   Democrat 2                        
17152 17152 Charles Dillon D000348 rep SD 1917-04-02 1919-03-03   Republican 1                        
17159 17159 Lincoln Dixon D000374 rep IN 1917-04-02 1919-03-03   Democrat 4                        
17162 17162 Dudley Doolittle D000427 rep KS 1917-04-02 1919-03-03   Democrat 4                        
17165 17165 Dow Drukker D000505 rep NJ 1917-04-02 1919-03-03   Republican 7                        
17166 17166 Frederick Essen E000219 rep MO 1917-04-02 1919-03-03   Republican 10                        
17172 17172 George Fairchild F000005 rep NY 1917-04-02 1919-03-03   Republican 34                        
17182 17182 David Finley F000131 rep SC 1917-04-02 1919-03-03   Democrat -1                        
17192 17192 John Fitzgerald F000165 rep NY 1917-04-02 1919-03-03   Democrat 7                        
17194 17194 Joseph Flynn F000228 rep NY 1917-04-02 1919-03-03   Democrat 3                        
17205 17205 George Foss F000295 rep IL 1917-04-02 1919-03-03   Republican 10                        
17211 17211 Martin Foster F000309 rep IL 1917-04-02 1919-03-03   Democrat 23                        
17212 17212 Joseph France F000333 sen MD 1917-04-02 1923-03-03 1 Republican                          
17213 17213 George Francis F000335 rep NY 1917-04-02 1919-03-03   Republican 18                        
17214 17214 Joseph Frelinghuysen F000370 sen NJ 1917-04-02 1923-03-03 1 Republican                          
17223 17223 Augustus Gardner G000050 rep MA 1917-04-02 1919-03-03   Republican 6                        
17226 17226 William Gordon G000317 rep OH 1917-04-02 1919-03-03   Democrat 20                        
17228 17228 Edward Gray G000393 rep NJ 1917-04-02 1919-03-03   Republican 8                        
17230 17230 Oscar Gray G000401 rep AL 1917-04-02 1919-03-03   Democrat 1                        
17238 17238 Alexander Gregg G000441 rep TX 1917-04-02 1919-03-03   Democrat 7                        
17241 17241 Daniel Griffin G000460 rep NY 1917-04-02 1919-03-03   Democrat 8                        
17244 17244 Charles Hamilton H000104 rep NY 1917-04-02 1919-03-03   Republican 43                        
17251 17251 Courtney Hamlin H000119 rep MO 1917-04-02 1919-03-03   Democrat 7                        
17258 17258 Everis Hayes H000389 rep CA 1917-04-02 1919-03-03   Republican 8                        
17260 17260 Robert Heaton H000433 rep PA 1917-04-02 1919-03-03   Republican 12                        
17261 17261 Victor Heintz H000455 rep OH 1917-04-02 1919-03-03   Republican 2                        
17265 17265 Henry Helgesen H000459 rep ND 1917-04-02 1919-03-03   Republican 1                        
17268 17268 Guy Helvering H000466 rep KS 1917-04-02 1919-03-03   Democrat 5                        
17272 17272 Walter Hensley H000522 rep MO 1917-04-02 1919-03-03   Democrat 13                        
17283 17283 Ebenezer Hill H000591 rep CT 1917-04-02 1919-03-03   Republican 4                        
17285 17285 Benjamin Hilliard H000620 rep CO 1917-04-02 1919-03-03   Democrat 1                        
17290 17290 Gilbert Hitchcock H000645 sen NE 1917-04-02 1923-03-03 1 Democrat                          
17293 17293 David Hollingsworth H000726 rep OH 1917-04-02 1919-03-03   Republican 18                        
17295 17295 George Hood H000755 rep NC 1917-04-02 1919-03-03   Democrat 3                        
17302 17302 William Houston H000829 rep TN 1917-04-02 1919-03-03   Democrat 5                        
17306 17306 William Howard H000849 rep GA 1917-04-02 1919-03-03   Democrat 5                        
17308 17308 George Hulbert H000934 rep NY 1917-04-02 1919-03-03   Democrat 21                        
17322 17322 William Jones J000259 rep VA 1917-04-02 1919-03-03   Democrat 1                        
17325 17325 Edward Keating K000035 rep CO 1917-04-02 1919-03-03   Democrat 3                        
17326 17326 James Kehoe K000046 rep FL 1917-04-02 1919-03-03   Democrat 3                        
17327 17327 Frank Kellogg K000065 sen MN 1917-04-02 1923-03-03 1 Republican                          
17330 17330 John Key K000157 rep OH 1917-04-02 1919-03-03   Democrat 8                        
17333 17333 Philander Knox K000296 sen PA 1917-04-02 1921-12-31 1 Republican                          
17337 17337 William La Follette L000006 rep WA 1917-04-02 1919-03-03   Republican 4                        
17340 17340 Adam Littlepage L000358 rep WV 1917-04-02 1919-03-03   Democrat 6                        
17344 17344 Charles Lobeck L000385 rep NE 1917-04-02 1919-03-03   Democrat 2                        
17345 17345 George Lunn L000518 rep NY 1917-04-02 1919-03-03   Democrat 30                        
17346 17346 Charles Martin M000170 rep IL 1917-04-02 1919-03-03   Democrat 4                        
17350 17350 Porter McCumber M000397 sen ND 1917-04-02 1923-03-03 1 Republican                          
17352 17352 Atkins McLemore M000554 rep TX 1917-04-02 1919-03-03   Democrat -1                        
17354 17354 Jacob Meeker M000629 rep MO 1917-04-02 1919-03-03   Republican 10                        
17359 17359 Clarence Miller M000717 rep MN 1917-04-02 1919-03-03   Republican 8                        
17361 17361 Henry Myers M001129 sen MT 1917-04-02 1923-03-03 1 Democrat                          
17362 17362 Harry New N000059 sen IN 1917-04-02 1923-03-03 1 Republican                          
17365 17365 Patrick Norton N000156 rep ND 1917-04-02 1919-03-03   Republican 3                        
17369 17369 George O’Shaunessy O000117 rep RI 1917-04-02 1919-03-03   Democrat 1                        
17370 17370 Daniel Oliver O000071 rep NY 1917-04-02 1919-03-03   Democrat 23                        
17372 17372 Arthur Overmyer O000141 rep OH 1917-04-02 1919-03-03   Democrat 13                        
17375 17375 Carroll Page P000014 sen VT 1917-04-02 1923-03-03 1 Republican                          
17378 17378 Miles Poindexter P000403 sen WA 1917-04-02 1923-03-03 1 Republican                          
17379 17379 Albert Polk P000407 rep DE 1917-04-02 1919-03-03   Democrat 0                        
17381 17381 Atlee Pomerene P000420 sen OH 1917-04-02 1923-03-03 1 Democrat                          
17385 17385 Caleb Powers P000487 rep KY 1917-04-02 1919-03-03   Republican 11                        
17387 17387 Harry Pratt P000500 rep NY 1917-04-02 1919-03-03   Republican 37                        
17390 17390 Jesse Price P000527 rep MD 1917-04-02 1919-03-03   Democrat 1                        
17394 17394 Edwin Roberts R000309 rep NV 1917-04-02 1919-03-03   Republican 0                        
17396 17396 Charles Rowland R000480 rep PA 1917-04-02 1919-03-03   Republican 21                        
17401 17401 Joseph Russell R000533 rep MO 1917-04-02 1919-03-03   Democrat 14                        
17404 17404 George Scott S000170 rep IA 1917-04-02 1919-03-03   Republican 11                        
17406 17406 John Scott S000180 rep PA 1917-04-02 1919-03-03   Republican -1                        
17416 17416 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, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);