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 district 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26969 | 26969 | Daniel Reed R000113 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 43 | |||||||||||||
28091 | 28091 | John Pillion P000352 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 42 | |||||||||||||
26564 | 26564 | Edmund Radwan R000008 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 41 | |||||||||||||
28016 | 28016 | William Miller M000762 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 40 | |||||||||||||
28079 | 28079 | Harold Ostertag O000121 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 39 | |||||||||||||
26900 | 26900 | Kenneth Keating K000036 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 38 | |||||||||||||
26249 | 26249 | William Cole C000617 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 37 | |||||||||||||
30631 | 30631 | Howard Robison R000357 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 37 | |||||||||||||
27566 | 27566 | John Taber T000001 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 36 | |||||||||||||
28111 | 28111 | Roy Riehlman R000250 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 35 | |||||||||||||
26674 | 26674 | William Williams W000549 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 34 | |||||||||||||
27959 | 27959 | Clarence Kilburn K000170 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 33 | |||||||||||||
26453 | 26453 | Bernard Kearney K000030 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 32 | |||||||||||||
27028 | 27028 | Dean Taylor T000070 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 31 | |||||||||||||
28602 | 28602 | Leo O’Brien O000015 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 30 | |||||||||||||
28907 | 28907 | Elmer Holland H000717 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 30 | |||||||||||||
32400 | 32400 | Robert Wilson W000610 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 30 | |||||||||||||
27509 | 27509 | Dalip Saund S000075 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 29 | |||||||||||||
28259 | 28259 | James Wharton W000323 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 29 | |||||||||||||
29724 | 29724 | Robert Corbett C000772 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 29 | |||||||||||||
26320 | 26320 | Herman Eberharter E000029 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 28 | |||||||||||||
28173 | 28173 | Katharine St. George S000764 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 28 | |||||||||||||
29492 | 29492 | James Utt U000034 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 28 | |||||||||||||
26351 | 26351 | Ralph Gwinn G000541 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 27 | |||||||||||||
28149 | 28149 | Harry Sheppard S000335 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 27 | |||||||||||||
29782 | 29782 | James Fulton F000422 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 27 | |||||||||||||
27178 | 27178 | Edwin Dooley D000425 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 26 | |||||||||||||
28630 | 28630 | James Roosevelt R000426 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 26 | |||||||||||||
31207 | 31207 | Thomas Morgan M000958 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 26 | |||||||||||||
26402 | 26402 | Patrick Hillings H000623 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 25 | |||||||||||||
28824 | 28824 | Paul Fino F000137 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 25 | |||||||||||||
30242 | 30242 | Frank Clark C000431 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 25 | |||||||||||||
33589 | 33589 | Kenneth Gray G000400 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 25 | |||||||||||||
27273 | 27273 | Carroll Kearns K000032 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 24 | |||||||||||||
27674 | 27674 | Charles Buckley B001024 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 24 | |||||||||||||
29338 | 29338 | Glenard Lipscomb L000344 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 24 | |||||||||||||
33701 | 33701 | Charles Price P000522 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 24 | |||||||||||||
26650 | 26650 | Charles Vursell V000125 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 23 | |||||||||||||
26820 | 26820 | Isidore Dollinger D000402 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 23 | |||||||||||||
27758 | 27758 | Clyde Doyle D000481 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 23 | |||||||||||||
27807 | 27807 | Leon Gavin G000102 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 23 | |||||||||||||
30585 | 30585 | William Minshall M000799 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 23 | |||||||||||||
26884 | 26884 | Joseph Holt H000746 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
27859 | 27859 | James Healey H000424 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 22 | |||||||||||||
28796 | 28796 | Frances Bolton B000607 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
30093 | 30093 | William Springer S000756 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
30670 | 30670 | John Saylor S000102 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
26463 | 26463 | Augustine Kelley K000058 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
27228 | 27228 | Edgar Hiestand H000568 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 21 | |||||||||||||
27328 | 27328 | Peter Mack M000020 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
27591 | 27591 | Herbert Zelenko Z000003 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
30351 | 30351 | Ovie Fisher F000152 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
31527 | 31527 | John Dent D000255 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
32377 | 32377 | Charles Vanik V000047 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
26610 | 26610 | Sidney Simpson S000437 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
27030 | 27030 | Ludwig Teller T000118 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
27296 | 27296 | Paul Kilday K000171 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
27581 | 27581 | James Van Zandt V000069 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
29262 | 29262 | Michael Feighan F000060 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
30082 | 30082 | H. Smith S000545 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
26621 | 26621 | Simon Stauffer S000819 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 19 | |||||||||||||
27151 | 27151 | Robert Chiperfield C000365 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 19 | |||||||||||||
29248 | 29248 | Leonard Farbstein F000015 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
29312 | 29312 | Michael Kirwan K000244 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
30488 | 30488 | Chester Holifield H000713 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
31632 | 31632 | George Mahon M000065 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
27012 | 27012 | Richard Simpson S000436 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 18 | |||||||||||||
27506 | 27506 | Alfred Santangelo S000057 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
28624 | 28624 | Walter Rogers R000404 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
30499 | 30499 | Craig Hosmer H000802 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 18 | |||||||||||||
30979 | 30979 | Wayne Hays H000408 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
34265 | 34265 | William Broomfield B000890 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 18 | |||||||||||||
35428 | 35428 | Robert Michel M000692 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 18 | |||||||||||||
26270 | 26270 | Frederic Coudert C000804 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26513 | 26513 | J. McGregor M000460 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26773 | 26773 | Alvin Bush B001165 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
28950 | 28950 | Cecil King K000196 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 17 | |||||||||||||
30149 | 30149 | Leslie Arends A000216 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
30405 | 30405 | Martha Griffiths G000471 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 17 | |||||||||||||
31458 | 31458 | Omar Burleson B001111 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 17 | |||||||||||||
26704 | 26704 | Leo Allen A000138 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
26891 | 26891 | Donald Jackson J000008 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
27393 | 27393 | Walter Mumma M001077 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
27499 | 27499 | J. Rutherford R000547 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 16 | |||||||||||||
27987 | 27987 | John Lesinski L000252 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 16 | |||||||||||||
29428 | 29428 | Adam Powell P000477 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 16 | |||||||||||||
29626 | 29626 | Frank Bow B000676 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
26865 | 26865 | John Henderson H000484 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
27353 | 27353 | Noah Mason M000224 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
27362 | 27362 | Gordon McDonough M000414 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
27431 | 27431 | John Ray R000077 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
27964 | 27964 | Joe Kilgore K000177 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 15 | |||||||||||||
28244 | 28244 | Francis Walter W000108 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 15 | |||||||||||||
39800 | 39800 | John Dingell D000355 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 15 | |||||||||||||
26287 | 26287 | Vincent Dellay D000219 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
26454 | 26454 | Russell Keeney K000042 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 14 | |||||||||||||
27426 | 27426 | Louis Rabaut R000001 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
28441 | 28441 | Harlan Hagen H000013 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
28545 | 28545 | Joseph Martin M000191 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 14 | |||||||||||||
29018 | 29018 | George Rhodes R000187 | rep | PA | 1957-01-03 | 1959-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);