legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
31 rows where "end" is on date 1965-01-03 and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: start, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27810 | 27810 | Leon Gavin G000102 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 23 | |||||||||||||
27838 | 27838 | William Green G000421 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28022 | 28022 | William Milliken M000770 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
28247 | 28247 | Francis Walter W000108 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
28249 | 28249 | James Weaver W000226 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
28394 | 28394 | Willard Curtin C001005 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
28404 | 28404 | Paul Dague D000004 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
28519 | 28519 | John Kunkel K000341 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
28714 | 28714 | Herman Toll T000297 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28910 | 28910 | Elmer Holland H000717 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 20 | |||||||||||||
29021 | 29021 | George Rhodes R000187 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
29645 | 29645 | James Byrne B001212 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29727 | 29727 | Robert Corbett C000772 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 18 | |||||||||||||
29785 | 29785 | James Fulton F000422 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 27 | |||||||||||||
30079 | 30079 | Hugh Scott S000174 | sen | PA | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
30130 | 30130 | John Whalley W000320 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
30245 | 30245 | Frank Clark C000431 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 25 | |||||||||||||
30379 | 30379 | George Goodling G000290 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 19 | |||||||||||||
30673 | 30673 | John Saylor S000102 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 22 | |||||||||||||
30828 | 30828 | William Barrett B000178 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
30945 | 30945 | William Green G000420 | rep | PA | 1964-04-28 | 1965-01-03 | Democrat | 5 | |||||||||||||
31074 | 31074 | Albert Johnson J000115 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 23 | |||||||||||||
31210 | 31210 | Thomas Morgan M000958 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 26 | |||||||||||||
31311 | 31311 | Herman Schneebeli S000135 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 17 | |||||||||||||
31319 | 31319 | Richard Schweiker S000159 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 13 | |||||||||||||
31530 | 31530 | John Dent D000255 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
31697 | 31697 | Robert Nix N000113 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
31769 | 31769 | Frederick Rooney R000423 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
32067 | 32067 | Daniel Flood F000209 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
32186 | 32186 | William Moorhead M000930 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
36295 | 36295 | Joseph McDade M000399 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 10 |
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);