legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
35 rows where "start" is on date 1935-01-03 and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21642 | 21642 | William Berlin B000409 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 28 | |||||||||||||
21656 | 21656 | Joshua Brooks B000882 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 30 | |||||||||||||
21738 | 21738 | Charles Dietrich D000340 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21746 | 21746 | Isaac Doutrich D000460 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21747 | 21747 | Denis Driscoll D000501 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
21761 | 21761 | Clare Fenerty F000071 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21899 | 21899 | Theodore Moritz M000962 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 32 | |||||||||||||
21940 | 21940 | Harry Ransley R000061 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
21942 | 21942 | William Richardson R000230 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
21986 | 21986 | Charles Turpin T000433 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 12 | |||||||||||||
22008 | 22008 | William Wilson W000622 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22104 | 22104 | Charles Crosby C000928 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 29 | |||||||||||||
22114 | 22114 | Frank Dorsey D000438 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22126 | 22126 | Charles Eckert E000032 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 26 | |||||||||||||
22132 | 22132 | Henry Ellenbogen E000111 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 33 | |||||||||||||
22151 | 22151 | Benjamin Focht F000230 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 18 | |||||||||||||
22154 | 22154 | Oliver Frey F000382 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22178 | 22178 | James Gildea G000182 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22180 | 22180 | Don Gingery G000224 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
22192 | 22192 | Joseph Gray G000399 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 27 | |||||||||||||
22374 | 22374 | James Quinn Q000017 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 31 | |||||||||||||
22428 | 22428 | Michael Stack S000773 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22545 | 22545 | John Daly D000014 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22559 | 22559 | George Darrow D000063 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
22584 | 22584 | Matthew Dunn D000551 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 34 | |||||||||||||
22882 | 22882 | Patrick Boland B000601 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
22986 | 22986 | Charles Faddis F000001 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 25 | |||||||||||||
23017 | 23017 | Joseph Guffey G000519 | sen | PA | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23021 | 23021 | Harry Haines H000026 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
23426 | 23426 | John Ditter D000363 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
23933 | 23933 | John Kinzer K000231 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
24099 | 24099 | John Snyder S000668 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 24 | |||||||||||||
24211 | 24211 | James Wolfenden W000678 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
25004 | 25004 | Robert Rich R000209 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 16 | |||||||||||||
28233 | 28233 | Francis Walter W000108 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 21 |
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);