legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "start" is on date 1951-01-03 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26966 | 26966 | Daniel Reed R000113 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 45 | |||||||||||||
25170 | 25170 | John Butler B001179 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 44 | |||||||||||||
26561 | 26561 | Edmund Radwan R000008 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 43 | |||||||||||||
28013 | 28013 | William Miller M000762 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 42 | |||||||||||||
28076 | 28076 | Harold Ostertag O000121 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 41 | |||||||||||||
26897 | 26897 | Kenneth Keating K000036 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 40 | |||||||||||||
26246 | 26246 | William Cole C000617 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 39 | |||||||||||||
27563 | 27563 | John Taber T000001 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 38 | |||||||||||||
25298 | 25298 | Edwin Hall H000050 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 37 | |||||||||||||
28108 | 28108 | Roy Riehlman R000250 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 36 | |||||||||||||
26671 | 26671 | William Williams W000549 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 35 | |||||||||||||
27956 | 27956 | Clarence Kilburn K000170 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 34 | |||||||||||||
25158 | 25158 | Frank Buchanan B001002 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 33 | |||||||||||||
25885 | 25885 | Vera Buchanan B001009 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 33 | |||||||||||||
27025 | 27025 | Dean Taylor T000070 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 33 | |||||||||||||
25178 | 25178 | William Byrne B001214 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 32 | |||||||||||||
26317 | 26317 | Herman Eberharter E000029 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 32 | |||||||||||||
28599 | 28599 | Leo O’Brien O000015 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 32 | |||||||||||||
26450 | 26450 | Bernard Kearney K000030 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 31 | |||||||||||||
29779 | 29779 | James Fulton F000422 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 31 | |||||||||||||
28256 | 28256 | James Wharton W000323 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 30 | |||||||||||||
29721 | 29721 | Robert Corbett C000772 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 30 | |||||||||||||
25212 | 25212 | Harmar Denny D000249 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 29 | |||||||||||||
28170 | 28170 | Katharine St. George S000764 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 29 | |||||||||||||
25973 | 25973 | Ralph Gamble G000031 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 28 | |||||||||||||
27270 | 27270 | Carroll Kearns K000032 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 28 | |||||||||||||
26348 | 26348 | Ralph Gwinn G000541 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 27 | |||||||||||||
26460 | 26460 | Augustine Kelley K000058 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 27 | |||||||||||||
25379 | 25379 | Christopher McGrath M000455 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 26 | |||||||||||||
25599 | 25599 | Cecil Bishop B000486 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 26 | |||||||||||||
30667 | 30667 | John Saylor S000102 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 26 | |||||||||||||
25688 | 25688 | Louis Graham G000360 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 25 | |||||||||||||
27671 | 27671 | Charles Buckley B001024 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 25 | |||||||||||||
33698 | 33698 | Charles Price P000522 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 25 | |||||||||||||
26647 | 26647 | Charles Vursell V000125 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 24 | |||||||||||||
26817 | 26817 | Isidore Dollinger D000402 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 24 | |||||||||||||
31204 | 31204 | Thomas Morgan M000958 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 24 | |||||||||||||
25334 | 25334 | Edward Jenison J000080 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 23 | |||||||||||||
25383 | 25383 | Clinton McKinnon M000528 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 23 | |||||||||||||
25491 | 25491 | Edward Sittler S000461 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 23 | |||||||||||||
25960 | 25960 | Sidney Fine F000126 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 23 | |||||||||||||
26082 | 26082 | John Phillips P000309 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
27578 | 27578 | James Van Zandt V000069 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
28793 | 28793 | Frances Bolton B000607 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
29425 | 29425 | Adam Powell P000477 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 22 | |||||||||||||
30090 | 30090 | William Springer S000756 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
25371 | 25371 | James Lind L000318 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
25656 | 25656 | Robert Crosser C000932 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
27325 | 27325 | Peter Mack M000020 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
28146 | 28146 | Harry Sheppard S000335 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
30348 | 30348 | Ovie Fisher F000152 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
31068 | 31068 | Jacob Javits J000064 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 21 | |||||||||||||
25797 | 25797 | Franklin Roosevelt R000425 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
26000 | 26000 | John Hinshaw H000640 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 20 | |||||||||||||
26607 | 26607 | Sidney Simpson S000437 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 20 | |||||||||||||
27293 | 27293 | Paul Kilday K000171 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
28241 | 28241 | Francis Walter W000108 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
29259 | 29259 | Michael Feighan F000060 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
26041 | 26041 | Arthur Klein K000261 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
27148 | 27148 | Robert Chiperfield C000365 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 19 | |||||||||||||
27804 | 27804 | Leon Gavin G000102 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 19 | |||||||||||||
29309 | 29309 | Michael Kirwan K000244 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
30485 | 30485 | Chester Holifield H000713 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
31629 | 31629 | George Mahon M000065 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
25941 | 25941 | James Donovan D000421 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
26133 | 26133 | Harold Velde V000082 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 18 | |||||||||||||
27390 | 27390 | Walter Mumma M001077 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 18 | |||||||||||||
27755 | 27755 | Clyde Doyle D000481 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
28621 | 28621 | Walter Rogers R000404 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
30976 | 30976 | Wayne Hays H000408 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
25938 | 25938 | George Dondero D000411 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
26267 | 26267 | Frederic Coudert C000804 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
26510 | 26510 | J. McGregor M000460 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
27009 | 27009 | Richard Simpson S000436 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
28947 | 28947 | Cecil King K000196 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 17 | |||||||||||||
30146 | 30146 | Leslie Arends A000216 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
31455 | 31455 | Omar Burleson B001111 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 17 | |||||||||||||
25403 | 25403 | James Murphy M001094 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 16 | |||||||||||||
25789 | 25789 | Kenneth Regan R000140 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 16 | |||||||||||||
26500 | 26500 | Samuel McConnell M000354 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
26701 | 26701 | Leo Allen A000138 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
26888 | 26888 | Donald Jackson J000008 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
27984 | 27984 | John Lesinski L000252 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 16 | |||||||||||||
29623 | 29623 | Frank Bow B000676 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
25920 | 25920 | John Dingell D000354 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
26770 | 26770 | Alvin Bush B001165 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 15 | |||||||||||||
27350 | 27350 | Noah Mason M000224 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 15 | |||||||||||||
27359 | 27359 | Gordon McDonough M000414 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 15 | |||||||||||||
28649 | 28649 | Robert Secrest S000219 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
29685 | 29685 | Emanuel Celler C000264 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
33816 | 33816 | Lloyd Bentsen B000401 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
25277 | 25277 | Wilson Gillette G000206 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
25704 | 25704 | Edward Hart H000284 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
25756 | 25756 | John Lyle L000525 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
25844 | 25844 | Samuel Yorty Y000024 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
26101 | 26101 | Chauncey Reed R000111 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
26207 | 26207 | Joseph Carrigg C000182 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
27423 | 27423 | Louis Rabaut R000001 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
28542 | 28542 | Joseph Martin M000191 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
28979 | 28979 | Abraham Multer M001074 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 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);