legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1975-01-14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31900 | 31900 | Andrew Young Y000028 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
32158 | 32158 | Marvin Mathis M000244 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32515 | 32515 | Jack Brinkley B000839 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32674 | 32674 | Ronald Ginn G000226 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
33023 | 33023 | Elliott Levitas L000265 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33049 | 33049 | Lawrence McDonald M000413 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33186 | 33186 | Antonio Won Pat W000686 | rep | GU | 1975-01-14 | 1977-01-03 | Democrat | 0 | |||||||||||||
34009 | 34009 | Spark Matsunaga M000250 | rep | HI | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
37032 | 37032 | Patsy Mink M000797 | rep | HI | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
39023 | 39023 | Daniel Inouye I000025 | sen | HI | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
30891 | 30891 | John Culver C000979 | sen | IA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31180 | 31180 | Edward Mezvinsky M000686 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
31423 | 31423 | Michael Blouin B000567 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33234 | 33234 | Berkley Bedell B000298 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
35590 | 35590 | Neal Smith S000596 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
39694 | 39694 | Thomas Harkin H000206 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
42434 | 42434 | Charles Grassley G000386 | rep | IA | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
30867 | 30867 | Frank Church C000388 | sen | ID | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32987 | 32987 | George Hansen H000171 | rep | ID | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
33786 | 33786 | Steven Symms S001138 | rep | ID | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
30969 | 30969 | Tim Hall H000073 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 15 | |||||||||||||
31117 | 31117 | John Kluczynski K000273 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
31351 | 31351 | Adlai Stevenson S000890 | sen | IL | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31668 | 31668 | Ralph Metcalfe M000675 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
31798 | 31798 | George Shipley S000367 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
31927 | 31927 | John Anderson A000195 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 16 | |||||||||||||
32181 | 32181 | Abner Mikva M000703 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 10 | |||||||||||||
32206 | 32206 | Morgan Murphy M001101 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32604 | 32604 | Edward Derwinski D000269 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
32635 | 32635 | John Fary F000040 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
32650 | 32650 | Paul Findley F000123 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 20 | |||||||||||||
32760 | 32760 | Robert McClory M000340 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 13 | |||||||||||||
32805 | 32805 | Thomas Railsback R000012 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 19 | |||||||||||||
32963 | 32963 | John Erlenborn E000204 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 14 | |||||||||||||
33376 | 33376 | George O’Brien O000010 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 17 | |||||||||||||
33710 | 33710 | Charles Price P000522 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 23 | |||||||||||||
34191 | 34191 | Frank Annunzio A000212 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
34697 | 34697 | Edward Madigan M000041 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 21 | |||||||||||||
34913 | 34913 | Martin Russo R000543 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
34956 | 34956 | Paul Simon S000423 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
35437 | 35437 | Robert Michel M000692 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 18 | |||||||||||||
35542 | 35542 | Daniel Rostenkowski R000458 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
35759 | 35759 | Cardiss Collins C000634 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
36460 | 36460 | Sidney Yates Y000013 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 9 | |||||||||||||
37285 | 37285 | Philip Crane C000873 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 12 | |||||||||||||
37697 | 37697 | Henry Hyde H001022 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
30837 | 30837 | Birch Bayh B000254 | sen | IN | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
30974 | 30974 | Philip Hayes H000392 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
31159 | 31159 | Ray Madden M000039 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
31308 | 31308 | John Roush R000467 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31964 | 31964 | John Brademas B000736 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32628 | 32628 | David Evans E000239 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
32654 | 32654 | Floyd Fithian F000161 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33301 | 33301 | Elwood Hillis H000624 | rep | IN | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
35565 | 35565 | Philip Sharp S000294 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 10 | |||||||||||||
35867 | 35867 | Andrew Jacobs J000033 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
35953 | 35953 | John Myers M001130 | rep | IN | 1975-01-14 | 1977-01-03 | Republican | 7 | |||||||||||||
36233 | 36233 | Lee Hamilton H000114 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 9 | |||||||||||||
31331 | 31331 | Garner Shriver S000388 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
31603 | 31603 | Martha Keys K000162 | rep | KS | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31837 | 31837 | Joe Skubitz S000472 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
32280 | 32280 | Keith Sebelius S000217 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
33180 | 33180 | Edward Winn W000636 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
35195 | 35195 | Robert Dole D000401 | sen | KS | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
31426 | 31426 | John Breckinridge B000788 | rep | KY | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
31986 | 31986 | Tim Carter C000201 | rep | KY | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
33100 | 33100 | Carl Perkins P000230 | rep | KY | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33420 | 33420 | Marion Snyder S000669 | rep | KY | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
34578 | 34578 | Carroll Hubbard H000878 | rep | KY | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
35261 | 35261 | Wendell Ford F000268 | sen | KY | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
35394 | 35394 | Romano Mazzoli M000291 | rep | KY | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
35468 | 35468 | William Natcher N000009 | rep | KY | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31052 | 31052 | Felix Hébert H000437 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
31251 | 31251 | Otto Passman P000098 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
31876 | 31876 | Joseph Waggonner W000018 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32349 | 32349 | David Treen T000362 | rep | LA | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
32738 | 32738 | Russell Long L000428 | sen | LA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
33340 | 33340 | Gillis Long L000417 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
33369 | 33369 | William Moore M000923 | rep | LA | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
33823 | 33823 | Corinne Boggs B000592 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
36513 | 36513 | John Breaux B000780 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
31142 | 31142 | Torbert Macdonald M000005 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
31448 | 31448 | James Burke B001092 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
31588 | 31588 | Michael Harrington H000230 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
32041 | 32041 | Robert Drinan D000499 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32352 | 32352 | Paul Tsongas T000393 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
32708 | 32708 | Margaret Heckler H000440 | rep | MA | 1975-01-14 | 1977-01-03 | Republican | 10 | |||||||||||||
33393 | 33393 | Thomas O’Neill O000098 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
33505 | 33505 | Edward Boland B000600 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
34333 | 34333 | Silvio Conte C000709 | rep | MA | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
34411 | 34411 | Joseph Early E000013 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
36038 | 36038 | Gerry Studds S001040 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 12 | |||||||||||||
37041 | 37041 | John Moakley M000834 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 9 | |||||||||||||
42815 | 42815 | Edward Markey M000133 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
30956 | 30956 | Gilbert Gude G000513 | rep | MD | 1975-01-14 | 1977-01-03 | Republican | 8 | |||||||||||||
31474 | 31474 | Goodloe Byron B001221 | rep | MD | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
31950 | 31950 | Robert Bauman B000244 | rep | MD | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
32294 | 32294 | Gladys Spellman S000716 | rep | MD | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
32748 | 32748 | Charles Mathias M000241 | sen | MD | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
33034 | 33034 | Clarence Long L000413 | rep | MD | 1975-01-14 | 1977-01-03 | Democrat | 2 |
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);