legislator_terms

Table actions

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

481 rows where "start" is on date 1915-12-06

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: end, 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
16663 16663 John Abercrombie A000013 rep AL 1915-12-06 1917-03-03   Democrat -1                        
16668 16668 John Adair A000027 rep IN 1915-12-06 1917-03-03   Democrat 8                        
16675 16675 Wyatt Aiken A000064 rep SC 1915-12-06 1917-03-03   Democrat 3                        
16678 16678 Alfred Allen A000111 rep OH 1915-12-06 1917-03-03   Democrat 2                        
16680 16680 Warren Bailey B000050 rep PA 1915-12-06 1917-03-03   Democrat 19                        
16686 16686 Andrew Barchfeld B000133 rep PA 1915-12-06 1917-03-03   Republican 32                        
16687 16687 Cyrus Beales B000269 rep PA 1915-12-06 1917-03-03   Republican 20                        
16688 16688 John Beckham B000293 sen KY 1915-12-06 1921-03-03 3 Democrat                          
16689 16689 Henry Benedict B000359 rep CA 1915-12-06 1917-03-03   Republican 10                        
16693 16693 William Bennet B000370 rep NY 1915-12-06 1917-03-03   Republican 23                        
16695 16695 James Brady B000753 sen ID 1915-12-06 1919-03-03 3 Republican                          
16705 16705 Robert Broussard B000896 sen LA 1915-12-06 1919-03-03 3 Democrat                          
16708 16708 William Brown B000949 rep WV 1915-12-06 1917-03-03   Democrat 2                        
16711 16711 Frank Buchanan B001001 rep IL 1915-12-06 1917-03-03   Democrat 7                        
16719 16719 George Burgess B001083 rep TX 1915-12-06 1917-03-03   Democrat 9                        
16722 16722 Michael Burke B001095 rep WI 1915-12-06 1917-03-03   Democrat 2                        
16725 16725 Oscar Callaway C000056 rep TX 1915-12-06 1917-03-03   Democrat 12                        
16727 16727 George Chamberlain C000277 sen OR 1915-12-06 1921-03-03 3 Democrat                          
16728 16728 William Charles C000323 rep NY 1915-12-06 1917-03-03   Republican 30                        
16731 16731 James Clarke C000463 sen AR 1915-12-06 1917-03-03 3 Democrat                          
16735 16735 Cyrus Cline C000521 rep IN 1915-12-06 1917-03-03   Democrat 12                        
16736 16736 William Coleman C000622 rep PA 1915-12-06 1917-03-03   Republican 30                        
16740 16740 William Cullop C000975 rep IN 1915-12-06 1917-03-03   Democrat 2                        
16743 16743 Henry Danforth D000029 rep NY 1915-12-06 1917-03-03   Republican 39                        
16747 16747 James Davenport D000074 rep OK 1915-12-06 1917-03-03   Democrat 1                        
16748 16748 James Davis D000110 rep TX 1915-12-06 1917-03-03   Democrat -1                        
16752 16752 Daniel Driscoll D000500 rep NY 1915-12-06 1917-03-03   Democrat 42                        
16754 16754 Manuel Earnshaw E000015 rep PI 1915-12-06 1917-03-03     0                        
16755 16755 Michael Farley F000021 rep NY 1915-12-06 1917-03-03   Democrat 14                        
16762 16762 Jacob Gallinger G000023 sen NH 1915-12-06 1919-03-03 3 Republican                          
16768 16768 Joseph Goulden G000344 rep NY 1915-12-06 1917-03-03   Democrat 23                        
16773 16773 Asle Gronna G000491 sen ND 1915-12-06 1921-03-03 3 Republican                          
16778 16778 Frank Guernsey G000517 rep ME 1915-12-06 1917-03-03   Republican 4                        
16780 16780 Archibald Hart H000283 rep NJ 1915-12-06 1917-03-03   Democrat 6                        
16790 16790 James Hay H000382 rep VA 1915-12-06 1917-03-03   Democrat 7                        
16800 16800 Robert Henry H000516 rep TX 1915-12-06 1917-03-03   Democrat 11                        
16803 16803 Asher Hinds H000630 rep ME 1915-12-06 1917-03-03   Republican 1                        
16804 16804 Robert Hopwood H000785 rep PA 1915-12-06 1917-03-03   Republican 23                        
16811 16811 Joseph Howell H000866 rep UT 1915-12-06 1917-03-03   Republican 1                        
16815 16815 Dudley Hughes H000920 rep GA 1915-12-06 1917-03-03   Democrat 12                        
16822 16822 William Humphrey H000958 rep WA 1915-12-06 1917-03-03   Republican 1                        
16823 16823 Paul Husting H001006 sen WI 1915-12-06 1917-12-31 3 Democrat                          
16824 16824 Edwin Johnson J000128 sen SD 1915-12-06 1921-03-03 3 Democrat                          
16832 16832 Joseph Johnson J000156 rep SC 1915-12-06 1917-03-03   Democrat 4                        
16834 16834 Abraham Keister K000052 rep PA 1915-12-06 1917-03-03   Republican 22                        
16837 16837 William Kent K000127 rep CA 1915-12-06 1917-03-03   Independent 1                        
16840 16840 Thomas Konop K000310 rep WI 1915-12-06 1917-03-03   Democrat 9                        
16846 16846 Daniel Lafean L000014 rep PA 1915-12-06 1917-03-03   Republican -1                        
16848 16848 Charles Lieb L000302 rep IN 1915-12-06 1917-03-03   Democrat 1                        
16849 16849 Michael Liebel L000303 rep PA 1915-12-06 1917-03-03   Democrat 25                        
16854 16854 Charles Lindbergh L000320 rep MN 1915-12-06 1917-03-03   Republican 6                        
16864 16864 James Lloyd L000380 rep MO 1915-12-06 1917-03-03   Democrat 1                        
16866 16866 George Loft L000399 rep NY 1915-12-06 1917-03-03   Democrat 13                        
16872 16872 George Loud L000449 rep MI 1915-12-06 1917-03-03   Republican 10                        
16873 16873 Nelson Matthews M000254 rep OH 1915-12-06 1917-03-03   Republican 5                        
16874 16874 Paul McCorkle M000363 rep SC 1915-12-06 1917-03-03   Democrat 5                        
16875 16875 Robert McCracken M000378 rep ID 1915-12-06 1917-03-03   Republican -1                        
16880 16880 James McDermott M000405 rep IL 1915-12-06 1917-03-03   Democrat 4                        
16883 16883 Daniel McGillicuddy M000448 rep ME 1915-12-06 1917-03-03   Democrat 2                        
16886 16886 Samuel Miller M000753 rep PA 1915-12-06 1917-03-03   Republican 28                        
16887 16887 Thomas Miller M000758 rep DE 1915-12-06 1917-03-03   Republican 0                        
16888 16888 William Mooney M000888 rep OH 1915-12-06 1917-03-03   Republican 15                        
16891 16891 Lewis Morgan M000955 rep LA 1915-12-06 1917-03-03   Democrat 6                        
16895 16895 Martin Morrison M000998 rep IN 1915-12-06 1917-03-03   Democrat 9                        
16897 16897 Hunter Moss M001034 rep WV 1915-12-06 1917-03-03   Republican 4                        
16901 16901 Ralph Moss M001037 rep IN 1915-12-06 1917-03-03   Democrat 5                        
16903 16903 William Murray M001118 rep OK 1915-12-06 1917-03-03   Democrat 4                        
16911 16911 Francis Newlands N000069 sen NV 1915-12-06 1917-12-31 3 Democrat                          
16912 16912 Solomon North N000141 rep PA 1915-12-06 1917-03-03   Republican 27                        
16913 16913 Peter Oakey O000002 rep CT 1915-12-06 1917-03-03   Republican 1                        
16915 16915 Woodson Oglesby O000049 rep NY 1915-12-06 1917-03-03   Democrat 24                        
16922 16922 Robert Page P000022 rep NC 1915-12-06 1917-03-03   Democrat 7                        
16925 16925 Thomas Patten P000109 rep NY 1915-12-06 1917-03-03   Democrat 18                        
16929 16929 Boies Penrose P000217 sen PA 1915-12-06 1921-03-03 3 Republican                          
16930 16930 James Phelan P000290 sen CA 1915-12-06 1921-03-03 3 Democrat                          
16934 16934 Manuel Quezon Q000009 rep PI 1915-12-06 1917-03-03     0                        
16939 16939 George Rauch R000070 rep IN 1915-12-06 1917-03-03   Democrat 11                        
16942 16942 Luis Rivera R000279 rep PR 1915-12-06 1917-03-03   Unionist 0                        
16951 16951 Ernest Roberts R000311 rep MA 1915-12-06 1917-03-03   Republican 9                        
16952 16952 Tinsley Rucker R000493 rep GA 1915-12-06 1917-03-03   Democrat 8                        
16953 16953 Joshua Russell R000534 rep OH 1915-12-06 1917-03-03   Republican 4                        
16955 16955 Lawrence Sherman S000348 sen IL 1915-12-06 1921-03-03 3 Republican                          
16961 16961 Benjamin Shively S000371 sen IN 1915-12-06 1917-03-03 3 Democrat                          
16963 16963 George Smith S000540 rep MN 1915-12-06 1917-03-03   Republican 5                        
16965 16965 Hoke Smith S000551 sen GA 1915-12-06 1921-03-03 3 Democrat                          
16969 16969 John Smith S000577 sen MD 1915-12-06 1921-03-03 3 Democrat                          
16979 16979 Marcus Smith S000589 sen AZ 1915-12-06 1921-03-03 3 Democrat                          
16986 16986 William Smith S000636 rep TX 1915-12-06 1917-03-03   Democrat 16                        
16997 16997 Stephen Sparkman S000702 rep FL 1915-12-06 1917-03-03   Democrat 1                        
16998 16998 Thomas Steele S000837 rep IA 1915-12-06 1917-03-03   Democrat 11                        
17008 17008 John Stephens S000858 rep TX 1915-12-06 1917-03-03   Democrat 13                        
17011 17011 William Stephens S000861 rep CA 1915-12-06 1917-03-03   Progressive 10                        
17014 17014 Claudius Stone S000954 rep IL 1915-12-06 1917-03-03   Democrat 16                        
17020 17020 William Stone S000968 sen MO 1915-12-06 1919-03-03 3 Democrat                          
17022 17022 Tom Stout S000982 rep MT 1915-12-06 1917-03-03   Democrat -1                        
17025 17025 Joseph Taggart T000011 rep KS 1915-12-06 1917-03-03   Democrat 2                        
17027 17027 Clyde Tavenner T000059 rep IL 1915-12-06 1917-03-03   Democrat 14                        
17029 17029 Charles Thomas T000160 sen CO 1915-12-06 1921-03-03 3 Democrat                          
17032 17032 Samuel Tribble T000366 rep GA 1915-12-06 1917-03-03   Democrat 8                        
17033 17033 Seward Williams W000535 rep OH 1915-12-06 1917-03-03   Republican 14                        

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