legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
35 rows where "end" is on date 1843-03-03 and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4694 | 4694 | Henry Beeson B000313 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 20 | |||||||||||||
4697 | 4697 | Henry Black B000498 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 18 | |||||||||||||
4762 | 4762 | Davis Dimock D000352 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 17 | |||||||||||||
4770 | 4770 | John Edwards E000074 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4791 | 4791 | Joseph Fornance F000276 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
4804 | 4804 | James Gerry G000140 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 11 | |||||||||||||
4812 | 4812 | Amos Gustine G000533 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 13 | |||||||||||||
4832 | 4832 | Thomas Henry H000518 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 24 | |||||||||||||
4834 | 4834 | Enos Hook H000756 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 20 | |||||||||||||
4839 | 4839 | William Irwin I000044 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 22 | |||||||||||||
4840 | 4840 | William Jack J000002 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 23 | |||||||||||||
4842 | 4842 | Francis James J000049 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4850 | 4850 | George Keim K000050 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 9 | |||||||||||||
4857 | 4857 | Joseph Lawrence L000137 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 21 | |||||||||||||
4870 | 4870 | Albert Marchand M000123 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 19 | |||||||||||||
4895 | 4895 | Thomas McKennan M000501 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 21 | |||||||||||||
4921 | 4921 | Peter Newhard N000068 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 8 | |||||||||||||
4926 | 4926 | Charles Ogle O000047 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 18 | |||||||||||||
4939 | 4939 | Arnold Plumer P000391 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 25 | |||||||||||||
4948 | 4948 | Robert Ramsey R000028 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
4980 | 4980 | James Russell R000527 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 18 | |||||||||||||
4996 | 4996 | John Sergeant S000246 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5003 | 5003 | William Simonton S000427 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
5010 | 5010 | John Snyder S000667 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 16 | |||||||||||||
5035 | 5035 | George Toland T000296 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5059 | 5059 | John Westbrook W000306 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 7 | |||||||||||||
5132 | 5132 | Benjamin Bidlack B000445 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 15 | |||||||||||||
5147 | 5147 | Jeremiah Brown B000925 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
5221 | 5221 | James Irvin I000033 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 14 | |||||||||||||
5271 | 5271 | Almon Read R000090 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 17 | |||||||||||||
5630 | 5630 | Charles Brown B000906 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
5734 | 5734 | Charles Ingersoll I000015 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5739 | 5739 | Joseph Ingersoll I000019 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5947 | 5947 | James Cooper C000753 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
6969 | 6969 | James Buchanan B001005 | sen | PA | 1837-09-04 | 1843-03-03 | 3 | Democrat |
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);