legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
36 rows where "end" is on date 1939-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22105 | 22105 | Charles Crosby C000928 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 29 | |||||||||||||
22106 | 22106 | Peter De Muth D000225 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 30 | |||||||||||||
22115 | 22115 | Frank Dorsey D000438 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22116 | 22116 | Ira Drew D000494 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22127 | 22127 | Charles Eckert E000032 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 26 | |||||||||||||
22133 | 22133 | Henry Ellenbogen E000111 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 33 | |||||||||||||
22152 | 22152 | Benjamin Focht F000230 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 18 | |||||||||||||
22155 | 22155 | Oliver Frey F000382 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22179 | 22179 | James Gildea G000182 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
22181 | 22181 | Don Gingery G000224 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
22193 | 22193 | Joseph Gray G000399 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 27 | |||||||||||||
22375 | 22375 | James Quinn Q000017 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 31 | |||||||||||||
22429 | 22429 | Michael Stack S000773 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22433 | 22433 | Guy Swope S001127 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
22472 | 22472 | Robert Allen A000145 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 28 | |||||||||||||
22546 | 22546 | John Daly D000014 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22562 | 22562 | James Davis D000111 | sen | PA | 1933-03-09 | 1939-01-03 | 3 | Republican | |||||||||||||
22585 | 22585 | Matthew Dunn D000551 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 34 | |||||||||||||
22883 | 22883 | Patrick Boland B000601 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22987 | 22987 | Charles Faddis F000001 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 25 | |||||||||||||
22995 | 22995 | John Flannery F000192 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
23022 | 23022 | Harry Haines H000026 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
23058 | 23058 | Benjamin Jarrett J000060 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 20 | |||||||||||||
23147 | 23147 | Guy Moser M001026 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23207 | 23207 | Albert Rutherford R000546 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 15 | |||||||||||||
23210 | 23210 | Leon Sacks S000008 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23427 | 23427 | John Ditter D000363 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
23594 | 23594 | James McGranery M000454 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23782 | 23782 | Michael Bradley B000743 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23934 | 23934 | John Kinzer K000231 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
24100 | 24100 | John Snyder S000668 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 24 | |||||||||||||
24212 | 24212 | James Wolfenden W000678 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
25005 | 25005 | Robert Rich R000209 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 16 | |||||||||||||
26310 | 26310 | Herman Eberharter E000029 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 32 | |||||||||||||
27002 | 27002 | Richard Simpson S000436 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 18 | |||||||||||||
28234 | 28234 | Francis Walter W000108 | rep | PA | 1937-01-05 | 1939-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);