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 district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31953 | 31953 | Edward Beard B000279 | rep | RI | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31997 | 31997 | James Cleveland C000512 | rep | NH | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
32158 | 32158 | Marvin Mathis M000244 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32206 | 32206 | Morgan Murphy M001101 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32266 | 32266 | Harold Runnels R000510 | rep | NM | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32311 | 32311 | Harley Staggers S000778 | rep | WV | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32364 | 32364 | Albert Ullman U000004 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32431 | 32431 | James Abdnor A000009 | rep | SD | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
32507 | 32507 | David Bowen B000682 | rep | MS | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32562 | 32562 | Donald Clausen C000475 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
32654 | 32654 | Floyd Fithian F000161 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32669 | 32669 | Lawrence Fountain F000319 | rep | NC | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32697 | 32697 | Thomas Hagedorn H000012 | rep | MN | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
32987 | 32987 | George Hansen H000171 | rep | ID | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
33034 | 33034 | Clarence Long L000413 | rep | MD | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33058 | 33058 | John Melcher M000635 | rep | MT | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33276 | 33276 | Don Fuqua F000430 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33437 | 33437 | George Whitehurst W000406 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
33505 | 33505 | Edward Boland B000600 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33571 | 33571 | John Duncan D000534 | rep | TN | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
33799 | 33799 | Timothy Wirth W000647 | rep | CO | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33823 | 33823 | Corinne Boggs B000592 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33966 | 33966 | Robert Kastenmeier K000020 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
34310 | 34310 | William Cohen C000598 | rep | ME | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
34374 | 34374 | William Dickinson D000326 | rep | AL | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
34390 | 34390 | Thomas Downey D000471 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
35020 | 35020 | Morris Udall U000001 | rep | AZ | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
35327 | 35327 | William Hughes H000930 | rep | NJ | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
35468 | 35468 | William Natcher N000009 | rep | KY | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
36099 | 36099 | Charles Wilson W000570 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
37032 | 37032 | Patsy Mink M000797 | rep | HI | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
37156 | 37156 | Floyd Spence S000718 | rep | SC | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
37604 | 37604 | Christopher Dodd D000388 | rep | CT | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
30817 | 30817 | Carl Albert A000073 | rep | OK | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
30951 | 30951 | William Green G000420 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31011 | 31011 | David Henderson H000479 | rep | NC | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31341 | 31341 | Sam Steiger S000846 | rep | AZ | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
31369 | 31369 | Leonor Sullivan S001057 | rep | MO | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31432 | 31432 | Garry Brown B000917 | rep | MI | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
31549 | 31549 | Frank Evans E000240 | rep | CO | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31686 | 31686 | John Moss M001035 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31885 | 31885 | Charles Whalen W000317 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
31917 | 31917 | Jerome Ambro A000170 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31946 | 31946 | Alvin Baldus B000083 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31964 | 31964 | John Brademas B000736 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32046 | 32046 | Robert Duncan D000537 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32084 | 32084 | Robert Giaimo G000151 | rep | CT | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32274 | 32274 | David Satterfield S000070 | rep | VA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32291 | 32291 | John Slack S000473 | rep | WV | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32349 | 32349 | David Treen T000362 | rep | LA | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
32515 | 32515 | Jack Brinkley B000839 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32570 | 32570 | James Collins C000638 | rep | TX | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
33180 | 33180 | Edward Winn W000636 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
33517 | 33517 | Don Bonker B000620 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
33605 | 33605 | James Howard H000840 | rep | NJ | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
33688 | 33688 | William Nichols N000095 | rep | AL | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
33916 | 33916 | William Frenzel F000380 | rep | MN | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
34103 | 34103 | Virginia Smith S000622 | rep | NE | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
34246 | 34246 | Charles Bennett B000371 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
34411 | 34411 | Joseph Early E000013 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
34515 | 34515 | John Hammerschmidt H000124 | rep | AR | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
34913 | 34913 | Martin Russo R000543 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
35180 | 35180 | Butler Derrick D000267 | rep | SC | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
35373 | 35373 | Marilyn Lloyd L000381 | rep | TN | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
35394 | 35394 | Romano Mazzoli M000291 | rep | KY | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
35922 | 35922 | Gillespie Montgomery M000865 | rep | MS | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
37095 | 37095 | Paul Sarbanes S000064 | rep | MD | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
42434 | 42434 | Charles Grassley G000386 | rep | IA | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
30877 | 30877 | John Conlan C000682 | rep | AZ | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
30935 | 30935 | Joseph Evins E000273 | rep | TN | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
30997 | 30997 | Kenneth Hechler H000438 | rep | WV | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31034 | 31034 | J. Hutchinson H001011 | rep | MI | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
31104 | 31104 | Joseph Karth K000014 | rep | MN | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31289 | 31289 | William Randall R000041 | rep | MO | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31308 | 31308 | John Roush R000467 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31331 | 31331 | Garner Shriver S000388 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
31542 | 31542 | Joshua Eilberg E000096 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31619 | 31619 | Robert Leggett L000221 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31646 | 31646 | James Mann M000105 | rep | SC | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31876 | 31876 | Joseph Waggonner W000018 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32041 | 32041 | Robert Drinan D000499 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32143 | 32143 | James Johnson J000148 | rep | CO | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
32163 | 32163 | Mike McCormack M000365 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32260 | 32260 | Herbert Roberts R000312 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32327 | 32327 | Thomas Steed S000829 | rep | OK | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32341 | 32341 | Frank Thompson T000200 | rep | NJ | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32582 | 32582 | Robert Daniel D000037 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
32604 | 32604 | Edward Derwinski D000269 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
32693 | 32693 | Tennyson Guyer G000537 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
32899 | 32899 | Ike Andrews A000207 | rep | NC | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33023 | 33023 | Elliott Levitas L000265 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33204 | 33204 | Clement Zablocki Z000001 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33308 | 33308 | Marjorie Holt H000747 | rep | MD | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
33420 | 33420 | Marion Snyder S000669 | rep | KY | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
33428 | 33428 | James Weaver W000227 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33532 | 33532 | William Chappell C000321 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33672 | 33672 | Stewart McKinney M000527 | rep | CT | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
34675 | 34675 | Norman Lent L000243 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
35590 | 35590 | Neal Smith S000596 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
35697 | 35697 | Tom Bevill B000431 | rep | AL | 1975-01-14 | 1977-01-03 | Democrat | 4 |
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);