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 1967-01-03 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30332 | 30332 | Thaddeus Dulski D000523 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 41 | |||||||||||||
30689 | 30689 | Henry Smith S000548 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 40 | |||||||||||||
29361 | 29361 | Richard McCarthy M000318 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 39 | |||||||||||||
29101 | 29101 | Charles Goodell G000282 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 38 | |||||||||||||
30113 | 30113 | John Tunney T000410 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 38 | |||||||||||||
32368 | 32368 | Lionel Van Deerlin V000024 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 37 | |||||||||||||
32922 | 32922 | Barber Conable C000666 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 37 | |||||||||||||
32404 | 32404 | Robert Wilson W000610 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 36 | |||||||||||||
34564 | 34564 | Frank Horton H000797 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 36 | |||||||||||||
29496 | 29496 | James Utt U000034 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 35 | |||||||||||||
33765 | 33765 | Samuel Stratton S000997 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 35 | |||||||||||||
30446 | 30446 | Richard Hanna H000164 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 34 | |||||||||||||
32089 | 32089 | James Hanley H000158 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 34 | |||||||||||||
28418 | 28418 | Kenneth Dyal D000588 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 33 | |||||||||||||
30635 | 30635 | Howard Robison R000357 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 33 | |||||||||||||
30023 | 30023 | Alexander Pirnie P000366 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 32 | |||||||||||||
30503 | 30503 | Craig Hosmer H000802 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 32 | |||||||||||||
32166 | 32166 | Robert McEwen M000433 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 31 | |||||||||||||
32390 | 32390 | Charles Wilson W000571 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 31 | |||||||||||||
30518 | 30518 | Carleton King K000195 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 30 | |||||||||||||
34899 | 34899 | Edward Roybal R000485 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 30 | |||||||||||||
28606 | 28606 | Leo O’Brien O000015 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 29 | |||||||||||||
36523 | 36523 | George Brown B000918 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 29 | |||||||||||||
29012 | 29012 | Joseph Resnick R000164 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 28 | |||||||||||||
30840 | 30840 | Alphonzo Bell B000330 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 28 | |||||||||||||
29440 | 29440 | Edwin Reinecke R000159 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 27 | |||||||||||||
29735 | 29735 | John Dow D000462 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 27 | |||||||||||||
29786 | 29786 | James Fulton F000422 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 27 | |||||||||||||
28634 | 28634 | James Roosevelt R000426 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 26 | |||||||||||||
30626 | 30626 | Ogden Reid R000150 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 26 | |||||||||||||
31211 | 31211 | Thomas Morgan M000958 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 26 | |||||||||||||
31290 | 31290 | Thomas Rees R000134 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 26 | |||||||||||||
28360 | 28360 | Ronald Cameron C000067 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 25 | |||||||||||||
30246 | 30246 | Frank Clark C000431 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 25 | |||||||||||||
33072 | 33072 | Richard Ottinger O000134 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 25 | |||||||||||||
28828 | 28828 | Paul Fino F000137 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 24 | |||||||||||||
29342 | 29342 | Glenard Lipscomb L000344 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 24 | |||||||||||||
31396 | 31396 | Joseph Vigorito V000098 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 24 | |||||||||||||
33705 | 33705 | Charles Price P000522 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 24 | |||||||||||||
30589 | 30589 | William Minshall M000799 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 23 | |||||||||||||
31075 | 31075 | Albert Johnson J000115 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 23 | |||||||||||||
31500 | 31500 | Delwin Clawson C000476 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 23 | |||||||||||||
31793 | 31793 | George Shipley S000367 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 23 | |||||||||||||
32476 | 32476 | Jonathan Bingham B000472 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 23 | |||||||||||||
28800 | 28800 | Frances Bolton B000607 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 22 | |||||||||||||
29289 | 29289 | Jacob Gilbert G000175 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
30097 | 30097 | William Springer S000756 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 22 | |||||||||||||
30674 | 30674 | John Saylor S000102 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 22 | |||||||||||||
30858 | 30858 | Robert Casey C000228 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
32002 | 32002 | James Corman C000780 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
30355 | 30355 | Ovie Fisher F000152 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
31531 | 31531 | John Dent D000255 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
32381 | 32381 | Charles Vanik V000047 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
33593 | 33593 | Kenneth Gray G000400 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
33934 | 33934 | Augustus Hawkins H000367 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
34928 | 34928 | James Scheuer S000124 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
28911 | 28911 | Elmer Holland H000717 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
29266 | 29266 | Michael Feighan F000060 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
30057 | 30057 | William Ryan R000562 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
30086 | 30086 | H. Smith S000545 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 20 | |||||||||||||
32645 | 32645 | Paul Findley F000123 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 20 | |||||||||||||
36205 | 36205 | Henry González G000272 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
28390 | 28390 | Nathaniel Craley C000866 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
28423 | 28423 | Billie Farnum F000025 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
28636 | 28636 | Darwin Schisler S000128 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
29252 | 29252 | Leonard Farbstein F000015 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
29316 | 29316 | Michael Kirwan K000244 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
30492 | 30492 | Chester Holifield H000713 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
31636 | 31636 | George Mahon M000065 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
28445 | 28445 | Harlan Hagen H000013 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
28628 | 28628 | Walter Rogers R000404 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
29432 | 29432 | Adam Powell P000477 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
29728 | 29728 | Robert Corbett C000772 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 18 | |||||||||||||
30983 | 30983 | Wayne Hays H000408 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
34269 | 34269 | William Broomfield B000890 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 18 | |||||||||||||
35432 | 35432 | Robert Michel M000692 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 18 | |||||||||||||
28524 | 28524 | John Lindsay L000326 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
28954 | 28954 | Cecil King K000196 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 17 | |||||||||||||
28960 | 28960 | Theodore Kupferman K000343 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
30153 | 30153 | Leslie Arends A000216 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
30409 | 30409 | Martha Griffiths G000471 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 17 | |||||||||||||
31312 | 31312 | Herman Schneebeli S000135 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
31462 | 31462 | Omar Burleson B001111 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 17 | |||||||||||||
32448 | 32448 | John Ashbrook A000221 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
28520 | 28520 | John Kunkel K000341 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 16 | |||||||||||||
29630 | 29630 | Frank Bow B000676 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 16 | |||||||||||||
31824 | 31824 | Bernice Sisk S000454 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
31922 | 31922 | John Anderson A000195 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 16 | |||||||||||||
32196 | 32196 | John Murphy M001098 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
32881 | 32881 | Richard White W000390 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
39804 | 39804 | John Dingell D000355 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
28652 | 28652 | Robert Secrest S000219 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
30051 | 30051 | Charlotte Reid R000143 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 15 | |||||||||||||
30218 | 30218 | Hugh Carey C000143 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
31652 | 31652 | John McFall M000436 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
31770 | 31770 | Frederick Rooney R000423 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
32224 | 32224 | Edward Patten P000106 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
35265 | 35265 | William Ford F000270 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
36116 | 36116 | Eligio de la Garza D000203 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
28315 | 28315 | John Baldwin B000092 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 14 |
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);