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 legislator_id
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30899 | 30899 | Dominick Daniels D000041 | rep | NJ | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
32587 | 32587 | George Danielson D000043 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 29 | |||||||||||||
30285 | 30285 | Glenn Davis D000102 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
30292 | 30292 | John Davis D000122 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
32011 | 32011 | Mendel Davis D000125 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
36120 | 36120 | Eligio de la Garza D000203 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 15 | |||||||||||||
35669 | 35669 | Ron de Lugo D000209 | rep | VI | 1973-01-03 | 1975-01-03 | Democrat | 0 | |||||||||||||
31524 | 31524 | James Delaney D000211 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
30296 | 30296 | John Dellenback D000220 | rep | OR | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
36143 | 36143 | Ronald Dellums D000222 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
30298 | 30298 | Frank Denholm D000234 | rep | SD | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30301 | 30301 | David Dennis D000241 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
31535 | 31535 | John Dent D000255 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
32603 | 32603 | Edward Derwinski D000269 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
32022 | 32022 | Samuel Devine D000279 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 12 | |||||||||||||
34373 | 34373 | William Dickinson D000326 | rep | AL | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
32035 | 32035 | Charles Diggs D000344 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 13 | |||||||||||||
39808 | 39808 | John Dingell D000355 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 16 | |||||||||||||
35194 | 35194 | Robert Dole D000401 | sen | KS | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
29222 | 29222 | Peter Dominick D000409 | sen | CO | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
30908 | 30908 | Thomas Downing D000474 | rep | VA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
32040 | 32040 | Robert Drinan D000499 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
30336 | 30336 | Thaddeus Dulski D000523 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 37 | |||||||||||||
33570 | 33570 | John Duncan D000534 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
31409 | 31409 | Pierre du Pont D000558 | rep | DE | 1973-01-03 | 1975-01-03 | Republican | 0 | |||||||||||||
32612 | 32612 | Thomas Eagleton E000004 | sen | MO | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
32052 | 32052 | Robert Eckhardt E000035 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
35204 | 35204 | William Edwards E000064 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
32952 | 32952 | William Edwards E000084 | rep | AL | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
31541 | 31541 | Joshua Eilberg E000096 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
32962 | 32962 | John Erlenborn E000204 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 14 | |||||||||||||
29227 | 29227 | Samuel Ervin E000211 | sen | NC | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30914 | 30914 | Marvin Esch E000213 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30919 | 30919 | Edwin Eshleman E000214 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 16 | |||||||||||||
31548 | 31548 | Frank Evans E000240 | rep | CO | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30934 | 30934 | Joseph Evins E000273 | rep | TN | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
34451 | 34451 | Dante Fascell F000041 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 15 | |||||||||||||
33890 | 33890 | Walter Fauntroy F000046 | rep | DC | 1973-01-03 | 1975-01-03 | Democrat | 0 | |||||||||||||
32649 | 32649 | Paul Findley F000123 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 20 | |||||||||||||
35234 | 35234 | Hamilton Fish F000141 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 25 | |||||||||||||
30359 | 30359 | Ovie Fisher F000152 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
32072 | 32072 | Daniel Flood F000209 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
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 | |||||||||||||
35249 | 35249 | Thomas Foley F000239 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
30799 | 30799 | Gerald Ford F000260 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
35260 | 35260 | Wendell Ford F000268 | sen | KY | 1974-12-28 | 1975-01-03 | 3 | Democrat | |||||||||||||
35269 | 35269 | William Ford F000270 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 15 | |||||||||||||
32974 | 32974 | Edwin Forsythe F000286 | rep | NJ | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
32668 | 32668 | Lawrence Fountain F000319 | rep | NC | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31574 | 31574 | Donald Fraser F000350 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
30370 | 30370 | Peter Frelinghuysen F000371 | rep | NJ | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
33915 | 33915 | William Frenzel F000380 | rep | MN | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
31579 | 31579 | Louis Frey F000381 | rep | FL | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
30371 | 30371 | Harold Froehlich F000388 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
29285 | 29285 | James Fulbright F000401 | sen | AR | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30941 | 30941 | Richard Fulton F000424 | rep | TN | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
33275 | 33275 | Don Fuqua F000430 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
33584 | 33584 | Edwin Garn G000072 | sen | UT | 1974-12-21 | 1975-01-03 | 3 | Republican | |||||||||||||
34473 | 34473 | Joseph Gaydos G000105 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
30377 | 30377 | Thomas Gettys G000144 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
32083 | 32083 | Robert Giaimo G000151 | rep | CT | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
35826 | 35826 | Sam Gibbons G000153 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
36920 | 36920 | Benjamin Gilman G000212 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 26 | |||||||||||||
32673 | 32673 | Ronald Ginn G000226 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
35285 | 35285 | John Glenn G000236 | sen | OH | 1974-12-24 | 1975-01-03 | 3 | Democrat | |||||||||||||
32680 | 32680 | Barry Goldwater G000267 | sen | AZ | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
32685 | 32685 | Barry Goldwater G000268 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 27 | |||||||||||||
36209 | 36209 | Henry González G000272 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
30383 | 30383 | George Goodling G000290 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 19 | |||||||||||||
30385 | 30385 | Ella Grasso G000387 | rep | CT | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
30943 | 30943 | Maurice Gravel G000388 | sen | AK | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
33597 | 33597 | Kenneth Gray G000400 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 24 | |||||||||||||
30395 | 30395 | Edith Green G000407 | rep | OR | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30950 | 30950 | William Green G000420 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30413 | 30413 | Martha Griffiths G000471 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 17 | |||||||||||||
30426 | 30426 | Harold Gross G000495 | rep | IA | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30432 | 30432 | James Grover G000504 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30443 | 30443 | Charles Gubser G000512 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
30955 | 30955 | Gilbert Gude G000513 | rep | MD | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30444 | 30444 | William Gunter G000528 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
29295 | 29295 | Edward Gurney G000531 | sen | FL | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
32692 | 32692 | Tennyson Guyer G000537 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
30967 | 30967 | James Haley H000041 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
36232 | 36232 | Lee Hamilton H000114 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
34514 | 34514 | John Hammerschmidt H000124 | rep | AR | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
32093 | 32093 | James Hanley H000158 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 32 | |||||||||||||
30450 | 30450 | Richard Hanna H000164 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 34 | |||||||||||||
30451 | 30451 | Robert Hanrahan H000168 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30461 | 30461 | Julia Hansen H000174 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30464 | 30464 | Orval Hansen H000175 | rep | ID | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
31587 | 31587 | Michael Harrington H000230 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
32106 | 32106 | William Harsha H000281 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30471 | 30471 | James Harvey H000306 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30972 | 30972 | James Hastings H000327 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 39 | |||||||||||||
33938 | 33938 | Augustus Hawkins H000367 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
30987 | 30987 | Wayne Hays H000408 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 18 | |||||||||||||
31051 | 31051 | Felix Hébert H000437 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 1 |
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);