legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "start" is on date 1969-01-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30475 | 30475 | William Hathaway H000346 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30531 | 30531 | Earl Landgrebe L000049 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30605 | 30605 | Ancher Nelsen N000028 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30663 | 30663 | Charles Sandman S000045 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30705 | 30705 | Robert Steele S000836 | rep | CT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30734 | 30734 | Robert Tiernan T000265 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30872 | 30872 | Donald Clancy C000409 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30888 | 30888 | John Culver C000979 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30912 | 30912 | Marvin Esch E000213 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
31196 | 31196 | Wilbur Mills M000778 | rep | AR | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31370 | 31370 | James Symington S001134 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31661 | 31661 | Lloyd Meeds M000626 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31700 | 31700 | Robert Nix N000113 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31994 | 31994 | James Cleveland C000512 | rep | NH | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
32136 | 32136 | Harold Johnson J000135 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32179 | 32179 | Abner Mikva M000703 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32308 | 32308 | Harley Staggers S000778 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32361 | 32361 | Albert Ullman U000004 | rep | OR | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32666 | 32666 | Lawrence Fountain F000319 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33031 | 33031 | Clarence Long L000413 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33055 | 33055 | John Melcher M000635 | rep | MT | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33273 | 33273 | Don Fuqua F000430 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33434 | 33434 | George Whitehurst W000406 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
33502 | 33502 | Edward Boland B000600 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33568 | 33568 | John Duncan D000534 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
33963 | 33963 | Robert Kastenmeier K000020 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
34006 | 34006 | Spark Matsunaga M000250 | rep | HI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
34371 | 34371 | William Dickinson D000326 | rep | AL | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
35017 | 35017 | Morris Udall U000001 | rep | AZ | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
35465 | 35465 | William Natcher N000009 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
35656 | 35656 | Jamie Whitten W000428 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29182 | 29182 | William Cowger C000823 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
29350 | 29350 | Clark MacGregor M000010 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
29397 | 29397 | William Murphy M001104 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29419 | 29419 | Philip Philbin P000303 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29557 | 29557 | George Andrews A000206 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29637 | 29637 | William Brock B000851 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
29648 | 29648 | James Byrne B001212 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29668 | 29668 | Patrick Caffery C000017 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29812 | 29812 | Edward Garmatz G000071 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29815 | 29815 | Charles Griffin G000458 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30326 | 30326 | William Dorn D000434 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30393 | 30393 | Edith Green G000407 | rep | OR | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30424 | 30424 | Harold Gross G000495 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30459 | 30459 | Julia Hansen H000174 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30552 | 30552 | David Martin M000175 | rep | NE | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30730 | 30730 | Vernon Thomson T000233 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30814 | 30814 | Carl Albert A000073 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31008 | 31008 | David Henderson H000479 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31338 | 31338 | Sam Steiger S000846 | rep | AZ | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
31366 | 31366 | Leonor Sullivan S001057 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31429 | 31429 | Garry Brown B000917 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
31546 | 31546 | Frank Evans E000240 | rep | CO | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31683 | 31683 | John Moss M001035 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31882 | 31882 | Charles Whalen W000317 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
31961 | 31961 | John Brademas B000736 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32081 | 32081 | Robert Giaimo G000151 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32271 | 32271 | David Satterfield S000070 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32288 | 32288 | John Slack S000473 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32414 | 32414 | Lester Wolff W000680 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32512 | 32512 | Jack Brinkley B000839 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32567 | 32567 | James Collins C000638 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
33177 | 33177 | Edward Winn W000636 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
33602 | 33602 | James Howard H000840 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
34243 | 34243 | Charles Bennett B000371 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
34512 | 34512 | John Hammerschmidt H000124 | rep | AR | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
29112 | 29112 | Edwin Adair A000024 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29247 | 29247 | George Fallon F000012 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29360 | 29360 | Catherine May M000273 | rep | WA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29522 | 29522 | Watkins Abbitt A000002 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29569 | 29569 | Wayne Aspinall A000225 | rep | CO | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29791 | 29791 | Nick Galifianakis G000015 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29882 | 29882 | John Kyl K000351 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29922 | 29922 | William McCulloch M000393 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30162 | 30162 | Benjamin Blackburn B000506 | rep | GA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30294 | 30294 | John Dellenback D000220 | rep | OR | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30313 | 30313 | Harold Donohue D000419 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
30932 | 30932 | Joseph Evins E000273 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
30994 | 30994 | Kenneth Hechler H000438 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31031 | 31031 | J. Hutchinson H001011 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
31101 | 31101 | Joseph Karth K000014 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31286 | 31286 | William Randall R000041 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31328 | 31328 | Garner Shriver S000388 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
31539 | 31539 | Joshua Eilberg E000096 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31616 | 31616 | Robert Leggett L000221 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31643 | 31643 | James Mann M000105 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31873 | 31873 | Joseph Waggonner W000018 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32257 | 32257 | Herbert Roberts R000312 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32324 | 32324 | Thomas Steed S000829 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32338 | 32338 | Frank Thompson T000200 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32424 | 32424 | John Wydler W000780 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
32601 | 32601 | Edward Derwinski D000269 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
33169 | 33169 | Lowell Weicker W000253 | rep | CT | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
33201 | 33201 | Clement Zablocki Z000001 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
33417 | 33417 | Marion Snyder S000669 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
33529 | 33529 | William Chappell C000321 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
33685 | 33685 | William Nichols N000095 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
34848 | 34848 | David Pryor P000556 | rep | AR | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
35919 | 35919 | Gillespie Montgomery M000865 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29345 | 29345 | Allard Lowenstein L000477 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 5 |
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);