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 descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30334 | 30334 | Thaddeus Dulski D000523 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 41 | |||||||||||||
30691 | 30691 | Henry Smith S000548 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 40 | |||||||||||||
29363 | 29363 | Richard McCarthy M000318 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 39 | |||||||||||||
30115 | 30115 | John Tunney T000410 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 38 | |||||||||||||
30970 | 30970 | James Hastings H000327 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 38 | |||||||||||||
32370 | 32370 | Lionel Van Deerlin V000024 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 37 | |||||||||||||
32924 | 32924 | Barber Conable C000666 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 37 | |||||||||||||
32406 | 32406 | Robert Wilson W000610 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 36 | |||||||||||||
34566 | 34566 | Frank Horton H000797 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 36 | |||||||||||||
29498 | 29498 | James Utt U000034 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 35 | |||||||||||||
30061 | 30061 | John Schmitz S000133 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 35 | |||||||||||||
33767 | 33767 | Samuel Stratton S000997 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 35 | |||||||||||||
30448 | 30448 | Richard Hanna H000164 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 34 | |||||||||||||
32091 | 32091 | James Hanley H000158 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 34 | |||||||||||||
30637 | 30637 | Howard Robison R000357 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 33 | |||||||||||||
31277 | 31277 | Jerry Pettis P000272 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 33 | |||||||||||||
30025 | 30025 | Alexander Pirnie P000366 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 32 | |||||||||||||
30505 | 30505 | Craig Hosmer H000802 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 32 | |||||||||||||
32168 | 32168 | Robert McEwen M000433 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 31 | |||||||||||||
32392 | 32392 | Charles Wilson W000571 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 31 | |||||||||||||
30520 | 30520 | Carleton King K000195 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 30 | |||||||||||||
34901 | 34901 | Edward Roybal R000485 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 30 | |||||||||||||
29168 | 29168 | Daniel Button B001201 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 29 | |||||||||||||
36525 | 36525 | George Brown B000918 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 29 | |||||||||||||
30842 | 30842 | Alphonzo Bell B000330 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 28 | |||||||||||||
35232 | 35232 | Hamilton Fish F000141 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 28 | |||||||||||||
29386 | 29386 | Martin McKneally M000530 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 27 | |||||||||||||
29442 | 29442 | Edwin Reinecke R000159 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 27 | |||||||||||||
29788 | 29788 | James Fulton F000422 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 27 | |||||||||||||
32683 | 32683 | Barry Goldwater G000268 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 27 | |||||||||||||
30628 | 30628 | Ogden Reid R000150 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 26 | |||||||||||||
31213 | 31213 | Thomas Morgan M000958 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 26 | |||||||||||||
31292 | 31292 | Thomas Rees R000134 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 26 | |||||||||||||
30248 | 30248 | Frank Clark C000431 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 25 | |||||||||||||
31888 | 31888 | Charles Wiggins W000448 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 25 | |||||||||||||
33074 | 33074 | Richard Ottinger O000134 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 25 | |||||||||||||
29344 | 29344 | Glenard Lipscomb L000344 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 24 | |||||||||||||
31398 | 31398 | Joseph Vigorito V000098 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 24 | |||||||||||||
32844 | 32844 | John Rousselot R000469 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 24 | |||||||||||||
33484 | 33484 | Mario Biaggi B000432 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 24 | |||||||||||||
33707 | 33707 | Charles Price P000522 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 24 | |||||||||||||
33995 | 33995 | Donald Lukens L000509 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 24 | |||||||||||||
30591 | 30591 | William Minshall M000799 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 23 | |||||||||||||
31077 | 31077 | Albert Johnson J000115 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 23 | |||||||||||||
31502 | 31502 | Delwin Clawson C000476 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 23 | |||||||||||||
31795 | 31795 | George Shipley S000367 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 23 | |||||||||||||
32478 | 32478 | Jonathan Bingham B000472 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 23 | |||||||||||||
33012 | 33012 | Abraham Kazen K000025 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 23 | |||||||||||||
29291 | 29291 | Jacob Gilbert G000175 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
30099 | 30099 | William Springer S000756 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 22 | |||||||||||||
30676 | 30676 | John Saylor S000102 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 22 | |||||||||||||
30860 | 30860 | Robert Casey C000228 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
32004 | 32004 | James Corman C000780 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
32383 | 32383 | Charles Vanik V000047 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
30357 | 30357 | Ovie Fisher F000152 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
31533 | 31533 | John Dent D000255 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
33595 | 33595 | Kenneth Gray G000400 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
33936 | 33936 | Augustus Hawkins H000367 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
34930 | 34930 | James Scheuer S000124 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
36398 | 36398 | Louis Stokes S000948 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
29268 | 29268 | Michael Feighan F000060 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
30059 | 30059 | William Ryan R000562 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
30088 | 30088 | H. Smith S000545 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 20 | |||||||||||||
32647 | 32647 | Paul Findley F000123 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 20 | |||||||||||||
34471 | 34471 | Joseph Gaydos G000105 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
36207 | 36207 | Henry González G000272 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
29254 | 29254 | Leonard Farbstein F000015 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
29318 | 29318 | Michael Kirwan K000244 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
29925 | 29925 | Jack McDonald M000410 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
30381 | 30381 | George Goodling G000290 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
30494 | 30494 | Chester Holifield H000713 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
31481 | 31481 | Charles Carney C000164 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
31638 | 31638 | George Mahon M000065 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
32802 | 32802 | Thomas Railsback R000012 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
29434 | 29434 | Adam Powell P000477 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 18 | |||||||||||||
29730 | 29730 | Robert Corbett C000772 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
30556 | 30556 | Robert Mathias M000242 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
30618 | 30618 | Robert Price P000528 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
30985 | 30985 | Wayne Hays H000408 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 18 | |||||||||||||
34271 | 34271 | William Broomfield B000890 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
35434 | 35434 | Robert Michel M000692 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
30155 | 30155 | Leslie Arends A000216 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 17 | |||||||||||||
30411 | 30411 | Martha Griffiths G000471 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
31314 | 31314 | Herman Schneebeli S000135 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 17 | |||||||||||||
31464 | 31464 | Omar Burleson B001111 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
31605 | 31605 | Edward Koch K000302 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
32450 | 32450 | John Ashbrook A000221 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 17 | |||||||||||||
34174 | 34174 | Glenn Anderson A000189 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
29632 | 29632 | Frank Bow B000676 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 16 | |||||||||||||
30917 | 30917 | Edwin Eshleman E000214 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 16 | |||||||||||||
31826 | 31826 | Bernice Sisk S000454 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
31924 | 31924 | John Anderson A000195 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 16 | |||||||||||||
32198 | 32198 | John Murphy M001098 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
32883 | 32883 | Richard White W000390 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
39806 | 39806 | John Dingell D000355 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
30053 | 30053 | Charlotte Reid R000143 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 15 | |||||||||||||
30220 | 30220 | Hugh Carey C000143 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
31654 | 31654 | John McFall M000436 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
31772 | 31772 | Frederick Rooney R000423 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
32226 | 32226 | Edward Patten P000106 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 15 |
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);