legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
17 rows where party = "Ind. Republican-Democrat" and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6756 | 6756 | John Allison A000158 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 23 | |||||||||||||
6778 | 6778 | Samuel Bradshaw B000751 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 7 | |||||||||||||
6819 | 6819 | Henry Fuller F000410 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 12 | |||||||||||||
6854 | 6854 | Jonathan Knight K000285 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 20 | |||||||||||||
6894 | 6894 | John Pearce P000162 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 15 | |||||||||||||
6908 | 6908 | David Robison R000356 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 17 | |||||||||||||
6936 | 6936 | Job Tyson T000454 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 2 | |||||||||||||
7036 | 7036 | John Edie E000049 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 18 | |||||||||||||
7126 | 7126 | John Kunkel K000340 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 10 | |||||||||||||
7190 | 7190 | Samuel Purviance P000576 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 22 | |||||||||||||
7201 | 7201 | David Ritchie R000273 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 21 | |||||||||||||
7205 | 7205 | Anthony Roberts R000304 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 9 | |||||||||||||
7381 | 7381 | John Dick D000303 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 25 | |||||||||||||
7514 | 7514 | William Millward M000782 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
7684 | 7684 | James Campbell C000088 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 11 | |||||||||||||
8562 | 8562 | John Covode C000818 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 19 | |||||||||||||
9397 | 9397 | Lemuel Todd T000293 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 16 |
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);