legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
29 rows where "end" is on date 1887-03-03 and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10469 | 10469 | John Mitchell M000819 | sen | PA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10972 | 10972 | Charles Boyle B000728 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 21 | |||||||||||||
10981 | 10981 | William Brown B000952 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 16 | |||||||||||||
10997 | 10997 | Jacob Campbell C000086 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 17 | |||||||||||||
11016 | 11016 | Andrew Curtin C001004 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 20 | |||||||||||||
11034 | 11034 | Isaac Evans E000244 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 7 | |||||||||||||
11037 | 11037 | James Everhart E000270 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
11040 | 11040 | George Fleeger F000193 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 26 | |||||||||||||
11149 | 11149 | James Negley N000024 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 22 | |||||||||||||
11213 | 11213 | John Storm S000975 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 11 | |||||||||||||
11222 | 11222 | John Swope S001128 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 19 | |||||||||||||
11265 | 11265 | Alexander White W000354 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 25 | |||||||||||||
11300 | 11300 | Franklin Bound B000667 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 14 | |||||||||||||
11309 | 11309 | Frank Bunnell B001064 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 15 | |||||||||||||
11392 | 11392 | John Hiestand H000569 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 9 | |||||||||||||
11415 | 11415 | Oscar Jackson J000024 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 24 | |||||||||||||
11505 | 11505 | William Scott S000188 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 27 | |||||||||||||
11514 | 11514 | William Sowden S000692 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11596 | 11596 | Thomas Bayne B000261 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 23 | |||||||||||||
11796 | 11796 | William Kelley K000062 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
11881 | 11881 | Edwin Osborne O000110 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | -1 | |||||||||||||
11923 | 11923 | Samuel Randall R000039 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
12071 | 12071 | Louis Atkinson A000331 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 18 | |||||||||||||
12724 | 12724 | Charles O’Neill O000093 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
13151 | 13151 | Joseph Scranton S000192 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 12 | |||||||||||||
13658 | 13658 | Daniel Ermentrout E000205 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
13691 | 13691 | Alfred Harmer H000215 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
15000 | 15000 | Charles Brumm B000977 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 13 | |||||||||||||
15857 | 15857 | Henry Bingham B000469 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 1 |
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);