legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
37 rows where "end" is on date 1917-03-03 and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16135 | 16135 | George Oliver O000073 | sen | PA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16680 | 16680 | Warren Bailey B000050 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 19 | |||||||||||||
16686 | 16686 | Andrew Barchfeld B000133 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 32 | |||||||||||||
16687 | 16687 | Cyrus Beales B000269 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 20 | |||||||||||||
16736 | 16736 | William Coleman C000622 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 30 | |||||||||||||
16804 | 16804 | Robert Hopwood H000785 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 23 | |||||||||||||
16834 | 16834 | Abraham Keister K000052 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 22 | |||||||||||||
16846 | 16846 | Daniel Lafean L000014 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
16849 | 16849 | Michael Liebel L000303 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 25 | |||||||||||||
16886 | 16886 | Samuel Miller M000753 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 28 | |||||||||||||
16912 | 16912 | Solomon North N000141 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 27 | |||||||||||||
17259 | 17259 | Robert Heaton H000433 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
17395 | 17395 | Charles Rowland R000480 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 21 | |||||||||||||
17405 | 17405 | John Scott S000180 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
17630 | 17630 | Peter Costello C000796 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17641 | 17641 | Arthur Dewalt D000288 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17688 | 17688 | John Farr F000029 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17717 | 17717 | Mahlon Garland G000068 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
17805 | 17805 | John Lesher L000250 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
17851 | 17851 | Joseph Moore M000906 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
17965 | 17965 | Henry Steele S000831 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 26 | |||||||||||||
18136 | 18136 | Thomas Crago C000853 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
18298 | 18298 | Aaron Kreider K000327 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 18 | |||||||||||||
19249 | 19249 | Thomas Butler B001192 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
19429 | 19429 | John Morin M000961 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 31 | |||||||||||||
19520 | 19520 | William Vare V000071 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
19617 | 19617 | John Casey C000223 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
19744 | 19744 | William Griest G000456 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
19817 | 19817 | Edgar Kiess K000168 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
19926 | 19926 | Stephen Porter P000447 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 29 | |||||||||||||
20435 | 20435 | George Graham G000354 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20917 | 20917 | Henry Temple T000119 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 24 | |||||||||||||
21244 | 21244 | George Edmonds E000053 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
21409 | 21409 | Louis McFadden M000434 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 14 | |||||||||||||
21587 | 21587 | Henry Watson W000201 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
22146 | 22146 | Benjamin Focht F000230 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 17 | |||||||||||||
22549 | 22549 | George Darrow D000063 | rep | PA | 1915-12-06 | 1917-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);