legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "end" is on date 1951-01-03 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26965 | 26965 | Daniel Reed R000113 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 45 | |||||||||||||
24837 | 24837 | Chester Gorski G000331 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 44 | |||||||||||||
25040 | 25040 | Anthony Tauriello T000056 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 43 | |||||||||||||
24989 | 24989 | William Pfeiffer P000286 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 42 | |||||||||||||
25058 | 25058 | James Wadsworth W000012 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 41 | |||||||||||||
26896 | 26896 | Kenneth Keating K000036 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 40 | |||||||||||||
26245 | 26245 | William Cole C000617 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 39 | |||||||||||||
27562 | 27562 | John Taber T000001 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 38 | |||||||||||||
25297 | 25297 | Edwin Hall H000050 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 37 | |||||||||||||
28107 | 28107 | Roy Riehlman R000250 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 36 | |||||||||||||
24817 | 24817 | John Davies D000089 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 35 | |||||||||||||
27955 | 27955 | Clarence Kilburn K000170 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 34 | |||||||||||||
25157 | 25157 | Frank Buchanan B001002 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 33 | |||||||||||||
27024 | 27024 | Dean Taylor T000070 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 33 | |||||||||||||
25177 | 25177 | William Byrne B001214 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 32 | |||||||||||||
26316 | 26316 | Herman Eberharter E000029 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 32 | |||||||||||||
26449 | 26449 | Bernard Kearney K000030 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 31 | |||||||||||||
29778 | 29778 | James Fulton F000422 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 31 | |||||||||||||
24879 | 24879 | Jay Le Fevre L000161 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 30 | |||||||||||||
29720 | 29720 | Robert Corbett C000772 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 30 | |||||||||||||
24816 | 24816 | Harry Davenport D000071 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 29 | |||||||||||||
28169 | 28169 | Katharine St. George S000764 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 29 | |||||||||||||
25972 | 25972 | Ralph Gamble G000031 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 28 | |||||||||||||
27269 | 27269 | Carroll Kearns K000032 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 28 | |||||||||||||
26347 | 26347 | Ralph Gwinn G000541 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 27 | |||||||||||||
26459 | 26459 | Augustine Kelley K000058 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 27 | |||||||||||||
24811 | 24811 | Robert Coffey C000586 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 26 | |||||||||||||
25378 | 25378 | Christopher McGrath M000455 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 26 | |||||||||||||
25598 | 25598 | Cecil Bishop B000486 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 26 | |||||||||||||
30666 | 30666 | John Saylor S000102 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 26 | |||||||||||||
25687 | 25687 | Louis Graham G000360 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 25 | |||||||||||||
27670 | 27670 | Charles Buckley B001024 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 25 | |||||||||||||
33697 | 33697 | Charles Price P000522 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 25 | |||||||||||||
26646 | 26646 | Charles Vursell V000125 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 24 | |||||||||||||
26816 | 26816 | Isidore Dollinger D000402 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 24 | |||||||||||||
31203 | 31203 | Thomas Morgan M000958 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 24 | |||||||||||||
24790 | 24790 | Anthony Cavalcante C000259 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 23 | |||||||||||||
24908 | 24908 | Walter Lynch L000537 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 23 | |||||||||||||
25333 | 25333 | Edward Jenison J000080 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 23 | |||||||||||||
25382 | 25382 | Clinton McKinnon M000528 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 23 | |||||||||||||
24925 | 24925 | Rolla McMillen M000574 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
26081 | 26081 | John Phillips P000309 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
27577 | 27577 | James Van Zandt V000069 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
28792 | 28792 | Frances Bolton B000607 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
29424 | 29424 | Adam Powell P000477 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 22 | |||||||||||||
25370 | 25370 | James Lind L000318 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
25655 | 25655 | Robert Crosser C000932 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
27324 | 27324 | Peter Mack M000020 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
28145 | 28145 | Harry Sheppard S000335 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
30347 | 30347 | Ovie Fisher F000152 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
31067 | 31067 | Jacob Javits J000064 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 21 | |||||||||||||
24772 | 24772 | Sol Bloom B000565 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
25796 | 25796 | Franklin Roosevelt R000425 | rep | NY | 1949-05-17 | 1951-01-03 | Liberal | 20 | |||||||||||||
25999 | 25999 | John Hinshaw H000640 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 20 | |||||||||||||
26606 | 26606 | Sidney Simpson S000437 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 20 | |||||||||||||
27292 | 27292 | Paul Kilday K000171 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
28240 | 28240 | Francis Walter W000108 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
29258 | 29258 | Michael Feighan F000060 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
26040 | 26040 | Arthur Klein K000261 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
27147 | 27147 | Robert Chiperfield C000365 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 19 | |||||||||||||
27803 | 27803 | Leon Gavin G000102 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 19 | |||||||||||||
29308 | 29308 | Michael Kirwan K000244 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
30484 | 30484 | Chester Holifield H000713 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
31628 | 31628 | George Mahon M000065 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
24843 | 24843 | Ben Guill G000521 | rep | TX | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
24917 | 24917 | Vito Marcantonio M000122 | rep | NY | 1949-01-03 | 1951-01-03 | American Labor | 18 | |||||||||||||
25105 | 25105 | Francis Worley W000744 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
26132 | 26132 | Harold Velde V000082 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
27754 | 27754 | Clyde Doyle D000481 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
28517 | 28517 | John Kunkel K000341 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
30975 | 30975 | Wayne Hays H000408 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
25937 | 25937 | George Dondero D000411 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
26266 | 26266 | Frederic Coudert C000804 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
26509 | 26509 | J. McGregor M000460 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
27008 | 27008 | Richard Simpson S000436 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
28946 | 28946 | Cecil King K000196 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 17 | |||||||||||||
30145 | 30145 | Leslie Arends A000216 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
31454 | 31454 | Omar Burleson B001111 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 17 | |||||||||||||
24897 | 24897 | John Lesinski L000251 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
24930 | 24930 | John McSweeney M000606 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
25402 | 25402 | James Murphy M001094 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
25788 | 25788 | Kenneth Regan R000140 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
26499 | 26499 | Samuel McConnell M000354 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 16 | |||||||||||||
26700 | 26700 | Leo Allen A000138 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 16 | |||||||||||||
26887 | 26887 | Donald Jackson J000008 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 16 | |||||||||||||
25010 | 25010 | Robert Rich R000209 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
25919 | 25919 | John Dingell D000354 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
27349 | 27349 | Noah Mason M000224 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
27358 | 27358 | Gordon McDonough M000414 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
28648 | 28648 | Robert Secrest S000219 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
29684 | 29684 | Emanuel Celler C000264 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
33815 | 33815 | Lloyd Bentsen B000401 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
24820 | 24820 | Helen Douglas D000454 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
24856 | 24856 | Walter Huber H000898 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
25276 | 25276 | Wilson Gillette G000206 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
25703 | 25703 | Edward Hart H000284 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
25755 | 25755 | John Lyle L000525 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
26100 | 26100 | Chauncey Reed R000111 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
27422 | 27422 | Louis Rabaut R000001 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
28541 | 28541 | Joseph Martin M000191 | rep | MA | 1949-01-03 | 1951-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);