legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
479 rows where "end" is on date 1975-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: start, party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29227 | 29227 | Samuel Ervin E000211 | sen | NC | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29285 | 29285 | James Fulbright F000401 | sen | AR | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29296 | 29296 | Harold Hughes H000922 | sen | IA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30178 | 30178 | John Blatnik B000550 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
30182 | 30182 | Frank Brasco B000771 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
30222 | 30222 | Hugh Carey C000143 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 15 | |||||||||||||
30250 | 30250 | Frank Clark C000431 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 25 | |||||||||||||
30292 | 30292 | John Davis D000122 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
30298 | 30298 | Frank Denholm D000234 | rep | SD | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30315 | 30315 | Harold Donohue D000419 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30328 | 30328 | William Dorn D000434 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30336 | 30336 | Thaddeus Dulski D000523 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 37 | |||||||||||||
30359 | 30359 | Ovie Fisher F000152 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
30377 | 30377 | Thomas Gettys G000144 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
30385 | 30385 | Ella Grasso G000387 | rep | CT | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
30395 | 30395 | Edith Green G000407 | rep | OR | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30413 | 30413 | Martha Griffiths G000471 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 17 | |||||||||||||
30444 | 30444 | William Gunter G000528 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
30450 | 30450 | Richard Hanna H000164 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 34 | |||||||||||||
30461 | 30461 | Julia Hansen H000174 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30496 | 30496 | Chester Holifield H000713 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 19 | |||||||||||||
30530 | 30530 | Peter Kyros K000356 | rep | ME | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30574 | 30574 | Clem McSpadden M000603 | rep | OK | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30614 | 30614 | Bertram Podell P000399 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 13 | |||||||||||||
30624 | 30624 | John Rarick R000065 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
30630 | 30630 | Ogden Reid R000150 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 24 | |||||||||||||
30656 | 30656 | John Rooney R000424 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
30658 | 30658 | William Roy R000484 | rep | KS | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30715 | 30715 | Frank Stubblefield S001037 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30736 | 30736 | Robert Tiernan T000265 | rep | RI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30744 | 30744 | Jerome Waldie W000035 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
30801 | 30801 | Bella Abzug A000018 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
30816 | 30816 | Carl Albert A000073 | rep | OK | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30818 | 30818 | James Allen A000127 | sen | AL | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30833 | 30833 | William Barrett B000178 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30836 | 30836 | Birch Bayh B000254 | sen | IN | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30862 | 30862 | Robert Casey C000228 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
30866 | 30866 | Frank Church C000388 | sen | ID | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30890 | 30890 | John Culver C000979 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30899 | 30899 | Dominick Daniels D000041 | rep | NJ | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
30908 | 30908 | Thomas Downing D000474 | rep | VA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30934 | 30934 | Joseph Evins E000273 | rep | TN | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
30941 | 30941 | Richard Fulton F000424 | rep | TN | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
30943 | 30943 | Maurice Gravel G000388 | sen | AK | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30950 | 30950 | William Green G000420 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30967 | 30967 | James Haley H000041 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
30987 | 30987 | Wayne Hays H000408 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 18 | |||||||||||||
30996 | 30996 | Kenneth Hechler H000438 | rep | WV | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31002 | 31002 | Henry Helstoski H000465 | rep | NJ | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
31010 | 31010 | David Henderson H000479 | rep | NC | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31016 | 31016 | Floyd Hicks H000563 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31026 | 31026 | William Hungate H000965 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
31051 | 31051 | Felix Hébert H000437 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31064 | 31064 | John Jarman J000057 | rep | OK | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
31094 | 31094 | Robert Jones J000248 | rep | AL | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
31103 | 31103 | Joseph Karth K000014 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31116 | 31116 | John Kluczynski K000273 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
31128 | 31128 | Phillip Landrum L000054 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
31130 | 31130 | Jerry Litton L000360 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31141 | 31141 | Torbert Macdonald M000005 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
31158 | 31158 | Ray Madden M000039 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31169 | 31169 | Warren Magnuson M000053 | sen | WA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31177 | 31177 | George McGovern M000452 | sen | SD | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31179 | 31179 | Edward Mezvinsky M000686 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31198 | 31198 | Wilbur Mills M000778 | rep | AR | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31215 | 31215 | Thomas Morgan M000958 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
31226 | 31226 | Gaylord Nelson N000033 | sen | WI | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31235 | 31235 | James O’Hara O000055 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 12 | |||||||||||||
31250 | 31250 | Otto Passman P000098 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
31274 | 31274 | John Patman P000103 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31288 | 31288 | William Randall R000041 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31294 | 31294 | Thomas Rees R000134 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 26 | |||||||||||||
31299 | 31299 | Abraham Ribicoff R000191 | sen | CT | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31307 | 31307 | John Roush R000467 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31333 | 31333 | James Stanton S000803 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
31348 | 31348 | Robert Stephens S000860 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 10 | |||||||||||||
31350 | 31350 | Adlai Stevenson S000890 | sen | IL | 1970-01-01 | 1975-01-03 | 3 | Democrat | |||||||||||||
31356 | 31356 | Williamson Stuckey S001039 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
31368 | 31368 | Leonor Sullivan S001057 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31372 | 31372 | James Symington S001134 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31383 | 31383 | Herman Talmadge T000035 | sen | GA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31392 | 31392 | Roy Taylor T000099 | rep | NC | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
31394 | 31394 | Richard Vander Veen V000029 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
31400 | 31400 | Joseph Vigorito V000098 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 24 | |||||||||||||
31416 | 31416 | Herman Badillo B000025 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
31420 | 31420 | Robert Bergland B000408 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
31425 | 31425 | John Breckinridge B000788 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31447 | 31447 | James Burke B001092 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
31450 | 31450 | Yvonne Burke B001102 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 37 | |||||||||||||
31466 | 31466 | Omar Burleson B001111 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 17 | |||||||||||||
31473 | 31473 | Goodloe Byron B001221 | rep | MD | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31483 | 31483 | Charles Carney C000164 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 19 | |||||||||||||
31524 | 31524 | James Delaney D000211 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
31535 | 31535 | John Dent D000255 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
31541 | 31541 | Joshua Eilberg E000096 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31548 | 31548 | Frank Evans E000240 | rep | CO | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31553 | 31553 | Walter Flowers F000218 | rep | AL | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
31566 | 31566 | John Flynt F000229 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31574 | 31574 | Donald Fraser F000350 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
31587 | 31587 | Michael Harrington H000230 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 6 |
Advanced export
JSON shape: default, array, newline-delimited
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);