legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,015 rows where party = "Democrat" and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: class, fax, rss_url, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3753 | 3753 | Samuel McKean M000492 | sen | PA | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4148 | 4148 | Andrew Buchanan B001000 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 20 | |||||||||||||
4203 | 4203 | Jacob Fry F000396 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4226 | 4226 | Francis Harper H000220 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4243 | 4243 | Edward Hubley H000899 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 8 | |||||||||||||
4253 | 4253 | John Klingensmith K000269 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4260 | 4260 | Henry Logan L000402 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 11 | |||||||||||||
4301 | 4301 | Henry Muhlenberg M001065 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 9 | |||||||||||||
4331 | 4331 | Luther Reily R000158 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 10 | |||||||||||||
4342 | 4342 | Daniel Sheffer S000316 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 12 | |||||||||||||
4398 | 4398 | William Beatty B000284 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 23 | |||||||||||||
4399 | 4399 | William Beatty B000284 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4454 | 4454 | John Davis D000116 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4475 | 4475 | John Galbraith G000011 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 25 | |||||||||||||
4497 | 4497 | Robert Hammond H000132 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 16 | |||||||||||||
4498 | 4498 | Robert Hammond H000132 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 16 | |||||||||||||
4536 | 4536 | Isaac Leet L000211 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 21 | |||||||||||||
4543 | 4543 | Charles McClure M000345 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
4544 | 4544 | Charles McClure M000345 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4545 | 4545 | George McCulloch M000389 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
4564 | 4564 | Samuel Morris M000987 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 17 | |||||||||||||
4565 | 4565 | Samuel Morris M000987 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4571 | 4571 | Lemuel Paynter P000155 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4572 | 4572 | Lemuel Paynter P000155 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4575 | 4575 | David Petrikin P000267 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 15 | |||||||||||||
4576 | 4576 | David Petrikin P000267 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 15 | |||||||||||||
4577 | 4577 | William Potter P000469 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 14 | |||||||||||||
4578 | 4578 | William Potter P000469 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
4581 | 4581 | William Ramsey R000030 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4635 | 4635 | David Wagener W000016 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 7 | |||||||||||||
4636 | 4636 | David Wagener W000016 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4694 | 4694 | Henry Beeson B000313 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 20 | |||||||||||||
4762 | 4762 | Davis Dimock D000352 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 17 | |||||||||||||
4790 | 4790 | Joseph Fornance F000276 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4791 | 4791 | Joseph Fornance F000276 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
4803 | 4803 | James Gerry G000140 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 11 | |||||||||||||
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 | |||||||||||||
4833 | 4833 | Enos Hook H000756 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 20 | |||||||||||||
4834 | 4834 | Enos Hook H000756 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 20 | |||||||||||||
4840 | 4840 | William Jack J000002 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 23 | |||||||||||||
4848 | 4848 | George Keim K000050 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 9 | |||||||||||||
4849 | 4849 | George Keim K000050 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
4850 | 4850 | George Keim K000050 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 9 | |||||||||||||
4869 | 4869 | Albert Marchand M000123 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4870 | 4870 | Albert Marchand M000123 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 19 | |||||||||||||
4920 | 4920 | Peter Newhard N000068 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4921 | 4921 | Peter Newhard N000068 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 8 | |||||||||||||
4938 | 4938 | Arnold Plumer P000391 | rep | PA | 1837-09-04 | 1839-03-03 | Democrat | 25 | |||||||||||||
4939 | 4939 | Arnold Plumer P000391 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 25 | |||||||||||||
5010 | 5010 | John Snyder S000667 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 16 | |||||||||||||
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 | |||||||||||||
5133 | 5133 | Benjamin Bidlack B000445 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 11 | |||||||||||||
5203 | 5203 | George Fuller F000409 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 12 | |||||||||||||
5215 | 5215 | Samuel Hays H000406 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 22 | |||||||||||||
5271 | 5271 | Almon Read R000090 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 17 | |||||||||||||
5272 | 5272 | Almon Read R000090 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 12 | |||||||||||||
5299 | 5299 | John Smith S000576 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5321 | 5321 | William Wilkins W000475 | rep | PA | 1829-12-07 | 1831-03-03 | Democrat | -1 | |||||||||||||
5323 | 5323 | William Wilkins W000475 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 21 | |||||||||||||
5362 | 5362 | James Black B000500 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 16 | |||||||||||||
5363 | 5363 | James Black B000500 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 16 | |||||||||||||
5417 | 5417 | Jacob Erdman E000200 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5424 | 5424 | William Garvin G000089 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 22 | |||||||||||||
5468 | 5468 | Owen Leib L000230 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 11 | |||||||||||||
5474 | 5474 | Moses McClean M000325 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 15 | |||||||||||||
5509 | 5509 | John Ritter R000278 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5510 | 5510 | John Ritter R000278 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
5534 | 5534 | Daniel Sturgeon S001046 | sen | PA | 1840-01-01 | 1845-03-03 | 1 | Democrat | |||||||||||||
5535 | 5535 | Daniel Sturgeon S001046 | sen | PA | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5584 | 5584 | Jacob Yost Y000026 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5585 | 5585 | Jacob Yost Y000026 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5630 | 5630 | Charles Brown B000906 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
5631 | 5631 | Charles Brown B000906 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
5734 | 5734 | Charles Ingersoll I000015 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5735 | 5735 | Charles Ingersoll I000015 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5736 | 5736 | Charles Ingersoll I000015 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5737 | 5737 | Charles Ingersoll I000015 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5913 | 5913 | John Brisbin B000841 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 11 | |||||||||||||
5951 | 5951 | Joel Danner D000045 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 15 | |||||||||||||
6049 | 6049 | Job Mann M000106 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 19 | |||||||||||||
6050 | 6050 | Job Mann M000106 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 19 | |||||||||||||
6135 | 6135 | William Strong S001021 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 9 | |||||||||||||
6136 | 6136 | William Strong S001021 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 9 | |||||||||||||
6143 | 6143 | James Thompson T000204 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 23 | |||||||||||||
6144 | 6144 | James Thompson T000204 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 23 | |||||||||||||
6145 | 6145 | James Thompson T000204 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 23 | |||||||||||||
6228 | 6228 | Richard Brodhead B000861 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
6229 | 6229 | Richard Brodhead B000861 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
6230 | 6230 | Richard Brodhead B000861 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
6231 | 6231 | Richard Brodhead B000861 | sen | PA | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
6272 | 6272 | Milo Dimmick D000350 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6273 | 6273 | Milo Dimmick D000350 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 10 | |||||||||||||
6310 | 6310 | Alfred Gilmore G000220 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 24 | |||||||||||||
6311 | 6311 | Alfred Gilmore G000220 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 24 | |||||||||||||
6360 | 6360 | James McLanahan M000534 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 16 | |||||||||||||
6361 | 6361 | James McLanahan M000534 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 16 | |||||||||||||
6373 | 6373 | John Morrison M000997 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
6380 | 6380 | Andrew Parker P000055 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 17 |
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);