legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
39 rows where "end" is on date 1921-03-03 and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16929 | 16929 | Boies Penrose P000217 | sen | PA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
17632 | 17632 | Peter Costello C000796 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
17643 | 17643 | Arthur Dewalt D000288 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
17690 | 17690 | John Farr F000029 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17719 | 17719 | Mahlon Garland G000068 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
17782 | 17782 | Willis Hulings H000939 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 28 | |||||||||||||
17807 | 17807 | John Lesher L000250 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
17832 | 17832 | Patrick McLane M000536 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
17853 | 17853 | Joseph Moore M000906 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17967 | 17967 | Henry Steele S000831 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 26 | |||||||||||||
18015 | 18015 | John Wilson W000600 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
18069 | 18069 | Edward Brooks B000876 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 20 | |||||||||||||
18074 | 18074 | William Burke B001101 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18138 | 18138 | Thomas Crago C000853 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18255 | 18255 | Evan Jones J000217 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 21 | |||||||||||||
18300 | 18300 | Aaron Kreider K000327 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 18 | |||||||||||||
18431 | 18431 | John Reber R000102 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
18453 | 18453 | John Rose R000437 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 19 | |||||||||||||
19147 | 19147 | Anderson Walters W000109 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
19251 | 19251 | Thomas Butler B001192 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
19431 | 19431 | John Morin M000961 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 31 | |||||||||||||
19522 | 19522 | William Vare V000071 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19618 | 19618 | John Casey C000223 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
19746 | 19746 | William Griest G000456 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
19819 | 19819 | Edgar Kiess K000168 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
19928 | 19928 | Stephen Porter P000447 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 29 | |||||||||||||
20160 | 20160 | Guy Campbell C000084 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 32 | |||||||||||||
20437 | 20437 | George Graham G000354 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20592 | 20592 | Samuel Kendall K000097 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 23 | |||||||||||||
20846 | 20846 | Milton Shreve S000387 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 25 | |||||||||||||
20919 | 20919 | Henry Temple T000119 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 24 | |||||||||||||
21246 | 21246 | George Edmonds E000053 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
21352 | 21352 | Melville Kelly K000076 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 30 | |||||||||||||
21411 | 21411 | Louis McFadden M000434 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
21562 | 21562 | Nathan Strong S001015 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 27 | |||||||||||||
21589 | 21589 | Henry Watson W000201 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
21932 | 21932 | Harry Ransley R000061 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
22148 | 22148 | Benjamin Focht F000230 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 17 | |||||||||||||
22551 | 22551 | George Darrow D000063 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 6 |
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);