legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
33 rows where "end" is on date 1903-03-03 and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13862 | 13862 | Alexander Billmeyer B000465 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
13893 | 13893 | Marriott Brosius B000892 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
13971 | 13971 | Henry Green G000411 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
13982 | 13982 | Galusha Grow G000507 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
13984 | 13984 | James Hall H000054 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 28 | |||||||||||||
14021 | 14021 | Summers Jack J000001 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 21 | |||||||||||||
14050 | 14050 | Robert Lewis L000292 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 19 | |||||||||||||
14108 | 14108 | Howard Mutchler M001124 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
14124 | 14124 | Rufus Polk P000410 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
14169 | 14169 | Joseph Showalter S000385 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 25 | |||||||||||||
14223 | 14223 | James Young Y000041 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 4 | |||||||||||||
14258 | 14258 | Henry Burk B001085 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14270 | 14270 | William Connell C000687 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14304 | 14304 | Alvin Evans E000232 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 20 | |||||||||||||
14309 | 14309 | Robert Foerderer F000232 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
14537 | 14537 | Charles Wright W000756 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 15 | |||||||||||||
14552 | 14552 | Robert Adams A000044 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14638 | 14638 | Elias Deemer D000186 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 16 | |||||||||||||
14797 | 14797 | Thaddeus Mahon M000066 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 18 | |||||||||||||
14842 | 14842 | Edward Morrell M000965 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
14854 | 14854 | George Patterson P000115 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 13 | |||||||||||||
14893 | 14893 | Joseph Sibley S000398 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 27 | |||||||||||||
14965 | 14965 | Ernest Acheson A000019 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 24 | |||||||||||||
15022 | 15022 | Henry Cassel C000235 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
15502 | 15502 | William Graham G000363 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 23 | |||||||||||||
15680 | 15680 | Henry Palmer P000040 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 12 | |||||||||||||
15806 | 15806 | Irving Wanger W000122 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
15848 | 15848 | Arthur Bates B000230 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 26 | |||||||||||||
15865 | 15865 | Henry Bingham B000469 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15924 | 15924 | John Dalzell D000016 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 22 | |||||||||||||
16138 | 16138 | Marlin Olmsted O000079 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 14 | |||||||||||||
16926 | 16926 | Boies Penrose P000217 | sen | PA | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
19242 | 19242 | Thomas Butler B001192 | rep | PA | 1901-12-02 | 1903-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);