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 1957-01-03 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30120 | 30120 | John Watts W000212 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
30093 | 30093 | William Springer S000756 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
30082 | 30082 | H. Smith S000545 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
30078 | 30078 | Hugh Scott S000174 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
30064 | 30064 | Frederick Schwengel S000161 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
30029 | 30029 | Richard Poff P000401 | rep | VA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
30012 | 30012 | Thomas Pelly P000196 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
29997 | 29997 | Alvin O’Konski O000058 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
29969 | 29969 | Joseph Montoya M000876 | rep | NM | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
29954 | 29954 | George Miller M000727 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
29940 | 29940 | John McMillan M000568 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29916 | 29916 | William McCulloch M000393 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
29885 | 29885 | Alton Lennon L000240 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
29859 | 29859 | Charles Jonas J000206 | rep | NC | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
29849 | 29849 | William Hull H000947 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29806 | 29806 | Edward Garmatz G000071 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29782 | 29782 | James Fulton F000422 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 27 | |||||||||||||
29759 | 29759 | Edmond Edmondson E000054 | rep | OK | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
29749 | 29749 | Florence Dwyer D000587 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
29741 | 29741 | John Dowdy D000467 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
29724 | 29724 | Robert Corbett C000772 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 29 | |||||||||||||
29708 | 29708 | William Colmer C000645 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29688 | 29688 | Emanuel Celler C000264 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
29656 | 29656 | John Byrnes B001216 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
29642 | 29642 | James Byrne B001212 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29626 | 29626 | Frank Bow B000676 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
29615 | 29615 | Thomas Boggs B000594 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
29598 | 29598 | Jackson Betts B000426 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
29587 | 29587 | Page Belcher B000323 | rep | OK | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
29573 | 29573 | Walter Baring B000141 | rep | NV | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
29563 | 29563 | Wayne Aspinall A000225 | rep | CO | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29551 | 29551 | George Andrews A000206 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29531 | 29531 | Thomas Abernethy A000016 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29516 | 29516 | Watkins Abbitt A000002 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29492 | 29492 | James Utt U000034 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 28 | |||||||||||||
29461 | 29461 | Byron Rogers R000389 | rep | CO | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29451 | 29451 | Lucius Rivers R000280 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29428 | 29428 | Adam Powell P000477 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 16 | |||||||||||||
29413 | 29413 | Philip Philbin P000303 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29379 | 29379 | John McCormack M000364 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
29338 | 29338 | Glenard Lipscomb L000344 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 24 | |||||||||||||
29323 | 29323 | Melvin Laird L000024 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
29312 | 29312 | Michael Kirwan K000244 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
29283 | 29283 | James Fulbright F000401 | sen | AR | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29273 | 29273 | Samuel Friedel F000384 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
29262 | 29262 | Michael Feighan F000060 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
29248 | 29248 | Leonard Farbstein F000015 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
29241 | 29241 | George Fallon F000012 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29228 | 29228 | Robert Everett E000266 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
29225 | 29225 | Samuel Ervin E000211 | sen | NC | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29211 | 29211 | William Dawson D000158 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29191 | 29191 | Glenn Cunningham C000991 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
29184 | 29184 | William Cramer C000869 | rep | FL | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
29160 | 29160 | Alan Bible B000436 | sen | NV | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29152 | 29152 | Ellis Berry B000416 | rep | SD | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
29146 | 29146 | Wallace Bennett B000384 | sen | UT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
29133 | 29133 | William Bates B000239 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
29122 | 29122 | William Ayres A000229 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 14 | |||||||||||||
29116 | 29116 | George Aiken A000062 | sen | VT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
29106 | 29106 | Edwin Adair A000024 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
29090 | 29090 | Jesse Younger Y000060 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
29082 | 29082 | Edwin Willis W000559 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29072 | 29072 | John Williams W000517 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29061 | 29061 | Basil Whitener W000410 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
29053 | 29053 | William Tuck T000395 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
29033 | 29033 | Armistead Selden S000232 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29018 | 29018 | George Rhodes R000187 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
29001 | 29001 | Barratt O’Hara O000053 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28982 | 28982 | Abraham Multer M001074 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 13 | |||||||||||||
28966 | 28966 | Arch Moore M000892 | rep | WV | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
28950 | 28950 | Cecil King K000196 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 17 | |||||||||||||
28936 | 28936 | Edna Kelly K000070 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
28926 | 28926 | Frank Karsten K000013 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
28907 | 28907 | Elmer Holland H000717 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 30 | |||||||||||||
28899 | 28899 | Albert Herlong H000530 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28882 | 28882 | Porter Hardy H000197 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28871 | 28871 | Charles Halleck H000081 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
28854 | 28854 | Ezekiel Gathings G000098 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
28838 | 28838 | John Fogarty F000233 | rep | RI | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28824 | 28824 | Paul Fino F000137 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 25 | |||||||||||||
28810 | 28810 | Thomas Curtis C001014 | rep | MO | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
28796 | 28796 | Frances Bolton B000607 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
28778 | 28778 | Edward Bartlett B000201 | rep | AK | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
28766 | 28766 | Robert Ashmore A000223 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28743 | 28743 | Ralph Yarborough Y000006 | sen | TX | 1957-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
28722 | 28722 | James Trimble T000373 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28706 | 28706 | Theo Thompson T000218 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
28699 | 28699 | Clark Thompson T000198 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28687 | 28687 | Albert Thomas T000156 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28670 | 28670 | Howard Smith S000554 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28638 | 28638 | Ralph Scott S000184 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28630 | 28630 | James Roosevelt R000426 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 26 | |||||||||||||
28624 | 28624 | Walter Rogers R000404 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
28612 | 28612 | Winston Prouty P000552 | rep | VT | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
28602 | 28602 | Leo O’Brien O000015 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 30 | |||||||||||||
28594 | 28594 | Thomas Murray M001114 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
28581 | 28581 | James Morrison M000995 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28561 | 28561 | Eugene McCarthy M000311 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28552 | 28552 | Donald Matthews M000253 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28545 | 28545 | Joseph Martin M000191 | rep | MA | 1957-01-03 | 1959-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);