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 state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31348 | 31348 | Robert Stephens S000860 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 10 | |||||||||||||
31356 | 31356 | Williamson Stuckey S001039 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
31383 | 31383 | Herman Talmadge T000035 | sen | GA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31566 | 31566 | John Flynt F000229 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31899 | 31899 | Andrew Young Y000028 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
32157 | 32157 | Marvin Mathis M000244 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
32514 | 32514 | Jack Brinkley B000839 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
32673 | 32673 | Ronald Ginn G000226 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
33185 | 33185 | Antonio Won Pat W000686 | rep | GU | 1973-01-03 | 1975-01-03 | Democrat | 0 | |||||||||||||
34008 | 34008 | Spark Matsunaga M000250 | rep | HI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
37031 | 37031 | Patsy Mink M000797 | rep | HI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
39022 | 39022 | Daniel Inouye I000025 | sen | HI | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29296 | 29296 | Harold Hughes H000922 | sen | IA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30426 | 30426 | Harold Gross G000495 | rep | IA | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30562 | 30562 | Wiley Mayne M000286 | rep | IA | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30682 | 30682 | William Scherle S000121 | rep | IA | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30890 | 30890 | John Culver C000979 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31179 | 31179 | Edward Mezvinsky M000686 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
35589 | 35589 | Neal Smith S000596 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
30464 | 30464 | Orval Hansen H000175 | rep | ID | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30866 | 30866 | Frank Church C000388 | sen | ID | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
33785 | 33785 | Steven Symms S001138 | rep | ID | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
30157 | 30157 | Leslie Arends A000216 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 15 | |||||||||||||
30260 | 30260 | Harold Collier C000629 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30451 | 30451 | Robert Hanrahan H000168 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30772 | 30772 | Samuel Young Y000052 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
31116 | 31116 | John Kluczynski K000273 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
31350 | 31350 | Adlai Stevenson S000890 | sen | IL | 1970-01-01 | 1975-01-03 | 3 | Democrat | |||||||||||||
31667 | 31667 | Ralph Metcalfe M000675 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31797 | 31797 | George Shipley S000367 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
31926 | 31926 | John Anderson A000195 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 16 | |||||||||||||
32205 | 32205 | Morgan Murphy M001101 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
32603 | 32603 | Edward Derwinski D000269 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
32649 | 32649 | Paul Findley F000123 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 20 | |||||||||||||
32759 | 32759 | Robert McClory M000340 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 13 | |||||||||||||
32804 | 32804 | Thomas Railsback R000012 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 19 | |||||||||||||
32962 | 32962 | John Erlenborn E000204 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 14 | |||||||||||||
33375 | 33375 | George O’Brien O000010 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 17 | |||||||||||||
33597 | 33597 | Kenneth Gray G000400 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 24 | |||||||||||||
33709 | 33709 | Charles Price P000522 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 23 | |||||||||||||
34190 | 34190 | Frank Annunzio A000212 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
34696 | 34696 | Edward Madigan M000041 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 21 | |||||||||||||
35436 | 35436 | Robert Michel M000692 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 18 | |||||||||||||
35541 | 35541 | Daniel Rostenkowski R000458 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
35758 | 35758 | Cardiss Collins C000634 | rep | IL | 1973-06-05 | 1975-01-03 | Democrat | 7 | |||||||||||||
36459 | 36459 | Sidney Yates Y000013 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
37284 | 37284 | Philip Crane C000873 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 12 | |||||||||||||
30194 | 30194 | William Bray B000778 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30301 | 30301 | David Dennis D000241 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
30509 | 30509 | William Hudnut H000906 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 11 | |||||||||||||
30533 | 30533 | Earl Landgrebe L000049 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30776 | 30776 | Roger Zion Z000010 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30836 | 30836 | Birch Bayh B000254 | sen | IN | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31158 | 31158 | Ray Madden M000039 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31307 | 31307 | John Roush R000467 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31963 | 31963 | John Brademas B000736 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
33300 | 33300 | Elwood Hillis H000624 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
35952 | 35952 | John Myers M001130 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
36232 | 36232 | Lee Hamilton H000114 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
30658 | 30658 | William Roy R000484 | rep | KS | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31330 | 31330 | Garner Shriver S000388 | rep | KS | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
31836 | 31836 | Joe Skubitz S000472 | rep | KS | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
32279 | 32279 | Keith Sebelius S000217 | rep | KS | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
33179 | 33179 | Edward Winn W000636 | rep | KS | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
35194 | 35194 | Robert Dole D000401 | sen | KS | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
30715 | 30715 | Frank Stubblefield S001037 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31425 | 31425 | John Breckinridge B000788 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31985 | 31985 | Tim Carter C000201 | rep | KY | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
33099 | 33099 | Carl Perkins P000230 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
33419 | 33419 | Marion Snyder S000669 | rep | KY | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
35260 | 35260 | Wendell Ford F000268 | sen | KY | 1974-12-28 | 1975-01-03 | 3 | Democrat | |||||||||||||
35393 | 35393 | Romano Mazzoli M000291 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
35467 | 35467 | William Natcher N000009 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30624 | 30624 | John Rarick R000065 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31051 | 31051 | Felix Hébert H000437 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31250 | 31250 | Otto Passman P000098 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
31875 | 31875 | Joseph Waggonner W000018 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
32348 | 32348 | David Treen T000362 | rep | LA | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
32737 | 32737 | Russell Long L000428 | sen | LA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
33339 | 33339 | Gillis Long L000417 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
33822 | 33822 | Corinne Boggs B000592 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
36512 | 36512 | John Breaux B000780 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
30263 | 30263 | Paul Cronin C000925 | rep | MA | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30315 | 30315 | Harold Donohue D000419 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31141 | 31141 | Torbert Macdonald M000005 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
31447 | 31447 | James Burke B001092 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
31587 | 31587 | Michael Harrington H000230 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
32040 | 32040 | Robert Drinan D000499 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
32707 | 32707 | Margaret Heckler H000440 | rep | MA | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
33392 | 33392 | Thomas O’Neill O000098 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
33504 | 33504 | Edward Boland B000600 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
34332 | 34332 | Silvio Conte C000709 | rep | MA | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
36037 | 36037 | Gerry Studds S001040 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 12 | |||||||||||||
37040 | 37040 | John Moakley M000834 | rep | MA | 1973-01-03 | 1975-01-03 | Ind. Democrat | 9 | |||||||||||||
30480 | 30480 | Lawrence Hogan H000692 | rep | MD | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30583 | 30583 | William Mills M000779 | rep | MD | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
30955 | 30955 | Gilbert Gude G000513 | rep | MD | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
31473 | 31473 | Goodloe Byron B001221 | rep | MD | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31949 | 31949 | Robert Bauman B000244 | rep | MD | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
32747 | 32747 | Charles Mathias M000241 | sen | MD | 1969-01-03 | 1975-01-03 | 3 | Republican |
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);