legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
29 rows where "start" is on date 1883-12-03 and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10632 | 10632 | Samuel Barr B000171 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 14 | |||||||||||||
10643 | 10643 | Samuel Brainerd B000761 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 27 | |||||||||||||
10673 | 10673 | Daniel Connolly C000696 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 12 | |||||||||||||
10705 | 10705 | William Duncan D000538 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 19 | |||||||||||||
10708 | 10708 | Mortimer Elliott E000126 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10757 | 10757 | James Hopkins H000775 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 22 | |||||||||||||
10793 | 10793 | George Lawrence L000134 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 24 | |||||||||||||
10832 | 10832 | John Patton P000139 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 25 | |||||||||||||
10846 | 10846 | George Post P000453 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 15 | |||||||||||||
10900 | 10900 | Abraham Smith S000509 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 9 | |||||||||||||
10971 | 10971 | Charles Boyle B000728 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 21 | |||||||||||||
10980 | 10980 | William Brown B000952 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 16 | |||||||||||||
10996 | 10996 | Jacob Campbell C000086 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 17 | |||||||||||||
11015 | 11015 | Andrew Curtin C001004 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 20 | |||||||||||||
11033 | 11033 | Isaac Evans E000244 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
11036 | 11036 | James Everhart E000270 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 6 | |||||||||||||
11212 | 11212 | John Storm S000975 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 11 | |||||||||||||
11221 | 11221 | John Swope S001128 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 19 | |||||||||||||
11595 | 11595 | Thomas Bayne B000261 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 23 | |||||||||||||
11795 | 11795 | William Kelley K000062 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 4 | |||||||||||||
11922 | 11922 | Samuel Randall R000039 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
12070 | 12070 | Louis Atkinson A000331 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 18 | |||||||||||||
12701 | 12701 | William Mutchler M001125 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 10 | |||||||||||||
12723 | 12723 | Charles O’Neill O000093 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
13657 | 13657 | Daniel Ermentrout E000205 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
13690 | 13690 | Alfred Harmer H000215 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 5 | |||||||||||||
14999 | 14999 | Charles Brumm B000977 | rep | PA | 1883-12-03 | 1885-03-03 | National Greenbacker | 13 | |||||||||||||
15856 | 15856 | Henry Bingham B000469 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
16885 | 16885 | Samuel Miller M000753 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 26 |
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);