legislator_terms

Table actions

480 rows where "start" is on date 1975-01-14

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, 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
30801 30801 Bella Abzug A000018 rep NY 1975-01-14 1977-01-03   Democrat 20                        
30816 30816 Carl Albert A000073 rep OK 1975-01-14 1977-01-03   Democrat 3                        
30818 30818 James Allen A000127 sen AL 1975-01-14 1978-06-01 3 Democrat                          
30833 30833 William Barrett B000178 rep PA 1975-01-14 1977-01-03   Democrat 1                        
30836 30836 Birch Bayh B000254 sen IN 1975-01-14 1981-01-03 3 Democrat                          
30844 30844 Alphonzo Bell B000330 rep CA 1975-01-14 1977-01-03   Republican 27                        
30846 30846 Henry Bellmon B000351 sen OK 1975-01-14 1981-01-03 3 Republican                          
30848 30848 Jaime Benítez B000362 rep PR 1975-01-14 1977-01-03   Popular Democrat 0                        
30853 30853 Edward Biester B000451 rep PA 1975-01-14 1977-01-03   Republican 8                        
30862 30862 Robert Casey C000228 rep TX 1975-01-14 1977-01-03   Democrat 22                        
30866 30866 Frank Church C000388 sen ID 1975-01-14 1981-01-03 3 Democrat                          
30874 30874 Donald Clancy C000409 rep OH 1975-01-14 1977-01-03   Republican 2                        
30876 30876 John Conlan C000682 rep AZ 1975-01-14 1977-01-03   Republican 4                        
30890 30890 John Culver C000979 sen IA 1975-01-14 1981-01-03 3 Democrat                          
30899 30899 Dominick Daniels D000041 rep NJ 1975-01-14 1977-01-03   Democrat 14                        
30908 30908 Thomas Downing D000474 rep VA 1975-01-14 1977-01-03   Democrat 1                        
30914 30914 Marvin Esch E000213 rep MI 1975-01-14 1977-01-03   Republican 2                        
30919 30919 Edwin Eshleman E000214 rep PA 1975-01-14 1977-01-03   Republican 16                        
30934 30934 Joseph Evins E000273 rep TN 1975-01-14 1977-01-03   Democrat 4                        
30941 30941 Richard Fulton F000424 rep TN 1975-01-14 1977-01-03   Democrat 5                        
30943 30943 Maurice Gravel G000388 sen AK 1975-01-14 1981-01-03 3 Democrat                          
30950 30950 William Green G000420 rep PA 1975-01-14 1977-01-03   Democrat 3                        
30955 30955 Gilbert Gude G000513 rep MD 1975-01-14 1977-01-03   Republican 8                        
30967 30967 James Haley H000041 rep FL 1975-01-14 1977-01-03   Democrat 8                        
30968 30968 Tim Hall H000073 rep IL 1975-01-14 1977-01-03   Democrat 15                        
30972 30972 James Hastings H000327 rep NY 1975-01-14 1977-01-03   Republican 39                        
30973 30973 Philip Hayes H000392 rep IN 1975-01-14 1977-01-03   Democrat 8                        
30987 30987 Wayne Hays H000408 rep OH 1975-01-14 1977-01-03   Democrat 18                        
30996 30996 Kenneth Hechler H000438 rep WV 1975-01-14 1977-01-03   Democrat 4                        
31002 31002 Henry Helstoski H000465 rep NJ 1975-01-14 1977-01-03   Democrat 9                        
31010 31010 David Henderson H000479 rep NC 1975-01-14 1977-01-03   Democrat 3                        
31016 31016 Floyd Hicks H000563 rep WA 1975-01-14 1977-01-03   Democrat 6                        
31018 31018 Andrew Hinshaw H000638 rep CA 1975-01-14 1977-01-03   Republican 40                        
31019 31019 Allan Howe H000851 rep UT 1975-01-14 1977-01-03   Democrat 2                        
31026 31026 William Hungate H000965 rep MO 1975-01-14 1977-01-03   Democrat 9                        
31033 31033 J. Hutchinson H001011 rep MI 1975-01-14 1977-01-03   Republican 4                        
31051 31051 Felix Hébert H000437 rep LA 1975-01-14 1977-01-03   Democrat 1                        
31064 31064 John Jarman J000057 rep OK 1975-01-14 1977-01-03   Republican 5   [{"start": "1975-01-14", "end": "1975-01-24", "party": "Democrat"}, {"start": "1975-01-24", "end": "1977-01-03", "party": "Republican"}]                    
31072 31072 Jacob Javits J000064 sen NY 1975-01-14 1981-01-03 3 Republican                          
31079 31079 Albert Johnson J000115 rep PA 1975-01-14 1977-01-03   Republican 23                        
31094 31094 Robert Jones J000248 rep AL 1975-01-14 1977-01-03   Democrat 5                        
31103 31103 Joseph Karth K000014 rep MN 1975-01-14 1977-01-03   Democrat 4                        
31116 31116 John Kluczynski K000273 rep IL 1975-01-14 1977-01-03   Democrat 5                        
31128 31128 Phillip Landrum L000054 rep GA 1975-01-14 1977-01-03   Democrat 9                        
31130 31130 Jerry Litton L000360 rep MO 1975-01-14 1977-01-03   Democrat 6                        
31141 31141 Torbert Macdonald M000005 rep MA 1975-01-14 1977-01-03   Democrat 7                        
31158 31158 Ray Madden M000039 rep IN 1975-01-14 1977-01-03   Democrat 1                        
31169 31169 Warren Magnuson M000053 sen WA 1975-01-14 1981-01-03 3 Democrat                          
31172 31172 John McCollister M000349 rep NE 1975-01-14 1977-01-03   Republican 2                        
31177 31177 George McGovern M000452 sen SD 1975-01-14 1981-01-03 3 Democrat                          
31179 31179 Edward Mezvinsky M000686 rep IA 1975-01-14 1977-01-03   Democrat 1                        
31198 31198 Wilbur Mills M000778 rep AR 1975-01-14 1977-01-03   Democrat 2                        
31199 31199 Robert Morgan M000956 sen NC 1975-01-14 1981-01-03 3 Democrat                          
31215 31215 Thomas Morgan M000958 rep PA 1975-01-14 1977-01-03   Democrat 22                        
31223 31223 Charles Mosher M001031 rep OH 1975-01-14 1977-01-03   Republican 13                        
31226 31226 Gaylord Nelson N000033 sen WI 1975-01-14 1981-01-03 3 Democrat                          
31235 31235 James O’Hara O000055 rep MI 1975-01-14 1977-01-03   Democrat 12                        
31250 31250 Otto Passman P000098 rep LA 1975-01-14 1977-01-03   Democrat 5                        
31274 31274 John Patman P000103 rep TX 1975-01-14 1977-01-03   Democrat 1                        
31279 31279 Jerry Pettis P000272 rep CA 1975-01-14 1975-02-14   Republican 37                        
31288 31288 William Randall R000041 rep MO 1975-01-14 1977-01-03   Democrat 4                        
31294 31294 Thomas Rees R000134 rep CA 1975-01-14 1977-01-03   Democrat 23                        
31299 31299 Abraham Ribicoff R000191 sen CT 1975-01-14 1981-01-03 3 Democrat                          
31307 31307 John Roush R000467 rep IN 1975-01-14 1977-01-03   Democrat 4                        
31316 31316 Herman Schneebeli S000135 rep PA 1975-01-14 1977-01-03   Republican 17                        
31322 31322 Richard Schweiker S000159 sen PA 1975-01-14 1981-01-03 3 Republican                          
31330 31330 Garner Shriver S000388 rep KS 1975-01-14 1977-01-03   Republican 4                        
31333 31333 James Stanton S000803 rep OH 1975-01-14 1977-01-03   Democrat 20                        
31335 31335 Alan Steelman S000841 rep TX 1975-01-14 1977-01-03   Republican 5                        
31340 31340 Sam Steiger S000846 rep AZ 1975-01-14 1977-01-03   Republican 3                        
31348 31348 Robert Stephens S000860 rep GA 1975-01-14 1977-01-03   Democrat 10                        
31350 31350 Adlai Stevenson S000890 sen IL 1975-01-14 1981-01-03 3 Democrat                          
31351 31351 Richard Stone S000962 sen FL 1975-01-14 1981-01-03 3 Democrat                          
31356 31356 Williamson Stuckey S001039 rep GA 1975-01-14 1977-01-03   Democrat 8                        
31368 31368 Leonor Sullivan S001057 rep MO 1975-01-14 1977-01-03   Democrat 3                        
31372 31372 James Symington S001134 rep MO 1975-01-14 1977-01-03   Democrat 2                        
31379 31379 Burt Talcott T000022 rep CA 1975-01-14 1977-01-03   Republican 16                        
31383 31383 Herman Talmadge T000035 sen GA 1975-01-14 1981-01-03 3 Democrat                          
31392 31392 Roy Taylor T000099 rep NC 1975-01-14 1977-01-03   Democrat 11                        
31394 31394 Richard Vander Veen V000029 rep MI 1975-01-14 1977-01-03   Democrat 5                        
31400 31400 Joseph Vigorito V000098 rep PA 1975-01-14 1977-01-03   Democrat 24                        
31406 31406 Milton Young Y000047 sen ND 1975-01-14 1981-01-03 3 Republican                          
31409 31409 Pierre du Pont D000558 rep DE 1975-01-14 1977-01-03   Republican 0                        
31411 31411 Clifford Allen A000118 rep TN 1975-01-14 1977-01-03   Democrat 5                        
31416 31416 Herman Badillo B000025 rep NY 1975-01-14 1977-01-03   Democrat 21                        
31420 31420 Robert Bergland B000408 rep MN 1975-01-14 1977-01-03   Democrat 7                        
31422 31422 Michael Blouin B000567 rep IA 1975-01-14 1977-01-03   Democrat 2                        
31425 31425 John Breckinridge B000788 rep KY 1975-01-14 1977-01-03   Democrat 6                        
31431 31431 Garry Brown B000917 rep MI 1975-01-14 1977-01-03   Republican 3                        
31437 31437 J. Burke B001091 rep FL 1975-01-14 1977-01-03   Republican 12                        
31447 31447 James Burke B001092 rep MA 1975-01-14 1977-01-03   Democrat 11                        
31450 31450 Yvonne Burke B001102 rep CA 1975-01-14 1977-01-03   Democrat 28                        
31466 31466 Omar Burleson B001111 rep TX 1975-01-14 1977-01-03   Democrat 17                        
31473 31473 Goodloe Byron B001221 rep MD 1975-01-14 1977-01-03   Democrat 6                        
31483 31483 Charles Carney C000164 rep OH 1975-01-14 1977-01-03   Democrat 19                        
31496 31496 Elford Cederberg C000263 rep MI 1975-01-14 1977-01-03   Republican 10                        
31504 31504 Delwin Clawson C000476 rep CA 1975-01-14 1977-01-03   Republican 33                        
31506 31506 Robert Cornell C000782 rep WI 1975-01-14 1977-01-03   Democrat 8                        
31524 31524 James Delaney D000211 rep NY 1975-01-14 1977-01-03   Democrat 9                        
31535 31535 John Dent D000255 rep PA 1975-01-14 1977-01-03   Democrat 21                        

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