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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34006 | 34006 | Spark Matsunaga M000250 | rep | HI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
37029 | 37029 | Patsy Mink M000797 | rep | HI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
29882 | 29882 | John Kyl K000351 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30069 | 30069 | Frederick Schwengel S000161 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30424 | 30424 | Harold Gross G000495 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30560 | 30560 | Wiley Mayne M000286 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30680 | 30680 | William Scherle S000121 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
30888 | 30888 | John Culver C000979 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
35587 | 35587 | Neal Smith S000596 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
30462 | 30462 | Orval Hansen H000175 | rep | ID | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30866 | 30866 | Frank Church C000388 | sen | ID | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
33353 | 33353 | James McClure M000346 | rep | ID | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29217 | 29217 | William Dawson D000158 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29397 | 29397 | William Murphy M001104 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29470 | 29470 | Daniel Ronan R000420 | rep | IL | 1969-01-03 | 1969-08-13 | Democrat | 6 | |||||||||||||
29479 | 29479 | Donald Rumsfeld R000508 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 13 | |||||||||||||
30042 | 30042 | Roman Pucinski P000559 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
30053 | 30053 | Charlotte Reid R000143 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 15 | |||||||||||||
30099 | 30099 | William Springer S000756 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 22 | |||||||||||||
30155 | 30155 | Leslie Arends A000216 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 17 | |||||||||||||
30258 | 30258 | Harold Collier C000629 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
31114 | 31114 | John Kluczynski K000273 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31795 | 31795 | George Shipley S000367 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 23 | |||||||||||||
31924 | 31924 | John Anderson A000195 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 16 | |||||||||||||
32179 | 32179 | Abner Mikva M000703 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32601 | 32601 | Edward Derwinski D000269 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
32647 | 32647 | Paul Findley F000123 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 20 | |||||||||||||
32757 | 32757 | Robert McClory M000340 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
32802 | 32802 | Thomas Railsback R000012 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
32960 | 32960 | John Erlenborn E000204 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 14 | |||||||||||||
33595 | 33595 | Kenneth Gray G000400 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
33707 | 33707 | Charles Price P000522 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 24 | |||||||||||||
34188 | 34188 | Frank Annunzio A000212 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
35434 | 35434 | Robert Michel M000692 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
35539 | 35539 | Daniel Rostenkowski R000458 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
36457 | 36457 | Sidney Yates Y000013 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
37282 | 37282 | Philip Crane C000873 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 13 | |||||||||||||
29112 | 29112 | Edwin Adair A000024 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29475 | 29475 | Richard Roudebush R000464 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30192 | 30192 | William Bray B000778 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30299 | 30299 | David Dennis D000241 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30531 | 30531 | Earl Landgrebe L000049 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30774 | 30774 | Roger Zion Z000010 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30836 | 30836 | Birch Bayh B000254 | sen | IN | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31156 | 31156 | Ray Madden M000039 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31961 | 31961 | John Brademas B000736 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
35865 | 35865 | Andrew Jacobs J000033 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
35950 | 35950 | John Myers M001130 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
36230 | 36230 | Lee Hamilton H000114 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
29391 | 29391 | Chester Mize M000832 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
31328 | 31328 | Garner Shriver S000388 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
31834 | 31834 | Joe Skubitz S000472 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
32277 | 32277 | Keith Sebelius S000217 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
33177 | 33177 | Edward Winn W000636 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
35194 | 35194 | Robert Dole D000401 | sen | KS | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
29097 | 29097 | Marlow Cook C000721 | sen | KY | 1969-01-03 | 1974-12-27 | 3 | Republican | |||||||||||||
29182 | 29182 | William Cowger C000823 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30126 | 30126 | John Watts W000212 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30713 | 30713 | Frank Stubblefield S001037 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31983 | 31983 | Tim Carter C000201 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
33097 | 33097 | Carl Perkins P000230 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
33417 | 33417 | Marion Snyder S000669 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
35465 | 35465 | William Natcher N000009 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29621 | 29621 | Thomas Boggs B000594 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29668 | 29668 | Patrick Caffery C000017 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29769 | 29769 | Edwin Edwards E000067 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29900 | 29900 | Speedy Long L000429 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
30622 | 30622 | John Rarick R000065 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31049 | 31049 | Felix Hébert H000437 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31248 | 31248 | Otto Passman P000098 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31873 | 31873 | Joseph Waggonner W000018 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32737 | 32737 | Russell Long L000428 | sen | LA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29139 | 29139 | William Bates B000239 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29385 | 29385 | John McCormack M000364 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
29419 | 29419 | Philip Philbin P000303 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29876 | 29876 | Hastings Keith K000053 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
29980 | 29980 | Frank Morse M001009 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30313 | 30313 | Harold Donohue D000419 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31139 | 31139 | Torbert Macdonald M000005 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
31445 | 31445 | James Burke B001092 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
31585 | 31585 | Michael Harrington H000230 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
32705 | 32705 | Margaret Heckler H000440 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
33390 | 33390 | Thomas O’Neill O000098 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
33502 | 33502 | Edward Boland B000600 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
34330 | 34330 | Silvio Conte C000709 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29247 | 29247 | George Fallon F000012 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29279 | 29279 | Samuel Friedel F000384 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29581 | 29581 | John Beall B000272 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29812 | 29812 | Edward Garmatz G000071 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29985 | 29985 | Rogers Morton M001021 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30478 | 30478 | Lawrence Hogan H000692 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30953 | 30953 | Gilbert Gude G000513 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
32747 | 32747 | Charles Mathias M000241 | sen | MD | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
33031 | 33031 | Clarence Long L000413 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30475 | 30475 | William Hathaway H000346 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30528 | 30528 | Peter Kyros K000356 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29925 | 29925 | Jack McDonald M000410 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
30238 | 30238 | Charles Chamberlain C000275 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 6 |
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);