legislator_terms

Table actions

484 rows where "start" is on date 1959-01-07

✎ View and edit SQL

This data as json, CSV (advanced)

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
26704 26704 Leo Allen A000138 rep IL 1959-01-07 1961-01-03   Republican 16                        
26706 26706 LeRoy Anderson A000200 rep MT 1959-01-07 1961-01-03   Democrat 2                        
26719 26719 Graham Barden B000139 rep NC 1959-01-07 1961-01-03   Democrat 3                        
26720 26720 Joseph Barr B000170 rep IN 1959-01-07 1961-01-03   Democrat 11                        
26724 26724 Albert Baumhart B000245 rep OH 1959-01-07 1961-01-03   Republican 13                        
26731 26731 James Beall B000271 sen MD 1959-01-07 1965-01-03 1 Republican                          
26735 26735 Alvin Bentley B000391 rep MI 1959-01-07 1961-01-03   Republican 8                        
26739 26739 Albert Bosch B000646 rep NY 1959-01-07 1961-01-03   Republican 5                        
26740 26740 Chester Bowles B000699 rep CT 1959-01-07 1961-01-03   Democrat 2                        
26743 26743 Charles Boyle B000727 rep IL 1959-01-07 1961-01-03   Democrat 12                        
26744 26744 Lawrence Brock B000849 rep NE 1959-01-07 1961-01-03   Democrat 3                        
26746 26746 Charles Brown B000908 rep MO 1959-01-07 1961-01-03   Democrat 7                        
26760 26760 Paul Brown B000940 rep GA 1959-01-07 1961-01-03   Democrat 10                        
26766 26766 Hamer Budge B001035 rep ID 1959-01-07 1961-01-03   Republican 2                        
26768 26768 John Burns B001127 rep HI 1959-01-07 1961-01-03   Democrat 0                        
26773 26773 Alvin Bush B001165 rep PA 1959-01-07 1961-01-03   Republican 17                        
26779 26779 Harry Byrd B001208 sen VA 1959-01-07 1965-01-03 1 Democrat                          
26790 26790 Gordon Canfield C000113 rep NJ 1959-01-07 1961-01-03   Republican 8                        
26797 26797 Albert Carnahan C000162 rep MO 1959-01-07 1961-01-03   Democrat 8                        
26798 26798 Steven Carter C000199 rep IA 1959-01-07 1961-01-03   Democrat 4                        
26805 26805 Dennis Chavez C000338 sen NM 1959-01-07 1962-11-18 1 Democrat                          
26809 26809 George Christopher C000383 rep MO 1959-01-07 1961-01-03   Democrat 4                        
26811 26811 Frank Coffin C000589 rep ME 1959-01-07 1961-01-03   Democrat 2                        
26814 26814 Henry Dixon D000368 rep UT 1959-01-07 1961-01-03   Republican 1                        
26820 26820 Isidore Dollinger D000402 rep NY 1959-01-07 1961-01-03   Democrat 23                        
26824 26824 Francis Dorn D000433 rep NY 1959-01-07 1961-01-03   Republican 12                        
26835 26835 Carl Durham D000571 rep NC 1959-01-07 1961-01-03   Democrat 6                        
26836 26836 Douglas Elliott E000121 rep PA 1959-01-07 1961-01-03   Republican 18                        
26845 26845 Clair Engle E000181 sen CA 1959-01-07 1965-01-03 1 Democrat                          
26846 26846 Gerald Flynn F000227 rep WI 1959-01-07 1961-01-03   Democrat 1                        
26847 26847 John Foley F000237 rep MD 1959-01-07 1961-01-03   Democrat 6                        
26858 26858 Aime Forand F000255 rep RI 1959-01-07 1961-01-03   Democrat 1                        
26859 26859 Newell George G000130 rep KS 1959-01-07 1961-01-03   Democrat 2                        
26860 26860 David Hall H000048 rep NC 1959-01-07 1961-01-03   Democrat 12                        
26861 26861 Denver Hargis H000204 rep KS 1959-01-07 1961-01-03   Democrat 3                        
26862 26862 Randall Harmon H000216 rep IN 1959-01-07 1961-01-03   Democrat 10                        
26865 26865 John Henderson H000484 rep OH 1959-01-07 1961-01-03   Republican 15                        
26879 26879 William Hess H000550 rep OH 1959-01-07 1961-01-03   Republican 2                        
26880 26880 Earl Hogan H000690 rep IN 1959-01-07 1961-01-03   Democrat 9                        
26884 26884 Joseph Holt H000746 rep CA 1959-01-07 1961-01-03   Republican 22                        
26891 26891 Donald Jackson J000008 rep CA 1959-01-07 1961-01-03   Republican 16                        
26892 26892 Byron Johnson J000119 rep CO 1959-01-07 1961-01-03   Democrat 2                        
26893 26893 George Kasem K000015 rep CA 1959-01-07 1961-01-03   Democrat 25                        
26900 26900 Kenneth Keating K000036 sen NY 1959-01-07 1965-01-03 1 Republican                          
26902 26902 John Lafore L000018 rep PA 1959-01-07 1961-01-03   Republican 13                        
26903 26903 Robert Levering L000260 rep OH 1959-01-07 1961-01-03   Democrat 17                        
26904 26904 Oren Long L000425 sen HI 1959-01-07 1963-01-03 3 Democrat                          
26911 26911 Russell Mack M000021 rep WA 1959-01-07 1961-01-03   Republican 3                        
26912 26912 Donald McGinley M000449 rep NE 1959-01-07 1961-01-03   Democrat 4                        
26913 26913 William Meyer M000682 rep VT 1959-01-07 1961-01-03   Democrat 0                        
26914 26914 Ward Miller M000759 rep OH 1959-01-07 1961-01-03   Republican 6                        
26916 26916 Harlan Mitchell M000812 rep GA 1959-01-07 1961-01-03   Democrat 7                        
26921 26921 Toby Morris M000991 rep OK 1959-01-07 1961-01-03   Democrat 6                        
26925 26925 James Oliver O000074 rep ME 1959-01-07 1961-01-03   Democrat 1                        
26936 26936 James Polk P000408 rep OH 1959-01-07 1961-01-03   Democrat 6                        
26938 26938 Charles Porter P000439 rep OR 1959-01-07 1961-01-03   Democrat 4                        
26945 26945 Prince Preston P000516 rep GA 1959-01-07 1961-01-03   Democrat 1                        
26946 26946 Stanley Prokop P000549 rep PA 1959-01-07 1961-01-03   Democrat 10                        
26948 26948 James Quigley Q000012 rep PA 1959-01-07 1961-01-03   Democrat 19                        
26969 26969 Daniel Reed R000113 rep NY 1959-01-07 1961-01-03   Republican 43                        
26981 26981 Edward Rees R000132 rep KS 1959-01-07 1961-01-03   Republican 4                        
26999 26999 Edith Rogers R000392 rep MA 1959-01-07 1961-01-03   Republican 5                        
27000 27000 Edna Simpson S000430 rep IL 1959-01-07 1961-01-03   Republican 20                        
27012 27012 Richard Simpson S000436 rep PA 1959-01-07 1961-01-03   Republican 18                        
27019 27019 Wint Smith S000640 rep KS 1959-01-07 1961-01-03   Republican 6                        
27028 27028 Dean Taylor T000070 rep NY 1959-01-07 1961-01-03   Republican 31                        
27030 27030 Ludwig Teller T000118 rep NY 1959-01-07 1961-01-03   Democrat 20                        
27033 27033 Edwin Thomson T000229 rep WY 1959-01-07 1961-01-03   Republican 0                        
27037 27037 Stuyvesant Wainwright W000024 rep NY 1959-01-07 1961-01-03   Republican 1                        
27038 27038 Fred Wampler W000120 rep IN 1959-01-07 1961-01-03   Democrat 6                        
27044 27044 Roy Wier W000446 rep MN 1959-01-07 1961-01-03   Democrat 3                        
27054 27054 Gardner Withrow W000663 rep WI 1959-01-07 1961-01-03   Republican 3                        
27055 27055 Leonard Wolf W000675 rep IA 1959-01-07 1961-01-03   Democrat 2                        
27065 27065 Hugh Addonizio A000054 rep NJ 1959-01-07 1961-01-03   Democrat 11                        
27070 27070 Hugh Alexander A000094 rep NC 1959-01-07 1961-01-03   Democrat 9                        
27072 27072 Thomas Alford A000105 rep AR 1959-01-07 1961-01-03   Ind. Democrat 5                        
27084 27084 Herman Andersen A000179 rep MN 1959-01-07 1961-01-03   Republican 7                        
27089 27089 Victor Anfuso A000255 rep NY 1959-01-07 1961-01-03   Democrat 8                        
27097 27097 Cleveland Bailey B000035 rep WV 1959-01-07 1961-01-03   Democrat 3                        
27101 27101 Perkins Bass B000222 rep NH 1959-01-07 1961-01-03   Republican 2                        
27107 27107 Iris Blitch B000561 rep GA 1959-01-07 1961-01-03   Democrat 8                        
27121 27121 Frank Boykin B000725 rep AL 1959-01-07 1961-01-03   Democrat 1                        
27124 27124 James Breeding B000791 rep KS 1959-01-07 1961-01-03   Democrat 5                        
27137 27137 Overton Brooks B000884 rep LA 1959-01-07 1961-01-03   Democrat 4                        
27139 27139 Frank Burke B001090 rep KY 1959-01-07 1961-01-03   Democrat 3                        
27151 27151 Robert Chiperfield C000365 rep IL 1959-01-07 1961-01-03   Republican 19                        
27157 27157 Marguerite Church C000389 rep IL 1959-01-07 1961-01-03   Republican 13                        
27160 27160 Merwin Coad C000540 rep IA 1959-01-07 1961-01-03   Democrat 6                        
27162 27162 Robert Cook C000725 rep OH 1959-01-07 1961-01-03   Democrat 11                        
27167 27167 Laurence Curtis C001011 rep MA 1959-01-07 1961-01-03   Republican 10                        
27175 27175 James Davis D000109 rep GA 1959-01-07 1961-01-03   Democrat 5                        
27178 27178 Edwin Dooley D000425 rep NY 1959-01-07 1961-01-03   Republican 26                        
27201 27201 Ivor Fenton F000075 rep PA 1959-01-07 1961-01-03   Republican 12                        
27208 27208 James Frazier F000353 rep TN 1959-01-07 1961-01-03   Democrat 3                        
27213 27213 Kathryn Granahan G000368 rep PA 1959-01-07 1961-01-03   Democrat 2                        
27222 27222 Burr Harrison H000264 rep VA 1959-01-07 1961-01-03   Democrat 7                        
27228 27228 Edgar Hiestand H000568 rep CA 1959-01-07 1961-01-03   Republican 21                        
27242 27242 Clare Hoffman H000683 rep MI 1959-01-07 1961-01-03   Republican 4                        
27247 27247 Lester Holtzman H000753 rep NY 1959-01-07 1961-01-03   Democrat 6                        
27253 27253 Frank Ikard I000007 rep TX 1959-01-07 1961-01-03   Democrat 13                        

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